Module 2 · Core · 10 min read

Customer statements and receivables ageing

You will be able to: Read a customer statement with its running balance; Use Aging to see which invoices are overdue and by how long; Know which report answers which collection question.

  • Read not done yet
  • Self-check: not taken not done yet
  • Lesson complete not done yet

Selling on credit means money is owed to you, and the business needs to answer two questions every week: what exactly does this customer owe, and who is late? Zeyto has a statement for the first and ageing for the second.

Customer statement

The quickest route is Sales, then Customers: open the customer and press Statement. The report behind that button is called Party Statement. Choose Party type Customer (AR), pick the customer, set From and To, and the statement opens. Each row is one posting with a running Balance: for a customer, a plus means they owe you. The first line, OB, is the opening balance before From.

The customer statement report for one customer showing each invoice and receipt with a running balance.

Customer, Statement: every document and the running balance.

Customer, Statement: every document and the running balance.
One customer's accountAl Noor Trading, January 2026: 1 Jan Invoice SI-1 Debit 525.00 Balance 525.00 Dr 20 Jan Receipt Credit 200.00 Balance 325.00 Dr 25 Jan Return (credit) Credit 105.00 Balance 220.00 Dr The customer owes AED 220.00. The invoice raised the balance (debit); the receipt and the return lowered it (credits).
  • Bill-wise (toolbar button) lists the invoices still open at the To date with Invoiced, Settled, Outstanding and days Overdue. Running balance goes back to the ledger view.
  • The Export menu gives you a PDF or XLSX copy for the customer, and WhatsApp PDF prepares a message. Zeyto sends nothing on its own; you attach the file and send.
  • Account statement (Reports) reads the same ledger from the accounting side and works for any account.

Outstanding and credit statement

Reports, then Outstanding lists every customer and supplier with a balance, with last invoice, last payment, overdue and balance. The Credit statement shows each customer's unpaid invoices with due date, days overdue, total, received and balance. Both include money received on account, so a customer who paid in advance shows a Cr balance.

The Outstanding report listing every customer with a balance, with last invoice, last payment, overdue and balance.

Reports, Outstanding: every party with a balance.

Reports, Outstanding: every party with a balance.

Aging

Open Reports, then Aging. Choose Side Receivables, an As on date, the Bucket size (7, 15, 30 or 60 days; it starts on 30) and press Run. Each row is a customer and each column a bucket of days past the due date: Not Due, then the late buckets. The due date is the invoice date plus the days of its payment term.

The Aging report for customers with the party summary: one row per customer with not due, 1 to 30, 31 to 60, 61 to 90 and over 90 day buckets and a total.

Reports, Aging: who owes you and for how long, bucket by bucket.

Reports, Aging: who owes you and for how long, bucket by bucket.
Bucket (30-day size)Meaning
Not DueUnpaid invoices not yet past their due date
0-301 to 30 days past due
31-6031 to 60 days past due
61-9061 to 90 days past due
90+More than 90 days past due
Placing an invoice in a bucketThe invoice for AED 525 is dated 1 January 2026 with a 30-day payment term, so it is due on 31 January. After the AED 200 receipt and the AED 105 return, AED 220 is outstanding. Run Aging with As on 15 March 2026. Days past due: from 31 January to 28 February is 28 days, plus 15 days in March = 43 days. 43 falls in 31-60, so AED 220 appears in the 31-60 column and Total is AED 220.

Limits of Aging

  • Only submitted sales invoices with a named customer are counted. Opening balances entered under Openings and manual journals to the receivable account are not invoices, so they are missing from Aging.
  • Money received on account or in advance is not allocated to an invoice, so it is not taken off. The Over-received customers report (Overpaid / Unallocated) lists it.
  • The bill-wise Outstanding reports put an invoice that is not yet due in 0-30, while Aging puts it in Not Due.

Which report for which question?

QuestionReport
What does this customer owe, line by line?Party Statement (Statement button on the customer)
Which of their invoices are still open?Bill-wise view or Credit statement
Who owes me and how late are they?Aging
Who has paid more than I invoiced?Over-received customers

Try it in the demo

  1. Open https://demo.zeyto.app/demo-app/ and sign in (user admin, password demoAdmin123). This is a public demo with sample data, so nothing you do there affects a real business.
  2. Open Sales, then Customers, click a customer with a balance and press Statement. Read the Balance column and switch to Bill-wise.
  3. Open Reports, then Aging. Keep Side on Receivables, set As on to today and press Run. Try Bucket size 15 and compare.
  4. Open Reports, then Outstanding and click a customer row to see its open bills.
Open the live demo

Public demo company, sign in as admin / demoAdmin123. Data refreshes nightly.

Key takeaways
  • A customer statement shows every posting with a running balance; debits raise what is owed, credits lower it.
  • Aging places each unpaid invoice in a bucket by days past its due date.
  • Money received but not allocated to an invoice is not netted in Aging; the Over-received customers report lists it.

Check yourself

2 questions on this lesson. Not timed, not the exam, and you can try again. Score 60% or more, and read the lesson, to complete it.

1. Which report splits what customers owe by how many days past their due date?

2. An invoice for AED 220 outstanding was due on 31 January 2026. With 30-day buckets and As on 15 March 2026, which bucket holds it?

Previous: Sales returns and credit notesNext: Discounts in the sales cycle

Practice questions for this module · Printable study sheet