Finances tracker FY2017-2018

Produced by the Treasurer as a monthly statement of BOTLab's financial position. See footnotes in table header for definition of each column. N.B. BOTLab's financial year runs from 1 Dec to 30 Nov of the following year.

Month Bank balance 1) Emergency reserve 2) Dorkbot funds 3) Hackspace small purchases 4) Hackspace remaining reserve 5) #members 6) Membership income 7) Non-recurring expenditure 8)
December 2017 £14,755.45 £5,526 £190.15 £1,000 £8,039.30 £1,351.53 G11 electricity: £123.80
Skillshare expenses: £126.17
Laser cutter lenses: £46.73
Clean up evening supplies: £18.67
January 2018 £15,159.61 £5,526 £190.15 £1,000 £8,443.46 £1,381.53 Scrapstore membership: £44.10
G11 electricity: £119.69
Drill bits: £18.77
Website hosting: £36
Soldering iron: £12.99
New server hosting: £12
February 2018 £15,727.69 £5,526 £190.15 £1,000 £9,011.54 £1,362.03 Dremel bits: £16.93
FLIR E4: £549.99
Storage boxes: £80
Mead skillshare expenses: £25.22
Scales: £24
G11 electricity: £123.80
Large printer paper & ink: £41.69
New server hosting: £14.40
March 2018 £15,502.00 £5,526 £190.15 £1,000 £8,785.85 £1,377.03 G11 electricity: £173.38
New server hosting: £14.40
Bank account service charge (3 months): £18
April 2018 £15,967.93 £5,526 £190.15 £1,000 £9,251.78 £1,377.03 Recycling bins: £29.99
New server overdue: £0.89
BV Open Studios contribution: £50
G11 electricity: £118.61
Security stickers: £156.28
New server hosting: £14.40
May 2018 £16,351.27 £5,526 £190.15 £1,000 £9,635.12 £1,341.03 Insurance: £608.36
G11 electricity: £131.28
AGM pizza: £37.98
Skillshare expenses: £41.92
New server hosting: £14.40
June 2018 £16,920.37 £5,526 £190.15 £1,000 £10,204.22 £1,299.03 Accountants fees: £594
G11 electricity: £127.17
New server hosting: £14.40
Bank account service charge (3 months): £18
July 2018 £16,941.83 £5,526 £190.15 £1,000 £10,225.68 137 £1,364.03 Wood lathe parts: £137.97
New server hosting: £80.18
G11 electricity: £379.18
Soldering supplies and tools: £112.22
August 2018 £16,982.31 £5,526 £190.15 £1,000 £10,266.16 156 £1,397.01 Sander discs: £18.94
Sandpaper holders: £9.16
PAT testing: £20
Sandpaper: £44.91
G11 electricity: £154.88
New server hosting: £23.67
September 2018 £17,522.26 £5,526 £190.15 £1,000 £10,806.11 165 £1,345.01 Website hosting: £36
Scales: £11
SD cards for laser cutter Pi: £18.46
G11 electricity: £160.18
CNC mill rebuild: £529.99
G11 rearrange: £229.88
Metal lathe: £4,260
New server hosting: £14.40
Bank account service charge (3 months): £18
October 2018 £13,563.05 £5,526 £190.15 £1,000 £6,846.90 167 £1,460.01 Needlenose pliers: £11.22
G11 rearrange pizza: £23.96
Glue: £13.71
Paper towel: £3.50
Screws
£23.84
New server hosting: £14.40
November 2018 £14,520.69 £5,526 £190.15 £1,000 £7,804.54 171 £1,413.01 Glue & masking tape: £6.56
New server hosting: £27.60
Scrapstore membership: £35
PPE: £30.38
Companies House filing fee: £13
Extraction duct: £111.39
Drill bits: £14.38
Glass table top: £50
Glue guns: £15.98

Known/potential upcoming expenses:

1)
Reported at the beginning of the month.
2)
Defined as 9 months' worth of rent payments (£581/month).
3)
Money collected from Dorkbot activities (as of beginning of month), held in order to fund further Dorkbot activities. From September 2018 known as “Public Engagement Fund” and held for Dorkbot, Hackkids and Skillshares.
4)
A reserve to support purchases below the threshold for large purchases, currently £300.
5)
Calculated as Bank balance - (Emergency reserve + Dorkbot funds + Hackspace small purchases)
6)
Total who pay by standing order + those who have contacted treasurer to arrange other payment methods
7)
Calculated as all membership income from standing orders.
8)
Excluding rent (£581/month) and G10 electricity (£33/month). The specified date is when the Hackspace made the payment, which may be some time after the original purchase was made in the case of reclaimed expenses.