Spreadsheet: 143646d1330508789-excel-2007-index-match-multiple-criteria-formula-management-accounts-2012-olas
Sheet: Raw Data

AccountNumber | AccountName | AccountCostCentre | CostCentreName | AccountDepartment | DepartmentName | PeriodNumber | BalanceTM | BudgetValue | Code | Description | Name | BalanceTMLY
0010 | TANGIBLE FA Motor |  |  |  |  | 0 | 2000 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0010 | TANGIBLE FA Motor |  |  |  |  | 1 | 500000 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0010 | TANGIBLE FA Motor |  |  |  |  | 2 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0010 | TANGIBLE FA Motor |  |  |  |  | 3 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0010 | TANGIBLE FA Motor |  |  |  |  | 4 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0010 | TANGIBLE FA Motor |  |  |  |  | 5 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0010 | TANGIBLE FA Motor |  |  |  |  | 6 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0010 | TANGIBLE FA Motor |  |  |  |  | 7 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0010 | TANGIBLE FA Motor |  |  |  |  | 8 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0010 | TANGIBLE FA Motor |  |  |  |  | 9 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0010 | TANGIBLE FA Motor |  |  |  |  | 10 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0010 | TANGIBLE FA Motor |  |  |  |  | 11 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0010 | TANGIBLE FA Motor |  |  |  |  | 12 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0011 | TANGIBLE FA Leasehold Property |  |  |  |  | 0 | 17133.18 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0011 | TANGIBLE FA Leasehold Property |  |  |  |  | 1 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0011 | TANGIBLE FA Leasehold Property |  |  |  |  | 2 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0011 | TANGIBLE FA Leasehold Property |  |  |  |  | 3 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0011 | TANGIBLE FA Leasehold Property |  |  |  |  | 4 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 1585.9
0011 | TANGIBLE FA Leasehold Property |  |  |  |  | 5 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0011 | TANGIBLE FA Leasehold Property |  |  |  |  | 6 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0011 | TANGIBLE FA Leasehold Property |  |  |  |  | 7 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0011 | TANGIBLE FA Leasehold Property |  |  |  |  | 8 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0011 | TANGIBLE FA Leasehold Property |  |  |  |  | 9 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0011 | TANGIBLE FA Leasehold Property |  |  |  |  | 10 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0011 | TANGIBLE FA Leasehold Property |  |  |  |  | 11 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
0011 | TANGIBLE FA Leasehold Property |  |  |  |  | 12 | 0 | 0 | 12 | FIXED ASSETS - TANGABLES | Balance Sheet | 0
4000 | COS - NETWORKS - MATERIALS | 405 | NETWORKS | 800 | SERVICE A BEAGAN | 0 | 0 | 0 | D701 | SERVICE DEPT SALES | Profit and Loss | 0
4000 | COS - NETWORKS - MATERIALS | 405 | NETWORKS | 800 | SERVICE A BEAGAN | 1 | 2000 | 0 | D701 | SERVICE DEPT SALES | Profit and Loss | 0
4000 | COS - NETWORKS - MATERIALS | 405 | NETWORKS | 800 | SERVICE A BEAGAN | 2 | 0 | 0 | D701 | SERVICE DEPT SALES | Profit and Loss | 0
4000 | COS - NETWORKS - MATERIALS | 405 | NETWORKS | 800 | SERVICE A BEAGAN | 3 | 0 | 0 | D701 | SERVICE DEPT SALES | Profit and Loss | 0
4000 | COS - NETWORKS - MATERIALS | 405 | NETWORKS | 800 | SERVICE A BEAGAN | 4 | 0 | 0 | D701 | SERVICE DEPT SALES | Profit and Loss | 0
4000 | COS - NETWORKS - MATERIALS | 405 | NETWORKS | 800 | SERVICE A BEAGAN | 5 | 0 | 0 | D701 | SERVICE DEPT SALES | Profit and Loss | 0
4000 | COS - NETWORKS - MATERIALS | 405 | NETWORKS | 800 | SERVICE A BEAGAN | 6 | 0 | 0 | D701 | SERVICE DEPT SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR - | 201 | AMC LABOUR | 103 | CAROLINE FLA. | 11 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR - | 201 | AMC LABOUR | 103 | CAROLINE FLA. | 12 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  [NAME] | 201 | AMC LABOUR | 102 | [NAME] | 0 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  [NAME] | 201 | AMC LABOUR | 102 | [NAME] | 1 | 50000 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  [NAME] | 201 | AMC LABOUR | 102 | [NAME] | 2 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  [NAME] | 201 | AMC LABOUR | 102 | [NAME] | 3 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  [NAME] | 201 | AMC LABOUR | 102 | [NAME] | 4 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  [NAME] | 201 | AMC LABOUR | 102 | [NAME] | 5 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  [NAME] | 201 | AMC LABOUR | 102 | [NAME] | 6 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  [NAME] | 201 | AMC LABOUR | 102 | [NAME] | 7 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  [NAME] | 201 | AMC LABOUR | 102 | [NAME] | 8 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  [NAME] | 201 | AMC LABOUR | 102 | [NAME] | 9 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  [NAME] | 201 | AMC LABOUR | 102 | [NAME] | 10 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  [NAME] | 201 | AMC LABOUR | 102 | [NAME] | 11 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  [NAME] | 201 | AMC LABOUR | 102 | [NAME] | 12 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  FINANCE/ADMIN | 201 | AMC LABOUR | 900 | FINANCE/ADMIN | 0 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  FINANCE/ADMIN | 201 | AMC LABOUR | 900 | FINANCE/ADMIN | 1 | 29000 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  FINANCE/ADMIN | 201 | AMC LABOUR | 900 | FINANCE/ADMIN | 2 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  FINANCE/ADMIN | 201 | AMC LABOUR | 900 | FINANCE/ADMIN | 3 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  FINANCE/ADMIN | 201 | AMC LABOUR | 900 | FINANCE/ADMIN | 4 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  FINANCE/ADMIN | 201 | AMC LABOUR | 900 | FINANCE/ADMIN | 5 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  FINANCE/ADMIN | 201 | AMC LABOUR | 900 | FINANCE/ADMIN | 6 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  FINANCE/ADMIN | 201 | AMC LABOUR | 900 | FINANCE/ADMIN | 7 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  FINANCE/ADMIN | 201 | AMC LABOUR | 900 | FINANCE/ADMIN | 8 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  FINANCE/ADMIN | 201 | AMC LABOUR | 900 | FINANCE/ADMIN | 9 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
4000 | SALES  - AMC LABOUR -  FINANCE/ADMIN | 201 | AMC LABOUR | 900 | FINANCE/ADMIN | 10 | 0 | 0 | D501 | DUBLIN SALES | Profit and Loss | 0
5000 | COS MAT STD COST - GEN - PROJECT X | 100 | GEN | 103 | CAROLINE FLA. | 12 | 0 | 0 | D502 | DUBLIN COST OF SALES - STD MATERIALS | Profit and Loss | 0
5000 | COS MAT STD COST - MAINT FEES - | 300 | MAINT FEES | 103 | CAROLINE FLA. | 0 | 0 | 0 | D802 | MAINTENANCE COST OF SALES - STD MATERIALS | Profit and Loss | 0
5000 | COS MAT STD COST - MAINT FEES - | 300 | MAINT FEES | 103 | CAROLINE FLA. | 1 | 0 | 0 | D802 | MAINTENANCE COST OF SALES - STD MATERIALS | Profit and Loss | 0
5000 | COS MAT STD COST - MAINT FEES - | 300 | MAINT FEES | 103 | CAROLINE FLA. | 2 | 3500 | 0 | D802 | MAINTENANCE COST OF SALES - STD MATERIALS | Profit and Loss | 0
5000 | COS MAT STD COST - MAINT FEES - | 300 | MAINT FEES | 103 | CAROLINE FLA. | 3 | 0 | 0 | D802 | MAINTENANCE COST OF SALES - STD MATERIALS | Profit and Loss | 0
7006 | PENSIONS - GEN -  ORAN MAHER | 100 | GEN | 101 | ORAN MAHER | 7 | 0 | 0 | D505 | DUBLIN OPERATING COSTS - SALARIES | Profit and Loss | 805.35
7006 | PENSIONS - GEN -  ORAN MAHER | 100 | GEN | 101 | ORAN MAHER | 8 | 0 | 0 | D505 | DUBLIN OPERATING COSTS - SALARIES | Profit and Loss | 805.35
7006 | PENSIONS - GEN -  ORAN MAHER | 100 | GEN | 101 | ORAN MAHER | 9 | 0 | 0 | D505 | DUBLIN OPERATING COSTS - SALARIES | Profit and Loss | 805.35
8330 | DEPREC PLANT & MACH - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 1 | 0 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 1052
8330 | DEPREC PLANT & MACH - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 2 | 0 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 1052
8330 | DEPREC PLANT & MACH - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 3 | 0 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 1052
8330 | DEPREC PLANT & MACH - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 4 | 0 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 1052
9998 | Suspense Account |  |  |  |  | 0 | 0 | 0 | 07 | OVERHEADS | Profit and Loss | 0
9998 | Suspense Account |  |  |  |  | 1 | -25720.05 | 0 | 07 | OVERHEADS | Profit and Loss | 20.48
9998 | Suspense Account |  |  |  |  | 2 | 27456.23 | 0 | 07 | OVERHEADS | Profit and Loss | -20.49
9998 | Suspense Account |  |  |  |  | 3 | 0 | 0 | 07 | OVERHEADS | Profit and Loss | 223.94
9998 | Suspense Account |  |  |  |  | 4 | 0 | 0 | 07 | OVERHEADS | Profit and Loss | -223.93
9998 | Suspense Account |  |  |  |  | 5 | 0 | 0 | 07 | OVERHEADS | Profit and Loss | 2.2
9998 | Suspense Account |  |  |  |  | 6 | 0 | 0 | 07 | OVERHEADS | Profit and Loss | -2.2
9998 | Suspense Account |  |  |  |  | 7 | 0 | 0 | 07 | OVERHEADS | Profit and Loss | 12.66
9998 | Suspense Account |  |  |  |  | 8 | 0 | 0 | 07 | OVERHEADS | Profit and Loss | -13.76
9998 | Suspense Account |  |  |  |  | 9 | 0 | 0 | 07 | OVERHEADS | Profit and Loss | 1.1
9998 | Suspense Account |  |  |  |  | 10 | 0 | 0 | 07 | OVERHEADS | Profit and Loss | -0.24
9998 | Suspense Account |  |  |  |  | 11 | 0 | 0 | 07 | OVERHEADS | Profit and Loss | 0.24
9998 | Suspense Account |  |  |  |  | 12 | 0 | 0 | 07 | OVERHEADS | Profit and Loss | 0
9999 | MISPOSTING A/C - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 0 | 0 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 0
9999 | MISPOSTING A/C - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 1 | 2100 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 0
9999 | MISPOSTING A/C - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 2 | 0 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 0
9999 | MISPOSTING A/C - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 3 | 0 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 0
9999 | MISPOSTING A/C - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 4 | 0 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 0
9999 | MISPOSTING A/C - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 5 | 0 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 0
9999 | MISPOSTING A/C - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 6 | 0 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 0
9999 | MISPOSTING A/C - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 7 | 0 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 0
9999 | MISPOSTING A/C - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 8 | 0 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 0
9999 | MISPOSTING A/C - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 9 | 0 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 0
9999 | MISPOSTING A/C - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 10 | 0 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 0
9999 | MISPOSTING A/C - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 11 | 0 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 0
9999 | MISPOSTING A/C - GEN -  FINANCE/ADMIN | 100 | GEN | 900 | FINANCE/ADMIN | 12 | 0 | 0 | D507 | DUBLIN OVERHEADS | Profit and Loss | 0
 |  | 1