Accounting and reporting on a cash flow basis•11
Half-year to 30 June 20X1
£
Receipts from
Customers 165,000
Payments to
Suppliers (124,000)
Expense creditors (18,000)
Rent (6,250)
Total payments (148,250)
Realised operating cash flows 16,750
Sales Cash Purchases Expenses
Month invoiced received invoiced Cash paid invoiced Cash paid
££££££
January 15,000 7,500 16,000 3,400 3,100
February 20,000 17,500 19,000 16,000 3,500 3,400 March 35,000 27,500 29,000 19,000 3,800 3,500 April 40,000 37,500 32,000 29,000 3,900 3,800
May 40,000 40,000 33,000 32,000 3,900 3,900
June 45,000 42,500 37,000 33,000 4,000 3,900
TOTAL 195,000 172,500 166,000 129,000 22,500 21,600
Note:The following items were included under the Expenses invoiced heading:
Expense creditors – amount
Wages – £3,100 per month paid in the month
Commission – 2% of sales invoiced payable one month in arrears
Jan Feb Mar Apr May Jun Total
££ ££ ££ £
Receipts
Customers 7,500 17,500 27,500 37,500 40,000 42,500 172,500
Less payments
Suppliers 16,000 19,000 29,000 32,000 33,000 129,000
Expense
creditors 3,100 3,400 3,500 3,800 3,900 3,900 21,600
Rent 6,250 6,250
Realised (1,850) (1,900) 5,000 4,700 4,100 5,600 15,650
Figure 1.6 Forecast of realised operating cash flows
Figure 1.7 Monthly sales, purchases and expenses for six months ended 30 June
20X1
Figure 1.8 Monthly realised operating cash flows