Type what's in your till and bank today, then for each month enter the cash you expect in (sales, receivables) and out (stock, rent, wages, loan, KRA). The sheet computes each month's net and your closing balance, and turns any negative month red. The Dashboard shows your total cash in and out, your ending cash, and — the number that matters — your lowest cash point, with a clear warning if any month goes negative so you can act early: chase receivables, delay spending or arrange a facility.
It's the simplest early-warning system a business can keep, and it separates owners who get caught short from those who don't. Formulas locked, opens in Excel or Google Sheets; update it weekly as reality lands.
Want your real cash-in and cash-out tracked for you? Biashara Yangu keeps your books and shows your live cash position, free.