Skip to content

Import IFRS 16 leases

Updated:

Bulk-load leases into the register.

Open IFRS 16 lease register in Fiatto
In this article

Under Accounting → IFRS 16 lease register (/dashboard/contracten/ifrs16) Lessor & import → Import leases (/dashboard/contracten/ifrs16/import) bulk-loads, for admins, leases into the register.

Steps

  1. Under 1. Source, template & file, click ↓ Download template (CSV).
  2. Per row, fill in either the commencement columns (start date/annual amount/term) or the carrying columns (transition date/carrying amount/remaining term).
  3. Upload the file (.xlsx, .xls or .csv). Under Column mapping, check which field each column goes to and keep it with Save as column profile for the next upload from the same source. Review the outcome of 2. Check (dry run) and fix validation errors before importing for real.
  4. Spot-check the register + completeness.

Tips

  • Tick Update existing leases (same supplier + contract number, or same source key) to update existing leases instead of creating duplicates. Only filled columns are applied; a lease already in the ledger only gets enrichment, and a row that changes a measurement field is rejected.
  • The template has optional columns for the identification file: the conclusion and, per criterion, the answer and rationale. When filled, the import records the file with you as preparer. If your company requires an identification file, a lease without a conclusion arrives as a proposal that you confirm per contract; the dry run shows this in advance. An empty discount rate gets the rate from the IBR matrix (indexation, tab Policy choices).
  • Do not import blindly beside manual edits in the same period.
  • Post-import indexation via indexation.
Was this article helpful?
View all articles in this topic

Find another answer

A task, feature or short question is enough.