Template format
The columns in each template, which ones are required, what other header names are recognised, and where to download them.
Every entity you can import (loans, clients, payments, services) has its own template, with headers written out in your language, not technical keys.
Readable headers, not technical keys
The columns use the same word you already see on the web form: the disbursement date is called "Start date" in both places, grace days are called "Grace days" in both places. Nothing was invented just for the template.
The four templates
Template | Required columns | Required only if the client does not exist |
|---|---|---|
Loans | Identity document, Principal, Interest (%), Total installments, Loan type, Payment frequency, Start date | First name, Last name |
Clients | Identity document, First name, Last name | N/A |
Payments | Loan (folio or code), Payment date, Total paid | N/A |
Services | Identity document, Service name, Recurring charge, Start date | First name, Last name |
Every other column in each template is optional: leave it empty if you do not have it.
Two columns say "where a migrated loan or service stands": "Installments paid" (or "Charges already settled" for services), or the alternative balance/date. For loans, one of the two is needed only when the start date is already more than one period old; for services, it is needed as soon as the start date is in the past, no matter how far. Writing 0 is a valid statement ("never paid any, and is genuinely in arrears"); leaving it empty states nothing, and the loan or service would come in with arrears that may not be real.
The payments template has no installment number column: it is decided by row order. The first row referencing a loan is its installment 1, the second its installment 2, and so on, even when rows from different loans are interleaved.
Two formats: CSV or a full workbook
From the blog and from this documentation you can download the template as CSV, one per entity, for anyone who only wants to import one thing. Inside the app, the combined file wizard gives you the loans and payments templates in Excel so you can paste them as two tabs of the same workbook. The combined file only accepts .xlsx: a CSV is a single table.
Aliases: an old template still works
If you already have a file built with the previous technical keys (fechaDesembolso, moraDiaria, cuotasPagadas), it still uploads without changing anything: they are recognised aliases of the new headers. The same goes for reasonable variants of the readable header: "Start date" also recognises "fecha" or "fecha de desembolso", and "Installments paid" also recognises "pagadas" or "payments made". Auto-mapping compares ignoring accents, case and punctuation.
Before you upload
- Accepted formats are CSV or Excel .xlsx. An old .xls file (the legacy Excel format) is not processed: save it as .xlsx first.
- Maximum 200 rows per file. If your portfolio is bigger, split it into several: each batch is independent and re-uploading duplicates nothing.
- Amounts go in currency (25000 or 25,000.00), never in cents.
- Dates go as YYYY-MM-DD or DD/MM/YYYY.
- Every template ships with example rows using obviously fake identities: "EXAMPLE-001" for loans, clients and services; example folios like "PRE-0001" for payments. Delete them or replace them with your own data before importing.
Download the templates
How importing works with these templates: How importing works.