ABOUT THIS SHEET
This sheet generates a summary of your spending based on data in the 'Expenses' and 'Income' tabs.
Make sure you've set a starting balance in the 'Setup' tab before beginning.
NOTE
Please don't edit this sheet. It contains formulas and will update automatically.
Summary
| May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | Total | Average | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Income | £6,928.82 | £16.00 | £0.00 | £5,869.50 | £16.86 | £0.00 | £8,782.51 | £18.14 | £150.00 | £4,145.89 | £18.62 | £20.00 | £25,966.34 | £2,596.63 | |
| Expenses | £3,205.00 | £2,058.76 | £2,895.00 | £5.00 | £1,583.26 | £44.99 | £5.00 | £605.00 | £9,675.58 | £705.00 | £1,505.00 | £2,182.50 | £24,470.09 | £2,039.17 | |
| Net savings [1] | £3,723.82 | -£2,042.76 | -£2,895.00 | £5,864.50 | -£1,566.40 | -£44.99 | £8,777.51 | -£586.86 | -£9,525.58 | £3,440.89 | -£1,486.38 | -£2,162.50 | £1,496.25 | £5,451.68 | |
| Ending balance [2 £35,734.82 | £33,692.06 | £30,797.06 | £36,661.56 | £35,095.16 | £35,050.17 | £43,827.68 | £43,240.82 | £33,715.24 | £37,156.13 | £35,669.75 | £33,507.25 | £36,178.98 | |||
| Income | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | Total | Average | |||
| Queries | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £20.00 | ||||
| Other | £6,928.82 | £16.00 | £0.00 | £5,869.50 | £16.86 | £0.00 | £8,782.51 | £18.14 | £150.00 | £4,145.89 | £18.62 | £0.00 | ||||
| Expenses | ||||||||||||||||
| May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | Total | Average |
| ABS Bursary Kirkbright Steer Expenses |
£2,600.00 s £0.00 £605.00 |
£2,000.00 £0.00 £58.76 |
£1,890.00 £0.00 £1,005.00 |
£0.00 £0.00 £5.00 |
£950.00 £0.00 £633.26 |
£0.00 £0.00 £44.99 |
£0.00 £0.00 £5.00 |
£0.00 £0.00 £605.00 |
£0.00 £9,645.58 £30.00 |
£700.00 £0.00 £5.00 |
£1,500.00 £0.00 £5.00 |
£1,550.00 £0.00 £632.50 |
||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
[1] Total of Income - Expenses
[2] This total includes the 'Starting Balance' from the 'Setup' tab.