Finances tracker FY2016-2017

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 Membership income (approx) 6) Non-recurring expenditure 7)
December 2016 £12,112.85 £5,526 £190.15 £1,000 £5,396.70 112 £1,177.02 Replacement PSU for laser cutter: £400
Companies House fee: £13
Bank account service charge (3 months): £18
January 2017 £12,247.37 £5,526 £190.15 £1,000 £5,531.22 116 £1,202.02 Project storage boxes: £90
Pressure cooker: £42.49
Consumables and extension lead: £31.69
G11 electricity: £261.32
CNC router dust booth materials: £389.57
February 2017 £12,065.32 £5,526 £190.15 £1,000 £5,349.17 117 £1,202.02 G11 electricity: £127.03
CNC router dust booth materials: £184.93
March 2017 £12,328.88 £5,526 £190.15 £1,000 £5,612.73 116 £1,216.02 CNC router dust booth materials: £30.03
Bandsaw blades: £32.16
Accounts preparation: £570
Open Studios fee: £5
G11 electricity: £123.01
Bank account service charge (3 months): £18
April 2017 £12,240.74 £5,526 £190.15 £1,000 £5,524.59 £1,213.02 G11 electricity: £108.53
Drill chuck: £54.62
AGM stationery and kitchenware: £9.77
More RFID cards: £23.76
AGM pizza: £36.98
May 2017 £12,652.41 £5,526 £190.15 £1,000 £5,936.26 £1,248.03 Insurance renewal: £1,320
G11 electricity: £118.73
June 2017 £12,069.98 £5,526 £190.15 £1,000 £5,353.83 £1,226.03 G11 electricity: £91.77
Bank account service charge (3 months): £18
July 2017 £12,306.23 £5,526 £190.15 £1,000 £5,590.08 £1,226.03 Drill bits: £10.98
Cleaning night pizza: £ 36.98
Cleaning supplies: £1.78
Fluorescent tubes for G11: £ 56
G11 electricity: £123.80
4-way extensions for G11: £94.75
August 2017 £13,010.89 £5,526 £190.15 £1,000 £6,294.74 £1,296.53 G11 electricity: £119.69
September 2017 £13,603.73 £5,526 £190.15 £1,000 £6,887.58 £1,341.53 HSS drill bits: £8.30
Membership refund: £10
G11 electricity: £123.80
Dust extraction purchase: £1,068,01
Bank account service charge (3 months): £18
October 2017 £12,799.14 £5,526 £190.15 £1,000 £6,082.99 £1,341.53 Website hosting: £36
Laser cutter lenses: £65
G11 electricity: £123.80
November 2017 £13,641.72 £5,526 £190.15 £1,000 £6,925.57 £1,381.52 G11 electricity: £119.69
Children's Scrapstore membership: £44.10

Known/potential upcoming expenses:

1)
Reported at the beginning of the month, with the standing orders for BV Studios rent and electricity subtracted.
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.
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)
Calculated by identifying all subscribing members and summing their initial subscription amounts; if subscriptions are adjusted over the course of a year then this may not be accurate. Represents all income over the course of the corresponding month, i.e. not available until month end. Due to separation of membership secretary and treasurer roles, from April calculated as all membership income from standing orders.
7)
Excluding rent and electricity. 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.