Create an amortization schedule (calculated or imported)

In Embat you can create amortization schedules for loans or leasings to get visibility over past and future instalments and automate how they’re treated in treasury. This article explains the creation flow, starting with choosing whether you want a Calculated or Imported schedule.

Open the creation wizard

• Go to Banks > Bank connections.
• Find the debt product and click the rectangular icon to start creating the schedule.
   

Choose how to create your schedule

In the first step, select the schedule type:

• Calculated: you provide parameters and Embat calculates the schedule.
• Imported: you paste or import instalment details from a file.
   

Set up a calculated schedule

If you choose Calculated, fill in the key parameters:

• Select the charge account.
• Enter the reference text used to identify schedule-related transactions.
• Complete the schedule parameters (for example, outstanding balance, number of periods, frequency, next instalment date, interest details, grace periods, and taxes if applicable).
   

Set up an imported schedule

If you choose Imported:

• Select the charge account and enter the reference text.
• Paste the schedule into the blank table using the required format.
• Review validation messages before continuing.
   

Review the schedule

Before moving forward, review the generated or imported schedule and confirm the instalment details are correct.
 

Configure reconciliation and accounting

In the final step, define how instalments should be treated:

• Configure reconciliation/accounting based on your needs.
• If applicable, set up a split to separate principal, interest, and taxes with their corresponding categories.

If you have any further questions, feel free to contact the Customer Experience team or submit a request via this link.