Outstanding Invoice Tracker for Small Businesses | Excel Payment Recovery Dashboard

Unpaid invoices become harder to recover when customer details, due dates, reminders, and balances are stored in different places. The Outstanding Invoice Tracker gives small-business owners one clear working system for monitoring unpaid accounts and deciding what to follow up on next.

Enter each invoice in the yellow input cells. The workbook automatically calculates the remaining balance and days overdue, while the dashboard summarizes total outstanding, overdue amounts, overdue invoices, and payments collected.

**What is included:**

- Start Here instructions and color guide

- Invoice log for up to 100 customer invoices

- Automatic balance-due calculation

- Automatic days-overdue calculation

- Status dropdowns for Open, Paid, Disputed, Payment Plan, and Cancelled

- Last-reminder, next-action, and notes fields

- Live invoice-recovery dashboard

- Sample entries showing how the tracker works

**Best for:** freelancers, consultants, contractors, service providers, small agencies, rental businesses, and other businesses that invoice customers.

**File format:** One downloadable Excel workbook (.xlsx). Works best in Microsoft Excel; compatible spreadsheet apps may display some formatting differently.

This is an operational planning tool, not legal, accounting, tax, or financial advice.