Invoice & Payment Tracker — Excel Template for Contractors with 30/60/90 Aging
Stop losing money to unpaid invoices. Know exactly who owes you what — and who to call first.Built for independent contractors, trades, and small construction businesses. If your "system" for tracking who's paid is memory, text messages, and a shoebox of paper, this replaces it in 10 minutes.WHAT YOU GET (1 Excel file, works in Excel + Google Sheets):📋 Invoice Log — one row per invoice. Enter the number, client, date, and amount. Due date, balance, status (Paid / Partial / Outstanding / Overdue), and days overdue calculate automatically.⏰ Automatic 30/60/90 Aging — every unpaid invoice sorts itself into Current, 1–30, 31–60, 61–90, or 90+ days overdue. The aging table shows where your money is stuck at a glance.📈 Receivables Dashboard — total outstanding, total overdue, your collection rate, and your oldest unpaid invoice. Updates itself every time you open the file (aging is always as of today).💰 Partial payments handled — log what's been paid to date and the balance tracks itself.WHY THIS MATTERS: collectability drops fast after 90 days. Contractors who chase the oldest invoices first collect thousands more per year — but only if they can see which ones those are.HOW IT WORKS:1. Instant download after purchase2. Set your payment terms once (5 minutes)3. Log invoices as you send them, log payments as they arrive4. Open the Dashboard before making collection callsIncludes a Start Here tab with instructions and worked example data.Pair it with our Job Costing & Estimate Calculator — price the job right, then make sure you get paid for it.FORMAT: .xlsx — Microsoft Excel 2010+, Google Sheets, LibreOffice, Numbers.INSTANT DIGITAL DOWNLOAD — no physical product will be shipped. Due to the digital nature of the product, all sales are final. For personal / single-business use.
Get it → exovtools.gumroad.com