Reconcile a Bank Statement

When you receive a statement from your bank, use the Bank Statement Reconciliation form to reconcile the statement.

To reconcile a bank statement, complete the following steps:

  1. From the Vision Navigation menu, click Accounting > Bank Reconciliation.
  2. In the Bank field on the Bank Statement Selection dialog box, click the drop-down arrow and select the bank.
  3. Complete one of the following actions:
    Option Description
    If you are starting the reconciliation process for the statement Select New in Statement Status, click in New Statement Date, and select the statement date.
    If you want to continue a reconciliation process begun previously, for which the statement date has already been entered and saved Select In Progress in Statement Status and select the statement date in In Progress/Closed Statement Date.
  4. Click Select.
  5. To clear receipts deposited to your account, click the Receipts tab and select Cleared for each of the receipts.
    Option Description
    If you want to mark individual transactions as cleared Select Cleared in the grid for each transaction.
    If you want to mark multiple transactions as cleared Press the SHIFT key while you drag the mouse pointer over a group of transactions or press the CTRL key while you click each transaction, and then click Clear on the grid toolbar.
  6. To clear payments that have cleared the bank, click the Payments tab and select Cleared for each of the payments.
    Option Description
    If you want to mark individual transactions as cleared Select Cleared in the grid for each transaction.
    If you want to mark multiple transactions as cleared Press the SHIFT key while you drag the mouse pointer over a group of transactions or press the CTRL key while you click each transaction, and then click Clear on the grid toolbar.
  7. If the statement contains miscellaneous bank transactions such as interest or service charges, click the Miscellaneous tab and enter those transactions. If a miscellaneous bank transaction should be reflected in the general ledger, you also need to enter a corresponding transaction for it in the Transaction Center. Bank transactions entered on the Miscellaneous tab of Bank Statement Reconciliation only affect the reconciliation.
  8. After you mark all receipts and payments on the statement as cleared and you enter any miscellaneous transactions, click the Summary tab and use its contents to verify that the calculated closing balance ties out to the closing balance on the statement.
  9. If you want to mark the statement as closed so the statement date will no longer display on the list of in-progress statement dates, click the Main tab and select the Closed check box.
  10. To save the final reconciliation, click Save. You can also save periodically as you work on the reconciliation.