Bank statement converter for PDF to Excel and CSV

Add a statement PDF, even a crooked scan, and you get every transaction in a spreadsheet you can sort and add up. Each row shows the statement page it came from.

Get 50 pages free Schedule a demo

Sample statement, 2 pages

Linden RidgeBank

Linden Ridge Bank, N.A.PO Box 6120Linden Ridge, PA 17820

Statement period: March 1, 2026 through March 31, 2026
Account number: ••••4821
Page: 1 of 2

DANA R WHITCOMBE1187 WEXFORD LN APT 3BMILLBROOK FALLS OH 44097

Everyday Checking

Questions? Call 1-800-555-0147

24 hours a day, 7 days a week

lindenridge.bank

Account summary

Beginning balance on March 1, 2026: 4,218.36
Deposits and other credits (3): +5,630.00
Withdrawals and other debits (6): −3,003.66
Checks paid (2): −1,475.00
Ending balance on March 31, 2026: $5,369.70

Deposits and credits
Date	Description	Amount
03/01	PAYROLL DIRECT DEPOSIT	2,640.00
03/15	PAYROLL DIRECT DEPOSIT	2,640.00
03/22	MOBILE CHECK DEPOSIT	350.00
Total deposits and credits		$5,630.00

Withdrawals and debits
Date	Description	Amount
03/03	ONLINE TRANSFER TO SAVINGS XX7710	500.00
03/05	MORTGAGE PAYMENT ACH	1,912.44
03/09	CARD PURCHASE CORNER GROCERY	186.27
03/12	ELECTRIC UTILITY AUTOPAY	143.80
03/18	ATM WITHDRAWAL	200.00
03/27	CARD PURCHASE FUEL STOP	61.15
Total withdrawals and debits		$3,003.66

Continued on next page

Linden RidgeBank

DANA R WHITCOMBE · Everyday Checking ••••4821
March 1, 2026 through March 31, 2026 · Page 2 of 2

Checks paid
Check	Date paid	Amount
1042	03/11	1,200.00
1043	03/24	275.00
Total checks paid		$1,475.00

Check images

#1042 · Paid 03/11

#1043 · Paid 03/24

Daily ending balance

Date	Balance
03/01	6,858.36
03/03	6,358.36
03/05	4,445.92
03/09	4,259.65

Date	Balance
03/11	3,059.65
03/12	2,915.85
03/15	5,555.85
03/18	5,355.85

Date	Balance
03/22	5,705.85
03/24	5,430.85
03/27	5,369.70

In case of errors or questions about your electronic transfers

Call us at 1-800-555-0147 or write to Linden Ridge Bank, N.A., PO Box 6120, Linden Ridge, PA 17820, as soon as you can if you think your statement or receipt is wrong or you need more information about a transfer on it. We must hear from you no later than 60 days after we sent the first statement on which the problem appeared. Tell us your name and account number, describe the transfer you are unsure about and why, and tell us the dollar amount.

Linden Ridge Bank, N.A. · Member FDIC · Equal Housing Lender

Your spreadsheet, 11 rows

counselpro-sample-bank-statement.csv

C13=SUM(C2:C12)

Transactions from the sample statement, Checking ••4821, March 2026, with the statement page each row came from
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Date	Description	Amount	Kind	Account	Page
2	3/1/2026	PAYROLL DIRECT DEPOSIT	2640.00	credit	Checking x4821	1
3	3/15/2026	PAYROLL DIRECT DEPOSIT	2640.00	credit	Checking x4821	1
4	3/22/2026	MOBILE CHECK DEPOSIT	350.00	credit	Checking x4821	1
5	3/3/2026	ONLINE TRANSFER TO SAVINGS XX7710	-500.00	debit	Checking x4821	1
6	3/5/2026	MORTGAGE PAYMENT ACH	-1912.44	debit	Checking x4821	1
7	3/9/2026	CARD PURCHASE CORNER GROCERY	-186.27	debit	Checking x4821	1
8	3/12/2026	ELECTRIC UTILITY AUTOPAY	-143.80	debit	Checking x4821	1
9	3/18/2026	ATM WITHDRAWAL	-200.00	debit	Checking x4821	1
10	3/27/2026	CARD PURCHASE FUEL STOP	-61.15	debit	Checking x4821	1
11	3/11/2026	CHECK 1042	-1200.00	debit	Checking x4821	2
12	3/24/2026	CHECK 1043	-275.00	debit	Checking x4821	2
13		Net change	1151.34
14
15

counselpro-sample-bank-statementSum: 1151.34Count: 1

Download the sample CSV

Opening balance: $4,218.36
Money in, 3 rows: $5,630.00
Money out, 8 rows: $4,478.66
What the rows add up to: $5,369.70
Ending balance printed on page 1:: $5,369.70

Off by $0.00, the month balances

How to convert a bank statement PDF to Excel

Add your PDF to a project in CounselPro. It can be one statement or a whole stack, and a file holding several statements gets split into months.

In minutes you have every transaction in one list, with the date, description, amount, money in or out, account and page number. Download the list and open it in Excel to sort, filter and add up the amounts.

How to convert a bank statement to CSV

The download is already a CSV file, and it opens in Excel, Google Sheets or Numbers. If you only want one account, one payee or one year, filter the list first and download just those rows.

Transactions

Transactions/Sample case2,418 rows

Search 2,418 transactionsAll accountsMoney out2024Download

Feb 3Payroll depositChecking 4471+4,550.00

Feb 7Grocery storeCard 5518-142.18

Feb 9Online transfer to 6690Unknown accountChecking 4471-12,000.00

Feb 11Zelle paymentJoint 8802-650.00

Feb 12Transfer from savingsSavings 3106+1,500.00

Feb 14Electric billChecking 4471-214.63

Feb 16ATM withdrawalChecking 4471-400.00

4 accounts, January to December 2024Sorted by date

Convert scanned bank statements to Excel

Most statements don’t show up as clean downloads. You get crooked scans, faxes, phone photos, or one giant PDF with several accounts mixed together.

Add them as they are. You get back separate monthly statements, in date order for each account, from big banks, regional banks and credit unions. The sharper and straighter the scan, the better the result.

A woman at a kitchen counter reads a printed statement beside her open laptop.

Convert credit card statements to Excel

Credit card statements work the same way. Every purchase, payment, fee and interest charge gets a row with its page number, and you can see who holds a card on the account.

Convert bank statements with check images

Each check gets its own row, marked money in or money out. If it isn’t clear which, the check is flagged for you to look at. You can also add a file of nothing but check images.

Check 1042, on page 2 of the sample statement, becomes this row:2026-03-11,CHECK 1042,-1200.00,debit,Checking x4821,2

How to check a converted bank statement is complete

Take the opening balance, add the money in and subtract the money out. You should land on the ending balance the bank printed.

We do that for every account, every month. If a month doesn’t add up, we check it again until every figure matches what the bank printed. Anything we can’t confirm is flagged for you, with the page next to it, and you can see right away which months are missing.

This check comes with the free trial, the Premier plan and the Single Project. Core and Plus extract every row.

See how reconciliation works Compare plans

Bank statement converter questions

Didn’t see your question here? Email support@counselpro.ai and I’ll get back to you.Ian O’Brien, co-founder and CEO

Why won’t a bank statement PDF paste cleanly into Excel?

A PDF stores where each word sits on the page, but not which column it belongs to. So when you paste one into Excel, a description on two lines turns into two rows, amounts come in as text, and page headers end up between your transactions.

Can I convert a scanned bank statement to Excel?

Yes. You can add scanned pages, faxes and phone photos. A sharp, straight scan gives the best result. On the free trial, each month is also balanced to the totals the bank printed.

Can I convert many bank statements at once?

Yes. Add a whole stack, or one PDF with thousands of pages and several accounts in any order. You get it back split into monthly statements and sorted by account, and you can see which months are missing. On Premier and the Single Project, a month that shows up twice is flagged.

How do I know every transaction was converted?

Each month has to balance: the opening balance plus money in, minus money out, has to equal the ending balance the bank printed. If a month doesn’t add up, we check it again until every figure matches. Anything the records can’t support is flagged for you. This check comes with the free trial, the Premier plan and the Single Project.

What do I get back when I convert a bank statement?

One row for every transaction, with the date, description, amount, money in or out, account and statement page. Download the rows as a CSV to open in Excel or Google Sheets, or click a row in the app to open that statement page.

How long does converting a bank statement take?

Minutes, and it runs in the background. A big stack takes longer, and you can keep working while it runs.

Which banks does the converter work with?

Bank and credit card statements from virtually any U.S. institution, including regional banks and credit unions. It also works on statement layouts we haven’t seen before.

Are my statement files kept private?

Yes. Your files are encrypted on the way in and while they’re stored with us, the infrastructure we run on is checked by outside auditors, and we never train models on your client data.

Is the bank statement converter free?

Your first 50 pages are free on the trial. After that, each statement page costs one credit, and credits come with every plan and with the Single Project.

Convert your own statement

Try it on the statement that gave you the most trouble. Your first 50 pages are free.

Get 50 pages free