Bank statements

Turn a PDF bank statement into reviewable Google Sheets rows

Start by asking the bank for CSV, OFX, or QFX. When the PDF is the only usable source, one-click table extraction can recover reviewable rows without pretending the books are reconciled.

Use the bank export first

A native export carries actual fields rather than reconstructing a visual layout. It is the best route for current periods and active accounts.

PDF extraction helps with older statements, closed accounts, client-supplied documents, and institutions that do not provide a usable export.

Why statement PDFs break copy and paste

A page that looks like a table may be positioned text with separate date, description, debit, credit, and balance fragments. Copying can collapse columns, repeat headers, merge wrapped descriptions, or detach signs from amounts.

What the converter does

The same general-table extraction used for every PDF can keep distinct visible tables separate, handle supported adjacent page continuations deterministically, and remove only narrow repeated header rows when the evidence is exact.

Page provenance remains attached to extracted tables so you can compare the preview with the source.

The product preserves extracted wording and signs. It does not normalize dates, make debits negative, infer missing vendors, carry values across rows, reconcile balances, or guarantee completeness.

A careful review order

  1. Compare opening and closing statement context with the PDF, without treating a match as proof.
  2. Check page boundaries, repeated headers, multiline descriptions, and debit/credit signs.
  3. Spot-check the first, last, and several middle transactions.
  4. Insert into new tabs, then make any manual type or formatting changes in a copy.

Common bank-statement questions

Does it reconcile the statement?

No. Extraction prepares data for review; reconciliation is a separate manual or accounting workflow.

Will it preserve running balances?

It can extract a balance column when present, but does not infer, repair, or guarantee it. Compare every critical value with the source.

Can I enter the PDF password?

No. Password-protected and encrypted files are unsupported and fail safely.

Google Sheets add-on

Bring the PDF. Keep the final say.

Preview what was extracted before anything is inserted. Review every result—especially financial data.