Spreadsheet: 686550d1594678433-highlighting-overdue-payments-if-date-paid-blank-mb-job-tracker
Sheet: 2020

 | Date | Att. | Ref. | Job description | Time spent inc. travel time | Parts cost | Parts description | Address | Travelled from | [NAME] | Cost (45p/m) N/A to call out | Invoice amount | Date Invoiced | Cash/inv | Date paid | Comments
Ex. | 2019-01-01 00:00:00 | Mick work Joint work [NAME] work |  | Washing machine repair | Call out (30 min) [NAME] (1.5hr) | 110 | Bosch 1800 WM Element | PL3 5TR | TR7 3HG | 1 |  | 145.8 | 2019-01-04 00:00:00 | Invoice | 12.01.2019
 | 2020-06-29 00:00:00 | MB | 1 | Oven repair | 3 | 5 | Element | PL23 1PB | TR7 3HG | 78 |  | 103 | NA | Other | 2020-06-29 00:00:00 | Bank transfer to MB
 |  | MB/RL | 2 | Washing machine repair | 0.5 | 0 | N/A - blockage | Henver Rd   [NAME] | N/A | 0 |  | 45 | NA | Cash | 2020-06-29 00:00:00
 |  | MB/RL | 3 | Fridge-Frz | 0.75 | 0 | N/A - blocked water pipe | Pentire | N/A | 0 |  | 35 | NA | Cash | 2020-06-29 00:00:00
 |  | MB/RL | 4 | Bosch washer | 2 | 5 | Brushes on motor |  | N/A | 0 |  | 115 | 2020-06-30 00:00:00
 |  | MB/RL | 5 | Integrated dishwasher | 1.25 | 0 | E4 error - clear pump | [NAME] | N/A | 0 |  | 70 | NA | Cash | 2020-06-29 00:00:00
 |  | MB/RL | 6 | Oven repair | 1.25 | 10 | Element and bulb | Crantock | N/A | 0 |  | 85
 |  | MB/RL | 7 | Oven repair | 1 | 10 | Element | Fistral | N/A | 0 |  | 85 | NA | Cash | 2020-06-29 00:00:00
 | 2020-06-30 00:00:00 | MB/RL | 8 | Cooker element | 2 | Wrong | Wrong part - reordered | Dunes | N/A | 0 |  | N/A | NA |  |  | 2nd visit
 |  | MB/RL | 9 | Dishwasher F14 error | 2 | 0 | Circulation pump - rtn | Easterleigh | N/A | 0 |  | N/A | NA |  |  | 3rd visit
 |  | MB/RL | 10 | Patched roof | 1.5 | 0 | Plastic |  | N/A | 0 |  | 100 |  | Invoice
 |  | MB/RL | 11 | Bosch washer pump | 1 | 0 | Blockage | Town Road | N/A | 0 |  | 45 | NA | Cash
 |  | MB/RL | 12 | Dishwasher, water damaged boards | 0.5 | 0 | Irrepairable | Quintell Downs | N/A | 0 |  | 25 | NA | Cash
 |  | MB/RL | 13 | Dishwasher | 1.5 | 5 | Flow meter | Hillgrove | N/A | 0 |  | 75 | CheckaTrader | Invoice
 | 2020-07-01 00:00:00 | MB/RL | 14 | Dishwasher no power | 2 | 0 | Irrepairable - purchased new | St Columb Major (Tolcarn) | N/A | 0 |  | N/A | NA |  |  | Diagnosis
 |  | MB/RL | 15 | Bosch diswasher Clicking (fins blocked) | 2.5 | 0 | Pending - diverter |  | N/A | 0 |  | 90 | 2020-07-03 00:00:00 | Invoice |  | Diagnosis
 |  | MB/RL | 16 | Dishwasher | 1.5 | 0 | Irrepairable - purchased new | 11 Beeches, Porth | N/A | 0 |  | 45 | 2020-07-03 00:00:00 | Invoice |  | Diagnosis
 |  | MB | 17 | Cooker hood | 3 | 50 | Fitting | 9 The Edge | TR7 3NP | 3 |  | 175 | 2020-07-01 00:00:00 | Invoice
 | 2020-07-02 00:00:00 | MB/RL | 8 | Cooker element | 1.5 | 30 | Element | Dunes | N/A | 0 |  | 95 | 2020-07-02 00:00:00 | Invoice |  | 3rd visit
 |  | MB/RL | 9 | Circulation pump blockage | 2 | 0 | Blockage cleared | Easterleigh | N/A | 0 |  | 110 | 2020-07-02 00:00:00 | Invoice |  | 4th visit
 |  | MB/RL | 18 | Dishwasher - PCB | 1.5 | 0 | Repair PCB | Padstow | N/A | 0 |  | 75 |  |  |  | Diagnosis
 |  | MB/RL | 19 | Cooker Thermocouple | 0.75 | 6 | Thermocouple | Pentire | N/A | 0 |  | 55 | 2020-07-02 00:00:00 | Invoice
 |  | MB/RL | 13 | Dishwasher not heating | 1 |  | Diagnosis pending | Hillgrove | N/A | 0
 | 2020-07-03 00:00:00 | MB/RL | 20 | Hob regulator 3rd appt | 2 | 0 | Regulator - stock | Redruth | N/A | 0 |  | 150
 |  | MB/RL | 16 | Fit dishwasher | 2 | 269 | Fitted | 11 Beeches, Porth | N/A | 0 |  | 349 | 2020-07-03 00:00:00 | Invoice
 |  | MB/RL | 14 | Fit dishwasher | 1.5 | 359 | Fitted | St Columb Major (Tolcarn) | N/A | 0 |  | 640 | 2020-07-03 00:00:00 | Invoice |  | 2nd visit
 |  | MB | 21 | Defrost freezer | 1.5 | 0 | 0 | 30 [NAME] | TR7 3HG | 2 |  | 30 |  | Cash |  | Cash to MB
 | Week end
 |  |  |  |  | Plus invoicing
 | Date | Att. | Ref. | Job description | Time spent inc. travel time | Parts cost | Parts description | Address | Base | [NAME] | Cost (45p/m) N/A to call out | Invoice amount | Date Invoiced | Cash/inv | Date paid | Comments
 | 06/072020 | MB/RL | 22 | Hoover washer replace pulley and motor brush | 1 |  | Pulley (Stock item) | Flat 3 Quintell | N/A | 0 |  | 75
 |  | MB/RL | 23 | Dishwasher leaking at door | 0.5 |  |  | Probus | N/A | 0 |  | 25 |  | cash | 2020-07-06 00:00:00 | Advised to replace. 20 years old
 |  | MB/RL | 24 | Diagnose washing machine. Possible door interlock | 0.5 |  | Door interlock | Fish Farm | N/A | 0 |  | 25
 |  | MB/RL | 25 | Supply and fit Baumatic dishwasher | 1.5 | 340 | Slimline dishwasher | 223 [NAME] | Robs | 2 |  | 440 | 2020-07-06 00:00:00 | BACS | 2020-07-06 00:00:00
 | 2020-07-07 00:00:00 | MB | 26 | Cut plinth to clear dishwasher | 1 | 30 |  | Higher [NAME] | Robs | 4 |  | 30 | 2020-07-07 00:00:00 | cash to mick | 2020-07-07 00:00:00 | Cash to MB
 |  | MB | 27 | Fit repaired board on Beko washing machine. | 2 |  | [NAME] | Trogave | higher tolcarne | 8 |  | 75 | 2020-07-07 00:00:00 | Bacs to Mick | 2020-07-08 00:00:00 | Bank transfer to MB
 |  | MB | 28 | Bosch washing machine |  |  |  | Not able to diagnose | trogave | 4 |  | 30 | 2020-07-07 00:00:00 | cash to mick | 2020-07-09 00:00:00 | Cash to MB
 | 2020-08-08 00:00:00 |  | 29 | Dryer - new thermo | 0.5 | 3 | Thermo | St Columb Major | robs | 3 |  | 60 |  | cash to [NAME]
 |  |  | 30 | Loose filter | 1 | 0 |  | White Acres | st columb major | 5 |  | 60 |  | cash to [NAME]
 |  |  | 31 | Dishwasher - kink in wastepipe | 1.5 | 0 |  | 29 Droskyn Way | White Acres | 5 |  | 60 | 2020-07-08 00:00:00 |  | 09/072020 | Bank transfer to [NAME]
 |  |  | 32 | Washer leak - pierced drum | 1 | 0 |  | 5 [NAME] | 29 Droskyn Way | 0.05 |  | 45 |  | Cash to [NAME]
 |  |  | 33 | Door switch | 1 | 0 |  | Fish Farm | 5 Droskyn Way | 5
 |  |  | 34 | Dishwasher - instuctions on use | 0.15 | 0 |  | Pentire Mews | Fish Farm | 3 |  | 85 | 2020-07-08 00:00:00
 |  |  | 35 | Dishwasher - moved waste pipe |  |  |  | Porth Manor | PentireMews | 1 |  | 35 | 08/072020
 |  |  | 36 | Dryers x2 |  |  | 1x belt/ 1x tripping | Merrimore | Porth Manor | 4
 |  |  | 37 | Dryer |  |  | Snapped belt | Merrimore
 |  |  | 38 | Washing machine door and dishwasher |  |  |  | [NAME]
 |  |  | 39 | Beko cooker |  |  | Switch | [NAME] |  |  |  | 96
 | 2020-09-09 00:00:00 |  | 40 | Dishwasher |  |  | Soap dispenser - ordered | St Columb Major
 |  |  | 41 | Dryer leaking |  |  | Blocked condenser pump | St Columb Major |  |  |  | 65
 |  |  | 28 | Bosch washer - intermittent door lock fault |  |  | Not able to fix | Tregallion |  |  |  |  |  |  |  | 2nd visit
 |  |  |  | Dryer |  |  | Fit belt | Morgan Porth |  |  |  |  |  |  |  | 2nd visit
 |  |  | 42 | Bosch dishwasher - no power |  |  |  | Morgan Porth
 |  |  | 43 | Bosch washing machine |  |  | Belt came off | Newquay
 |  |  | 44 | Hoover washer/dryer |  |  | Reset thermostat | Mount Wise
 | 2020-10-10 00:00:00 |  | 45 | Oven |  |  | Unable to diagnose
 |  |  | 46 | Dishwasher not heating
 |  |  | 47 | Bosch washing machine and dishwasher |  |  | Door seal Level sensor
 |  |  | 48 | Dishwasher |  |  | Flow sensor | Summer Court
 |  |  | 49 | Range cooker - gas jets | 1.5 | supplied | jets | St Columb Major
 | 2020-10-11 00:00:00 |  | 50 | Getting model numbers for repairs |  |  |  | Holiday park
 | Week end
 | 2020-07-13 00:00:00 |  | 51 | Washer pulley loose | 1.5 |  | Make washer | 39 by tip |  | 1
 |  |  | 52 | Bosch washer | 1 | 12 | Fit door seal | Gannel link |  | 1 |  | 95
 |  |  | 53 | Washing machine | 0.75 | 3.75 | Door handle - replace & test | Pentire |  | 1 |  | 85
 |  |  | 54 | Dishwasher | 1 | 0 | Impeller off | The old rectory |  | 5 |  | 85
 |  |  | 55 | Washer in back Dryer upstairs | 1.5 |  | Motor earthing out. Dryer, no power at socket. Checked over for noise. Fan rubbing against cover. | Town Road |  | 1
 |  |  | 56 | Dryer | 0.5 |  | Bearing | Mount Wise ([NAME]) |  |  |  | 86
 |  |  | 57 | Dishwasher | 1 |  | remove pump for test | Newquay |  | 2
 |  |  | 46 | Dishwasher 2nd visit |  |  | Check thermocouple. Machine not cost effiscient to repair. | Just off Gannel road |  | 2 |  | 20
 |  |  | 51 | Washer pulley loose | 1.75 |  | Fit washer | 39 by tip |  | 85 |  |  |  |  |  | 2nd visit
 | 2020-07-14 00:00:00