Freelancer Invoice & Payment Tracker
Automate invoicing, reminders, and payment tracking
Generate invoices from tracked time or completed projects, send automated payment reminders, track paid vs. outstanding invoices, and maintain a real-time revenue dashboard.
Your Progress
0 of 15 tasks completed
Tools You'll Need
Step-by-Step Setup Guide
Create invoices automatically from time entries or project milestones.
Choose trigger
Option A: Weekly schedule → Pull Toggl time entries → Calculate total. Option B: Project completed in Asana → Trigger invoice
Create Stripe invoice
Add step → Stripe → Create Invoice → Customer, line items, due date (Net 15 or Net 30)
Customize invoice
Include: Project name, hours/deliverables breakdown, payment terms
Send invoice
Add step → Stripe → Send Invoice → This emails the client automatically
Stripe invoices include a "Pay Now" button - much faster payment than PDF invoices
Send friendly reminders for unpaid invoices at strategic intervals.
Enable Stripe reminders
Stripe Dashboard → Settings → Billing → Automatic reminders: 3 days before due, On due date, 7 days overdue
Add personal touch
Create separate Zap: Invoice overdue 7+ days → Send personal email: "Hey {{name}}, just checking in on invoice #{{invoice_id}}..."Escalate if needed
Add Path: If invoice 30+ days overdue → More urgent email + flag in your tracking sheet
Invoices sent on Tuesday/Wednesday get paid faster than Friday invoices
Log every invoice to Google Sheets for a real-time overview of your receivables.
Create tracking sheet
Columns: Invoice ID, Client, Amount, Date Sent, Due Date, Status (Pending/Paid), Date Paid
Log new invoices
Zap: Stripe → Invoice Created → Google Sheets → Add Row
Update when paid
Zap: Stripe → Invoice Paid → Google Sheets → Lookup Row → Update Status to "Paid", add Date Paid
Calculate totals
Add formulas: Outstanding = SUMIF(Status, "Pending", Amount). Revenue this month = SUMIF(Paid date in current month)
Add conditional formatting: Red for 30+ days overdue, Yellow for approaching due date
Create a simple dashboard to visualize income, outstanding invoices, and client breakdown.
Create dashboard tab
New sheet tab: "Dashboard" with summary cards and charts
Add key metrics
Revenue YTD, Outstanding invoices, Average days to payment, Top clients by revenue
Create simple charts
Monthly revenue bar chart, Outstanding by client pie chart
Set up weekly digest
Zap: Weekly schedule → Email yourself: "This week: ${{invoiced}}, Outstanding: ${{outstanding}}, Paid: ${{collected}}"Review your dashboard every Monday to prioritize collection calls for overdue invoices