#078 Ma conciliation bancaire est à zero... alors pourquoi mon bilan est faux ? - 6DT Conseil inc

#078 My bank reconciliation is at zero... so why is my balance sheet incorrect?

Christiane Constantineau
This is one of the most frequent questions from new QuickBooks users. You have checked off all your transactions, your reconciliation difference shows $0.00, but when printing your Balance Sheet, the bank account amount does not match reality.

Why does this discrepancy happen?

  • Future or post-dated transactions: Checks or transfers recorded in the software with a date later than the balance sheet date.

  • Outstanding items: Checks issued or deposits recorded in QuickBooks that have not yet been processed by the bank.

  • Direct journal entries: Manual adjustments made directly to the bank account without going through the reconciliation module.

  • Incorrect report date: The balance sheet is pulled for a date different from the end date of your reconciliation period.

How to fix everything?

 

  1. Verify the exact date the balance sheet was pulled:

    Ensure that the end date of your balance sheet report matches exactly the end date of the reconciled period (e.g., the 31st of the month).

  2. Pull the "Reconciliation Detail" report:

    Consult the Uncleared Transactions section to identify post-dated items or duplicates that are distorting the overall balance.

  3. Identify isolated journal entries:

    Filter your general ledger to locate manual adjustments made directly to the bank account without passing through the reconciliation module.

  4. Make the necessary adjusting entries:

    Adjust or delete duplicates, reclassify amounts to the correct accounts, or make an adjusting entry to permanently eliminate orphaned discrepancies.

 

💡 Useful resource: To understand the impact of adjusted accounting and avoid end-of-month errors, consult our detailed article on the importance of bank reconciliation.

Back to blog