Bank statements

A bank statement in Mosce ERP is the representation of an imported bank extract: a header with the range and balances, plus the transaction lines that make it up. Mosce ERP accepts CSV files (using the column mapping you configured on the bank account) and OFX (the standard bank format), verifies that you have not imported the same file twice, and leaves everything ready for reconciliation to cross it against the ledger.

Reading time: ~6 min

When to use this

• You closed the month and need to load the bank extract to reconcile.
• Your bank issued an OFX and you want to avoid building the CSV by hand.
• You suspect you imported a file twice and need to verify it.
• You are going to audit the loaded lines before starting the reconciliation.

Before you start

• The bank account was already created and is active. If you are going to import CSV, the column mapping must be configured.
• Your role includes the banking:statement permission to import and view.
• You have the extract file on hand:
  • CSV - with the columns you declared in the mapping, and consistent separator and date format.
  • OFX - issued by the bank; needs no additional configuration.
• The file is under 10 MB.

How the import works

When you import a file, Mosce ERP records the bank statement with its header (bank, account, period, opening and closing balances) and the list of transaction lines it contains. Each line carries a date, a description, and a signed amount (positive = deposit, negative = withdrawal).

Mosce ERP computes a unique identifier for the imported file to prevent duplicates: if you try to import the same file twice for the same account, the system detects it and warns you before creating repeated lines. A statement's lines can end up linked to payments recorded during the reconciliation process.

Step by step

Import a statement

1. Go to Banking → Bank statements and open the Import tab.
2. Bank account: choose an active account from the selector.
3. File: drag the file into the drop zone or click to open the file browser.
   • Accepted formats: .csv, .ofx.
   • Maximum size: 10 MB.
4. Mosce ERP detects the format automatically and shows it below the selected file.
5. Click Import. While it processes, you see an Importing… loader.
6. When it finishes, it takes you to the bank statement detail and shows the toast Bank statement imported successfully.

Review the imported lines

The statement detail shows:

• Header: bank, account, period (start and end), opening and closing balance, import date, and imported by.
• Transaction lines: a table with columns Date, Description, Amount, and Status (Reconciled or Unreconciled).

The lines are sorted by transaction date and keep their sign: deposits positive, withdrawals negative.

Import history

The History tab lists all imported statements with filters by:

• Bank account (or all).
• From / To by import date.

The columns are: imported on, account, format (CSV or OFX), period, lines, and imported by. Click a row to open the detail.

Handling duplicates

If you try to import a file that Mosce ERP already recognizes for that account, the import stops and opens the This file was already imported dialog:

• It shows you the data of the existing statement (account, period, lines, imported on, imported by).
• Clicking View bank statement takes you to the existing statement's detail.
• Cancel discards the attempt.

To reimport legitimately (for example, the bank corrected a file and reissued the new version), you need to receive a file with different content - any change in the content is treated as a new file. If you receive the same file with minimal changes, discuss it with your accountant before importing it to avoid duplicating lines in the reconciliation.

Expected result

• The bank statement is recorded with all its lines, ready to enter a reconciliation.
• Protection against duplicates - the same file cannot be imported twice for the same account.
• Traceability by user and import date for auditing.

Common errors

Related

• Bank accounts
• Bank reconciliation
• Accounting settings