Build a collection queue from Business Central’s aged receivables report

Run Aged Accounts Receivable Excel as of your review date. Use the due-date breakdown to separate overdue invoices from amounts that are not due yet.
Upload a case

Key facts

Use a consistent cutoff, aging basis and currency basis when comparing successive reports.

Set a repeatable report basis

Run Aged Accounts Receivable Excel, report 4402. Set Aged as of and Period length. Choose By period (LCY) for local currency or By Period (FCY) to review foreign currencies. If your company still uses legacy report 120, choose Due Date in Aging by and record whether Print Amounts in LCY is on.

Check sample balances

Set the cutoff to month-end for a month-end worklist. Use CustomerAgingData or the customer ledger entries to check individual documents. Check one large balance and one overdue balance with a recent receipt or credit. Compare the source and export using the same cutoff and currency basis. Investigate differences before treating a bucket as a collection target.

Assign the next action

Create columns for customer, invoice, open amount, due date, owner and next action. Mark blocked items such as unapplied cash, a missing credit or an open dispute. For example, put a $6,000 overdue invoice with a pending $2,000 credit into a credit review queue before asking the customer to confirm the collectible amount.

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.