FINBIZTOOLS
How to Manage Business Cash Flow
Understanding the method
A sale on credit may create revenue before cash is collected. Borrowing increases cash but is not sales profit. Buying equipment reduces cash even when its accounting expense is recognized differently. Identify actual receipts and payments and use one consistent period. Reconcile the result to bank and cash balances; a forecast should be labeled separately from actual records.
Worked example
Opening cash ₹10,000 plus ₹25,000 inflows minus ₹18,000 outflows gives net cash flow ₹7,000 and closing cash ₹17,000. If outflows rise to ₹40,000, closing cash becomes −₹5,000.
Formula and definitions
Net cash flow = inflows − outflows. Closing balance = opening balance + net cash flow.
How to use FinBizTools
- Record the actual opening balance at the start of the period.
- List received money as inflows and paid money as outflows, including financing separately.
- Calculate the closing balance and investigate differences from statements.
- Use a separate scenario for expected future receipts and payment dates; do not mix forecasts with actuals.
Open the tools
Download related templates
Common mistakes and limitations
A positive closing balance does not prove profitability. The simple calculator has no bank connection, receivables ledger or automatic reconciliation.
Why profitable businesses still run out of cash
A business can show a profit and still be unable to pay its bills, because profit is recognized when a sale is made while cash arrives only when the customer pays. Suppose you deliver ₹1,00,000 of work in April on 45-day payment terms, but pay ₹60,000 in salaries and rent at the end of April. On paper April is profitable; in the bank account you are ₹60,000 down until mid-June. Growing businesses are especially exposed, because each new order requires spending before the customer pays.
Building a simple three-month forecast
A forecast lists expected receipts and payments by week or month, starting from today’s bank balance. Here is a simple monthly example for a small agency starting with ₹50,000 in the bank:
| Month | Opening cash | Expected receipts | Expected payments | Closing cash |
|---|---|---|---|---|
| July | ₹50,000 | ₹80,000 | ₹95,000 | ₹35,000 |
| August | ₹35,000 | ₹70,000 | ₹1,10,000 | −₹5,000 |
| September | −₹5,000 | ₹1,40,000 | ₹95,000 | ₹40,000 |
The forecast shows a shortfall in August even though the quarter as a whole is positive. Seeing that six weeks ahead gives time to chase a customer, delay a purchase or arrange a short-term facility, instead of discovering it when a payment bounces. The Cash Flow Template records one month’s actual receipts and payments; save a copy for each month and keep a forecast table like the one above on a separate sheet, so estimates never mix with actual figures.
Practical ways to improve cash flow
- Invoice immediately when work is delivered, and state the due date clearly on the invoice.
- Ask for an advance on larger projects, for example 30–50% on acceptance of the quotation.
- Offer easy payment methods such as UPI or bank transfer details on every invoice.
- Follow up on overdue invoices on a fixed schedule, and consider a late-payment fee stated in your terms.
- Negotiate supplier terms so that you pay suppliers after, rather than before, your customers pay you where possible.
- Avoid tying up cash in excess stock; see the inventory guide.
- Separate tax money by moving GST collected and expected income tax into a separate account so it is not spent by mistake.
How much cash reserve to keep
A common planning approach is to keep enough cash to cover two to three months of fixed costs such as rent, salaries and loan payments. The right level depends on how seasonal your sales are and how quickly customers pay. For a startup that is spending more than it earns, the Runway Calculator shows how many months current cash will last at the present burn rate.
Reviewing actual against forecast
At the end of each month, compare the actual closing balance with the forecast and note the reasons for differences: a customer paid late, a cost was higher than expected, or a sale was missed. Over a few months this review makes the forecast more accurate and highlights the customers and costs that need attention. Keep actual figures and forecasts in separate columns so that estimates are never mistaken for money already received.
Frequently asked questions
Should an unpaid invoice count as cash inflow?
Not in an actual cash worksheet. Record it when cash is received; track the unpaid invoice separately.
Disclaimer
This guide is educational. Examples are illustrative, not financial, tax or legal advice. Verify important decisions and current requirements. Read the FinBizTools Disclaimer.