Fabren
All guides

· Bookkeeping

Turn bank statement and invoice PDFs into a reviewed spreadsheet a bookkeeper can trust

A repeatable firm workflow to turn bank statement and invoice PDFs into a clean spreadsheet with an exceptions list, so DIY ChatGPT extractions stop breaking. General information, not legal advice.

By Fabren EditorialPublished November 3, 2026
12 min read

Audience

Bookkeepers and admins at small firms turning client PDFs into working sheets

Core takeaway

Use one template per document type, validate totals against the PDF, queue exceptions, and have a bookkeeper sign off before anything is offered to the ledger. Informational, not legal advice.

Chasing the PDF is a different job from reading it. Once the bank statement or the supplier invoice is in the folder, the firm still has to turn it into a sheet a bookkeeper can review. One shot chat extractions fail because the fields move, the page splits, and nobody checks the ending balance. This page is the extraction and review pack after the file arrives.

Getting the receipt or statement in the first place is chasing bookkeeping receipts. Where the PDF sits once it exists is document routing for a tax or CPA firm. What the client should keep versus send is the small business recordkeeping checklist.

02

Why one shot chat extractions fail

A chat window will happily invent a payee from a truncated description, skip a page, or print dates in a mix of month first and day first. The next statement looks similar, so the same prompt is reused, and the misses compound. The fix is not a cleverer prompt. The fix is one template per document type, an exceptions queue, and a person who checks the PDF.

  • The working sheet uses fixed columns. The model fills those columns. It does not invent extra ones.
  • Every required field is either filled from the PDF or marked with a reason code. Blank without a code is a fail.
  • Totals are checked against something printed on the PDF: page count, statement ending balance, or invoice total.
  • The original PDF stays next to the sheet. The sheet is not the record.

03

Pick one template per document type

Bank statements and supplier invoices do not share a column set. Keep two templates. Do not run a mixed folder through one prompt and hope the model sorts it.

Source typeFields to pullWhat you validate
Bank statementPeriod start and end, institution, account name, last four, each transaction date, description, amount, ending balance, currencyRow count against visible pages. Sum against the printed ending balance when the PDF shows one.
Supplier invoiceVendor, invoice number, invoice date, due date if printed, line descriptions, quantities, unit amounts, tax, total, currencyInvoice total on the sheet equals the total printed on the PDF. Line count matches the PDF pages for that invoice.

Use one date format on the sheet (year, month, day) even if the PDF prints another. Use decimal amounts. If the PDF is not in the client's base currency, do not convert in this step. Flag CURRENCY and leave it for the reviewer.

Publication 583 says purchases, sales, payroll, and other transactions generate supporting documents, including invoices, and that those documents contain the information you record in the books. The IRS recordkeeping page says you may choose any recordkeeping system suited to the business that clearly shows income and expenses. The sheet is the working copy. The PDF is the supporting document. (Recordkeeping, Publication 583)

Accounting firms

Want this handled for your firm?

Fabren sets up a done for you operator inside your accounting stack. It drafts client chasing, intake follow ups, and similar admin work. Your staff approve what goes out. Your CPA reviews and signs every return.

Prefer the long form? Use the contact page.

04

The exceptions queue

Exceptions are the point of the workflow. They are not a failure of the template. Park the row, keep the PDF in view, and give the bookkeeper a reason code.

CodeWhat it meansWhat happens next
UNCLEAR_PAYEEVendor, bank, or description cannot be read with confidence.Leave the field blank. Ask the client or open a prior statement. Do not guess.
MULTI_PAGE_SPLITOne PDF is two documents, or one document is split across files.Split or merge until one source maps to one sheet. Recount pages.
PASSWORD_PDFThe file will not open.Get the password through the portal. Do not store passwords on the sheet.
CURRENCYThe amount is not in the base currency, or the symbol is missing.Do not convert. Flag for the reviewer.
DATE_UNCLEARDay, month, and year cannot be read, or locale is ambiguous.Do not guess month first versus day first.
AMOUNT_UNCLEARDigits are unreadable, or the total does not match the PDF.Stop the sheet. Extract again or key the line from the PDF.

05

A person approves before anything hits the ledger

Extraction can draft the sheet. A named bookkeeper compares it to the PDF and signs the run. Only then may someone offer those lines to QuickBooks or Xero as a suggestion. Bank rules and receipt capture in QuickBooks Online still need a person on the For review pile. That policy is bookkeeping categorization in QuickBooks Online. The close that consumes the reviewed sheet is the month end close checklist.

  • Inbox folder holds only this client and this period.
  • Extract into the template, not into a freeform paste.
  • Validate page count and, when printed, the statement ending balance or invoice total.
  • Every blank required field has a reason code.
  • Bookkeeper sign off. Then file the sheet next to the original PDF.

06

Keep the original PDF

Publication 583 says the same recordkeeping rules that apply to hard copy books and records also apply to electronic storage systems, and that an electronic storage system must reproduce the stored books and records in a legible format. Publication 552 says the same for a person's own records. Do not throw away the PDF because a sheet exists. File them together. How long you keep them is a counsel question, not a number invented here. (Publication 583, Publication 552)

07

Download the extraction template

Download the extraction template, exception codes, and run checklist. If you want this run built for the firm, see the tax season operator. Your staff approve the sheet. Nothing posts to the ledger without that sign off. Founders who only need the monthly chase around the PDFs can start with the AI assistant.

Tax season operator

Want this handled for your firm?

Fabren sets up a done for you operator inside your accounting stack. It drafts client chasing, intake follow ups, and similar admin work. Your staff approve what goes out. Your CPA reviews and signs every return.

You read: PDF to Spreadsheet Workflow for Bookkeepers: Bank Statements and Invoices

Prefer the long form? Use the contact page.

Next step

Want the PDF extraction run built for the firm?

The tax season operator drafts the named follow ups when a statement is still missing. Your staff approve the sheet. Nothing posts to the ledger without a person signing off.

See the tax season operator

Topic hub

Related guides

More in Bookkeeping and CAS workflows.