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.
01
This is not legal advice
This page is general information, not legal advice. It does not recommend a converter product and it does not invent an accuracy rate. A person signs off on the sheet before anything is offered to QuickBooks or Xero. Extraction tools do not post ledger entries.
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 type | Fields to pull | What you validate |
|---|---|---|
| Bank statement | Period start and end, institution, account name, last four, each transaction date, description, amount, ending balance, currency | Row count against visible pages. Sum against the printed ending balance when the PDF shows one. |
| Supplier invoice | Vendor, invoice number, invoice date, due date if printed, line descriptions, quantities, unit amounts, tax, total, currency | Invoice 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.
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.
| Code | What it means | What happens next |
|---|---|---|
| UNCLEAR_PAYEE | Vendor, 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_SPLIT | One PDF is two documents, or one document is split across files. | Split or merge until one source maps to one sheet. Recount pages. |
| PASSWORD_PDF | The file will not open. | Get the password through the portal. Do not store passwords on the sheet. |
| CURRENCY | The amount is not in the base currency, or the symbol is missing. | Do not convert. Flag for the reviewer. |
| DATE_UNCLEAR | Day, month, and year cannot be read, or locale is ambiguous. | Do not guess month first versus day first. |
| AMOUNT_UNCLEAR | Digits 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.
Keep reading on Fabren
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
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 operatorTopic hub
Related guides
More in Bookkeeping and CAS workflows.