Weekly accounts receivable dashboard template for collections decisions

Use this weekly accounts receivable dashboard to decide which customers to call, which disputes to unblock, where to reassign work and which balances to review for collection.
Upload a case

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.

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.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.