Accrual Prepayment Schedule preview
Monthly accrual and prepayment schedule for FY2026 with type, supplier, total amount, and twelve-month amortization columns. 1/4

About this accrual prepayment schedule spreadsheet template

This accrual prepayment schedule template helps finance teams and accountants systematically track prepayments and accruals across a full fiscal year. Built around four interconnected sheets — Schedule, Register, Dashboard, and Lists — it covers the complete workflow from monthly amortization entries and counterparty details to summary dashboards and internal control documentation.

The Schedule sheet maps each entry by type (prepayment or accrual), supplier, total amount, and start month, then spreads the recognition across twelve monthly columns. The Register adds deeper tracking with opening balances, YTD recognized amounts, closing balances, review notes, and owner assignments. The Dashboard distills everything into a clean monthly summary, while the Lists sheet documents control rules, risks, evidence, and required actions for audit readiness.

Every cell, label, and formula is fully editable in WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers. Replace the sample entries with your own contracts, invoices, and estimates to build a tailored month-end close tool.

4 interconnected sheets

Schedule, Register, Dashboard, and Controls sheets work together for end-to-end accrual and prepayment tracking.

Monthly amortization layout

Twelve-month columns with automatic recognition spread make it easy to plan and review the full fiscal year.

Dashboard summary view

At-a-glance monthly totals for prepayments and accruals help you monitor balances and spot trends quickly.

Standard XLSX format

Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers without conversion.

Frequently asked questions
The Accrual Prepayment Schedule template is designed for tracking monthly accruals and prepayments, managing amortization schedules, and supporting month-end close processes. Customize the sample entries, amounts, and dates in WPS Office for your own accounting workflows.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the structure and data in a Notion database; for branded financial reports, adapt the content in Adobe Express.
Download the template, open it in WPS Office, and replace the sample entries, supplier names, amounts, dates, and other editable cells with your own financial data.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for month-end close processes, audit preparation, budget tracking, and financial control documentation. It is available for personal and commercial projects, subject to the applicable template license.