Year-End Summary
Overview
Comprehensive annual financial review covering full-year income and expenses, monthly trends, category breakdowns, year-over-year comparisons, and financial highlights. Useful for tax preparation, goal setting, and understanding your overall financial picture.
Wilson Tools Used
spending_summary — monthly and category-level aggregates for the full year
transaction_search — find notable transactions, income sources, largest expenses
anomaly_detect — identify year-level anomalies and trend shifts
export_transactions — export the full report as Markdown or CSV
Workflow
- Determine the target year (default: previous calendar year).
- Use
spending_summary for each month of the year to build a monthly trend table.
- Use
spending_summary for the full year grouped by category.
- If prior year data exists, pull the same data for year-over-year comparison.
- Use
transaction_search to identify:
- Top 10 largest expenses
- All income sources and totals
- Most frequent vendors
- First and last transactions of the year
- Use
anomaly_detect across the full year to find:
- Months with unusually high or low spending
- Categories with significant year-over-year changes
- Compile the report with sections below.
- Export as Markdown file.
Report Sections
# Year-End Summary — [Year]
## Annual Overview
| Metric | [Year] | [Prior Year] | Change |
|--------|--------|--------------|--------|
| Total Income | $XX,XXX | $XX,XXX | +/-XX% |
| Total Expenses | $XX,XXX | $XX,XXX | +/-XX% |
| Net Savings | $XX,XXX | $XX,XXX | +/-XX% |
| Savings Rate | XX% | XX% | +/-X pts |
## Monthly Trend
| Month | Income | Expenses | Net |
|-------|--------|----------|-----|
| Jan | ... | ... | ... |
| ... | ... | ... | ... |
## Spending by Category (Full Year)
| Category | Amount | % of Total | vs. Prior Year |
|----------|--------|------------|----------------|
| ... | ... | ... | ... |
## Top 10 Expenses
1. ...
## Income Sources
| Source | Total | Frequency |
|--------|-------|-----------|
| ... | ... | ... |
## Year Highlights
- Highest spending month: [Month] ($X,XXX)
- Lowest spending month: [Month] ($X,XXX)
- Biggest single expense: [Description] ($X,XXX)
- Most frequent vendor: [Vendor] (XX transactions)
Without Wilson
To build a year-end summary in a spreadsheet:
- Gather data: Export 12 months of transactions from your bank(s) as CSV. Combine into one sheet.
- Monthly trend pivot table:
- Rows: Month (use
=TEXT(A2,"YYYY-MM") to extract)
- Columns: Income vs. Expense (use
=IF(C2>0,"Income","Expense"))
- Values: SUM of Amount
- Category pivot table:
- Rows: Category
- Values: SUM of Amount, COUNT of transactions
- Year-over-year:
- Keep prior year data in a separate tab
- Use
=VLOOKUP to pull prior year category totals next to current year
- Calculate change:
=(Current - Prior) / ABS(Prior) * 100
- Key formulas:
Annual Income: =SUMPRODUCT((YEAR(A:A)=2025)*(C:C>0)*C:C)
Annual Expenses: =ABS(SUMPRODUCT((YEAR(A:A)=2025)*(C:C<0)*C:C))
Savings Rate: =(Income-Expenses)/Income*100
Highest Month: Use MAX on monthly totals pivot
Most Frequent: =INDEX(B:B,MATCH(MAX(COUNTIF(B:B,B:B)),COUNTIF(B:B,B:B),0))
- Export: Copy the summary tables into a Google Doc or Word document for your records.
Important Notes
- Year-over-year comparison requires at least partial data from the prior year. If unavailable, that column is omitted.
- Savings rate uses gross income (before taxes) unless you've categorized tax payments separately.
- The report includes all transaction types. Transfers between your own accounts are excluded from income/expense totals if properly categorized.
- This report pairs well with the
tax-deduction-tracker skill for tax season preparation.
1---
2name: year-end-summary
3description: >
4 Generate an annual financial review with totals, trends, and highlights.
5metadata:
6 source: https://skillmd.com/skills/openaccountant/year-end-summary
7---
8
9# Year-End Summary
10
11## Overview
12Comprehensive annual financial review covering full-year income and expenses, monthly trends, category breakdowns, year-over-year comparisons, and financial highlights. Useful for tax preparation, goal setting, and understanding your overall financial picture.
13
14## Wilson Tools Used
15- `spending_summary` — monthly and category-level aggregates for the full year
16- `transaction_search` — find notable transactions, income sources, largest expenses
17- `anomaly_detect` — identify year-level anomalies and trend shifts
18- `export_transactions` — export the full report as Markdown or CSV
19
20## Workflow
211. Determine the target year (default: previous calendar year).
222. Use `spending_summary` for each month of the year to build a monthly trend table.
233. Use `spending_summary` for the full year grouped by category.
244. If prior year data exists, pull the same data for year-over-year comparison.
255. Use `transaction_search` to identify:
26 - Top 10 largest expenses
27 - All income sources and totals
28 - Most frequent vendors
29 - First and last transactions of the year
306. Use `anomaly_detect` across the full year to find:
31 - Months with unusually high or low spending
32 - Categories with significant year-over-year changes
337. Compile the report with sections below.
348. Export as Markdown file.
35
36## Report Sections
37```
38# Year-End Summary — [Year]
39
40## Annual Overview
41| Metric | [Year] | [Prior Year] | Change |
42|--------|--------|--------------|--------|
43| Total Income | $XX,XXX | $XX,XXX | +/-XX% |
44| Total Expenses | $XX,XXX | $XX,XXX | +/-XX% |
45| Net Savings | $XX,XXX | $XX,XXX | +/-XX% |
46| Savings Rate | XX% | XX% | +/-X pts |
47
48## Monthly Trend
49| Month | Income | Expenses | Net |
50|-------|--------|----------|-----|
51| Jan | ... | ... | ... |
52| ... | ... | ... | ... |
53
54## Spending by Category (Full Year)
55| Category | Amount | % of Total | vs. Prior Year |
56|----------|--------|------------|----------------|
57| ... | ... | ... | ... |
58
59## Top 10 Expenses
601. ...
61
62## Income Sources
63| Source | Total | Frequency |
64|--------|-------|-----------|
65| ... | ... | ... |
66
67## Year Highlights
68- Highest spending month: [Month] ($X,XXX)
69- Lowest spending month: [Month] ($X,XXX)
70- Biggest single expense: [Description] ($X,XXX)
71- Most frequent vendor: [Vendor] (XX transactions)
72```
73
74## Without Wilson
75To build a year-end summary in a spreadsheet:
76
771. **Gather data**: Export 12 months of transactions from your bank(s) as CSV. Combine into one sheet.
782. **Monthly trend pivot table**:
79 - Rows: Month (use `=TEXT(A2,"YYYY-MM")` to extract)
80 - Columns: Income vs. Expense (use `=IF(C2>0,"Income","Expense")`)
81 - Values: SUM of Amount
823. **Category pivot table**:
83 - Rows: Category
84 - Values: SUM of Amount, COUNT of transactions
854. **Year-over-year**:
86 - Keep prior year data in a separate tab
87 - Use `=VLOOKUP` to pull prior year category totals next to current year
88 - Calculate change: `=(Current - Prior) / ABS(Prior) * 100`
895. **Key formulas**:
90 ```
91 Annual Income: =SUMPRODUCT((YEAR(A:A)=2025)*(C:C>0)*C:C)
92 Annual Expenses: =ABS(SUMPRODUCT((YEAR(A:A)=2025)*(C:C<0)*C:C))
93 Savings Rate: =(Income-Expenses)/Income*100
94 Highest Month: Use MAX on monthly totals pivot
95 Most Frequent: =INDEX(B:B,MATCH(MAX(COUNTIF(B:B,B:B)),COUNTIF(B:B,B:B),0))
96 ```
976. **Export**: Copy the summary tables into a Google Doc or Word document for your records.
98
99## Important Notes
100- Year-over-year comparison requires at least partial data from the prior year. If unavailable, that column is omitted.
101- Savings rate uses gross income (before taxes) unless you've categorized tax payments separately.
102- The report includes all transaction types. Transfers between your own accounts are excluded from income/expense totals if properly categorized.
103- This report pairs well with the `tax-deduction-tracker` skill for tax season preparation.