Sonning Common Millenium Field Accounts for the year ended July 31, 2023
Income and Expenditure Account
| Subscriptions SCOST Donation Gift Aid Wayleave Miscellaneous Maintenance Administration Insuance Miscell Net Surplus/(Deficit) Balance Sheet Accumulated Fund b/f Surplus/(Deficit) for year Accumulated Fund c/f Represented by: Development outgoings Cash at Bank Creditors |
2023 2022 124 179 27,962 40,000 0 18 40 41 14 0 |
2023 2022 124 179 27,962 40,000 0 18 40 41 14 0 |
2022 |
|---|---|---|---|
| 28,139 | 40,238 | ||
| 30 29,579 32 131 333 227 0 75 |
|||
| 395 | 30,011 | ||
| 27,745 | 10,227 | ||
| 26,767 17,098 27,745 (557) |
|||
| 54,512 | 26,767 | ||
| 3,020 0 51,492 26,767 |
|||
| 54,512 | 26,767 | ||
| 0 0 |
|||
| 54,512 | 26,767 |
Auditors' Report
I have examined the books and records presented by the Treasurer and confirm that the above Balance Sheet and Income and Expenditure Account are in accordance therewith.
Date: Aug 30, 2023 Signed by: Auditor
C Whittaker
Treasurer: Chairman:
Do not change yellow cells. They are formulae that are dependent on the white ones.
Trial Balance
| Opening Balances k Printing & Stationery l Postage m Maintenance n Administration p Insuance z Miscell y Creditors a Subscriptions b SCOST c Gift Aid d Bench e Wayleave z Miscellaneous Surplus/(Deficit) Balance b/f Closing balance per bank rec Balance Sheet Creditors 0.00 Surplus b/f 26,767.08 Cash 26,767.08 y Prepayments 0.00 Debtors 0.00 Totals |
Cash book Adjustments Accounts Op Bals Tfrs Accruals Surplus |
Cash book Adjustments Accounts Op Bals Tfrs Accruals Surplus |
Cash book Adjustments Accounts Op Bals Tfrs Accruals Surplus |
|---|---|---|---|
| 0.00 0.00 0.00 0.00 30.00 30.00 31.50 31.50 333.28 333.28 616.40 (630.00) (13.60) 3,020.00 (3,020.00) 0.00 |
|||
| 4,031.18 | -3,650.00 0.00 0.00 0.00 |
381.18 | |
| (124.00) (124.00) (27,961.63) (27,961.63) 0.00 0.00 (630.00) 630.00 0.00 (40.16) (40.16) 0.00 0.00 |
|||
| (28,755.79) | 0.00 0.00 0.00 0.00 0.00 |
(28,125.79) | |
| 24,724.61 (27,744.61) 26,767.08 |
|||
| 51,491.69 | 0.00 (3,650.00) 0.00 0.00 (27,744.61) (27,744.61) |
||
| - 0.00 0.00 0.00 27,744.61 54,511.69 24,724.61 51,491.69 3,020.00 3,020.00 0.00 0.00 |
|||
| 24,724.61 0.00 (630.00) 0.00 0.00 0.00 109,023.38 |
Creditors
Prepayments
Prepayments received
| Totals > 28,755.79 | Totals > 28,755.79 | Mar 2020-1 Summary a Subscription b SCOST Gift c Gift Aid d Bench (Hale e Wayleave f Miscellaneo Total Income |
|
|---|---|---|---|
| Date Payor / Source Code |
Bank | Comments | |
| 8/1/2022 ac Higson a 2.00 8/15/2022 CHAPS SCOST b 2,961.63 8/16/2022 CHAPS SCOST b 25,000.00 9/1/2022 ac Higson a 2.00 10/3/2022 ac Higson a 2.00 10/27/2022 ac Southern Electric e 30.16 11/1/2022 ac Higson a 2.00 11/24/2022 ac Facebook a 5.00 12/1/2022 ac Higson a 2.00 12/30/2022 ac Procter - bench d 630.00 1/3/2023 ac Higson a 2.00 1/3/2023 ac Hancock a 5.00 2/1/2023 ac Higson a 2.00 3/1/2023 ac Higson a 2.00 3/30/2023 29765 SSE e 10.00 4/3/2023 ac Brown a 15.00 4/3/2023 ac Brown a 15.00 4/3/2022 ac Cunningham a 10.00 4/3/2023 ac Staford a 10.00 4/3/2023 ac Higson a 2.00 4/3/2023 ac Phillips a 5.00 4/1/2022 ac Walker a 5.00 4/3/2023 ac Pearson a 10.00 5/2/2023 ac Higson a 2.00 5/2/2023 ac Stevens a 10.00 6/1/2022 ac Higson a 2.00 6/1/2022 ac Dayton a 10.00 7/3/2023 ac Higson a 2.00 |
Do not change yellow cells. They are formulae that are dependent on the white ones.
| ns | 124.00 |
|---|---|
| t | 27,961.63 |
| - | |
| e) | 630.00 |
| 40.16 | |
| ous | - |
| 28,755.79 |
Totals - 4,031.18
| Date Chq No Payee CodeDetail Bank 8/9/2022 348 SCVH n 31.50 9/28/2022 349 P Memmot - survey y 500.00 1/27/2023 BACS McVey Parker - bench z 266.40 4/14/2023 BACS Green Gym - mtce m 30.00 4/17/2023 BACS Petherwick insurance p 333.28 4/28/2023 350 I H Austn - bench install. z 350.00 6/14/2023 351 Seymour Parkes - legal y 2,520.00 |
2020-1 S |
|---|---|
| k l m n p x y z |
Bank ac
ü
Do not change yellow cells. Th that are dependent on the whit
Summary
| Printing & Stationery | - | ||
|---|---|---|---|
| Postage | - | ||
| Maintenance | 30.00 | ||
| Administration | 31.50 | ||
| Insurance | 333.28 | ||
| Equipment & Furnishings | - | ||
| Prepaid Development Costs | 3,020.00 | ||
| Miscellaneous | 616.40 | ||
| Total payments | 4,031.18 | ||
| ccount: Opening balance 16,540.45 Payments (4,031.18) Receipts 28,755.79 Closing balance 41,265.06 |
ccount: Opening balance 16,540.45 Payments (4,031.18) Receipts 28,755.79 Closing balance 41,265.06 |
ccount: Opening balance 16,540.45 Payments (4,031.18) Receipts 28,755.79 Closing balance 41,265.06 |
|---|---|---|
| 41,265.06 |
iey are formulae .e ones.
Bank reconciliation
0.00 |
|||
|---|---|---|---|
| 31-Mar-20 | |||
| Balance per bank Outstanding cheques: Chq # Total O/S cheques Date Outstanding receipts Total O/S receipts Reconciled Per books |
51,491.69 0.00 0.00 51,491.69 51,491.69 |
||
| Book Balance | |||
| Balance Apl 1 Income |
26,767.08 28,755.79 |
||
| Payments Balance Mar 31 per books |
(4,031.18) 51,491.69 |
Try to do a reconciliation at least every quarter. It ensures that all transactions have been picked up and that bank errors are identified early.