End of month. Your client's submitted forty expense receipts — half photographed, half forwarded from email confirmations. Manual entry is half a day's work for a junior. There's a better way.
Extraction beats typing every time.
Collect into a single PDF first
Receipts arrive in every format — phone photos, PDF email confirmations, PDF receipts from booking sites. Collect everything into one folder, convert images to PDF for photos, and merge PDF the lot into a single monthly expense PDF. One file is easier to extract from than forty scattered ones.
Extract to Excel
Convert PDF to Excel on the monthly PDF. The Excel output won't be perfect — receipts have varied layouts — but it'll capture dates, amounts, and merchant names for most receipts. Spot-check by comparing the Excel total to the manual receipt total.
Categorise in Excel
Add a Category column and code each row. Bulk-categorise by merchant where possible — every receipt from "Marriott" is travel, every receipt from "Sainsbury's" is subsistence (if business meals). Filter and apply categories in batches. This is where Excel beats any PDF workflow.
Import to bookkeeping
Once categorised, import the Excel into Xero, QuickBooks, or whatever bookkeeping software you use. Most accept Excel imports natively. Keep the original PDF receipts attached in the accounting software so the audit trail is preserved.
FAQ
How accurate is receipt extraction?
For text-layer PDFs (email confirmations, online booking receipts), very accurate. For phone photos of paper receipts, accuracy depends on photo quality and OCR.
Should I keep the original receipts?
Yes — HMRC and IRS both require originals to be retained. The Excel is your analysis layer; PDFs are your audit record.
Can I extract VAT amounts separately?
Where the receipt shows VAT broken out, extraction picks it up. For total-only receipts, you'll calculate VAT manually.
What about handwritten receipts?
OCR struggles. Manual entry remains the only reliable approach for handwritten material.
Stop typing receipts by hand. Convert your monthly pack in Flint and reclaim the afternoon.