Hi Robert Kowton ,

Thanks for reaching out regarding the discrepancies between your Sage and bank balances. It's great that you've already matched all transactions, but these differences can sometimes be tricky to resolve.

Here are some steps and reports that might help:

1. General Ledger Report:

   • Ensure the report's finish date includes all transactions. You can find the latest transaction date in the Setup under Company Information in the Home window. Use this date as the finish date for your General Ledger report.
   • This can help identify any transactions that may not have been accounted for.

2. Bank Reconciliation Analysis:

   • Double-check the opening and ending balances, start and end dates, and ensure all transactions are recorded and dated correctly in Sage 50.
   • Verify that you've cleared all transactions appearing in your bank statement and added any bank fees or gains (interest, etc.) as needed.
   • If there's a discrepancy, look at the opening book balance and opening outstandings. Adjust as necessary.
   • For unresolved amounts, check the ending book balance and compare it with the statement ending balance and ending outstandings.

3. Database Utilities:

   • If the above methods don't resolve the issue, consider running the Database Utilities on your company file, as this can sometimes resolve underlying data issues.

4. Contact Sage Tech Support:

   • If these methods don't work, Sage Tech Support can provide further assistance. Their contact number is 888-522-2722.

5. Reset Bank Reconciliation:

   • If discrepancies persist, you might need to reset the bank reconciliation. This can sometimes clear up data errors.

Remember, discrepancies can arise from various issues like missed transactions, data entry errors, or issues during bank synchronization. Careful analysis is often required to pinpoint the exact cause. Hope this helps, happy holidays!

Warm Regards,
Erzsi

Good afternoon Erzsi, 

I appreciate your quick response. I will try these steps next week and let you know which worked best.

Robert

Good day Erzsi, 

Thanks for your tips. I reverted my reconciliations and went all the way back to 2020. I was able to reconcile my accounts up to December 2023 RBC banks statements. However, I still have the following descrepancies:

Chequing:

Sage: $3,944.88

RBC Bank Balance: $4,341.95

Difference: $397.07

RBC Mastercard:

Sage: -$193.96

RBC Bank Balance: -$3.42

Difference: -$190.54

My Savings account all matches. 

I have over every transaction and cannot figure out why I am out. Either I am missing an entry on the chequing and double entered something on the RBC Mastercard. 

Any other ideas?

Robert Kowton

Hi Erzsi, 

Can I undo a finalized bank reconciliation in Sage clound accouting?

Robert Kowton