Bank statement converter

Convert PDF and scanned bank statements to Excel, CSV, QuickBooks, Xero and Quicken files. Every balance is checked against the statement before you download.

Drop bank statements here PDF, JPG, PNG or HEIC. Up to 20 files at once.

Choose files

First 10 pages free. No card needed. Make a free account to upload and download.

Download asExcelCSVQBOOFXQIFJSONor send to QuickBooks and Xero

What one bank statement turns into

A sample Chase business checking statement, and the rows LedgerBox returns for it. The balance check runs before anything downloads.

Sample

ChaseBusiness checking ••4417Kramer Mfg LLC

Statement of accountMarch 1, 2026 through March 31, 2026

Beginning balance$12,450.33

Deposits and additions18,420.19

Checks paid-3,450.00

Electronic withdrawals-5,759.85

Ending balance$21,660.67

Deposits and additions

03/02ACME PAYROLL DIR DEP$4,250.00

03/05WIRE IN DANA R75.00

03/09STRIPE TRANSFER2,318.40

Checks paid

03/02CHECK 1042$1,200.00

Electronic withdrawals

03/03CON EDISON PAYMENT$184.62

03/06PAPER TRAIL SUPPLIES642.18

03/10INK + PAPER CO96.25

03/12ADP PAYROLL FEE58.00

Page 1 of 4. Made-up account. Chase is a trademark of JPMorgan Chase Bank, N.A.; LedgerBox is not affiliated with Chase.

chase-4417-2026-03.xlsx

Date	Description	Amount	Balance	Page
2026-03-02	Acme Payroll direct deposit	4,250.00	16,700.33	1
2026-03-02	Check 1042	-1,200.00	15,500.33	1
2026-03-03	Con Edison payment	-184.62	15,315.71	1
2026-03-05	Wire in, Dana R	75.00	15,390.71	1
2026-03-06	Paper Trail Supplies	-642.18	14,748.53	1
2026-03-09	Stripe transfer	2,318.40	17,066.93	1
2026-03-10	Ink + Paper Co	-96.25	16,970.68	1
2026-03-12	ADP payroll fee	-58.00	16,912.68	1
30 more rows from pages 2 to 4

Date,Description,Amount,Balance
2026-03-02,Acme Payroll direct deposit,4250.00,16700.33
2026-03-02,Check 1042,-1200.00,15500.33
2026-03-03,Con Edison payment,-184.62,15315.71
2026-03-05,"Wire in, Dana R",75.00,15390.71
2026-03-06,Paper Trail Supplies,-642.18,14748.53
2026-03-09,Stripe transfer,2318.40,17066.93
2026-03-10,Ink + Paper Co,-96.25,16970.68
2026-03-12,ADP payroll fee,-58.00,16912.68
...

<BANKTRANLIST>
  <DTSTART>20260301
  <DTEND>20260331
  <STMTTRN>
    <TRNTYPE>CREDIT
    <DTPOSTED>20260302
    <TRNAMT>4250.00
    <NAME>Acme Payroll direct deposit
  </STMTTRN>
  <STMTTRN>
    <TRNTYPE>CHECK
    <DTPOSTED>20260302
    <TRNAMT>-1200.00
    <CHECKNUM>1042
  </STMTTRN>
  ...

Balanced Opening 12,450.33 + 38 rows 9,210.34 = 21,660.67. The statement says 21,660.67. Difference 0.00. Deposits and withdrawals also match the printed totals.

How to convert a bank statement to Excel or CSV

Upload
Drop the PDF you downloaded from your bank, a scanned statement or a phone photo. A PDF with many months in it is fine.
Check
LedgerBox reads every transaction and checks each balance against the statement. A row that does not add up is flagged with the reason, so you can fix it.
Download or send
Download Excel, CSV, QBO, OFX, QIF or JSON. Or send the rows straight into QuickBooks Online or Xero.

Pick the file your software takes

Where the rows go	File to download	Or send directly
Excel, Google Sheets, Numbers	XLSX or CSV	Not needed
QuickBooks Online	QBO, or CSV in the 3-column or 4-column layoutImports through Upload from file in Banking	Yes, to the bank account you pick
QuickBooks Desktop	QBO (Web Connect)	No
Xero	CSV or OFXImports through Import a statement	Yes, to the bank account you pick
Quicken	QIF or OFXNo QFX. Quicken accepts QFX only from licensed banks.	No
Your own code	JSON	Yes, with the API and SDK

Bank statement to Excel

Each transaction is one row, with date, description, amount and running balance in their own columns. Open it in Excel, Google Sheets or Numbers.

Excel export details

Bank statement to CSV

A plain CSV for any spreadsheet or import tool. For QuickBooks Online, pick the 3-column or 4-column layout its bank upload expects.

CSV export details

Bank statement to QuickBooks (QBO)

A QBO Web Connect file imports into QuickBooks like a download from your bank. On Pro plans you can send the rows to QuickBooks Online instead. Our integration passed Intuit's app review.

QuickBooks export details

Bank statement to Xero

Download a CSV or OFX for Xero's statement import, or connect Xero and send the transactions to the bank account you choose.

OFX export details

OFX and QIF for Quicken

Quicken imports QIF and OFX files. LedgerBox does not make QFX files, because Quicken only accepts QFX from banks that pay for a license.

Why there is no QFX

JSON and the API

Get every field as JSON, including the opening and closing balance and the check result. Or send statements through the API and SDK on any paid plan.

API and SDK

How you know the numbers are right

A converter that misreads one digit gives you a spreadsheet that looks fine and is wrong. LedgerBox uses the statement's own math to catch that before you download.

Every printed balance is checkedFrom the opening balance, each running balance on the statement must match the rows above it, to the cent.

The totals are checked tooDeposits and withdrawals must add up to the totals the bank printed.

Problems are flagged, not guessedA row that does not add up is marked with its page and the reason. You fix it or confirm it before export.

chase-4417-2026-04.pdf1 row to check

04/16Kramer Mfg-412.008,526.20

04/18Paper Trail Supplies-385.008,141.20

04/20Stripe transfer1,906.1010,047.30

Page 3. The balance after this row does not match the statement. The amount may be 358.00.

Statement says8,168.20

Rows add up to8,141.20

Off by27.00

Scanned statements, phone photos and card statements

Scans and photosScanned PDFs and phone photos (JPG, PNG, HEIC) are read with OCR. Amounts the scan makes hard to read are flagged for you to check.

Long and multi-month filesUpload a year of statements in one PDF. Files can be up to 8 MB each, and up to 20 at a time.

Dates without a yearStatements print 03/02, not 03/02/2026. The year comes from the statement period, even when it runs from December into January.

Credit card statementsCard statements convert the same way. Charges and payments keep the right sign.

Who converts bank statements with LedgerBox

Bookkeepers and accountants

Convert a new client's year of statements for a cleanup, then post them to QuickBooks Online or Xero. Clients can send statements to you through your portal.

LedgerBox for firms

Business owners

Catch up on your books, or put last year's transactions in a spreadsheet for your tax preparer.

Import statements into QuickBooks

Lenders and underwriters

Turn an applicant's statements into rows you can review, with every balance checked against the statement.

LedgerBox for lenders

Personal use

Get your statements into Excel for a budget, a mortgage application or your taxes.

Start with 10 free pages

Works with statements from any bank

LedgerBox reads the layout of each statement, so there is no template to set up and no list of supported banks to check. For the big banks, we also publish guides to downloading your statements.

ChaseGuide Bank of AmericaGuide Wells FargoGuide CitibankGuide Capital OneGuide U.S. BankGuide PNC BankGuide Truist BankGuide TD BankGuide Navy Federal Credit UnionGuide American ExpressGuide All bank guidesUS, UK, Canada, Australia

When you do not need a converter

Your bank's own download

Most banks let you download recent transactions as a CSV, and some as a QBO file for QuickBooks. If the dates you need are there, use that.

Excel's PDF import

For a clean digital PDF, Excel can pull tables out with Data > Get Data > From PDF. It does not check balances, and it cannot read scans.

When a converter helps

Older statements your bank no longer offers as downloads, scans and photos, many accounts at once, and files that QuickBooks, Xero or Quicken can import.

Is it safe to upload a bank statement?

EncryptedFiles and rows are encrypted in transit and at rest.

AuditedOur security is independently audited by a third party. GDPR applies to all accounts.

Not used for trainingYour statements are not used to train AI models.

Yours to deleteFiles stay in your account until you delete them.

How we protect your data

Bank statement converter pricing

10 pagesfree, no card

Share LedgerBox with a colleague200 free pages
Starter, 60 pages a month$25 a month
Pro, from 640 pages a monthfrom $135 a month

See all plans

Bank statement converter questions

What is a bank statement converter?

A tool that reads the transactions on a bank statement PDF and gives them back as a spreadsheet or accounting file, so you do not type them in by hand. LedgerBox also checks every balance against the statement.

Is there a free bank statement converter?

Your first 10 pages on LedgerBox are free, and you do not need a card. Share LedgerBox with a colleague to get 200 free pages. After that, plans start at $25 a month.

How do I convert a PDF bank statement to Excel?

Upload the PDF, check the rows LedgerBox finds, and download the XLSX file. Each transaction is one row with its date, description, amount and balance.

How do I turn a bank statement into a CSV file?

Upload the statement and choose CSV when you download. For QuickBooks Online, choose the 3-column or 4-column QuickBooks layout.

How do I convert a bank statement to a QBO file?

Upload the statement and download QBO. QuickBooks imports the file like a download from your bank. On Pro plans you can send the rows to QuickBooks Online without a file.

Does QuickBooks accept PDF bank statements?

QuickBooks imports bank transactions from files such as CSV and QBO. Convert the PDF first to get a file QuickBooks takes, with the balances already checked.

Can I import a converted statement into Xero?

Yes. Download a CSV or OFX file for Xero's statement import, or connect Xero and send the transactions to a bank account.

Does it work with my bank?

Yes. LedgerBox reads the layout of each statement instead of using a template per bank. If part of a statement cannot be read, those rows are flagged, not guessed.

Can it convert a scanned statement or a phone photo?

Yes. Scanned PDFs and JPG, PNG and HEIC photos are read with OCR. Amounts that are hard to read are flagged for you to check.

How is this different from asking ChatGPT?

A chat assistant gives you what it reads, with nothing to tell you if a row is missing or a digit is wrong. LedgerBox checks every balance against the statement and shows you the rows that do not add up.

Can I convert many statements at once?

Yes. Upload up to 20 files at a time, up to 8 MB each. One PDF can hold many months.

Can I get my bank statement in Excel from my bank?

Many banks let you download recent transactions as a CSV file, which opens in Excel. Older statements are often PDF only. Our bank guides show where each bank keeps its downloads.

Convert your first bank statement

10 pages free. No card needed.

Choose files Talk to a human