Migrate from Sage: chart, third parties, balances and FEC
Here you bring over from Sage the chart, third parties, opening balances and general ledger, or a FEC.
How to
- Export from Sage the chart, third parties, the trial balance, then the general ledger (or a FEC).
- Open Year-end and migration, « Data migration » tab, « Import from Sage, a FEC or Excel » card.
- Follow the recommended order: 1. Chart of accounts, 2. Third parties, 3. Opening balances, 4. General ledger (history).
- Drop the file, click « Check the file », review the recommendations.
- Click « Approve and import » (or « Import »), then move to the next step.
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
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.
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).
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 ».