Import bank accounts
How to register several bank accounts at once from a CSV file - download the template, validate, and confirm.
Import bank accounts
If your company handles several bank accounts and you need to register them in Mosce ERP all at once while setting up your account, the Import button lets you upload them all from a CSV file. Mosce ERP validates the file before saving anything.
Bank accounts only support the create new mode - Mosce ERP never overwrites an existing account from a CSV to avoid accidental errors with balances and accounting records. If you need to modify an existing account, do it individually from the account's record.
Before you start
- You need the
bank-accounts:bulk-importpermission. If the Import button does not appear in the toolbar of the bank accounts list, ask whoever administers the account to assign it to you. - The file must be in CSV format (comma-separated values), encoded in UTF-8.
- There is a limit on rows per file and files per month depending on your plan (see "Limits" below). For bank accounts, this limit is strict - see "Large files" below.
Step 1 - Download the template
On the Bank accounts page (inside Banking), click the Import button in the toolbar. On the first screen of the wizard, download the template with the Download CSV template button.
The template includes two example rows and all the headers that Mosce ERP expects. The columns are:
| Column | Required | Description |
|---|---|---|
name | Yes | Descriptive name of the account (for example, "BHD Checking Account" or "USD Petty Cash"). |
bankName | Yes | Name of the bank or financial institution. |
accountNumber | Yes | Bank account number. Must be unique - Mosce ERP does not allow two accounts with the same number. |
currency | No | Currency code in 3-letter ISO 4217 format (e.g. DOP, USD, EUR). If omitted, DOP is used by default. |
Important: the column names must be exactly as they appear in the template. Do not translate or rename them.
Step 2 - Validate your file
With your file ready, drag it into the window or select it with the file explorer. Mosce ERP reviews it without saving anything yet.
If everything is correct, you will see a preview of the first rows and the Continue button becomes enabled.
If there are errors, a table appears with the row number, the problematic field, and the reason. You can download the full report with the Download errores.csv button, fix the file, and upload it again.
The most common errors are:
- Duplicate
accountNumber(an account with that number already exists in your account). currencywith a code that is not a valid ISO 4217.- Empty name or bank.
Step 3 - Confirm the import
Bank accounts only support the Create new records only mode. If a row has the same account number as an already existing account, it is discarded with a notice in the results report - the existing account is not updated.
Click Import to begin. When it finishes, you will see a summary with the number of accounts created and the number of rows discarded as duplicates.
How does Mosce ERP identify duplicate accounts?
Mosce ERP uses the account number (accountNumber) as the identification key. If a row's number already exists in your account, that row is discarded. Mosce ERP does not update existing bank accounts from a CSV import.
Large files
For bank accounts, the rows-per-file limit is strict (see the table in "Limits"). If your file exceeds that limit, Mosce ERP will show you an error and ask you to split it into smaller files and upload them one by one. Bank account files cannot be processed in the background.
Limits
| Plan | Rows per file | Files per month |
|---|---|---|
| Free | 1 000 | 3 |
| Starter | 10 000 | 20 |
| Professional | 100 000 | unlimited |
| Enterprise | unlimited | unlimited |
The files-per-month counters reset on the first day of each month.
Frequently asked questions
What if Excel saves my CSV with semicolons instead of commas? Mosce ERP only accepts commas as the delimiter. When saving from Excel, choose CSV (comma delimited) or CSV UTF-8 (comma delimited).
Is the account's opening balance imported? No. The import only creates the account record (name, bank, number, currency). The balance is built from the actual movements and reconciliations you record afterward. If you need an opening balance, record it as an adjustment movement from the account's record once it exists.
Can I import accounts in more than one currency in the same file? Yes. Each row can have a different currency. Make sure to use the correct ISO 4217 code for each currency.
Can I import columns that are not in the template? No. Mosce ERP only reads the columns from the template. Any extra column is ignored without causing an error.
Why can't I update bank accounts from a CSV? To avoid accidental errors. An import with incorrect data could change the name or bank of an account that already has recorded movements, causing inconsistencies in reports. If you need to modify an account, do it individually from its record.
Related
Last updated: 2026-05-11