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.
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.
fix the problem:
what the CaseWare Working Trial Balance is out of balance by. This number
will be used to help find the duplicate account number.
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
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.
can either re-import the trial balance or manually add the re-numbered account
in the CaseWare Trial Balance screen.