Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
governance:finances:2019_20 [2023/01/19 01:38] – created felixgovernance:finances:2019_20 [2024/11/19 21:42] (current) – external edit 127.0.0.1
Line 1: Line 1:
-====== Finances tracker FY2020-2021 ====== +====== Finances tracker FY2019-2020 ====== 
-Produced by the Treasurer as a monthly statement of Bristol Open Technology Lab C.I.C.'s financial position.\\ +Produced by the Treasurer as a monthly statement of BOTLab's financial position. See footnotes in table header for definition of each columnN.BBOTLab's financial year runs from 1 Dec to 30 Nov of the following year.
-BOTLab C.I.C.'s financial year runs from 1 Dec to 30 Nov of the following year.+
  
-^ Month ^ BOTLab C.I.Cbank balance ((Reported on 1st of each month)) ^ Funds held ((Reported on 1st of each month)) ^ BOTLab C.I.C. remaining reserve ((Reported on 1st of each month)) ^ Number of members ((Reported on 1st of each month)) ^ Income ((Recorded on this month's bank statement)) ^ Expenditure ((Recorded on this month'bank statement))^ Net income (total income - total outgoings)^ +^ Month ^ BOTLab C.I.C bank balance ((Reported on 1st of each month.)) ^ Bristol Hackspace emergency reserve ((Defined as 9 months' worth of rent payments (£581/month).)) ^ Public engagement fund ((Reported at beginning of month. Held for all public engagement activities.)) ^ Bristol Hackspace small purchases fund ((A reserve to support purchases below the threshold for large purchases, currently £300.)) ^ BOTLab C.I.C. remaining reserve ((Calculated as Bank balance - (Emergency reserve + Public engagement fund + Hackspace small purchases) )) ^ Number of members ((At the beginning of the month.)) ^ Membership income ^ Other income ^ Non-recurring expenditure ((Excluding rent (£581/month), G10 electricity (£33/month), bank account service fees (£18 every three monthsand website hosting (£36 every three months).)) ^ 
-| December 2020  |  £38,264.71 Public engagement fund: £288.39 \\ Hackspace emergency fund: £5,526 \\ Hackspace small purchases: £1,000 \\ Move budget: £5,000 \\ COVID shortfall fund: £5,000 \\ **Total: £16,814.39** |  **£21,450.32** |  179 Membership income: £1,542.62 \\ Laser cutter usage: £15 \\ **Total£1,557.62** | Rent: £581 \\ Electricity£33 \\ Web hosting£36 \\ Bank account service charge: £18 \\ **Total: £668** |  **£889.62** +| December 2019  |  £18,884.46  £5,526 |  £288.39 |  £1,000 |  £12,070.07 |  222  £1,941 | Laser cutter usage: £30 | Consumables: £15.17 \\ Art of Electronics X Chapters (micro proposal)£39.59 \\ Spot welder (small proposal)£143.54 \\ G11 electricity£164.51    
-| January 2021   |  £39,122.53 Public engagement fund: £288.39 \\ Hackspace emergency fund: £5,526 \\ Hackspace small purchases: £1,000 \\ Move budget: £5,000 \\ COVID shortfall fund: £5,000 \\ **Total: £16,814.39** |  **£22,308.14** |  180 Membership income: £1453.62 \\ Laser cutter usage: £10 \\ **Total£1463.62** | Rent£584 \\ Electricity£33 \\ Metal lathe tooling (small purchase proposal): £259.72 \\ Building supplies (move budget): £179.61 \\ Food for volunteers (general fund)£4.28 \\ Fuel (move budget): £88.54 \\ Builder labour/consultancy (move budget): £350 \\ **Total: £1,496.15** |  **-£32.53** | +| January 2020   |  £19,860.65  £5,526 |  £288.39 |  £1,000 |  £13,046.26 |  222  £1,981.11 | Laser cutter usage: £20 | Consumables: £4 \\ Christmas hebocon supplies£71.03 \\ Bike tools (micro proposal)£41.99 \\ Companies House filing fee£13 \\ Socket set (micro proposal): £37.96 \\ CNC parts (various proposals): £231.50 \\ G11 electricity£92.76 \\ PCBs for access control project (micro proposal): £27.35 \\ Raspberry Pi for CUPS server (micro proposal): £50.67 |   
-| February 2021  |  £39,097.80 Public engagement fund: £288.39 \\ Hackspace emergency fund: £5,526 \\ Hackspace small purchases: £1,000 \\ Move budget: £4381.85 \\ COVID shortfall fund: £5,000 \\ **Total: £16,196.24** |  **£22,901.56** |  177 Membership income: £1,341.62 \\ Laser cutter usage: £10 \\ **Total£1,351.62** | Rent: £581 \\ Electricity: £33 \\ Consumables: £2 \\ Building supplies (move budget): £840.54 \\ Food for volunteers (general fund): £87.83 \\ Fuel (move budget)£20 \\ SDS drill (micro proposal)£49.99 \\ **Total: £1,614.36** |  **-£262.74** +| February 2020  |  £20,677.50  £5,526 |  £288.39 |  £1,000 |  £13,863.11‬ |  232  £1,894.11 | Laser cutter usage: £20 | G11 electricity£130.74 \\ Consumables: £79.27 \\ PCBs for access control project (micro proposal): £3.51 \\ Children's Scrapstore membership£37 \\ Food for cleanup weekend£111.52    
-| March 2021     |  £38,702.26 Public engagement fund: £288.39 \\ Hackspace emergency fund: £5,526 \\ Hackspace small purchases: £1,000 \\ Move budget: £3,425.16 \\ COVID shortfall fund: £5,000 \\ **Total: £15,239.55** |  **£23,462.71** |  177 Membership income: £1,524.62 \\ Laser cutter usage: £10 \\ Donations: £50 \\ **Total: £1,584.62** Rent£1,303 \\ Electricity: £33 \\ Bank account service charge: £18 \\ Electrics (move budget): £344.42 \\ Building supplies (move budget): £497.17 \\ Wifi installation (move budget): £425.34 \\ Food for volunteers (general fund): £16.78 \\ Door access control (move budget): £589.82 \\ Door access cards: £50.40 \\ Moving supplies (move budget): £24 \\ Carpenter (move budget): £850 \\ **Total: £4,151.53** |  **-£2,566.91** +| March 2020     |  £21,615.57  £5,526 |  £288.39 |  £1,000 |  £14,801.18‬ |  241  £2,026.11 | Laser cutter usage: £20 G11 electricity£130.74    
-| April 2021     |  £35,773.47 Public engagement fund: £288.39 \\ Hackspace emergency fund: £5,526 \\ Hackspace small purchases: £1,000 \\ Move budget: £152.23 \\ COVID shortfall fund: £5,000 \\ **Total: £11,966.62** |  **£23,806.85** |  178 Membership income: £1,335.62 \\ Access card payments: £125 \\ Laser cutter usage: £35 \\ Donations: £45.89 \\ Refunds: £151.60 \\ **Total: £1,698.51** Rent£1,655.08 \\ Electricity: £33 \\ Building supplies (move budget): £218.99 \\ Moving supplies (move budget): £10.80 \\ Van hire (move budget): £347.60 \\ Fuel (move budget): £30 \\ Food for volunteers (general fund): £72.74 \\ Bike stand (micro proposal): £20 \\ Stationary (micro proposal): £34.62 \\ Consumables: £8 \\ Door access cards: £182.40 \\ **Total: £2,613.23** |  **-£914.72** +| April 2020     |  £22,898.94  £5,526 |  £288.39 |  £1,000 |  £16,084.55 |  241  £1,760.11 | Laser cutter usage: £20 G11 electricity£122.16 |  
-| May 2021       |  £34,853.35 Public engagement fund: £288.39 \\ Hackspace emergency fund: £14,400 \\ Hackspace small purchases: £1,000 \\ Move budget: £288.17 \\ COVID shortfall fund: £5,000 \\ **Total: £20,976.56** |  **£13,876.79** |  173 Membership income: £1,474.62 \\ Laser cutter usage: £10 \\ Access card payments: £165 \\ **Total: £1,649.62** Rent£1545 \\ Lab and kitchen supplies (move budget): £83.19 \\ Building supplies (move budget): £40.27 \\ Laser extraction tubing (move budget): £104.80 \\ Consumables: £34.31 \\ Drill and bits (micro proposal): £43.20 \\ **Total: £1,850.77** |  **-£201.15** +| May 2020       |  £23,942.89  £5,526 |  £288.39 |  £1,000 |  £17,128.50 |  243  £1,598.11 | Laser cutter usage: £20 G11 electricity£130.74 
-| June 2021      |  £34,702.92 Public engagement fund: £288.39\\ Hackspace emergency fund: £14,400 \\ Hackspace small purchases: £1,000 \\ Move budget: £40.02 \\ COVID shortfall fund: £5,000 \\ **Total: £20,728.41** |  **£13,974.51** |  176 Membership income: £1,738.62 \\ Laser cutter usage: £10 \\ Access card payments: £120 \\ **Total: £1,858.62** Rent£1600 \\ Accountants: £624 \\ Air compressor (small purchase proposal): £150 \\ Bank account service charge: £18 \\ Consumables: £19.14 \\ Mitre saw (small purchase proposal)£248.48 \\ Distance measurer (micro purchase proposal): £26.48 \\ 110V transformer (small purchase proposal): £69.99 \\ **Total: £2,756.09** |  **-£897.47** +| June 2020      |  £24,816.26  £5,526 |  £288.39 |  £1,000 |  £18,001.87 |  243  £1,718.11 | Laser cutter usage: £20 G11 electricity£126.54 \\ 3D printer parts£48.70 
-| July 2021      |  £33,805.45 Public engagement fund: £288.39 \\ Hackspace emergency fund: £14,400 \\ Hackspace small purchases: £1,000 \\ Move budget: £40.02 \\ COVID shortfall fund: £5,000 \\ **Total: £20,728.41** |  **£13,077.04** |  191 Membership income: £1,788.62 \\ Laser cutter usage: £10 \\ Access card payments£45 \\ Donations tin: £6.56 \\ **Total: £1,850.18** Rent£1,600 \\ Pipe bender (micro purchase proposal): £14.39 \\ PEI stickers for 3D printer (micro purchase proposal): £40.67 \\ Children's Scrapstore membership£17.50 \\ Angle grinder (micro purchase proposal): £49.99 \\ Power cables (micro purchase proposal): £24 \\ **Total: £1,746.55** |  **£103.63** +| July 2020      |  £25,747.13  £5,526 |  £288.39 |  £1,000 |  £18,932.74 |  244  £1,597.12 | Laser cutter usage: £20 \\ G10 electricity refund£125 Consumables£75.78 \\ Lathe cross slide nut (small purchase proposal): £90 \\ G11 electricity£130.74 \\ 110V transformer (small purchase proposal): £144.64 \\  | 
-| August 2021    |  £33,909.08 Public engagement fund: £288.39 \\ Hackspace emergency fund: £14,400 \\ Hackspace small purchases: £1,000 \\ Move budget: £40.02 \\ Move budget: £40.02 \\ COVID shortfall fund: £5,000 \\ **Total: £20,768.43** |  **£13,140.65** |  197 Membership income: £1,928.62 \\ Laser cutter usage: £10 \\ Access card payments: £65 \\ **Total: £2,003.62** | Rent: £1,600 \\ Building supplies (move budget): £44.04 \\ Label tape (consumables): £10.51 \\ Sublimation ink (consumables)£36.99 \\ Hot air station (small purchase proposal): £76.74 \\ Try square (micro purchase proposal)£7.98 \\ Drill bits (consumables): £3.49 \\ Layout tools (micro purchase proposal): £16.38 \\ Internet: £37.50 \\ Insurance: £628.01 \\ **Total£2,461.64** |  **-£458.02** +| August 2020    |  £26,362.09  £5,526 |  £288.39 |  £1,000 |  £19,547.70 |  245  £1,497.62 Laser cutter usage: £417.04 \\ Covid Grant: £10,000 \\ Donations£50 | G11 electricity: £126.54 \\ Hand sanders (small proposal): £256.83 \\ Accountants fees£624 \\ Insurance: £539.20 \\ Consumables£58.13 
-| September 2021 |  £33,488.61 Public engagement fund: £288.39 \\ Hackspace emergency fund: £14,400 \\ Hackspace small purchases: £1,000 \\ COVID shortfall fund: £5,000 \\ **Total: £20,688.39** |  **£12,800.22** |  203 Membership income: £1,867.62 \\ Laser cutter usage: £10 \\ Access card payments: £35 \\ Donations£0.01 \\ **Total£1,912.63** | Rent: £1,600 \\ Electricity£33.35 \\ Bank account service charge: £18 \\ Airline coupling (micro purchase proposal): £11.32 \\ Tool sharpening system (medium purchase proposal): £574.95\\ Move budget top up (micro purchase proposal): £2.02 \\ **Total£2,239.64** |  **-£327.01** +| September 2020 |  £36,108.05  £5,526 |  £288.39 |  £1,000 |  £29,293.36 |  179  £1,607.62 Laser cutter usage: £365.41 | G11 electricity£101.20 \\ Large printer print head (micro proposal)£46 \\ Chisels (small proposal)£107.99 \\ Duck oil (micro proposal): £10.55 \\ Various tools for G10 (small proposal): £233.56 \\ Step drill bits (micro proposal): £42.98 \\ New web hosting£13.20 \\ Consumables: £25.64 \\ Palm router & bits (small proposal): £88.28 
-| October 2021   |  £33,163.57 Public engagement fund: £288.39 \\ Hackspace emergency fund: £14,400\\ Hackspace small purchases: £1,000 \\ COVID shortfall fund: £5,000 \\ **Total: £20,688.39** |  **£12,475.18** |  211 Membership income: £1,961.51 \\ Laser cutter usage: £12.50 \\ Access card payments£60 \\ **Total: £2,034.01** | Rent: £1,600 \\ Electricity£60.52 \\ Web hosting: £8.40 \\ CNC compressed air line£122.63 \\ Internet£75 \\ Unknown: £14.22 \\ Unknown£29.64 \\ Bandsaw blade (consumables): £18 \\ Project boxes (consumables): £198 \\ RFID access system: £250.38 \\ **Total: £2,376.79** |  **-£342.78** +| October 2020   |  £36,779.38  £5,526 |  £288.39 |  £1,000 |  £29,964.99 |  180  £1,557.60 | Laser cutter usage: £98.06 | G11 electricity£101.20 \\ PCB CNC supplies (small proposal)£166.99 \\ New web hosting: £ 1.20 \\ Bike truing kit(micro proposal)£38.04 \\ Consumables£5.96 \\ Wood for crosscut sled (micro proposal): £27.86 
-| November 2021  |  £32,905.79 Public engagement fund: £288.39 \\ Hackspace emergency fund: £14,400 \\ Hackspace small purchases: £1,000 \\ COVID shortfall fund: £5,000 \\ **Total: £20,688.39** |  **£12,217.40** |  216 Membership income: £2,092.51 \\ Laser cutter usage: £10 \\ Access card payments: £50 \\ **Total: £2,152.51** Rent: £1,600 \\ Internet: £37.50 \\ Electricity: £58.56 \\ Web hosting: £14.40 \\ Key safe (micro purchase proposal): £20 \\ Woodshop dust extraction (small purchase proposals): £168.85 \\ Companies House late filing fee: £375 \\ Food for volunteers (general fund)£38.39 \\ Companies House confirmation statement fee: £13 \\ Maintenance weekend (unknown budget(s)): £31.01 \\ **Total: £2,356.71** |  **-£204.20** |+| November 2020  |  £37,480.11  £5,526 |  £288.39 |  £1,000 |  £30,665.72 |  179  £1,522.62 | Laser cutter usage: £10 | Companies House accounts filing fee: £15 \\ G11 electricity£126.02 \\ Companies House confirmation statement fee: £13  |
  • governance/finances/2019_20.1674092296
  • Last modified: 5 months ago
  • (external edit)