A prepaid expense schedule is the working file that turns a one-time payment, a year of insurance, a software licence, a rent deposit, into a correct monthly expense over the months it actually covers. Get it wrong and your monthly profit swings for no real business reason; get it right and every month tells the truth. This free Excel template does the whole job: you type each prepaid in once, and it automatically builds the monthly amortization, the GL roll-forward, a ready-to-import journal entry, and a dashboard, recalculating instantly the moment you change the reporting month.
What you get: a formula-driven workbook with six working sheets. Add a prepaid once with its amount, start date and term; the file spreads the cost across the right months, splits the remaining balance into current and non-current for the balance sheet, and produces a balanced journal entry for whichever month you are closing. Free download below, no macros, works in Excel, Google Sheets and LibreOffice Calc.
Why every prepaid expense schedule needs to exist at all
Imagine you pay Rs 1,20,000 in April for a full year of insurance. If you expense the whole amount in April, your April books show a large cost that has nothing to do with April’s actual business activity, and the remaining eleven months show no insurance cost at all, even though you are covered every one of those months. Accounting standards fix this with the matching principle: record the expense in the month it benefits, not the month you paid for it. So the Rs 1,20,000 becomes an asset called Prepaid Expenses on 1 April, and Rs 10,000 moves out of that asset into the profit and loss statement each month for 12 months. That monthly movement is amortization, and a proper prepaid expense schedule is simply the working file that tracks every one of these movements, for every prepaid, at once. Doing it by hand across dozens of prepaids, every month, for years, is exactly the kind of repetitive work a spreadsheet should handle for you.
What is inside this prepaid expense schedule template
| Sheet | What it does | Do you edit it? |
|---|---|---|
| Dashboard | KPI tiles and charts: current prepaid balance, this month’s amortization, the current/non-current split, and a run-off chart. | No, read-only |
| Prepaid Schedule | The register. One row per prepaid; this is the only sheet you type into regularly. | Yes, blue cells |
| Amortization | The engine: one column per month across the full horizon, spreading each prepaid automatically. | No, automatic |
| GL Roll-Forward | Opening balance plus additions minus amortization equals closing balance, one row per month. | No, automatic |
| Journal Entries | A balanced Debit Expense / Credit Prepaid entry for the month you are closing, ready to import into Tally, Zoho Books, QuickBooks or Business Central. | No, automatic |
| Settings | Your control panel: company name, currency, reporting period, GL codes and the category-to-account map. | Yes, blue cells |
A worked example: one insurance premium, twelve months
Say your company pays HDFC Ergo Rs 1,20,000 on 1 April 2026 for a 12-month insurance policy. Here is exactly what happens when you type that one line into the Prepaid Schedule:
- You enter: Vendor HDFC Ergo, Category Insurance, Amount (excl. GST) Rs 1,20,000, Start Date 1 April 2026, Term 12 months, Method left blank (uses your default).
- The template calculates the End Date as 31 March 2027, using
EDATE(start, term) - 1so a 12-month term ends exactly 12 months later, not one day into a 13th month. - It looks up Insurance in your Settings GL map and auto-fills the expense account, GL code 6200, Insurance Expense, so you never have to remember or retype account codes.
- With the Monthly method, each of the 12 months gets exactly Rs 10,000 of amortization (Rs 1,20,000 divided by 12), visible as one column each on the Amortization sheet.
- Set the reporting period to July 2026 on Settings, and the line instantly shows This-Period Amortization: Rs 10,000, Amortised to Date: Rs 40,000 (April through July), and Remaining Balance: Rs 80,000.
- Because the whole 12-month term ends within 12 months of July, the entire Rs 80,000 remaining is classified Current; nothing is Non-current for this particular line.
- The Check column reads OK, confirming the 12 monthly charges sum to exactly Rs 1,20,000, no rounding leaks.
That is the entire manual effort: one row, six inputs. Everything from the End Date onward is calculated the moment you press Enter, and it recalculates again automatically the next month when you roll the reporting period forward.
Monthly vs Daily amortization, and when each one matters
Amount divided by Term, charged equally across each calendar month. Simple, and the right choice for most subscriptions and insurance policies that conceptually run in whole months.
Amount split by the exact number of days the prepaid covers in each month. Use it when a prepaid starts or ends mid-month and you want the first and last months to be smaller and more accurate.
Both methods land on the same total by the end of the term, they only differ in how the cost is spread month by month. You can set a global default on Settings and still override it per line, so a single workbook can mix both methods across different prepaids.
The current vs non-current split, explained
Financial statements under Schedule III separate assets into current (usable within 12 months) and non-current (usable beyond that). A prepaid asset is no exception. Take a 24-month software licence, Rs 2,40,000, paid on 1 January 2026. As of July 2026, six months have already been used (Rs 60,000 amortized), leaving Rs 1,80,000. Of that remaining balance, the next 12 months (roughly Rs 1,20,000) is current, and the last six months (roughly Rs 60,000) is non-current. The template recalculates this split for every line, every month, automatically, which is exactly the number your balance sheet notes need and exactly the calculation most people get wrong when doing this by hand in a hurry.
Categories and the GL map that ships with the template
Nine common categories come pre-mapped to expense accounts on the Settings sheet, so a fresh prepaid instantly knows which GL account it belongs to:
- Insurance → 6200 Insurance Expense
- Software / SaaS → 6310 Software Subscription Expense
- Rent → 6100 Rent Expense
- AMC / Maintenance → 6410 Repairs and Maintenance
- Professional Fees → 6500 Professional Fees
- Subscriptions → 6320 Subscriptions and Memberships
- Licenses → 6330 Licenses and Permits
- Marketing → 6600 Marketing and Advertising
- Others → 6900 Miscellaneous Expense
Every code and name is on the Settings sheet in plain cells, so renaming them to match your own chart of accounts takes a minute and updates every existing and future prepaid line automatically.
The four built-in checks that catch mistakes for you
| Where | Reads | What it is telling you |
|---|---|---|
| Prepaid Schedule → Check | OK | That line’s monthly charges sum exactly to its Amount. |
| Amortization → total row | TIES | Every line, added up, matches the grand total of all prepaid amounts. |
| GL Roll-Forward → Recon status | OK – ties to register | The closing balance matches what the register says should be remaining. |
| Journal Entries → total row | Balanced | Total debits equal total credits for the month’s entry. |
If any check ever flags red: it is almost always a missing Start Date, Term or Amount on one line. The template is built so a single bad row shows up immediately instead of quietly throwing off every total on the dashboard.
Running this prepaid expense schedule every month, in two steps
- On Settings, change the Current reporting period to the month you are closing.
- On Prepaid Schedule, add any brand-new prepaids from the month as new rows.
That is genuinely the entire monthly task. Amortization, balances, the current/non-current split, the journal entry, the roll-forward and the dashboard all recalculate the instant you change the period, because every sheet is linked by formula, not by copy-paste.
Posting the journal entry into your accounting system
The Journal Entries sheet produces a plain Debit Expense, Credit Prepaid Expenses entry for the selected month, already balanced, with a Date column and a Memo describing which prepaid it relates to. Copy the rows straight into Tally, Zoho Books, QuickBooks or Business Central, or hand them to whoever posts your journals. If you already use Zoho Books, our Zoho setup guide covers the wider month-end configuration; if you are automating accounts payable end to end, see our AP automation guide.
Who this prepaid expense schedule is built for
Any business with more than a handful of prepaid expenses: annual insurance, software licences, AMC contracts, professional retainers, rent deposits, subscriptions. If you currently track these in a note-to-self or recalculate them by hand each month, this prepaid expense schedule replaces that entirely, and if your accountant already maintains a similar spreadsheet, this saves them from rebuilding one from scratch.
Frequently asked questions
What is a prepaid expense, in simple terms?
A prepaid expense is money you have already paid for something you have not fully used yet, like a one-year insurance policy paid on day one. Because the benefit stretches across future months, accounting rules say you cannot expense the whole payment on day one. Instead you park it on the balance sheet as an asset called Prepaid Expenses, and move a slice of it into the profit and loss statement every month as you actually use the service. That monthly move is called amortization, and this template automates it.
Why can’t I just expense the whole payment when I pay it?
Because of the matching principle in accounting: an expense should be recorded in the period it benefits, not the period it was paid. If you expense a 12-month insurance premium entirely in April, your April profit looks artificially low and the rest of the year looks artificially high. Spreading it evenly (or by actual days) gives a true monthly picture, which is what lenders, auditors and your own management reports need.
What is the difference between the Monthly and Daily amortization methods?
Monthly (straight-line) divides the amount evenly across the term, in whole calendar months. Daily (pro-rata) divides it by the actual number of days the benefit covers in each month, which matters when a prepaid starts or ends mid-month. A subscription that starts on the 20th, for example, gets a smaller first month under Daily and a larger evenly-split first month under Monthly. Either method sums to exactly the same total by the end of the term.
Do I enter the amount including or excluding GST?
Excluding GST. Enter only the expense value, the amount you will actually charge to the profit and loss statement over time. The GST portion is input tax credit, claimed separately through your GST return, and is not part of the prepaid asset at all. Entering the gross invoice value by mistake is the single most common error with prepaid schedules.
What does the Current vs Non-current split mean?
It is a balance sheet classification required under Schedule III of the Companies Act (and equivalent standards elsewhere). The portion of a prepaid that will be used up within the next 12 months from your reporting date is a current asset; anything beyond 12 months is non-current. A 24-month software licence paid today, for example, is roughly half current and half non-current on day one, and the split shifts every month as time passes. The template computes this automatically for every line.
How many prepaid expenses can this template handle?
100 lines out of the box, and the workbook tells you if you need more (unprotect the Prepaid Schedule sheet, select the last row, and fill the formulas down; the roll-forward and dashboard pick up new rows automatically as long as the TOTAL row stays at the bottom).
Is this template free, and do I need to sign up?
The template is completely free. You do need a free reconscribe.com account to download it, the same as our other Excel tools; this just lets us keep the download link working and occasionally tell you about template updates. There is no payment and no trial period.
Related: Accounts payable template · Cash flow decision tool · AP automation guide · Task management for accountants