If Trial balance contain items with amounts made up of both an opening balance and a current year elements,upon import of the opening balances these will be separated into the opening balance/current year elements automatically.
The process is reversed when the file is deleted ie by clicking the delete all file.Use the edit button to amend the amounts in the opening balances.Once saved and confirmed the splits will be automatically recomputed
Preparing the file
File must be in an excel or CSV format with only two columns,with column 1 containing the account description and column 2 , amounts.
Remove column headings
Ensure the narratives/account descriptions are the same as the ones in the TB in the work area.
Debits and credits should be shown in the same column,with credits shown as negatives and debits as positives.