Skip to content

Free tools for CAs & accountants

✓ Free, no login✓ Runs in your browser, nothing saved

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

Count days from

If your dates are due dates, pick "Due date": bills not yet due get their own column.

Ageing by party
Party0-30 days31-60 days61-90 days90+ daysTotal
Mahavir Steel60,000.001,25,000.00––1,85,000.00
Shree Balaji Traders22,000.00–48,500.00–70,500.00
Kumar Agro–––31,500.0031,500.00
Total82,000.001,25,000.0048,500.0031,500.002,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

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
Talk to our experts

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.

+91
or
Chat on WhatsApp+91 86999 71687Book a free demo instead
We'll only use this number to contact you. No spam, ever.
Quick
call back
Transport
experts
No spam,
ever