Spreadsheet: 885030d1734442469-index-match-formula-help-sample-entry-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  | SUBSIDIARY_NAME | [NAME] | ACCOUNT_NAME | DEPARTMENT_NAME | LOCATION_NAME | DEBIT | CREDIT | DATE | TRANSACTION MEMO | LINE MEMO | REFERNUMBER
 |  |  |  |  |  |  |  | PMIH : TN | 10440 | Intercompany | Corporate | Corporate | 0 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
 |  |  |  |  |  |  |  | PMIH : MI | 10440 | Intercompany | Corporate | Corporate | 0 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
 |  |  |  |  |  |  |  | PMIH : VA | 10440 | Intercompany | Corporate | Corporate | 0 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
 |  |  |  |  |  |  |  | PMIH : TLC | 10440 | Intercompany | Corporate | Corporate | 0 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
Account No. | (All)
Sum of Amount |  |  | Period End Date
[NAME] | Department: Department Name | Location: Location Name | 2024-11-30 00:00:00 |  |  | Net Total
MI | Dept 1 | Michigan | -197.2700000000002 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  |  |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
MI | Dept 2 | Michigan | -2345.57 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 2345.57 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
MI Total |  |  | -2542.84 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 2542.84 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
TN | Dept 1 | Tennessee | -143.1 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 143.1 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
TN | Dept 1 | Tennessee | -429.3 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 429.3 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
TN | Dept 1 | Tennessee | -275.54 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 275.54 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
TN | Dept 1 | Tennessee | -632.02 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 632.02 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
TN | Dept 2 | Tennessee | -7284.6 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 7284.6 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
TN | Dept 2 | Tennessee | -10207.45 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 10207.45 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
TN | Dept 2 | Tennessee | -4540.18 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 4540.18 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
TN Total |  |  | -23512.19 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 23512.19 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
VA | Dept 1 | Virginia | -2087.5 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 2087.5 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
VA | Dept 1 | Virginia | -14874.73 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 14874.73 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
VA | Dept 1 | Virginia | -11175.36 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 11175.36 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
VA | Dept 1 | Virginia | -6818.570000000003 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 6818.570000000003 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
VA | Dept 1 | Virginia | 801.4800000000014 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 0 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
VA | Dept 1 | Virginia | 368.2299999999996 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 0 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
VA | Dept 1 | Virginia | -1880.380000000001 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 1880.380000000001 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
VA | Dept 2 | Virginia | -27736.15000000001 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 27736.15000000001 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
VA | Dept 2 | Virginia | -55931.44000000001 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 55931.44000000001 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
VA | Dept 2 | Virginia | -29630.46999999999 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 29630.46999999999 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
VA | Dept 2 | Virginia | -10606.36 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 10606.36 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
VA | Dept 2 | Virginia | -10660.43 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 10660.43 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
VA | Dept 2 | Virginia | -19180.86 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 19180.86 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
VA | Dept 2 | Virginia | -20170.74 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 20170.74 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001
VA Total |  |  | -209583.28 |  |  |  |  |  | 61510 | ASA Fee Expense |  |  | 209583.28 |  | 2024-11-30 00:00:00 | ASA Fee Entry | ASA Fee Expense | ASA202411-001