Troubleshooting Balance Sheet Mismatch

SOLVED

I need some help troubleshooting why the value of my chequing account on my balance sheet is mismatched.

Balance Sheet run on 2023-12-31 shows chequing account value of -8115. When I drill into that value, my closing balance for 2023-12-31 shows 55.03. The correct value of my chequing account is 55.03. If I run the balance sheet for 2024-01-01, it updates the balance sheet to 55.03.

I have looked backward at journals and cash entries and cannot find any reason for this mismatch. I'm at a loss as to why the balance sheet value would show something different than when I drill into the chequing account for the exact same period. Any troubleshooting advice?

  • 0
    verified answer

    Hi  ,

    Thanks for reaching out. There could be several reasons for differences between the reported balances in the software. The balance may include future-dated transactions while the today's balance reflects only the transactions recorded up to the current date, which should align more closely with your actual bank balance.

    Here are some steps you can take to troubleshoot the mismatch:

    1. Check for any future-dated transactions that may have been included in the balance sheet value but not in the chequing account's closing balance.
    2. Utilize the Cashbook report to verify the running bank balance as of the current date and compare it against the balance sheet.
    3. Ensure that all transactions are processed and allocated correctly, especially if you’ve recently imported transactions or are using bank feeds.
    4. If the discrepancy persists, you may want to proceed with a bank reconciliation process to identify any duplicates or missing transactions that could be affecting the balance.

    If you’re still unable to find the reason after these steps, it might be helpful to reach out to Sage support for more specific guidance. Connect with us through the Help and Chat options available within your Sage product.

    Warm Regards,
    Erzsi

  • 0

    I'm having the same problem! cash balance on the balance shows a different number than the detailed ledger.  I'm choosing the same date for both.  I've tried the trouble shooting methods recommended, and I still can't figure it out.