How to Keep a Prepaid Expenses Schedule at Month-End

When you pay for a service before you receive it, such as a year of insurance cover or an annual software plan, the payment covers future months. A prepaid expenses schedule spreads that cost over the months it actually relates to, so your monthly profit is not hit hard in the month you pay and then flattered for the rest of the period.

The schedule is also your evidence. It shows the auditor, your chartered accountant or a new team member exactly what makes up the prepaid balance on the balance sheet, line by line.

Keep one row per payment, not one row per supplier. A supplier you renew with every year gets a new row for each renewal, so every row can be traced back to one invoice and one payment.

• ✓Supplier or party name and a short description, for example fire insurance for the godown.
• ✓Invoice reference and payment date.
• ✓Total amount to be spread, using the same basis your books use for that expense.
• ✓Cover start date and cover end date.
• ✓Number of months covered and the monthly release amount.
• ✓Expense ledger the release is posted to, such as insurance, software or rent.
• ✓Released to date and balance remaining at the current month-end.
• ✓Status: active, fully released or cancelled, with a note for any change.

If you already track recurring charges, link each annual plan in your subscription tracker to its row here. The guide on tracking business subscriptions and recurring charges helps you catch renewals before they post.

The example below shows three common prepayments at the close of a month that we will call month 4 of the financial year. All amounts and periods are illustrative and are not drawn from any real business.

In this illustration, the month 4 journal releases Rs 43,000 from prepaid expenses: Rs 10,000 to insurance, Rs 3,000 to software and Rs 30,000 to rent. After posting, the prepaid expenses ledger should show Rs 1,70,000, matching the balance remaining column. If the ledger shows any other figure, the close is not finished.

Cover does not always start on the first of the month. Pick one method, write it down in your close notes, and apply it consistently. Two common approaches are a daily basis, where the cost is spread by the number of days in each month, and a simpler monthly basis, where a policy starting in the first half of a month is treated as starting that month and one starting in the second half is treated as starting the next.

For illustration, a Rs 73,000 policy covering 365 days that starts on the 21st of a 30-day month would release Rs 2,000 for the 10 days in that first month on a daily basis, then Rs 200 per day after that. A monthly basis would release Rs 6,083 or so each month from the following month. Either works for most small businesses if it is applied consistently; confirm the method with your chartered accountant, especially for large amounts.

If you cancel a policy or subscription before the cover ends, the unreleased balance no longer relates to future service. How you clear it depends on what you get back.

1. Release the cost up to the cancellation date as normal.
2. If the supplier agrees a refund, move the refundable amount from prepaid expenses to a receivable from that party until the money arrives.
3. Expense any part of the balance that will not be refunded in the month of cancellation.
4. Mark the row as cancelled, attach the cancellation confirmation and note the refund reference.
5. When the refund reaches the bank, clear the receivable and check it in your bank reconciliation.

If a refund is credited against a future invoice instead of paid back, track it in the same way you track vendor advances, so it is not lost when the next invoice arrives.

• ✓Add new prepayments paid during the month, checking the payment register for annual or advance payments that were posted straight to expense.
• ✓Post the monthly release journal from the schedule totals, split by expense ledger.
• ✓Update released to date and balance remaining for every active row.
• ✓Compare the schedule total with the prepaid expenses ledger balance at the closing date.
• ✓Explain and correct any difference, then record who reviewed the tie-out and when.
• ✓Move fully released and cancelled rows to a closed section rather than deleting them.

Make this a fixed step in your month-end close checklist. At the financial year-end, the same tie-out feeds the year-end books closing checklist and the audit pack.

• Posting an annual payment straight to expense and never moving it to prepaid.
• Keeping one row per supplier, so renewals overwrite old balances and the trail breaks.
• Forgetting to stop releases once cover ends, which drives the balance negative.
• Changing the mid-month method from one item or month to the next.
• Leaving a cancelled policy on the schedule and continuing to release it.
• Treating the schedule as complete without checking its total against the ledger.
• Mixing accrued costs or supplier advances for goods into the prepaid schedule.

When this does not apply: small, routine monthly bills that cover only the current month do not need a schedule. Your chartered accountant may also agree a materiality level below which minor prepayments are expensed directly. Advances to suppliers for goods or capital items belong in other records. This guide does not cover tax treatment of any prepayment.