← Help

Bringing data in from a spreadsheet, and reconciling with the bank

Free to import · reconciliation and export are Premium

A bank export, an accountant's schedule, the book kept elsewhere until now: movements, invoices and payments can enter from a spreadsheet. The one rule worth reading twice — the import creates nothing — is what keeps the book clean.

Start from the template

Settings › Import Data › Download template. Two files come out: the template to fill in and import, and your lists — every account, category, subcategory, entity and project the app already knows, with the exact spelling, whether it is professional, and the currency of each account.

The import creates nothing

Accounts, categories, subcategories, entities and projects must exist in the app before the file names them. If the file names something that does not exist, nothing is imported — not the good lines either — and the app shows everything that is missing in one go. Look at the list, create in the app what is missing, or adjust the file to the names that exist.

The currency is not written

A movement's currency is the currency of the account it enters; choosing the account is choosing the currency. A transfer between two currencies needs both Amount and Amount received; without the second the line is refused rather than a rate invented.

Invoices and their payments

A line with a Document type (invoice, credit note, debit note, receipt) is the document — no account, no money moves on that line; the currency is the entity's. A line with only the document number is a movement that pays it, from the account named. Order does not matter. An invoice without payment lines enters as unpaid and becomes paid when its payments are imported, in that file or a later one. An empty due date means due on the document's date.

What is refused, and why

• A name the app does not have — nothing imported, the missing names listed.
• A payment with a number that does not exist; a word that is not a document type; a zero or negative amount; a transfer to the same account; a cross-currency transfer without the received amount.
• The same number twice — one invoice kept, with a warning. Payments above the invoice — a warning. A category on a transfer — a warning; transfers have none.

Each warning says which line.

Reconciling with the bank (Premium)

Import the bank's CSV or OFX statement, let the app match its lines to your records, review what it could not match, and close the period with the statement balance. A reconciled movement stays reconciled on every synced device; the import history and the categorisation rules learned stay on the phone that learned them.

Checked against ZeniCash 1.5.0 on 2026-09-10. Where a feature is Premium, it says so.