A prepayment schedule is one sheet. Skipping it costs a misstated balance sheet and a surprise at year end.
List each prepayment with its amount, start date and end date. Calculate the months covered, the monthly release and the cumulative amount released to date, then the balance still prepaid. Post the monthly release as a journal and reconcile the schedule total to the prepayments account in the general ledger every month.
Put the month-end date in a cell named MonthEnd.
F: months covered
=DATEDIF(C2,D2,"m")+1
G: monthly release
=B2/F2
H: months elapsed to date (capped between zero and the total)
=MAX(0,MIN(F2,DATEDIF(C2,MonthEnd,"m")+1))
If the start date is after MonthEnd, DATEDIF returns an error; wrap it: =IF(C2>MonthEnd,0,MAX(0,MIN(F2,DATEDIF(C2,MonthEnd,"m")+1)))
I: released to date =G2*H2
J: balance still prepaid =B2-I2
This releases in whole months, which suits most prepayments. For large items that start mid-month, release by days instead.
Typical prepayments are insurance, software licences, maintenance contracts, rent paid in advance and subscriptions covering future months. Set a threshold so small items are expensed directly; a schedule full of tiny amounts is costly to maintain and adds nothing. The accruals and prepayments guide covers the threshold and the matching accruals routine.
Before posting the release journal, scan the schedule for new rows. Check each new prepayment against the invoice: is the service period right, is the amount net of recoverable tax, and is the expense account the one the cost would normally go to? Most schedule errors come from a wrong end date keyed on day one, which then releases the wrong amount for the whole life of the item. A second person checking new rows once a month removes most of these mistakes.
Use the amount net of recoverable VAT or sales tax. Irrecoverable tax forms part of the cost and is released with the prepayment.
Matches every company card transaction to its expense claim, and flags spend nobody claimed, claims made twice, missing receipts and splits under the approval limit. Runs in your browser on your own computer: nothing is uploaded.
12 questions on how strong your close controls are. Free to use online.
The Month-End Close & Controls System tests the trial balance against the sum of reconciled balances, keeps every open item on one exception dashboard and blocks sign-off while exceptions remain open. Excel, no macros, one-time price.
Keep them separate. Prepayments are assets released over time; accruals are liabilities that usually reverse the next month. Mixing them makes both harder to reconcile.
Monthly works for most items. Release large prepayments that start mid-month by days, so the expense is accurate in the first and last month.
One that your auditors agree is immaterial, set in your accounting policy. Below it, expense the cost when invoiced.
Usually a prepayment was posted directly to expense, a release journal was missed, or an item was added to the ledger but not to the schedule.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.