## **Sonning Common Millenium Field Accounts for the year ended July 31, 2023** 

## **Income and Expenditure Account** 

|Subscriptions<br>SCOST Donation<br>Gift Aid<br>Wayleave<br>Miscellaneous<br>Maintenance<br>Administration<br>Insuance<br>Miscell<br>Net Surplus/(Deficit)<br>**Balance Sheet**<br>Accumulated Fund b/f<br>Surplus/(Deficit) for year<br>Accumulated Fund c/f<br>Represented by:<br>Development outgoings<br>Cash at Bank<br>Creditors|**2023**<br>**2022**<br>124<br>179<br>27,962<br>40,000<br>0<br>18<br>40<br>41<br>14<br>0|**2023**<br>**2022**<br>124<br>179<br>27,962<br>40,000<br>0<br>18<br>40<br>41<br>14<br>0|**2022**|
|---|---|---|---|
||28,139|40,238||
||30<br>29,579<br>32<br>131<br>333<br>227<br>0<br>75|||
||395|30,011||
|||||
||27,745|10,227||
||26,767<br>17,098<br>27,745<br>(557)|||
||**54,512**|**26,767**||
||3,020<br>0<br>51,492<br>26,767|||
||54,512|26,767||
||0<br>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**<br>**Balances**<br>k<br>Printing & Stationery<br>l<br>Postage<br>m<br>Maintenance<br>n<br>Administration<br>p<br>Insuance<br>z<br>Miscell<br>y<br>Creditors<br>a<br>Subscriptions<br>b<br>SCOST<br>c<br>Gift Aid<br>d<br>Bench<br>e<br>Wayleave<br>z<br>Miscellaneous<br>Surplus/(Deficit)<br>Balance b/f<br>Closing balance per bank rec<br>**Balance Sheet**<br>Creditors<br>0.00<br>Surplus b/f<br>26,767.08<br>Cash<br>26,767.08<br>y<br>Prepayments<br>0.00<br>Debtors<br>0.00<br>Totals|**Cash book**<br>**Adjustments**<br>**Accounts**<br>**Op Bals**<br>**Tfrs**<br>**Accruals**<br>**Surplus**|**Cash book**<br>**Adjustments**<br>**Accounts**<br>**Op Bals**<br>**Tfrs**<br>**Accruals**<br>**Surplus**|**Cash book**<br>**Adjustments**<br>**Accounts**<br>**Op Bals**<br>**Tfrs**<br>**Accruals**<br>**Surplus**|
|---|---|---|---|
||0.00<br>0.00<br>0.00<br>0.00<br>30.00<br>30.00<br>31.50<br>31.50<br>333.28<br>333.28<br>616.40<br>(630.00)<br>(13.60)<br>3,020.00<br>(3,020.00)<br>0.00|||
||**4,031.18**|-3,650.00<br>0.00<br>0.00<br>0.00|381.18|
||(124.00)<br>(124.00)<br>(27,961.63)<br>(27,961.63)<br>0.00<br>0.00<br>(630.00)<br>630.00<br>0.00<br>(40.16)<br>(40.16)<br>0.00<br>0.00|||
||**(28,755.79)**|0.00<br>0.00<br>0.00<br>0.00<br>0.00|**(28,125.79)**|
||24,724.61<br>(27,744.61)<br>26,767.08|||
||51,491.69|0.00<br>(3,650.00)<br>0.00<br>0.00<br>(27,744.61)<br>(27,744.61)||
|||||
|||||
|||||
||-<br>0.00<br> <br>0.00<br> <br>0.00<br>27,744.61<br>54,511.69<br> <br>24,724.61<br>51,491.69<br> <br>3,020.00<br>3,020.00<br> <br>0.00<br>0.00|||
||**24,724.61**<br>**0.00**<br>**(630.00)**<br>**0.00**<br>**0.00**<br>**0.00**<br>**109,023.38**|||



## **Creditors** 

## **Prepayments** 

**Prepayments received** 



|Totals > **28,755.79**|Totals > **28,755.79**||**Mar 2020-1 Summary**<br>a<br>Subscription<br>b<br>SCOST Gift<br>c<br>Gift Aid<br>d<br>Bench (Hale<br>e<br>Wayleave<br>f<br>Miscellaneo<br>**Total Income**|
|---|---|---|---|
|**Date**<br>**Payor / Source**<br>**Code**|**Bank**|**Comments**||
|8/1/2022<br>ac Higson<br>a<br>2.00<br>8/15/2022<br>CHAPS SCOST<br>b<br>2,961.63<br>8/16/2022<br>CHAPS SCOST<br>b<br>25,000.00<br>9/1/2022<br>ac Higson<br>a<br>2.00<br>10/3/2022<br>ac Higson<br>a<br>2.00<br>10/27/2022<br>ac Southern Electric<br>e<br>30.16<br>11/1/2022<br>ac Higson<br>a<br>2.00<br>11/24/2022<br>ac Facebook<br>a<br>5.00<br>12/1/2022<br>ac Higson<br>a<br>2.00<br>12/30/2022<br>ac Procter - bench<br>d<br>630.00<br>1/3/2023<br>ac Higson<br>a<br>2.00<br>1/3/2023<br>ac Hancock<br>a<br>5.00<br>2/1/2023<br>ac Higson<br>a<br>2.00<br>3/1/2023<br>ac Higson<br>a<br>2.00<br>3/30/2023<br>29765 SSE<br>e<br>10.00<br>4/3/2023<br>ac Brown<br>a<br>15.00<br>4/3/2023<br>ac Brown<br>a<br>15.00<br>4/3/2022<br>ac Cunningham<br>a<br>10.00<br>4/3/2023<br>ac Staford<br>a<br>10.00<br>4/3/2023<br>ac Higson<br>a<br>2.00<br>4/3/2023<br>ac Phillips<br>a<br>5.00<br>4/1/2022<br>ac Walker<br>a<br>5.00<br>4/3/2023<br>ac Pearson<br>a<br>10.00<br>5/2/2023<br>ac Higson<br>a<br>2.00<br>5/2/2023<br>ac Stevens<br>a<br>10.00<br>6/1/2022<br>ac Higson<br>a<br>2.00<br>6/1/2022<br>ac Dayton<br>a<br>10.00<br>7/3/2023<br>ac Higson<br>a<br>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**<br>**Chq No**<br>**Payee**<br>**CodeDetail**<br>**Bank**<br>8/9/2022<br>348 SCVH<br>n<br>31.50<br>9/28/2022<br>349 P Memmot - survey<br>y<br>500.00<br>1/27/2023<br>BACS McVey Parker - bench<br>z<br>266.40<br>4/14/2023<br>BACS Green Gym - mtce<br>m<br>30.00<br>4/17/2023<br>BACS Petherwick insurance<br>p<br>333.28<br>4/28/2023<br>350 I H Austn - bench install.<br>z<br>350.00<br>6/14/2023<br>351 Seymour Parkes - legal<br>y<br>2,520.00|**2020-1 S**|
|---|---|
||k<br>l<br>m<br>n<br>p<br>x<br>y<br>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:<br>Opening balance<br>16,540.45<br>Payments<br>(4,031.18)<br>Receipts<br>28,755.79<br>Closing balance<br>41,265.06|ccount:<br>Opening balance<br>16,540.45<br>Payments<br>(4,031.18)<br>Receipts<br>28,755.79<br>Closing balance<br>41,265.06|ccount:<br>Opening balance<br>16,540.45<br>Payments<br>(4,031.18)<br>Receipts<br>28,755.79<br>Closing balance<br>41,265.06|
|---|---|---|
||41,265.06||





iey are formulae
.e ones.

## **Bank reconciliation** 

||||<br> <br>0.00<br> <br> <br><br>|
|---|---|---|---|
|||**31-Mar-20**||
|Balance per bank<br>Outstanding cheques:<br>**Chq #**<br>Total O/S cheques<br>**Date**<br>Outstanding receipts<br>Total O/S receipts<br>Reconciled<br>Per books|51,491.69<br>**0.00**<br>**0.00**<br>**51,491.69**<br>51,491.69|||
|**Book Balance**||||
|Balance Apl 1<br>Income|26,767.08<br>28,755.79|||
|Payments<br>Balance Mar 31 per books|(4,031.18)<br>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. 

