custom-report
Build custom financial reports with user-defined date ranges and categories.
- License 许可
- MIT
- 最近更新
- 2026-11-09
- Stars
- ★ 0
- Forks
- 0
01 前言 Front Matter
- name
- custom-report
- source
- https://github.com/openaccountant/skills
- license
- MIT
- description
- Build custom financial reports with user-defined date ranges and categories.
- imported_at
- 2026-09-20
- source_path
- shared/custom-report/SKILL.md
- source_repository
- openaccountant/skills
03 SKILL.md 正文
Custom Report
Overview
Generate tailored financial reports by specifying date ranges, category filters, transaction types, and output format. Combine spending summaries with transaction-level detail in a single report.
Wilson Tools Used
spending_summary— aggregate spending by category for the specified periodtransaction_search— pull detailed transactions matching filtersexport_transactions— export report data to CSV or Markdown
Workflow
- Ask the user what the report should cover:
- Date range: specific dates, "last 3 months," "Q1 2025," "year to date"
- Categories: all, specific categories, or exclude certain categories
- Transaction type: expenses only, income only, or both
- Minimum amount: optional threshold (e.g., "only transactions over $50")
- Use
spending_summaryto generate category-level aggregates for the date range. - Use
transaction_searchto pull individual transactions matching the filters. - Compile the report with:
- Summary table (category totals, percentages)
- Top transactions by amount
- Transaction count and average per category
- Date range and filter parameters noted at the top
- Ask the user for output format: terminal display, Markdown file, or CSV export.
- If Markdown or CSV, use
export_transactionsto write the file.
Without Wilson
You can build custom reports in a spreadsheet:
Google Sheets / Excel Setup
- Import or paste your transactions into a sheet with columns:
Date,Description,Amount,Category. - Date filtering: Add a filter or use
=FILTER(A:D, A:A >= DATE(2025,1,1), A:A <= DATE(2025,3,31))for Q1 2025. - Category summary pivot table:
- Select your data > Insert > Pivot Table
- Rows: Category
- Values: SUM of Amount, COUNT of Amount
- Filter: Date range
- Manual summary formulas:
Total Expenses: =SUMIFS(C:C, C:C, "<0", A:A, ">="&DATE(2025,1,1), A:A, "<="&DATE(2025,3,31)) Total Income: =SUMIFS(C:C, C:C, ">0", A:A, ">="&DATE(2025,1,1), A:A, "<="&DATE(2025,3,31)) Category Total: =SUMIFS(C:C, D:D, "Groceries", A:A, ">="&DATE(2025,1,1), A:A, "<="&DATE(2025,3,31)) - Top transactions: Sort by Amount (ascending for biggest expenses) and take the top 10.
CLI Alternative (csvkit)
# Filter by date range
csvgrep -c Date -r "2025-0[1-3]" transactions.csv | csvsort -c Amount | head -20
# Summary by category
csvstat -c Amount --group Category transactions.csv
Important Notes
- Date ranges are inclusive on both ends.
- Spending summary shows absolute values (positive numbers) for expenses to improve readability.
- Reports can be re-run with different parameters without re-importing data.
- Markdown export includes a YAML header with report metadata (date generated, filters applied).
04 同仓库更多 Skills
oath
Auditing regulatory compliance (SOC2/PCI-DSS/HIPAA/ISO 27001): maps requirements, checks controls, designs audit trails, implements Policy as Code. Use when compliance auditing is needed.
nexus
Orchestrating multi-specialist task chains and scope-adaptive product delivery: classifies intent, selects and executes the minimum viable chain, aggregates results, and verifies acceptance criteria. For multi-domain tasks, build-first delivery, and product lifecycle execution.
nest
Designing LLM-optimized folder structures: audits and restructures directories for context efficiency, progressive disclosure, and prompt cache performance. Not for general repo structure (Grove).
native
Implementing production iOS/Android/macOS native features (SwiftUI, Compose) and iterating a screen against a reference design. Not for cross-platform RN/Flutter (Port) or web (Artisan).
muse
Defining and managing design tokens, applying token systems to existing codebases, building design system foundations. Use for spacing, color, typography, dark mode, cross-platform output.
morph
Converting document formats (Markdown/Word/Excel/PDF/HTML) and generating reusable conversion scripts. Use for distributable specs, accessibility-compliant PDFs, or Pandoc/LibreOffice pipelines.