Import bank transactions from CSV or a bank file
Download a sample CSV, map dates and amounts, fix common import problems, and review the transactions in Bokeping.
In BokepingBanking → Bank transactions
Import bank transactions from a CSV when you already have a statement download or need to fill a gap in your bank feed. Map the file to the correct account, check the preview, then review the imported activity before treating it as part of your books.
Where to go: Banking → Bank transactions → select an account → Import.
Download a sample bank CSV
Section titled “Download a sample bank CSV”Two fictional USD bank rows dated September 28, 2026: a $350 receipt and a $300 withdrawal. Uses separate Withdrawal and Deposit columns. Free download; no signup required.
Use this file to inspect the layout or practise in a demo company. It recreates the $350 receipt and $300 withdrawal illustrated below, with simple demo payee labels. Do not import these fictional rows into your live company. For your own books, keep the headers and replace both rows with your actual statement activity.
The file does not select or create a bank account. Choose a USD demo bank account whose opening balance date is on or before September 28, 2026 if you want to preview the sample unchanged. Your real import must use the actual statement dates and the appropriate account and currency.
| Sample column | Map to in Bokeping | What to check |
|---|---|---|
| Date | Bank Date | 2026-09-28 means September 28, 2026. |
| Withdrawal (money out) | Spent (Withdrawal) | The supplier payment is 300.00. |
| Deposit (money in) | Received (Deposit) | The customer receipt is 350.00. |
| Bank Merchant / Payee | Bank Merchant / Payee | A statement label; it does not create a customer or vendor. |
| Bank Description | Bank Description | Keep the statement’s description. |
| Bank Reference / Transaction ID | Bank Reference / Transaction ID | Keep the reference for checking the source activity. |
Choose Separate spent / received columns for this file. Leave the unused amount cell empty on each row; enter plain numeric amounts such as 350.00, without a currency symbol. With both rows included, the preview should show 2 ready rows, $300 spent and $350 received if the target account and dates meet the import conditions. Repeated uploads may be flagged as duplicates.
Check every mapping even when columns are selected automatically. In the current workflow, Bank Reference / Transaction ID may remain Not imported for this sample: choose its matching file column manually. Memo can stay Not imported because the sample has no separate bookkeeping note.
Choose a file
Section titled “Choose a file”| Format | How it is handled |
|---|---|
| CSV, XLSX, XLS | Map your columns to the fields requested in the next step. |
| OFX, QFX, QBO | Date, amount, description, and reference are read from the structured bank file. Custom columns are not supported. |
The upload screen accepts files up to 5 MB. A .qbo file contains bank or card activity, not a complete QuickBooks Online company backup.
Free includes bank CSV import. You can upload a statement without connecting your bank. If you want transactions to sync automatically, compare file import with Plaid bank feeds. Plaid feeds require Standard, Pro, or an active Pro trial. Company access and import permissions still apply, as do plan limits when creating sales or purchase records. See plans and usage limits.
Upload and review
Section titled “Upload and review”- Open the correct company and select the bank or credit card account in Bank transactions.
- Choose Import. Check Importing to before choosing a file; it shows the target account and currency.
- If preparing a spreadsheet, use Download template to check the columns. Replace sample rows with your actual statement activity; merchant labels describe the bank activity and do not create contact records.
- Choose the file, then select Next. For spreadsheets, review the column mapping, including dates and money-in or money-out amounts.
- Review the rows and validation messages. Correct errors and investigate potential duplicates before confirming the import.
- Review Results. Return to the selected account’s For review tab (called Pending in the earlier walkthrough) and compare the imported date range and amounts with the statement.
Example: one receipt and one withdrawal
Section titled “Example: one receipt and one withdrawal”The screenshots show the earlier demo walkthrough with a $350 customer receipt and $300 supplier payment. Both already had bookkeeping records, so the imported rows were ready to be matched. The downloadable CSV recreates the amounts and date; a new company will not already have those records.

Use one amount format consistently. In this sample, money out maps to Spent and money in maps to Received. The target is Checking Account, USD.

The two Demo rows were imported successfully and verified in Pending. Importing them did not add another $350 receipt or $300 payment to the ledger. Your statement dates and amounts will differ.
After a successful import, the app may return directly to the account. Confirm the new rows in For review even if the Results screen is no longer open. Next, match to the existing records.
Avoid overlapping imports
Section titled “Avoid overlapping imports”If you also use a bank feed, identify the exact missing range first. Do not import a whole statement repeatedly just because one transaction is missing.
Check both Posted and Excluded before deciding a row was not imported. Match activity to records already in your books rather than categorizing it as another sale or expense.
If the file is rejected
Section titled “If the file is rejected”A date is rejected or appears in the wrong month
Section titled “A date is rejected or appears in the wrong month”An ambiguous date such as 03/04/2026 can be read differently from what you intended. If the statement means April 3, 2026, use 2026-04-03 in the CSV, save it, upload the corrected file and check the preview again. A date such as 2026-02-30 is not a real day: correct it from the original statement, rather than guessing.
If a transaction is earlier than the account’s opening balance date, check the selected account and your opening balances. Do not move genuine transactions to a later date merely to make the file import.
Money in appears as money out
Section titled “Money in appears as money out”For the downloadable sample, a preview of $350 spent and $300 received means the two amount columns are reversed. Return to mapping: Withdrawal goes to Spent, Deposit goes to Received. Check for $300 spent and $350 received after the correction.
If your own bank export has a single signed Amount column, select One amount column instead. The preview asks What do positive amounts mean? Choose Received or Spent from the bank’s actual convention, and check a known receipt and withdrawal. This setting does not fix swapped separate columns; correct those mappings directly.
An amount is missing or not numeric
Section titled “An amount is missing or not numeric”Each activity row needs an amount. A blank on one side is normal for the sample’s separate columns; both sides blank leave the row without an amount. Replace text such as three hundred with the verified number 300.00. Keep notes in the description column. Remove empty rows or spreadsheet totals that are not bank transactions, then recheck the number of included rows and the totals.
The file belongs to a different account, or includes repeated activity
Section titled “The file belongs to a different account, or includes repeated activity”Check Importing to, the currency and the statement’s date range before confirming. A CSV does not reliably identify the destination bank account for you. Cancel and restart in the correct account if the target is wrong.
For overlapping imports, inspect For review, Posted and Excluded and investigate any duplicate messages. Match activity already recorded in the books instead of creating another sale or expense. See duplicate bank transactions.
The file cannot be uploaded, or no rows appear
Section titled “The file cannot be uploaded, or no rows appear”Check the format and the 5 MB limit. A header-only spreadsheet contains no transactions. If a file is too large, split it into smaller, non-overlapping date ranges while preserving the header row. For a structured bank file, download a fresh copy from your bank instead of renaming another file to .qbo or .ofx. A PDF bank statement is not one of the accepted import formats.
If only some rows succeed, review the results before retrying. Keep the source file and import result so you can identify what has already been brought in.
New to Bokeping? Start with your own bank file
Section titled “New to Bokeping? Start with your own bank file”You can download the sample before creating an account. To import your own activity:
- Create your account, verify your email or continue with Google, and complete company setup.
- Select or add the bank account that represents the statement. Use the appropriate Bank or Credit Card account type, and check its currency and opening balance date; you do not need to connect a live bank feed for file import.
- Open Banking → Bank transactions, select that account, and choose Import. Upload your actual bank file, map the columns and inspect the preview.
- Confirm the intended rows, then review and match them. Importing alone does not confirm that they are posted to the general ledger. Check the outcome of any applicable Auto-add rules as well.
- When your records are ready, reconcile to the statement.
Create a free Bokeping account · Already have an account? Log in to Bokeping.
Signup creates access to your workspace; it does not copy the demo company or its transactions. Use a demo company for practice and actual statement activity for your own books.
Frequently asked questions
Section titled “Frequently asked questions”Can I import a bank CSV on the Free plan without connecting a bank?
Yes. Free includes bank CSV import without a live bank connection. You need company access, a suitable bank or credit-card account, and permission to import. Automatic bank feeds require Standard, Pro, or an active Pro trial. Plan limits and permissions still apply when you create the underlying sales or purchase records.
Do I need to register to download or use the sample?
No account is needed to download and inspect the CSV. To try the import workflow in Bokeping, sign up, verify your email or continue with Google, complete company setup, and select a demo bank account. The sample contains fictional rows and does not create a company, a bank account, customers, invoices, or bills. Keep it out of your live books.
How should I map the sample's amounts?
Choose Separate spent / received columns. Map Withdrawal (money out) to Spent (Withdrawal) and Deposit (money in) to Received (Deposit). With both sample rows included, check for $300 spent and $350 received. If they are reversed, correct the column mapping before importing.
How do I avoid importing a date in the wrong month?
Check dates against the statement and use an unambiguous YYYY-MM-DD value in the CSV. For example, write April 3, 2026 as 2026-04-03 rather than 03/04/2026. Recheck the preview after correcting the file. Dates before the target account's opening balance date are rejected; do not change genuine transaction dates merely to pass validation.
What if my CSV has one Amount column?
Choose One amount column and map Amount. In the preview, explicitly choose whether positive values in your file mean Received or Spent, based on the bank's export convention. Check a known receipt and withdrawal before importing. This sign choice is for a single Amount column; reversed separate columns need their mapping corrected.
Does a successful import mean the transactions are in the general ledger?
Importing bank activity creates review rows; it is not by itself proof that the rows have been posted to the ledger. Match existing records or review the appropriate categorization, and check the status of any applicable Auto-add rules. Do not record the same receipt or payment a second time.
Does importing a QBO file migrate my complete QuickBooks company?
No. QBO, QFX and OFX bank files contain bank or card activity. They do not provide a complete QuickBooks company backup or transfer all customers, invoices, bills and historical accounting data.
For skipped rows, mapping problems, or an interrupted result, see import recovery.