====== 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 ((Reported at the beginning of the month, with the standing orders for BV Studios rent and electricity subtracted.)) ^ Emergency reserve ((Defined as 9 months' worth of rent payments (£581/month).)) ^ Dorkbot funds ((Money collected from Dorkbot activities (as of beginning of month), held in order to fund further Dorkbot activities.)) ^ Hackspace small purchases ((A reserve to support purchases below the threshold for large purchases, currently £300.)) ^ Hackspace remaining reserve ((Calculated as Bank balance - (Emergency reserve + Dorkbot funds + Hackspace small purchases) )) ^ #members ^ Membership income (approx) ((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.)) ^ Non-recurring expenditure ((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.)) ^ | 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:** * G11 rent arrears: £648 * G11 additional rent: £54/month * G10 business rates: ~£70/month