Use this template to track what you paid in advance, when the coverage applies, how much to recognize each period, and the prepaid balance still remaining. It is a practical bookkeeping schedule—not a prescribed regulatory form or a tax-deduction calculator.
What a prepaid expense schedule tracks
A prepaid expense is a payment made now for a benefit received in a future period. Common examples include insurance, rent, subscriptions, maintenance agreements, and software subscriptions. For bookkeeping, the prepaid amount is generally recorded as an asset and recognized as expense over the period that receives the benefit. Straight-line allocation may fit when the benefit is even across the coverage period, but the schedule should show its dates and method rather than assume every payment works that way. See QuickBooks’ overview of prepaid expenses and amortization.
Copyable prepaid expense template
Use one row per contract or prepaid item on the summary sheet, then link it to a monthly schedule. The fields below are practical recommendations, not a mandated form.
| Field | What to enter |
|---|---|
| Vendor or description | Insurer, landlord, service provider, or a short description of the item. |
| Category | For example, insurance, rent, subscription, maintenance, or software. |
| Reference or invoice number | The invoice, policy, contract, or other source reference. |
| Amount paid | Total amount paid for the benefit being tracked. |
| Payment date | Date the payment was made. |
| Coverage start date | First date the service or benefit applies. |
| Coverage end date | Last date the service or benefit applies. |
| Recognition periods | Number of months or other periods used in the schedule, as appropriate to the terms. |
| Allocation method | For example, straight-line when an even allocation fits the benefit period. |
| Periodic expense | Amount recognized as expense in each period, including adjustments for partial first or last periods where needed. |
| Opening prepaid balance | Unrecognized prepaid amount at the start of the period. |
| Period expense | Amount recognized as expense during the period. |
| Closing prepaid balance | Unrecognized prepaid amount at the end of the period. |
| Accounts | Prepaid asset account and expense account used for posting. |
| Journal entry details | Entry date, reference, and posting or review status. |
Build the monthly roll-forward
For each item, list each month (or other recognition period) between the coverage dates. A basic schedule can use these columns:
#1 Best Overall
| Period | Opening prepaid balance | Expense recognized | Closing prepaid balance |
|---|---|---|---|
| First period | Amount paid, adjusted for any amount already recognized before the schedule begins. | Amount allocated to the period under the selected method. | Opening balance minus period expense. |
| Each following period | Prior period’s closing balance. | Amount allocated to the period under the selected method. | Opening balance minus period expense. |
Where straight-line allocation is appropriate and every period is a full month, a simple calculation is the amount paid divided by the number of recognition periods. If coverage begins or ends partway through a month, decide how to treat partial periods based on the applicable accounting policy and contract; do not let a formula silently allocate a full month when the benefit period is shorter. The schedule should make any such treatment visible.
Example layout
Suppose a business pays for an item covering several months. Enter its actual vendor, payment, coverage dates, amount, and selected method in the summary row. In the linked monthly schedule, carry each closing balance forward as the next month’s opening balance, record that month’s expense, and calculate the new closing balance. This illustrates the layout only; it does not set an allocation method or amount for a real contract.
Rank #2
- Ideal for Gifting
- Ideal for a bookworm
- Compact for travelling
Reconcile and review the schedule
Use these checks before relying on a schedule for reporting:
- Confirm that the full scheduled expense over the coverage period adds up to the original prepaid amount, subject to any documented adjustments.
- Check that the schedule starts and ends on the correct coverage dates and that partial first or last periods are treated consistently with the selected method.
- Verify that each period’s opening balance matches the prior period’s closing balance.
- Tie the total closing prepaid balances to the prepaid asset account in the ledger and investigate differences.
- Record the related journal-entry reference and whether it has been posted and reviewed.
Spreadsheet or accounting software?
A spreadsheet can be suitable when a small number of schedules can be maintained and reviewed manually. Accounting software may be more useful when recurring postings, schedule forecasts, and consolidated reporting matter. Sage Intacct documents prepaid schedule templates, straight-line amortization, reports, and automation that can reduce reliance on spreadsheets and manual journal entries. The right choice depends on transaction volume, number of active schedules, posting effort, reporting needs, controls, and implementation cost; there is no universal schedule count at which software becomes worthwhile. See Sage Intacct’s prepaid expense amortization documentation.
Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Keep book expense separate from tax deductions
This schedule is for tracking bookkeeping recognition; it does not determine when a payment is deductible for tax. IRS Publication 334 (2025) says cash-method taxpayers generally deduct expenses in the year paid, subject to limitations for advance payments. Its example concerns a calendar-year taxpayer paying $1,000 in 2025 for a one-year business insurance policy beginning July 1: the publication shows a $500 deduction in 2025 and $500 in 2026. That is a tax example, not a rule for financial-statement expense recognition. Read the IRS Publication 334 (2025), Tax Guide for Small Business.
Tax timing can depend on the taxpayer’s facts and accounting method. IRS Publication 538 describes a 12-month rule for certain rights or benefits: the benefit must not extend beyond the earlier of 12 months after it begins or the end of the tax year after payment. It also notes that some method changes require IRS approval. Do not use a general prepaid schedule to automatically decide whether a payment qualifies; consult current IRS guidance or a qualified tax professional for an individual tax determination. See IRS Publication 538, Accounting Periods and Methods.
Quick Recap
Best Value
- It can be a gift option
- Comes with secure packaging
- Helpful in various ways
Rank #4
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
