Skip to main content

Import a Payment Schedule from Excel

The payment schedule import action is used when you want to continue managing an existing contract in a new system — specifically Business Central. It can also be used when the payment schedule was previously maintained in Excel, while only installment payments were posted in Business Central without recording the payment schedule itself.

Prerequisite

Before importing the payment schedule, the fixed asset must already be created in Business Central with the appropriate IFRS 16 posting group and defined depreciation start and end dates.

  1. Use the Download Excel Template action to download the template that must be completed with data from the existing payment schedule.

Download Excel Template action on the payment schedule ribbon

Import from Excel action on the payment schedule ribbon

  1. Complete the template. Each field in the template includes an explanation of its meaning and purpose, so you can enter the data correctly. The template consists of two worksheets — Header and Lines — and both must be completed.

Excel template field with a note explaining its meaning and purpose

Header worksheet of the Excel template

Lines worksheet of the Excel template

  1. Use the Import from Excel action to import the payment schedule into Business Central, allowing you to continue tracking and posting it in the system.

Completed Header worksheet of the Excel template

Completed Lines worksheet of the Excel template

Import from Excel window opened in Business Central

NPS D.O.O. | +381 11 260 9850 | info@nps.rs | www.nps.rs