Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceAccounting & BookkeepingFinancial CloseAccrual and Prepayment Schedule

SpreadsheetFinancial CloseFree

Accrual and Prepayment Schedule

Amortise prepaid expenses month by month, track accruals and their reversal, and get the month-end journal ready to post.

Shown with sample data

Colour

Accrual and Prepayment Schedule

Amortise prepaid expenses month by month, track accruals and their reversal, and get the month-end journal ready to post.

Prepaid balance at period end
$28,686
Agree to the trial balance
Released this month
$9,224
Fully released
1
Accrued this month
$14,132
Net true-up so far
$825
Invoices minus estimates
Difference
$0
Must be zero
Prepaid balance by item
  • Annual audit retainer$8,750
  • Trade show booth, March 2027$6,500
  • Warehouse rent, Q4$6,200
  • Accounting software (annual)$3,591
  • Business insurance (annual)$3,400
  • Design tools (annual licences)$245
Month-end debits by account
  • Contractors$6,920
  • Rent$6,200
  • Professional fees$4,750
  • Freight$1,860
  • Utilities$1,240
  • Insurance$1,130
  • Software$644
  • Interest$612

How to use it

  1. 1On Settings, type the period-end date you are closing (the last day of the month).
  2. 2Add each prepaid invoice with its amount, the first month of service and the number of months it covers.
  3. 3Add each accrual for costs incurred this month with no invoice yet, with the basis for the estimate.
  4. 4Post the Month-end journal: expense debits against prepaid expenses and accrued liabilities.
  5. 5When an accrued invoice arrives, enter it so the true-up difference is visible, then roll Settings to the next month.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Prepayments and accruals are what turn cash accounting into accrual accounting. List each prepaid invoice with its service period; the schedule calculates the monthly release, the amount expensed to date and the balance left on the balance sheet. Record accruals for costs incurred but not yet invoiced, track their reversal date and true-up, and read off the month-end journal with a balance check.

Who it’s for

  • Monthly close for annual insurance, software and rent paid in advance
  • Accruing utilities, professional fees and goods received not invoiced
  • Supporting balance sheet reconciliations for prepaid and accrued accounts

What’s included

  • Prepayments sheet: Each prepaid invoice with its monthly release and remaining balance.
  • Accruals sheet: Costs incurred this month with no invoice yet, and their true-up.
  • Month-end journal sheet: The entry to post at month end.
  • Settings sheet: The month you are closing.

How to use it

  1. 1On Settings, type the period-end date you are closing (the last day of the month).
  2. 2Add each prepaid invoice with its amount, the first month of service and the number of months it covers.
  3. 3Add each accrual for costs incurred this month with no invoice yet, with the basis for the estimate.
  4. 4Post the Month-end journal: expense debits against prepaid expenses and accrued liabilities.
  5. 5When an accrued invoice arrives, enter it so the true-up difference is visible, then roll Settings to the next month.

Tips

  • Agree the prepaid balance on this schedule to the prepaid expenses account in the trial balance every month.
  • Set a materiality threshold (for example $1,000) below which small prepayments are expensed straight away.
  • Reverse accruals on the first day of the next month and book the actual invoice when it arrives; the difference shows how good your estimates are.

Questions

What is the difference between an accrual and a prepayment?

An accrual records an expense you have incurred but not yet been invoiced for (a liability). A prepayment is an expense you have paid for in advance (an asset) and release to the income statement over the months it covers.

How is the monthly release calculated?

Straight line: invoice amount ÷ number of months. The final month releases whatever is left so the balance ends at exactly zero.

What journal entry releases a prepayment?

Debit the expense account (for example insurance expense) and credit prepaid expenses with the monthly release.

Related searchesprepaid expense scheduleprepayment amortization scheduleaccrual scheduleaccruals and prepaymentsprepaid amortization excelmonth end accruals

Details

Format
Spreadsheet
Category
Financial Close
Sheets
4
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetFinancial CloseFree

Accrual and Prepayment Schedule

Amortise prepaid expenses month by month, track accruals and their reversal, and get the month-end journal ready to post.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Financial Close
Sheets
4
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More financial close templates

View all
Month-End Close Checklist2 sheets

Close complete

36%

In progress

2

Blocked

1

ABCD
1CategoryTaskOwnerDue (working day)
2CashReconcile all bank and card accountsMia2
3CashPost bank charges and interestMia2
4ReceivablesIssue all invoices for the monthTom1
5ReceivablesReview aging and update bad-debt provisionTom3
Close tasks
SpreadsheetFinancial Close

Month-End Close Checklist

Close tasks by area with owners, due day, status and a completion score for the close.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ