Spreadsheet: 854388d1704290142-prepaid-schedule-amortization-formulas-prepaid-expense-schedule-sample
Sheet: Prepaid Exp Schedule 2023 V2

Company Name
Prepaid Expense Schedule
10400 Prepaid Expenses
2023-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  | 2022-12-31 00:00:00 | 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 | 2023-12-31 00:00:00
[NAME] | Expense Account | Description | Start Period | End Period | Cost | Months | Monthly Exp | Days | Daily Exp | Balance | Expense | Expense | Expense | Expense | Expense | Expense | Expense | Expense | Expense | Expense | Expense | Expense | Balance
Company 1 | 50552 Tech : Enterprise Software | Licenses 2/24/21-9/12/25 | 2021-02-24 00:00:00 | 2025-09-12 00:00:00 | 7604.92 | 54 |  |  |  | 4647.451111111113
Company 2 | 50552 Tech : Enterprise Software | Enterprise License | 2021-06-21 00:00:00 | 2025-10-30 00:00:00 | 7604.92 | 52 |  |  |  | 4972.447692307685
Company 3 | 50405 Prof : Legal Fees | Re-Accreditation Evaluation 2/1/23-2/1/24 | 2023-02-01 00:00:00 | 2024-02-01 00:00:00 | 45000 | 12
Company 4 | 71310 Interest : Interest Expense | Admin Fee 2/28/23-2/27/24 | 2023-02-28 00:00:00 | 2024-02-27 00:00:00 | 25000 | 12
Company 5 | 51110 HR : Professional Development | 3/30/2023-6/29/2023 Compliance Manager Professional | 2023-03-30 00:00:00 | 2023-06-29 00:00:00 | 7049.66 | 3 |  |  |  | 0 | 0 | 0 |  |  |  | 2274.08
Company 6 | 50552 Tech : Enterprise Software | 3/29/2023 - 3/28/2024 | 2023-03-29 00:00:00 | 2024-03-28 00:00:00 | 11218.58 | 12 |  |  |  | 0 | 0 | 0
Company 7 | 50552 Tech : Enterprise Software | 3/7/2023 - 9/6/2023 | 2023-03-07 00:00:00 | 2023-09-06 00:00:00 | 15558.7 | 6 |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  |  | 585.54
Company 8 | 50552 Tech : Enterprise Software | 4/21/2023 - 12/28/2023 | 2023-04-21 00:00:00 | 2023-12-28 00:00:00 | 2367.81 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 207.18
Company 9 | 51110 HR : Professional Development | Quarterly Subscription Fee 05/15/2023 to 08/14/2023 | 2023-05-15 00:00:00 | 2023-08-14 00:00:00 | 3063.11 | 3 |  |  |  |  |  |  |  |  |  |  |  | 510.52
Company 10 | 51120 HR : Recruiting Fees | 1 Yearly Professional Subscription (Global) Prorated 5/17/23 - 4/25/24 | 2023-05-17 00:00:00 | 2024-04-25 00:00:00 | 2947.13 | 12.5
Company 11 | 50552 Tech : Enterprise Software | 5/31/2023 - 8/30/2023 Quickbase Business (Annual) | 2023-05-31 00:00:00 | 2023-08-30 00:00:00 | 8982.19 | 3
Company 12 | 51120 HR : Recruiting Fees | 1 Yearly Professional Subscription (Global) Prorated 6/5/23 - 5/25/24 | 2023-06-05 00:00:00 | 2024-05-25 00:00:00 | 3041.36 | 12.5
Company 13 | 51110 HR : Professional Development | Quarterly Subscription Fee 08/15/2023 to 11/14/2023 | 2023-08-15 00:00:00 | 2023-11-14 00:00:00 | 3063.11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 765.78
Company 14 | 50820 Marketing : Advertising | Recruiter - Corporate 8/11/2023 - 8/10/2024 | 2023-08-11 00:00:00 | 2024-08-10 00:00:00 | 23538.78 | 12
Company 15 | 50552 Tech : Enterprise Software | 8/31/2023 - 11/29/2023 | 2023-08-31 00:00:00 | 2023-11-29 00:00:00 | 8982.19 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2994.06
Company 16 | 50552 Tech : Enterprise Software | 9/7/2023 - 9/6/2024 | 2023-09-07 00:00:00 | 2024-09-06 00:00:00 | 31712 | 12
Company 17 | 50552 Tech : Enterprise Software | 9/24/2023 - 12/28/2023 | 2023-09-24 00:00:00 | 2023-12-28 00:00:00 | 902.02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 240.54
Total
per GL-10400 Prepaid Expenses
Difference