I have imported a CSV file, why does my Trial Balance not balance?
Article ID
ias-12205
Article Name
I have imported a CSV file, why does my Trial Balance not balance?
Created Date
11th December 2015
Product
IRIS Accounts Production
Problem
I have imported a CSV file, why does my Trial Balance not balance?
Resolution
Please ensure that the total of the CSV file balances i.e totals to zero.
If it does then the main reason the Trial Balance does not balance when imported will be that within the CSV file, amounts have been imported to single sided entry accounts (non-contributing to trial balance)
Check the import map and make sure that no single sided entry account numbers e.g. account 340, have been used.
Select Setup | Import maps
Choose the import map being used and select Change then Accounts in import map and look for any accounts that are single sided entry accounts.
If your not sure which accounts these are, post the balancing entry to suspense within the posting screen to make the trial balance balance and then run a trial balance through ‘Reports’.
The trial balance will show the single sided entry accounts marked with an asterix.
In order for the trial balance to balance a journal will be necessary to move these amounts to different account numbers.
NOTE: The formatting of the cells within the CSV may also be a reason as to why the Trial Balance does not balance.
To format cells
Highlight the relevant column | Right click on Highlighted column | Select Format cells… | Select the Number tab | Select the relevant option – e.g. For the Amount column select your category as ‘Number’, decimal places ‘2’ and Un-tick the ‘Use 1000 Separator (,) box
For further assistance please contact IRIS Support
We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.