Invoice Organizer

SKILL.md

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

## 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

## 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

## 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

## 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

## 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

## 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

## 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

## 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