Import or update an amortization schedule (imported)

Imported schedules are created by pasting instalment details from a file (Excel or CSV). The same format is also used to update an imported schedule when amounts or structure change.

Before you start: prepare your file

Make sure your spreadsheet contains one row per instalment and, in this order, the following columns:

• Date (DD/MM/YYYY)
• Principal amortisation (amount of principal repaid in the instalment)
• Interest (interest amount for the instalment)
• Taxes (if not applicable, enter 0,00)
• Remaining balance (outstanding balance after each instalment)

Formatting recommendations:

• Use a decimal comma (e.g., 1.000,00) and no currency symbol.
• Ensure all dates follow the DD/MM/YYYY format.
• The remaining balance on the last instalment must always be 0,00.
   

Open the import table

You can reach the table in two ways:

• During creation: choose Imported and proceed to the table.
• To update: open the schedule and go to three dots > Update schedule.
   

Copy and paste the table

Follow these steps to paste your amortization schedule into the table:

1. In your Excel or Google Sheets file, select the full data range you want to import, including all columns up to Remaining balance.
2. Return to Embat and place the cursor in the first available cell of the table (top-left corner, under “Date”).
3. Paste the values. The system will automatically distribute the data across the corresponding columns and rows.
    

Review the validations

When pasting, the system runs automatic checks. You may encounter:

• ✅ All good: a green notice indicating you can continue.
• 🟥 Cells in red: hover the cell to see the exact error reason (e.g., “invalid date format” or “required field is empty”). Fix it in your file and paste again, or edit the cell directly.
• 🟨 Total principal vs. product balance: if you see a yellow notice indicating the sum of principal does not match the product’s current balance, review your data. If the schedule is correct, the product balance will be adjusted automatically at the end of the process.
   

Fix and re-validate (if applicable)

• Dates: must follow DD/MM/YYYY.
• Amounts: numeric and positive, no symbols.
• Taxes: if not applicable, enter 0,00.
• Blank rows: remove them at the end of the range.
• Final row: ensure the remaining balance ends at 0,00.

Hover any red cell to see details about the error and how to fix it.

Common questions

• Can I paste the headers? Paste only the data under Embat’s column headers to avoid misalignment.
• Can I edit a cell manually after pasting? Yes, although it is recommended to keep your file as the source of truth and paste again if you make structural changes.
• The system shows an error and I do not know why. Hover the red cell to see contextual help with the cause and solution.
• I get a date error. Ensure you are using DD/MM/YYYY and not any other format.

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