Group by customer
It collects all customer open invoices in one row with the number of invoices and total balance.
Receivables Analysis · Pro plan
Aging report of accounts receivable by customer
Collect customer open balances in periods not due, 1–30, 31–60, 61–90, and over 90 days, then download a CSV report in Arabic.
Create an account free without a card. Eligible Pro trial options, duration and payment terms are shown inside the account. Paid Pro costs 49 SAR per month including VAT, by card, Apple Pay or Google Pay.
Knowing the total due is insufficient; aging shows where collection risk is concentrated. Fawtar calculates the remaining balance from issued invoices, groups it by customer and due date, without modifying invoices or fabricating payment dates.
Available on Pro
What do you get?
Clear aging periods
It separates non-due from 1–30, 31–60, 61–90, and over 90 days, and displays undated invoices separately.
Balance not original value
The report is based on the amount remaining after recorded payments, so the collected portion is not calculated again.
Arabic CSV export
Download an aggregated report to open in Excel or Google Sheets or share with the accountant.
How does the feature work?
- 1
Issue and set due date
The issued invoice enters the report with its remaining value and recorded due date.
- 2
Review balance age
View customers sorted by total balance and amount overdue in each period.
- 3
Move to collection
Use the daily collection list and expected payment date after you identify where overdue amounts are concentrated.
Suitable for this business
- Weekly receivables review
- Deliver a simplified statement to the accountant
- Identify customers with the longest delays
Frequently asked questions
How does Fawtar calculate invoice age?
Days are counted from the day after the due date through the report date. An invoice due on the report date stays in the not-yet-due category.
Does the report depend on total invoice amount?
It's based on the open balance after deducting recorded payments, excluding fully paid invoices.
What happens to invoices without a due date?
Appears in a separate column named without date so it doesn't disappear from the total or fall into an incorrect aging period.
Is there a free calculator without an account?
Yes. The receivables aging calculator works inside the browser and issues CSV without saving customer names or amounts.
Want to try Aging report of accounts receivable by customer for your business?
Leave your email and we'll send you the shortest path to start, with clarification of what you need before subscribing. No card or commitment.
Related features
Daily collection list and cash forecastOrganize invoices that need follow-up today, record the expected payment date and internal note, pause reminders until the date, then monitor collection expectations within 30, 60, and 90 days.Customer portal for invoices and paymentsShare a secure portal link that collects the customer's invoices, balances, payment requests, and transfer proofs on one page bearing your business’s identity.Bank statement reconciliation with invoicesUpload a CSV bank statement, review suggestions for matching deposits to open invoices, then record approved payments in the collection record.