Contractor Invoice & Accounts Receivable Tracker - Excel & Google Sheets (30/60/90 Aging, Payments, Deposits, Statements)

Know exactly who owes you, how much, and how late. This contractor invoice and accounts receivable tracker logs every invoice, partial payment and deposit, then ages every unpaid balance into 30, 60 and 90+ days automatically. It works in Excel and Google Sheets.

WHAT'S INCLUDED

• Invoice & Payment A/R Tracker (.xlsx), a blank copy ready to use, with 8 tabs:

- Start Here: settings (business name, payment terms, optional "as of" date) and step-by-step instructions

- Dashboard: total outstanding, overdue, overdue count, collected this month, invoiced this month, average days to pay, deposits held, oldest unpaid invoice, % of A/R overdue, aging totals, and 12 months of invoiced vs collected

- Customers: up to 50 customers with their own payment terms, plus invoiced, paid, balance, overdue, open invoices and deposits held for each one

- Invoices: a 500-row register. Due date, amount paid, balance, days past due, status (Open, Partial, Overdue, Paid), aging bucket, date paid in full and days to pay all fill in automatically

- Payments: 1,000 rows. Pick the invoice # from a dropdown, and partial payments are fine. It shows the invoice balance after each payment

- Deposits: deposits and retainers collected before the work, with the amount still held for each customer

- Aging: every customer's balance split into Current, 1-30, 31-60, 61-90 and 90+ days

- Statement: pick a customer to get a printable statement with every open invoice, aging totals and deposits on hand

• A filled-in EXAMPLE copy with sample customers so you can see how it all works

FEATURES

• Working formulas with no macros

• Net 15, Net 30 or due-on-receipt terms, set per customer or per invoice

• Overdue invoices are flagged in red, and duplicate invoice numbers are blocked

• Yellow means type here, grey means calculated. Sheets are protected with no password, so you can customize them

• Print-ready on US Letter

WHO IT'S FOR

Handymen, remodelers, general contractors and trade contractors who send their own invoices and want to stop losing track of who has paid, without paying for monthly accounting software.

PLEASE NOTE

This is a recordkeeping tool. It doesn't create or send invoices and isn't legal, tax or accounting advice. Late fee and collection rules vary by state.

INSTANT DOWNLOAD

You'll get one ZIP file right after purchase. This is a digital download, and no physical item will be shipped.

Designed with AI assistance