AR / AP Aging
AR and AP aging: who is late, and by how much
Pick a date, and see every customer who owes you and every vendor you owe, sorted into age buckets from not yet due to over 90 days. The oldest money is the first thing you see.
Now onboarding companies in Dhaka.
- Receivables aging by customer and payables aging by vendor
- As-of date, so you can look at any day
- Buckets for not yet due, 0-30, 31-60, 61-90 and 90+ days
- Total open amount and number of open documents for each party
AR / AP Aging
As of
Not Yet Due
0
0-30
0
31-60
587,424.2
61-90
17,200
90+ Overdue
20,422,582.42
Total open
BDT 21,027,206.62
| Customer | 90+ | Total Open | Open # |
|---|---|---|---|
| Padma Knitwear Ltd. buyer | 4,413,985.99 | 4,431,185.99 | 4 |
| Jamuna Apparel buyer | 3,213,370.46 | 3,213,370.46 | 3 |
| Surma Textile Limited buyer | 2,451,909.81 | 2,451,909.81 | 3 |
| Rupsha Sweater Ltd buyer | 1,361,088.7 | 1,767,394.42 | 5 |
| Teesta International buyer | 1,450,019.33 | 1,450,019.33 | 4 |
| Karnaphuli Fashion buyer | 1,176,319.75 | 1,282,542.8 | 4 |
Reading the buckets, in three bands
Each open invoice or bill falls into one bucket, by how long it has been unpaid as of the date you pick.
01 · On time
Not yet due, and 0 to 30 days
Money that is current or only just late. Nothing to chase yet, but worth watching.
02 · Late
31 to 90 days
Money that is properly overdue. These are the conversations to have this week.
03 · 90+
Over 90 days
The oldest money, shown in red. It is the first to look at, and the first to question.
What you see on the page
- AR and AP tabs
- Receivables by customer, or payables by vendor, with the same layout.
- As of date
- Look at any day, such as month end, and Refresh to reload.
- Summary cards
- One card for each bucket, and the total open at the end.
- A row per party
- Each customer or vendor with an amount in each bucket.
- Total open and Open #
- What the party owes or is owed in all, and how many documents that is.
Aging is built from invoices and bills
It holds no data of its own. It reads what is unpaid and sorts it by age.
What feeds it
- Invoices (AR)
Unpaid sales invoices.
- Bills (AP)
Unpaid supplier bills.
- Customers
Who owes you.
- Vendors
Whom you owe.
What you do about it
- Receipts
Record the payment when it arrives.
- Cheque Register
Pay a vendor by cheque.
Where it shows up
- Financial Reports
Receivables and payables in your statements.
- Accounting Hub
Open balances at a glance.
- Ledgers
A party’s balance, line by line.
Aging for companies that sell and buy on credit
Credit is how most business is done, and late payment is how it goes wrong. Seeing the age of every balance is the first step to collecting.
Chase the right customers
The biggest and oldest balances sit at the top of the list.
Plan what to pay
Payables aging shows which suppliers are waiting longest, and which you can still hold.
Any date
Run it as of month end, or as of a date a bank asked about.
Documents counted
Open # shows how many invoices make up each balance.
One Monday morning, from list to phone call
A sample collection round, the way it usually runs.
The accountant opens AR aging as of today.
The 90+ column shows the oldest money in red.
The biggest balance belongs to a customer with four open invoices.
A call is made, and the payment promised.
A receipt is recorded, and the balance drops out of the 90+ bucket.
How different trades use aging
- Retail
Account customers with credit terms.
- Food & Hospitality
Corporate clients and event bills.
- Real Estate
Tenants and buyers on instalments.
- Consulting
Clients on retainers.
- Manufacturing
Buyers on 30 to 90 day terms.
- Health & Fitness
Members and corporate packages.
- Trades
Customers billed after a job.
- Others
Sponsors and partners with pledged amounts.
Questions we get about aging
What is aging?
A list of unpaid invoices or bills, sorted by how long they have been unpaid.
Which buckets are there?
Not yet due, 0 to 30, 31 to 60, 61 to 90, and 90 plus days.
Can I see both receivables and payables?
Yes. Switch between the Receivables (AR) and Payables (AP) tabs.
Can I look at a past date?
Yes. Set As of and click Refresh.
What is Open #?
The number of unpaid documents that make up the balance.
Does it hold data of its own?
No. It reads open invoices and bills.
Where is Adon ERP available?
We are currently onboarding companies in Dhaka. Book a demo and we will run aging on sample books.
Bring your oldest unpaid invoice. We will find it in the aging in the demo.
A live demo in English or Bangla, using sample books close to your own trade, with time for your accountant’s questions.