# Year End Summary

> >

- **Type:** Skill
- **Install:** `agentstack add skill-openaccountant-skills-year-end-summary`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [openaccountant](https://agentstack.voostack.com/s/openaccountant)
- **Installs:** 0
- **Category:** [Agent Skills](https://agentstack.voostack.com/c/agent-skills)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [openaccountant](https://github.com/openaccountant)
- **Source:** https://github.com/openaccountant/skills/tree/main/shared/year-end-summary

## Install

```sh
agentstack add skill-openaccountant-skills-year-end-summary
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# 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
1. Determine the target year (default: previous calendar year).
2. Use `spending_summary` for each month of the year to build a monthly trend table.
3. Use `spending_summary` for the full year grouped by category.
4. If prior year data exists, pull the same data for year-over-year comparison.
5. Use `transaction_search` to identify:
   - Top 10 largest expenses
   - All income sources and totals
   - Most frequent vendors
   - First and last transactions of the year
6. Use `anomaly_detect` across the full year to find:
   - Months with unusually high or low spending
   - Categories with significant year-over-year changes
7. Compile the report with sections below.
8. 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:

1. **Gather data**: Export 12 months of transactions from your bank(s) as CSV. Combine into one sheet.
2. **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
3. **Category pivot table**:
   - Rows: Category
   - Values: SUM of Amount, COUNT of transactions
4. **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`
5. **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))
   ```
6. **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.

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [openaccountant](https://github.com/openaccountant)
- **Source:** [openaccountant/skills](https://github.com/openaccountant/skills)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-openaccountant-skills-year-end-summary
- Seller: https://agentstack.voostack.com/s/openaccountant
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.