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