How to see what customers owe and for how long

What is it for?

The ageing of receivable balances shows, by customer, how much is still to be received and how many days ago that amount fell due. Each column is an overdue bracket: Not due, 1 - 30 days, 31 - 60 days, 61 - 90 days, 91 - 120 days and More than 120 days.

It helps you decide whom to call first and assess the collection risk.

When to use it?

• To prepare the month's collections: see the customers with the most overdue.
• To know how much was not yet due on a date (today, the end of the month).
• To check the customer balance in the accounting against the invoices that make it up.

Where to find it?

• Billing › Collect › To collect (Billing profile).
• Accounting › Review › Third parties › Ageing of balances (Accountant profile).

The screen is called Ageing of balances. The Accountant also has the To pay tab, which shows the same report for debts to suppliers; the Billing profile only sees Receivable.

Before you start

• The customer invoices are issued (draft ones are not included, unless you use the Include drafts option).
• The example is Empresa Demonstração, Lda, on 05/11/2026.

How to use it

1. Open Accounting › Review › Third parties › Ageing of balances. The screen opens on 2026 (from 01/01/2026 to 31/12/2026) and the overdue days count up to today, because the period has not ended yet. The Not due column shows what is not yet due and the other columns what is overdue: in the example, a Total of €5,241.03, all in 1 - 30 days.
2. Click More filters and tick Unfold all to see each customer's invoices, with the Document and the Due date. In the example, invoice FT D26/30 of Papelaria Central, Lda, due on 19/10/2026, is in 1 - 30 days: 17 days have passed.
3. To see the position on another date, type it in to:, or choose an option in Default period. With 18/10/2026, FT D26/30 moves to Not due (€4,847.43) and FT D26/29 of Maria João Ferreira (ENI), for €1,461.72, reappears: it was still to be received on that date and has since been paid.
4. If you need other brackets, change Bracket limits (days) or Days per period and Periods. In Days counted from, choose Due date (the default) or Document date: with the document date, days count from when the invoice was issued.
5. To have it on paper, click Export PDF (or Export for a spreadsheet). The PDF carries the company, the tax number (NIF), the period, the date and the user who issued it.

Expected result

• One line per customer and a Total line. The example total, €5,241.03, is the sum of the three customers (€246.00, €147.60 and €4,847.43).
• Each invoice appears only once, in the bracket given by the report date minus the due date.
• A company with no invoices to collect shows only the Total line at €0.00.

Important notes

• Up to which day the days count. While the period has not ended, days count up to today, even with the whole year chosen. For a period that has already ended, they count up to its last day. In Days counted from, with Document date, FT D26/30, issued on 19/09/2026, moves from 1 - 30 days to 31 - 60 days.
• The report only sees what is posted. Invoices not yet issued, receipts not yet registered and payments not yet reconciled change the result. For the customer's balance with the movements, open the partner statements.

Common problems

The “Not due” column is at €0.00

• Cause: none of the invoices to collect has a due date after the report date. In the example, on 05/11/2026, all of them are already due.
• What to do: nothing, if the date is right. To see what was not yet due on another date, change it in to: (step 3).