BRAccount
Dashboard
Dashboard charts

Accounts Receivable Ageing

Chart from the Accounts Receivable report: outstanding by ageing bucket.

In detail

This chart runs the Accounts Receivable report and draws what customers owe you by ageing bucket, so it shows how overdue customer dues are. All buckets read Rs 0 in the demo after Jivan Dahal paid in full. The bars are the Debtors account split by age and should total the Debtors line in the Balance Sheet. Amounts in the over 90 days bucket are the ones to chase hardest; after that they become candidates for a bad debt provision.

Formula

Each bar = Sum of outstanding amount on unpaid Sales Invoices grouped by days since due date, from the Accounts Receivable report

How to record it in BRAccount

  1. 01Go to Invoicing; the chart sits with Accounts Payable Ageing.
  2. 02Hover a bar to read the bucket and amount.
  3. 03To change the date or bucket size, open the chart menu > Edit and set the report filters.
  4. 04Click the chart to open the full Accounts Receivable report by customer.
  5. 05Send statements or reminders to the customers in the oldest bucket.

When to use it

How overdue customer dues are.

Example from the demo books

All buckets Rs 0 after Jivan Dahal paid.