Bank Account Setup & Transactions

Bank Account Setup

Go to Accounting > Configuration > Journals → Create a journal of type "Bank".

Setting Up a Bank Journal

1. Name: e.g. "Main Checking Account".
2. Type: Bank.
3. Short Code: e.g. "BNK".
4. Default Account: Select the bank account from the chart of accounts.
5. Currency: Leave blank for company currency, or set to EUR/USD for foreign accounts.
6. Bank Feeds: Configure automatic bank statement import (see below).
7. Save.

Bank Statement Import

Quickenerp supports importing bank statements in multiple formats:

• CODA - Belgian format.
• CSV/Excel - Generic format with column mapping.
• OFX/QFX - Open Financial Exchange.
• CAMT.053 - ISO 20022 XML bank statement.
• SAP - SAP bank statement format.
• Auto-Sync (PAIN) - Direct API connection with supported banks (via third-party connectors).

Importing a Bank Statement

1. Go to the Bank Journal → click Statements → Import.
2. Select your file (CSV, OFX, etc.).
3. Map columns: Date, Label, Debit, Credit, Balance. Quickenerp auto-detects common formats.
4. Click Import. The statement appears as a new bank statement.
5. Each line becomes a statement line ready for reconciliation.

Recording Manual Bank Transactions

To record a bank transaction without a statement:

1. Open the Bank Journal → click Add a Line.
2. Enter date, label, debit or credit amount.
3. Save. The line appears in the bank statement for reconciliation.