Hi DeAnna Hart ,

Thanks for reaching out. I see that you're experiencing a discrepancy between your client's Trial Balance and Balance Sheet for FYE2023. This can indeed be puzzling, especially when all entries seem correct upon review.

Before proceeding with any fixes, please ensure to create a backup of your data. If you have recently changed the account type of one of your general ledger accounts, this could cause the Balance Sheet to become unbalanced.

Here are some steps you can follow to potentially resolve the issue:

1. Run the Chart of Accounts/Journal Synchronization test. This is often the most common fix and can be done by following the instructions on how to run the Chart of Accounts Journal Synchronization test.

2. Check for customized or damaged reports. If you’re using a customized Trial Balance or Balance Sheet report, try running the standard version of the report to see if the balance issue persists.

3. Look for Damaged Transactions. Run a General Ledger report with the Time Frame set to All. If you encounter an error indicating a damaged transaction, this will need to be addressed.

4. For Consolidated Companies: Ensure that each subsidiary company’s Trial Balance is in balance by running the General Ledger Trial Balance report for each one and checking if debits equal credits. If they don't, you’ll need to run the Chart of Accounts/Journal Synchronization test for each subsidiary company. Once all are in balance, reconsolidate the consolidated company.

If after these steps the issue remains unresolved, it's best to contact Sage Support for further assistance at 866-747-3888.

I'll move this post to the Support Group for Sage 50 US so that other users can also offer their insights.

Warm Regards, 

Erzsi

Hi there. This issue is happening in Sage Accountant Edition of Sage Online, not Sage 50... so, this thread might need to be moved back to where it was originally.

Also - Since posting I got hold of Sage Online support, who informed that a lot of other Online Acct Ed users are having the same issue, so, whatever's happening it's systemic and not end-user caused.

Hi DeAnna Hart ,

Thank you for your follow-up and for reaching out to Sage Online Support. Apologies "trial balance" is usually a term for Sage 50 US.

The Sage Accounting US issue related to degraded performance incident in our service that has since been resolved. The services are now performing as expected, and you should no longer experience the discrepancy issue on your end.

We are having the same issue - we have noticed it since 1/3 - i have been reaching out every day and just keep getting told that its been escalated but there is not ETA on when a fix will get in- even though i have been stressing it is year end and we want to know when we can run accurate reports - we also use Sage 50

Hi C R,

Please let us know where you are located and which version of Sage 50 you are using, so we can make sure your question gets moved to the correct forum.  This thread is relating to Sage Accounting US, which is a different product than Sage 50.

Thanks,

Derek

We Use Sage US Accounting the cloud based accounting  (sorry for the confusion!) - for year end we changed all of our transactions to 12/30 and noticed our balances then were inline with all of our recs - we did lots of accruals from the 30th, and reversed them on the 31st so any of our rev rec items would show on the 30th (but whenever they fix this - the balances wouldn't be changed). 

it looks like something happened on the 31st and that is causing the Bug which i think we are all hoping gets fixed very soon

Ok, thanks for confirming.  Your post is in the correct forum.

Thanks,

Derek

Hi DeAnna Hart  and all,

I hope this message finds you well. I'm reaching out to provide an update on the situation you've been facing with the Trial Balance report within Sage Business Cloud Accounting.

Our product manager confirms that the General Ledger report is accurate and should reflect the correct data for your year-end processes. This has been verified and there are no known issues with it at this time. The discrepancy appears to be isolated to the Balance Sheet report, which we believe should not impact your year-end reporting, although it's certainly not ideal.

Our development team is fully aware of the problem and is actively working towards a solution for the Balance Sheet report discrepancy. While we are optimistic about resolving this quickly, we cannot provide an exact timeline just yet.

We understand the importance of reliable data, especially now, and we want to thank you for your patience as we work through this. Please rest assured that resolving this issue is a high priority for us, and we will keep you updated with any new information as soon as it becomes available.

If you have any questions or need further support, don't hesitate to reach out. 

Warm regards,

Erzsi

Hi all! 
I got an email last night stating this problem was resolved. I checked just now and yes, the balances match across Balance Sheet, Trial Balance, and GL detail reporting.