Invoice Organizer
Organize, categorize, and track invoices and receipts for better financial management.
Overview
This skill helps you:
- Extract key data from invoices
- Categorize expenses automatically
- Track payment status
- Organize files consistently
- Prepare for tax/audit
How to Use
Process Invoice
"Extract data from this invoice" "Categorize this receipt" "Add this invoice to my tracking"
Organize
"Organize my invoice folder" "Create a filing system for receipts" "Sort invoices by vendor and date"
Report
"Summarize invoices by category" "Show unpaid invoices" "Generate expense report for Q1"
Data Extraction
Invoice Data Fields
markdown## Invoice Data Extraction ### Extracted Information | Field | Value | Confidence | |-------|-------|------------| | **Vendor** | Acme Corp | 98% | | **Invoice #** | INV-2026-0042 | 99% | | **Invoice Date** | 2026-01-15 | 99% | | **Due Date** | 2026-02-14 | 99% | | **Subtotal** | $1,250.00 | 98% | | **Tax** | $100.00 | 98% | | **Total** | $1,350.00 | 99% | | **Currency** | USD | 99% | ### Line Items | Description | Qty | Unit Price | Total | |-------------|-----|------------|-------| | Consulting Services | 10 hrs | $100.00 | $1,000.00 | | Software License | 1 | $250.00 | $250.00 | ### Vendor Details - **Company**: Acme Corp - **Address**: 123 Business St, NY 10001 - **Tax ID**: 12-3456789 - **Contact**: billing@acme.com ### Payment Information - **Terms**: Net 30 - **Method**: Bank Transfer - **Account**: XXXX-1234
Categorization
Expense Categories
markdown## Expense Category System ### Standard Categories | Category | Subcategory | Examples | |----------|-------------|----------| | **Office** | Supplies | Paper, pens, toner | | | Equipment | Computers, furniture | | | Services | Cleaning, maintenance | | **Travel** | Transportation | Flights, trains, taxis | | | Accommodation | Hotels, Airbnb | | | Meals | Client dinners, per diem | | **Software** | Subscriptions | SaaS, cloud services | | | Licenses | One-time purchases | | **Professional** | Legal | Attorney fees | | | Accounting | CPA, bookkeeping | | | Consulting | Advisors, contractors | | **Marketing** | Advertising | Ads, sponsorships | | | Events | Conferences, booths | | | Content | Design, copywriting | | **Utilities** | Phone/Internet | Telecom services | | | Cloud/Hosting | AWS, servers | ### Auto-Categorization Rules | Vendor Contains | → Category | |-----------------|------------| | Amazon Web Services | Software > Cloud | | Office Depot | Office > Supplies | | United Airlines | Travel > Transportation | | Marriott, Hilton | Travel > Accommodation | | Adobe, Microsoft | Software > Subscriptions |
Filing System
Folder Structure
markdown## Invoice Filing System ### By Year and Category
📁 Invoices/ ├── 📁 2026/ │ ├── 📁 Office/ │ │ └── 2026-01-15_Staples_125.50_INV001.pdf │ ├── 📁 Software/ │ │ └── 2026-01-20_Adobe_54.99_INV002.pdf │ ├── 📁 Travel/ │ │ └── 2026-01-22_United_450.00_INV003.pdf │ ├── 📁 Professional/ │ └── 📁 Other/ ├── 📁 2025/ │ └── ... └── 📁 Archive/
### Naming Convention
YYYY-MM-DD_Vendor_Amount_InvoiceNumber.pdf
**Examples**: - 2026-01-15_AcmeCorp_1350.00_INV-2026-0042.pdf - 2026-01-20_Adobe_54.99_Monthly.pdf - 2026-01-22_DeltaAirlines_425.00_CONF123456.pdf
Tracking System
Invoice Register
markdown## Invoice Tracking Register ### Open Invoices | Invoice # | Vendor | Date | Due | Amount | Status | Days | |-----------|--------|------|-----|--------|--------|------| | INV-042 | Acme | 01/15 | 02/14 | $1,350 | ⏳ Pending | 14 | | INV-045 | Beta | 01/18 | 02/17 | $890 | ⏳ Pending | 11 | | INV-048 | Gamma | 01/22 | 01/29 | $500 | 🔴 Overdue | -1 | ### Recently Paid | Invoice # | Vendor | Paid Date | Amount | Method | |-----------|--------|-----------|--------|--------| | INV-038 | Delta | 01/25 | $720 | ACH | | INV-035 | Epsilon | 01/22 | $1,200 | Check | ### Summary | Status | Count | Total | |--------|-------|-------| | Pending | 2 | $2,240 | | Overdue | 1 | $500 | | Paid (Jan) | 2 | $1,920 |
Payment Tracking
markdown## Invoice Payment Tracker ### Invoice: INV-2026-0042 (Acme Corp) | Date | Event | Notes | |------|-------|-------| | 01/15 | Received | Via email | | 01/16 | Reviewed | Approved by Manager | | 01/20 | Scheduled | Payment batch 01/25 | | 01/25 | Paid | ACH Ref: 789456 | | 01/25 | Filed | /2026/Professional/ | ### Payment Details - **Method**: ACH Transfer - **Reference**: 789456 - **Bank**: Chase Business - **Confirmation**: Sent to vendor
Reports
Monthly Summary
markdown## Invoice Summary: January 2026 ### Overview | Metric | Value | |--------|-------| | Total Invoices | 28 | | Total Amount | $12,450.00 | | Avg per Invoice | $444.64 | | Paid | 22 ($9,800) | | Pending | 4 ($2,150) | | Overdue | 2 ($500) | ### By Category | Category | Count | Amount | % of Total | |----------|-------|--------|------------| | Software | 8 | $4,200 | 33.7% | | Professional | 5 | $3,500 | 28.1% | | Office | 6 | $2,100 | 16.9% | | Travel | 4 | $1,650 | 13.3% | | Utilities | 3 | $600 | 4.8% | | Other | 2 | $400 | 3.2% | ### By Vendor | Vendor | Invoices | Total | |--------|----------|-------| | Adobe | 2 | $1,200 | | AWS | 1 | $2,800 | | Acme Corp | 3 | $3,200 | | ... | ... | ... | ### Trends - Software expenses up 15% from December - Travel expenses down 20% (seasonal) - New vendor added: Gamma Inc.
Tax Preparation
markdown## Tax-Ready Invoice Report: 2025 ### Annual Summary | Category | Total | Tax Deductible | |----------|-------|----------------| | Office Supplies | $4,500 | ✅ Yes | | Software | $18,000 | ✅ Yes | | Travel - Business | $8,200 | ✅ Yes | | Travel - Meals (50%) | $1,200 | ⚠️ Partial | | Professional Services | $12,000 | ✅ Yes | | **Total Deductible** | **$43,900** | | ### Required Documentation | Expense Over $75 | Count | Status | |------------------|-------|--------| | With receipt | 45 | ✅ | | Missing receipt | 3 | ⚠️ | ### Missing Receipts | Date | Vendor | Amount | Action | |------|--------|--------|--------| | 03/15 | Hotel ABC | $189 | Request from vendor | | 07/22 | Uber | $85 | Download from app | | 11/08 | Restaurant | $95 | Use bank statement | ### Vendor 1099 Review | Vendor | Total Paid | 1099 Required | |--------|------------|---------------| | Consultant A | $8,500 | ✅ Yes (>$600) | | Consultant B | $450 | ❌ No |
Automation Rules
Auto-Processing
markdown## Invoice Automation Rules ### Email Processing | Trigger | Action | |---------|--------| | From: *@vendor1.com | Auto-categorize: Software | | Subject: "Invoice" | Add to review queue | | Attachment: PDF | Extract data | ### Auto-Categorization | Condition | Category | Confidence | |-----------|----------|------------| | Vendor = Adobe | Software > Subscriptions | High | | Contains "flight" | Travel > Transportation | High | | Amount < $50 | Office > Supplies | Medium | ### Alerts | Condition | Alert | |-----------|-------| | Due in 3 days | Email reminder | | Overdue | Daily notification | | Large invoice (>$1000) | Manager approval required |
Limitations
- Cannot perform actual file operations
- OCR quality affects data extraction
- Categories may need manual adjustment
- Cannot integrate directly with accounting software
- Exchange rates need external verification
- Tax advice should come from professionals
