Prepaid expense schedules: allocate the cost to the months it covers
In this worked example, a business pays 2,400 on 15 September 2026 for a year of software support running from 1 October 2026 to 30 September 2027. Expensing the whole amount in September puts a year of cost into a month that received none of the service. On accrual accounts, the payment date records when cash left and the contract dates show which months the cost belongs to. A prepayment schedule holds that allocation and gives you a balance to check against the ledger at each month end.
The principle behind the schedule
ACCA's study material explains that under the accruals approach, an expense belongs to the period it relates to, and an amount paid for a future period is carried as a prepayment asset until then. How a particular item is treated still depends on your reporting framework, materiality policy and the contract. When a payment is deductible for tax is a separate question that this schedule does not answer.
Sources and context, checked :
A worked schedule
Assume accrual accounts, benefit received evenly across twelve full months, and an approved policy that recognises the prepayment on payment and releases it monthly. Tax, currency and cancellation are ignored. The monthly release is 2,400 / 12 = 200.
If no supplier bill has been posted, the payment is recorded as debit prepaid expenses 2,400 and credit bank 2,400, and each month as debit support expense 200 and credit prepaid expenses 200. If accounts payable has already posted the invoice to prepaid expenses, the payment simply settles the payable. Recording the bank payment as another purchase would count the cost twice.
| Date | Expense recognised to date | Prepaid balance |
|---|---|---|
| 30 September 2026, before coverage starts | 0 | 2,400 |
| 31 October 2026 | 200 | 2,200 |
| 30 November 2026 | 400 | 2,000 |
| 31 December 2026 | 600 | 1,800 |
What each schedule line should hold
We suggest one line per item showing the supplier, invoice reference and attachment, payment date, coverage start and end, amount to allocate, allocation basis and expense account. For each month, the line then shows the opening balance, additions, releases, approved adjustments and closing balance. Take coverage dates from the contract or renewal notice, because an invoice date alone does not show which months are covered.
Keep refundable deposits off the schedule until their classification is settled. If a service is cancelled, refunded or changed, record an approved adjustment so the monthly release stops or changes. A partial first month or a usage-based service needs a documented method that fits the arrangement, which an automatic one-twelfth will not always provide.
Prove the balance each month
The control is a short rollforward: opening prepaid balance, plus new prepayments, less releases, plus or minus approved adjustments, equals the closing balance. That total should agree to the prepaid expenses account in the ledger. A difference can mean an item was expensed on payment, posted twice or never added to the schedule. If a payment went straight to expense, reclassify the unexpired part to prepaid expenses once. Posting a fresh purchase entry as well would double the cost.
At this month end, pick one annual renewal and prove three figures against its contract: the coverage dates, the expense recognised to date and the balance still prepaid.