## 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 2023** |**INCOME**
SCC Grant
Town Council Grant
Takings
Room Hire
Foreign Coinage
Fundraising
Donations
Bruton Town Council Donation
**EXPENDITURE**
Stafng (SCC)
Rates
Insurance
Repairs
Security
Window Cleaning
Telephone
Utilities
Fundraising Costs
Miscellaneous
**CAP EX**
Building Costs
Architects Fees
Income over Expenditure for Year (Overspend)
Balance b/fwd 31/3/22
Transfer from Virgin Savings Account
**Carry F/wd to 23-24 (Surplus)**|**DR**
1,123.44
153.60
2,018.89
2,170.00
376.04
178.64
67.50
2,017.68
56.46
145.53|**CR**
2,000.00
1,592.00
764.92
160.00
162.00
224.90
11,186.38
1,500.00| |---|---|---| ||**8,307.78**
52,217.09
790.00|| ||**6,496.93**|| |ed.|||||||||||||||| |---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---| |.
Ente
r||**WLT ACCOUNTS TO 31 MARCH 23**|||||||||||||| ||||||||||||||||| |~~C4 to~~
P4.g|||APR|MAY|JUN|JUL|AUG|SEP|OCT|NOV|DEC|JAN|FEB|MAR|YEAR| |in||**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