Monthly Digest
Overview
Produce a concise monthly financial digest covering income, expenses, savings rate, notable transactions, spending anomalies, and month-over-month trends. Designed to be a quick "state of your finances" snapshot.
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
- Determine the target month (default: previous calendar month).
- Use
spending_summary to get category totals for the month.
- Use
spending_summary for the prior month to calculate month-over-month changes.
- Use
transaction_search to find:
- Top 5 largest expenses
- All income transactions
- Any new vendors (first-time transactions)
- Use
anomaly_detect to flag:
- Unusual amounts (significantly above category average)
- New recurring charges
- Missing expected recurring charges
- Compile the digest using the template below.
- 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
To create a monthly digest manually:
- Export the month's transactions from your bank as CSV.
- Open in Google Sheets and add a Category column if missing.
- 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
- Category breakdown: Create a pivot table grouped by Category, summing Amount.
- Top expenses: Sort by Amount ascending, take the first 5 rows.
- Month-over-month: Keep last month's totals in a separate tab and calculate
=(ThisMonth - LastMonth) / LastMonth * 100 for each category.
- 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.
1---
2name: monthly-digest
3description: >
4 Generate a monthly financial summary with metrics, trends, and anomalies.
5metadata:
6 source: https://skillmd.com/skills/openaccountant/monthly-digest
7---
8
9# Monthly Digest
10
11## Overview
12Produce a concise monthly financial digest covering income, expenses, savings rate, notable transactions, spending anomalies, and month-over-month trends. Designed to be a quick "state of your finances" snapshot.
13
14## Wilson Tools Used
15- `spending_summary` — category-level spending totals for the month
16- `transaction_search` — find largest transactions and income entries
17- `anomaly_detect` — flag unusual spending patterns or amounts
18
19## Workflow
201. Determine the target month (default: previous calendar month).
212. Use `spending_summary` to get category totals for the month.
223. Use `spending_summary` for the prior month to calculate month-over-month changes.
234. Use `transaction_search` to find:
24 - Top 5 largest expenses
25 - All income transactions
26 - Any new vendors (first-time transactions)
275. Use `anomaly_detect` to flag:
28 - Unusual amounts (significantly above category average)
29 - New recurring charges
30 - Missing expected recurring charges
316. Compile the digest using the template below.
327. Display the digest and optionally export as Markdown.
33
34## Digest Template
35```
36# Monthly Digest — [Month Year]
37
38## Key Numbers
39| Metric | Amount | vs. Last Month |
40|--------|--------|----------------|
41| Total Income | $X,XXX | +/-XX% |
42| Total Expenses | $X,XXX | +/-XX% |
43| Net (Income - Expenses) | $X,XXX | — |
44| Savings Rate | XX% | +/-X pts |
45
46## Spending by Category
47| Category | Amount | % of Total | vs. Last Month |
48|----------|--------|------------|----------------|
49| ... | ... | ... | ... |
50
51## Top 5 Expenses
521. [Description] — $XXX on [Date]
532. ...
54
55## Anomalies & Alerts
56- [flag icon] [Description of anomaly]
57
58## New This Month
59- First time seeing: [vendor name]
60```
61
62## Without Wilson
63To create a monthly digest manually:
64
651. **Export the month's transactions** from your bank as CSV.
662. **Open in Google Sheets** and add a Category column if missing.
673. **Key numbers**:
68 ```
69 Total Income: =SUMIFS(Amount, Amount, ">0", Date, ">="&DATE(2025,3,1), Date, "<="&DATE(2025,3,31))
70 Total Expenses: =ABS(SUMIFS(Amount, Amount, "<0", Date, ">="&DATE(2025,3,1), Date, "<="&DATE(2025,3,31)))
71 Savings Rate: =(Income - Expenses) / Income * 100
72 ```
734. **Category breakdown**: Create a pivot table grouped by Category, summing Amount.
745. **Top expenses**: Sort by Amount ascending, take the first 5 rows.
756. **Month-over-month**: Keep last month's totals in a separate tab and calculate `=(ThisMonth - LastMonth) / LastMonth * 100` for each category.
767. **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.
77
78## Important Notes
79- The digest defaults to the previous calendar month. Ask for a specific month if needed.
80- Savings rate is calculated as `(income - expenses) / income`. If income is zero, savings rate is shown as N/A.
81- Anomaly detection uses a rolling 6-month window. New users with less history will see fewer anomaly flags.
82- The digest does not include transfers between your own accounts (e.g., savings transfers) in the income/expense totals.