How does a prepaid amortization schedule work?

Definition

A prepaid amortization schedule lists each prepaid item and the slice of cost that becomes expense in each period it covers. On the books, this is a worksheet, not a statement line and not an account you post to.

The Balance Sheet still shows prepaid expenses as one total. The schedule is the proof behind that total.

Each row is a prepaid item, its original cost, the months it covers, and the amount to expense this period. The leftover column should equal the prepaid account.

Where it shows up

Balance Sheet: Related to the prepaid expenses line it supports.

P&L: Related to the expense recognized each period.

See also: Prepaid Expenses · Adjusting Journal Entry · Supporting Schedule

When you look at your Balance Sheet, you will not see this schedule as a line. You see prepaid expenses in current assets, and this worksheet supports that number.

The profit and loss statement does not list the schedule either. The related expense is the amount the schedule says to recognize this period.

A close binder or a shared spreadsheet is where the schedule usually lives. It is working paper, not a general-ledger account.

How it works

Start with the prepaid payment. Record the full amount as a prepaid asset, then put that item on the schedule.

The schedule lists the start date, the end date, and the monthly amount. For a $1,200 annual bill, the monthly amount is $100.

At period end, the schedule tells you the adjusting journal entry. You debit the expense and credit prepaid expenses for that month's slice.

If the same amount repeats each month, a recurring journal entry can post it. The schedule still has to agree to the prepaid account after the entry.

New prepayments get a new row. Expired rows drop off once the leftover is zero.

The matching principle is the reason for the spread. The expense belongs in the months of coverage, not on the payment date.

Account reconciliation at month-end compares the prepaid account to the schedule total. If they disagree, a row was missed or an entry was skipped.

Month-end close is when this work usually happens. The schedule is part of the close file, next to the other supporting schedules.

Keep one row per prepaid item, with leftover cost that you can tie out. A schedule that cannot be added up is not doing its job.

Example

A music school pays $1,200 on January 1 for a year of teaching software. The prepaid amortization schedule puts that bill on one row, $100 per month for twelve months.

January's leftover after the first month is $1,100. The schedule's expense-this-period column shows $100.

The school records the monthly adjusting entry the schedule calls for:

Debit: Software subscription expense $100

Credit: Prepaid expenses $100

Software subscription expense hits the P&L by $100, and prepaid expenses fall by $100. The schedule's leftover column now matches the prepaid account at $1,100.

The payment itself is not this page's journal. The schedule's job is the monthly spread, and this is the one entry it drives.

February through December repeat the same $100. When December is posted, the row's leftover is zero and it can leave the schedule.

Common mix-ups

A prepaid amortization schedule is not the prepaid expenses account. The account is the Balance Sheet line; the schedule is the worksheet that supports it.

The schedule is not the adjusting journal entry. The schedule computes the amount; the entry is what you post.

This is not a depreciation schedule. Depreciation spreads a long-lived asset; this worksheet spreads a prepaid.

Related terms

• Prepaid Expenses: Amounts paid up front for goods or services the business has not yet used.
• Adjusting Journal Entry: An entry made at period end to record accruals, deferrals, and corrections.
• Supporting Schedule: A detailed worksheet backing up a single line on the financial statements.
• Recurring Journal Entry: A standard entry set to repeat each period with the same accounts.
• Deferral: Pushing recognition of a cost or revenue to a later period than the cash movement.
• Account Reconciliation: Proving that a ledger balance agrees to independent support.
• Matching Principle: Recording expenses in the same period as the revenue they helped produce.
• Month-End Close: The monthly version of the close, ending in issued financial statements.