Skip to content

Matching bank transactions

Bank feeds works by matching transactions from your bank to those recorded in MYOB. Where possible, MYOB will try to automatically match bank transactions to MYOB transactions. You can also create rules that will tell MYOB what to do if a bank transaction matches predefined criteria.

Where no automatic match occurs but there are possible matches, you can manually do the matching.

If no possible matches are found, you can allocate the transaction to one or more MYOB accounts. You can also split a transaction between accounts, or select multiple transactions and allocate them to the same account. See Allocating bank transactions.

Learn more about:

Automatic matching

AddAdd

When you receive a bank feed, MYOB tries to automatically match transactions from your feed with existing MYOB transactions.

A bank transaction and MYOB transaction are matched if they have the same date and amount and the MYOB transaction is the correct type (such as Spend Money).

Example: A payment for Metropolitan Electricity of $400 comes out of your bank account on November 16. When this payment appears in your bank feed, it is automatically matched to a Spend Money transaction recorded for $400 recorded on November 16.

Of course, if there are two identical transactions, a match won’t happen — you're able to review the possible matches and select the right one:

Want to turn off automatic matching?

Go to Banking > Bank rules and deselect the option Automatically match bank transactions to MYOB bills and invoices.

 If you're accessing an AccountRight company file in a browser, you can also deselect an additional option, Automatically allocate bank transactions using bank feed rules, if you don't want your rules to automatically allocate bank transactions to accounts. Selecting or deselecting this preference changes the preference setting in your AccountRight software too.



Rule matching

AddAdd

You can set up rules to automatically prepare matching transactions in MYOB. The more rules you set up, the more matching is automated and the fewer transactions you have to find or create.

Rules work by searching for bank transactions based on the search criteria you set.

You can set up invoice and bill rules to record invoice and bill payments, and transaction rules for all other receipts and expenses. Transactions that have been automatically allocated based on a rule are identified with a magic wand icon.

Bank transactions page with wand icons highlighted

You can also set up rules without any search criteria (called allocation templates) that you can apply to any transaction.

Transaction on the bank transactions page with allocation template field highlighted

If you want, you can turn off automatic rule matching. See Managing rules.



Manual matching

AddAdd

If there isn’t an automatic match, (for example because of a rounding difference in the amounts), or you'd like to match one bank feed transaction to multiple MYOB transactions, click Possible match found to view the possible matches. To help find matching transactions, use the ShowContact and Search fields. Select one or more transactions to match the bank feed transaction to then click Save:

Matching a grouped payment to multiple invoices

If you're matching to multiple transactions, the Out of balance must be $0.00.

If there's a rounding difference in the amounts, you can click Add adjustment and record a transaction to bring the Out of balance to $0.00.



Un-matching a transaction

AddAdd

If a transaction has been wrongly auto-matched or if you've accidentally matched it to the wrong transaction, you can unmatch it.

On the Bank transactions page, click the down arrow  to open the matched transaction and click Unmatch, then click Unmatch again to confirm. You can now correctly match the transaction. If you want, you can delete the original allocation transaction. The easiest way to do this is to right-click the transaction and open it on a new tab, then click Delete. Learn more about deleting transactions.

You can un-match multiple transactions. Select each transaction and click Un-allocate:

Un-allocate transactions



Showing and hiding transactions

AddAdd

Use the filters across the top of the Bank transactions page to show only the transactions you need, such as Unallocated ones or those for a particular period:

Bank transactions filters

If you use AccountRight in a browser, you have an additional option to show hidden bank transactions – choose Hidden in the Status menu:

Show hidden transactions


The ability to hide and unhide a transaction in the browser is coming soon. Until then, you can hide and unhide transactions in your AccountRight desktop software by clicking Hide Transaction or Unhide button in the Bank Feeds page. Learn more...



  FAQs


How do I match my payroll transactions?

AddAdd

How you match your payroll transactions depends on how you pay your employees.

If you pay employees...

Here are the details

electronically (using a bank file or direct payment from MYOB)

To match these payroll transactions, you'll need a bank feed set up on the business bank account your electronic payments are paid from. Employees paid this way will need their Payment method set to Electronic.

When you process the electronic payment in MYOB:

choose the business bank account your electronic payments are paid from

a single electronic payment transaction is created in MYOB (containing all the pays of the employees being paid electronically)

the funds will be withdrawn from your bank account as a single transaction, and

these transactions will match in your bank feeds.

using cash

To match these payroll transactions, you'll need a bank feed set up on the business bank account your cash wage payments are paid from. Employees paid this way will need their Payment method set to Cash.

When you process a pay run that includes employees with a payment method of Cash:

the employees' pay amounts are posted to your linked account for cash payments (what are linked accounts?)

you'll withdraw a single amount from your bank account for cash wage payments

these transactions will match in your bank feed

via EFT (by manually transferring funds using internet banking)

This requires a bit of work on your behalf, and relies on you entering the correct bank details and amounts into your online banking. We suggest using electronic payments in MYOB to speed things up, reduce the possibility of errors, and to simplify bank feed matching.

To match these payroll transactions, you'll need a bank feed set up on the business bank account the EFT wage payments are paid from. Employees paid this way will need their Payment method set to Cash.

When you process a pay run that includes employees with a payment method of Cash:

the employees' pay amounts are posted to your linked account for cash payments (what are linked accounts?)

you'll manually process the EFT payments into your employee's bank accounts using your online banking

these transactions will match in your bank feed

using cheques

To match these payroll transactions, you'll need a bank feed set up on the business bank account your cheque wage payments are paid from. Employees paid this way will need their Payment method set to Cheque.

When you process a pay run that includes employees with a payment method of Cheque:

the employees' pay cheque amounts are posted to your linked account for cheque payments (what are linked accounts?)

when an employee deposits their pay cheque into their bank account (and the cheque clears), the cheque amount will be withdrawn from your cheque account

these transactions will match in your bank feed



Can I delete bank feed transactions?

AddAdd

We recommend contacting product support to discuss your options.

Why am I getting the error "You have indicated that the transaction is to be paid electronically. All electronic payments must contain Statement Text"?

AddAdd

This error means the linked account for electronic payments is not set to your electronic clearing account.

To check your linked accounts

  1. Go to the Accounting menu > Manage linked accounts.

  2. Make sure the Bank account for electronic payments is set to your Electronic clearing account. If you're not sure about which account to choose, speak to your accounting advisor.

  3. Click Save.