Invoices and Receipts to a Clean Expense Table With Totals and Flags
Reads uploaded receipts and invoices into one expense table with net, tax, total, currency and category, marks unclear fields instead of guessing, totals by category and currency, and gives a CSV to paste.
You getTable, totals by category and by currency and flags
The prompt
You are a careful bookkeeping assistant. Read the receipts and invoices I uploaded and turn them into one clean expense table.
Categories to use: Travel, Meals, Software, Office supplies, Equipment, Other (example value for {your expense categories})
Rules:
- Copy values exactly as printed. If a field is unclear, cut off or missing, leave it blank and mark it CHECK instead of guessing.
- Keep each amount in its original currency. Do not convert currencies unless I give you a rate.
- Separate net, tax (VAT, GST or sales tax) and total. If only a total is shown, leave net and tax blank.
- Flag likely duplicates (same vendor, date and total). If I also upload a card statement, flag lines with no matching receipt.
- If a file is not a receipt or invoice, list it and skip it.
Output format:
1. Table: file | date (YYYY-MM-DD) | vendor | invoice or receipt number | net | tax | total | currency | category | payment method | notes
2. Totals by category and by currency
3. Flags: CHECK fields, possible duplicates, missing receipts
4. The same table as a CSV code block ready to paste into a spreadsheet
This is data entry help, not tax advice; ask your accountant what is deductible.Dashed parts are example values, so the prompt runs as copied. Change them in Fill in the blanks.
Example output
Upload photos or PDFs of receipts and invoices to ChatGPT, Claude or Gemini in batches of about 10 (file limits vary by app), then paste this. Spot-check the CHECK fields against the originals before filing.
Make it repeatable
Keep using this prompt without pasting it in every time.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Document intake: classify, extract and verify: Multi-Step Agent Workflow for Claude Code, Codex or ChatGPT
Labels each pasted document (contract, invoice, RFP, resume, report), extracts its fields, checks each value against a verbatim quote and flags risks.
Excel and Google Sheets Formula Builder With a Plain-English Explanation
Writes the formula for what you want a spreadsheet to do, in both Excel and Google Sheets syntax, explains each part, and gives a test case so you can check it works.
Support triage bot: Multi-Step Agent Workflow for Claude Code, Codex or ChatGPT
Reads each new ticket, routes it to billing, bug or how-to, drafts a reply and waits for an agent to approve before sending.
Meeting Notes to Action Items, Owners and a Follow-Up Email
Get decisions, action items with owners and dates, open questions and a follow-up email under 150 words from raw meeting notes or a call transcript.
Spreadsheet and CSV Cleanup Report Skill (SKILL.md)
A SKILL.md that has your agent profile a messy CSV or spreadsheet, fix it in a copy with a script, and report every change so the cleaned data can be trusted.
Standard Operating Procedure From a Screen-Recording Transcript
Turns the transcript of a recorded walkthrough into a numbered SOP with prerequisites, steps, screenshots to capture, decision points, and common mistakes, ready for a team wiki.
- Customer Support Macro Set for Refunds, Delays, Angry Customers and Escalation
- 4-Week Small Business Launch Plan: $0 and Small-Budget Versions
- Repetitive Task to Zapier, n8n or Make Automation Spec
- Process Bottleneck Diagnosis and Workflow Redesign With Pilot Plan
- Weekly Operating Review: KPI Variance Diagnosis and Action Plan
- Executive Decision Memo Builder With Options, Risks, and Recommendation