A manufacturer once told me: "My business is profitable on paper but I have no cash." His Tally showed good margins. But ₹40 lakh was sitting with 12 buyers, some for over 4 months.

This is one of the most common ways Indian manufacturing businesses run into trouble. Profit and cash are not the same thing. The gap between them is your receivables — and a debtor aging report is the tool that makes this gap visible.

What Is a Debtor Aging Report?

A debtor aging report (also called accounts receivable aging) shows:

Every customer who owes you money
How much they owe
How long each invoice has been outstanding

The "aging" part groups outstanding invoices into time buckets:

Bucket	Meaning
0–30 days	Current or just due — normal, collect per terms
31–60 days	Slightly overdue — soft follow-up needed
61–90 days	Overdue — active follow-up required
90+ days	Significantly overdue — escalation and review

A typical report might show Sharma Textiles with ₹2,40,000 spread across the 0–30, 31–60, and 61–90 buckets; Metro Distributors with ₹3,80,000 spread across the current and slightly-overdue buckets; and ABC Auto Parts with just ₹95,000 total — but all of it sitting in the 61–90 and 90+ buckets.

One look at this tells you: ABC Auto Parts has ₹50,000 sitting for more than 90 days. That needs immediate action — even though their balance is the smallest.

Why This Is Critical for Manufacturers

Manufacturers operate on thin margins — typically 5–15% net profit. When receivables stretch, the maths becomes brutal:

Example: ₹1 crore annual revenue, 10% net margin = ₹10 lakh profit.

If customers pay 90 days late instead of 30 days late, you're financing an extra 60 days of sales — that's ₹16.4 lakh in additional working capital you need to fund from somewhere (usually borrowed at 12–18% interest).

The interest cost on that borrowing can eliminate your profit margin entirely.

This is why the quote from India's manufacturing forums rings true: "90% of capital is stuck as credit with buyers. 5–10% profit margins don't justify the risk."

How to Build a Debtor Aging Report

In Tally

Tally has a built-in Outstanding Receivables report: Gateway of Tally → Display → Statements of Accounts → Outstandings → Receivables

You can age the ledger by invoice date and see outstanding amounts by party. Tally lets you set credit periods and highlight overdue entries.

Limitation: Tally shows you the accounting position, but it doesn't show you which sales rep owns the relationship, whether follow-up has been done, or the customer's payment history pattern.

In a Manufacturing ERP

A manufacturing ERP that handles invoicing can generate aging reports directly from dispatched and invoiced orders — with additional context:

Which orders are invoiced but unpaid
Payment history per customer
Days Since Invoice for each outstanding
Link to the original sales order and delivery details

This context matters for collections — your team needs to know what was delivered, when, and what was agreed.

In Excel (If You're Starting From Scratch)

If you don't have a system, build this manually:

Export all unpaid invoices from Tally (or your billing system)
Calculate days outstanding for each invoice (today's date minus invoice date)
Categorize into 0–30, 31–60, 61–90, 90+ buckets
Sum by customer and by bucket
Add a column for last follow-up action taken

Refresh this every week. Assign ownership — who is responsible for collecting from each customer?

How to Use the Report: A Collection Workflow

A debtor aging report is only useful if it drives action. Here's a practical weekly workflow:

0–30 Days: Proactive Touchpoint

Send a statement of account to all customers with outstanding invoices
If approaching payment due date, a WhatsApp reminder is appropriate

31–60 Days: Active Follow-Up

Call the accounts team at the customer's business
Confirm they've received the invoice and the goods were accepted
Get a specific payment commitment date
Note the commitment in your records

61–90 Days: Escalation

Escalate to a senior relationship (director to director, if needed)
If the customer claims a dispute, resolve it immediately — disputes are the most common excuse for delay
Consider pausing further credit extension to this customer
Set a firm deadline: payment by [date] or orders will be held

90+ Days: Serious Action

Formal written notice (WhatsApp or email isn't enough at this stage — send a formal letter)
Evaluate the customer relationship: is future business worth the current pain?
Provision for bad debt in your accounts
Legal notice if warranted (many Indian buyers respond to legal notices even if they ignored calls)

Red Flags to Watch in Aging Reports

A customer's outstanding keeps moving right (from 30 days bucket to 60 to 90): They're a chronic late payer. Stop extending credit.

90+ days bucket is growing month over month: Your collections process is broken. Assign dedicated follow-up ownership.

One customer represents more than 30% of total outstanding: Concentration risk. If they don't pay, your business is in trouble.

Outstanding is growing faster than revenue: You're selling more but collecting less. Revenue growth means nothing without collection.

Debtor Days: The Number to Track Over Time

Beyond the weekly aging report, track Debtor Days as a monthly KPI:

Debtor Days = (Total Outstanding Receivables ÷ Monthly Revenue) × 30

Debtor Days	What It Means
Below 30	Excellent — customers pay promptly
30–45	Healthy — minor follow-up needed
45–60	Needs attention — collections process review
60–90	Problem — significant working capital tied up
90+	Crisis — credit policies need immediate revision

Track this number monthly and watch the trend. A rising Debtor Days number is a warning sign even if overall revenue looks good.

Receivables and Business Credit

There's another dimension to receivables that most Indian manufacturers are beginning to understand: your receivables record is part of your creditworthiness.

NBFCs and fintech lenders that offer Invoice Discounting or Supply Chain Finance look at:

How much you're owed and by whom
How reliably customers pay
Your historical Debtor Days

A manufacturer with clean, structured receivables data and short Debtor Days is a better credit risk — and gets better financing terms — than one with the same revenue but messy collections.

FactoStack's reporting module tracks customer-wise outstanding, aging, and payment history. That structured history can support internal credit decisions and lender-ready reporting where an applicable financing provider accepts it.

Reporting & Analytics

Track customer-wise outstanding, debtor aging buckets, and payment history — all updated in real time from your invoices and collections.

See how it works →Book a demo

Debtor Aging Report: How Indian Manufacturers Should Track What They're Owed