## About the template Use this template to maintain monthly and annual budget. Enter Income and Expenses in respective tables to calculate Cash shortage or surplus for each month and year. Sparklines are auto-updated in each table. Note: Additional instructions have been provided in column A in PERSONAL BUDGET worksheet. This text has been intentionally hidden. To remove text, select column A, then select DELETE. To unhide text, select column A, then change font colour. To learn more about tables, press SHIFT and then F10 within a table, select the TABLE option, then select ALTERNATIVE TEXT. ## **WARD LIBRARY TRUST ACCOUNTS TO 31ST MARCH 2025** |**INCOME**
SCC Grant
Town Council Grant
FJW Grant
Takings
Room Hire
Foreign Coinage
Fundraising
Donations
Hauser & Wirth (charity of year)
Misc
**EXPENDITURE**
Stafng (SCC)
Rates
Insurance
Repairs
Security
Window Cleaning
Telephone
Utilities
F&E
Fundraising Costs
Miscellaneous
Income over Expenditure for Year (Defcit)
Closure of Virgin Money Deposit Account
Balance b/fwd @ 31/3/24
**Carry F/wd to 25-26 (Surplus)**|**DR**
7,546.54
86.08
407.08
-
333.60
136.15
207.18
1,822.47
288.00
34.19
52.00|**CR**
1,500.00
2,192.00
1,500.00
1,038.83
20.00
65.00
129.65
175.36
2,243.31
36.00| |---|---|---| |||**8,900.15**












(2,013.14)
663.26
10,137.15
**8,787.27**| ||**10,913.29**|| |ed.
|||||||||||||||| |---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---| |~~right.~~
Enter
year
~~in cell~~||**WLT ACCOUNTS TO 31 MARCH 23**|||||||||||||| |
|||||||||||||||| |~~C4 to~~
P4.
|||APR|MAY|JUN|JUL|AUG|SEP|OCT|NOV|DEC|JAN|FEB|MAR|YEAR| |~~ng in~~
~~cell~~||**INCOME**|Column1|Column2|Column3|Column4|Column5|Column6|Column7|Column8|Column9|Column10|Column11|Column12|Column13| |||SCC Grant|||£500.00|£500.00||£500.00||||£500.00|||£2,000.00| |||Town Council Grant|£1,592.00||||||||||||£1,592.00| |||Takings||£99.00|||£182.37||£102.60|||£194.95||£186.00|£764.92| |||Room Hire||||£10.00||£10.00||||£20.00||£120.00|£160.00| |||Foreign Coinage|||£162.00||||||||||£162.00| |||Fundraising|||||£14.27||£201.50|||£9.13|||£224.90| |||Donations|||||£650.00|£790.00|£2,755.00|£1,038.84||£852.54|£5,000.00|£100.00|£11,186.38| |||**Total**|**£1,592.00**|**£99.00**|**£662.00**|**£510.00**|**£846.64**|**£1,300.00**|**£3,059.10**|**£1,038.84**|**£0.00**|**£1,576.62**|**£5,000.00**|**£406.00**|**£16,090.20**| ||||||||||||||||| |~~to~~
P11.
~~cell~~|||APR|MAY|JUN|JUL|AUG|SEP|OCT|NOV|DEC|JAN|FEB|MAR|YEAR| |
A20.||**EXPENDITURE**|January|February|March|April|May|June|July|August|September|October|November|December|Year| |||Stafng(SCC)|||£493.94|£189.22|||£189.22||||£251.06||£1,123.44| |||Rates|£153.60||||||||||||£153.60| |||Insurance|£321.84|||||||||||£1,697.05|£2,018.89| |||Repairs||||||||||||£2,170.00|£2,170.00| |||Security||||£146.88||||||||£229.16|£376.04| |||Window Cleaning|£44.66|||£44.66|||||£44.66|£44.66|||£178.64| |||Telephone||£67.50|||||||||||£67.50| |||Utilities|£177.00|£177.00|£177.00|£177.00|£177.00|£177.00|£177.00|£177.00|£177.00|£177.00|£123.84|£123.84|£2,017.68| |||FundraisingCosts||||||||£56.46|||||£56.46| |||Miscellaneous|£11.74||£3.79|||||||||£130.00|£145.53| |||**Total**|**£708.84**|**£244.50**|**£674.73**|**£557.76**|**£177.00**|**£177.00**|**£366.22**|**£233.46**|**£221.66**|**£221.66**|**£374.90**|**£4,350.05**|**£8,307.78**| |~~cell~~|||||||||||||||| |
A29.||**CAP EX**|Column1|Column2|Column3|Column4|Column5|Column6|Column7|Column8|Column9|Column10|Column11|Column12|Column13| |||Extension (GDW)|||||||||£17,962.97|£23,286.97||£10,967.15|£52,217.09| |||Architects Fees|||||||||£790.00||||£790.00| |||**Total**|**£0.00**|**£0.00**|**£0.00**|**£0.00**|**£0.00**|**£0.00**|**£0.00**|**£0.00**|**£18,752.97**|**£23,286.97**|**£0.00**|**£10,967.15**|**£53,007.09**| Page 3 of 4 |**_Balance b/fwd_**|| |---|---| |_Bank @ 31/3/22_|_£15,221.60_| |**Fundraising**|| |Cofee Morning|| |Book Sales|| |Race Night|| |BPS Mufti|| |**Donations**|| |Bits & Pieces|| |H&W|| |**Misc**|| |CBS - stationery??|| 8724.67