Photograph the Receipts, Fill the Sheet
Extract structured expense data from photos of receipts and invoices.
Expense admin is not hard, it is just tedious enough that it gets done in a panic at quarter end, when half the receipts have faded.
That is the gap this drop closes. It is a finance & admin skill built for Gemini, and it takes about ten minutes to set up the first time. After that it runs in under a minute.
Who should use it
Small businesses doing expenses in a shoebox and a spreadsheet.
How it works
The skill file does five things, in this order.
1. Batch the images. Photograph as you go. Multimodal handles crumpled and angled.
2. Define the exact columns. Match your accounting export format from the start.
3. Extract with confidence flags. Low-confidence fields flagged rather than guessed.
4. Handle VAT correctly. UAE 5% split out, and the TRN captured where present.
5. Output as pasteable CSV. Straight into your sheet or accounting import.
What comes back
A clean CSV with VAT split, supplier TRN, category, and flagged uncertain fields.
The mistake to avoid
Insist on a confidence column and never let it guess a number. A flagged field takes ten seconds to check; a wrong figure in your VAT return takes considerably longer.
Running it
Save the prompt as a Gem so it is reusable, or paste it into Gemini with your files attached. If the task touches Sheets, Docs or Gmail, run it from the Workspace side panel so it can read the file you already have open.
Where this fits
On its own, one skill saves an hour a week. The compounding happens when three or four of them run in sequence on the same input, the same transcript that produces a scope of work also produces the follow-up email and the project brief. That is the point at which it stops being a prompt and starts being an internal tool. If you want that wired into the systems your team already uses, that is the work 67 Digital does.
In the file
Extract expense data from these receipt images.
Output CSV with exactly these columns:
date, supplier_name, supplier_trn, description, category, subtotal, vat_amount,
total, currency, payment_method, confidence, notes
Rules:
- Never guess. If a field is unreadable, write UNCLEAR and set confidence LOW.
- UAE receipts: VAT is 5%. If the receipt shows only a total, calculate the
split and note that it was derived, not printed.
- Capture the supplier TRN if printed. This matters for input tax recovery.
- Category from this list only: {your chart of accounts categories}
- Flag any receipt that appears to be a duplicate of another in this batch.
Output raw CSV with no commentary so I can paste it straight in.