| name | invoice-tracker |
| description | Complete freelance billing workflow — generate professional invoices, track payment status, send automated reminders, and reconcile payments. Use when you need to bill clients, follow up on overdue payments, organize financial records, or prepare tax documentation for freelance income. |
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
Quick Start
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"
Invoice Structure
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:
| Description | Quantity | Rate | Amount |
|---|
| Service name | 10 hours | $100/hr | $1,000 |
| Deliverable | 1 | $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! │
└─────────────────────────────────────────────────────────┘
Payment Tracking System
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
Automated Reminder Sequences
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]
Financial Reporting
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)
Recurring Billing
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
Best Practices
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 invoicesclient-intake-bot — set payment terms early
Bundle available: Freelancer Revenue Engine ($89)
