Skip to content AI News: Nano Banana 2.1 is out: better edits and text, half the API price per image →
PH-0889 · Text prompt

Receipt Expense Logger

A Gemini prompt that reads photos of receipts and returns a clean expense table you can paste straight into Google Sheets.

What you get

Reads photos of receipts and returns a clean expense table you can paste straight into Google Sheets.

What you need
  • One blank to fill in: attach the files
Best inGeminiAlso works in ChatGPT, Claude
232 words
Prompt · September 19, 2026
I want you to act as a bookkeeping assistant who reads receipts. I will attach photos or PDFs of receipts, and you will turn them into one clean expense table.

For each receipt, read the merchant, the date, the currency, the total, the tax amount if it is printed, the payment method if it is visible, and the individual line items when they are legible. Put the result in a table with the columns Date, Merchant, Category, Description, Net, Tax, Total, Currency, Payment Method, File. Use these categories and no others: travel, meals, accommodation, software, equipment, office supplies, marketing, fees, other. Format dates as YYYY-MM-DD. Keep amounts as plain numbers with two decimals and no currency symbol inside the number column.

Never guess a figure you cannot read. Where a value is unclear, write UNREADABLE in that cell and add the receipt to a short list at the end called Needs a human, saying exactly which field failed. Do the same for a receipt that is cut off, blurred, or in a language you are unsure of, naming the language.

After the table, give me three lines: the total per category, the total overall per currency, and any receipt that looks duplicated, naming both files. Do not give tax advice and do not decide what is deductible.

My first request is: "Here are eleven receipts from a conference trip. [attach the files]"
Finance & Legal Gemini

How to use it

  1. Fill the blanks under «Make it yours» — the prompt updates as you type.
  2. Copy the prompt and paste it into Gemini.
  3. Not quite right? Reply with what to change — the model keeps the rest.

More Gemini prompts

PH-0689Coding

Apps Script Automator

Turn any repetitive Sheets, Gmail or Drive chore into working, commented Google Apps Script with setup and trigger steps.

You fill in PipelineOwnerStage

Gemini
PH-0755Business

Deep Research Brief

Turns a rough question into a scoped Deep Research brief: sub-questions, preferred sources, exclusions, report outline…

You fill in cut-off datethe market for AI note-taking…Q3 build-or-buy decision

Gemini
PH-0760Writing

Docs Draft Polisher

Line-edits any Google Doc you link, returning a tightened draft plus a change log while keeping your voice and required terms.

You fill in confirm figurerequired terminologywho will read this+3 more

Gemini
PH-0772Writing

Email Reply Drafter

Reference a Gmail message and get three ready-to-paste reply drafts in your own voice, short, standard and detailed.

You fill in confirm datenameDaniel Okafor+1 more

Gemini
PH-0795Productivity

Gmail Thread Summarizer

Turns a long Gmail thread into decisions, open questions, owner-and-deadline actions and one suggested next step you can send.

You fill in subjectnumberdate of first+4 more

Gemini
PH-0926Business

Slides Deck Outliner

Paste this Gemini prompt to turn a long report, PDF or Google Doc into a slide-by-slide deck outline with titles, bullets, speaker notes and visuals.

You fill in confirm figurenumbertitle of under eight words+3 more

Gemini
Weekly

New prompts in your inbox

One email a week: the best new prompts and one short guide. Unsubscribe any time. Privacy policy