johnalbertini14-glitch 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)