Skip to main content

Troubleshooting Bank Reconciliation: Resolving Out-of-Balance Differences

How to resolve unmatched differences, handle bank adjustments, and preserve in-progress monthly bank reconciliation sessions in Edlio Accounting.

Monthly bank reconciliation ensures that your school's general ledger matches your physical bank statement balance. In Edlio Accounting, a reconciliation session cannot be closed until the Difference equals exactly $0.00. This troubleshooting guide walks through diagnosing out-of-balance differences, posting bank adjustments, and saving in-progress work safely.

The Difference does not equal $0.00: How to find the discrepancy

If your reconciliation displays a non-zero difference, work through this 4-step diagnostic checklist:

  1. Verify the Ending Statement Balance: Confirm that the ending balance keyed in the header matches the exact ending cash balance on your paper or PDF bank statement. A simple transposition error (e.g. $14,250.00 vs $14,520.00) is the most frequent cause of differences.

  2. Match Deposits and Credits: Compare each deposit line on the bank statement against the cleared deposits list. If a deposit appears on the bank statement but was not checked off in Edlio Accounting, find and check the matching deposit.

  3. Match Disbursements and Debits: Compare cleared checks and debit charges on the bank statement against your payment list. Outstanding checks (checks written that have not yet been cashed by the payee) must remain unchecked.

  4. Check for Bank-Initiated Activity: Bank service fees, earned interest, wire fees, or returned check (NSF) charges appear on the bank statement but do not originate in your daily receipts or disbursements. These must be recorded via Bank Adjustments.

How to record bank adjustments (interest, service charges, returned checks)

When your bank statement includes interest earned or monthly service fees, do not exit reconciliation to enter an invoice or receipt. Enter the item directly inside the reconciliation session:

  1. Within the active reconciliation screen, click Bank Adjustments.

  2. Click Add Adjustment.

  3. Select the Adjustment Type:

    • Interest Earned: Increases cash balance; allocated to your general interest fund account.

    • Bank Service Charge: Decreases cash balance; allocated to your bank fees activity fund.

    • Returned Item / NSF: Reverses deposit credit for a bounced check.

    • Other Adjustment: For specialized corrections or wire transfer fees.

  4. Enter the exact amount and select the fund account responsible for the adjustment.

  5. Save the adjustment. The item immediately updates the reconciliation calculation, reducing your Difference toward $0.00.

⚠️ Important: Always use "Save for Later" before exiting

If you must leave your desk or investigate a discrepancy mid-reconciliation, always click Save for Later at the bottom of the screen. If you close the browser tab or navigate away without saving, your cleared checkboxes and session entries will not be preserved.

Related articles

Did this answer your question?