How to Prepare Audit-Ready Prepayment Schedules

Prepayments are a standard area of audit testing. They sit on the balance sheet as assets, so auditors want to verify that each balance is genuine, correctly calculated, and will be recovered through future amortization. A well-prepared schedule makes this a quick conversation rather than a prolonged investigation.

What Auditors Test

• Existence: does the prepayment relate to a real payment made in the period?
• Completeness: have all prepayments been captured and none omitted?
• Valuation: is the remaining balance correctly calculated based on the coverage period?
• Cut-off: is the amount expensed in the period appropriate for the time elapsed?
• Presentation: are prepayments correctly classified as current assets?

What Your Schedule Should Include

A well-structured prepayment schedule should give an auditor everything they need without having to ask follow-up questions.

• Description of what was paid for and the supplier
• Date of payment and original invoice amount
• Coverage period (start and end dates)
• Amortization method and monthly amounts
• Cumulative amortization recognised to date
• Remaining balance as of the period end
• GL account the balance sits in
• Reference to the original invoice (file number or attachment)

Handling Cut-Off

Cut-off is the most commonly tested assertion for prepayments. The question is whether the expense recognised in the period matches the benefit received in that period. For a straight-line amortization, this is mechanical. For custom schedules or irregular coverage periods, it requires more careful documentation.

For year-end specifically, you need to be able to show that the amount expensed in the final month of the year is appropriate — and that nothing has been accelerated or deferred to manage the P&L.

Adjustments and the Audit Trail

If you have made any mid-period adjustments — partial refunds, amount corrections, early terminations — auditors will want to understand why and will test the revised schedule. Any adjustment should be supported by documentation: a credit note, a cancellation confirmation, or a written explanation of the reason.

The most common audit finding in this area is an adjustment that reduced the prepayment balance without a corresponding credit note. Even if the accounting treatment was correct, the lack of documentation creates a problem.

Exporting the Schedule

CloseKit lets you export the full prepayment schedule as a CSV — including all active entries, their amortization history, remaining balances, and linked GL accounts. This is designed to be dropped straight into an audit workpaper file and sent to your auditors without any manual reformatting.