calculate-loan

01 Loan payments

Prepayment Schedule for Audit: What It Shows

Guide 01-19010 · Updated · Step by step

A prepayment schedule for audit is a period-by-period record of payments made before the related goods or services are received, showing the opening balance, additions, amounts recognized as expense, and closing balance. It helps reconcile the general ledger to supporting documents and assess whether prepaid amounts are valid, properly valued, and recorded in the right periods.

What a Prepayment Schedule Contains

Prepayments are amounts paid in advance for benefits expected in a later period—for example, annual insurance, rent, software subscriptions, or maintenance contracts. Until the benefit is received, the unexpired portion is generally presented as an asset under the applicable accounting framework. As time passes or services are delivered, that portion is recognized as an expense or another appropriate account.

A useful schedule links each balance to its source and explains how it changes. Common columns include:

  • Vendor, contract, invoice number, and a brief description of the purchase.
  • Payment date, service start and end dates, and the total amount paid.
  • Opening prepaid balance, current-period additions, expense recognized, and closing balance.
  • Allocation method, such as straight-line by month or recognition based on actual service delivery.
  • General-ledger account, currency, preparer, review status, and document references.

Not every organization needs every column. The schedule should nevertheless let a reviewer trace the reported balance to evidence and reproduce the calculation.

How the Schedule Works

For a straightforward time-based prepayment, calculate the amount that relates to the period under review and leave the unexpired portion as an asset. A basic roll-forward is:

Closing prepaid balance = opening balance + qualifying additions − amounts recognized or otherwise removed.

Consider a $12,000 insurance premium paid on October 1 for 12 months of coverage. If coverage is provided evenly and the accounting period ends December 31, three months have elapsed. The expense for those months is $3,000 ($12,000 ÷ 12 × 3), and the remaining prepaid balance is $9,000. This example assumes the policy began on October 1, runs for exactly 12 months, and is recognized evenly; actual contract terms and accounting policies may require a different calculation.

In the ledger, a payment may initially be recorded as a debit to prepaid insurance and a credit to cash or accounts payable. A period-end adjustment then debits insurance expense and credits prepaid insurance for the portion consumed. The schedule should agree with those entries, not merely calculate an expected figure in isolation.

Preparing It for an Audit

Preparation usually begins with the general-ledger balance and a complete listing of prepaid items. The preparer checks whether additions and releases are included in the correct period, then matches material items to invoices, contracts, payment evidence, and service dates. A reviewer should be able to follow the calculation from the source document through the schedule to the ledger and financial-statement balance.

  1. Obtain the account detail and reconcile its ending balance to the trial balance.
  2. List each individual prepayment, including opening items and new payments.
  3. Inspect the underlying invoice or agreement to establish what was purchased and when the benefit begins and ends.
  4. Recalculate the amount recognized through the reporting date using the stated basis.
  5. Investigate old, negative, unusually large, or fully consumed items that remain on the schedule.
  6. Document proposed adjustments, approval, and the final tie-out to the ledger.

Auditors may select items for testing based on their procedures and materiality. A well-organized schedule supports that work, but it does not by itself prove that a contract is valid, a payment occurred, or the accounting treatment is appropriate. Evidence and professional judgment remain necessary.

Evidence and Audit Checks

Supporting evidence depends on the item. It may include a signed contract or policy, supplier invoice, proof of payment, renewal notice, service-period details, or correspondence about cancellation or refunds. For services spanning periods, the agreement should make the coverage dates and nature of the service understandable. Evidence should be retained in a way that connects it to a distinct schedule line.

Common checks include agreeing totals to the ledger, recalculating allocations, verifying dates, and checking whether the reported balance represents a future benefit at the reporting date. Auditors may also consider whether costs are properly classified, whether any amount should be expensed sooner, and whether a balance requires adjustment because the service was canceled, the contract changed, or recovery is uncertain. The exact procedures depend on the engagement and applicable accounting framework.

Common Errors and Misconceptions

A frequent mistake is dividing a payment by 12 without checking the actual coverage period. A contract might begin mid-month, cover a different number of months, or provide services unevenly. Another error is treating the invoice date, payment date, and service commencement date as interchangeable; they can be different and serve different purposes in the analysis.

  • Leaving expired items on the schedule: Confirm that each balance has remaining coverage or another documented basis.
  • Missing additions or releases: Reconcile the schedule’s movement to account activity and investigate differences.
  • Using inconsistent rounding: Apply a clear method and ensure line-level rounding does not create an unexplained difference to the ledger.
  • Netting unrelated items: Preserve enough detail to identify each contract and explain unusual credit or negative balances.
  • Assuming every advance is a prepayment: Deposits, refundable amounts, inventory, and other advances may need different classification based on their substance and the applicable framework.

A schedule is not a substitute for an accounting-policy decision. It records and supports the treatment; it cannot make an incorrect classification correct merely because the arithmetic adds up.

Format, Review, and Recordkeeping

A spreadsheet is often sufficient for a modest number of items if formulas are controlled, source references are preserved, and changes can be reviewed. Larger volumes may be managed through accounting software or a controlled subledger. Whatever the format, use consistent date conventions, clearly label currencies, protect formula cells where appropriate, and retain a record of who prepared and reviewed the schedule.

Useful quality controls include an automated check that opening balance plus additions less releases equals closing balance, a comparison of the closing total with the ledger, and a listing of items whose end dates have passed. Keep both the calculation and the evidence available under the organization’s document-retention procedures. Avoid overwriting prior-period schedules when doing so would remove the audit trail; use dated versions or another controlled method.

Frequently Asked Questions

What is a prepayment schedule for audit?
A detailed listing and roll-forward of costs paid in advance, showing how each amount is supported, allocated to periods, and reconciled to the recorded balance.

Is a prepayment schedule the same as a prepaid expense schedule?
The terms are often used for the same kind of working paper. Organizations may use “prepayment” more broadly, so check whether their schedule also includes advances or deposits that require separate classification.

How do I calculate the prepaid balance at year-end?
Start with the supported amount paid, determine the portion relating to service received by year-end under the applicable method, and subtract that recognized portion. Confirm dates and contract terms rather than assuming all items run evenly by month.

What documents should support a prepayment?
Typically, retain the relevant invoice or agreement, evidence of payment where applicable, dates showing the service period, and the calculation or accounting entry that explains the balance.

Can a spreadsheet be used for an audit schedule?
Yes, a spreadsheet can present the information, provided it is complete, accurate, traceable to source evidence, reconciled to the ledger, and subject to suitable review and version controls.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this section

The whole Loan payments section →