Spreadsheet: 877706d1724519825-help-please-mio-audit-pnc
Sheet: PNC

Role | Date | Company | Name | Vendor | Vendor’s name | Vendor’s inv. no. | Purchase orders | Contract no. | Invoice date | Invoice series | Serial no. | Due date | Accounting date | Payment date | Voucher series | Voucher no. | Credit | Status | Currency | Amount | TAX amount | Net amount | Default currency amount | TAX amount (def. cur.) | Exchange rate | Group1 | Group2 | Group3 | Group4 | Group5 | Group6
 | 08/21/2024 |  |  | 03310 | DEPENDABLE BREAK ROOM SOLUTIONS INC | MI18943 | 20-8300-500-173 |  | 2024-06-15 00:00:00 |  | 9145 | 2024-08-14 00:00:00 | 2024-08-21 00:00:00 |  |  | 241348 | No | Recorded | USD | 87.87 | 0 | 87.87 | 87.87 | 0 | 1
 | 08/21/2024 |  |  | 03310 | DEPENDABLE BREAK ROOM SOLUTIONS INC | MI18153 | 20-8300-500-173 |  | 2024-06-01 00:00:00 |  | 9146 | 2024-07-31 00:00:00 | 2024-08-21 00:00:00 |  |  | 241347 | No | Recorded | USD | 108.74 | 0 | 108.74 | 108.74 | 0 | 1
 | 08/21/2024 |  |  | 03310 | DEPENDABLE BREAK ROOM SOLUTIONS INC | MI21459 | 20.8300.451.173 |  | 2024-08-10 00:00:00 |  | 8688 | 2024-10-09 00:00:00 | 2024-08-15 00:00:00 |  |  | 241349 | No | Recorded | USD | 514.81 | 0 | 514.81 | 514.81 | 0 | 1 | 0.00
 | 08/23/2024 |  |  | 01398 | INTERMOUNTAIN GOLF CARS, INC. | 339581 | 20-8300-840-177 |  | 2024-08-22 00:00:00 |  | 9312 | 2024-08-22 00:00:00 | 2024-08-23 00:00:00 |  |  |  | No | Active | USD | 1498.15 | 0 | 1498.15 | 1498.15 | 0 | 1 | 0.00
 | 08/23/2024 |  |  | 01398 | INTERMOUNTAIN GOLF CARS, INC. | 333229 | 20-8300-840-177 |  | 2024-06-05 00:00:00 |  | 9315 | 2024-06-05 00:00:00 | 2024-08-23 00:00:00 |  |  |  | No | Active | USD | 603.69 | 0 | 603.69 | 603.69 | 0 | 1 | 0.00
 | 08/21/2024 |  |  | 02102 | ITW GSE INC | 113724 | 20-8300-459-109 |  | 2024-08-08 00:00:00 |  | 8955 | 2024-09-07 00:00:00 | 2024-08-16 00:00:00 |  |  | 241354 | No | Recorded | USD | 3209.4 | 0 | 3209.4 | 3209.4 | 0 | 1 | 0.00
 | 08/21/2024 |  |  | 02102 | ITW GSE INC | 112181 | 20-8300-459-188 |  | 2024-05-30 00:00:00 |  | 8923 | 2024-06-29 00:00:00 | 2024-08-13 00:00:00 |  |  | 241353 | No | Recorded | USD | 5017.89 | 0 | 5017.89 | 5017.89 | 0 | 1 | 0.00
 | 08/23/2024 |  |  | 00120 | JBT AEROTECH - OGDEN | 2413427 | 20-2010-000-175 |  | 2024-08-21 00:00:00 |  | 9305 | 2024-09-20 00:00:00 | 2024-08-23 00:00:00 |  |  |  | No | Active | USD | 2308.5 | 0 | 2308.5 | 2308.5 | 0 | 1 | 0.00
 | 08/23/2024 |  |  | 00120 | JBT AEROTECH - OGDEN | 2413464 | 20-8300-459-185 |  | 2024-08-22 00:00:00 |  | 9307 | 2024-09-21 00:00:00 | 2024-08-23 00:00:00 |  |  |  | No | Active | USD | 257.68 | 0 | 257.68 | 257.68 | 0 | 1 | 0.00
 | 08/21/2024 |  |  | 01433 | [NAME] CONTROLS | 24035649 | 20-8300-500-173 |  | 2024-03-22 00:00:00 |  | 8952 | 2024-05-21 00:00:00 | 2024-08-16 00:00:00 |  |  | 241352 | No | Recorded | USD | 606 | 0 | 606 | 606 | 0 | 1 | 0.00
 | 08/23/2024 |  |  | 02261 | MAVICH LLC | [PHONE] | 20-8300-459-174 |  | 2024-08-13 00:00:00 |  | 9306 | 2024-08-13 00:00:00 | 2024-08-23 00:00:00 |  |  | 241467 | Yes | Recorded | USD | -224.79 | 0 | -224.79 | -224.79 | 0 | 1 | 0.00
 | 08/23/2024 |  |  | 02261 | MAVICH LLC | [PHONE] | 20-8300-459-174 |  | 2024-08-13 00:00:00 |  | 9308 | 2024-08-13 00:00:00 | 2024-08-23 00:00:00 |  |  | 241466 | Yes | Recorded | USD | -187.91 | 0 | -187.91 | -187.91 | 0 | 1 | 0.00
 | 08/23/2024 |  |  | 02261 | MAVICH LLC | [PHONE] | 20-8300-459-174 |  | 2024-08-13 00:00:00 |  | 9309 | 2024-08-13 00:00:00 | 2024-08-23 00:00:00 |  |  | 241465 | Yes | Recorded | USD | -68.14 | 0 | -68.14 | -68.14 | 0 | 1 | 0.00
 | 08/23/2024 |  |  | 02261 | MAVICH LLC | [PHONE] | 20-8300-459-174 |  | 2024-08-13 00:00:00 |  | 9314 | 2024-10-12 00:00:00 | 2024-08-23 00:00:00 |  |  | 241468 | No | Recorded | USD | 35.49 | 0 | 35.49 | 35.49 | 0 | 1 | 0.00
 | 08/23/2024 |  |  | 02261 | MAVICH LLC | [PHONE] | 20-8300-459-174 |  | 2024-08-01 00:00:00 |  | 9022 | 2024-08-01 00:00:00 | 2024-08-19 00:00:00 |  |  | 241464 | Yes | Recorded | USD | -21.27 | 0 | -21.27 | -21.27 | 0 | 1 | 0.00
 | 08/23/2024 |  |  | 00732 | [NAME] SUPPLY COMPANY | 31987514 | 20-8300-459-109 |  | 2024-08-19 00:00:00 |  | 9313 | 2024-09-18 00:00:00 | 2024-08-23 00:00:00 |  |  |  | No | Active | USD | 377.87 | 0 | 377.87 | 377.87 | 0 | 1 | 0.00
 | 08/23/2024 |  |  | 03223 | PREFERRED MECHANICAL GROUP LLC | 12468638 | 20-8300-459-174 |  | 2024-08-15 00:00:00 |  | 9311 | 2024-10-14 00:00:00 | 2024-08-23 00:00:00 |  |  |  | No | Active | USD | 2372.49 | 0 | 2372.49 | 2372.49 | 0 | 1 | 0.00
 | 08/20/2024 |  |  | 00304 | UNITED RENTALS (NORTH AMERICA) INC | [PHONE] | 20-8300-500-173 |  | 2024-08-11 00:00:00 |  | 8926 | 2024-09-10 00:00:00 | 2024-08-14 00:00:00 |  |  | 241351 | No | Active | USD | 988.95 | 60.76 | 928.19 | 988.95 | 60.76 | 1 | 60.76
 | 08/19/2024 |  |  | 00304 | UNITED RENTALS (NORTH AMERICA) INC | [PHONE] | 20-8300-671-154 |  | 2024-04-01 00:00:00 |  | 8640 | 2024-05-01 00:00:00 | 2024-08-13 00:00:00 |  |  | 241350 | No | Active | USD | 1879.19 | 151.55 | 1727.64 | 1879.19 | 151.55 | 1 | 151.55