How is a prepaid amortization schedule built?

Short answer

List each prepaid with its amount and service dates, divide the cost over the months covered, and release that amount to expense each month.

Worked example

A company pays $18,000 on March 20 for a 12-month insurance policy that runs April 1 through March 31 of the following year.

Record the payment as a prepaid asset: Debit prepaid insurance $18,000 and credit cash $18,000. Nothing hits expense in March because coverage hasn't started.
Calculate the monthly amount: $18,000 / 12 months = $1,500.
Release it each month: Starting in April, debit insurance expense $1,500 and credit prepaid insurance $1,500.

Month	Beginning balance	Additions	Amortization	Ending balance
March	$0	$18,000	$0	$18,000
April	$18,000	$0	$1,500	$16,500
May	$16,500	$0	$1,500	$15,000
June	$15,000	$0	$1,500	$13,500
(July to January follow the same pattern)
February	$3,000	$0	$1,500	$1,500
March, next year	$1,500	$0	$1,500	$0

Each month's ending balance is what sits in the prepaid insurance account on the balance sheet.

Columns the schedule needs

Identification: Vendor, description, and invoice or contract reference.
Accounts: The prepaid account and the expense account it releases to, plus department or class if the cost is split.
Term: Amount paid, service start date, and service end date.
Calculation: Monthly amortization, amortization to date, and remaining balance.

Partial months

When a term starts mid-month, the first and last months are prorated under the team's policy. A $12,000 subscription running June 16 through June 15 of the next year could release $500 in the first June, $1,000 in each of the next 11 months, and $500 in the final June. Prorating by days is the other common approach.

Best practices

Use contract service dates: The service period drives amortization, not the invoice or payment date.
Set a threshold: Many teams expense prepaids below a policy amount right away, which keeps the schedule focused on material items.
Tie to the GL monthly: The schedule total should equal the prepaid account balance.

From contract to monthly entry in Stack

Connect QuickBooks Online, NetSuite, or Sage Intacct in Stack > Knowledge > Apps so the agent can read the prepaid account's GL detail.
Upload the contracts or invoices, or point a Ramp Stack agent at the bills and card charges that cover future periods. Stack reads the amount and service dates from PDF text and tables.
The agent builds the schedule with the columns above in a workbook, using formulas you can trace from each month's release back to the amount paid and the term.
It reconciles the schedule total to the prepaid account in the GL and categorizes any difference that doesn't tie out.
Set the schedule up as a recurring Close checklist task. Each period, the agent rolls it forward, adds new prepaids, and drafts the amortization entry with its supporting documentation.
An approver reviews the roll-forward and the entry, which posts after approval.