Invoice Tracker Pro

Invoice Tracker

Get paid what you're owed. This skill handles the complete billing lifecycle — from invoice creation to payment reconciliation — with professional templates, automated reminders, and financial reporting.

What It Does

Invoice Generation: Professional invoices from project data Payment Tracking: Know who owes what and when Automated Reminders: Polite follow-ups for overdue payments Payment Reconciliation: Match payments to invoices Financial Reporting: Revenue, aging, tax summaries Recurring Billing: Retainers and subscription invoices Late Fee Management: Calculate and apply late fees

1. Create Your First Invoice

"Create an invoice for: Client: [Company Name] Client Email: [email] Project: [Project Name] Invoice #: INV-2024-001 Issue Date: [date] Due Date: Net 15 Line Items: 1. Website Design - $5,000 2. Development - $3,500 3. CMS Training - $500 Payment terms: Net 15, 1.5% late fee after 30 days Payment methods: Bank transfer, PayPal, credit card"

2. Batch Invoice Creation

"Generate monthly invoices for my retainer clients: Client A: $2,000/month - Website maintenance Client B: $1,500/month - Ongoing consulting Client C: $3,000/month - Marketing support Period: January 2024 Terms: Net 30 Include: Hours summary, deliverables completed"

3. Overdue Payment Follow-Up

"Create follow-up emails for overdue invoices: Invoice INV-2024-005 - $4,500 - 15 days overdue Invoice INV-2024-008 - $2,200 - 30 days overdue Invoice INV-2024-012 - $6,000 - 45 days overdue Tone: Professional but firm Include: Payment link, original invoice, late fee notice"

Required Elements

Header: Your business name/logo Invoice number (unique, sequential) Issue date Due date Parties: From: Your business name, address, tax ID To: Client name, contact person, billing address Line Items: DescriptionQuantityRateAmountService name10 hours$100/hr$1,000Deliverable1$2,500$2,500 Totals: Subtotal Tax (if applicable) Discounts Total Due Footer: Payment instructions Terms and conditions Thank you message

Professional Invoice Template

┌─────────────────────────────────────────────────────────┐ │ [YOUR LOGO] INVOICE │ │ Your Business Name #INV-2024-001│ │ 123 Main Street Date: Jan 15 │ │ City, ST 12345 Due: Feb 1 │ │ contact@yourbusiness.com │ ├─────────────────────────────────────────────────────────┤ │ BILL TO: │ │ Client Company Name │ │ Attn: Accounts Payable │ │ 456 Business Ave │ │ City, ST 67890 │ ├─────────────────────────────────────────────────────────┤ │ PROJECT: Website Redesign │ ├─────────────────────────────────────────────────────────┤ │ Description │ Qty │ Rate │ Amount │ │ ──────────────────────┼─────┼───────────┼─────────────│ │ Discovery & Strategy │ 1 │ $1,500.00 │ $1,500.00 │ │ UI/UX Design │ 1 │ $3,000.00 │ $3,000.00 │ │ Frontend Development │ 40 │ $100.00 │ $4,000.00 │ │ CMS Integration │ 1 │ $1,500.00 │ $1,500.00 │ │ ──────────────────────┴─────┴───────────┼─────────────│ │ Subtotal │ $10,000.00 │ │ Tax (0%) │ $0.00 │ │ ─────────────────────────│ │ TOTAL DUE │ $10,000.00 │ ├─────────────────────────────────────────────────────────┤ │ PAYMENT OPTIONS: │ │ • Bank Transfer: [Account details] │ │ • PayPal: [PayPal.me link] │ │ • Credit Card: [Stripe/PayPal link] │ │ │ │ TERMS: Net 30. Late payments subject to 1.5% monthly │ │ service charge after 30 days. │ │ │ │ Questions? Contact: billing@yourbusiness.com │ │ Thank you for your business! │ └─────────────────────────────────────────────────────────┘

Invoice Status Categories

DRAFT → Created but not sent SENT → Issued to client, awaiting payment VIEWED → Client opened invoice (if using online system) PARTIAL → Partial payment received PAID → Full payment received OVERDUE → Past due date, payment pending COLLECTIONS → Seriously overdue, escalation needed VOID → Cancelled/replaced

Aging Report

Track overdue invoices by age: Aging Report - February 2024 Client Invoice Amount 0-30 31-60 60+ ───────────────────────────────────────────────────────────── ABC Corp INV-005 $4,500 $4,500 XYZ Inc INV-008 $2,200 $2,200 123 LLC INV-012 $6,000 $6,000 ───────────────────────────────────────────────────────────── TOTALS $12,700 $2,200 $4,500 $6,000

Standard Follow-Up Schedule

Day 0: Invoice sent Day 7: Friendly reminder (optional for Net 30) Day 25: Payment due soon Day 31: Overdue notice #1 Day 45: Overdue notice #2 Day 60: Final notice + late fee Day 75: Collections consideration

Email Templates

Pre-Due Reminder (Day 25): Subject: Payment Reminder: Invoice INV-2024-001 ($10,000) Hi [Name], Just a friendly reminder that invoice INV-2024-001 for $10,000 is due on [due date] (5 days from now). You can view and pay the invoice here: [link] Payment options: • Bank transfer (preferred) • PayPal: [link] • Credit card: [link] Please let me know if you have any questions or need any additional information. Thanks! [Your name] First Overdue Notice (Day 31): Subject: Overdue Invoice: INV-2024-001 ($10,000) - Action Needed Hi [Name], I wanted to follow up on invoice INV-2024-001 for $10,000, which was due on [due date] and is now overdue. If you've already sent payment, please disregard this message and accept my thanks. If not, you can pay online here: [link] I'm happy to discuss any questions or concerns you may have. Please reply to this email or call me at [phone]. Best regards, [Your name] Second Overdue Notice (Day 45): Subject: Second Notice: Overdue Invoice INV-2024-001 ($10,000) Hi [Name], This is my second notice regarding invoice INV-2024-001 for $10,000, originally due on [due date]. Per our agreement, a late fee of $150 (1.5%) will be applied to this invoice if payment is not received by [date + 15 days]. I value our working relationship and want to resolve this amicably. Please contact me to discuss payment arrangements if needed. Payment link: [link] Regards, [Your name] Final Notice (Day 60): Subject: FINAL NOTICE: Overdue Invoice INV-2024-001 ($10,150) Hi [Name], This is a final notice regarding invoice INV-2024-001. Original amount: $10,000 Late fees applied: $150 Current balance: $10,150 If payment is not received within 15 days, I will need to escalate this matter to collections and suspend any ongoing work. I would prefer to avoid this. Please contact me immediately to discuss payment: [phone/email] Payment link: [link] [Your name]

Monthly Revenue Report

• Revenue Report - January 2024
• Invoiced: $25,000
• - Services: $20,000
• - Products: $5,000
• Collected: $22,500
• Outstanding: $12,500
• - Current: $5,000
• - Overdue: $7,500
• Top Clients:
• 1. ABC Corp: $8,000
• 2. XYZ Inc: $6,500
• 3. 123 LLC: $4,500
• Payment Methods:
• Bank transfer: 60%
• PayPal: 30%
• Credit card: 10%

Tax Summary

Annual Tax Summary - 2024 Total Revenue: $180,000 - Q1: $45,000 - Q2: $42,000 - Q3: $48,000 - Q4: $45,000 Taxable Income: $165,000 (after $15,000 expenses) Estimated Tax: ~$41,250 (25% effective rate) Quarterly payments: $10,312 1099s Received: 3 clients ($95,000 total) 1099s Required: 2 contractors ($12,000 paid)

Retainer Setup

• "Create a monthly retainer invoice template:
• Client: [Name]
• Service: Ongoing consulting
• Amount: $3,000/month
• Billing date: 1st of month
• Payment terms: Net 15
• Include:
• Hours included: 20
• Overage rate: $150/hr
• Rollover policy: Up to 5 hours
• Minimum commitment: 3 months"

Subscription Invoicing

• For productized services:
• Tier: Starter ($99/month)
• Invoice auto-generated on subscription date
• Payment auto-charged (if using Stripe/PayPal)
• Failed payment → retry sequence
• Cancellation → final invoice prorated

Invoice Numbering

Use a consistent format: INV-YYYY-NNN (INV-2024-001) YYYY-MM-NNN (2024-01-001) CLIENT-NNN (ABC-001)

Payment Terms

Standard options: Net 15: Large enterprises (they take forever anyway) Net 30: Standard for most clients Due on receipt: Small projects, new clients 50/50: 50% deposit, 50% on completion Milestone: Payment at defined project stages

Cash Flow Tips

Invoice immediately — don't wait until month-end Require deposits — 50% upfront for new clients Offer early payment discounts — 2/10 Net 30 (2% off if paid in 10 days) Charge late fees — and enforce them Stop work on overdue accounts — protect yourself Use online payments — easier for clients = faster payment

Red Flags

Watch for these warning signs: Client questions your rates after agreement "The check is in the mail" (repeatedly) Asks to pay after project completion (no deposit) Disappears when invoice is due Wants to change payment terms mid-project

Tools Integration

Accounting Software: QuickBooks, Xero, FreshBooks — sync invoices Automatic reconciliation Tax reporting Payment Processors: Stripe — credit cards, ACH PayPal — widely accepted Wise — international transfers Bank transfer — lowest fees Time Tracking: Harvest, Toggl, Clockify Auto-generate invoices from time entries

Common Mistakes

Not invoicing promptly — delays payment by weeks Unclear payment terms — confusion leads to delays No late fees — clients have no incentive to pay on time Ignoring overdue invoices — they don't get better with age No deposit for new clients — high risk of non-payment Mixing personal and business — tax nightmare Not tracking 1099s — IRS penalties

Integration Ideas

Connect to proposal-generator to convert accepted proposals to invoices Use with client-intake-bot to set payment expectations upfront Track project profitability alongside content-repurposer ROI

Monetization Note

This skill is part of the Freelancer Revenue Engine. For maximum value, use alongside: proposal-generator — convert proposals to invoices client-intake-bot — set payment terms early Bundle available: Freelancer Revenue Engine ($89)