Taking over an existing fixed asset base
When you start using SynkriaOps with a company that is already trading, your fixed assets already exist and part of their value has already been depreciated. By the end of this page, you will know how to import them in one go, with their prior depreciation, and check that the register matches the general ledger.
Before you start
Section titled “Before you start”- The opening balances are in the accounts: accounts
2xand28xmust carry the gross value and accumulated depreciation of your assets, through the opening entries (à-nouveaux) or the historical accounting data import. - Each asset account you will mention exists in your chart of accounts, in class 2, and is not a summary account.
- The takeover fiscal year is open.
- The Administrator, CFO or Accountant role.
Importing the file
Section titled “Importing the file”-
Open Assets → Fixed assets, Import tab, then click Start import. The Import fixed assets window opens.
-
Download template: click SynkriaOps Excel template and fill in one row per asset.
-
Recovery fiscal year: choose the fiscal year from which SynkriaOps takes over the depreciation.
-
Import your file: select the completed CSV or XLSX file.
-
Click Validate without importing. SynkriaOps checks each row and shows the number of valid rows and errors, row by row.
-
Correct the file if needed and run the validation again, until the message “All records are ready to import.”
-
Click Confirm import.
Template columns
Section titled “Template columns”| Column | Required | Content |
|---|---|---|
designation | Yes | Name of the asset |
categorie | Yes | Code of a category in your depreciation tables |
compte_immo | Yes | Class 2 account number, for example 2441 |
valeur_brute | Yes | Acquisition value excluding recoverable taxes |
date_acquisition | Yes | In YYYY-MM-DD format |
date_mise_en_service | Yes | In YYYY-MM-DD format; starting point of depreciation |
methode_eco | Yes | LINEAIRE (straight-line), DEGRESSIF (declining-balance) or AUCUN (non-depreciable) |
duree_eco_mois | Yes | Total depreciation period in months, for example 60 |
amortissement_anterieur_eco | No | Depreciation already recorded before the takeover fiscal year |
methode_fisc, duree_fisc_mois, amortissement_anterieur_fisc | No | Tax track, if it differs |
reference, site, departement, service, bureau, emplacement, marque, serial number… | No | Identification and location of the asset |
Checking after the import
Section titled “Checking after the import”-
Open the Reconciliation tab, choose the takeover fiscal year and click Refresh.
-
Each account shows the register’s gross value and depreciation against those of the general ledger. Aim for the Reconciliation balanced status.
-
If an asset is listed as “to record”, its account does not carry a sufficient balance in the general ledger: check your opening entries before generating depreciation.
Reconciliation is covered in detail in Reconciliation, export and financial statements.
Records “To complete”
Section titled “Records “To complete””A historical accounting data import can create records with the To complete status, from the fixed asset accounts of the imported general ledger. These records have no depreciation schedule and generate no depreciation. Open each one, click Complete and fill in the date put into service, the method and the duration.
Frequent errors
Section titled “Frequent errors”| Message | Cause | Solution |
|---|---|---|
| Required columns missing | Template modified or old file | Start again from the SynkriaOps Excel template |
categorie invalide | Code missing from your depreciation tables | Use a code from the list given in the message |
date_… doit être YYYY-MM-DD | Date in DD/MM/YYYY format | Enter 2024-03-31 |
compte_immo "…" introuvable | Account missing from the chart of accounts | Create the account, then run the validation again |
compte_immo "…" hors classe 2 | Account from another class | Use the asset’s class 2 account |
compte_immo "…" est un compte de regroupement | Higher-level account, for example 24 | Use a sub-account, for example 2441 |