To prepare the Receipts and Payments Account and the Income and Expenditure Account, we first need to identify and adjust the relevant figures. The "Balance in the Bank account M212 060" on 31 December 2022 is the closing balance. We will calculate the opening bank balance for the Receipts and Payments Account.
Step 1: Calculate total cash receipts (excluding opening balance) and total cash payments (excluding closing balance).
Total Cash Receipts:
M94800(Schoolfees)+M20000(Donations)+M15000(Salesofuniform)=M129800
Total Cash Payments:
M7300(Stationery)+M102000(Equipment)+M12344(Sundryexpenses)+M50000(Salaries)+M22000(Rent)+M5367(Electricity)=M199011
Step 2: Calculate the opening bank balance for the Receipts and Payments Account.
Given the closing bank balance of M212 060, we can find the opening balance:
OpeningBalance=ClosingBalance−TotalReceipts+TotalPayments
OpeningBalance=M212060−M129800+M199011=M281271
Step 3: Prepare the Receipts and Payments Account for the year ended 31 December 2022.
This account summarizes all cash inflows and outflows during the year.
ReceiptsToBalanceb/d(1Jan2022)ToSchoolfeesreceivedToDonationsreceivedToSalesofuniformTotalAmount(M)281271948002000015000411071PaymentsByStationeryboughtByEquipmentpurchasedBySundryexpensesByInstructorsalariesByBuildingrentByElectricityexpenseByBalancec/d(31Dec2022)TotalAmount(M)73001020001234450000220005367212060411071
Step 4: Calculate adjusted expenditure items for the Income and Expenditure Account.
- Stationery consumed: Stationery bought (M7 300) less closing inventory (M1 100).
M7300−M1100=M6200
- Depreciation on equipment: 10% of the cost of equipment purchased (M102 000).
10%×M102000=M10200
- Building rent expense: Rent paid (M22 000) plus rent owing (accrued) at year-end (M2 000).
M22000+M2000=M24000
Step 5: Calculate total income for the Income and Expenditure Account.
Income items are recognized when earned. No adjustments are specified for these.
M94800(Schoolfees)+M20000(Donations)+M15000(Salesofuniform)=M129800
Step 6: Calculate total expenditure for the Income and Expenditure Account.
This includes the adjusted expenditure items and other expenses.
M6200(Stationery)+M10200(Depreciation)+M12344(Sundryexpenses)+M50000(Salaries)+M24000(Rent)+M5367(Electricity)=M108111
Step 7: Determine the surplus or deficit for the Income and Expenditure Account.
Surplus=TotalIncome−TotalExpenditure
Surplus=M129800−M108111=M21689
Step 8: Prepare the Income and Expenditure Account for the year ended 31 December 2022.
This account shows the financial performance on an accrual basis.
ExpenditureToStationeryconsumedToDepreciationToSundryexpensesToInstructorsalariesToBuildingrentToElectricityexpenseToSurplusTotalAmount(M)620010200123445000024000536721689129800IncomeBySchoolfeesByDonationsBySalesofuniformTotalAmount(M)948002000015000129800
What's next? 📸