What a cash budget is
A cash budget is a period-by-period forecast of the money coming into a business and the money going out. It is not a profit forecast. A month can be profitable on paper and still leave the bank account short, because a sale on credit earns its profit the day it is invoiced but brings in cash only when the customer pays. A cash budget tracks the second event.
The usual periods are a month, a quarter or a year, and each period has the same shape: an opening balance, the receipts expected, the payments due, the net movement, and the closing balance that becomes the next period's opening figure. That running balance is the whole point of the exercise. It shows the month the account is expected to turn negative, which is the month payments must be moved or a limit arranged.
How it differs from the profit and loss account and the fund flow statement
| Statement | What it shows |
|---|---|
| Cash budget | Cash received and paid in each period, and the closing bank position |
| Profit and loss account | Income earned and expenses incurred in a period, whether or not cash moved |
| Fund flow statement | Sources and uses of long-term funds, and how working capital and net worth changed |
A business needs all three. The profit and loss account shows whether the operation is viable, the fund flow statement shows where the money went over a longer stretch, and the cash budget shows whether the account will hold next month.
Why it matters
- Liquidity. It shows a shortage before it arrives, when there is still time to act, instead of after a payment is returned.
- Borrowing. Lenders ask for a cash budget or cash flow projection in a loan file, particularly for working capital limits, because it supports the repayment and limit assessment.
- Investment and purchases. A planned machinery purchase or a large stock build-up can be tested against the months when cash is tight.
- Cost control. Preparing the budget forces every expense line to be justified for the period ahead.
- Discipline. Comparing budget with actual tells management where collections slipped or spending ran ahead.
Step 1: forecast the receipts
Start with cash sales, which come in the period they are made. Then take collections from credit sales, based on your actual credit terms and the lag you see in practice rather than the terms printed on the invoice. Add interest received, proceeds from the sale of an asset, loan or subsidy instalments expected in the period, and any other receipts. Where collections are irregular, group credit customers and apply a realistic collection percentage to each group for each month.
Step 2: forecast the disbursements
List every payment by the period in which it will be made, not the period to which it relates. Raw material purchases, salaries and wages, rent, power and fuel, transport, marketing, interest, tax instalments, loan repayments, capital expenditure and drawings each deserve their own line. In a manufacturing or trading unit, tie the purchases line to the production plan and to the credit the supplier gives, because paying for stock well before the sales come in is a common cause of a cash gap.
Step 3: work out the net movement and the closing balance
For each period, total the receipts, total the payments and subtract. Add the net movement to the opening balance to arrive at the closing balance. Carry it forward and repeat for the next period. Where the closing balance is negative, the budget has done its job by showing it early, and the options are to speed up collections, postpone a discretionary spend, arrange a limit or bring in funds.
The timing assumptions decide the accuracy
Two businesses with the same annual sales can have very different cash positions. The difference is usually the operating cycle: how long stock sits before it is sold, and how long customers take to pay after the sale. If a unit holds three months of stock and gives two months of credit, it funds five months of cost before a rupee comes back. That is why the collection and payment lags in a cash budget should come from the business's own records rather than an assumed average.
Five mistakes that weaken a cash budget
- Treating profit as if it were cash, and ignoring the gap between invoice and collection.
- Using the stated credit period instead of the period customers actually take.
- Leaving out quarterly payments such as advance tax and other statutory dues.
- Ignoring the month in which a large purchase or a loan repayment falls due.
- Preparing the budget once and never comparing it with the actual figures.
Choosing the period and updating the budget
A cash budget for a small trading business is often prepared month by month for the year ahead, with the first quarter kept more detailed. A business with a long manufacturing cycle may prepare weekly figures for the near months and monthly figures beyond that. The period should match how quickly the cash position can change, so the tighter the working capital, the shorter the interval that needs watching.
Once prepared, the budget earns its keep only if it is compared with actuals. Each month, place the actual receipts and payments beside the forecast, note the differences, and correct the assumptions behind the next month's figures. A collection lag that has silently stretched from thirty days to fifty will show up in that comparison long before it shows up in the profit and loss account, which leaves time to follow up on the older invoices.
Where the cash budget sits in a loan file
For a working capital limit, the bank wants to see how the operating cycle funds itself and when the account will be drawn. For a term loan, the repayment capacity working carries the cash the project generates against the instalments due. Finxora's CMA report software produces a cash flow statement and DSCR analysis alongside the operating statement, balance sheet and MPBF computation, and the project report produces a cash flow showing inflows from capital, subsidy and borrowings against outflows for assets, interest, principal and drawings, built from the same inputs as the projections. That keeps the cash figures consistent with the profitability figures the bank reads in the same file.
Preparing the budget alongside the statements is also the quickest way to see which assumption drives the cash position. Move the collection lag by a fortnight and the closing balance changes; the same change barely touches the profit figure. The tools page carries calculators for EMI and other day-to-day figures when a quick estimate is enough.
