How To Run A Bank Reconcile
- In order to reconcile a bank account, navigate to ACCOUNTING >> AUDIT >> ACCOUNT RECONCILE.
- Click on the New Reconcile button.
- Input the bank Statement Date, statement Ending Balance and select the Cash Account you are reconciling the statement for. Click on the Create button. The Show All Transactions box is automatically checked. Un-check this Box to show only unreconciled transactions up through the statement date. Checks, Payments and manual credit transactions to this ledger account will appear on the left section of the screen. Prepayments, Deposits and all debit transactions will appear on the right.
-
Check boxes for items listed on the bank statement. As you do, the Checks and Payments, Deposits, Cleared Balance and Difference
values in the upper section of the screen will be populated.
Prepayments will appear in the Deposits section with a customer name in the Payee column. When Prepayments are deposited, those dollars are also listed in the Deposits section with a Deposit ID. That same Deposit ID will also appear in the Checks and Payments section as an offset. If the deposit is listed on the bank statement, all three items should be checked. - At any time, you can click the Update button.
- When finished, change the Status to Closed. A report of all Reconciled and Un-Reconciled items will be displayed.