Help center
Getting started

Migrate from Sage: chart, third parties, balances and FEC

1 min read Close and control > Year-end and migration > Data migration
Download as PDF

Here you bring over from Sage the chart, third parties, opening balances and general ledger, or a FEC.

How to

  1. Export from Sage the chart, third parties, the trial balance, then the general ledger (or a FEC).
  2. Open Year-end and migration, « Data migration » tab, « Import from Sage, a FEC or Excel » card.
  3. Follow the recommended order: 1. Chart of accounts, 2. Third parties, 3. Opening balances, 4. General ledger (history).
  4. Drop the file, click « Check the file », review the recommendations.
  5. Click « Approve and import » (or « Import »), then move to the next step.
Demonstration video: Migrating from Sage to Comptia
Learn more

The « Import from Sage, a FEC or Excel » card takes your files as Sage exports them: text separated by semicolon, comma, tab or pipe, or an Excel file. Each file is checked first: nothing is written until you confirm, and the same file can only be imported once.

Import order

Import in the recommended order shown at the top of the card: 1. Chart of accounts, 2. Third parties, 3. Opening balances (the trial balance at the switch-over date), 4. General ledger (history), the import of past fiscal years (see « Import past fiscal years »). Each step done shows a tick, the next one is marked « next ». Under « Other imports », « Analytic sections » takes your sections, and « FEC (chart, third parties, balances) » takes the first three steps at once. With a FEC, the unclosed result (classes 6 to 8) goes to the book's result account.

Formats and encoding

Accepted formats: .txt, .csv, .tsv, .fec, .xlsx, .xls, .ods (20 MB at most). For an Excel workbook, pick the sheet in « Excel sheet ». Leave « File encoding » on Automatic (Sage Windows-1252 and Sage 100 CP850 are recognised); choose Windows-1252 (Sage) or CP850 (Sage 100, DOS) if accents look wrong. Title lines above the header are ignored.

Downloadable templates

Above the « Exported file » box, « Download the template » gives the Excel file of the chosen tab: the recognised headers, one or two example rows and a « Notes » sheet that explains each column and its format (dates dd/mm/yyyy, amounts, account numbers). « or as CSV » gives the same table as CSV. Replace the example rows with your data without touching the header. The FEC tab and the « History import » card use the « Journal entries (FEC layout) » template.

Column mapping

If columns are not recognised, the « Column mapping » screen opens: pick the « Header row » (or « No header (columns by position) »), then the field of each useful column. Amounts are read as Debit and Credit, a signed Balance, or an Amount with a Direction column (D / C). Click « Apply and check ». The mapping is saved for this book and for your organisation: the next files of the same kind reuse it, in the organisation's other books too (the column layout only, no client data); « Forget it » clears it.

The Sage 100 « Liste des tiers » report

In Sage 100, the « Liste des tiers » report saved to Excel imports as it is in the « 2. Third parties » tab: the card recognises it (the « © Sage - Sage 100 » line, the « Compte tiers » and « Intitulé du tiers » columns), reads the columns where the data is even when the headers are merged, and skips the title and page lines. The type comes from the code: 401… supplier, 411…, 419… or 41… customer, with the matching control account of the chart. A third party without a type never blocks: the « Third parties to check » list recommends a choice, with its reason, in this order: the choice made in an earlier import of this book, the general ledger already analysed (code on a 401: supplier, on a 411: customer), a code that looks like a ledger account (for example 5850ESPECES, 585 being a cash account) recommended « Skip », a code starting with 1 suggested as a customer, else a suggestion to check. Change the recommendation row by row (Customer, Supplier or Skip), or tick rows and « Apply to the selection ». Then click « Approve and import »: your choices are kept for this book's next imports (later fiscal years included, never in another client's book), and each type chosen or code skipped stays traced in « Import history ». The temporary name « Tiers à créer » is replaced by the code, and parties with the same name as another one are flagged as possible duplicates, nothing is merged. Sage's .sma file is a format model with no data: export the third-party list (Excel) instead.

Accounts listed as a total and in detail

A Sage trial balance often lists the control account (401, 411) as a total, then the detail per third party. The check flags it under « Accounts listed as a total and in detail ». Tick « Keep the detail only (ignore the total lines) » so nothing counts twice; any remainder is kept as unassigned.

With double validation

If double validation is on (or during an audit engagement), imported opening balances wait for a second person to approve them in Journal entries > « Awaiting approval ». They are posted on approval.

A Sage chart in 8 digits

Sage often keeps accounts in 8 digits. Create the book with the same « Account code length » before importing: shorter numbers in the file are padded with zeros to the book's length, and the whole chart stays aligned. The length can no longer change after the import.

A Sage chart with letters (411CLIENTA)

Some Sage charts have accounts with letters, for example 411CLIENTA or 401SAGE01. Before importing, open Book settings > Chart of accounts and click « Turn on » on the « Alphanumeric account codes » card. Letters are then accepted after the class digit and upper-cased. The first character stays the class (1 to 9): an account such as A411 is refused. A letter in the first three characters or an account longer than the « Account code length » is shown as a recommendation, without blocking. The option can only be turned off once these accounts are deactivated. For every new book, set « Default alphanumeric account codes » in Settings > Accounting (Comptia) > Book defaults.

Frequently asked questions

I imported the wrong file: what now?

For opening balances or the general ledger, drop the corrected file in the same step: « Replace the previous import » reverses the old import (posted entries are reversed, not deleted; a draft awaiting approval is deleted) and imports the new one in one operation, as long as nothing was entered, matched or closed on top of it and the book is not under an audit engagement (otherwise correct by reversal, the reason is shown). For a chart or third parties, edit or deactivate them in their list.

Can I also bring in my past fiscal years?

Yes: step « 4. General ledger (history) » of the same card imports a FEC, the Sage 100 general ledger or a Sage export of several years, brought in as closed years you can consult (prior-year comparisons, general ledger).

What if I do not come from Sage?

Any tabular file (Excel, CSV) goes through the same card thanks to column mapping. For a plain 3-column balance, see « Import my opening balance ».

Read next

Getting started
Import my opening balance (Excel or CSV)
Bring the balance-sheet balances from your previous software in at the first day of the fiscal year, as one carry-forward entry.
Getting started
Import past fiscal years from Sage or a FEC
Import your earlier fiscal years as closed years: prior-year comparisons, prior-year statements, general ledger and trial balances from day one.
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.
Third parties, due dates & reminders
View the auxiliary trial balance and ledger
The balance of each supplier and customer, its line-by-line detail and a printable statement.
Getting started
Choose the account code length (8 digits, for example)
Keep a book's chart in fixed-length numbers (401 becomes 40100000), or in the official chart's free numbers.

A specific question?

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

Contact support