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 invoices
client-intake-bot — set payment terms early

Bundle available: Freelancer Revenue Engine ($89)

Invoice Tracker Pro

概述