Spreadsheet: 888463d1738946033-organize-data-idea-test-file
Sheet: Sheet1

Employee: [NAME] Davis    Number: 123456 |  |  |  |  |  |  |  | employee name | employee id | accrual bank | date posted | Accrued | Expired | Taken | Adjustments | Period Net | Balance |  |  | employee id | accrual bank | date posted | Accrued | Expired | Taken | Adjustments | Period Net | Balance
Accrual : 22 |  |  |  |  |  |  |  | [NAME] [NAME] | 123456 | 22 | 11/11/2024 | 0.67 | 0 | 0 | 0 | 0 | - |  | [NAME] [NAME] | 123456 | 22 | 11/11/2024 | 0.67 | 0 | 0 | 0 | ---- | -
 |  |  |  |  |  |  |  | [NAME] [NAME] | 123456 | 22 | 11/24/2024 | 1.19 | 0 | 0 | 0 | 0 | - |  | [NAME] [NAME] | 123456 | 22 | 11/24/2024 | 1.19 | 0 | 0 | 0 | ---- | -
Date Posted | Date Expired | Accrued | Expired | Taken | Adjustments | Period Net |  | [NAME] [NAME] | 123456 | 22 | 12/8/2024 | 0.52 | 0 | 0 | 0 | 0 | - |  | [NAME] [NAME] | 123456 | 22 | 12/8/2024 | 0.52 | 0 | 0 | 0 | ---- | -
 |  |  |  |  |  |  |  | [NAME] [NAME] | 123456 | 22 | 12/22/2024 | 0.82 | 0 | 0 | 0 | 0 | - |  | [NAME] [NAME] | 123456 | 22 | 12/22/2024 | 0.82 | 0 | 0 | 0 | ---- | -
 |  |  |  |  |  |  |  | [NAME] [NAME] | 123456 | 22 | 1/19/2025 | 0.78 | 0 | 0 | 0 | 0 | - |  | [NAME] [NAME] | 123456 | 22 | 1/19/2025 | 0.78 | 0 | 0 | 0 | ---- | -
11/11/2024 |  | 0.67 | 0 | 0 |  | ---- |  | [NAME] [NAME] | 123456 | 22 | - | - | - | - | - | - | 3.99 |  | [NAME] [NAME] | 123456 | 22 | - | - | - | - | - | - | 3.99
11/24/2024 |  | 1.19 | 0 | 0 |  | ----
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | employee name | employee id | accrual bank | date posted | Accrued | Expired | Taken | Adjustments | Period Net | Balance
12/8/2024 |  | 0.52 | 0 | 0 |  | ---- |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 171595 | 2 | 11/10/2024 | 0 | 0 | -24 | 0 | ---- | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 171595 | 2 | 11/11/2024 | 45.36 | 0 | 0 | 0 | ---- | -
12/22/2024 |  | 0.82 | 0 | 0 |  | ---- |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 171595 | 2 | 11/24/2024 | 2.15 | 0 | 0 | 0 | ---- | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 171595 | 2 | 12/8/2024 | 2.15 | 0 | 0 | 0 | ---- | -
1/19/2025 |  | 0.78 | 0 | 0 |  | ---- |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 171595 | 2 | 12/15/2024 | 0 | 0 | -8 | 0 | ---- | -
Total for Accrual: |  | 3.99 | 0 | 0 | 0 | 3.99 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 171595 | 2 | 12/19/2024 | 0 | 0 | -8 | 0 | ---- | -
Employee: [NAME]: 171595 |  |  |  |  |  |  |  | employee name | employee id | accrual bank | date posted | Accrued | Expired | Taken | Adjustments | Period Net | Balance |  | [NAME] | 171595 | 2 | 12/21/2024 | 0 | 0 | -8 | 0 | ---- | -
Accrual : 2 |  |  |  |  |  |  |  | [NAME] | 171595 | 2 | 11/10/2024 | 0 | 0 | 24 | 0 | 0 | - |  | [NAME] | 171595 | 2 | 12/22/2024 | 2.15 | 0 | 0 | 0 | ---- | -
 |  |  |  |  |  |  |  | [NAME] | 171595 | 2 | 11/11/2024 | 45.36 | 0 | 0 | 0 | 0 | - |  | [NAME] | 171595 | 2 | 1/1/2025 | ---- | ---- | ---- | 0 | (3.81) | -
Date Posted | Date Expired | Accrued | Expired | Taken | Adjustments | Period Net |  | [NAME] | 171595 | 2 | 11/24/2024 | 2.15 | 0 | 0 | 0 | 0 | - |  | [NAME] | 171595 | 2 | 1/5/2025 | 2.15 | 0 | 0 | 0 | ---- | -
 |  |  |  |  |  |  |  | [NAME] | 171595 | 2 | 12/8/2024 | 2.15 | 0 | 0 | 0 | 0 | - |  | [NAME] | 171595 | 2 | 1/19/2025 | 2.15 | 0 | 0 | 0 | ---- | -
 |  |  |  |  |  |  |  | [NAME] | 171595 | 2 | 12/15/2024 | 0 | 0 | 8 | 0 | 0 | - |  | [NAME] | 171595 | 2 | - | - | - | - | - | - | 4.3
11/10/2024 |  | 0 | 0 | -24 |  | ---- |  | [NAME] | 171595 | 2 | 12/19/2024 | 0 | 0 | 8 | 0 | 0 | -
 |  |  |  |  |  |  |  | [NAME] | 171595 | 2 | 12/21/2024 | 0 | 0 | 8 | 0 | 0 | -
11/11/2024 |  | 45.36 | 0 | 0 |  | ---- |  | [NAME] | 171595 | 2 | 12/22/2024 | 2.15 | 0 | 0 | 0 | 0 | -
 |  |  |  |  |  |  |  | [NAME] | 171595 | 2 | 1/1/2025 | 0 | 0 | 0 | 0 | 3.81 | -
11/24/2024 |  | 2.15 | 0 | 0 |  | ---- |  | [NAME] | 171595 | 2 | 1/5/2025 | 2.15 | 0 | 0 | 0 | 0 | -
 |  |  |  |  |  |  |  | [NAME] | 171595 | 2 | 1/19/2025 | 2.15 | 0 | 0 | 0 | 0 | -
12/8/2024 |  | 2.15 | 0 | 0 |  | ---- |  | [NAME] | 171595 | 2 | - | - | - | - | - | - | 4.3
12/15/2024 |  | 0 | 0 | -8 |  | ----
12/19/2024 |  | 0 | 0 | -8 |  | ----
12/21/2024 |  | 0 | 0 | -8 |  | ----
12/22/2024 |  | 2.15 | 0 | 0 |  | ----
1/1/2025 |  | ---- | ---- | ---- |  | (3.81)
1/5/2025 |  | 2.15 | 0 | 0 |  | ----
1/19/2025 |  | 2.15 | 0 | 0 |  | ----
Total for Accrual: |  | 56.11 | 0 | (48.00) | (3.81) | 4.3