Conversion guide
How to convert a bank CSV to QBO
Turn a bank CSV export into a QBO file with the correct dates, amounts, account type, and transaction IDs.
Read the guideConversion library
Cleaner files. Safer imports.
Learn how to prepare bank exports, map columns, choose an account type, diagnose import problems, and verify the result before it reaches your books.
Import workflow
Prepare bank transactions for a QuickBooks import
A pre-import checklist for cleaner QuickBooks bank transaction uploads and fewer duplicate or misclassified entries.
Read the guideColumn mapping
How to map date, description, amount, debit, and credit columns
Understand common bank CSV layouts and map transaction dates, descriptions, signed amounts, debits, credits, memos, and IDs correctly.
Read the guideTroubleshooting
Troubleshoot a QBO file that will not import
Diagnose account, date, amount, duplicate, and file-selection problems when a generated QBO file cannot be imported.
Read the guideFile formats
QBO vs OFX, QFX, CSV, and IIF
Compare common financial file formats and understand what Bank2QBO creates for bank-transaction import.
Read the guideAccount workflow
Checking vs credit card transaction imports
Choose the correct QBO account type and sign convention for checking, savings, and credit card CSV exports.
Read the guideWorked examples
Sample bank CSV layouts and mapping examples
See signed-amount and separate debit/credit CSV examples, plus the correct Bank2QBO mapping for each layout.
Read the guideStart with your situation
Pick the shortest path to a reliable test
| If you need to… | Start here | Then verify |
|---|---|---|
| Convert a normal bank export | CSV-to-QBO walkthrough | Dates, signs, count, and account type |
| Understand unfamiliar headings | Column-mapping guide | Signed amount versus separate debit/credit |
| Prepare a historical import | Import preparation checklist | Non-overlapping periods and destination account |
| Diagnose a rejected file | QBO troubleshooting guide | A minimal two- or three-row test |
| Separate checking and card activity | Account workflow comparison | Purchases, payments, refunds, and transfers |
What these guides can do
Preparation guidance, not automated bookkeeping
Fictional examples
Examples are invented to explain file structure. Never import them into production books or treat them as accounting entries.
Version-aware instructions
QuickBooks menus and accepted workflows can change. The guides explain preparation principles and tell you when to consult current product documentation.
Private practice
Use a short export from the intended account for testing. The converter processes it locally and never asks for bank or QuickBooks credentials.
Ready to convert?