Audit Friendly MODERN ACCOUNTING
TUE · OCT 27 · EDITION

A client document extraction workflow built for preparers

 

Manual re-keying of client-supplied statements - bank statements, lease schedules, trial balances - is slow and error-prone. This workflow has an AI assistant produce a structured draft extraction that a preparer then verifies in a single pass, document type by document type, until the prompt is stable for that format. It is built for preparers who want a defensible, documented process rather than a shortcut.

BUILD WITH AI

How to build a client document extraction workflow with an AI assistant

This workflow replaces manual re-keying of client-supplied statements by having an AI assistant produce a structured draft extraction that a preparer verifies in a single pass. Run it on one document type at a time until the prompt is stable for that format.

1
 Confirm the source document has a selectable text layer; if it is a scanned image, run it through an OCR tool first and save the output as a searchable PDF.
2
 Open your AI assistant and upload the document or paste the relevant pages as text.
3
 Paste this prompt exactly, substituting the bracketed items for your document: 'You are an accounting data extraction assistant. From the attached [bank statement / lease schedule / trial balance], extract all line items into a table with these columns: Line item label | Period | Amount | Currency | Source page number.
4
 Review the uncertainty flags first; any row marked uncertain must be verified directly against the source before the figure enters a workpaper.
5
 For unflagged rows, spot-check at least three line items by tracing each amount back to the page number the assistant cited.
6
 Confirm that the extracted totals agree with any summary totals printed in the source document; a discrepancy here means at least one line item was missed or misread.
7
 Paste the verified table into your workpaper template or reconciliation schedule and note in the workpaper that the source extraction was AI-assisted and human-reviewed, with the reviewer's initials and date.
The rule: A preparer - not the person who ran the extraction - must sign off that each figure ties to the source document before the data enters any client-facing deliverable.

WORKED EXAMPLE

In practice

A three-month bank statement for a small business client, covering the period just ended, arrives as a digital PDF. The preparer needs a line-item table of all credits and debits to populate a cash reconciliation workpaper for the current month.

THE PROMPT
You are an accounting data extraction assistant. From the attached bank statement, extract all transaction line items into a table with these columns: Date | Description | Debit | Credit | Running balance | Source page number. If you are uncertain about any value, label, or date, add a column marked Uncertain: Yes and explain why in one sentence. Do not infer, calculate, or round any figures - use only the amounts explicitly printed in the statement. Return only the table and the uncertainty notes, no narrative or summary.

What came back. The assistant returned a 47-row table covering all three months, with source page numbers in every row. Two rows were flagged as uncertain: one where a description was partially cut off at the page margin, and one where a deposit amount appeared twice in adjacent rows and the assistant could not confirm whether the second entry was a duplicate or a separate transaction. The running balance in row 31 did not match the printed statement balance for that date, indicating one line item had been skipped.

How it was checked. The preparer opened the source PDF, located the skipped line item on page 4 using the source-page column, added it to the table, and confirmed the running balance then agreed to the printed statement figure before importing the table into the reconciliation workpaper.

A constructed example. The prompt is usable as written; the figures show the shape of a result, not a measured one.

WHEN TO USE IT

 
Client sends a clean digital PDF statement that needs line items in a workpaper.
 
Volume of documents makes manual re-keying a bottleneck at period close.
 
A preparer is available to verify the output against the source before it is used.
 
The document type is consistent enough that a single stable prompt covers most instances.

WHEN NOT TO

 
The source is a scanned image or handwritten document without OCR pre-processing.
 
No one with accounting judgment is available to review the extraction before it enters a deliverable.
 
The document contains merged cells or multi-column layouts the assistant has not been tested on.
The pitfall: The assistant returns a complete-looking table even when a line item is missing; the running balance column is the fastest check - if it stops agreeing with the printed statement at any row, something was skipped or misread.
FROM THE CAREER PORTAL
Upload your resume once. The portal does the rest.
Drop your resume into the career portal and it pulls every signal out of it, role history, skills, seniority, target comp, then feeds that into our matching engine. From one upload you get job matches ranked to your profile, recruiter contacts who place people like you, and a prioritized list of fixes to get your resume past the ATS. Tools that do a fraction of this charge around $40 a month and were never built for accounting. Ours is free, and the matching is tuned on accounting and finance profiles, not a general pool.

SPONSORED

Gusto: full-service payroll that posts clean journal entries to your ledger
Federal, state and local filing in all 50 states, native two-way sync to QuickBooks Online and Xero, and published per-employee pricing with no contract. Audit Friendly scored it 74/100 in a fact-checked review; we earn a referral fee if you sign up, and the score is not affected.
Rewards for sharing
Share Modern Accounting. Unlock free rewards.
1
AI Starter Kit
1 friend · 10 copy-ready prompts for everyday work
Free gift
3
Close Prompt Playbook
3 friends · All 20 month-end prompts with reviewer's guides
$39 value
5
Playbook + Close Skills
5 friends · The Playbook plus five Claude skills: bank rec, flux review, duplicate payments, deferred revenue and journal entry review
$99 value
10
Month-end close kit
10 friends · The Playbook, the Close Skills and the AI-assisted month-end close workflow
$149 value
Your personal share link and your count are right below. Each friend who confirms their subscription counts. Rewards arrive by email.
Month-end close kit
The whole month-end close, with AI doing the first pass.
The AI-assisted month-end close workflow, the Close Prompt Playbook and all five Close Skills in one kit. One payment, 30-day refund.
Get the close kit, $149 →
New: the AuditFriendly Library, 49 close, audit and bookkeeping tools from $9, some free. Playbook buyers get the matching Library items free. Browse the Library

GO DEEPER

Go deeper

Software reviews → Fact-checked vendor reviews with verdicts and pricing
AF Stack Designer → Design your accounting stack in ten minutes
Skills that pay → Which named tools move the number
Software in postings → Every tool ranked by live demand

Next issue: more of the tools and shifts reshaping how accounting gets done.

Forward this to the partner still doing it the old way.

An original workflow written for practitioners. Replicate it in a sandbox first; nothing here replaces your review.

How accountants are using AI, automation and smarter workflows to close faster, audit cleaner, and free up time for real work.

More from AuditFriendly
Month End Closers · Everything that moved in accounting this week
Accounting Stack · The software, head to head
The Remote Accountant · Remote accounting roles with pay, every weekday
The Finance Nomad · Remote finance roles with pay, every weekday
Want to reach these readers? Advertise with us. Sponsors buy the slot, never the coverage.

Audit Friendly · modernaccounting.ai · Audit Friendly Data

© 2026 Modern Accounting.
beehiivPowered by beehiiv