Reconciling your bank accounts

Even if you use bank feeds to easily bring your bank account and credit card information into MYOB, you still need to reconcile those accounts. Reconciling ensures that the bank account balances in MYOB match your bank’s records.

Also find out about undoing a bank reconciliation and fixing out of balance bank reconciliations.

Here's a quick reconciliation overview:

To reconcile a bank account that you've connected to MYOB

Follow this procedure for bank accounts that you've connected to MYOB that you're receiving bank feeds for.

1. On the Bank transactions page (Banking menu > Bank transactions), check that you have received all bank feed transactions for the period you want to reconcile, and they have been matched or categorised or entered into MYOB. For information, see Working with bank transactions.

2. Click Reconcile account. The Reconcile account page appears.
   The Bank account, Statement date, Closing bank statement balance and Calculated closing balance are filled in for you, based on the most recent information received in your bank feed.

3. If your bank didn’t provide statement balance information, you will need to enter the balance and date you want to reconcile:

   • In the Closing bank statement balance field, type the closing balance that appears on the statement your bank sent you. If you're reconciling as at the end of the week or month, and your statement has transactions dated after that date, type the closing balance for the last day of the period you’re reconciling.

   • In the Statement date field, enter the closing date that appears on your bank statement and then press Tab. Only unreconciled transactions dated on or before that date will appear. If you are reconciling as at the end of a week or month, and your statement has transactions dated later, type the last day of the period you’re reconciling.

4. Review the list of transactions. If there are uncleared transactions, mark them as cleared (select them) if they have appeared on your bank statement. This might be the case if, for example, you are performing a monthly reconciliation but you applied for bank feeds part way through the month.
   The Calculated closing balance will update to show the expected closing balance of the statement, based on the transactions you've selected as cleared.

   If want to save what you're doing and complete reconciliation later, click Save progress (at the top right).

5. Click Reconcile to finish (at the bottom of the page). If your bank account is out of balance, see Reconciliation problems.

6. When prompted, click Export report to export a copy of the Bank reconciliation report for your records.

To manually reconcile an account

Follow this procedure for banking accounts that you manually enter transactions into, that is, accounts that don’t have bank feeds, and accounts you don’t import bank statements for.

1. Go to the Banking menu and choose Reconcile accounts. The Reconcile account page appears.

2. In the Account field, enter the account you want to reconcile. The Last reconciled date for this account is shown.

3. For the Statement date, choose the closing date that appears on your bank statement. Only unreconciled transactions dated on or before that date will appear. If you're reconciling as at the end of a week or month, and your statement has transactions dated later, choose the last day of the period you’re reconciling.

4. In the Closing bank statement balance ($) field, type the closing balance that appears on the statement your bank sent you. If you're reconciling as at the end of the week or month, and your statement has transactions dated after that date, type the closing balance for the last day of the period you’re reconciling.

5. For each entry on your bank statement, select the corresponding transaction on the Reconcile accounts page. The Calculated closing balance will update to show the expected closing balance of the statement, based on the transactions marked as cleared in the list.

6. If a transaction on your bank statement hasn't yet been recorded in MYOB, record it now then come back and complete the reconciliation.

   If want to save what you're doing and complete reconciliation later, click Save progress (at the top right).

7. When the Calculated closing balance equals the Closing bank statement balance and there is no Out of balance shown, click Reconcile.

8. When prompted, click Export report to export a copy if the Bank reconciliation report for your records.

FAQs

How do I print the reconciliation report?

You're prompted to export a copy of the Bank reconciliation report each time you reconcile.

Or you can run the report via the Reporting menu > Reports > Banking reconciliation. For all the details see Banking reports.