Help center
Getting started

Import past fiscal years from Sage or a FEC

1 min read Close and control > Year-end and migration > Data migration > 4. General ledger (history)
Download as PDF

Here you bring your past fiscal years from Sage or a FEC in, as closed years.

How to

  1. Open Year-end and migration, « Data migration » tab, step « 4. General ledger (history) ».
  2. Pick the file, then « Upload and analyse ».
  3. Read the report and its recommendations: years, journals, accounts and parties to create.
  4. Change what does not fit (parties to create, years, journals).
  5. Click « Approve and import », then « Confirm the import ».
Learn more

After migrating, your past fiscal years can be brought into Comptia. They become closed, read-only fiscal years: prior-year comparisons, prior-year statements, the general ledger and trial balances work straight away.

Where to find it, and in what order

The general ledger import is step « 4. General ledger (history) » of the « Import from Sage, a FEC or Excel » card, « Data migration » tab. The recommended order: 1. Chart of accounts, 2. Third parties, 3. Opening balances, 4. General ledger. Each step done shows a tick, and the next step to do is flagged. The link in the analysis e-mails (…/cloture#reprise-historique) opens step 4 directly. It is for book administrators with the close right.

Which file

- A FEC (French standard audit file), covering one or more fiscal years. - Or the Sage 100 general ledger exported as text, recognised as it is (see below). - Or a Sage journal or general ledger export (text separated by ; , tab or |, or Excel). Sage columns (JO_Num, EC_Piece, EC_Date, CG_Num, CT_Num, EC_Montant, EC_Sens, EC_Lettrage) are recognised. Otherwise a column mapping screen opens, and your choice is kept for next time. - At most 150,000 lines and 40 MB per import. For more years, import the most recent ones first, then the older ones in a second import.

The Sage 100 general ledger as text

The general ledger Sage 100 exports as text (no header row, 9 columns: account, date DDMMYY, journal, document number, label, matching, debit, credit, running balance) is recognised as it is, in Windows-1252 or CP850, with tab, semicolon or comma. The report says so in the « Sage 100 general ledger (text) » box. - This file has no opening entries: each account's balance on the first day of the fiscal year is derived from its running balance (balance of its first line, minus its debit, plus its credit). The lines of the opening journal (RAN) are added to it, with no double count. - Sage lists only accounts that moved. If the book already has the opening balances of the next year, the accounts that did not move (capital, reserves…) take that balance; otherwise import those opening balances first. - Negative amounts (red reversals) are moved to the other column as positive amounts. - A day the month does not have (Sage dates its monthly centralisations on the 31st, for example 31/11) is not an error: the line is dated on the month's last day (30/11), as a recommendation, and the original date is kept with the import and in the audit log. The report lists these lines under « Recommended dates ». This holds for any file, not only Sage. - Entries are formed by document; lines whose document does not balance on its own (daily or monthly counterparts) are grouped by day, then by month. - Without the running balance column the import is refused: export it, or export the FEC.

Steps

1. Choose the file, then "Upload and analyse". The file is sent in chunks and the analysis runs on the server: you can leave the page. When it is done, the book's administrators (those who may confirm the import) get an e-mail, once per import: ready to confirm, with what to check, or to fix, with each error, its cause and what to do. The link brings you back to this card. The e-mail follows your « Approvals » notification preferences. 2. Read the report: fiscal years in the file (tick the ones to import), journal mapping (to an existing journal, to create, or opening journal), accounts and third parties to create, any errors. 3. Change what does not fit: your choices are analysed again when you approve (or at once with "Analyse again with these choices"). 4. At the bottom of the card: "Approve and import", then "Confirm the import". Nothing is written before that confirmation.

What is checked

- Every entry and every fiscal year must balance. - A fiscal year that already has entries in the book is never imported. - The imported years are consecutive and end the day before the book's first fiscal year. - If the book already has its opening balances (an imported switch-over balance or FEC), the close of the last imported year must equal them, account by account and third party by third party. Otherwise nothing is imported and the reconciliation shows each difference. The 13 result accounts are compared in total. - The file's opening entries of the following years must match the previous year's close. - A fiscal year is imported only once.

What the import does

- Entries keep their dates, their original numbers (prefixed with the journal or year when they repeat) and their document references. - Matching (lettrage) is kept when the group is settled within the imported years. - Each fiscal year is closed like a close done in Comptia: result on 131 or 139 (per the book settings), then the opening entries. - If the book already had its opening balances, they become the carry-forward of the last imported close: nothing is counted twice. - Books running approvals: someone other than the person who sent the file or ran the analysis confirms the import.

If the import is blocked

At the top of the card, « Before importing » lists each blocking point with its cause and what to do. The most common cases: - Dates that do not exist (31 November): the file was opened and saved again in Excel. Fix the date in Sage and export again without going through Excel. - Unbalanced entries: the Sage export is incomplete or filtered. Export the journal or the FEC of the whole fiscal year again, with no filter on accounts or journals. - Fiscal year that cannot be imported: the book already has entries in that year (the card names the first one), the year has not ended, or it is already closed. Untick it, or follow the step shown. - Close different from the book's opening balances: the card gives the likely cause. Close at 0 on capital and reserves: the file has no opening entries, export them (the FEC has them). Differences only on 401 / 411: the third-party list is missing, import it first. File that stops before the year end: truncated export. - The « Ask the Assistant » button opens the Comptia Assistant, which reads the book's latest import and explains each point.

Third parties missing from the book

When the file carries third-party codes (FEC, export with CT_Num) that do not exist in the book, the report no longer just warns: the « Third parties to create » list recommends them, ticked. The type comes from the control account (401 supplier, 411 customer), the name from the file or, failing that, the code. On import they are created, then their lines are attached to them. Untick those not to create (or « Create none »): their lines then go on the control account, with no third party. A code skipped in an earlier import of this book arrives unticked (never from another book). 401 / 411 lines with no third-party code at all keep the « imported as totals » warning.

Replace the previous import with a corrected file

If the file's fiscal years already come from a previous history import, a message at the top says so (for example « This 2025 general ledger is already imported (on 13/11/2026, 1,250 entries) »), with « See the imported entries » and « Replace the previous import », instead of a list of errors. One click on « Replace » analyses again as if the previous import were removed; « Replace and import » then « Confirm the replace » reverses the previous import and imports the new file in one operation: all or nothing. Posted entries are reversed, never deleted: its closes are reversed (years reopened), then each entry gets its opposite entry, on the same date, in the same journal, with the journal's next numbers, linked to the original (« Contre-passation import #… »). The general ledger and trial balances show the pair, which nets to zero, then the new import. The replaced import stays in « Import history » and in the audit log (file, fingerprint, entries, totals, author, date). The replace is refused, with the reason, whenever an auditor would refuse it: book under an audit engagement (posted entries are corrected by reversal), fiscal year closed or period locked since the import, entries entered since the import, lines matched or reconciled with other entries, records relying on the import. In that case, correct by reversal: reopen the fiscal year (« Reopen by reversal »), post the corrections, then close again. Book administrators only.

Automatic corrections and audit trail

Every automatic correction you approve keeps the original value next to the value used, with your name and the date: date brought to the month's last day, negative amount moved to the other side, third party created from the general ledger, code skipped. They are listed in « Import history » (« automatic corrections approved ») and in the audit log.

Fixing an imported year

An imported fiscal year is read-only. To change it, reopen its close (Closing › Reopen), fix it, then close it again: the opening entries are recomputed.

A specific question?

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

Contact support