Import my opening balance (Excel or CSV)
Here you bring your former software's balances over as one carry-forward entry.
How to
- Open Year-end and migration, « Data migration » tab, then step « 3. Opening balances ».
- Keep the suggested balance date: the first day of the fiscal year, never the day before.
- Choose the file: Excel or CSV with Account, Debit, Credit (or the Sage export, with third parties).
- Click « Check the file » and fix each blocking point (date, missing accounts, unbalanced trial balance).
- Click « Import ».
Learn more
Opening balances are imported in one place: step 3 of the « Import from Sage, a FEC or Excel » card. It takes a simple trial balance (Account, Debit, Credit) as well as the Sage export with balances per third party.
Expected format
The columns Account, Debit and Credit, recognised by their name in an Excel file (.xlsx, .xls, .ods) or a text file separated by a semicolon, comma, tab or |. A signed Balance, or an Amount with a Direction column (D / C), also works. A Third party column adds the detail per customer or supplier. One line per account. The balance must be even (total debits equal total credits). Only one import is allowed per book.
The template
« Download the template », to the right of « Exported file », gives a file with a balanced example. You can also paste the lines into the text box under the file and fix them before the check.
What is checked before importing
« Check the file » lists what blocks, without saving anything. The suggested date is the first day of the book's first fiscal year: a balance dated the day before would fall outside every fiscal year. Each account must exist in the chart of accounts: missing accounts are listed with their line, create them in « Chart of accounts » (or import your chart in step 1), or correct the number in the file. Charge and income accounts (classes 6 to 8) are not taken as they are: their net balance becomes one line on the result account, 131 for a profit, 139 for a loss, which you allocate later. The « Import » button stays greyed out while something blocks, and says why.
Replace balances already entered
A book has only one opening-balance entry. When it exists, step 3 shows the entry instead of the form. If it came from an import, « Import a corrected trial balance » then « Replace the previous import » reverses it and imports the new file in one operation. Otherwise, « Open the entry »: reverse it if it is posted, delete it if it is still a draft, then import the new trial balance.