Money forecast · from Strength

Cash dips below your safe level for one week in December.

Salaries, GST and steel bills land together, while two big customers pay late. After Christmas, money from finished jobs brings it back up.

Cash today ₹21.4 L SBI current account and cash box
Coming in, next 90 days about₹1.04 Cr ₹91 L to ₹1.12 Cr
Going out, next 90 days about₹1.07 Cr Net · salaries, steel, taxes, rent, loan
Lowest point ₹9.8 L Week of 14 December · safe level

Cash in the bank, week by week

12 weeks back, 13 weeks ahead. Late payers are already counted late.

What happened What we think will happen Likely range

Where the low point comes from

From ₹21.4 L today to ₹9.8 L on 14 December.

Coming in · ₹47.8 L
Invoices already sent+₹29.6 L
Jobs that will finish+₹13.7 L
Advances on new orders+₹4.5 L
Going out · ₹59.4 L
Steel and materials−₹27.4 L
Salaries, Nov and Dec−₹17.2 L
GST and TDS−₹6.9 L
Power, transport, other−₹4.5 L
Rent and loan EMI−₹3.4 L

Money in and out, each week

Above the line comes in, below the line goes out. The dashed line is what's left over. Hover a week to read it.

Coming in Going out Left over that week

What to do about it

Each one says how much it changes the low point. Doing one moves every number on this page.

The week of 14 December goes ₹20,000 below your safe level.
December salaries (₹8.6 L), November GST (₹3.9 L) and a steel bill all fall in the same two weeks.
Try: move Gupta shed by 2 weeks
₹7.2 L from Mehta Infra will likely come 18 days late.
That's how they paid their last 6 invoices. If they slip to 30 days, the low point drops to ₹6.1 L.
Relationships
Welding wire runs out in about 6 days.
At this week's pace you'll need more by 30 October. Ordering now costs about ₹38,000, paid on 6 November.
Ravi Steels paid ₹1.2 L early. The low point went up by the same.
They have paid early 5 times out of 6. The forecast now expects that from them.

Who will pay, and when

The likely date comes from how each customer paid before. Click a row for their history.

₹20.6 L in these 7 invoices
CustomerInvoiceAmountDueLikely paidLate byHow sure

Bills and taxes coming

Next 90 days. Fixed ones are sure; tax depends on sales. Click one for its dates.

Stock that will run out

Based on what open jobs will use, not just last month.

ItemDays leftOrder byCost
Plate use doubles in December because of the Gupta shed and KRB gates. See the work forecast →

Profit, month by month

April to October is real. November to March is the forecast.

Made Likely
Profit this year, likely₹38 L₹31 L to ₹43 L · 8.3% of ₹4.6 Cr sales
So far (Apr–Oct)
₹21.6 L
Still to come (Nov–Mar)
₹16.4 L
December is thin
Overtime and rush steel orders
₹2.1 L
Steel price up 3%
Changed this week
₹1.4 L
Your changes
Everything you did on any page

Make this forecast sharper

Small things to fill in. Each adds points to how sure we are (now /100).

How sure is it?
Connect the HDFC current account
We only see SBI. HDFC payments are guessed.
+5
Enter 4 cash expenses from October
Spends from the cash box are missing.
+2
Add payment terms for 3 customers
We assume 30 days for them now.
+2