The Schema CPA blog
Guides for accounting firms on collecting client documents, chasing what is missing, and turning statements, receipts and tax forms into clean data.
See the most recent postsSee the most recently updated posts
Collecting client documents
How accounting firms get every client document in one place: upload links, document requests, and intake from email and phone photos.
23 posts
Tax checklists and organizers
Checklists, tax organizers and request lists that tell clients exactly which documents to send, from 1040s to audit PBC lists.
28 posts
Chasing missing documents
How to see which client documents are still outstanding, compare against last year's return, and follow up without nagging.
25 posts
Sorting and organizing client files
Classifying, splitting, naming and de-duplicating the PDFs and photos clients send, and managing client files across the firm.
22 posts
Tax forms, W-9s and payroll paper
Reading W-2s, 1099s, K-1s, W-9s, pay stubs and payroll reports accurately, and cutting the data entry they cause in tax prep.
30 posts
Bank statements to Excel
Converting bank, credit card and loan statement PDFs into clean Excel or CSV, including scanned statements and bank downloads.
20 posts
Statement reconciliation
Tying out bank and card statements month to month, finding gaps in a run of statements, and reconciling client accounts faster.
24 posts
Receipts and invoices
Receipt and invoice OCR, vendor invoice processing and accounts payable automation for bookkeepers and accounting firms.
23 posts
Ledgers and financial statements
Extracting general ledgers, trial balances, balance sheets and income statements into Excel for write-up, review and audit work.
25 posts
QuickBooks, Xero and Excel export
Moving clean client data into QuickBooks Online, Xero and Excel: CSV formats, statement imports, receipts and invoices.
27 posts
Tax season workflow
Running tax season across preparers: workflow, review queues, return status tracking, capacity planning and the cost of manual entry.
22 posts
Client portals and data security
Client portals, secure file exchange and the IRS and FTC rules on safeguarding taxpayer data, written for accounting firms.
26 posts