Bank Statement Reconciliation

The Reconciliation form again verifies the asset, month, and year you are working with, and displays all deposits for the current month, and any from a prior month that haven't been shown as having cleared the bank.

Similarly, it shows all the checks written in the current month, as well as any from a prior month that haven' been marked as cleared.

You use the bank statement to see what deposits are shown as deposited on the statement, and click on the check box next to the deposit date. Remember that the date you show for the deposit should be (normally) the Sunday service date, while the bank will show the date of physical receipt and crediting by the bank. You may also have some EFT deposits to verify.

You use the statement the same way to check off the checks, Debit Memoranda, and EFT transfers that cleared in the statement.

As you check off each of the deposits and checks, the "Outstanding" totals for each are re-calculated, and the reconciliation math is performed in the text boxes at the bottom of the form. It is expected that, if the check marks are applied accurately, the "Difference" box will show "$0.00" at the completion of checking.

Note Well: Once you move on from one month to the next, re-doing the reconciliation will become difficult, because any checks not cleared this month, but subsequently cleared, say next month, will still show on the re-run of this month's reconciliation, but the "outstanding" totals will be thrown off by the subsequent clearing. It might become necessary for you to remove all the checks marks for subsequent months and then resume reconciling each of the months.