Rounding Robin

Home › Templates › Prepaid Expense and Accrual Schedule Template

Prepaid Expense and Accrual Schedule Template

Two linked schedules: prepaid expenses amortized evenly over their coverage period, and accrued expenses measured at period end. Each produces its own journal entry and reconciliation.

Download the Excel template

Free. Excel .xlsx format, no macros, no registration.

Contents

TabPurpose
InstructionsPurpose, steps, a guide to each tab, the colour key and a list of every built-in check with its result.
InputsPeriod end, general ledger balances and a summary.
Schedule - PrepaidsCoverage period, monthly expense, expensed to date, remaining balance, and the current and long-term split.
Schedule - AccrualsAmount accrued at period end and at the prior period end, with the change as the expense for the month.
Journal EntryPrepaid amortization entry and accrual entry, by expense account.
ReconciliationPrepaid and accrued balances compared with the general ledger after the entries.
ListsExpense accounts and balance sheet accounts.

Features

Instructions

  1. On the Lists tab, set your expense accounts.
  2. Enter each prepaid item with its coverage dates and amount.
  3. Enter each accrual with the amount owed at period end and at the prior period end.
  4. Post both entries from the Journal Entry tab.
  5. Confirm both reconciliations show OK.

Notes

The first and last months of a coverage period are treated as full months.

Related calculators

More accounting templates

Need a version built for your process? Request a custom template quote.

To report an error or request a calculator or template, send feedback.

Templates are provided for general information. They are not accounting, tax or legal advice. Review the formulas and results before relying on them.