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.
Free. Excel .xlsx format, no macros, no registration.
Contents
| Tab | Purpose |
|---|---|
| Instructions | Purpose, steps, a guide to each tab, the colour key and a list of every built-in check with its result. |
| Inputs | Period end, general ledger balances and a summary. |
| Schedule - Prepaids | Coverage period, monthly expense, expensed to date, remaining balance, and the current and long-term split. |
| Schedule - Accruals | Amount accrued at period end and at the prior period end, with the change as the expense for the month. |
| Journal Entry | Prepaid amortization entry and accrual entry, by expense account. |
| Reconciliation | Prepaid and accrued balances compared with the general ledger after the entries. |
| Lists | Expense accounts and balance sheet accounts. |
Features
- Handles 80 prepaid items and 60 accruals across 20 expense accounts.
- Separates prepaid balances into amounts expensed within 12 months and long-term.
- A data check on every row identifies missing amounts, dates and accounts.
- The accrual method records the change in the balance, so prior accruals reverse automatically.
- Both journal entries list only the lines that have an amount.
- Both reconciliations start from the ledger balance before the entry.
Instructions
- On the Lists tab, set your expense accounts.
- Enter each prepaid item with its coverage dates and amount.
- Enter each accrual with the amount owed at period end and at the prior period end.
- Post both entries from the Journal Entry tab.
- Confirm both reconciliations show OK.
Notes
The first and last months of a coverage period are treated as full months.
Related calculators
- Prepaid Expense Amortization CalculatorCalculate the monthly expense, the amount recognized to date and the remaining prepaid balance for a cost paid in advance.
- Accrued Interest CalculatorCalculate interest accrued on a loan or note for a number of days, on a 365-day or 360-day basis.
More accounting templates
- Depreciation Schedule TemplateFixed asset register with monthly depreciation, disposals, roll-forwards by class, journal entries and general ledger reconciliation.
- Loan Amortization Schedule TemplatePayment-by-payment amortization with extra principal, journal entries for payment, accrued interest and the current portion, and a lender reconciliation.
- Bank Reconciliation TemplateTwo-sided bank reconciliation with outstanding items, book adjustments and the adjusting journal entry.
- Month-End Close Checklist TemplateClose checklist with owners, business-day due dates and status, a recurring entry register and an account reconciliation tracker.
- Accounts Receivable Aging TemplateInvoice-level aging with customer totals, allowance calculation, journal entry and control account reconciliation.
- 13-Week Cash Flow Forecast TemplateWeekly receipts and disbursements for one quarter, with closing cash, minimum balance alerts and forecast-to-actual tracking.
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.