July 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.
51% of receivables from one customer
If this one customer has a bad month, your cash flow has a bad month. That's not a customer relationship — it's a dependency.
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 |
₹198,301 |
| TDS refund pending
Withheld by customers, claim back from govt |
₹105,530 |
| Total stuck | ₹303,831 |
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 |
₹29,766 |
| Subtotal · statutory floats | ₹29,766 |
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.
Same party — both sides (gross-up)
These parties appear in BOTH your Debtors Ageing and Creditors Ageing for this period. Tally nets them inside a single ledger; the TB's Sundry Debtors / Creditors figures under-state gross trade exposure. Shown here at gross, the way Working Capital should be read.
| Party | Gross receivable (they owe you) |
Gross payable (you owe them) |
Net (rec − pay) |
|---|---|---|---|
| Ekadrisht Capital Private Limited | ₹23,600 | ₹141,600 | ₹-118,000 |
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 = 51% of total outstanding · concentration risk critical
What to do this week
51% of receivables from one customer
NK SARRAF & ASSOCIATES owes ₹100,300 — that's 51% of all money you're owed.
UTF TECHNOLOGIES INDIA PRIVATE LIMITED: ₹74,401 owed — oldest invoice 20 months old
₹74,401 outstanding. Oldest invoice is 20 months old — almost certainly a bad-debt candidate at this age.
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).