Need to load your fixed assets into Odoo, for example as part of the opening balance or when you start using the asset module later on? Use our Excel template. It lets you import every asset in one go instead of entering them one by one.
Download: Fixed-asset import template (XLSX)
Downloading the template
We provide a filled-in example file with notes. The first row of the first tab carries yellow notes that explain what belongs in each column.
- Fixed-asset import file.xlsx - the standard template for recent Odoo versions.
- Fixed-asset import file (Odoo 16 and earlier).xlsx - for older versions.
Ask us for the template if you don’t have it yet; we’ll send it over.
Key points
- Delete the yellow note row. The first row on the first tab is explanation only. Remove it before importing, otherwise Odoo reads the notes as data.
- Leave out the start date. If you fill in the depreciation details correctly, Odoo derives the right start date itself when it generates the depreciation. You don’t need to import that column.
- Check the reconciliation with the opening balance. Reconcile your fixed-asset accounts and the accumulated depreciation with the amounts in your opening balance.
This article is part of the checklist for going live with Odoo Accounting, where importing assets is step 6.
Need a hand with your asset import?
Stuck on the import or the reconciliation with the opening balance? Book an Odoo scan or get in touch - we will take a look with you.