Check Reconciliation Worksheet

$ _____________

1

Ending bank balance (from bank statement)

$ _____________

2

Total outstanding A/P checks (shown on A/P Check Recon File Listing and G/L Unposted Transactions Report)

+

$ _____________

3

Total outstanding PR checks (shown on Payroll Check Recon File Listing)

$ _____________

4

Add outstanding checks together (#2 + #3)

$ _____________

5

Subtract outstanding checks from bank balance (#1 - #4)

$ _____________

6

Deposits in transit (highlighted (A)dj/(D)eposits Check Recon File Listing)

$ _____________

7

Add deposits in transit (#5 + #6)

The total obtained in line #7 should equal the "ending balance" shown on the G/L Trial Balance Report.

If the Cash Management module is present, reconciliation is performed using Bank Reconciliation Entry instead.