Accruals & Prepayments Schedule – Excel Template

Spread annual and multi-month costs over the right months: monthly expense, expense to date and the accrual or prepayment balance at month end.

• Automatic summary: Prepayments (asset), Accruals (liability), Expense for this month
• Calculated for you: Months, Monthly expense, Months to date, Expense to date, Balance at month end
• Drop-down menus for quick, consistent entry
• Example rows and a step-by-step "How to Use" sheet

Instant download (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.