Spreadsheet: 885124d1734546676-nested-if-statements-sample-entry-v2
Sheet: Sheet1

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