# Expense report summary prompt: free ChatGPT template > Summarize a month of expense or reimbursement rows for the owner: totals by category and status, what's waiting, and flags to ask about, with row numbers. Source: https://learn.ynteractive.com/content/prompts/expense-report-summary-prompt · Updated 2026-10-01 · Free from Stepthrough (https://learn.ynteractive.com) [Reports and planning](https://learn.ynteractive.com/content/prompts#job-reports-and-planning) · [Finance](https://learn.ynteractive.com/content/prompts#industry-finance) · [Accounting](https://learn.ynteractive.com/content/prompts#industry-accounting) · Works in ChatGPT, Claude, Gemini and Copilot Updated October 1, 2026 · By [Robert Breen](https://learn.ynteractive.com/content/about) 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](https://learn.ynteractive.com/content/prompt-writing-101-role-context-task-format): Role, Context, Task and Format. Copy prompt ```text 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](https://learn.ynteractive.com/content/expense-reimbursement-form-ai-approval-lovable-n8n). 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. Copy example ```text 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](https://learn.ynteractive.com/content/chatgpt-reply-to-customer-emails): 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](https://learn.ynteractive.com/content/expense-reimbursement-form-ai-approval-lovable-n8n)**: 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. [Start the free lesson](https://learn.ynteractive.com/modules/lovable-n8n-finance) Also useful: [Build an AI Agent That Categorizes Business Expenses](https://learn.ynteractive.com/content/n8n-ai-agent-categorize-business-expenses-google-sheets) · [AI Receipt Extractor: Receipts to Google Sheets with n8n](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets) ## Terms used here [Expense reimbursement](https://learn.ynteractive.com/content/glossary/expense-reimbursement) · [Expense categorization](https://learn.ynteractive.com/content/glossary/expense-categorization) · [Google Sheets (as an automation database)](https://learn.ynteractive.com/content/glossary/google-sheets) ## Related prompts - [Expense categorization prompt](https://learn.ynteractive.com/content/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](https://learn.ynteractive.com/content/prompts/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](https://learn.ynteractive.com/content/prompts/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](https://learn.ynteractive.com/content/prompts/cash-flow-summary-for-owner-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… [All free prompt templates](https://learn.ynteractive.com/content/prompts) · [AI glossary](https://learn.ynteractive.com/content/glossary)