September 2024
Working Capital
Cash is king. This page answers three questions in 30 seconds: where is my money stuck, what you owe short-term, and what should I do this week. Every number is sliceable by segment.
UTF TECHNOLOGIES INDIA PRIVATE LIMITED: ₹74,401 owed — oldest invoice 22 months old
Collection probability at this age is under 20%. Either push hard this week or provision for write-off.
Where your cash is stuck
Money you've earned or paid but not yet in your hands
| Customer dues (receivables)
Invoices sent, not yet collected |
₹262,701 |
| TDS refund pending
Withheld by customers, claim back from govt |
₹145,530 |
| Total stuck | ₹408,231 |
By Geography
What you owe (short-term)
Three economically distinct buckets — not all of them are 'funding' in the real sense
Real working-capital funding
Genuine third-party capitalSomeone is actually lending you money or delaying their claim so you can operate. More of this is good — others funding your growth.
| Vendor credit (trade payables)
Vendors billed you, you haven't paid — their money working for you |
₹141,600 |
| Customer advances
Customers paid you before delivery — their money in your bank |
₹0 |
| Subtotal · real funding | ₹141,600 |
Tax & statutory timing floats
Not yours — in transit to govtMoney you've collected for the government and are holding until due date. This isn't funding — it's a short-term float. The moment you remit, cash leaves your bank.
| GST / Duties & Taxes payable
Tax collected from customers in their invoices, due to govt |
₹42,826 |
| Subtotal · statutory floats | ₹42,826 |
Set this aside mentally — it leaves your bank on the next statutory due date.
Book accruals (future payments expected)
Accounting-recognised, not cash-in-handThese are accounting entries recognising liabilities you expect to pay in future (audit fees, bonuses, known expenses). Nobody gave you this money — it's just your books recording a future outflow.
| Provisions
Expected future liabilities (audit fee, bonuses, repairs, warranty) |
₹52,450 |
| Subtotal · book accruals | ₹52,450 |
Don't mistake this for cash sitting with you — these represent future outflows your P&L has already booked as expense.
Net working capital position
NWC = Current Assets − Current Liabilities. Matches the Home KPI tile and the balance sheet — one number, everywhere. Breakdown below separates trade-cycle cash (receivables/payables/taxes) from book accruals so you can see what's driving it.
Tally cross-party netting detected
Your Creditors Ageing file shows gross payables that the TB's Sundry Creditors line is not reflecting — because a vendor's credit balance is grouped inside a debtor ledger. Working Capital view uses the ageing-file gross figures.
Trade receivables vs trade payables (gross)
Read from the ageing files — the party-level truth. Independent of how Tally groups the ledgers.
How old is the money owed to you
Older the bucket, lower the collection odds
Industry rule of thumb: anything past 90 days has < 50% collection probability.
Top customers by outstanding
Top customer = 36% of total outstanding · watch this
What to do this week
UTF TECHNOLOGIES INDIA PRIVATE LIMITED: ₹74,401 owed — oldest invoice 22 months old
₹74,401 outstanding. Oldest invoice is 22 months old — almost certainly a bad-debt candidate at this age.
36% concentration in top customer
Higher than ideal. Industry healthy range: top customer ≤ 25%.
DSO at 25 days — excellent
Collections well-managed. Cash cycle tight.
Computed from TB + Debtors Ageing + P&L waterfall. DSO = (Receivables ÷ Revenue) × period days · DPO = (Payables ÷ Purchases) × period days · Cash Cycle = DSO − DPO (services firms have no inventory, so no DIO component).