How to Troubleshoot Incorrect Figures in the Trial Balance

Published: 16/05/2023

How to Troubleshoot Incorrect Figures in the Trial Balance

Answer:

It is important to ensure that the Trial Balance is in balance before and after the import. If the Trial Balance does not balance at the source (ERP system or Excel), it must be correctly adjusted before it can be imported into Caseware Working Papers.

If the Trial Balance did balance before import and does not balance after import, it needs to be re-imported.

1. Re-import from Microsoft Excel

Go to Engagement | Import | Excel File…
Follow the on screen instructions on the import wizard
Pay special attention to the following advanced specifications:
- Clear balances of periods being imported and
- Make sure the currency format is correct; uncheck to overwrite the default symbols set in your control panel. (For more information on Regional Settings, refer to How to ensure my figures import correctly from Microsoft Excel)

2. Re-import from accounting software

Go to Engagement | Import | Accounting Software
Select the required information for import
When importing from accounting software and there are balances in your client file; you will be asked if you want to delete the amounts, select to delete to reset the Trial Balance

Rate this article:

Processing...

(Popularity = 0/100, Rating = 0.0/5)