expense receipt sorter

Managing a messy pile of receipts or bank statements during tax season is a manual grind that invites errors. This skill automates the categorization of expense lines, providing clear totals for freelancers and small business owners without requiring complex accounting software.

What it does

• Automatic Categorization maps expense descriptions to plain-English categories using keyword matching.
• Financial Totaling calculates sub-totals for every category and a grand total for the entire period.
• Exception Handling isolates uncategorized items for manual review to ensure no spend is missed.
• Rule Customization allows users to define specific store names or keywords for personalized sorting logic.
• Risk Flagging identifies suspicious entries, such as unusually high amounts, for human verification.

How it works

1. Data Input accepts pasted text or CSV files containing dates, descriptions, and amounts.
2. Sorting Logic executes a Python-based sorter against a JSON reference of categories and keywords.
3. Review Phase presents categorized totals and asks for clarification on any unknown items.
4. Logic Update updates the ruleset if you want specific recurring vendors recognized in future runs.

Frameworks & tools

This skill uses a Python-based processing engine and JSON-based rule definitions. It operates on standard CSV data structures and requires no external database or API connections.

Why this beats prompting it yourself

Generic prompts often hallucinate categories or fail to maintain consistent totals across large datasets. This skill uses a deterministic script to ensure math is accurate and allows you to build a persistent, reusable library of categorization rules.

Use cases

• Preparing expense totals for Schedule C tax filing.
• Auditing monthly business spend across multiple credit card statements.
• Organizing messy shoeboxes of digital receipts into structured reports.
• Flagging duplicate or unusually high transactions for manual audit.

Known limitations

This tool does not provide tax advice and cannot determine deductibility. It processes text and CSV data but does not perform OCR on image files of receipts.