Help center
Getting started

Import my opening balance (Excel or CSV)

1 min read Close and control > Year-end and migration > Data migration > 3. Opening balances
Download as PDF

Here you bring your former software's balances over as one carry-forward entry.

How to

  1. Open Year-end and migration, « Data migration » tab, then step « 3. Opening balances ».
  2. Keep the suggested balance date: the first day of the fiscal year, never the day before.
  3. Choose the file: Excel or CSV with Account, Debit, Credit (or the Sage export, with third parties).
  4. Click « Check the file » and fix each blocking point (date, missing accounts, unbalanced trial balance).
  5. 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.

Read next

Getting started
Migrate from Sage: chart, third parties, balances and FEC
Import from Sage the chart of accounts, third parties, opening balances and analytic sections, or a FEC that carries everything.
Getting started
Undo an import (Sage, FEC or history import)
Take back an opening-balance import or a history import saved by mistake, then import the right file.
Checks & closing
Work with separate fiscal years
Each fiscal year is isolated: its statements, balances and close are its own, and the next year opens by itself.
Checks & closing
Allocate the result after the general meeting
Split a closed year's profit or loss between reserves, retained earnings and dividends.
Getting started
Turn on double validation of entries
A second person approves entries above an amount (manual entry, templates, recurring entries, reversals, invoice inbox, bank automation, month-end), the year-end close and imported opening balances.

A specific question?

The Comptia team is available Monday to Friday, reply within 4 business hours.

Contact support