Monthly Digest

Overview

Wilson Tools Used

• spending_summary

  — category-level spending totals for the month

• transaction_search

  — find largest transactions and income entries

• anomaly_detect

  — flag unusual spending patterns or amounts

Workflow

1. Determine the target month (default: previous calendar month).
2. Use

   spending_summary

   to get category totals for the month.
3. Use

   spending_summary

   for the prior month to calculate month-over-month changes.
4. Use

   transaction_search

   to find:
   • Top 5 largest expenses
   • All income transactions
   • Any new vendors (first-time transactions)
5. Use

   anomaly_detect

   to flag:
   • Unusual amounts (significantly above category average)
   • New recurring charges
   • Missing expected recurring charges
6. Compile the digest using the template below.
7. Display the digest and optionally export as Markdown.

Digest Template

# Monthly Digest — [Month Year]

## Key Numbers
| Metric | Amount | vs. Last Month |
|--------|--------|----------------|
| Total Income | $X,XXX | +/-XX% |
| Total Expenses | $X,XXX | +/-XX% |
| Net (Income - Expenses) | $X,XXX | — |
| Savings Rate | XX% | +/-X pts |

## Spending by Category
| Category | Amount | % of Total | vs. Last Month |
|----------|--------|------------|----------------|
| ... | ... | ... | ... |

## Top 5 Expenses
1. [Description] — $XXX on [Date]
2. ...

## Anomalies & Alerts
- [flag icon] [Description of anomaly]

## New This Month
- First time seeing: [vendor name]

Without Wilson

1. Export the month's transactions from your bank as CSV.
2. Open in Google Sheets and add a Category column if missing.
3. Key numbers:

   Total Income:   =SUMIFS(Amount, Amount, ">0", Date, ">="&DATE(2025,3,1), Date, "<="&DATE(2025,3,31))
   Total Expenses: =ABS(SUMIFS(Amount, Amount, "<0", Date, ">="&DATE(2025,3,1), Date, "<="&DATE(2025,3,31)))
   Savings Rate:   =(Income - Expenses) / Income * 100

4. Category breakdown: Create a pivot table grouped by Category, summing Amount.
5. Top expenses: Sort by Amount ascending, take the first 5 rows.
6. Month-over-month: Keep last month's totals in a separate tab and calculate

   =(ThisMonth - LastMonth) / LastMonth * 100

   for each category.
7. Anomaly detection (manual): Calculate the average and standard deviation per category over the last 6 months. Flag any category where this month's spending exceeds the average + 2 standard deviations.

Important Notes

• The digest defaults to the previous calendar month. Ask for a specific month if needed.
• Savings rate is calculated as

  (income - expenses) / income

  . If income is zero, savings rate is shown as N/A.
• Anomaly detection uses a rolling 6-month window. New users with less history will see fewer anomaly flags.
• The digest does not include transfers between your own accounts (e.g., savings transfers) in the income/expense totals.