Accounts Receivable Spreadsheet | Invoice Tracker, AR Aging, Collections Dashboard & Payment Follow Up

Know what is owed, what is late, and what to work next

The MetricForgeHQ AR & Collections Command Center is a Microsoft Excel accounts receivable system for small businesses, bookkeepers, consultants, agencies, contractors, and finance teams that need more than a basic invoice list.

Connect invoices, partial payments, balances, aging, customer exposure, follow-ups, promises to pay, disputes, and expected collections in one reusable workflow.

What you can manage

• Total open and overdue accounts receivable
• Current, 1–30, 31–60, 61–90, and 90+ aging
• Partial and multiple payments with remaining balances
• Collection contacts, outcomes, next steps, priority, and owner
• Promise-to-pay dates, amounts, and broken-promise flags
• Customer exposure, risk flags, and open disputes
• Thirteen-week expected collections forecast

What you receive

• Executive AR & Collections Dashboard
• Invoice Register and separate Payment Log
• Collections Follow-Up Queue
• Customer Risk & Exposure view
• AR Aging Summary and 13-Week Collections Forecast
• Editable settings and collection targets
• Demo workbook, blank workbook, Quick Start Guide, FAQ, and single-business license

Why it is different

Many invoice trackers stop at Paid or Unpaid. This system connects the balance to a weekly collections workflow so you can see not only what is outstanding, but also the owner, next action, expected timing, and customer risk.

Choose this product if

• You invoice customers and need a disciplined weekly collection process
• You want an Excel solution without a recurring subscription
• You need a clearer view of cash timing and overdue exposure

For broader cash-flow, expense, inventory, project, and sales tools, browse Small Business Excel Systems.

Compatibility and delivery

Delivered as Microsoft Excel .xlsx files using standard formulas and no macros. Microsoft Excel is recommended. Google Sheets import is possible, but formulas, charts, formatting, or behavior may differ. This is an instant digital download; no physical product will be shipped.

Important notice

This template supports general business organization and receivables management; it is not accounting, tax, legal, credit, lending, investment, or financial advice. Do not store payment-card data, passwords, authentication codes, bank credentials, government IDs, or other highly sensitive information in the workbook. Files may not be resold, redistributed, sublicensed, or publicly shared.