Guide
How to import bank and credit card statements into QuickBooks Online
QuickBooks Online can import transactions from a CSV, QBO or QFX file, and it can also read a PDF or image of the statement itself. This page covers the CSV route for a bank account and a credit card account: the file QuickBooks expects, what changes for a card, the errors that stop an upload, and a recorded walkthrough of the whole import. MatchLedger reads your statement from a PDF, CSV or Excel file. It then writes the CSV that QuickBooks Online imports. See how MatchLedger works.
Recorded September 2026
What the walkthrough says
Recorded September 2026
- From bank statement to posted transactions, with zero manual entry. See how MatchLedger extracts your bank statement data, exports it in a QuickBooks-ready format, and gets it automatically matched, categorized, and posted, without retyping a single transaction. Click Get Started to see it in action.
- Upload your bank statement to get started.
- Select your statement file.
- Click Upload. MatchLedger takes it from here.
- Feel free to close this. We'll email you when it's ready.
- Export your extracted transactions.
- Pick your accounting software for the right format.
- Choose QuickBooks Online, or whichever accounting software you use.
- Download your CSV, ready for QuickBooks.
- Open Bank transactions in QuickBooks.
- Click Upload transactions to import your file.
- Choose the account for these transactions.
- Open the account dropdown.
- Upload the CSV you exported.
- Select the destination account.
- Pick your bank account.
- Click Continue.
- Match the date format to your file.
- Click Continue to confirm mapping.
- Select all to import the full batch.
- Click Done to finish the import.
- Once the file's imported, QuickBooks takes it from here, automatically.
- Set a rule once. Every matching transaction gets categorized automatically from here on.
- QuickBooks suggests categories too, even without a rule.
- Existing bills and invoices? Matched automatically.
- Once you've reviewed everything, check all the transactions and click the Match/Post button. They'll all be posted at once.
- Everything's posted. Head to the bank register to see it all reflected.
- Zero manual entry. Fully posted.
- Now your entire statement is posted in your bank register. No manual entry, even if you've got hundreds or thousands of transactions. That's MatchLedger: from statement to accounting software, in minutes instead of hours.
The file QuickBooks Online accepts
| What | What QuickBooks Online needs | What MatchLedger's export writes |
|---|---|---|
| File type | A CSV, QBO or QFX file for a list of transactions. A PDF or image of the statement (JPG, PNG, HEIC) goes through a separate statement upload. | A CSV file. Several statements at once come back as a ZIP with one CSV per statement. |
| Columns | Three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit), with the headings in the first row. The word amount comes out of the Credit and Debit headings. | Three columns with a heading row: Date, Description, Amount. |
| Amount sign | In the three column layout, money out is negative and money in is positive: -100.00 is a payment, 200.00 a deposit. | Bank: withdrawals negative, deposits positive. Card: charges negative, payments and credits positive. |
| Amount cells | Plain numbers: no currency symbols or commas, and a cell that only holds a zero left blank. An amount of 12 or more digits is rejected. | Plain signed numbers with no currency symbol. |
| Date format | Every date in one format, the same one you choose when mapping the columns. Intuit recommends dd/mm/yyyy. A day of the week written into the date cell needs its own column. | MM/DD/YYYY for a statement written month first. A statement written day first exports as YYYY-MM-DD, which QuickBooks detects. |
| Limits | Up to 1,000 lines per upload, one transaction per line, 350 KB or less, in English. | One CSV per statement, so each file covers one statement period. |
Pick QuickBooks Online when you export from MatchLedger and the file comes out in this shape, with no column to delete or heading to rename. Both of its QuickBooks Online exports, bank and card, are marked Verified in the app, each checked with a live import into QuickBooks Online. See the supported exports.
QuickBooks Online upload limits. Which upload path the 350 KB and 1,000 line limits belong to, and what to do when a file is over them.
Importing a credit card statement
- It goes into a credit card account. A card is a liability, so its statement belongs in a credit card account, not a bank account. In QuickBooks Online, Intuit's guidance is to choose the credit card account, not a bank account, when you upload the file. If the card has no account yet, add it as a credit card account first.
- The signs flip. On a card, a charge increases what you owe and a payment reduces it, the opposite of a bank account, and QuickBooks Online expects its own convention for which is which. Intuit notes that a card's file can show amounts the opposite way round to a bank's, and that choosing the credit card account at upload is what gets them added correctly.
- A card payment is a transfer. The payment leaves your bank account and arrives on the card, so it shows up on both statements. Match it once as a transfer, rather than booking it twice as an expense and as income. QuickBooks Online suggests a match for a transfer or card payment of the same amount dated from 90 days before to 20 days after, and pairs the bank side with the card side so the payment is recorded once.
MatchLedger's QuickBooks Online card export writes charges as negative amounts and payments as positive ones, the convention confirmed by a live import into a QuickBooks Online credit card account. See the export formats.
How to import a credit card statement into QuickBooks Online. The card in detail: closed cards with no feed, the transaction date against the post date, and reconciling the card.
Common QuickBooks Online import errors
Why does QuickBooks say the uploaded file is of a different type than these accounts?
QuickBooks shows this error when the file belongs to a different kind of account from the one you picked, for example savings transactions uploaded into a checking account. Go back and choose the account the statement belongs to. A credit card statement goes into the credit card account, not a bank account.
Why won't QuickBooks Online accept my CSV file?
Most rejected uploads break one of Intuit's file rules: more than 1,000 lines or more than 350 KB, a layout other than three or four columns, currency symbols or commas in the amounts, special characters in the descriptions, or dates in a different format from the one chosen when mapping. Fix the file against those rules and upload it again, splitting a long period into shorter date ranges if it is over the limits. MatchLedger's QuickBooks Online export writes plain amounts in the three column layout, one file per statement.
Why are my credit card charges showing up as payments in QuickBooks?
Either the file went into a bank account instead of the credit card account, or its signs are the opposite of what QuickBooks expects for a card. Check the account first. If the account is right, delete the wrongly imported transactions before uploading a corrected file, so nothing is counted twice. MatchLedger's card export writes charges as negative and payments as positive, the convention confirmed by a live import into a QuickBooks Online credit card account.
Why did my dates import as the wrong month in QuickBooks?
A date written day first, such as 03/09/2026 for 3 September, reads as 9 March when the file is mapped as month first, and every date with a day of 12 or less imports without an error. Keep every date in the file in one format and choose that same format when mapping the columns. MatchLedger exports a statement written day first with YYYY-MM-DD dates, which cannot be read the wrong way round.
Why do I have duplicate transactions after importing a bank statement into QuickBooks?
Usually the uploaded statement overlaps dates a bank feed already brought in, or a card payment was added on both the bank account and the card account. Intuit's guidance is to start the uploaded statement at least one day before your oldest QuickBooks transaction in that account. Where an imported line is already in your books, match it to the existing transaction instead of adding it again.
QuickBooks bank rules and auto-match. Once the transactions are in, set up the rules and matching that code them for you.
Imported is not the same as reconciled
An import checks the shape of the file, not whether it holds every transaction the statement lists. Once the month is in QuickBooks Online, reconcile the ledger back against the statement itself, so a missing or duplicated transaction shows up before you close the month rather than after. Extraction gets the data in. Reconciliation is what lets you say the month is right. See how MatchLedger does both.
Turn your bank and credit card statements into a CSV for QuickBooks Online, then reconcile the month against the statement.
Start FreeOnly one statement to do? Convert it with the free converter.