Skip to content

Matching a bank feed to multiple transactions

Bank feeds contain your bank account transactions. This means individual deposits and withdrawals come through in the bank feed as individual transactions. But sometimes a bank transaction relates to multiple customer, supplier and employee payments in AccountRight.

To speed things up and make auto-matching bank feeds a breeze, you can use AccountRight's handy payment grouping features to match grouped transactions in your bank feed:

  • The electronic payments feature lets you group supplier or employee payments into a single transaction.

  • The bank deposit feature lets you group customer payments.

Let's take you through these processes.

 

To group multiple supplier payments

AddAdd

Supplier payments made through Pay bills or Spend money can be grouped into a single transaction using the Electronic payments feature. You'll first need to set up electronic payments, but this only takes a minute.

Even if you don't process the electronic payment file, this method can still be used to create a single AccountRight transaction to simplify bank feed matching.

  1. When recording a supplier payment select the Electronic Payments option.

    spend money with electronic payments option selected

  2. When you're ready, prepare an electronic payment file containing your supplier payments (go to the Banking command centre and click Prepare Electronic Payments).

    Prepare electronic payments window

  3. Select the payments to be grouped, and then click Bank File (Australia) or Process (New Zealand). This creates an electronic payment transaction which is the total of the selected supplier payments.

  4. Save the electronic payment file. This is the file you can send to your bank for processing the electronic payment.

  5. In the bank feed, AccountRight will auto-match the bank withdrawal to the grouped electronic payment transaction.

To group multiple customer payments

AddAdd

Customer payments made through Receiving payments or Receive money can be grouped into a single transaction using the Prepare Bank Deposit feature. Here's how:

  1. When recording a customer payment select the Undeposited Funds option. Learn more about undeposited funds.

    Receive money with undeposited funds option selected

  2. When you're ready, prepare a bank deposit containing your customer payments (go to the Banking command centre and click Prepare Bank Deposit).

    Prepare bank deposit window
  3. Select the payments to be grouped then click Record. This creates a deposit transaction which is the total of the selected customer payments.

  4. Click Print (if you want to print a bank deposit slip), or click Record to just record the bank deposit transaction.

If you don't use the electronic payment or bank deposit features, and a bank feed transaction relates to multiple AccountRight transactions, you'll need to hide the bank feed transaction then manually reconcile the AccountRight transactions.

 

To hide the bank feed transaction and manually reconcile

AddAdd
  1. Right-click the bank feed transaction and choose Hide Transaction.

    Hide transaction
  2. Go to the Banking command centre and choose Reconcile Accounts.

  3. Select the bank feed Account and select the Bank Statement Date.

  4. Mark the transactions associated with the single (now hidden) bank feed transaction.

  5. Close the Reconcile Accounts window.

Learn more about reconciling accounts