spending-review
Generate a categorized spending breakdown with month-over-month trends.
- License 许可
- MIT
- 最近更新
- 2026-11-09
- Stars
- ★ 0
- Forks
- 0
01 前言 Front Matter
- name
- spending-review
- source
- https://github.com/openaccountant/skills
- license
- MIT
- description
- Generate a categorized spending breakdown with month-over-month trends.
- imported_at
- 2026-09-20
- source_path
- personal/spending-review/SKILL.md
- source_repository
- openaccountant/skills
03 SKILL.md 正文
Spending Review
Overview
Produces a categorized breakdown of your spending for a given period, compares it against prior months to show trends, and highlights categories where spending increased or decreased significantly.
Wilson Tools Used
spending_summary— get total spending grouped by category for any date rangetransaction_search— drill into specific categories for transaction-level detail
Workflow
- Run
spending_summaryfor the current month to get category-level totals. - Run
spending_summaryfor the previous month to establish a comparison baseline. - Calculate the dollar change and percentage change for each category between the two months.
- Flag any category where spending increased by more than 20% or more than $100.
- For each flagged category, run
transaction_searchwithcategory: "<flagged_category>"andmonths: 1to pull the individual transactions driving the increase. - Present results as a summary table with columns: Category, This Month, Last Month, Change ($), Change (%), Trend Arrow.
- Below the table, list the top 3 categories by absolute spending and the top 3 by percentage increase.
- Provide a one-paragraph narrative summary describing the overall spending pattern and notable changes.
Without Wilson
- Export your last two months of transactions as CSV files from your bank (most banks: Account > Statements > Download > CSV format).
- Open both CSVs in Google Sheets. Combine them into one sheet with a "Month" column added.
- If your bank doesn't categorize transactions, manually add a "Category" column. Common categories: Groceries, Dining, Transportation, Utilities, Entertainment, Shopping, Health, Subscriptions.
- Create a pivot table: Rows = Category, Columns = Month, Values = SUM of Amount.
- Add a calculated column for change:
=B2-C2(this month minus last month). - Add a percentage change column:
=IF(C2<>0, (B2-C2)/ABS(C2)*100, "New"). - Conditional format the change column: red for increases, green for decreases (since spending is negative, reverse the logic or use absolute values).
- Sort by absolute change descending to see your biggest movers.
- For a quick visual, insert a bar chart from the pivot table showing this month vs. last month by category.
Important Notes
- Category accuracy depends on your bank's auto-categorization or Wilson's categorization rules. Run the
categorizetool first if many transactions are uncategorized. - One-time large purchases (appliances, travel, medical) can skew month-over-month comparisons. Consider whether a spike is a true trend or an outlier.
- For a more meaningful view, compare against a 3-month rolling average rather than just the prior month.
04 同仓库更多 Skills
dei-assessment
Assess diversity, equity, and inclusion with metrics. TRIGGERS - Use when user needs help with dei-assessment related tasks.
dei-action-plan
Create DEI action plans with goals and initiatives. TRIGGERS - Use when user needs help with dei-action-plan related tasks.
culture-fit-assessment
Design culture add assessment processes. TRIGGERS - Use when user needs help with culture-fit-assessment related tasks.
cowork-to-code-bridge
Use an already-installed, independently verified cowork-to-code bridge to run narrowly approved actions on the user's own macOS, Linux, or WSL2 machine through a local file queue.
counter-offer-response
Draft counter-offer responses for retention. TRIGGERS - Use when user needs help with counter-offer-response related tasks.
continuous-feedback-system
Design continuous feedback systems. TRIGGERS - Use when user needs help with continuous-feedback-system related tasks.