Invoice and AR Register

This template is for tracking open customer invoices in a single table, with one row per invoice and columns for invoice number, client, amount, issue date, due date, status, and owner. It helps you see what is still unpaid, what is overdue, and who is responsible for follow-up. The included boards surface the clients and owners tied to the largest outstanding balances.

It is best suited to operational accounts receivable tracking, not as a replacement for your accounting system. Use it when you need a working register for follow-up, ownership, and visibility across open invoices. If you already have an ERP or accounting platform, this template can sit alongside it as a lightweight action list.

Update it whenever an invoice is issued, paid, disputed, or becomes overdue. Many teams review it daily or at least several times a week so the status column stays current and follow-up does not lag behind the due date. If your billing volume is high, assign a clear owner to keep the register current.

Usually finance, billing, or accounts receivable owns the register, with sales or account managers helping on customer follow-up when needed. The Owner field makes it easy to assign a specific person to each invoice or account. In smaller teams, one person can maintain the register and escalate overdue items to the right contact.

The biggest mistake is storing status as free text instead of a fixed select list, which makes reporting messy and inconsistent. Another common issue is leaving due dates blank or failing to update paid invoices, which makes the overdue view unreliable. Teams also sometimes track too many fields and turn a simple register into a cluttered spreadsheet clone.

Yes. You can add fields such as PO number, payment terms, currency, region, or dispute reason if those are part of your workflow. Keep the identifying column first, use narrow field types where possible, and avoid adding columns that do not drive follow-up or reporting.

The boards rank clients by total outstanding balance and show which owners are carrying the most open value. That makes it easier to prioritize collections work, spot concentration risk, and review where follow-up effort is needed. The status board also gives a quick count of invoices by stage.

Compared with an ad hoc spreadsheet, this template gives you a consistent row structure, cleaner field types, and built-in ranking views. That makes it easier to filter, assign, and review open invoices without rebuilding the logic each month. It is especially useful when multiple people need to update the same register.