How to set up bank reconciliation
Description
Cause
Resolution

Before you Begin

  • For the initial setup, you can only reconcile the account in the current fiscal year
  • If you must reconcile outside of the current fiscal year:
    • Do a manual bank reconciliation until the end of the previous fiscal year
    • Continue with the bank reconciliation setup

Enable the Bank reconciliation


  • In the Home window:
    • In Enhanced View: Select Company, then double-click Chart of Accounts
    • In Classic View: double-click on Chart of Accounts
  • Double-click on your bank account.
  • Select the Reconciliation & Deposits tab.
  • Place a mark in Save Transactions for Account Reconciliation.
  • Click the Set Up button at the bottom of the page.
  • Set up revenue accounts for the following:
    • Interest income
    • Exchange gain
    • Error - Gain
    • Adjustments
  • You can also set up expense accounts for:
    • Bank Charges
    • NSF Fee
    • Interest Expense
  • You can rename the Interest Expenses to agree with the bank statement.
  • Click OK.

To set up Bank Reconciliation

  1. In the Home window:
    • In Enhanced View, go to the Banking tab and click Reconcile Accounts
    • In Classic View, double-click on Reconciliation & Deposits
  2. Choose the bank account you’re reconciling.
  3. Enter the following from the report provided by your financial institution:
    • Statement Start Date
    • Statement End Date
    • Reconciliation Date
    • Statement Opening Balance
    • Statement End Balances
  4. Select the Add Prior Outstanding button.
  5. If you receive a prompt to save changes, select YES when prompted to save changes.
  6. Click OK.
  7. Set the Show Resolved Trans. On or After: date to the oldest outstanding transaction.
  8. From the list of Resolved Transactions:
    • Select outstanding transactions dated before the statement beginning date
    • Click Add to move to the Outstanding Transactions list
  9. Select Insert Outstanding to add transactions that don’t appear in the list.
  10. When finished, click OK.
  11. Check if the discrepancy is zero before clearing transactions. If not zero:
    • You missed adding outstanding transactions
    • Added a wrong outstanding transaction on ‘Add prior outstanding window’
    • The opening balance amount on bank reconciliation is incorrect
  12. If there’s no discrepancy, click Process to post the bank reconciliation.
  13. Print the Account Reconciliation reports.


[BCB:159:Chat 50 CA English:ECB]






Steps to duplicate
Related Solutions

My bank reconciliation has a discrepancy and / or an unresolved amount

How do I reset the bank reconciliation?