Track customer and supplier due dates (due-date ledger, aged balance)
Here you track unpaid items, their due date and how late they are.
How to
- Open Due dates and reminders, Customers or Suppliers tab.
- Pick « As of »; tick « Overdue only ».
- Fix a due date with the pencil, then « OK ».
- Open « Aged receivables » or « Aged payables » for the bucket view and export.
Learn more
The due-date ledger lists, third party by third party, the unmatched items. Unmatched payments are applied to the oldest items. The Not due, 1-30 d, 31-60 d, 61-90 d and Over 90 d buckets summarise what is outstanding.
Filter and print
Customers and Suppliers tabs; « As of », « Due from … to … », « Overdue only »; « Print » in the « ⋯ » menu. A third party's « Ledger » link opens its auxiliary ledger.
Change a due date or payment method
A row's « Edit due date » pencil opens the due date and payment method (Transfer, Cheque, Cash, Mobile money, Card, Direct debit, Bill of exchange, Other). Click « OK ».
The aged balance
« Aged receivables » (Sales > Customers) and « Aged payables » (Purchases > Suppliers) open outstanding amounts by age bucket at the chosen date, computed from the ledger and matching, with « Export ». The Customers and Suppliers tabs switch between them. A customer overdue for more than 90 days is flagged doubtful: chase them or provide for a doubtful receivable (account 416).