Accruals & Prepaids Tracker (2026)

1Tell us where to send it
Your name and work email — nothing more.
2Check your inbox
Your tracker arrives in seconds, not days.
3Use it with your team
Editable and ready to share — make it your own.

A peek inside

See exactly what you're getting

Free Excel template

Spotsaas · 2026

Accruals & Prepaids Tracker

✓ Instructions

✓ Prepaid Schedule

✓ Accrual Schedule

✓ Summary

Get the tracker →

What it is

The Accruals & Prepaids Tracker is a working schedule for the two adjusting entries that trip up almost every close: prepaid expenses and accrued expenses. Prepaids are costs paid up front, insurance, annual software plans, rent, that must be expensed gradually under the matching principle. Accruals are costs already incurred, utilities used, services received, interest owed, that have not been invoiced yet but still belong in the current period. Enter each item once and the tracker does the rest of the math.

The workbook has four tabs. On the Prepaid Schedule tab you enter each prepaid's description, total paid, term in months, and months elapsed; the sheet computes monthly straight-line amortization, the expense recognized to date, the remaining asset balance, and the current-period expense. On the Accrual Schedule tab you enter each accrued expense, the amount owed for the period, and whether it reverses next period. The Summary tab rolls everything into the exact journal entries you need to post, debit expense and credit prepaid assets for amortization, debit expense and credit accrued liabilities for the accrual, with the reversing portion backing out automatically next period.

Beyond the calculations, the tracker is pre-filled with realistic sample rows, general liability insurance, an annual SaaS subscription, prepaid rent, a three-year software license, accrued payroll, unbilled legal fees, a bonus accrual, that show exactly how to use it. An editable materiality threshold on the Summary tab lets you flag small items that can be expensed immediately rather than scheduled, so you do not waste effort tracking immaterial amounts.

What it's used for

Accruals and prepaids are where accrual-basis accounting actually lives, and they are the entries most likely to be missed or mishandled at close. This tracker is used to schedule them correctly and produce ready-to-post journal entries.

✓ Amortizing prepaid expenses straight-line across their term so each period bears its fair share of the cost
✓ Tracking the remaining prepaid asset balance that belongs on the balance sheet at period-end
✓ Accruing incurred-but-unbilled expenses so they hit the correct period under the matching principle
✓ Marking accruals that reverse next period so the eventual invoice does not double-count
✓ Producing the exact debit-and-credit journal entries to post for amortization and accruals each close
✓ Applying a materiality threshold so small items get expensed immediately instead of scheduled
✓ Keeping an auditable schedule that ties prepaid and accrued balances back to their source items

Who uses it

Adjusting entries are the domain of the accounting team. This tracker is built for the people who prepare them and the people who review and rely on them.

Staff and senior accountantsThey prepare the prepaid amortization and accrual entries each close and need a clean schedule to work from.

ControllersThey review the adjusting entries for completeness and ensure the matching principle is applied consistently.

BookkeepersThey maintain the schedule month to month, adding new prepaids and accruals as costs arise.

CFOs and finance managersThey rely on properly matched expenses for an accurate P&L and balance sheet that reflect true period performance.

AuditorsThey request prepaid amortization schedules and accrual support, and recompute them, so a clean tracker speeds fieldwork.

Outsourced accounting firmsThey use a standardized tracker to manage adjusting entries consistently across many clients.

Context & good to know

Prepaids and accruals exist because of the matching principle, the rule that expense should be recognized in the period the benefit is consumed, not when cash changes hands. Pay a year of insurance up front and you have not incurred a year of expense on day one; you have bought an asset that gets consumed one month at a time. The tracker enforces this by amortizing the prepaid straight-line over its term, moving a slice from the balance sheet to the P&L each period and leaving the remaining asset balance where it belongs.

Accruals run the opposite direction. The cost has already been incurred, you have used the electricity, received the contractor's work, racked up the loan interest, but no invoice has arrived. Leaving it out understates expense and overstates profit for the period. The accrual entry debits the expense and credits accrued liabilities to put the cost where it belongs, and the tracker's Summary tab assembles this entry automatically from the items you enter.

The reversing-entry mechanic is what keeps accruals from causing double-counting. Most accruals are estimates booked because the real invoice has not arrived. When that invoice does arrive next period, you record it normally, so if the accrual were still on the books you would count the cost twice. Marking an accrual to reverse means it backs out automatically at the start of the next period, leaving the actual invoice to stand alone. The tracker handles this by computing the reversing portion separately, and most accruals, utilities, unbilled fees, payroll, interest, should reverse.

The materiality threshold is a practical convenience that keeps the tracker from becoming busywork. Not every prepaid is worth amortizing; a small annual subscription may be immaterial enough to expense in full when paid. Setting a threshold on the Summary tab lets you flag items below it for immediate expensing rather than scheduling, which keeps your effort focused on the prepaids and accruals that actually move the financial statements. The discipline these schedules enforce is exactly what auditors look for, since they routinely request and recompute prepaid amortization and accrual support during year-end fieldwork.

✓ Independent · vendors can't pay to rank

Built on verified data, not vendor spin

Every Spotsaas resource draws on the Spotsaas Score — a blend of verified review ratings, review volume, and feature depth across 171 accounting software tools. Refreshed regularly; data as of June 2026.

FAQ

Questions, answered

What's the difference between a prepaid expense and an accrued expense?

A prepaid expense is a cost you paid in advance, like annual insurance or a SaaS subscription, that gets expensed gradually as the benefit is consumed. An accrued expense is a cost you have already incurred, like utilities used or interest owed, that has not been invoiced yet but still belongs in the current period. Prepaids start as assets; accruals start as liabilities.

What is the matching principle?

The matching principle says expenses should be recognized in the same period as the benefit they provide or the revenue they help generate, regardless of when cash moves. It is the reason prepaids are amortized over time and accruals are booked before the invoice arrives. This tracker exists to apply that principle correctly each close.

How does straight-line amortization of a prepaid work?

You divide the total amount paid by the term in months to get a monthly amortization figure, then expense that amount each period until the prepaid is fully consumed. For example, a $12,000 annual insurance policy amortizes at $1,000 per month. The tracker computes the monthly amount, expense-to-date, and remaining asset balance automatically.

What is a reversing journal entry and which accruals need one?

A reversing entry automatically backs out an accrual at the start of the next period, so when the real invoice arrives you record it normally without double-counting the cost. Most accruals, utilities, unbilled fees, payroll, and interest, should reverse. A few, like a multi-month bonus accrual you will draw down, may not. The tracker lets you mark each one.

What journal entries does this tracker produce?

Three. For prepaid amortization: debit expense, credit prepaid assets, for the period's amortization. For the accrual: debit expense, credit accrued liabilities. And the reversing entry next period: debit accrued liabilities, credit expense. The Summary tab assembles all three with the correct amounts from the items you enter.

What is a materiality threshold and how do I set it?

A materiality threshold is the dollar level below which an item is too small to bother scheduling, so you simply expense it when paid rather than amortizing or accruing it. You set it on the Summary tab. It keeps your effort focused on items that actually move the financials, instead of tracking a tiny subscription month by month.

Why do accruals matter for accurate financial statements?

Without accruals, expenses that were incurred but not yet billed are left out, which understates costs and overstates profit for the period. Accrual accounting paints the true picture of a period's performance by recognizing expenses when incurred. Skipping accruals is one of the most common ways month-end statements end up misleading.

Can my accounting software handle accruals and prepaids automatically?

Many accounting platforms support recurring journal entries and some include prepaid amortization schedules, which automates much of this. A spreadsheet tracker gives you a clear, auditable view and full control over assumptions. You can compare accounting platforms with built-in amortization and accrual features on Spotsaas.

What typically counts as a prepaid versus an accrual?

Typical prepaids include insurance, annual software or SaaS plans, rent, maintenance contracts, and licenses, anything paid up front and consumed over time. Typical accruals include utilities, unbilled professional fees, payroll earned but not yet paid, loan interest, and bonuses, costs incurred but not yet invoiced. The tracker is pre-filled with examples of each.

Where do prepaid and accrued balances show up on the financial statements?

The remaining prepaid asset sits on the balance sheet as a current (or sometimes long-term) asset, while accrued liabilities sit on the balance sheet as current liabilities. The period's amortization and accrual amounts both hit the income statement as expense. The tracker's Summary tab reports each of these figures for you.

Keep exploring