Prepaid expense working papers that pass audit: structure, formulas and tie-outs

Insurance premiums, annual software subscriptions, AMC contracts and advance rent are paid up front and charged to the P&L over the period they cover. Done casually, prepaid accounting creates two recurring problems: a balance sheet number nobody can explain, and lumpy expense lines in the monthly MIS. A simple register with formula-driven amortisation fixes both.

1. One row per item

Keep one row per invoice or policy with: vendor, description, invoice number and date, GL to charge, cost centre, total amount (net of recoverable GST), coverage start date and coverage end date. Anything shorter than a month, or below a materiality threshold set in your policy, can go straight to expense.

2. Amortise by days, not by twelfths

Dividing by 12 works only when coverage starts on the first of a month. Charging by days is exact and still easy to formula. For a reporting month whose first day is in cell H$4:

Days in month   =MAX(0, MIN($G5, EOMONTH(H$4,0)) - MAX($F5, H$4) + 1)
Charge          =ROUND($E5 * DaysInMonth / ($G5 - $F5 + 1), 2)

Here F is the coverage start, G the coverage end and E the amount. Copy across twelve month columns built with =EDATE(H$4,1). In the final month, take the remaining balance instead of the formula so the item clears to exactly zero.

3. Roll-forward for each month

Opening balance	+ Additions	− Amortised	= Closing balance
From last month's closing	New items with invoice date in the month	Sum of the month's charge column	Must equal the GL balance

The closing balance must tie to the prepaid GL in the trial balance every month. A difference usually means a prepaid was posted straight to expense, or an amortisation journal was missed.

4. Split current and non-current

Amounts that will be charged within 12 months of the reporting date are current (other current assets); the rest is non-current. Add a column that sums the charges for the next twelve months; the remainder is the non-current portion.

5. What auditors ask for

The register reconciled to the GL at the period end.
Invoices or policy schedules for a sample, showing the coverage dates used.
Evidence that GST input credit was taken separately and not included in the prepaid amount.
Cut-off: payments made before year end for periods after year end are prepaid, not expense.
Review and approval of the monthly amortisation journal.

6. Save time

The free Template A: Prepaid Expenses Amortisation Schedule has the register, the day-based schedule for any twelve-month window and a summary by GL ready to paste into the journal. Pair it with a month-end accruals tracker for the other half of the close.