Bank Feed Connectors
This course covers automatic bank feed connectors in Quickenerp: connecting a live bank/payment provider feed (Plaid, GoCardless, Stripe, PayPal, Wise, Ponto) so transactions import automatically instead of manual file upload, plus the file-based import formats (OFX, CAMT, CSV) for banks without a live connector.
| Responsible | System |
|---|---|
| Last Update | 07/21/2026 |
| Completion Time | 1 day 12 hours |
| Members | 1 |
When There's No Live Connector for Your Bank
Most banks let you export a statement file from their own online banking portal — download it and import it manually into the matching journal.
Supported Formats
| Format | Common In |
|---|---|
| OFX | Widely supported by North American and many other banks. |
| CAMT.053 / CAMT.054 | European SEPA-standard bank statement format. |
| Generic CSV / Spreadsheet | Any bank export, mapped manually to date/description/amount columns on first use. |
| Move Line Import | Importing already-categorised statement lines directly as journal entries. |
Importing
- Open the bank journal → Import.
- Select the downloaded file.
- For CSV/spreadsheet formats, map each column once — the mapping is remembered for future imports of the same format.
- Review the preview and confirm.
Reconciliation afterward works identically whether transactions arrived via a live feed or a file import.
Bank Feeds Overview
View allWhen There's No Live Connector for Your Bank
Most banks let you export a statement file from their own online banking portal — download it and import it manually into the matching journal.
Supported Formats
| Format | Common In |
|---|---|
| OFX | Widely supported by North American and many other banks. |
| CAMT.053 / CAMT.054 | European SEPA-standard bank statement format. |
| Generic CSV / Spreadsheet | Any bank export, mapped manually to date/description/amount columns on first use. |
| Move Line Import | Importing already-categorised statement lines directly as journal entries. |
Importing
- Open the bank journal → Import.
- Select the downloaded file.
- For CSV/spreadsheet formats, map each column once — the mapping is remembered for future imports of the same format.
- Review the preview and confirm.
Reconciliation afterward works identically whether transactions arrived via a live feed or a file import.
Transactions That Arrive Without You Doing Anything
Instead of downloading a statement file from your bank and importing it manually (see the Accounting course's Bank Reconciliation article for that flow), a Provider connects directly to your bank or payment processor and pulls new transactions automatically on a schedule.
Supported Providers
| Provider | Typical Use |
|---|---|
| Plaid | Broad bank account aggregation, especially North American banks. |
| GoCardless (Open Banking) | European Open Banking bank connections and Direct Debit collection. |
| Ponto | Belgian/European bank account aggregation (Isabel Group). |
| Stripe | Pulls in your Stripe payment processor's own transaction/payout activity as a feed. |
| PayPal | PayPal account transaction history as a feed. |
| Wise | Multi-currency Wise account balances/transactions. |
If your bank isn't covered by a live connector, file-based import (OFX, CAMT.053, generic CSV/spreadsheet formats) still works exactly as before — see the last article in this course.
Once Transactions Arrive Automatically
Auto-pulled transactions land in the bank journal exactly like a manually-imported statement line — the daily habit doesn't change, just the manual download/upload step disappears. Go to Accounting > Bank > Reconciliation as usual (see the Accounting course's Bank Reconciliation article for the matching mechanics).
What's Different With Payment-Processor Feeds
A Stripe or PayPal feed brings in gross transaction amounts, which typically need matching against your actual invoice (net of processor fees) — the processor's own fee is usually a separate small deduction. Set up a small automated reconciliation rule for recurring processor fees so they're not manually categorised every single time.
Duplicate Prevention
If you ever also manually import a statement file covering a period a live feed already pulled, Quickenerp detects and skips transactions it recognizes as already imported (matched by the bank's own transaction reference) rather than creating duplicates — but it's still good practice not to mix both methods for the same account routinely.