Bank accounts

A bank account in Mosce ERP represents a real account (checking, savings, or other) at a specific bank. When you create it, Mosce ERP automatically generates a linked Class 1 (Asset) ledger account and keeps both in sync. This ledger account is the one you will debit and credit when money comes in and out of the bank - and it is also the basis for reconciling against the bank statement.

Reading time: ~6 min

When to use this

• You just opened a new account at the bank and need to reflect it in Mosce ERP.
• You are migrating from an external system and are going to load your active accounts.
• You want to configure the CSV column mapping before importing the first bank statement.
• You need to deactivate an account you no longer use.

Before you start

• The Accounting module is active and the chart of accounts is configured. Mosce ERP requires the account catalog to be ready before you can create bank accounts.
• Your plan allows the number of bank accounts you are going to create (lower plans have a limit - check it in Settings → Billing and subscription).
• Your role includes the banking:bank-account permission to create and edit.
• You have on hand: the bank name, the account number, and the currency (DOP or USD).

How the ledger linking works

Each bank account carries:

• A descriptive Name (e.g. Primary checking account).
• Bank (e.g. Banco Popular).
• Account number, unique within the tenant.
• Currency (DOP or USD).
• Linked ledger account - created automatically when the bank account is registered, not editable.
• Optional CSV mapping with columns, separator, and date format for imports.
• Status, active or inactive.

When you create the bank account, Mosce ERP generates a linked Current Asset ledger account in the same step. When you deactivate the bank account, its linked ledger account is deactivated as well.

Step by step

Create a bank account

1. Go to Banking → Bank accounts and click New bank account.
2. Fill in:
   • Name (e.g. Primary checking account).
   • Bank (e.g. Banco Popular).
   • Account number (unique within the tenant; max. 50 characters).
   • Currency (DOP - Dominican Peso or USD - US Dollar).
3. Save. Mosce ERP creates the account and the linked ledger account in a single operation.
4. The screen shows a Linked ledger account section with the code and name of the chart-of-accounts entry that was associated - save it if you need to reference it in manual mappings.

Configure the CSV mapping

If you are going to import bank statements in CSV, define how Mosce ERP should interpret the columns. This configuration is done once per account and stays saved.

1. In the bank account form, open the CSV column mapping section.
2. Date format: choose how the date appears in your file:
   • YYYY-MM-DD (e.g. 2024-01-15)
   • DD/MM/YYYY (e.g. 15/01/2024)
   • MM/DD/YYYY (e.g. 01/15/2024)
   • DD-MM-YYYY (e.g. 15-01-2024)
3. Field separator: comma, semicolon, or tab.
4. Decimal separator: period or comma.
5. Required columns:
   • Date - name or index of the transaction date column.
   • Description - the transaction concept.
6. Amount mode - choose one of two:
   • Single column: a single signed Amount field (positive = deposit, negative = withdrawal).
   • Two columns: two separate fields, Debit and Credit.
7. Optional Balance - useful if your bank provides it and you want to display it.
8. The on-screen preview simulates a row and tells you whether the configuration interprets the data correctly.
9. Save. The mapping stays associated with the account and is applied on every CSV import.

OFX does not require mapping: OFX-format imports carry standard fields and Mosce ERP parses them without additional configuration.

Edit an account

You can change the name, bank, currency, and CSV mapping. You cannot change the linked ledger account - it is fixed at creation to preserve the integrity of historical entries.

Deactivate an account

1. Open the account detail and click Deactivate bank account.
2. The dialog warns you that the linked ledger account (with its code and name) will also be deactivated.
3. Confirm. Mosce ERP marks both as inactive.

If the linked ledger account is mapped in Accounting settings (for example, as Cash account (transfer)), Mosce ERP blocks the deactivation with an account-in-use notice. Reassign the mapping in Accounting settings first.

Expected result

• Every bank account of the business exists in Mosce ERP with its accounting counterpart ready to receive entries.
• The CSV mapping is configured and the next imports read the files without manual intervention.
• The Accounting settings screen lets you point the transfer or check account to the linked ledger account.

Common errors

Related

• Bank statements
• Bank reconciliation
• Accounting settings
• Chart of accounts