Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5

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

Also find out about undoing a bank reconciliation.

See reconciliation in action

HTML
<iframe width="560" height="315" src="https://fast.wistia.com/embed/medias/xhojxcsruw" frameborder="0" allowfullscreen></iframe>

Take a closer look at how to reconcile an account:

UI Expand
titleTo reconcile an account that has a bank feed

To reconcile an account that has a bank feed

Follow this procedure for banking accounts that you receive 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 allocated or entered into MYOB. For information, see Working with bank transactions.
  2. Click Reconcile. The Reconcile account page appears.
    The 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.

    UI Text Box
    sizemedium
    typetip

    If want to save what you're doing and complete reconciliation later, click Save progress (at the top right). Any transaction selections you've made in Reconcile accounts are saved when you go to other pages.

  5. Click Reconcile to finish (at the bottom of the page). If your account is out of balance, see Reconciliation problems.
UI Expand
titleTo manually reconcile an account

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.

    UI Text Box
    sizemedium
    typetip

    If want to save what you're doing and complete reconciliation later, click Save progress (at the top right). Any transaction selections you've made in Reconcile accounts are saved when you go to other pages.

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

Can't balance your reconciliation? See Fixing out of balance bank reconciliations.

HTML
<h2><i class="fa fa-comments"></i>&nbsp;&nbsp;FAQs</h2><br>
UI Expand
titleHow do I reconcile a cash-on-hand account?

How do I reconcile a cash-on-hand account?

Reconciling is done to ensure the bank account balances in MYOB match your bank’s records. If your cash-on-hand account isn't associated with an actual bank account, you won't have a bank statement to reconcile to.

If your cash-on-hand account is a petty cash account, you might want to manually reconcile the MYOB transactions against the petty cash receipts.

UI Expand
titleHow do I print the reconciliation report?

How do I print the reconciliation report?

Run the Banking reconciliation report (Reporting menu > Reports > Banking reconciliation). You can then export the report as an Excel spreadsheet or PDF by clicking Export. For all the details see Banking reports.

UI Expand
titleCan I save a bank reconciliation and complete it later?

Can I save a bank reconciliation and complete it later?

Yes. Just click Save progress. Any transaction selections on the Reconcile accounts page are retained. So if you go to other parts of your MYOB software and return to Reconcile accounts, your selections will still be there.

HTML
</span>
HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Undoing a bank reconciliation

Fixing out of balance bank reconciliations

Banking reports

HTML Wrap
classacademyBanner

Take the free online course about reconciling