Skip to content

Accounts Receivable

The Accounts Receivable aging report shows what each client owes your company, broken down by how overdue each amount is. Use it to follow up on late payments and monitor your outstanding receivables position.

Navigate to Finance > Accounts Receivable from the main menu.

Accounts Receivable is an on-demand report. Configure the date and click Run to generate it.

  1. Set the As Of date (defaults to today).
  2. Click Run.

Once the report is generated, the following are shown:

MetricDescription
As OfThe date the report is calculated as of
Client CountThe number of clients with outstanding balances
Total ReceivableThe total outstanding amount owed by all clients
ColumnDescription
Client NameThe name of the client
Invoice CountThe number of outstanding invoices for this client
CurrentInvoices that are not yet overdue
1–30 DaysInvoices 1 to 30 days past due
31–60 DaysInvoices 31 to 60 days past due
61–90 DaysInvoices 61 to 90 days past due
91–120 DaysInvoices 91 to 120 days past due
120+ DaysInvoices more than 120 days past due
TotalThe total outstanding balance for the client

Only amounts greater than zero are shown in each aging bucket. A summary row is pinned to the bottom of the table showing the totals across all clients for each aging bucket.

Aging is calculated from the invoice due date relative to the As Of date. An invoice is placed in the appropriate bucket based on how many days have elapsed since its due date:

  • Current — the due date is on or after the As Of date.
  • 1–30 Days — the due date was 1 to 30 days before the As Of date.
  • 31–60 Days — 31 to 60 days overdue, and so on.

If an invoice does not have a due date set, it is treated as current.

Click any column header to sort the report by that column.