QuickBooks will not take your credit card statement PDF through the normal import path, the connected feed usually reaches back only about 90 days, and a manual upload caps out at 1,000 lines. Upload the card statement here and download a QBO file that imports like a real bank download, or a CSV with the charges already signed the way a credit card account expects.
Last updated July 2026
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
QuickBooks Online accepts .csv, .txt, .qbo, and .ofx files under Transactions, then Bank transactions, then the Link account dropdown, then Upload from file. Pick the credit card account as the destination, not a bank account. QuickBooks Desktop is narrower: its reliable native path is a Web Connect .qbo file through File, then Utilities, then Import, then Web Connect Files. Neither one imports a statement PDF on that path, so convert the PDF to QBO or CSV first. In a CSV, charges must be negative and payments positive, which is the opposite of how most card issuers export their own files.
Bank statements import cleanly. Credit cards are a different account type with a different sign rule, a shorter feed, and a statement that usually arrives as a PDF. Here is where people get stuck.
When you connect a card, QuickBooks Online pulls roughly the last 90 days. Some issuers expose more, but anything older than the connection offers has to be uploaded by hand.
Most issuers export purchases as positive numbers. Feed that straight into a QuickBooks credit card account and every charge lands on the payment side, so your balance moves the wrong way.
QuickBooks Online takes up to 1,000 transactions per upload and the file must be 350 KB or less and in English. A busy card year needs to be split into several files.
Desktop has no native CSV import for bank or credit card transactions, and QIF does not work for these accounts either. Web Connect .qbo is the path that actually works.
Closed cards, corporate card programs, and periods older than the download window often exist only as a PDF statement, which the normal import path will not accept.
A description cell that is purely numeric, a cell holding only 0, a dollar sign in the amount, or a weekday stuck onto the date will all stop a CSV at the door.
Upload the credit card statement PDF and download a file QuickBooks accepts, with the transaction table already parsed and the amounts already pointing the right way.
Export a .qbo file that both QuickBooks Online and QuickBooks Desktop import like a genuine bank download, with account matching and duplicate detection.
Purchases come out negative and payments and refunds positive, so a credit card account posts the right way instead of backwards.
Choose the three column Date, Description, Amount layout or the four column Date, Description, Credit, Debit layout that the upload wizard maps without complaint.
Convert a whole year of statements at once and export the rows in batches that clear the 1,000 line and 350 KB limits.
Amex, Chase, Capital One, Citi, Discover, Bank of America, Wells Fargo, U.S. Bank, and the rest, including closed accounts with no feed left.
Dollar signs, thousands separators, stray zeros, and numeric-only descriptions are handled before you ever reach the mapping screen.
Works for QuickBooks Online and QuickBooks Desktop, and for cards no longer connected to a feed.
Drop the card statement PDF into the box above. Add several months at once if you are filling a gap the feed never covered.
Tip: Password protected statements work.
Choose the .qbo Web Connect file for the cleanest import, or CSV if you would rather map the columns yourself.
Tip: QBO carries duplicate detection, CSV does not.
In QuickBooks Online go to Transactions, Bank transactions, Link account, Upload from file. In Desktop use File, Utilities, Import, Web Connect Files.
Tip: Select the credit card account, never a bank account.
Almost always someone closing a month against a card the bank feed cannot reach.
Fill the gap before the feed started, or catch up a client who has ignored a card for eight months.
Load a year of client card history for a cleanup engagement or a tax return without keying a line.
Bring corporate card programs that offer no QuickBooks feed into the ledger on a monthly cycle.
Get charges from a closed or cancelled business card into the books so the year actually reconciles.
QuickBooks Online accepts four file types on the manual upload path: .csv, .txt, .qbo, and .ofx. QuickBooks Desktop is stricter. Its dependable native route for bank and credit card transactions is a Web Connect .qbo file, and Intuit support consistently tells Desktop users to convert other formats into .qbo first. Neither product takes a PDF statement on this path, which is the single fact that sends most people looking for a converter.
| File type | QuickBooks Online | QuickBooks Desktop |
|---|---|---|
| QBO (Web Connect) | Yes, the cleanest option | Yes, the only reliable native path |
| CSV | Yes, with a column mapping step | No native import for transactions |
| TXT | Yes | No |
| OFX | Yes | Intuit directs users to convert to QBO |
| QIF | No | No, not for bank or card accounts |
| PDF statement | Not on the standard upload path | No |
Intuit has been rolling an AI assisted statement upload into some QuickBooks Online plans that reads a PDF or an image and shows you what it pulled out. Availability varies by plan, you still review every extracted row, and it does not help Desktop at all, so a converted QBO or CSV remains the route that works everywhere.
In a QuickBooks credit card account, a charge must be a negative number in the Amount column and a payment or refund must be positive. That rule surprises people because card issuers write their exports from their own point of view, listing purchases as positive. Import an untouched issuer file and every purchase posts as a payment, which walks your card balance in the wrong direction.
| Transaction | Sign QuickBooks expects | Four column layout |
|---|---|---|
| Purchase or charge | Negative | Debit column |
| Fee or interest | Negative | Debit column |
| Cash advance | Negative | Debit column |
| Payment to the card | Positive | Credit column |
| Refund or statement credit | Positive | Credit column |
If you are fixing an issuer export by hand, the usual trick is a helper column that multiplies the amount by negative one, then paste the result back as values. The four column layout sidesteps the problem entirely, because you place each amount in the Debit or the Credit column and never argue about a sign. A converted file arrives already signed, which is why most people stop editing spreadsheets after the first month.
The upload wizard understands a three column file with Date, Description, and Amount, or a four column file with Date, Description, Credit, and Debit. Dates must all use one format, descriptions cannot be purely numeric, cells holding only a zero should be left blank, and currency symbols and thousands separators have to go. Keep the file under 1,000 transactions and 350 KB, in English, or the upload is rejected before mapping.
Convert the statement first, then follow the upload path. Go to Transactions, then Bank transactions, open the Link account dropdown, and choose Upload from file. Drag in the .qbo or .csv file. On the next screen choose the QuickBooks account, and this is the step that matters: select the credit card account, not a checking account. Map the columns if you brought a CSV, confirm the date format QuickBooks guessed, and import. The transactions land in For Review, where you categorize them and match anything the feed already brought in.
Desktop needs a Web Connect .qbo file. Convert the statement, then go to File, Utilities, Import, Web Connect Files, or take the equivalent route through Banking, Bank Feeds, Import Web Connect Files. Choose the file and associate it with the credit card account. Desktop will not read a CSV of transactions and will not take a QIF for a card account, so any guide telling you to import a spreadsheet directly is describing a third party add on, not QuickBooks. Worth knowing: Intuit stopped selling new QuickBooks Desktop Pro, Premier, and Mac subscriptions to US customers in 2024, while existing subscribers keep renewing and Enterprise is still sold.
Almost every rejected file fails for one of a handful of reasons, and the error message rarely names the row.
| What went wrong | The fix |
|---|---|
| Mixed date formats, or a weekday inside the date cell | Use one format for every row and move the weekday to its own column |
| A description that is nothing but digits | Add text or clear the cell, since a bare reference number is rejected |
| Cells containing only 0 | Leave them blank |
| Dollar signs, commas, or symbols in Amount | Strip them and store a plain signed number |
| More than 1,000 rows or over 350 KB | Split the period into smaller files |
| A four column file with only money out and no money in | Add an offsetting line, or switch to the three column layout |
Importing is only half the month. Open Reconcile, pick the card, and enter the statement ending balance and ending date exactly as the statement prints them, remembering the card cycle rarely ends on the last day of the month. Clear each line until the difference reads $0.00, then record the payment to the card so it matches the checking feed later instead of doubling up. If you want the whole workflow, see how credit card reconciliation software compares.
The same conversion feeds more than QuickBooks. Export to Excel when you want to sort and total the year for a tax return, using the credit card statement to Excel converter, or start from your issuer page for Chase, Capital One, Citi, or Bank of America. Checking and savings statements follow the same route through the bank statement to QBO converter. If you only ever move statements into QuickBooks, a dedicated bank statement to QuickBooks converter does that one job, and if your data already sits in spreadsheets a CSV to QBO converter handles the last mile.
Yes, but not as a PDF on the standard path. QuickBooks Online takes .csv, .txt, .qbo, and .ofx files, and QuickBooks Desktop takes a Web Connect .qbo file. Convert the statement PDF into one of those formats, then upload it to the credit card account. A .qbo file imports like a real bank download, complete with duplicate detection.
Convert the PDF to a .qbo or .csv file, then go to Transactions, Bank transactions, open the Link account dropdown and choose Upload from file. Select the file, choose the credit card account as the destination, map the columns if it is a CSV, and import. The rows arrive in For Review for categorizing.
Charges are negative and payments and refunds are positive in the Amount column of a QuickBooks credit card account. Card issuers usually export purchases as positive numbers, so an untouched issuer file posts every charge as a payment. Either flip the sign or use the four column layout and place amounts in the Debit and Credit columns.
Up to 1,000 lines per upload, in a file of 350 KB or less, written in English. A full year on an active card usually exceeds that, so split the period into several smaller files and upload them one after another. Each upload targets the same credit card account.
No. QuickBooks Desktop has no native CSV import for bank or credit card transactions, and QIF does not work for these account types either. The path that works is a Web Connect .qbo file through File, Utilities, Import, Web Connect Files. Anything else relies on a third party add on.
A newly connected card typically brings in roughly the last 90 days. Some issuers expose more history, occasionally up to about two years, but it depends entirely on what the card issuer offers. Anything older than the feed reaches has to come from statements you upload yourself.
Either three columns, Date, Description, and Amount, or four columns, Date, Description, Credit, and Debit. Use one date format throughout, remove currency symbols and commas, leave zero-only cells blank, and never use a purely numeric description. Those five rules prevent most rejected uploads.
Because the amounts were positive. QuickBooks reads a positive number in a credit card account as money paid toward the balance. Multiply the amount column by negative one, or rebuild the file with separate Debit and Credit columns, then import again. Deleting the reversed batch first avoids duplicates.
Yes. A closed or cancelled card has no feed to connect, so the statement PDF is the only remaining record. Convert it the same way and upload the file to the credit card account in QuickBooks, which is the usual reason bookkeepers reach for a converter during a cleanup.
Uploads are encrypted in transit with 256-bit encryption, you can delete your files whenever you want, and your financial data is never resold or shared. As with any financial document, check where a tool stores your file and how long it keeps it before you upload.
Convert any card statement PDF to Excel or CSV.
How the reconciliation tools actually compare.
The same conversion for checking and savings.
The IIF route into QuickBooks Desktop.
The step-by-step guide for bank accounts.
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
