Automated Invoice Tracker & Generator for Google Sheets
The Automated Invoice Tracker & Generator keeps your invoicing under control in one spreadsheet. Log each invoice once and the tracker shows what is sent, what is paid, and what is overdue, with the totals on a payment dashboard. It includes a simple invoice layout and a client log, and works in Google Sheets and Excel.
Never Chase an Overdue Invoice Again
Each invoice gets a row with its amount, the date sent, the due date, and its status. The tracker automatically flags anything past its due date as overdue, so the invoices that need chasing rise to the top instead of slipping through the cracks. You can see your total outstanding and your total overdue at a glance.
Built for Freelancers and Small Businesses
If invoicing software feels like overkill for the number of clients you have, this spreadsheet is the middle ground. It is light enough to open and update in seconds, but organised enough that you always know who owes you, how much, and for how long — without paying a monthly subscription for the privilege.
What's Included: Generator + Tracker + Dashboard
There are three parts that work together: a clean invoice layout you can fill in and send, a tracker where each invoice is logged and its status updates automatically, and a dashboard that totals paid, outstanding, and overdue amounts. Together they cover the whole cycle from issuing an invoice to getting paid.
What's Included
- Fill-in invoice layout you can complete and send
- Invoice log with amount, date sent, due date, and status
- Automatic overdue flagging based on the due date
- Payment dashboard: total paid, outstanding, and overdue
- Simple client log to keep contact details in one place
- Status colour cues so the list is easy to scan
- Works in Google Sheets and Microsoft Excel
Frequently Asked Questions
Can this create invoices, or only track them?
Both. There is a fill-in invoice layout you can complete and send, plus a tracker that logs every invoice and a dashboard that totals what is paid, outstanding, and overdue.
How does it know which invoices are overdue?
You enter each invoice's due date and mark it paid when payment arrives. Anything still unpaid past its due date is automatically flagged as overdue, so the invoices that need a follow-up stand out.
Is this good for freelancers?
Yes. It is built for freelancers and small businesses who find full invoicing software more than they need. It is fast to update and has no monthly fee.
Does it work in Google Sheets?
Yes. It opens in Excel and imports into Google Sheets, and the status flags and dashboard totals work the same in both.