Spreadsheet: 831191d1685478768-sumifs-and-subtotal-issue-subtotal-and-sumifs_excel
Sheet: Sheet1

 |  | Sales team | Account Description | Accounting Period | Transaction Date | Description | Other1 Description | Amount in USD | Amount in base currency | Currency Code
 |  | ANAP | T&E-TRAVEL GENERAL | 2023001 | 2022-12-12 00:00:00 | Desc1 | MEALS & ENTERTAINMENT | 686.73 | 937.99 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023001 | 2022-12-19 00:00:00 | [NAME] | MEALS & ENTERTAINMENT | 135.93 | 185.66 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023001 | 2022-12-19 00:00:00 | [NAME] | MEALS & ENTERTAINMENT | 162.51 | 221.97 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023001 | 2022-12-22 00:00:00 | Desc4 | TRAVEL AGENCY FEE | 43.93 | 60 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023001 | 2022-12-22 00:00:00 | Desc5 | AIRFARE | 1744.84 | 2383.22 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023001 | 2022-12-27 00:00:00 | Desc6 | MEALS & ENTERTAINMENT | 65.09 | 88.91 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023001 | 2022-12-31 00:00:00 | [NAME] | HOTEL RELATED CHARGES | -2013.76 | -2736.3 | USD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023001 | 2022-12-31 00:00:00 | Desc8 | MISC | -160.67 | -218.32 | USD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023001 | 2023-01-31 00:00:00 | Desc9 | HOTEL RELATED CHARGES | 2013.76 | 2750.53 | USD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023001 | 2023-01-31 00:00:00 | [NAME] | MISC | 160.67 | 219.45 | USD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-05 00:00:00 | Desc11 | TRAVEL AGENCY FEE | 44.82 | 60 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-05 00:00:00 | Desc12 | TRAVEL AGENCY FEE | 44.82 | 60 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-05 00:00:00 | [NAME] | AIRFARE | 1544.68 | 2067.97 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-09 00:00:00 | Desc14 | T&E | 2319.38 | 3105.1 | USD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-15 00:00:00 | Desc15 | HOTEL RELATED CHARGES | 4467.86 | 5981.42 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-16 00:00:00 | Desc16 | MEALS & ENTERTAINMENT | 25.76 | 34.48 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-16 00:00:00 | Desc17 | TIPS | 20.01 | 26.79 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-18 00:00:00 | [NAME] | GROUND TRANSPORTATION | 35.55 | 47.59 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-18 00:00:00 | Desc19 | GROUND TRANSPORTATION | 174.93 | 234.19 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-18 00:00:00 | [NAME] | MEALS & ENTERTAINMENT | -25.13 | -33.64 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-18 00:00:00 | Desc21 | GROUND TRANSPORTATION | 174.93 | 234.19 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-18 00:00:00 | Desc22 | MEALS & ENTERTAINMENT | 64.74 | 86.67 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-18 00:00:00 | Desc23 | PARKING | 117.11 | 156.78 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-23 00:00:00 | Desc24 | PARKING | -114.28 | -152.99 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-23 00:00:00 | Desc25 | PARKING | 16.52 | 22.12 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-27 00:00:00 | Desc26 | GROUND TRANSPORTATION | 29.18 | 39.06 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-27 00:00:00 | Desc27 | GROUND TRANSPORTATION | 29.98 | 40.13 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-30 00:00:00 | Desc28 | GROUND TRANSPORTATION | 72.75 | 97.39 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-31 00:00:00 | Desc29 | HOTEL RELATED CHARGES | -2013.76 | -2750.53 | USD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-31 00:00:00 | Desc30 | MISC | -160.67 | -219.45 | USD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-01-31 00:00:00 | Desc31 | MEALS & ENTERTAINMENT | 1191.33 | 1594.91 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-02-01 00:00:00 | Desc32 | MEALS & ENTERTAINMENT | 1649.91 | 2208.84 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-02-01 00:00:00 | Desc33 | GROUND TRANSPORTATION | 247.62 | 331.51 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-02-02 00:00:00 | Desc34 | TRAVEL AGENCY FEE | 44.82 | 60 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-02-02 00:00:00 | [NAME] | GROUND TRANSPORTATION | 341.67 | 457.41 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-02-03 00:00:00 | Desc36 | GROUND TRANSPORTATION | 14.13 | 18.92 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-02-03 00:00:00 | Desc37 | MEALS & ENTERTAINMENT | 21.02 | 28.14 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-02-03 00:00:00 | Desc38 | HOTEL RELATED CHARGES | 2759.33 | 3694.1 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-02-03 00:00:00 | Desc39 | TIPS | 19.89 | 26.63 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-02-05 00:00:00 | Desc40 | GROUND TRANSPORTATION | 38.09 | 50.99 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023002 | 2023-02-06 00:00:00 | Desc41 | GIFTS | 75.43 | 100.98 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023003 | 2023-02-22 00:00:00 | Desc42 | GROUND TRANSPORTATION | 28.96 | 39.06 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023003 | 2023-02-22 00:00:00 | [NAME] | MEALS & ENTERTAINMENT | 117.2 | 158.1 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023003 | 2023-02-22 00:00:00 | Desc44 | HOTEL RELATED CHARGES | 1619.5 | 2184.67 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023003 | 2023-02-23 00:00:00 | Desc45 | MEALS & ENTERTAINMENT | 69.25 | 93.42 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023003 | 2023-02-23 00:00:00 | Desc46 | TIPS | 5.03 | 6.78 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023003 | 2023-02-23 00:00:00 | Desc47 | TIPS | 20.1 | 27.11 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023003 | 2023-02-24 00:00:00 | Desc48 | MEALS & ENTERTAINMENT | 34.6 | 46.68 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023003 | 2023-02-24 00:00:00 | Desc49 | GROUND TRANSPORTATION | 185.9 | 250.77 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023003 | 2023-02-24 00:00:00 | Desc50 | MEALS & ENTERTAINMENT | 88.04 | 118.76 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023003 | 2023-02-26 00:00:00 | Desc51 | GROUND TRANSPORTATION | 37.8 | 50.99 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023003 | 2023-02-26 00:00:00 | Desc52 | GROUND TRANSPORTATION | 214.98 | 290 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023003 | 2023-02-27 00:00:00 | Desc53 | PARKING | 19.68 | 26.55 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-02-13 00:00:00 | Desc54 | TRAVEL AGENCY FEE | 43.75 | 60 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-02-13 00:00:00 | Desc55 | AIRFARE | 1218.02 | 1670.25 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-02-17 00:00:00 | Desc56 | TRAVEL AGENCY FEE | 43.75 | 60 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-02-17 00:00:00 | Desc57 | AIRFARE | 0.03 | 0.04 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-02-28 00:00:00 | Desc58 | PARKING | 29.04 | 39.82 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-03-01 00:00:00 | Desc59 | PARKING | 15.49 | 21.24 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-03-01 00:00:00 | Desc60 | MEALS & ENTERTAINMENT | 158.17 | 216.89 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-03-14 00:00:00 | Desc61 | MEALS & ENTERTAINMENT | 376.58 | 516.4 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-03-15 00:00:00 | Desc62 | PARKING | 15.49 | 21.24 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-03-16 00:00:00 | [NAME] | GIFTS | 49.57 | 67.98 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-03-21 00:00:00 | Desc64 | TRAVEL AGENCY FEE | 43.75 | 60 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-03-21 00:00:00 | Desc65 | TRAVEL AGENCY FEE | 54.69 | 75 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-03-21 00:00:00 | [NAME] | AIRFARE | 1588.37 | 2178.1 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-03-21 00:00:00 | Desc67 | AIRFARE | 2695.19 | 3695.86 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-03-31 00:00:00 | Desc68 | PARKING | 30.98 | 42.48 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-03-31 00:00:00 | Desc69 | VISA AND PASSPORT CHARGES | 62.96 | 86.33 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-04-04 00:00:00 | Desc70 | MEALS & ENTERTAINMENT | 77.83 | 106.73 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-04-04 00:00:00 | Desc71 | GROUND TRANSPORTATION | 179.58 | 246.25 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-04-05 00:00:00 | Desc72 | GROUND TRANSPORTATION | 35.47 | 48.64 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-03-30 00:00:00 | [NAME] | MEALS & ENTERTAINMENT | 135.1 | 185.26 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-04-03 00:00:00 | Desc74 | MEALS & ENTERTAINMENT | 115.35 | 158.18 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-04-03 00:00:00 | Desc75 | GROUND TRANSPORTATION | 180.44 | 247.43 | CAD
 |  | ANAP | T&E-TRAVEL GENERAL | 2023004 | 2023-04-02 00:00:00 | [NAME] | HOTEL RELATED CHARGES | 3936.7 | 5398.32 | CAD
 |  | ANAP Total
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023001 | 2023-01-04 00:00:00 | Desc1 | Default Code | 45.5 | 42.91 | EUR
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023002 | 2023-01-05 00:00:00 | [NAME] | MEALS & ENTERTAINMENT | 148.14 | 136.39 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023002 | 2023-01-16 00:00:00 | [NAME] | AIRFARE | 0.06000000000040018 | 0.06000000000040018 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023002 | 2023-01-17 00:00:00 | Desc4 | AIRFARE | 7896.26 | 7270.15 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023002 | 2023-01-19 00:00:00 | Desc5 | MEALS & ENTERTAINMENT | 51.73 | 47.63 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023002 | 2023-01-23 00:00:00 | Desc6 | MEALS & ENTERTAINMENT | 10.62 | 9.78 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023002 | 2023-01-23 00:00:00 | [NAME] | MEALS & ENTERTAINMENT | 28.88 | 26.59 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023002 | 2023-01-29 00:00:00 | Desc8 | MEALS & ENTERTAINMENT | 17.92 | 16.5 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023002 | 2023-01-29 00:00:00 | Desc9 | GROUND TRANSPORTATION | 205.86 | 189.54 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023002 | 2023-01-29 00:00:00 | [NAME] | HOTEL RELATED CHARGES | 2206.71 | 2031.74 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023002 | 2023-01-30 00:00:00 | Desc11 | AIRFARE | 1519.4 | 1398.92 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023002 | 2023-01-30 00:00:00 | Desc12 | AIRFARE | 147.04 | 135.38 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023002 | 2023-02-02 00:00:00 | [NAME] | MEALS & ENTERTAINMENT | 11.2 | 10.32 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023002 | 2023-02-02 00:00:00 | Desc14 | HOTEL RELATED CHARGES | 554.46 | 510.5 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023002 | 2023-02-03 00:00:00 | Desc15 | MEALS & ENTERTAINMENT | 128.68 | 118.48 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023003 | 2023-01-16 00:00:00 | Desc16 | AIRFARE | 4861.75 | 4554.63 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023003 | 2023-01-16 00:00:00 | Desc17 | MEALS & ENTERTAINMENT | 17.43 | 16.33 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023003 | 2023-02-07 00:00:00 | [NAME] | MEALS & ENTERTAINMENT | 20.87 | 19.55 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023003 | 2023-02-08 00:00:00 | Desc19 | MEALS & ENTERTAINMENT | 19.53 | 18.3 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023003 | 2023-02-08 00:00:00 | [NAME] | TIPS | 277.5 | 259.97 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023003 | 2023-02-09 00:00:00 | Desc21 | MEALS & ENTERTAINMENT | 33.86 | 31.72 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023003 | 2023-02-14 00:00:00 | Desc22 | MEALS & ENTERTAINMENT | 14.15 | 13.26 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023003 | 2023-02-17 00:00:00 | Desc23 | MEALS & ENTERTAINMENT | 14.15 | 13.26 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023003 | 2023-02-17 00:00:00 | Desc24 | MEALS & ENTERTAINMENT | 136.15 | 127.55 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023003 | 2023-02-20 00:00:00 | Desc25 | MEALS & ENTERTAINMENT | 25.05 | 23.47 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023003 | 2023-02-21 00:00:00 | Desc26 | MEALS & ENTERTAINMENT | 14.63 | 13.71 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023003 | 2023-02-22 00:00:00 | Desc27 | MEALS & ENTERTAINMENT | 108.92 | 102.04 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023003 | 2023-02-23 00:00:00 | Desc28 | MEALS & ENTERTAINMENT | 17.7 | 16.58 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023003 | 2023-02-24 00:00:00 | Desc29 | MEALS & ENTERTAINMENT | 15.8 | 14.8 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023004 | 2023-02-24 00:00:00 | Desc30 | MEALS & ENTERTAINMENT | 27.43 | 25.37 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023004 | 2023-02-27 00:00:00 | Desc31 | MEALS & ENTERTAINMENT | 15.8 | 14.61 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023004 | 2023-03-07 00:00:00 | Desc32 | TIPS | -244.58 | -226.22 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023004 | 2023-03-10 00:00:00 | Desc33 | TIPS | 99.99 | 92.49 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023004 | 2023-03-15 00:00:00 | Desc34 | MEALS & ENTERTAINMENT | 27.23 | 25.19 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023004 | 2023-03-17 00:00:00 | [NAME] | MEALS & ENTERTAINMENT | 14.7 | 13.6 | AED
 |  | NADYETI | T&E-TRAVEL GENERAL | 2023004 | 2023-03-18 00:00:00 | Desc36 | VISA AND PASSPORT CHARGES | 25 | 23.12 | AED
 |  | NADYETI Total |  |  |  |  |  |  | 17138.22
 |  | PWKB | T&E-TRAVEL GENERAL | 2023001 | 2023-01-10 00:00:00 | Desc1 | TRAVEL AGENCY FEE | 35.85 | 35.85 | SGD
 |  | PWKB | T&E-TRAVEL GENERAL | 2023001 | 2023-01-10 00:00:00 | [NAME] | AIRFARE | 11306.78 | 11306.78 | SGD
 |  | PWKB | T&E-TRAVEL GENERAL | 2023002 | 2023-01-25 00:00:00 | [NAME] | MEALS & ENTERTAINMENT | 156.93 | 156.93 | SGD
 |  | PWKB | T&E-TRAVEL GENERAL | 2023002 | 2023-01-28 00:00:00 | Desc4 | MEALS & ENTERTAINMENT | 71.8 | 71.8 | SGD
 |  | PWKB | T&E-TRAVEL GENERAL | 2023002 | 2023-01-28 00:00:00 | Desc5 | HOTEL RELATED CHARGES | 3874.26 | 3874.26 | SGD
 |  | PWKB | T&E-TRAVEL GENERAL | 2023002 | 2023-01-29 00:00:00 | Desc6 | MEALS & ENTERTAINMENT | 223.05 | 223.05 | SGD
 |  | PWKB | T&E-TRAVEL GENERAL | 2023002 | 2023-01-29 00:00:00 | [NAME] | GROUND TRANSPORTATION | 206.53 | 206.53 | SGD
 |  | PWKB | T&E-TRAVEL GENERAL | 2023002 | 2023-01-29 00:00:00 | Desc8 | LAUNDRY | 34.2 | 34.2 | SGD
 |  | PWKB | T&E-TRAVEL GENERAL | 2023002 | 2023-01-30 00:00:00 | Desc9 | MEALS & ENTERTAINMENT | 17.98 | 17.98 | SGD
 |  | PWKB | T&E-TRAVEL GENERAL | 2023002 | 2023-02-02 00:00:00 | [NAME] | MEALS & ENTERTAINMENT | 180.45 | 180.45 | SGD
 |  | PWKB | T&E-TRAVEL GENERAL | 2023002 | 2023-02-04 00:00:00 | Desc11 | MEALS & ENTERTAINMENT | 113 | 113 | SGD
 |  | PWKB | T&E-TRAVEL GENERAL | 2023002 | 2023-02-04 00:00:00 | Desc12 | GROUND TRANSPORTATION | 175.59 | 175.59 | SGD
 |  | PWKB Total |  |  |  |  |  |  | 16396.42