1. Front page
  2. Playbooks
  3. Monthly expense report
Playbooks · Money

Monthly expense report

When a month closes, its receipts become a categorised report with totals.

Paste this into your agent

On the first working day of each month, gather the receipts and invoices that reached my email and the receipts folder during the previous month. Build a report in my expenses spreadsheet with the date, supplier, amount, currency and category for each item, then total each category and compare it with the month before. List any receipt you could not categorise instead of guessing. Edit nothing but that spreadsheet, and never pay, approve or mark anything as paid.

What the agent does

  1. Collect receipts and invoices from email and the receipts folder

  2. Record each item with supplier, amount, currency and category

  3. Total the categories and compare them with the previous month

  4. List unclear items for your judgement

Rules to add

  • Edits are confined to the one expenses spreadsheet you name
  • No payments, approvals or items marked as paid
  • Uncertain items are flagged rather than guessed

What you end up with: A finished monthly expense report and a short list of items only you can decide.