Weekly accounts receivable dashboard template for collections decisions
Key facts
Start with the reconciled invoice list from your accounts receivable aging audit. Add follow-up fields to the list and use the top of the same sheet for the four meeting decisions.
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
Set up one sheet
Put the summary at the top. Paste this header into your spreadsheet below it. Use one row per invoice per snapshot date, with the selling entity, customer ID and invoice number as the invoice key. Keep prior snapshots as fixed values and append a fresh set of rows each week.
Snapshot date Selling entity Customer ID Debtor country Invoice number Due date Currency Open balance Disputed amount AR owner Work status Promised payment date Open promised amount Next action Next action date Case reference
Use the invoice currency and enter numeric amounts without currency symbols. Filter each summary to the snapshot date and one currency. Treat invoices due before the snapshot date as overdue. Check the overdue subtotal against the source list after any corrections. Keep unclear amounts, duplicate invoice keys and missing currencies on an exception list for reconciliation before they enter the dashboard totals.
Use one work status per invoice, such as Follow-up, Dispute, Balance or evidence review, Ready for collection review or Placed. Record a customer-confirmed promise separately from your own next action date. For a partial promise, enter only the unpaid part of the amount promised. Apply verified payments and credits before setting either amount.
Put four decisions at the top
| View | What to total per currency | Decision at the meeting |
|---|---|---|
| Missed payment promises | Sum the open promised amount where the promise date is before the snapshot date and the promise remains unfulfilled. Keep the original missed date on that week’s snapshot. | Assign a call or remittance check with an owner and date. Record a new promise only when the customer confirms it. |
| Disputed overdue balance | Sum the disputed portion of overdue invoices. Keep each figure within the verified open balance. | Assign the person who can resolve the charge and give them an evidence or credit decision date. |
| Overdue balance by owner | Sum the full overdue open balance by AR owner. Put blank owners in an Unassigned group. Count actions due or overdue for each owner to see the workload behind the balance. | Assign unowned invoices and move overdue actions if an owner lacks capacity. Keep existing cases with the named case owner. |
| Collection-ready exposure | Sum overdue open balances marked Ready for collection review. Require a verified balance and debtor, supporting records, no unresolved dispute or live payment promise, and no existing placement. | Assign a final balance and eligibility check to a reviewer and decide whether to hand the file over. |
Show this week’s amount, last week’s amount and the difference for each currency. Use a pivot table or SUMIFS with the filters above. A balance can appear in the owner view and a second view, so use the overdue subtotal as the overall exposure. A move from collection-ready to placed is a workflow change. Count cash collected only after checking payment postings.
Example from a Monday meeting
A supplier’s EUR ledger shows EUR 11,300 overdue on 16 November. Ana owns EUR 7,900. That includes EUR 4,400 tied to a missed promise after a EUR 400 part-payment, and EUR 3,500 newly ready for collection review. Ben owns EUR 3,400, including EUR 600 under dispute within a EUR 2,400 invoice and EUR 1,000 already placed. In USD, Ben owns a separate USD 1,800 invoice with an overdue action. The example is fictional.
| View | 9 November | 16 November | Change | Action recorded for this week |
|---|---|---|---|---|
| Missed promises, EUR | 0 | 4,400 | +4,400 | Ana checks whether another transfer is in flight and calls the customer on 16 November. |
| Disputed balance, EUR | 900 | 600 | −300 | A EUR 300 credit posted. Ben asks billing for a decision on the remaining EUR 600 by 18 November. |
| Overdue by owner, Ben, USD | 1,800 | 1,800 | 0 | The balance is flat and the follow-up is overdue. Assign Maya to call on 17 November. |
| Ready for collection review, EUR | 0 | 3,500 | +3,500 | Ana assembles the file for a balance and eligibility check by 19 November. |
At the next meeting, check each action against the two snapshots. Record whether the promised payment posted, the dispute moved, the handoff took place or the owner needs another date. If a documented cross-border B2B invoice remains unpaid after follow-up, see what happens when you submit a claim with Debitura.


.webp)