Free tools for CAs & accountants
Outstanding Ageing Report from Excel (0-30, 31-60, 61-90, 90+)
Paste a party ledger from Excel and see how much each party owes, by how old the bill is.
Rules last checked 16 November 2026. A guide, not tax advice: confirm with your CA for your case.
Party ledger
If your dates are due dates, pick "Due date": bills not yet due get their own column.
| Party | 0-30 days | 31-60 days | 61-90 days | 90+ days | Total |
|---|---|---|---|---|---|
| Mahavir Steel | 60,000.00 | 1,25,000.00 | – | – | 1,85,000.00 |
| Shree Balaji Traders | 22,000.00 | – | 48,500.00 | – | 70,500.00 |
| Kumar Agro | – | – | – | 31,500.00 | 31,500.00 |
| Total | 82,000.00 | 1,25,000.00 | 48,500.00 | 31,500.00 | 2,87,000.00 |
Add this tool to your website or blog
Free for CA firms, associations and bloggers. Pick where you’ll paste it, copy, done.
Recommended. Works on WordPress, Blogger, Wix, Webflow, Squarespace and plain HTML. Fits its own height automatically.
<div data-bilty-tool="outstanding-ageing-report"><a href="https://getbilty.in/tools/outstanding-ageing-report">Outstanding Ageing Report from Excel (0-30, 31-60, 61-90, 90+) by getBilty</a></div> <script async src="https://getbilty.in/embed/v1.js" integrity="sha384-paQi8Gf5HXoUubYwxVp8sgPzBaTCRkQcp994KUXDEkJFJXe/XrJTPKeMME5QotFA" crossorigin="anonymous"></script>
Where do I paste it?
- WordPress: add a "Custom HTML" block, then paste.
- Blogger: switch the post to "HTML view", then paste where you want the tool.
- Wix: Add → Embed code → "Embed HTML", then paste.
- Webflow / Squarespace: add an "Embed" or "Code" block, then paste.
- Not sure what your site uses? Look for a block called "HTML", "Embed" or "Code". If scripts are not allowed, use the "No-script" tab.
Safe to embed: the tool runs in a sandboxed frame, so it cannot read or change anything on your page.
Frequently asked questions
How are the days counted?
From the date you give to the “age as on” date, counting the invoice date as day zero. 30 days old falls in 0-30; 31 days old falls in 31-60, and so on.
Invoice date or due date?
Pick invoice date to see how old each bill is. Pick due date to see how overdue it is; bills not yet due then get their own column.
How do I enter payments received?
Enter them as negative amounts against the party. They net off in the bucket of the date you give, so for a cleaner result list only unpaid bills.
Is my ledger uploaded?
No. Everything is calculated in your browser.
More free tools for CAs & transporters
Who pays GST on road freight, at 5% or 18%, and what the invoice must say.
1% or 2% TDS, the ₹30,000 and ₹1,00,000 limits and the 10-truck exemption.
Fill in and download the no-TDS declaration a transporter gives with PAN.
Deemed income per truck: ₹1,000 per ton a month for heavy vehicles, ₹7,500 for others.
Every GSTR, TDS and Annexure V date for the year. Add it to your calendar.
Type an amount, copy it in words for an invoice or cheque, in English or Hindi.
Paste invoices from Excel, get a Tally import file with CGST, SGST or IGST ledgers.
Every ledger a transport business needs in Tally, under the right group. Excel and import XML.
The invoice you raise yourself when an unregistered transporter charges you freight.
Last day to pay a micro or small supplier, and whether the deduction is at risk.
Search the SAC codes for freight, truck rental, hamali, warehousing and GTA services.
Your transporter clients still on paper or Excel?
getBilty makes the bilty, GST invoice and party ledger in one place, with the right GTA tax treatment on every bill. Free 14-day trial.
- No credit card required
- 14-day full free trial
- Works on mobile & WhatsApp
- GST & E-Way Bill ready
Want to talk to someone first?
Leave your mobile number. A transport desk specialist will call you back soon and help you with your questions.