• Accounting: costs, break-even and budgets

How do you prepare a cash budget?

Written with AI (How we create content)Target level: Grade 12Last updated: Report an error
Quick answer

To prepare a cash budget, list for each coming month the cash expected to come in and to go out, then add receipts to the opening balance and subtract payments to find the closing balance, which opens the next month. Receipts follow when customers actually pay; non-cash items like depreciation are left out. A negative balance shows when finance will be needed.

The topic explained

Planning cash, not profit

A business can be profitable and still run out of cash, because sales on credit are collected later and large payments come all at once. A cash budget plans for that. To prepare a cash budget, take the coming months one at a time and list the cash expected to come in, the receipts, and the cash expected to go out, the payments. Each month begins with an opening balance and ends with a closing balance, which becomes the next month's opening balance.

Take a made-up shop planning April to June with ₪20,000 in the bank on 1 April. Its customers pay half in the month of the sale and half in the following month. Sales were ₪30,000 in March and are expected to be ₪40,000, ₪60,000 and ₪50,000 in April, May and June. A cash budget is built from the business's other plans: the sales budget gives each month's sales, the collection pattern turns them into receipts, and the purchases and expense budgets give the payments. When any of those plans changes, the cash budget changes with it.

Step one: the receipts

Receipts are not the month's sales. April's receipts are half of April's sales, ₪20,000, plus half of March's, ₪15,000: ₪35,000. May's are ₪30,000 + ₪20,000 = ₪50,000, and June's ₪25,000 + ₪30,000 = ₪55,000. The most common mistake is to copy the sales figures into the budget: in May the shop sells ₪60,000 but collects only ₪50,000.

Receipts table: April 20,000 from April sales and 15,000 from March sales, total 35,000; May 30,000 and 20,000, total 50,000; June 25,000 and 30,000, total 55,000.Receipts from customersAprMayJun50% this month20,00030,00025,00050% last month15,00020,00030,000Total receipts35,00050,00055,000
Half collected at once, half a month later.

Step two: payments and balances

The shop expects to pay for its purchases in the month it buys them, ₪25,000, ₪35,000 and ₪30,000, plus rent of ₪8,000 and salaries of ₪12,000 every month, and a new display case for ₪15,000 in May. Payments are ₪45,000 in April, ₪70,000 in May and ₪50,000 in June. Then the balances: April 20,000 + 35,000 − 45,000 = ₪10,000; May 10,000 + 50,000 − 70,000 = −₪10,000; June −10,000 + 55,000 − 50,000 = −₪5,000.

Depreciation of the display case does not appear: it is an expense in the income statement, but no cash leaves the business for it. Only the payment of ₪15,000 in May is cash.

Cash budget for April to June: opening balances 20,000, 10,000 and −10,000; receipts 35,000, 50,000 and 55,000; purchases 25,000, 35,000 and 30,000; rent and salaries 20,000 a month; equipment 15,000 in May; closing balances 10,000, −10,000 and −5,000.Cash budgetAprMayJunOpening balance20,00010,000−10,000Add receipts35,00050,00055,000Purchases25,00035,00030,000Rent and salaries20,00020,00020,000Equipment015,0000Closing balance10,000−10,000−5,000
Each month's closing balance opens the next.

What the budget tells the owner

The budget warns, two months ahead, that the shop will be ₪10,000 short at the end of May, although April and June look healthy and the business may well be profitable. With that warning the owner can act in time: arrange an overdraft of at least ₪10,000 before May, ask customers to pay sooner, or postpone the display case to July. Postponing it would leave ₪5,000 at the end of May and ₪10,000 at the end of June. A cash budget is an estimate, so it is updated each month as real figures replace the planned ones.

Graph of the month-end cash balance in thousands of shekels: 20 at the start, 10 at the end of April, minus 10 at the end of May and minus 5 at the end of June, with the zero line marked.Month₪000123−10−551015200
Months 1 to 3 are April to June: below zero in May and June.
Free printable worksheet

Practice: preparing a cash budget

For 12th grade accounting students. Use the shop's figures on the sheet; work month by month. Check the answers at the end.

Free, no sign-up. The answer key prints on the second page. Regenerating a new worksheet on the same topic needs a free account.

Free printable worksheetlessoons.com
Practice: preparing a cash budgetName:
  1. What is the difference between a cash budget and a budgeted income statement?

  2. Complete the receipts table.

    The receipts table with June's share of May sales and the May and June totals marked with question marks.Receipts from customersAprMayJun50% this month20,00030,00025,00050% last month15,00020,000?Total receipts35,000??
  3. A second shop collects 60% in the month of sale and 40% the month after. Its sales are ₪20,000 in June and ₪30,000 in July. Find July's receipts.

  4. Complete the cash budget.

    The cash budget with June's opening balance and the May and June closing balances marked with question marks.Cash budgetAprMayJunOpening balance20,00010,000?Add receipts35,00050,00055,000Purchases25,00035,00030,000Rent and salaries20,00020,00020,000Equipment015,0000Closing balance10,000??
  5. Use the graph: in which month does the shop first need extra finance, and how much at least?

    The graph of month-end cash balances: 20, 10, minus 10 and minus 5 thousand shekels, with the zero line.Month₪000123−10−551015200
  6. The display case is depreciated by ₪250 a month. Should the depreciation appear in the cash budget? Explain.

  7. The owner postpones the display case to July. Find the closing balances for May and June.

More topics and worksheets at lessoons.com© 2026 Lessons

Common questions

Why prepare a cash budget if the business is profitable?

Because profit and cash arrive at different times. Credit sales, stock purchases and large payments can leave a profitable business short of cash in a given month, and the budget shows that in advance.

Why is depreciation not in a cash budget?

Depreciation is an expense that spreads the cost of an asset over its life, but no money is paid for it each period. The cash left the business when the asset was bought, and that payment is what the budget shows.

What happens when the closing balance is negative?

It means the planned payments are larger than the cash available. The business needs finance, such as an overdraft or a loan, or must change its plans: collect sooner, pay later or delay a purchase.

How far ahead should a cash budget look?

Many businesses plan month by month for the coming months and update the budget as each month ends. The further ahead, the less certain the figures, so the budget is reviewed regularly.

Are loans and owner's investments in the cash budget?

Yes. Money received from a loan or from the owner is a receipt, and loan repayments and interest paid are payments, because all of them move cash.

Still have a question? Ask Lessi

Any question about this subject. Lessi answers right here, step by step.

Try asking

Asking needs a free account; your question is kept while you sign up. Answers are written by AI and can contain mistakes. Lessi doesn’t give medical or legal advice.

Learn it with a teacher

Learn this topic live with Lessi

Lessi, the AI teacher, explains it out loud on a board, with short quizzes, at your pace. The first 60 minutes are free.