Spreadsheet: 858044d1706826515-prepaid-expense-spreadsheet-total-amount-expensed-invoice-total-new-prepaids-formula-help
Sheet: 1125 Invoices

2023 Invoices |  |  |  |  |  |  | # days in month
1125-0000 |  |  |  |  |  |  | start of month | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00
 |  |  |  |  |  |  | end of month | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00 | 2025-04-30 00:00:00 | 2025-05-31 00:00:00 | 2025-06-30 00:00:00 | 2025-07-31 00:00:00 | 2025-08-31 00:00:00 | 2025-09-30 00:00:00 | 2025-10-31 00:00:00 | 2025-11-30 00:00:00 | 2025-12-31 00:00:00
VENDOR | Invoice # | Date added to GL | Beginning Date of Expense | End Date of Expense | Expense | # Days | Expense Per Day | Jan - 2023 | Feb - 2023 | Mar - 2023 | Apr - 2023 | May - 2023 | Jun - 2023 | Jul - 2023 | Aug - 2023 | Sep - 2023 | Oct - 2023 | Nov - 2023 | Dec - 2023 | Jan - 2024 | Feb - 2024 | Mar - 2024 | Apr - 2024 | May - 2024 | 6/1/2024 | [NAME] | 8/1/2024 | 9/1/2024 | 10/1/2024 | 11/1/2024 | 12/1/2024 | 1/1/2025 | 2/1/2025 | 3/1/2025 | 4/1/2025 | 5/1/2025 | 6/1/2025 | 7/1/2025 | 8/1/2025 | 9/1/2025 | 10/1/2025 | 11/1/2025 | 12/1/2025
3M - HIM | 43452 | 2023-04-01 00:00:00 | 2023-04-18 00:00:00 | 2023-07-17 00:00:00 | 31904.81
3M - HIM | 44563 | 2023-05-01 00:00:00 | 2023-07-18 00:00:00 | 2023-10-17 00:00:00 | 31904.86
3M - HIM | 45674 | 2023-08-01 00:00:00 | 2023-10-18 00:00:00 | 2024-01-17 00:00:00 | 33429.28
3M - HIM | 46785 | 2023-12-01 00:00:00 | 2024-01-18 00:00:00 | 2024-04-17 00:00:00 | 33429.28
Acist Medical Systems | 35675 | 2023-04-01 00:00:00 | 2023-02-26 00:00:00 | 2024-02-25 00:00:00 | 8350
Advance (EFT/Patsy) | 30120 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-05-30 00:00:00 | 75000
American College of Surgeons | 24565 | 2023-04-01 00:00:00 | 2023-06-01 00:00:00 | 2024-05-31 00:00:00 | 9600
[NAME] | 26787 | 2023-09-01 00:00:00 | 2023-11-01 00:00:00 | 2024-10-31 00:00:00 | 52500
[NAME] | 27898 | 2023-09-01 00:00:00 | 2023-11-01 00:00:00 | 2024-10-31 00:00:00 | 78750
MCG | 95669 | 2023-11-01 00:00:00 | 2023-12-16 00:00:00 | 2024-12-15 00:00:00 | 34080.8
Medscribes EDZI INC. | 47896 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 | 22742.3
Medscribes EDZI INC. | 49007 | 2023-05-01 00:00:00 | 2023-05-08 00:00:00 | 2023-08-07 00:00:00 | 12937.5
Medscribes EDZI INC. | 54562 | 2023-08-01 00:00:00 | 2023-08-01 00:00:00 | 2023-11-30 00:00:00 | 12937.5
Medscribes EDZI INC. | 55673 | 2023-11-01 00:00:00 | 2023-11-01 00:00:00 | 2024-02-29 00:00:00 | 17689.89
Medscribes EDZI INC. | 56784 | 2023-11-01 00:00:00 | 2023-11-01 00:00:00 | 2024-02-29 00:00:00 | 12937.5
[NAME], LLC | 65672 | 2023-01-01 00:00:00 | 2023-04-01 00:00:00 | 2024-03-30 00:00:00 | 65593.25
[NAME], LLC | 76782 | 2023-09-01 00:00:00 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 | 38278.8
[NAME], LLC | 77893 | 2023-11-01 00:00:00 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 | -9569.7
Natus Neurology | 25676 | 2023-10-01 00:00:00 | 2024-08-07 00:00:00 | 2025-08-06 00:00:00 | 1730