Cash Budget Preparation: Exam Checklist & Worked Guide

Why Cash Budgets Feature Heavily in Accounting Exams

In financial and management accounting assessments, the cash budget is one of the most frequently tested management tools. Examiners use cash budget questions to test two distinct competencies simultaneously: your mechanical accuracy in scheduling cash flows across specific time horizons, and your theoretical grasp of accruals versus cash accounting.

A cash budget is a forecast of future cash inflows and cash outflows over a defined period (usually monthly). Unlike an income statement, which applies the matching and accruals concepts to show profit earned, a cash budget records only physical movements of bank balances and cash during the period they take place.

Mastering A-Level Accounting requires you to move fluidly between these two perspectives. Let us break down how to approach a cash budget preparation exam question with methodical precision.

---

Core Structure of a Cash Budget

A standard multi-column cash budget is divided into four main sections for each budgeted month:

1. Receipts (Inflows): Cash sales, collections from trade receivables, disposal proceeds of non-current assets, capital introduced, and bank loans received.
2. Payments (Outflows): Cash purchases, payments to trade payables, operational overheads, wages, capital expenditure (asset purchases), tax payments, and loan interest or repayments.
3. Net Cash Flow: Total Cash Receipts minus Total Cash Payments for that specific month.
4. Opening and Closing Cash Balances: Net cash flow is added to (or subtracted from) the opening cash balance to yield the closing cash balance, which then carries forward as the opening balance of the following month.

---

Non-Cash Adjustments: What Never Belongs in a Cash Budget

The most common deduction of marks in a cash budget preparation exam involves students including non-cash accrual entries. Examiners deliberately embed these items in scenario text to test your conceptual clarity.

Non-Cash Items to Exclude Completely:

• Depreciation: Depreciation is an internal allocation of an asset's cost over its useful life; no cash changes hands when an asset depreciates.
• Allowance for Doubtful Debts / Bad Debts Written Off: While bad debts reduce trade receivables, writing them off does not involve paying cash.
• Gains or Losses on Asset Disposals: These are accounting adjustments to profit. Only the actual cash disposal proceeds received are recorded under receipts.
• Inventory Adjustments: Changes in closing or opening inventory values are balance sheet valuations. The cash budget records payments for purchases, not the cost of goods consumed.

---

Handling Timing Differences: Receipts and Payments

Questions rarely involve all transactions taking place in pure cash. You must construct supporting schedules for debtors and creditors before attempting to fill out the master budget.

1. Collections from Trade Receivables (Debtors)

Examiners often specify a settlement pattern, such as:

• 20% of sales are settled for cash immediately in the month of sale.
• 50% are settled in the month following the sale (subject to a settlement discount, if applicable).
• 30% are settled two months after the sale.

Key Tip: If a prompt mentions a 5% cash discount for payment received in the month following sale, calculate the cash received as 95% of that specific debtor balance.

2. Payments to Trade Payables (Creditors)

Pay attention to whether the problem gives you "Cost of Sales" or "Purchases". If inventory levels change, remember that:
$$\text{Purchases} = \text{Cost of Sales} + \text{Closing Inventory} - \text{Opening Inventory}$$

Once credit purchases are identified, allocate payments according to credit supplier terms (e.g., payment one month in arrears).

3. Accrued and Prepaid Operating Overheads

If overheads include rent paid quarterly in advance, place the entire quarterly cash payment in the specific month it leaves the bank account, rather than spreading it evenly across three months.

---

Step-by-Step Worked Example: Orion Traders

To solidify the concept, let us review an original worked scenario.

Scenario Details

Orion Traders is preparing a monthly cash budget for the first quarter (January to March). The opening bank balance on 1 January is $12,000.

1. Sales Forecast:
   • November (actual): $40,000
   • December (actual): $50,000
   • January (budgeted): $60,000
   • February (budgeted): $70,000
   • March (budgeted): $80,000
   • Terms: 25% of sales are cash sales. The remaining 75% are on credit, collected in the month following the sale.
2. Purchases Forecast:
   • December (actual): $30,000
   • January (budgeted): $35,000
   • February (budgeted): $40,000
   • March (budgeted): $45,000
   • Terms: All purchases are on credit, paid one month after purchase.
3. Operating Expenses: Paid in the month incurred at $8,000 per month (this includes $1,500 monthly depreciation).
4. Capital Expenditure: A delivery van costing $18,000 is to be bought in February, paid in two equal installments in February and March.

---

Preliminary Workings

Receipts Schedule:

• January:
  • Cash sales (25% of $60,000) = $15,000
  • Credit collections (75% of Dec sales: $50,000 × 75%) = $37,500
  • Total = $52,500
• February:
  • Cash sales (25% of $70,000) = $17,500
  • Credit collections (75% of Jan sales: $60,000 × 75%) = $45,000
  • Total = $62,500
• March:
  • Cash sales (25% of $80,000) = $20,000
  • Credit collections (75% of Feb sales: $70,000 × 75%) = $52,500
  • Total = $72,500

Operating Expenses Schedule:

• Cash paid per month = Total expense ($8,000) - Non-cash depreciation ($1,500) = $6,500 per month.

---

The Final Cash Budget

Item	January ($)	February ($)	March ($)
Receipts
Cash Sales	15,000	17,500	20,000
Collections from Debtors	37,500	45,000	52,500
Total Receipts (A)	52,500	62,500	72,500
Payments
Payments to Creditors	30,000	35,000	40,000
Operating Expenses	6,500	6,500	6,500
Capital Equipment (Van)	—	9,000	9,000
Total Payments (B)	36,500	50,500	55,500
Net Cash Flow (A - B)	16,000	12,000	17,000
Opening Balance	12,000	28,000	40,000
Closing Balance	28,000	40,000	57,000

---

The Pre-Submission Exam Checklist

Before concluding your cash budget question in an exam, run through this five-point validation list:

• Did you eliminate all non-cash items? Double-check that depreciation, doubtful debt provisions, and paper profits on disposal are omitted from both receipts and payments.
• Are settlement discounts accurately applied? Ensure discount allowed is deducted from debtor receipts, and discount received is deducted from supplier payments.
• Did you roll the balances forward correctly? Ensure Closing Balance of Month 1 = Opening Balance of Month 2. A simple arithmetic error here cascades through the rest of the table.
• Is an overdraft marked clearly? If the closing balance is negative, enclose the figure in brackets: e.g., (4,200). Do not leave ambiguous minus signs.
• Have you answered the commentary part? Cash budget calculation questions are almost always followed by evaluation questions asking for remedial action to correct deficits or make use of surpluses.

---

Strategic Advice for Cash Deficits and Surpluses

When examiners ask you to interpret the budget you just built, keep your recommendations realistic to business practices:

Remedying a Cash Deficit:

• Short-Term Actions: Arrange or extend an agreed bank overdraft; negotiate extended credit periods with key trade payables; postpone non-essential capital expenditure; offer modest cash settlement discounts to accelerate receivables collections.
• Long-Term Actions: Issue fresh share capital or arrange long-term loans; sell obsolete non-current assets; adopt just-in-time inventory systems to reduce cash tied up in working capital.

Managing a Cash Surplus:

• Repay expensive borrowings early to save finance costs.
• Invest in short-term interest-bearing liquid instruments.
• Take advantage of early payment discounts offered by suppliers.

To build exam confidence across all management accounting topics, explore our curated accounting study resources or work directly with a private accounting tutor to review your written solutions.