**HWMT Income v Expenditure September 20 to August 2021** 

**Accrual Basis** 

||**Sep '20 - Aug 21**|
|---|---|
|**Ordinary Income/Expense**||
|**Income**||
|**Bank Interest Earned**|3.41|
|**Memorial Hall income**||
|**Grants received**|1,000.00|
|**MH fat rental**|5,107.28|
|**MH lettings**|8,661.98|
|**Total Memorial Hall income**|14,769.26|
|**Pavilion/Sports Grounds income**||
|**Membership Fees**|3,834.00|
|**Grants rec'd**|21,286.16|
|**Pavilion lettings**|182.00|
|**Pavilion donations**|130.00|
|**Sports Ground lettings**|5,598.40|
|**Pavilion bar takings**|3,779.00|
|**Total Pavilion/Sports Grounds income**|34,809.56|
|**Total Income**|49,582.23|
|**Gross Proft**|49,582.23|
|**Expense**||
|**Memorial Hall expenditure**||
|**waste bins**|315.00|
|**business rates**|105.63|
|**insurances**|776.47|
|**internet**|475.80|
|**licences**|159.00|
|**repairs & maintenance**|2,091.52|
|**utilities**|6,562.79|
|**water rates MH**|1,692.90|
|**Total Memorial Hall expenditure**|12,179.11|
|**Professional Fees**|2,360.00|
|**Pavilion expenditure**||
|**cleaning**|657.00|
|**bar equipment & consumables**|519.96|
|**bar expenditure - food & drink**|2,118.42|
|**licences**|180.00|
|**internet**|175.70|
|**Pav repairs & maintenance**|20,156.59|
|**Total Pavilion expenditure**|23,807.67|
|**Sports Ground expenditure**||
|**Awards**|37.00|
|**business rates**|105.90|
|**electricity**|713.85|
|**Insurance**|1,390.36|
|**Repairs and Maintenance**|4,442.69|
|**grass cutting**|10,570.80|
|**Waste collection**|1,262.67|
|**water rates - sports ground**|293.71|
|**water rates - tennis & bowls**|(48.04)|



**Page 1 of 2** 



**HWMT Income v Expenditure September 20 to August 2021** 

**Accrual Basis** 

||**Sep '20 - Aug 21**|
|---|---|
|**Total Sports Ground expenditure**|18,768.94|
|**Total Expense**|57,115.72|
|**Surplus/(Defecit) for the Year**|**(7,533.49)**|



**Page 2 of 2** 



Tips for updating QuickBooks I
You con export o report. chonge certoin formott
QuSckBooks w511 update and keep these chonges:
enamed report title5
Font. Fill. and Number formotting
l in row & column header5 only)
Resized column5
enamed rolumn & row headers
I nserted row5 & columns
You must enter text or a Formula in the row to preserwe it.
New Excel formula5
The updated report must contain the row 055DCiOted with
I nserted text
Make your new text alway5 oppear nexi to a partitulor row
the text a5 a f ormula (e.g.
inserted text")
QulckBook5 wlll NOT
support these change
Font f ormc4tting in
Inse¥ted rc>wS thot ai
- Movtry dtsto cell%

reports in Excel
Ling or odd new formulos. ond then updote it with new QuickB
My Company P&L
Profit & L055
J￿lY thrf•U9h 2012
qPTh•M2
•DI*￿ . L*••
li
Dllr formLJI
ij
by enterirbg
oTh-he<qde* cells
ie left empty
- Rerbomed dtste columns
- Delet￿ columft5
Sorted columns
Inserted ￿lUMn5 in
t*tween Qu i¢kBooks
row heoders

kB7 oa
Irmul<qS not be
1(4psed reports when
S(4me excel sheet

**HWMT Balance Sheet As of 31 August 2021** 

**11:18 AM 06/12/21 Accrual Basis** 

|**ASSETS**<br>**Current Assets**<br>**Other Current Assets**<br>**Bar stock in hand**<br>**Total Other Current Assets**<br>**Accounts Receivable**<br>**accounts receivable**<br>**Total Accounts Receivable**<br>**Cash at bank and in hand**<br>**Barclays Sports Grounds**<br>**Barclays Memorial Hall**<br>**COIF Main**<br>**ARC**<br>**Tennis Club surety**<br>**COIF Main - Other**<br>**Total COIF Main**<br>**COIF Memorial Hall**<br>**Total Cash at bank and in hand**<br>**Total Current Assets**<br>**Current Liabilities**<br>**Accounts Payable**<br>**Accounts Payable**<br>**Total Accounts Payable**<br>**Other Current Liabilities**<br>**Anticipated repayments**<br>**Tennis Club loan**<br>**Total Other Current Liabilities**<br>**Total Current Liabilities**<br>**NET CURRENT ASSETS**<br>**TOTAL ASSETS LESS CURRENT LIABILITIES**<br>**NET ASSETS**<br>**Reserves**<br>**ARC development fund**<br>**Cumulative Reserves**<br>**Unrestricted Net Assets**<br>**Total Trust funds**<br>**Proft/(Loss) for the Year**|**31 Aug 21**|
|---|---|
||478.52|
||478.52<br>1,042.43|
||1,042.43<br>2,052.79<br>19,914.02<br>6,600.00<br>3,800.00<br>398.52|
||10,798.52<br>7,138.53|
||39,903.86|
||41,424.81<br>1,354.79|
||1,354.79<br>465.00<br>(200.00)|
||265.00|
||1,619.79<br>39,805.02|
||39,805.02|
||**39,805.02**|
||20,520.00<br>29,329.35<br>(2,510.84)<br>(7,533.49)|
||**39,805.02**|



## Note 

The ARC Development Fund has been treated as a Reserve as there is no commitm **(in 2020 It was shown as a current liability).** 

**Page 4 of 5** 



**HWMT Balance Sheet As of 31 August 2021** 

**11:18 AM 06/12/21 Accrual Basis** 

## **ASSETS** 

**Current Assets** 

**Other Current Assets** 

**Bar stock in hand Total Other Current Assets Accounts Receivable** 

**accounts receivable Total Accounts Receivable Cash at bank and in hand** 

**Barclays Sports Grounds Barclays Memorial Hall COIF Main ARC Tennis Club surety COIF Main - Other** 

**Total COIF Main COIF Memorial Hall** 

**Total Cash at bank and in hand Total Current Assets** 

**Current Liabilities** 

**Accounts Payable Accounts Payable Total Accounts Payable Other Current Liabilities Anticipated repayments Tennis Club loan Total Other Current Liabilities Total Current Liabilities** 

**NET CURRENT ASSETS TOTAL ASSETS LESS CURRENT LIABILITIES NET ASSETS** 

**Reserves** 

**ARC development fund Cumulative Reserves** 

**Unrestricted Net Assets Profit/(Loss) for the Year** 

**Total Trust funds** 

Note 

The ARC Development Fund has been trement to Expenditure **(in 2020 It was shown as a current liability).** 

**Page 5 of 5** 



HENLEY4NARDEN WAR MEMORIAL
TRUST CIO
WAR
TRLST
1941
I l DeCern￿ 2021
lan Fox
Da
Chairman