Skip to content

Cash Flow · Tally · Working Capital · Growth Intelligence

How to build a 13-week cash flow forecast from your Tally data

Short answer. A 13-week cash flow forecast lists, week by week, the money you expect to receive and pay, starting from today’s bank and cash balance. Tally already holds most of it: bank balances, bills receivable and bills payable with due dates. Add salaries, rent, loan repayments and tax payments, adjust receipts for how your customers really pay, and update it every week.

Why 13 weeks

Thirteen weeks is one quarter. It is long enough to see a shortfall coming and short enough to forecast with real bills rather than guesses. Monthly forecasts hide the problem: a month can end in surplus while the third week runs the bank into overdraft because salaries and a large supplier fall due before customers pay.

What you need from Tally

ItemWhere it isNote
Opening bank and cashBalance Sheet → Cash-in-Hand and Bank AccountsShow an overdraft or cash credit balance as a negative figure
Expected receiptsOutstandings → Receivables (bill-wise, with due dates)Bill-wise details must be on for customer ledgers
Payments dueOutstandings → Payables (bill-wise, with due dates)Same setting for supplier ledgers
Regular paymentsLast three months of salary, rent and other expense ledgersUse the usual date in the month
LoansLoan ledgers and repayment schedulesEMIs and interest dates
Unused limitsBank sanction lettersHeadroom on cash credit or overdraft

Step by step

  1. Set up 13 weekly columns, each starting on a Monday, plus a row for opening balance, receipts, payments, net flow and closing balance.
  2. Enter the opening balance as bank plus cash, with any overdraft as a negative.
  3. Place receipts by when customers really pay, not when bills fall due. If a customer usually pays 20 days late, move their bills 20 days. Leave disputed and very old bills out, and list them separately.
  4. Add regular receipts such as cash sales or advances, based on the recent weekly average.
  5. Place supplier payments by due date, then mark which ones can move and which cannot.
  6. Add fixed outflows: salaries, rent, EMIs, insurance and utilities.
  7. Add statutory payments. For many businesses these include TDS deposits around the 7th, PF and ESI around the 15th, and GST with the monthly return around the 20th. Confirm the dates that apply to you with your CA.
  8. Add one-off items: capital purchases, advance tax, bonuses, festival payments.
  9. Draw a minimum-balance line, the least cash you are comfortable holding, and mark every week that falls below it.

Reading the forecast

  • The lowest week matters more than the total. Find it first.
  • Two levers fix most gaps: bringing specific receipts forward and moving flexible payments back. The forecast tells you which customers to call and which supplier to talk to, weeks ahead.
  • Keep three versions when the outlook is uncertain: base, slower collections, and a large order or loss.

The weekly update

Every Monday, replace last week’s forecast with what actually happened, roll a new week onto the end, and note the biggest difference between forecast and actual. After a few weeks you will know which customers and which cost lines your forecast keeps getting wrong, and the forecast becomes more accurate.

Where it usually goes wrong

  • Bills without due dates or bill-wise details, so receivables cannot be placed in weeks.
  • Books updated once a month, so the opening balance is already stale.
  • Counting a reminder sent as money received.
  • Mixing planned borrowing into the forecast as if it were already sanctioned.

Doing it without the spreadsheet

Growth Intelligence includes a 13-week cash and commitment view built from your Tally balances and open bills. It shows week by week whether bank and cash cover what falls due, sequences supplier dues against expected collections, and lists the customers who can change the picture, with a follow-up ready for your approval. Forecasts are planning scenarios, not a guarantee, and a sent reminder is never shown as cash collected.

Common questions

Can Tally make a cash flow forecast?

Tally holds the inputs: bank balances and bills receivable and payable with due dates. You can build a 13-week forecast from those reports in a spreadsheet, or use a tool that reads Tally and builds it for you.

Why weekly and not monthly?

Because a month can end in surplus while one week inside it runs short. Salaries, tax payments and large supplier bills often fall in the same week.

How do I forecast customer receipts accurately?

Use each customer’s actual payment behaviour, not the invoice due date. If a customer pays 20 days late on average, place their receipts 20 days after the due date.

How often should the forecast be updated?

Weekly. Replace last week with actuals, add a new week at the end, and note the largest difference between forecast and actual.

KEEP READING

View all guides ↗