By Rollevo ·
A weekly accounts receivable (AR) report pairs an aging snapshot with an invoice follow-up queue. Include total and overdue AR, verified payments, outstanding payment promises, and open disputes. Give every invoice that needs attention an owner, next action, and due date.
Build the report from a consistent snapshot
Use the same cutoff each week. Export open invoices by due date and apply the same rules for credits and unapplied payments. In QuickBooks Online, use the Aging Summary to check totals and Aging Detail to review open items by invoice. Intuit’s instructions for running both reports explain how to find and customize them.
Download the weekly AR report template
Download the Excel template (.xlsx)
The file includes a formula-driven Weekly Summary, an editable open-invoice queue, and a payment log. The sample figures below come from the workbook. When using it for your own report, replace the sample inputs and set the cutoff date.
1. Balance snapshot
Record the as-of date, total open AR, total past due, and balances by aging bucket. Show last week’s past-due total alongside this week’s. Use the aging report guide to check how invoices enter each bucket.
2. Invoice follow-up queue
Use one row per open invoice. Enter the open balance from your accounting system after payments and credits. Record only the disputed portion under Disputed amount, even if AP has put the entire invoice on hold.
Use statuses that tell the owner what to do next, such as awaiting AP approval, missing document, dispute in review, payment promised, or payment verification pending. If one customer promises to pay multiple invoices, record the allocations so the same payment is counted once.
3. Weekly outcomes
Report payments verified during the week, outstanding promises due next week, and the two or three blockers that need management attention. Payments verified during the week are a period total. Open AR and outstanding promises are as-of balances. Keep those figures separate.
Example of a weekly AR brief
Illustrative report as of November 17, 2026. The team has $24,000 past due and $11,000 in promises for the next seven days. One $4,000 invoice is on hold for a $1,200 rate dispute.
| Metric | USD |
|---|---|
| Total open AR | $72,000 |
| Current | $48,000 |
| 1–30 days past due | $17,000 |
| 31–60 days past due | $5,000 |
| 61–90 days past due | $2,000 |
| 91+ days past due | $0 |
| Total past due | $24,000 |
| Prior week past due | $29,000 |
| Verified receipts this week | $8,000 |
| Promises in next seven days | $11,000 |
| Amount in dispute | $1,200 |
Action for the meeting. Billing reviews the rate card for INV-1042 by November 18. AR checks the $6,000 and $5,000 promises against the ledger on their expected payment dates. The $5,000 week-over-week drop in past-due AR is distinct from the $8,000 in verified receipts because invoices can move across their due dates or be adjusted by credits.
How do you report a missed payment promise?
Keep the original promised amount and date in the contact history. After that date, check the ledger and any remittance advice. If a payment is still unverified, keep the invoice balance in open AR and assign a follow-up date. If AP proposes a new date, update the open commitment while preserving the original. Use the email for a missed payment date to ask for the status or remittance reference.
Use the same report to open the next AR meeting. Review prior commitments first, then assign the next action on newly overdue or blocked invoices. If the same dispute follows the invoice into a second week, use the dispute workflow to identify the decision that is holding it up.