# Convert PDF Bank Statement to CSV for QuickBooks

- Author: SimpleBankConvert (https://www.simplebankconvert.com)
- Published: 2026-01-20
- Updated: 2026-01-20
- Category: PDF bank statements
- Canonical: https://www.simplebankconvert.com/blog/convert-pdf-bank-statement-to-csv-for-quickbooks

> How to convert a PDF bank statement to CSV for QuickBooks Online: the three columns QuickBooks wants, signed amounts and one date format for every row.
To convert a PDF bank statement to CSV for QuickBooks, copy every dated transaction into three columns (date, description, amount), give money out a minus sign, write all dates the same way and save the sheet as CSV. Then check that the opening balance plus the amounts equals the statement's closing balance before you upload.

## Which CSV columns does QuickBooks expect from a bank statement?

QuickBooks Online takes a bank statement CSV in one of two shapes. [Intuit's guide to uploading transactions manually](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) says each file needs either three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit). Pick one shape and use it for every file.

The three-column shape is the one to aim for when you start from a PDF. It has one money column, so each row carries a single number that is either positive or negative. You only have to make one decision per line, and the file is easy to scan by eye afterwards.

The four-column shape keeps money in and money out apart, which is how many statements print them. It looks like less work, because you can copy each column across as it stands. The catch is the mapping screen: you have to tell QuickBooks which column is which, and a swap there turns every deposit into a withdrawal. Intuit's page also asks you to take the word "amount" out of the Credit and Debit headers and to leave a cell blank rather than typing a zero.

### What each column holds

- **Date:** the posting date the statement prints for the line, written in full with the year.
- **Description:** the payee or memo text, joined into one line if the statement wraps it. Intuit's guidance asks you to keep numbers out of this column, so strip stray amounts that were copied in by accident.
- **Amount:** one number, no currency symbol and no thousands separator.

Keep a header row at the top. It gives the mapping screen something to match against, and it reminds you which column is which when you open the file again in six months.

## Copying PDF statement lines into CSV rows

A statement PDF holds more than transactions, and only the dated movements become CSV rows. Work from the account activity table on each page, copy every line that has a date and an amount, and leave out balances, subtotals, headers and notices. Fees and interest count as movements, so they stay.

Start with the right file. If the bank emailed the statement as a locked PDF, you cannot copy text out of it until you open it with the password and save an unlocked copy; [opening a password protected PDF bank statement](/blog/password-protected-pdf-bank-statement) walks through that first step.

### Lines to copy and lines to skip

Copy these:

1. Deposits, transfers in and refunds.
2. Card purchases, checks, transfers out and bill payments.
3. Service fees, overdraft fees and interest paid to you.

Skip these:

1. "Beginning balance" and "Ending balance" rows. They are balances, not money moving.
2. Page subtotals and "balance carried forward" lines.
3. Summary boxes that total the month's deposits and withdrawals. Keep those totals nearby, because they make a good cross-check later, but they are not rows.
4. Daily balance tables that some banks print at the end of the statement.

### Descriptions that wrap

A long payee often runs onto a second printed line with no date and no amount. That second line belongs to the row above. Join it with a single space so each transaction sits on one CSV row. A row in your sheet with text and no amount is nearly always a wrapped description that was copied as its own line.

## Signed amounts in a QuickBooks statement CSV

In a three-column QuickBooks CSV for a bank account, money leaving the account is negative and money arriving is positive. A withdrawal of 86.42 becomes -86.42 and a deposit of 1,250.00 becomes 1250.00. The sign is the only thing that tells QuickBooks which way the money went.

Statements rarely print signs. Most use a pair of columns with labels such as withdrawals and deposits, or debits and credits, and the column a figure sits in is its direction. When you merge the two into one, every figure from the money-out column gets a minus sign and every figure from the money-in column stays as it is. [Turning debit and credit columns into one signed amount](/blog/debit-and-credit-columns-in-pdf-bank-statements) covers the labels banks use and the cases where they read backwards.

After mapping, the QuickBooks upload shows a preview. Intuit's page says that if amounts appear reversed there, you can choose to reverse all values to fix them. Check two or three rows in that preview against the PDF: one deposit, one card purchase and one fee. If all three point the right way, the rest will too.

### A worked example

Here are five example lines from an imaginary March statement, as printed with two money columns. The business, payees and figures are made up. The opening balance is 2,140.00.

| Date printed | Description printed | Withdrawals | Deposits |
| --- | --- | ---: | ---: |
| Mar 3 | ONLINE TRANSFER FROM SAVINGS | | 500.00 |
| 03/07 | CARD PURCHASE MAPLE PRINT / SHOP 114 | 64.90 | |
| 03/12 | MOBILE DEPOSIT REF 7731 | | 1,180.00 |
| 03/19 | ACH DEBIT HARBOR INSURANCE | 212.35 | |
| 03/31 | SERVICE CHARGE | 15.00 | |

The finished three-column CSV, as text:

```csv
Date,Description,Amount
03/03/2026,ONLINE TRANSFER FROM SAVINGS,500.00
03/07/2026,CARD PURCHASE MAPLE PRINT SHOP 114,-64.90
03/12/2026,MOBILE DEPOSIT REF 7731,1180.00
03/19/2026,ACH DEBIT HARBOR INSURANCE,-212.35
03/31/2026,SERVICE CHARGE,-15.00
```

Now prove it. Deposits total 1,680.00. Withdrawals total 292.25. The net is 1,387.75, and 2,140.00 plus 1,387.75 is 3,527.75. If the statement's ending balance reads 3,527.75, the file is complete and every sign is right. If it reads 3,657.55, the gap of 129.80 is exactly twice the 64.90 purchase, which means that one line went in as a positive number.

## One date format for every row of the statement CSV

Every date in the CSV should follow one pattern, with a four-digit year, such as 03/07/2026. Intuit's upload page asks for all dates in the same format. Statements mix styles like "Mar 3" and "03/07", and a sheet that keeps that mix can push some rows into the wrong month or the wrong year.

Two things cause most date trouble when you work from a PDF.

The first is the missing year. Many statements print only the month and day, so you add the year yourself from the statement period. A period that runs from mid-December to mid-January needs care, because lines from the start of the period belong to one year and lines from the end to the next. [Giving statement dates without a year the right year](/blog/pdf-bank-statement-dates-without-year) shows how to handle that boundary.

The second is the spreadsheet. Excel and Numbers try to be helpful with anything that looks like a date and may rewrite it in your computer's regional style when you save. After saving the CSV, open it in a plain text editor and read the date column. What you see there is what QuickBooks will read.

### Picking the format on the mapping screen

The QuickBooks mapping step asks which date format the file uses. Choose the one that matches the text you just checked. If your dates read month first, pick a month-first option; if they read day first, pick day first. A mismatch shows up quickly in the preview as dates in the wrong month, or rows that fail to load.

## Is the statement CSV small enough for the QuickBooks upload?

A single month from a business checking account is almost always small enough. Intuit's upload guide gives a limit of 350 KB per file and up to 1,000 lines per upload, and suggests a shorter date range when a file is bigger. A CSV of text rows takes very little space, so the line count usually binds first.

The line count matters when you convert a year of statements at once. A busy account with forty transactions a day passes 1,000 lines in under a month. Split the work by statement period instead: one CSV per month, uploaded in date order. Each file then lines up with one PDF, so the balance check has a clear opening and closing figure to prove against.

Intuit's page also advises that the file should start at least one day before the oldest transaction already in that QuickBooks account, and for an existing account, the day after the last one. In plain terms, do not overlap what is already there. If the bank feed has already brought in March 20 onward, cut your March CSV at March 19.

If you would rather join several months into one file, the same ordering and balance rules apply, and [combining PDF bank statements into one file](/blog/combine-pdf-bank-statements-into-one-qbo-file) explains how to check that each closing balance meets the next opening balance. When the file is ready, [uploading bank statements to QuickBooks Online](/blog/how-to-upload-bank-statements-to-quickbooks-online) covers each screen and the final balance comparison after import.

## When a statement CSV is the wrong file for QuickBooks

A bank statement CSV is the right tool for one job: adding bank or credit card transactions to a QuickBooks Online account. For other jobs it is the wrong file, even when the data started on a PDF, and forcing it costs more time than it saves.

### QuickBooks Desktop bank imports

QuickBooks Desktop brings bank activity in through Web Connect, and [Intuit's Desktop bank feeds article](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-feeds/download-bank-feed-transactions-quickbooks-desktop/L8o0Aw9VM_US_en_US) states that Web Connect only works with .qbo files. If your books live in Desktop, convert the PDF to QBO instead. A QBO file is also handy in Online when you want to skip the mapping screen.

### Records that are not bank lines

Some PDFs hold numbers that look like transactions but belong somewhere else in the books. Sales orders, purchase orders, invoices and customer lists each have their own import, with their own columns, and in some cases only certain editions take them. [Importing sales orders into QuickBooks](/blog/quickbooks-import-sales-orders) is one example of a record that a bank CSV cannot carry.

### Statements you cannot read cleanly

A scanned or photographed statement turns into text only after character recognition, and a blurred digit becomes a wrong amount in the CSV. The balance check above will catch most of those, but if a statement fails it more than once, typing the handful of lines by hand is often quicker than hunting the bad digit.

If you would rather not build the sheet yourself, SimpleBankConvert is being made to turn a statement PDF into a CSV or QBO file with the dates already in one format and the two money columns already merged. Accounts are not open yet; the [get started page](/get-started) lets you leave your email for when they are.