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 JlY 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 ttween 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 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 Total Trust funds Proft/(Loss) for the Year |
31 Aug 21 |
|---|---|
| 478.52 | |
| 478.52 1,042.43 |
|
| 1,042.43 2,052.79 19,914.02 6,600.00 3,800.00 398.52 |
|
| 10,798.52 7,138.53 |
|
| 39,903.86 | |
| 41,424.81 1,354.79 |
|
| 1,354.79 465.00 (200.00) |
|
| 265.00 | |
| 1,619.79 39,805.02 |
|
| 39,805.02 | |
| 39,805.02 | |
| 20,520.00 29,329.35 (2,510.84) (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