Bank statement → ExcelPublic beta

A bank statement, as a workbook you can check.

DocShape turns a PDF bank statement into an Excel workbook (.xlsx). The transactions go on one sheet, the figures the statement printed on a second, and the result of checking one against the other on a third.

Before anything is downloaded, the converter shows the summary, a sample of the extracted transactions and the verification outcome. The workbook holds the full transaction table.

Open the converter

The public beta runs for a limited time, on a best-effort basis, and the upload on the homepage says whether it is open right now. It takes a text-based PDF statement of up to 10 MB and 8 pages; scanned statements are refused. The full converter remains a private, invite-only beta. No separate DocShape account is required.

Text-based PDF only
One statement
Up to 10 MB
Up to 8 pages

XLSXdocshape-statement.xlsxSample

	A	B	C	D	E	F	G	H	I
1	Date	Posted Date	Description	Direction	Debit	Credit	Signed Amount	Running Balance
2	2026-06-02		Northstar Studio · Invoice 1042	Credit		3,200.00	3,200.00	11,450.00
3	2026-06-04		Workspace rent	Debit	1,200.00		-1,200.00	10,250.00
4	2026-06-08		Software subscription	Debit	85.00		-85.00	10,165.00
5	2026-06-12		Fieldwork Co. · Invoice 1043	Credit		1,850.00	1,850.00	12,015.00
6	2026-06-19		Contractor payments	Debit	1,900.00		-1,900.00	10,115.00
7	2026-06-24		Riverside Print · Invoice 1044	Credit		2,400.00	2,400.00	12,515.00
8	2026-06-27		Utilities	Debit	376.50		-376.50	12,138.50
9
10
11
12
13
14

Transactions
Summary
Verification

A fictional account. The posted date is blank because this statement did not print one.

Inside the workbook

Three sheets, each with one job.

What happened, what the statement says, and whether the two agree — in that order, one sheet each. Choose a sheet to see it.

TransactionsOne row per transaction, in the order the statement printed them: date, posted date, description, direction, debit, credit, signed amount and running balance. The header row is bold, frozen and filterable.
SummaryThe account and statement details — institution, account holder, the last four digits of the account number, the statement period — the opening and closing balances and reported totals where the statement gives them, the currency with how it was established, and the account's verification outcome.
VerificationThe account's verification outcome and what it means, then one row per check: whether it passed, failed or could not be checked, what was compared, and the expected and actual figures where there were figures to compare.

XLSXdocshape-statement.xlsxSample

	A	B	C	D	E	F	G	H	I
1	Date	Posted Date	Description	Direction	Debit	Credit	Signed Amount	Running Balance
2	2026-06-02		Northstar Studio · Invoice 1042	Credit		3,200.00	3,200.00	11,450.00
3	2026-06-04		Workspace rent	Debit	1,200.00		-1,200.00	10,250.00
4	2026-06-08		Software subscription	Debit	85.00		-85.00	10,165.00
5	2026-06-12		Fieldwork Co. · Invoice 1043	Credit		1,850.00	1,850.00	12,015.00
6	2026-06-19		Contractor payments	Debit	1,900.00		-1,900.00	10,115.00
7	2026-06-24		Riverside Print · Invoice 1044	Credit		2,400.00	2,400.00	12,515.00
8	2026-06-27		Utilities	Debit	376.50		-376.50	12,138.50
9
10
11
12
13
14
15
16
17
18

	A	B	C
1	Institution	Sample Bank
2	Account Holder	Willow Studio LLC
3	Account Number (last 4)	4821
4	Currency	USD
5	Currency Basis	Stated on the statement.
6	Statement Period Start	2026-06-01
7	Statement Period End	2026-06-30
8	Opening Balance	8,250.00
9	Closing Balance	12,138.50
10	Total Credits	7,450.00
11	Total Debits	3,561.50
12	Transaction Count	7
13	Page Count	1
14	Verification State	VERIFIED
15	Verification	Verified
16	What That Means	The extracted amounts reconcile with balances or totals DocShape read from the statement. This does not confirm that every transaction, date or description was captured correctly.
17
18

	A	B	C	D	E	F	G
1	Verification	Verified
2	What that means	The extracted amounts reconcile with balances or totals DocShape read from the statement. This does not confirm that every transaction, date or description was captured correctly.
3
4	Check	Status	Summary	Expected	Actual	Difference
5	Opening balance	Passed	The reported opening balance agrees with the balance implied by the first transaction and its printed running balance.	8,250.00	8,250.00	0.00
6	Closing balance	Passed	The reported opening balance plus every transaction equals the reported closing balance.	12,138.50	12,138.50	0.00
7	Total credits	Passed	The credits on the extracted transactions add up to the reported total credits.	7,450.00	7,450.00	0.00
8	Total debits	Passed	The debits on the extracted transactions add up to the reported total debits.	3,561.50	3,561.50	0.00
9	Running balance sequence	Passed	Every printed running balance follows from the one before it, and the sequence ends at the reported closing balance.	12,138.50	12,138.50	0.00
10
11
12
13
14
15
16
17
18

The same fictional account, sheet by sheet.

Built to be worked in

Sort it, filter it, add it up.

The workbook is made for the next step — a reconciliation, a budget, a question from your accountant — so every cell holds the kind of value it looks like.

Dates are dates: Date cells, formatted yyyy-mm-dd, so they sort and filter as dates rather than as text.; 2026-06-02Date cell
Amounts are exact numbers: Numeric cells written from exact decimal values. A figure too long for Excel to hold exactly is written as text instead of being quietly rounded.; 3,200.00Number cell
Debit, credit and signed: Separate Debit and Credit columns, plus a Signed Amount column — credits positive, debits negative — when one column of figures is what you need.; -1,200.00Signed Amount
Nothing runs: No formulas, macros or charts. A description that begins with an equals sign is stored as text and never calculated.; =Refund · Invoice 1042Text cell
Blank means not printed: An empty cell is something the statement did not state — never a zero or a guess put there to fill the gap.; Not printed

Consolidated statements

Several accounts, one workbook, each checked on its own.

Where a consolidated statement’s structure is supported, the workbook opens with an Overview sheet — one column per account — followed by each account’s own Transactions and Verification sheets. Nothing is added up across accounts.

Not every multi-account layout is supported. DocShape converts up to ten accounts from one PDF; a statement with more is not converted.

XLSXdocshape-statement.xlsxSample

	A	B	C	D
1	Field	Account 1	Account 2
2	Accounts	2
3	Verification	Each account was checked separately.
4
5	Institution	Sample Bank	Sample Bank
6	Account Holder	Willow Studio LLC	Willow Studio LLC
7	Account Number (last 4)	4821	7730
8	Currency	USD	USD
9	Currency Basis	Stated on the statement.	Stated on the statement.
10	Statement Period Start	2026-06-01	2026-06-01
11	Statement Period End	2026-06-30	2026-06-30
12	Opening Balance	8,250.00	15,000.00
13	Closing Balance	12,138.50	14,512.40
14	Total Credits	7,450.00	12.40
15	Total Debits	3,561.50	500.00
16	Transaction Count	7	2
17	Page Count	3	3
18	Verification State	VERIFIED	NEEDS_REVIEW

Overview
Account 1 Transactions
Account 1 Verification
Account 2 Transactions
Account 2 Verification

Two fictional accounts: a column each, and no column that adds them up.

Review first

See the result before you download it.

For each account, the converter shows one of three outcomes — Verified, Needs review, or Could not be verified automatically — next to a sample of the extracted transactions. The Verification sheet carries the same outcome, with the figures behind each check.

How the checks work

VerifiedThe extracted amounts reconcile with balances or totals DocShape read from the statement. This does not confirm that every transaction, date or description was captured correctly.
Needs reviewOne or more verification checks did not reconcile. Review the extracted data before exporting.
Could not be verified automaticallyDocShape did not recognize enough independent financial figures in this statement to check the extracted amounts automatically. The statement may contain balances or totals in a format DocShape does not yet support. Review the result against your statement before relying on it.

When a statement can’t become a workbook

DocShape says so and explains why, rather than handing over a workbook you would have to second-guess. For example, when:

The PDF is password-protected.
DocShape cannot read the layout reliably — a limitation of the converter, not a problem with your document.
The statement states values that contradict each other.
DocShape cannot reliably tell which account each transaction belongs to.
One PDF holds statements for more than ten accounts.

Choosing a format

CSV or Excel?

Both come from the same conversion you reviewed, and you can download either.

XLSXExcelThis page

For review and work.

A workbook: the transactions, with the statement's figures and the verification result alongside them.

Transactions, Summary and Verification sheets
Date and number cells, a bold, frozen, filterable header
Several accounts: an Overview, then each account's own sheets

CSVCSV

For imports, scripts and databases.

A fixed schema: eleven columns in the same order every time, transactions only.

UTF-8, CRLF, ISO dates, plain decimals
The currency and its basis on every row
Several accounts: one file each, never merged

What the CSV holds

Try it on a statement of your own.

Open the converter

Public beta · best effort
Text-based PDF only
One statement
Up to 10 MB
Up to 8 pages