Spreadsheet: 861718d1709570452-pulling-data-from-multiple-excel-sheet-payroll-test
Sheet: RESULTS

DONOTIMPORT | JOURNAL | DATE | REVERSEDATE | [NAME] | REFERENCE_NO | LINE_NO | ACCT_NO | LOCATION_ID | DEPT_ID | DOCUMENT | MEMO | DEBIT | CREDIT | SOURCEENTITY | ALLOCATION_ID | BILLABLE | TAXIMPLICATIONS | TAXSOLUTIONID | TAX_VENDORID | TAX_CUSTOMERID | TAX_CONTACTID | TAX_DETAILID | TAX_AMOUNT | [NAME] | SAGE50_REFERENCE | SAGE50_JOURNAL | GLENTRY_VENDORID | GLENTRY_EMPLOYEEID | GLENTRY_CLASSID | TAX_LINE_NO
 | GJ |  |  |  | 1 |  | 2230 | [NAME] |  |  | Net Wages |  |  |  |  |  |  | United Kingdom - VAT
 | GJ |  |  |  | 1 |  | 2210 | [NAME] |  |  | National Insurance
 | GJ |  |  |  | 1 |  | 2210 | [NAME] |  |  | PAYE
 | GJ |  |  |  | 1 |  | 2230 | [NAME] |  |  | Pension
 | GJ |  |  |  | 1 |  | 6023 | [NAME] |  |  | Employers Pension
 | GJ |  |  |  | 1 |  | 6900 | [NAME] |  |  | Paid Absence
 | GJ |  |  |  | 1 |  | 6001 | [NAME] |  |  | Payments
 | GJ |  |  |  | 1 |  | 6020 | [NAME] |  |  | Employers NIC
 |  |  |  |  | 1 |  | 2240 | [NAME] |  |  | Attachments
 |  |  |  |  | 1 |  | 2250 | [NAME] |  |  | GMB
 |  |  |  |  | 1 |  | 6004 | [NAME] |  |  | Payments
 |  |  |  |  | 1 |  | 6008 | [NAME] |  |  | Payments
 |  |  |  |  | 1 |  | 6015 | [NAME] |  |  | Annual Leave
 |  |  |  |  | 1 |  | 6009 | [NAME] |  |  | Payments
 |  |  |  |  | 1 |  | 2210 | [NAME] |  |  | Student Loan
 |  |  |  |  | 1 |  | 6025 | [NAME] |  |  | Deductions
 |  |  |  |  | 1 |  | 6003 | [NAME] |  |  | Payments
 |  |  |  |  | 1 |  | 6005 | [NAME] |  |  | Payments
 |  |  |  |  | 1 |  | 6002 | [NAME] |  |  | Payments
 |  |  |  |  | 1 |  | 6006 | [NAME] |  |  | Payments
 |  |  |  |  | 1 |  | 6021 | [NAME] |  |  | SSP
 |  |  |  |  | 1 |  | 6022 | [NAME] |  |  | SMP
 |  |  |  |  | 1 |  | 2210 | [NAME] |  |  | Total SMP Recovered
 |  |  |  |  | 1 |  | 6022 | [NAME] |  |  | SMP Recovered
 |  |  |  |  | 1 |  | 6007 | [NAME] |  |  | Payments
 |  |  |  |  | 1 |  | 6010 | [NAME] |  |  | Payments
 |  |  |  |  | 1 |  | 2220 | [NAME] |  |  | Advance Deduction
 |  |  |  |  | 1 |  | 2220 | ACC |  |  | Net Wages
 |  |  |  |  | 1 |  | 2210 | ACC |  |  | National Insurance
 |  |  |  |  | 1 |  | 2210 | ACC |  |  | PAYE
 |  |  |  |  | 1 |  | 2230 | ACC |  |  | Pension
 |  |  |  |  | 1 |  | 6023 | ACC |  |  | Employers Pension
 |  |  |  |  |  |  | 6900 | ACC |  |  | Paid Absence
 |  |  |  |  |  |  | 6001 | ACC |  |  | Payments
 |  |  |  |  |  |  | 6020 | ACC |  |  | Employers NIC
 |  |  |  |  |  |  | 2240 | ACC |  |  | Attachments
 |  |  |  |  |  |  | 2250 | ACC |  |  | GMB
 |  |  |  |  |  |  | 6004 | ACC |  |  | Payments
 |  |  |  |  |  |  | 6008 | ACC |  |  | Payments
 |  |  |  |  |  |  | 6015 | ACC |  |  | Annual Leave
 |  |  |  |  |  |  | 6009 | ACC |  |  | Payments
 |  |  |  |  |  |  | 2210 | ACC |  |  | Student Loan
 |  |  |  |  |  |  | 6025 | ACC |  |  | Deductions
 |  |  |  |  |  |  | 6003 | ACC |  |  | Payments
 |  |  |  |  |  |  | 6005 | ACC |  |  | Payments
 |  |  |  |  |  |  | 6002 | ACC |  |  | Payments
 |  |  |  |  |  |  | 6006 | ACC |  |  | Payments
 |  |  |  |  |  |  | 6021 | ACC |  |  | SSP
 |  |  |  |  |  |  | 6022 | ACC |  |  | SMP
 |  |  |  |  |  |  | 2210 | ACC |  |  | Total SMP Recovered
 |  |  |  |  |  |  | 6022 | ACC |  |  | SMP Recovered
 |  |  |  |  |  |  | 6007 | ACC |  |  | Payments
 |  |  |  |  |  |  | 6010 | ACC |  |  | Payments
 |  |  |  |  |  |  | 2220 | ACC |  |  | Advance Deduction
 |  |  |  |  |  |  | 2220 | CHT |  |  | Net Wages
 |  |  |  |  |  |  | 2210 | CHT |  |  | National Insurance
 |  |  |  |  |  |  | 2210 | CHT |  |  | PAYE
 |  |  |  |  |  |  | 2230 | CHT |  |  | Pension
 |  |  |  |  |  |  | 6005 | CHT |  |  | Payments
 |  |  |  |  |  |  | 6002 | CHT |  |  | Payments
 |  |  |  |  |  |  | 6006 | CHT |  |  | Payments
 |  |  |  |  |  |  | 6021 | CHT |  |  | SSP
 |  |  |  |  |  |  | 6022 | CHT |  |  | SMP
 |  |  |  |  |  |  | 2210 | CHT |  |  | Total SMP Recovered
 |  |  |  |  |  |  | 6022 | CHT |  |  | SMP Recovered
 |  |  |  |  |  |  | 6007 | CHT |  |  | Payments
 |  |  |  |  |  |  | 6010 | CHT |  |  | Payments
 |  |  |  |  |  |  | 2220 | CHT |  |  | Advance Deduction
 |  |  |  |  |  |  | 2220 | FMB |  |  | Net Wages
 |  |  |  |  |  |  | 2210 | FMB |  |  | National Insurance
 |  |  |  |  |  |  | 2210 | FMB |  |  | PAYE
 |  |  |  |  |  |  | 2230 | FMB |  |  | Pension
 |  |  |  |  |  |  | 6023 | FMB |  |  | Employers Pension
 |  |  |  |  |  |  | 6900 | FMB |  |  | Paid Absence
 |  |  |  |  |  |  | 6001 | FMB |  |  | Payments
 |  |  |  |  |  |  | 6020 | FMB |  |  | Employers NIC
 |  |  |  |  |  |  | 2240 | FMB |  |  | Attachments
 |  |  |  |  |  |  | 2250 | FMB |  |  | GMB
 |  |  |  |  |  |  | 6004 | FMB |  |  | Payments
 |  |  |  |  |  |  | 6008 | FMB |  |  | Payments
 |  |  |  |  |  |  | 6015 | FMB |  |  | Annual Leave
 |  |  |  |  |  |  | 6009 | FMB |  |  | Payments
 |  |  |  |  |  |  | 2210 | FMB |  |  | Student Loan
 |  |  |  |  |  |  | 6025 | FMB |  |  | Deductions
 |  |  |  |  |  |  | 6003 | FMB |  |  | Payments
 |  |  |  |  |  |  | 6005 | FMB |  |  | Payments
 |  |  |  |  |  |  | 6002 | FMB |  |  | Payments
 |  |  |  |  |  |  | 6006 | FMB |  |  | Payments
 |  |  |  |  |  |  | 6021 | FMB |  |  | SSP
 |  |  |  |  |  |  | 6022 | FMB |  |  | SMP
 |  |  |  |  |  |  | 2210 | FMB |  |  | Total SMP Recovered
 |  |  |  |  |  |  | 6022 | FMB |  |  | SMP Recovered
 |  |  |  |  |  |  | 6007 | FMB |  |  | Payments
 |  |  |  |  |  |  | 6010 | FMB |  |  | Payments
 |  |  |  |  |  |  | 2220 | FMB |  |  | Advance Deduction