Upload statements
Upload multiple digital or scanned statement PDFs into a named client batch.
Bank Statement Converter for Bookkeepers
Turn a client's statement PDFs into one organized ledger. Check balances, identify duplicates and continuity gaps, review flagged rows, then export to your bookkeeping workflow.
How it works
Check every balance
Extract transactions and deterministically compare opening balance plus activity with each closing balance.
Review and export
Review flagged rows, duplicates and continuity warnings, then choose an export format available on your plan.
Balance and continuity checks, explained
Reconciliation checks are visible review signals—not a promise that every source row is error-free.
Statement balance
For each statement, opening balance + extracted transaction amounts is compared to the closing balance to the cent. A mismatch shows PASS or FAIL with its difference for your review.
Account continuity & overlaps
Within the same account, a statement's closing balance is compared with the next opening balance. Overlapping transactions are marked as duplicates rather than silently removed.
Choose a format for your workflow
Column previews show the shape of the exported data. Available formats depend on your plan.
Excel workbook
Ledger sheet: Date, Description, Debit, Credit, Amount, Running Balance, Account, Source Statement, Source Page, Flags. Also includes statement summary and reconciliation report.
Generic CSV
Date, Description, Debit, Credit, Amount, Running Balance, Account, Source Statement, Source Page, Flags.
Xero bank statement CSV
Date (YYYY/MM/DD), Amount, Payee, Description, Reference.
QuickBooks-ready CSV · 3-column
Date (MM/DD/YYYY), Description, Amount.
QuickBooks-ready CSV · 4-column
Date (MM/DD/YYYY), Description, Credit (money out), Debit (money in).
Printable reconciliation summary
A printer-friendly statement and account check summary for the client file.
The QuickBooks 4-column bank-import layout uses Credit for money out and Debit for money in. Those labels follow QuickBooks' bank-import convention; the generic ledger's Debit and Credit columns retain their normal ledger meanings.
Retention and deletion
Source PDFs expire 7 days after batch creation; extracted ledger data expires after 30 days. Automatic cleanup removes expired files and data. You can delete a batch sooner. Read about Statements to Ledger security and data handling.
Bank statement conversion FAQs
How do I convert bank statements to a ledger?
Upload a batch of client statement PDFs. PDFDrill extracts transactions, groups statements by account, checks the balances and overlapping periods, then lets you review flags and export.
What does the balance check do?
For each statement, the opening balance plus the extracted transactions is compared with the printed closing balance. A mismatch is reported with its difference; it is not silently treated as reconciled.
How are continuity and duplicates handled?
Statements in the same account are checked for closing-to-opening balance continuity. Repeated transactions in overlapping periods are marked as duplicates for review rather than silently disappearing.
Which export formats are available?
Depending on your plan, exports include an Excel workbook, generic CSV, Xero bank statement CSV, QuickBooks-ready CSV layouts, and a printable reconciliation summary.
How long are source PDFs and extracted data retained?
Source PDFs expire 7 days after batch creation. Extracted ledger data expires after 30 days. Automatic cleanup removes expired files and data; a batch can also be deleted sooner.
Make statement review part of your close
Start with your available free page quota, or request a done-for-you ledger from $79 per bank account per year, including up to 12 statements / approximately 75 pages.