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