Zentriq Agent is live on Microsoft AppSourceInstall it free →Microsoft AppSourceInstall it free →

What is a Aged Accounts Receivable in Business Central?

Aged Accounts Receivable is a report listing open customer balances at a chosen date, grouped into aging buckets such as current, 1 to 30 and 31 to 60 days.

Aged Accounts Receivable is a standard Business Central report showing what each customer owes you at a given date and how long it has been outstanding. It reads open customer ledger entries, so invoices, credit memos and receipts that are not fully applied all influence the picture. The aging basis is usually the due date, with buckets of 30 days, which makes overdue exposure visible per customer.

Press Alt+Q and search for Aged Accounts Receivable. On the request page you set the aging date, the aging basis such as due date, posting date or document date, the period length and whether to show every document or only customer totals. You can also run it for a single customer from the customer list when you are preparing a call about a late payment.

Aged at 30 April 2026 with 30 day buckets by due date, customer C00042 shows CHF 14,900 in the 31 to 60 days column from invoice SI-2026-0311 dated 20 February with 30 day terms, and CHF 2,400 in the over 90 days column from a December 2025 invoice. The customer total is CHF 17,300, of which the older amount is the one worth a reminder or a phone call first.

Reading the report without checking application is the main pitfall: a payment received on account but never applied leaves the invoice open, so a customer who has paid appears overdue. Aging by posting date instead of due date makes every open invoice look late even inside agreed terms. And when someone posts a receipt with a later posting date than the aging date, the balance you see today for last month's close no longer matches the printout kept in the file.

Because the report is a snapshot, keep the same options for every month end, otherwise the trend you show management is not comparable from one period to the next. Zentriq Agent can answer questions over the same open customer entries inside Business Central, for example which customers pass 60 days at month end, without exporting the ledger to a spreadsheet, and any record it drafts still needs human approval before it is posted.

Frequently asked questions

A customer paid but still shows as overdue. Why?

The receipt is posted but not applied to the invoice, so both entries remain open. Apply the payment to the invoice and the amount leaves the aging bucket.

Can I use this report as the basis for reminders?

It is a good starting point for deciding who to chase, but reminders themselves are created from the reminder functionality, which applies your reminder terms and levels to the open entries.

Related terms

  • Customer Ledger Entry, The transaction record in Business Central tracking every posted invoice, payment, and credit memo for a customer, where open entries show what is still owed.
  • Customer, A Customer is the Business Central master record for a buyer, holding the address, posting groups, payment terms and credit limit used on every sales document.
  • Reminder, A Reminder in Business Central is a document that lists a customer's overdue invoices and can add reminder fees or interest according to a reminder terms setup.
  • Payment Terms, Codes defining when and how vendor invoices must be paid, such as Net 30 or 2/10 Net 30, configured on vendor cards.
  • Cash Receipt Journal, The Business Central journal for registering incoming customer payments and applying them to open sales invoices.

How Zentriq helps

Zentriq's AI tools automate many of the manual processes around aged accounts receivable in Business Central. Learn about the Zentriq Agent or try Zentriq PunchOut to see how AI simplifies procurement in BC.

Related resources

GlossaryCustomer Ledger EntryGlossaryCustomerHow-toHow to Set Up Vendor Bank Accounts for Payments in Business Central