Invoice Organizer

# 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