A useful annual budget is not twelve copies of the same month. A café may buy ingredients weeks before a busy season; a small agency may collect a project deposit in one month and the balance in another. Your 2027 plan should show when cash is expected to arrive and leave, using actual payment timing rather than a smooth annual average. This guide gives you a month-by-month template, a small worked example, and a simple way to stress-test the plan.
This is a planning tool, not a promise that every forecast will happen. A cash budget tracks expected cash receipts and payments; it is different from a profit-and-loss statement, which may record income and costs when earned or incurred, and from a tax filing. Keep your bookkeeping and tax records separate, and ask your accountant or tax adviser how to treat items for your business.
1. Start with 2026 actuals, not a blank page
Gather monthly 2026 figures for cash received, operating payments, payroll or owner pay, and opening and closing cash balances. Use records you trust, and choose one consistent basis: when money actually moved is often easiest for a cash plan. Then annotate unusual months: a one-time equipment repair, a large client project, a seasonal event, a temporary closure, or an owner contribution. Keep the one-off visible instead of assuming it will recur.
Write a short note beside any change you expect in 2027. For example: “June sales +15%: second seasonal market confirmed,” or “March repairs +$900: replacement refrigerator scheduled.” A reason makes an assumption easier to review later. If your records contain a mix of cash and accrual figures, ask your bookkeeper to help make the comparison consistent before copying numbers forward.
2. Forecast income by source and by month
Split expected receipts into useful sources rather than entering one annual sales total. A two-person agency might use monthly retainers, project milestones, and new work. A café might separate counter sales, catering, and other sales that matter to its operation. Put each receipt in the month you realistically expect to collect it, not automatically in the month you make the sale or send the invoice.
Separate confirmed income from hoped-for income. Use accepted client work with scheduled payment dates and recurring contracts as the stronger base. Put unsigned proposals, likely-but-unbooked catering, or an untested promotion in a separate opportunity line or an upside scenario. A signed project can still pay late, so use the payment schedule as a starting assumption rather than treating the money as already in the bank. This distinction is especially useful for service businesses; see how to move from an accepted quote to a dated cash forecast.
Do not divide projected annual income by twelve unless your sales really are even. Use last year's seasonal pattern as a starting point, then adjust for changes you can explain: opening days, planned price changes, booked work, supplier availability, or capacity. National small-business cash-flow findings are not a substitute for your own forecast; our guide to what cash-flow benchmarks measure—and what they do not explains why averages can hide very different business conditions.
3. Add regular costs and dated outflows
List fixed or recurring payments by month: rent, insurance, software, utilities, debt payments, payroll, and owner pay. Add variable costs that rise with sales, such as ingredients, packaging, contractor hours, or transaction fees. For each variable category, estimate a reasonable percentage of sales from your own records, then apply it to the months when the related sales occur. For instance, if ingredients have averaged 30% of café sales, begin with that ratio and adjust only when you have a clear reason.
Give irregular costs their own dated line: annual insurance renewals, permits, equipment servicing, planned replacements, software billed annually, or a seasonal supplier deposit. If an expense is likely but the exact date is unknown, enter the best estimate and mark it for confirmation. This exposes a cash squeeze that an annual total might conceal. A November–January plan can also help with near-term timing; compare this annual view with the holiday cash-flow plan for purchases, receipts, and January bills.
If you may need estimated tax payments, make a dated tax set-aside line so the cash is not accidentally treated as available for other spending. Check the IRS estimated-tax guidance and payment calendar for applicable dates and rules; amounts and requirements depend on your circumstances, so confirm them with a qualified tax adviser. Do not use this budget as a tax calculation.
The U.S. Small Business Administration recommends tracking financial information and using projections to manage business finances. Its small-business finance guidance is a useful companion, but the assumptions in your monthly plan should come from your own records and business commitments.
4. Copy-ready 12-month budget layout
Copy the month headings and rows below into a spreadsheet. Add another income or expense row for every source or category you need; use positive values for receipts and enter outflows as positive costs so the net row is easy to calculate. Add opening cash above the rows, then calculate monthly closing cash as prior month's closing cash plus that month's net cash movement. Carry December's closing cash into January 2028 when you roll the plan forward.
Columns: Line item | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Opening cash: ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____
Income — source 1: ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____
Income — source 2: ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____
Income — source 3 / other: ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____
Total planned income: ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____
Cost of goods / food / materials: ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____
Payroll and owner pay: ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____
Fixed costs: ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____
Dated one-offs: ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____
Tax set-aside: ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____
Net cash movement (income less outflows): ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____
Cumulative / closing cash: ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____ | ____
Use separate rows for expenses that have different timing or decision owners. “Fixed costs” can be split into rent, insurance, utilities, and subscriptions; “dated one-offs” can identify the exact renewal or purchase. If an income source is uncertain, label it clearly and leave it out of the base-case total—or keep a separate upside scenario—so the main plan does not quietly depend on a sale that is not confirmed.
5. Worked example: a small café (illustrative numbers)
Suppose a café starts January with $12,000 in cash. These are invented figures, rounded for illustration, not a benchmark. The owner expects monthly counter sales of $18,000 in January, rising to $24,000 in June, then easing to $20,000 in November and $22,000 in December. A confirmed $3,000 catering booking is due in June. For this simplified example, food and packaging costs are budgeted at 30% of sales; payroll and owner pay total $10,000 per month; fixed costs total $6,000 per month; and a $2,400 equipment service is due in September. The tax set-aside amount and timing would be set with the owner's adviser.
January's expected sales are $18,000. At the assumed 30%, food and packaging cost $5,400. After $10,000 payroll/owner pay and $6,000 fixed costs, the simplified net cash movement is negative $3,400, before any tax set-aside or other receipts and payments. If opening cash is $12,000, projected closing cash is $8,600. June's $24,000 counter sales plus the confirmed $3,000 catering receipt produce $27,000 of planned income; at the same 30% cost ratio, food and packaging are $8,100. Using the same payroll and fixed-cost assumptions, that month adds $2,900 before tax and other items. In September, add the dated $2,400 service cost rather than smoothing it across all twelve months.
This example is deliberately compact: a real café should distinguish ingredients, beverage supplies, packaging, delivery charges, payroll taxes, card settlement timing, debt payments, and other material cash movements. Most importantly, a profitable-looking month can still have a cash shortfall if supplier payments fall due before customer receipts. Use actual expected dates where that timing matters.
6. Build a lower-revenue case and a cut list
Duplicate the base budget and lower the income lines that are least certain; do not apply one arbitrary reduction to every category if that would misrepresent your business. For example, move a proposed agency project out of the confirmed column, or lower café sales in the months that depend on an unbooked event. Keep committed expenses and dated bills in place. Then look at the cumulative cash line: which month reaches its lowest point, and does the projected balance fall below the amount you need to operate?
Write a short cut list beside the lower case. Rank actions by how quickly they can reduce cash outflow and what trade-offs they involve: delay a discretionary equipment upgrade, reduce a planned promotion, pause an optional subscription at renewal, or defer a nonessential purchase. Do not treat payroll, tax, debt, safety, or contractual obligations as casual cuts; get appropriate advice before changing commitments. Record who would decide and by what date, so the scenario is an action plan rather than a vague warning.
7. Review it once a month
Choose a recurring date—for example, the first Tuesday after month-end—to compare the budget with what actually happened. Note the difference, write a one-line explanation, and revise future months only when new information warrants it. Update confirmed project payment dates, booked events, supplier renewals, staffing changes, and cash balances; keep the original assumption visible when useful. A practical 30-minute budget-versus-actuals review can turn the annual plan into a working routine instead of a file that gets opened once.
Ququ Finance is one option for entering one-off or monthly income and expense lines and viewing cash flow by month. It can support the planning workflow described here; it is not a substitute for accounting records, tax advice, or checking that your assumptions match actual payment timing. Learn more at Ququ Finance.




