Invoice Organizer
This skill transforms chaotic folders of invoices, receipts, and financial documents into a clean, tax-ready filing system without manual effort.
When to Use This Skill
- Preparing for tax season and need organized records
- Managing business expenses across multiple vendors
- Organizing receipts from a messy folder or email downloads
- Setting up automated invoice filing for ongoing bookkeeping
- Archiving financial records by year or category
- Reconciling expenses for reimbursement
- Preparing documentation for accountants
What This Skill Does
-
Reads Invoice Content: Extracts information from PDFs, images, and documents:
- Vendor/company name
- Invoice number
- Date
- Amount
- Product or service description
- Payment method
-
Renames Files Consistently: Creates standardized filenames:
- Format:
YYYY-MM-DD Vendor - Invoice - ProductOrService.pdf
- Examples:
2024-03-15 Adobe - Invoice - Creative Cloud.pdf
-
Organizes by Category: Sorts into logical folders:
- By vendor
- By expense category (software, office, travel, etc.)
- By time period (year, quarter, month)
- By tax category (deductible, personal, etc.)
-
Handles Multiple Formats: Works with:
- PDF invoices
- Scanned receipts (JPG, PNG)
- Email attachments
- Screenshots
- Bank statements
-
Maintains Originals: Preserves original files while organizing copies
How to Use
Basic Usage
Navigate to your messy invoice folder:
Then ask Claude Code:
Or more specifically:
Advanced Organization
Instructions
When a user requests invoice organization:
-
Scan the Folder
Identify all invoice files:
Report findings:
- Total number of files
- File types
- Date range (if discernible from names)
- Current organization (or lack thereof)
-
Extract Information from Each File
For each invoice, extract:
From PDF invoices:
- Use text extraction to read invoice content
- Look for common patterns:
- "Invoice Date:", "Date:", "Issued:"
- "Invoice #:", "Invoice Number:"
- Company name (usually at top)
- "Amount Due:", "Total:", "Amount:"
- "Description:", "Service:", "Product:"
From image receipts:
- Read visible text from images
- Identify vendor name (often at top)
- Look for date (common formats)
- Find total amount
Fallback for unclear files:
- Use filename clues
- Check file creation/modification date
- Flag for manual review if critical info missing
-
Determine Organization Strategy
Ask user preference if not specified:
-
Create Standardized Filename
For each invoice, create a filename following this pattern:
Examples:
2024-03-15 Adobe - Invoice - Creative Cloud.pdf2024-01-10 Amazon - Receipt - Office Supplies.pdf2023-12-01 Stripe - Invoice - Monthly Payment Processing.pdf
Filename Best Practices:
- Remove special characters except hyphens
- Capitalize vendor names properly
- Keep descriptions concise but meaningful
- Use consistent date format (YYYY-MM-DD) for sorting
- Preserve original file extension
-
Execute Organization
Before moving files, show the plan:
Invoices/
├── 2023/
│ ├── Software/
│ │ ├── Adobe/
│ │ └── Microsoft/
│ ├── Services/
│ └── Office/
└── 2024/
├── Software/
├── Services/
└── Office/
After approval:
-
Generate Summary Report
Create a CSV file with all invoice details:
This CSV is useful for:
- Importing into accounting software
- Sharing with accountants
- Expense tracking and reporting
- Tax preparation
-
Provide Completion Summary
Invoices/
├── 2024/ (45 files)
│ ├── Software/ (23 files)
│ ├── Services/ (12 files)
│ └── Office/ (10 files)
└── 2023/ (12 files)
Examples
Example 1: Tax Preparation (From Martin Merschroth)
User: "I have a messy folder of invoices for taxes. Sort them and rename properly."
Process:
- Scans folder: finds 147 PDFs and images
- Reads each invoice to extract:
- Date
- Vendor name
- Invoice number
- Product/service description
- Renames all files:
YYYY-MM-DD Vendor - Invoice - Product.pdf
- Organizes into:
2024/Software/, 2024/Travel/, etc.
- Creates
invoice-summary.csv for accountant
- Result: Tax-ready organized invoices in minutes
Example 2: Monthly Expense Reconciliation
User: "Organize my business receipts from last month by category."
Output:
Example 3: Multi-Year Archive
User: "I have 3 years of random invoices. Organize them by year, then by vendor."
Output: Creates structure:
Each file properly renamed with date and description.
Example 4: Email Downloads Cleanup
User: "I download invoices from Gmail. They're all named 'invoice.pdf', 'invoice(1).pdf', etc. Fix this mess."
Output:
Common Organization Patterns
By Vendor (Simple)
By Year and Category (Tax-Friendly)
By Quarter (Detailed Tracking)
By Tax Category (Accountant-Ready)
Automation Setup
For ongoing organization:
This creates a persistent solution that organizes invoices as they arrive.
Pro Tips
- Scan emails to PDF: Use Preview or similar to save email invoices as PDFs first
- Consistent downloads: Save all invoices to one folder for batch processing
- Monthly routine: Organize invoices monthly, not annually
- Backup originals: Keep original files before reorganizing
- Include amounts in CSV: Useful for budget tracking
- Tag by deductibility: Note which expenses are tax-deductible
- Keep receipts 7 years: Standard audit period
Handling Special Cases
If date/vendor can't be extracted:
- Flag file for manual review
- Use file modification date as fallback
- Create "Needs-Review/" folder
Duplicate Invoices
If same invoice appears multiple times:
- Compare file hashes
- Keep highest quality version
- Note duplicates in summary
Multi-Page Invoices
For invoices split across files:
- Merge PDFs if needed
- Use consistent naming for parts
- Note in CSV if invoice is split
For unusual receipt formats:
- Extract what's possible
- Standardize what you can
- Flag for review if critical info missing
- Creating expense reports for reimbursement
- Organizing bank statements
- Managing vendor contracts
- Archiving old financial records
- Preparing for audits
- Tracking subscription costs over time