Expense report summary prompt: free ChatGPT template
Updated · By Robert Breen
Use this at month end, when expense or reimbursement requests have piled up in a sheet and the owner wants the picture, not the rows. The prompt totals by category and status, lists what's stuck waiting for a receipt or approval, and flags rows worth a question, like a possible duplicate. It doesn't judge what's deductible; that's for your accountant.
Have a professional review it. This prompt helps you explain your own numbers, not give financial advice. Have your accountant or financial advisor review anything you will act on.
The prompt
Copy it into ChatGPT (or Claude, Gemini or Copilot) and replace every [BLANK] with your own details. It uses the four parts from Prompt Writing 101: Role, Context, Task and Format.
Role: You are a bookkeeping assistant at [BUSINESS] preparing a monthly expense summary for [READER]. Context: Below are this month's expense rows, with the header row. Our policy: [POLICY]. Categories we use: [CATEGORIES]. Only total what's in the rows, list any row you couldn't categorize, and don't give tax advice or say whether anything is deductible. Task: Total the amounts by category and by status. List requests waiting on a receipt or approval, with name, amount and what's needed. Flag rows that look like possible duplicates, lack a business purpose or don't fit the policy, with the row number and reason. End with up to three questions for the reader. Format: A totals table, then "Waiting", "Flags" and "Questions" as short lists. Amounts to the cent. Under 250 words. Rows: [EXPENSE ROWS]
Fill in the blanks
[BUSINESS]- Your business name.
[READER]- Who reads it, usually the owner or a partner.
[POLICY]- Your reimbursement rules, copied as written.
[CATEGORIES]- Your expense categories, so the totals match your books.
[EXPENSE ROWS]- The month's rows with a row number column. Remove card numbers before pasting.
Example, filled in
A made-up example from the free lesson Build an Expense Reimbursement Form With AI Policy Checks. Maple Street Bookkeeping is the made-up firm in the expense reimbursement form lesson. Its form agent marks each request Approved, Needs receipt or Needs manager OK and saves it to a sheet. The office manager sums up the month for the owner.
Role: You are a bookkeeping assistant at Maple Street Bookkeeping, a small bookkeeping firm, preparing a monthly expense summary for Ruth, the owner. Context: Below are this month's expense rows, with the header row. Our policy: Needs receipt if the employee says there is no receipt or doesn't mention one; Needs manager OK if the amount is $100 or more; Approved if under $100, with a receipt and a clear business purpose. Categories we use: Travel, Meals, Office supplies, Software, Training. Only total what's in the rows, list any row you couldn't categorize, and don't give tax advice or say whether anything is deductible. Task: Total the amounts by category and by status. List requests waiting on a receipt or approval, with name, amount and what's needed. Flag rows that look like possible duplicates, lack a business purpose or don't fit the policy, with the row number and reason. End with up to three questions for the reader. Format: A totals table, then "Waiting", "Flags" and "Questions" as short lists. Amounts to the cent. Under 250 words. Rows: Row | Name | Expense | Amount | Status 2 | Jamie | Parking at client office, receipt attached | 18.00 | Approved 3 | Priya | Printer toner, receipt attached | 64.99 | Approved 4 | Jamie | Lunch with client, no receipt | 37.40 | Needs receipt 5 | Owen | Bookkeeping software course, receipt attached | 149.00 | Needs manager OK 6 | Priya | Printer toner, receipt attached | 64.99 | Approved 7 | Owen | Team coffee | 22.15 | Needs receipt
What a good answer looks like
- Status totals that add up to the same grand total, $356.53.
- Waiting: Jamie's client lunch and Owen's team coffee need receipts; Owen's $149.00 course needs a manager's OK.
- A possible duplicate on rows 3 and 6: same person, same item, same amount.
- Row 7 raised as a question about business purpose, not as a verdict.
How to check it before you use it
An AI draft can sound right and still say something you never told it. Use the habit from the Reply Faster lesson: check every promise, name, date and number against what you gave it before anything goes out.
- Add the totals yourself or with a SUM in the sheet. Never send AI arithmetic to an owner unchecked.
- Treat flags as questions. Two toner orders in a month can be fine.
- Send questions about how expenses are treated for tax to your CPA, not into the summary.
Why this prompt works
Row numbers behind every flag keep the summary checkable, and banning deductibility comments stops a bookkeeping summary from drifting into tax advice.
Practice it in the free lesson
Build an Expense Reimbursement Form With AI Policy Checks: Build an expense reimbursement form in Lovable for Maple Street Bookkeeping and connect it to n8n — the AI agent checks each request against the policy, saves it to Google Sheets and emails the employee the status. You do every step yourself in a practice copy of Lovable and n8n, and nothing touches your real accounts.
Also useful: Build an AI Agent That Categorizes Business Expenses · AI Receipt Extractor: Receipts to Google Sheets with n8n
Terms used here
Related prompts
- Expense categorization prompt: Sort a batch of expenses into your own categories, with a short note each and a Needs Review bucket for anything unclear…
- Reimbursement decision email prompt: Check an employee's expense request against your written policy, show the rule that decides it, and draft a short email with the…
- Budget variance explanation prompt: Turn a budget-versus-actual report into a plain-English explanation of what moved and why, using only the reasons you give, plus…
- Cash flow summary for owners prompt: Get a plain-English summary of your own cash numbers: where money came from, where it went, and what known bills do to the…