Why is my Trial balance balancing in Excel but not in CaseWare

If your trial balance in Microsoft Excel is balancing well, but not in CaseWare it is likely that there are existing duplicated account numbers within your Excel Spreadsheet.

CaseWare Working Papers will only allow unique account numbers to be imported across. If a trial balance has any duplicated account numbers, CaseWare will ignore one of them upon importing, hence leaving it imbalanced.

To fix the problem:

Find out what the CaseWare Working Trial Balance is out of balance by. This number will be used to help find the duplicate account number.

1. Open the Microsoft Excel file (or ASCII Text file) which contains your client’s trial balance.

2. Using the out-of-balance amount from CaseWare, locate the duplicate account.

3. Renumber the duplicate account and make a note for next year in case the same thing re-occurs.

4. If there are a significant number of duplicate accounts, or you are unable to change them. You can go with the option of accumulating balances, this will add the instances of transaction in the account together.

Note: You can either re-import the trial balance or manually add the re-numbered account in the CaseWare Trial Balance screen.

• Related Articles

• How do I Change the Colour of the Working Trial Balance

  Users can change the colour scheme of the Working Trial Balance. To do this: 1. From the Tools tab, select Options to display the 'Options' dialog. 2. From the 'Properties' menu select General. 3. From the 'Colour Scheme' picklist select from the ...

• How can I use Microsoft Excel to tidy my ASCII Text files

  A direct import from the client's accounting package into CaseWare is not always possible. Therefore, it may be necessary to import the trial balance using the ASCII text file method. It should always be possible to export your client’s trial balance ...

• How to delete Transactions entered into Trial Balance

  There are multiple ways to delete a Transaction that has been entered. Method 1 1. Open Trial Balance and select your relevant Transaction to delete by double clicking on it. You will be brought the Period Year Balances, where you can delete the ...

• How to Display or Hide Zero Balances within Trial Balance Leadsheets and Review Documents

  This is a global setting that flows through to all automatic documents. To Hide: 1. From the File tab, select Options. 2. From the 'Properties' menu select Documents. 3. Untick the Trial Balance/leadsheets/analytical review/tax ...

• How to report Translated Trial Balance of a Foreign Currency Entity in a Consolidated File?

  If a trial balance for an entity that you are consolidating is in a foreign currency, to report on the converted values in the Consolidation file, you need to do the following: Procedure in the individual foreign subsidiary engagement file:  Create ...