Task Technology FAQs

The main reason why a trial balance will balance in Microsoft Excel and not in CaseWare is due to having duplicate account numbers in Excel.

CaseWare Working Papers will only allow unique account numbers. If a trial balance has duplicated account numbers, CaseWare will ignore one of them upon importing.

This will result in your trial balance being out-of balance.

To fix the problem:

1. 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.
2. Open the Microsoft Excel file (or ASCII Text file) which contains your client’s trial balance.
3. Using the out-of-balance amount from CaseWare, locate the duplicate account.
4. Renumber the duplicate account and make a note for next year in case the same thing re-occurs.
   

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





© Copyright Task Technology 2010