Expense summary — what columns to include

Step by step — build the monthly expense report

1. Photograph each receipt as you incur it. Use a phone scan-mode (Apple Notes, Google Drive scan, Adobe Scan) for auto-deskew and contrast. Save to a per-month folder with date-prefixed filenames.
2. OCR each receipt using Make PDF Searchable (or run the receipts-to-expense tool which bundles OCR with extraction).
3. Extract structured fields. The tool reads vendor (top of receipt), date (formatted date string), and total (largest currency amount near the bottom). Review the extracted values for accuracy; correct any mis-recognised ones manually.
4. Categorise and assign project. Apply the keyword-based category suggestion or set manually. Project assignment is usually manual — based on the context the expense was incurred in.
5. Merge into one expense report PDF with the summary table as page 1 and each receipt as a subsequent page. Auto-assign page numbers and bates-style receipt IDs (R-001, R-002, …) for cross-reference. Download and submit.

Related reading

• Searchable PDF: the OCR step that powers field extraction.
• PDF for accountants: how this fits into the broader tax-prep workflow.
• Small-business PDF tools: companion piece on cost-saving free workflows.
• PDF for freelancers: client-billable expense documentation.
• Compress PDF: keep the merged report under email size limits.
• PDF to PDF/A: long-term archival of expense records.
• All ScoutMyTool PDF tools: the full toolkit.

FAQ

How accurate is OCR on phone-photographed receipts?

Variable. Clean photos with good lighting and a flat receipt produce 90–95% accuracy on vendor, date, and total fields. Crumpled, faded, or angled photos drop to 70–85%. The single biggest accuracy improvement is consistent photo discipline: lay the receipt flat on a contrasting dark surface, take the photo directly from above (not at an angle), ensure even lighting (no shadow across the receipt). Most modern phone camera apps now have a "scan document" mode (Apple Notes, Google Drive scan, Adobe Scan) that auto-detects edges, deskews, and applies contrast — much better OCR-source than a freehand photo. For the receipts you have already photographed at suboptimal quality, OCR them anyway; you can correct the ~15% of fields manually faster than retaking the photos.

What is the right way to organise receipts for an expense report?

Three patterns work for different workflow scales. Solo / occasional: one folder per month, photos named by date taken; at month end, generate the report. Team / monthly: receipts uploaded to a shared folder per employee per month, with a "process by 5th of next month" deadline. High-volume: dedicated expense-management software (Expensify, Concur, Ramp) that pulls in receipts via email/photo and auto-extracts data. For ScoutMyTool's receipts-to-expense workflow, the solo and team patterns work directly — drop receipts into the tool, get a merged PDF with auto-extracted summary, send to your manager or accountant. Total time for a 30-receipt month is about 15 minutes.

Does my expense report need to include the original receipt images, or just the summary?

Almost always include the originals. The IRS requires "adequate evidence" for business expense deductions (per IRS Publication 463); for items over $75 this typically means a receipt, not just a summary. Most employer-reimbursement policies similarly require receipt evidence for items over a low threshold ($25–$75 depending on company). The pattern that satisfies both: an expense report PDF with a one-page summary at the front (table of all expenses, totals by category) plus each individual receipt as a subsequent page. Reviewer scans the summary, drills into any receipt by page number. Auditors can pull individual receipts directly from the same PDF.

How do I categorise expenses automatically?

OCR-based category inference works for ~70% of cases using vendor name keywords. "Starbucks" / "Coffee" → Meals; "Uber" / "Lyft" / "Taxi" → Travel; "Office Depot" / "Staples" → Office Supplies; "Hilton" / "Marriott" / "Airbnb" → Lodging. ScoutMyTool's receipts-to-expense tool has a built-in keyword classifier that gets you most of the way; you correct the remaining 30% manually in the summary review step. For higher-volume operations, train a custom classifier on your historical categorisation data — but for under ~100 receipts per month, manual correction is faster than training and maintaining a classifier.

How long do I need to keep expense receipt PDFs?

IRS minimum is three years from the date you filed the tax return that included the expense, longer for some situations (six years if you under-reported income by more than 25%; indefinitely for unfiled or fraudulent returns). Most accountants recommend seven years to be safe. Employer reimbursement records follow the employer's retention policy, typically four years after the expense was incurred. Archive in PDF/A format for long-term reliability — the PDF/A archival sub-standard is designed for multi-decade preservation. Store in per-year folders (Tax/{Year}/Expenses/) for easy retrieval.

Can I do this entire workflow without uploading receipts to a third party?

Yes. ScoutMyTool's receipts-to-expense tool runs OCR (Tesseract via WebAssembly) and merging entirely in your browser tab. Receipts containing credit-card numbers, signatures, and personal data never transmit to a third-party server. This matters for sensitive contexts: legal expense reports (client confidentiality), HR review of employee expenses (employee privacy), or freelance reporting where the client signed an NDA covering vendor relationships. For non-sensitive routine expense reporting, cloud-based tools (Expensify, Concur) offer more automation but at the privacy cost of cloud storage.

What if a receipt is in a foreign currency?

Two steps. First, OCR the receipt with the matching language pack (ScoutMyTool supports 12 common languages out of the box; download more on demand). Second, record both the local-currency amount and the converted home-currency amount in the summary, with the exchange rate and date of conversion noted. For US tax purposes, the IRS accepts the spot rate on the date of the expense or a yearly average rate; the FX rate used should be documented. Some employer policies (and almost all US-government reimbursement) require a specific source for the rate (typically Treasury's annual list or the OANDA daily rate); follow whatever the policy says.

Citations

1. IRS Publication 463 — "Travel, Entertainment, Gift, and Car Expenses" — expense documentation requirements.
2. IRS Publication 583 — "Starting a Business and Keeping Records" — record retention guidance.
3. Tesseract OCR documentation — open-source OCR engine used for receipt text extraction.
4. ISO 19005 — "PDF/A" — long-term archival format standard.