Import savings

Open Import savings from Institution (or press Ctrl+K and type "savings import"). You need savings-deposit permission to import. This is Bankayo’s preview importer — not Fineract’s Organization Excel bulk-import entity (savingsaccount). Fineract savings-transaction workbooks stay on Import savings transactions.

Each spreadsheet row posts one cash deposit on the client’s first active regular savings account. Payment type comes from the upload form and applies to every row.

Before you import

• Download the Excel template from the import page.
• Every client in the file needs an external ID that matches the client record, and an active savings account (not a fixed or recurring deposit).
• Add a non-system payment type if the payment-type picker is empty.

Spreadsheet columns

1. s/n — serial number (ignored)
2. External Client ID — required; matches the client’s external ID
3. Client Name — optional; filled from the matched client when blank
4. Amount — deposit amount greater than zero
5. Date — transaction date (see below)
6. Narration — optional; stored as the transaction receipt number (up to 50 characters)

Date formats

The Date column accepts:

• Excel date cells — format the column as Date in Excel (recommended).
• ISO text — yyyy-MM-dd when you type dates as text (for example 2024-03-15).
• Excel serial numbers — numeric date values Excel stores internally.

Avoid ambiguous slash dates such as 01/02/2024. Day and month order varies by locale and may import as the wrong date. Rows with an unrecognised date are marked invalid in the preview.

Preview the file before posting. Invalid rows can be exported, fixed, and uploaded again. Valid rows post one at a time; failed rows can be exported without undoing deposits that already posted.

If a client has more than one active savings account, the first active regular savings account is used.

The address bar is Institution › Import savings.