Skip to main content

Debts by Periods (Debts Aging Report)

Purpose​

Assessment of accounts receivable and accounts payable by overdue intervals.
Monitoring overdue balances and managing debt collection according to company policies.

Features​

  • Preconfigured intervals: 0–30, 31–60, 61–90, more than 90 days; intervals can be modified.
  • Filters and groupings: my company, manager, sales agent, counterparty, invoice, and others.
  • Calculation based on outstanding balances (includes partial payments).

Nuances and limitations​

  • Includes outstanding balances for posted invoices as of the specified date, as well as unapplied advances.
  • Overdue days are calculated from the specified due date.
  • Partially paid invoices are included in the interval according to the remaining debt.
  • In multicurrency accounting, balances are shown in the accounting currency — euro.

Step-by-step setup and execution​

  1. Open Sales or Purchases > Aging Report.
  2. From the report variants, select the required debt type: receivables or payables.
  3. Click Generate.

Expected result:
The report displays a table with debt distributed by intervals according to the selected groupings, along with a list of overdue invoices.

Tips​

tip

Review the intervals according to your internal policy (for example, 0–15–30–45–60 days) and save the configuration as a report variant.
If you want to see both debt types in a single report, disable the Debt Type filter in the settings.