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