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:

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   │
│  [email protected]                             │
├─────────────────────────────────────────────────────────┤
│  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: [email protected]           │
│  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

1. Invoice immediately — don't wait until month-end
2. Require deposits — 50% upfront for new clients
3. Offer early payment discounts — 2/10 Net 30 (2% off if paid in 10 days)
4. Charge late fees — and enforce them
5. Stop work on overdue accounts — protect yourself
6. 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

1. Not invoicing promptly — delays payment by weeks
2. Unclear payment terms — confusion leads to delays
3. No late fees — clients have no incentive to pay on time
4. Ignoring overdue invoices — they don't get better with age
5. No deposit for new clients — high risk of non-payment
6. Mixing personal and business — tax nightmare
7. 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)