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

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

At a glanceEUR expenses by category, March Berlin tripMeals includes a possible duplicate of 19.00; Software was 45.00 USD
  • Travel: 387.50
  • Equipment: 340.00
  • Meals: 38.00
  • Office supplies: 24.90

Example for: 7 uploaded files from a freelance designer's March trip to Berlin, no card statement.

1. Expense table

filedatevendorinvoice/receipt no.nettaxtotalcurrencycategorypayment methodnotes
IMG_2041.jpg2025-03-03Bahnhof Café Mitte00481715.973.0319.00EURMealsCard ****441219% VAT
IMG_2042.jpg2025-03-03Bahnhof Café Mitte00481715.973.0319.00EURMealsCard ****4412Possible duplicate of IMG_2041
hotel_invoice.pdf2025-03-05Hotel Lindenhof GmbHRE-2025-0392336.4523.55360.00EURTravelCard ****44123 nights, 7% VAT
figma_mar.pdf2025-03-01Figma, Inc.INV-88213-003145.0045.00USDSoftwareCard ****4412No tax line printed
taxi.jpgCHECKTaxi BerlinCHECK27.50EURTravelCashDate and number faded; total only
staples_receipt.jpg2025-03-07Papeterie Nord11-229020.923.9824.90EUROffice suppliesCard ****4412Sketchbooks, pens
monitor_order.pdf2025-03-10TechDirekt AGCHECK285.7154.29340.00EUREquipmentPayPalInvoice number cut off at page edge

Skipped (not a receipt or invoice):

  • boarding_pass.pdf: boarding pass with no price shown

2. Totals

By category

categoryEURUSD
Travel387.500.00
Meals38.000.00
Software0.0045.00
Office supplies24.900.00
Equipment340.000.00
Other0.000.00

By currency

  • EUR: 790.40 (19.00 of this is a possible duplicate)
  • USD: 45.00

No currencies were converted because no exchange rate was provided.

3. Flags

  • CHECK fields

    • taxi.jpg: the date and receipt number are unreadable.
    • monitor_order.pdf: the invoice number is cut off.
  • Possible duplicates

    • IMG_2041.jpg and IMG_2042.jpg match on vendor, date, total and receipt number. They look like two photos of the same receipt, so delete one if that is the case.
  • Missing receipts

    • Not checked, because no card statement was uploaded.

4. CSV

file,date,vendor,invoice_or_receipt_number,net,tax,total,currency,category,payment_method,notes
IMG_2041.jpg,2025-03-03,Bahnhof Café Mitte,004817,15.97,3.03,19.00,EUR,Meals,Card ****4412,19% VAT
IMG_2042.jpg,2025-03-03,Bahnhof Café Mitte,004817,15.97,3.03,19.00,EUR,Meals,Card ****4412,Possible duplicate of IMG_2041
hotel_invoice.pdf,2025-03-05,Hotel Lindenhof GmbH,RE-2025-0392,336.45,23.55,360.00,EUR,Travel,Card ****4412,"3 nights, 7% VAT"
figma_mar.pdf,2025-03-01,"Figma, Inc.",INV-88213-0031,45.00,,45.00,USD,Software,Card ****4412,No tax line printed
taxi.jpg,CHECK,Taxi Berlin,CHECK,,,27.50,EUR,Travel,Cash,Date and number faded; total only
staples_receipt.jpg,2025-03-07,Papeterie Nord,11-2290,20.92,3.98,24.90,EUR,Office supplies,Card ****4412,"Sketchbooks, pens"
monitor_order.pdf,2025-03-10,TechDirekt AG,CHECK,285.71,54.29,340.00,EUR,Equipment,PayPal,Invoice number cut off at page edge

This table is for data entry only. Ask your accountant which of these expenses are deductible.

Written by AI from this prompt. Your results will vary.

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
How prompts are written and checked

Did this prompt work?

Keep exploring

More in AI Business Workflows