Guide
How to track invoices and payments in Excel
A simple method for freelancers and service businesses. Works in Excel and Google Sheets, no macros needed.
Step by step
- Record each invoice with number, client, issue date, due date and amount.
- Calculate days overdue with a formula against today's date.
- Use a Status dropdown: Draft, Sent, Paid, Overdue.
- Total unpaid amounts by client.
- Send reminders for anything more than 7 days overdue.
Columns to include
Invoice #, Client, Issued, Terms (days), Amount, Paid on, Method, Due.
Numbers worth watching
Outstanding, Overdue, Collected this year, Invoices open, Avg days to pay. Put them at the top of a dashboard tab so you see them every time you open the file.
Skip the setup
The Ordwell Invoice Tracker has all of this built: dropdown lists you control from one tab, formulas in green columns and a dashboard that updates as you type.
Free: Simple Order Log
A real Ordwell spreadsheet with dropdowns, totals and a mini dashboard. Pay what you want, $0 is fine.
More guides
- How to track orders in Excel
- How to manage inventory in Excel
- How to build a simple CRM in Excel
- How to track appointments in Excel
- How to track a sales pipeline in Excel
- How to track business expenses in Excel
- How to track projects and tasks in Excel
- How to track purchase orders in Excel
- How to track employee hours in Excel