Spreadsheet: 770785d1646248994-remove-invoices-that-have-been-credited-out-to-give-a-true-invoice-list-sample-data
Sheet: gSX Service Composite ALL SOCO

Employee | Resource clocked | Account | Type code | Allowed | Time taken | Rate ph | Ext price | Inv No | WIP No | Actual Date costed | RTS code | Serv code | Sale type | Fran | Job card No | SOCo | Reg No | Last Sales date | Reg Date | Description | Model code | SL Type | Type
49 | NIGEL | z2202 | A | 1 | 1 | 115.69 | 115.69 | 2199011 | 22963 | 01/03/2022 | HSER12 | S01 | E | H | 130675 | 02 | REMOVED INFO | /  / | 09/07/2007 | JAZZ 5D 1.4 1.4 SP 0 AT | JAZZ
49 | NIGEL | z2202 | J | 1 | 1 | 54.85 | 50 | 2199011 | 22963 | 01/03/2022 | MOT | S01 | E | H | 130675 | 02 | REMOVED INFO | /  / | 09/07/2007 | JAZZ 5D 1.4 1.4 SP 0 AT | JAZZ
49 | NIGEL | z2202 | A | 0.5 | 0.5 | 119.83 | 59.92 | 2199011 | 22963 | 01/03/2022 | LAB | S01 | E | H | 130675 | 02 | REMOVED INFO | /  / | 09/07/2007 | JAZZ 5D 1.4 1.4 SP 0 AT | JAZZ
49 | 97 | z2202 | L | 3.7 | 0.1 | 11.95 | 44.22 | 2199011 | 22963 | 01/03/2022 | GOIL | S01 | E | H | 0 | 02 | REMOVED INFO | /  / | 09/07/2007 | JAZZ 5D 1.4 1.4 SP 0 AT | JAZZ
49 | 91 | z2202 | Z | 0.01 | 0.1 | 995 | 9.95 | 2199011 | 22963 | 01/03/2022 | ENV | S01 | E | H | 0 | 02 | REMOVED INFO | /  / | 09/07/2007 | JAZZ 5D 1.4 1.4 SP 0 AT | JAZZ
49 | NIGEL | z2202 | A | 0.4 | 0.4 | 110 | 44 | 2199011 | 22963 | 01/03/2022 | LAB | S01 | E | H | 0 | 02 | REMOVED INFO | /  / | 09/07/2007 | JAZZ 5D 1.4 1.4 SP 0 AT | JAZZ
49 | NIGEL | z2202 | A | 1 | 1 | 110 | 38.01 | 2199011 | 22963 | 01/03/2022 | TYRE | S01 | E | H | 0 | 02 | REMOVED INFO | /  / | 09/07/2007 | JAZZ 5D 1.4 1.4 SP 0 AT | JAZZ
49 | NIGEL | z2202 | A | 1 | 1 | 110 | 38.01 | 26941 | 22963 | 01/03/2022 | TYRE | *** | E | H | 0 | 02 | REMOVED INFO | /  / | 09/07/2007 | JAZZ 5D 1.4 1.4 SP 0 AT | JAZZ
49 | NIGEL | z2202 | A | 0.8 | 0.8 | 31.25 | 25 | 2199061 | 22963 | 01/03/2022 | TYRE2 | CON | E | H | 0 | 02 | REMOVED INFO | /  / | 09/07/2007 | JAZZ 5D 1.4 1.4 SP 0 AT | JAZZ
49 | * | z2202 | Z | 13.01 | 0.01 | 1 | 13.01 | 2199061 | 22963 | 01/03/2022 | TYREW2 | CON | E | H | 0 | 02 | REMOVED INFO | /  / | 09/07/2007 | JAZZ 5D 1.4 1.4 SP 0 AT | JAZZ
2 | 97 | [NAME] | U | 8.33 | 8.33 | 1 | 8.33 | 3198629 | 13141 | 02/03/2022 | LOAN | MEC | E | H | 155316 | 03 | REMOVED INFO | 01/03/2020 | 01/03/2020 | CR-V 2.0 i-MMD EX [NAME] eCVT | CR-V
2 | 97 | [NAME] | U | 8.33 | 8.33 | 1 | 8.33 | 34832 | 13141 | 02/03/2022 | LOAN | *** | E | H | 155316 | 03 | REMOVED INFO | 01/03/2020 | 01/03/2020 | CR-V 2.0 i-MMD EX [NAME] eCVT | CR-V
2 | 3 | [NAME] | A | 1 | 1 | 65 | 65 | 3198629 | 13141 | 02/03/2022 | LAB | MEC | E | H | 0 | 03 | REMOVED INFO | 01/03/2020 | 01/03/2020 | CR-V 2.0 i-MMD EX [NAME] eCVT | CR-V
2 | 3 | [NAME] | A | 1 | 1 | 65 | 65 | 34832 | 13141 | 02/03/2022 | LAB | *** | E | H | 0 | 03 | REMOVED INFO | 01/03/2020 | 01/03/2020 | CR-V 2.0 i-MMD EX [NAME] eCVT | CR-V
2 | 3 | [NAME] | A | 1 | 1 | 65 | 65 | 3198630 | 13141 | 02/03/2022 | LAB | MEC | E | H | 0 | 03 | REMOVED INFO | 01/03/2020 | 01/03/2020 | CR-V 2.0 i-MMD EX [NAME] eCVT | CR-V
2 | 3 | [NAME] | A | 1 | 1 | 65 | 65 | 3198629 | 13141 | 02/03/2022 | TRA | MEC | E | H | 0 | 03 | REMOVED INFO | 01/03/2020 | 01/03/2020 | CR-V 2.0 i-MMD EX [NAME] eCVT | CR-V
2 | 3 | [NAME] | A | 1 | 1 | 65 | 65 | 34832 | 13141 | 02/03/2022 | TRA | *** | E | H | 0 | 03 | REMOVED INFO | 01/03/2020 | 01/03/2020 | CR-V 2.0 i-MMD EX [NAME] eCVT | CR-V
2 | 3 | [NAME] | A | 1 | 1 | 65 | 65 | 3198630 | 13141 | 02/03/2022 | TRA | MEC | E | H | 0 | 03 | REMOVED INFO | 01/03/2020 | 01/03/2020 | CR-V 2.0 i-MMD EX [NAME] eCVT | CR-V
12 | 9 | z2204 | A | 0.5 | 0.5 | 110 | 55 | 4229607 | 40897 | 01/03/2022 | LAB | ELE | E | N | 168093 | 04 | REMOVED INFO | /  / | 30/11/2007 | MICRA INITIA | MICRA
12 | 9 | z2204 | A | 0.5 | 0.5 | 110 | 55 | 47083 | 40897 | 01/03/2022 | LAB | *** | E | N | 168093 | 04 | REMOVED INFO | /  / | 30/11/2007 | MICRA INITIA | MICRA
12 | 9 | z2204 | A | 0.5 | 0.5 | 90 | 45 | 4229625 | 40897 | 01/03/2022 | LAB | MEC | E | N | 168093 | 04 | REMOVED INFO | /  / | 30/11/2007 | MICRA INITIA | MICRA
11 | 15 | z2210 | J | 1 | 1 | 39.99 | 39.99 | 10217756 | 51665 | 01/03/2022 | MOT | MOT | E | C | 159887 | 10 | REMOVED INFO | 30/07/2019 | 26/03/2019 | Cit C4 ST P/T 130 Flair | USEDCITCAR
11 | 15 | E1010 | A | 1 | 0.77 | 85.05 | 85.05 | 10217757 | 51665 | 01/03/2022 | 3+I | S01 | E | C | 159887 | 10 | REMOVED INFO | 30/07/2019 | 26/03/2019 | Cit C4 ST P/T 130 Flair | USEDCITCAR
11 | 15 | E1010 | A | 1 | 0.77 | 85.05 | 85.05 | 101376 | 51665 | 01/03/2022 | 3+I | *** | E | C | 159887 | 10 | REMOVED INFO | 30/07/2019 | 26/03/2019 | Cit C4 ST P/T 130 Flair | USEDCITCAR
11 | 15 | E1010 | A | 1 | 0.77 | 65.49 | 65.49 | 10217758 | 51665 | 01/03/2022 | 3+I | S01 | E | C | 159887 | 10 | REMOVED INFO | 30/07/2019 | 26/03/2019 | Cit C4 ST P/T 130 Flair | USEDCITCAR
11 | 998 | E1010 | L | 4 | 4 | 4.88 | 19.52 | 10217757 | 51665 | 01/03/2022 | INEOOIL | S01 | E | C | 0 | 10 | REMOVED INFO | 30/07/2019 | 26/03/2019 | Cit C4 ST P/T 130 Flair | USEDCITCAR
11 | 998 | E1010 | L | 4 | 4 | 4.88 | 19.52 | 101376 | 51665 | 01/03/2022 | INEOOIL | *** | E | C | 0 | 10 | REMOVED INFO | 30/07/2019 | 26/03/2019 | Cit C4 ST P/T 130 Flair | USEDCITCAR
11 | 998 | E1010 | L | 4 | 4 | 4.88 | 19.52 | 10217758 | 51665 | 01/03/2022 | INEOOIL | S01 | E | C | 0 | 10 | REMOVED INFO | 30/07/2019 | 26/03/2019 | Cit C4 ST P/T 130 Flair | USEDCITCAR