back
loading skill details...
Organize, categorize, and track invoices and receipts
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
don't have the plugin yet? install it then click "run inline in claude" again.