Deposits & Adjustments
Make Journal Entries for all fees and adjustments included on the bank statement that do not display on the G/L Trial Balance Report.
Reprint the G/L Trial Balance Report and dispose of the previous report. Highlight the "ending balance" on the new report.
In Check Recon File Maintenance, enter all deposits and adjustments that display on the G/L Trial Balance Report but are not included on the bank statement.
Print the Check Recon File Listing for Adjustments and Deposits. Highlight total.
Check Reconciliation Worksheet
Use the Check Reconciliation Worksheet (below) to reconcile the General Ledger with the bank statement.
Purge reconciled checks from the reconciliation file using Check Recon File Purge. Note that check history is retained.
$_____1) |
Ending bank balance (from bank statement) |
|
$_____2) |
Total outstanding A/P checks (highlighted on Accounts Payable Check Recon File Listing) |
|
+$_____3) |
Total outstanding P/R checks (highlighted 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 on Adj/Deposits Check Recon File Listing) |
|
$_____7) |
Add deposits in transit (#5 + #6) |
The total obtained in line #7 should equal the "ending balance" highlighted on the G/L Trial Balance Report.