Prepaid Expense Amortization Schedule Template

A prepaid expense amortization schedule lists every bill you paid in advance, such as an annual insurance policy or a software subscription, and spreads each one over the months it covers. Each month it gives you two numbers: the amount to expense and the prepaid balance that stays on the balance sheet.

What a prepaid expense is

A prepaid expense is a payment for goods or services you will receive in a later period. Under accrual accounting the payment buys an asset, the right to that future benefit, so it goes on the balance sheet when you pay or record the bill. As the months it covers go by, you move it to expense. That move is amortization.

Common prepaids:

• Insurance premiums. General liability, property, D&O and other policies are often billed a year at a time.
• Software subscriptions. Annual plans paid at the start of the term.
• Service and maintenance contracts. Support agreements and equipment maintenance billed for a set term.
• Dues and subscriptions. Annual memberships and data or research subscriptions.

A prepaid is a current asset when its benefit will be used within 12 months of the balance sheet date. On a contract that runs longer, the portion that covers months beyond that is a noncurrent asset, so a two-year contract paid up front is split between the two. On the cash basis a prepayment is expensed when paid, which is why the schedule belongs to accrual books.

When to capitalize a prepaid and when to expense it

Record a payment as a prepaid when it covers future months and it is large enough that expensing it at once would distort the month you paid it. Expense it when paid if the benefit is used up within the month or the amount is too small to matter.

GAAP sets no dollar threshold for this. Materiality is a judgment, so each company picks its own threshold and writes it into its accounting policy. A typical policy names a minimum amount and a minimum term: prepayments at or above the amount that cover more than the set number of months go on the schedule, and everything else is expensed when paid. Applied the same way every month, the policy keeps the results comparable.

Everything here is about the books. The tax deduction for a prepayment follows separate IRS rules, including the 12-month rule, so the year a prepayment is deducted on the tax return can differ from the months it is expensed on the books. Your tax preparer handles that difference.

Straight-line monthly and daily methods

Both methods spread the cost evenly over the term. The difference is the unit of time.

Monthly straight-line

A $12,000 policy that runs from January 1 to December 31 expenses $1,000 a month. Every month gets the same amount, whether it has 28 days or 31, so the journal entry is the same each month. When the division leaves a fraction of a cent, round the monthly amount to the cent and put the difference in the last month so the balance ends at exactly zero. A $5,000 policy over 12 months is $416.67 a month for 11 months and $416.63 in the twelfth.

Daily

The same $12,000 policy works out to about $32.88 a day ($12,000 ÷ 365 days). January’s 31 days expense $1,019.18 and February’s 28 days expense $920.55. For each month, work out the amount through the month-end at the unrounded daily rate, round it to the cent, and subtract the amount through the prior month-end, so the months add to exactly $12,000. Daily follows the calendar exactly and handles a term that starts or ends mid-month with no extra rule. The tradeoff is a different journal entry amount every month.

Choose one method in your accounting policy and use it for every prepaid, so the whole schedule follows one rule.

Partial months

Terms rarely line up with the calendar. A software subscription from March 15 to March 14 of the next year touches 13 calendar months. There are three common ways to handle it:

1. 1Daily. Expense 17 days in March, each full month in between, and 14 days the next March. This is the most precise.
2. 2Start in the start month. Treat the term as 12 whole months beginning in March, so March gets a full month and the next February is the last. The template uses this rule for the Monthly method.
3. 3Mid-month convention. A term that starts on or before the 15th begins that month, and a later start begins the next month. Each month still gets an equal share.

All three expense the same total over the term. They differ only in how it splits between months, so write your convention into the policy and keep to it.

The monthly journal entry

Two entries cover the life of a prepaid. When you pay, or record the bill, set up the asset:

Then, at each month-end, move that month’s share to expense:

Debit the expense account each prepaid belongs to, such as insurance, software or repairs and maintenance, and credit prepaid expenses. Post one combined entry in the close, with a line for each expense account, and keep the schedule as its support.

A recurring journal entry can post the monthly straight-line amount for you. Check it against the schedule each month, because a new prepaid, a cancellation or a shorter last month changes the amount.

A rollforward that ties to the balance sheet

The rollforward shows that the schedule and the general ledger agree. For each month:

The beginning balance is last month’s ending balance. Additions are the prepaids recorded during the month. Amortization is the month’s total from the schedule. The ending balance should equal prepaid expenses on your balance sheet.

When the two disagree, look for a prepaid recorded in the ledger with no row on the schedule, an ordinary expense coded to prepaid expenses, or a month whose amortization entry was never posted. The template’s Rollforward sheet builds this table from the schedule: enter the general ledger balance each month and it shows the difference.

Common mistakes

• Expensing the whole payment. An annual policy expensed in the month it was paid overstates that month’s expenses and understates the next eleven.
• Recording the asset with no schedule row. The prepaid sits on the balance sheet unamortized until someone asks about it at year-end.
• Amortizing past the end of the term. A recurring entry left running after the term ends keeps expensing a balance that is already gone. Each schedule row should end at exactly zero.
• Booking a renewal straight to expense. A renewed policy is a new prepaid with its own row and its own term.
• Leaving a canceled contract on the schedule. When a contract ends early, record any refund due as a receivable, expense the rest of the balance, and close the row.
• Skipping the tie-out. A schedule that is never compared to the general ledger drifts away from it. Reconcile the rollforward to the balance sheet every month.

Frequently asked questions