Unit 5 - Business Accounting P3

Sheet1
January February March April May June Ju
Receipts
Sales £10,000.00 £30,000.00 £30,000.00 £37,000.00 £37,000.00 £37,000.00
VAT on sales £2,000.00 £6,000.00 £6,000.00 £7,400.00 £7,400.00 £7,400.00
VAT refund £0.00
Owner’s capital £25,000.00
Loan £80,000.00
Total Receipts £117,000.00 £36,000.00 £36,000.00 £44,400.00 £44,400.00 £44,400.00
Payments
Purchases £13,500.00 £13,500.00 £13,500.00 £16,650.00 £16,650.00 £16,650.00
VAT on purchases £2,700.00 £2,700.00 £2,700.00 £3,330.00 £3,330.00 £3,330.00
Bank loan £1,000.00 £1,000.00 £1,000.00 £1,000.00 £1,000.00 £1,000.00
Machinery £85,000.00
Fixtures and fittings £20,000.00
Overdraft £277.90 £192.18
Rent £2,083.33 £2,083.33 £2,083.33 £2,083.33 £2,083.33 £2,083.33
Rates £1,700.00 £1,700.00 £1,700.00 £1,700.00 £1,700.00 £1,700.00
Salary £6,333.33 £6,333.33 £6,333.33 £6,333.33 £6,333.33 £6,333.33
Telephone £300.00 £300.00
Post £50.00 £50.00 £50.00 £50.00 £50.00 £50.00
Courier £1,500.00 £1,500.00 £1,500.00 £1,500.00 £1,500.00 £1,500.00
Advertising £160.00 £160.00 £660.00 £160.00 £160.00 £660.00
Heat and light £500.00 £500.00 £500.00 £500.00 £500.00 £500.00
Insurance £1,000.00
VAT Paid £5,900.00 £12,210.00
Total Payments £135,804.56 £29,718.84 £36,226.66 £33,306.66 £33,306.66 £46,316.66
Net cash flow -£18,804.56 £6,281.16 -£226.66 £11,093.34 £11,093.34 -£1,916.66
Opening balance £0.00 -£18,804.56 -£12,523.40 -£12,750.06 -£1,656.72 £9,436.62
Closing balance -£18,804.56 -£12,523.40 -£12,750.06 -£1,656.72 £9,436.62 £7,519.96