Last updated: 7 October 2026 · Independent buyer’s guide · We do not sell rankings or coverage.
Prepaid expense amortization is the monthly process of moving the cost of an advance payment, such as an annual insurance premium, from a prepaid asset account to expense over the period the payment covers. QuickBooks Online and Xero automate it only through recurring journal entries or third-party apps. NetSuite, Sage Intacct and Microsoft Dynamics 365 Business Central generate the schedule directly from the vendor bill.
Key takeaways
- Record the payment as a prepaid asset and expense it monthly over the coverage period. A daily method is most accurate for policies that start mid-month.
- Set a written materiality threshold. Published policies we reviewed use $1,000, $2,500 and $5,000.
- QuickBooks Online has no amortization schedule feature. Intuit says to use journal entries, which can recur when the amount is fixed.
- NetSuite, Sage Intacct and Business Central build the schedule from a template on the bill line, and NetSuite and Business Central can prorate partial months by days.
- Add-ons such as Accruer, Spread, Dext and Ramp generate the entries for QuickBooks Online or Xero. Accruer starts at $29 a month and Ramp Plus at $15 per user per month.
How prepaid expense accounting works
When you pay in advance for a benefit you will receive over future periods, you record an asset. You debit a prepaid expense account (a current asset if the benefit runs 12 months or less) and credit cash or accounts payable. Each month you then debit the relevant expense account, such as insurance or software, and credit the prepaid account for the portion that has been used up.
By the end of the coverage period the prepaid balance for that item should be zero. A refundable security deposit on a lease is different: it is not amortized and stays on the balance sheet until you get it back, so keep it in a separate account.
For US federal income tax, the 12-month rule in Treasury Regulation §1.263(a)-4(f) generally lets you deduct an amount paid for a benefit that does not extend beyond the earlier of 12 months after the benefit starts or the end of the following tax year (eCFR, up to date as of 5 October 2026). That rule does not change your GAAP books, where you still amortize over the coverage period.
Choosing an amortization method
Straight-line by month divides the total by the number of months covered, so a $12,000 annual policy starting 1 January costs $1,000 a month. When a policy starts mid-month, many companies book half a month in the first and last periods.
Daily (exact days) divides the total by the days covered and multiplies by the days in each month. Amounts vary slightly from month to month, but each month carries exactly the cost of its coverage. This is where spreadsheet formulas most often go wrong.
Materiality thresholds
GAAP does not set a dollar threshold for prepaid recognition, so each company decides what is too small to track. The College of Charleston reviews payments of $1,000 or more that cross fiscal years (College of Charleston, last reviewed 13 October 2020). The Idaho College of Osteopathic Medicine sets its threshold at $5,000 and expenses anything below that in the month paid (ICOM, last reviewed 6 January 2026). The College of the Holy Cross does not record prepaids under $2,500 (College of the Holy Cross, effective 1 April 2024). A business should likewise write its threshold down and agree it with its auditor.
What auditors check
Auditors usually start with a prepaid roll-forward showing the opening balance, additions, amortization and closing balance for each item. Thomson Reuters publishes an audit workpaper built on exactly these columns (Thomson Reuters, no date shown). An audit guide from the advisory firm EFPR Advisory adds invoice review, recalculation of the schedule, cut-off testing and review of unusual journal entries (EFPR Advisory, no date shown).
Worked example: a policy that starts mid-month
Illustration: a manufacturer pays a $14,400 annual general liability premium for coverage from 16 March 2026 to 15 March 2027 (365 days). All figures in this example are illustrative.
The daily rate is $14,400 divided by 365, or about $39.45 a day. The table compares the daily method with a half-month convention. Because the policy starts mid-month, a 12-month policy touches 13 accounting periods.
| Month | Days covered | Expense, daily method | Expense, half-month convention |
|---|---|---|---|
| Mar 2026 | 16 | $631.23 | $600.00 |
| Apr 2026 | 30 | $1,183.56 | $1,200.00 |
| May 2026 | 31 | $1,223.01 | $1,200.00 |
| Jun 2026 | 30 | $1,183.56 | $1,200.00 |
| Jul 2026 | 31 | $1,223.01 | $1,200.00 |
| Aug 2026 | 31 | $1,223.01 | $1,200.00 |
| Sep 2026 | 30 | $1,183.56 | $1,200.00 |
| Oct 2026 | 31 | $1,223.01 | $1,200.00 |
| Nov 2026 | 30 | $1,183.56 | $1,200.00 |
| Dec 2026 | 31 | $1,223.01 | $1,200.00 |
| Jan 2027 | 31 | $1,223.01 | $1,200.00 |
| Feb 2027 | 28 | $1,104.66 | $1,200.00 |
| Mar 2027 | 15 | $591.81 | $600.00 |
| Total | 365 | $14,400.00 | $14,400.00 |
The final daily amount includes a $0.03 rounding adjustment. At a 31 December 2026 year end, the prepaid balance is $2,919.48 under the daily method and $3,000.00 under the half-month convention. An $80.52 difference is immaterial for most companies, which is why many choose the simpler method.
The spreadsheet method and where it breaks
Most small and mid-sized finance teams keep the schedule in Excel or Google Sheets, with one row per invoice and a column per month, and key a journal entry from each month’s total. It works for a dozen items and becomes fragile as the list grows.
The failure points are predictable. A new invoice is coded straight to expense and never reaches the schedule. A formula is copied one row too far, or a mid-month start is treated as a full month. A policy is cancelled early and its row keeps amortizing. The schedule and the ledger are separate records, so the totals drift apart until someone notices at year end. Our guide to building a better accrual process covers the same discipline for accruals.
What accounting software does natively
QuickBooks Online
Intuit states directly that “amortization of debts and assets in QuickBooks Online will have to be done through manual transactions, such as checks and journal entries” (Intuit, checked 7 October 2026). You can select Make Recurring on the journal entry and save it as a template, which works when the monthly amount is identical. Recurring transactions can be scheduled to post automatically, set as reminders, or left unscheduled (Intuit, updated 5 August 2026). We found no native prepaid schedule in QuickBooks Online Advanced either. A recurring entry does not track the remaining balance, so daily-method amounts and early cancellations still need manual work.
List prices on Intuit’s US pricing page are $38 a month for Simple Start, $85 for Essentials, $140 for Plus and $340 for Advanced, before introductory discounts (Intuit, checked 7 October 2026).
Xero
Xero has no native prepayment schedule on bills. A Product Ideas request for amortization on bills is still open, with user comments continuing into 2026 (Xero Product Ideas, checked 7 October 2026). Xero’s own guide to prepaid expenses suggests setting up repeating journal entries so a monthly amortization schedule posts automatically each period (Xero, 8 August 2026). Those journals do not adjust for the number of days in each month: a February 2026 request comes from a user who spends about half a day each month updating more than a hundred recurring journals by hand for that reason (Xero Product Ideas, 7 February 2026). US list prices are $27 a month for Early, $59 for Growing and $97 for Established (Xero, checked 7 October 2026).
Oracle NetSuite
NetSuite’s Amortization feature generates a schedule when you save, or approve, a vendor bill whose line carries an amortization template. The schedule does not post by itself; you create the entries in a batch on the Create Amortization Journal Entries page (Oracle NetSuite Help, no date shown). Templates offer four straight-line variants, including straight-line by even periods, prorating the first and last period, and exact days, plus a custom method for uneven amounts (Oracle NetSuite Help, no date shown). BrokenRubik, a NetSuite partner, describes expense amortization as part of the Advanced Financials module (BrokenRubik, 28 February 2026). Oracle’s help pages describe the Amortization feature without naming a module, so confirm with your account manager which edition includes it. Oracle does not publish NetSuite list pricing.
Sage Intacct
Sage Intacct 2026 Release 3, dated 7 August 2026 (Sage Intacct, 2026 R3 Release Notes), added “Automate prepaid expense amortization” as an Early Adopter feature in Accounts Payable and Purchasing with no separate subscription. You apply a template with start and end dates to a bill, and the schedule entries then post to the general ledger automatically (Sage Intacct release notes, 2026 Release 3). Only the straight-line method is available outside France, and amortization is not supported on recurring bills or lines that use allocations. Templates set the schedule period and posting day (Sage Intacct Help, no date shown). A separate Prepaid Expense Amortization application is also documented as a Platform Services subscription (Sage Intacct Help, no date shown). We found no published list price for Sage Intacct.
Microsoft Dynamics 365 Business Central
Business Central uses deferral templates that you assign to a G/L account, item or resource, or set on a purchase invoice line. When you post the invoice, the expense is deferred to the periods set by the template. The methods are Straight-Line, Equal per Period, Days per Period and User-Defined, which covers both approaches in the example above (Microsoft Learn, last updated 1 October 2025). Microsoft lists Essentials at $80 and Premium at $110 per user per month, paid yearly (Microsoft, checked 7 October 2026).
| Product | Native prepaid handling | Partial months by days | Published US price |
|---|---|---|---|
| QuickBooks Online | Recurring journal entries only | No, calculate yourself | $38 to $340 per month |
| Xero | Repeating manual journals only | No, calculate yourself | $27 to $97 per month |
| NetSuite | Schedule from bill line template; entries created in batch | Yes, exact days or prorated first and last period | Not published |
| Sage Intacct | Schedule from bill or purchase transaction; posts automatically (Early Adopter) | Not documented; straight-line only | Not published |
| Business Central | Deferral template on purchase invoice line | Yes, Days per Period method | $80 or $110 per user per month |
Add-ons that automate prepaids
Accruer, from FinOptimal, reads the service period you type on a QuickBooks Online transaction, books every amortization entry and keeps a backup schedule. It costs $29 a month for up to 10 automated entries, $99 for up to 50 and $199 for unlimited, per QuickBooks file (FinOptimal, checked 7 October 2026). Spread, listed in the Xero App Store, reads the date range from a bill attachment and allocates the cost across months; the listing shows a free trial but no price (Xero App Store, checked 7 October 2026).
Dext offers prepayments for Xero, QuickBooks Online and MYOB, spreading cost by months or by days, and posts the full set of future monthly journals at once (Dext Help, no date shown). Ramp includes amortization in its Plus plan for card transactions, reimbursements and bill payments and posts scheduled journal entries to QuickBooks Online (Ramp Support, no date shown). Plus costs $15 per user per month plus a platform fee (Ramp, checked 7 October 2026). Ramp only helps if the prepaid is paid through Ramp.
BlackLine offers an amortization solution with pre-built templates that create schedules and post the related journal entries (BlackLine, no date shown). FloQast added amortization calculations to its AutoRec product in 2020 (FloQast, 11 August 2020), and its Journal Entry Management product creates and posts journals to the ERP, with integrations listed for NetSuite, Sage Intacct, Microsoft, SAP, Xero and Workday (FloQast, checked 7 October 2026). Numeric publishes a prepaid expense workpaper template and reconciliation tooling (Numeric, 10 March 2025); we could not confirm from its published material that it generates and posts amortization entries. None of these three publishes pricing. Our guide to automating the financial close explains where they fit in a wider close process.
Our independent take
Automation helps most when the schedule is created from the bill, because a prepaid then cannot be missed and the schedule always agrees with the ledger. NetSuite and Business Central do this natively and prorate partial months by days. Sage Intacct now does it too, but the feature was still marked Early Adopter in August 2026, so test it before relying on it at year end.
On QuickBooks Online or Xero, recurring journals automate the posting but not the schedule. With more than about 20 active prepaids, an add-on such as Accruer is likely to save more close time than it costs. With fewer, a spreadsheet tied to the trial balance each month remains a reasonable control.
Three buyer scenarios
A 25-person services firm on QuickBooks Online Plus with eight prepaids. Keep the spreadsheet, set a written threshold, and use recurring journal entries for equal monthly amounts. Reconcile the prepaid account to the schedule every month.
A 60-person distributor on Xero with 40 prepaids and an annual audit. Trial Spread or Dext so each schedule starts from the bill. Confirm with your auditor that the add-on’s report works as a roll-forward, and check how future-dated journals are reversed if a policy is cancelled.
A 200-person manufacturer moving from QuickBooks to an ERP. Ask NetSuite, Sage Intacct and Business Central partners to demonstrate a mid-month policy start, a cancellation and a year-end roll-forward. Our guide to the best accounting software for small business covers the wider selection.
When you do not need dedicated software for this
If you have fewer than 10 to 15 prepaids and equal monthly amounts, recurring journal entries plus a simple schedule are enough. An add-on’s fees and another integration to maintain may cost more than the hour a month the spreadsheet takes. Revisit the decision when the item count grows or your auditor raises findings on the prepaid account.
How we researched this
We reviewed the pages ranking for “prepaid expense amortization,” all published by vendors, then read each product’s documentation, checked US pricing pages on 7 October 2026, and reviewed published prepaid policies and audit materials. We did not test the products hands-on, and no vendor paid for or reviewed this article.
Related guides
- Standard Cost vs Actual Cost in Manufacturing: How ERP Handles Each and When to Switch
- The De Minimis Indirect Cost Rate: How Nonprofits Apply It and Track It in Their Accounting Software
- Schedule of Expenditures of Federal Awards (SEFA): How to Prepare It From Your Accounting System
- HVAC Service Agreement Software (2026): How to Choose, What It Costs and How Billing Works
Frequently asked questions
How do you calculate prepaid expense amortization?
Divide the total prepaid amount by the number of months in the coverage period to get the monthly expense. For more precision, divide by the number of days covered and multiply by the days in each month. Record each month’s amount as a debit to expense and a credit to the prepaid asset account.
Can QuickBooks Online automatically amortize prepaid expenses?
Not natively. Intuit says amortization must be done with journal entries, which you can set to recur when the amount is the same each month. For a schedule that calculates partial months and tracks remaining balances, you need an add-on such as Accruer or a spend platform such as Ramp.
What is a reasonable threshold for recording prepaid expenses?
There is no GAAP threshold, so each company sets its own. Published institutional policies we reviewed use $1,000, $2,500 and $5,000. Choose a level your auditor or outside accountant agrees is immaterial and apply it consistently.
How do you amortize an insurance policy that starts mid-month?
Either use the daily method, which charges each month for the exact days covered, or apply a half-month convention to the first and last months. A 12-month policy that starts on the 16th will touch 13 accounting periods either way. NetSuite and Business Central can calculate the daily method automatically.
Can I deduct a prepaid expense in the year I pay it?
For federal income tax, often yes, under the 12-month rule in §1.263(a)-4(f). It does not change your GAAP books, where you still amortize over the coverage period. Confirm the tax position with your tax adviser.
Sources
Every figure and claim in this article traces to one of these. Prices were checked on the date shown. Vendor sources sell the products they describe.
- eCFR, 26 CFR §1.263(a)-4, 12-month rule, up to date as of 5 October 2026. ecfr.gov
- College of Charleston, Prepaid Expenses policy, last reviewed 13 October 2020. charleston.edu
- Idaho College of Osteopathic Medicine, Prepaid Expense policy, last reviewed 6 January 2026. icom.edu
- College of the Holy Cross, Prepaid Expense Procedure, effective 1 April 2024. holycross.edu
- Thomson Reuters, Prepaid expenses roll-forward workpaper, no date shown. thomsonreuters.com
- EFPR Advisory, Prepaid Expenses Audit Guide, no date shown. efpradvisory.com
- Intuit, Does QuickBooks Online have an amortization schedule?, checked 7 October 2026. quickbooks.intuit.com
- Intuit, Create recurring transactions in QuickBooks Online, updated 5 August 2026. quickbooks.intuit.com
- Intuit, QuickBooks Online pricing, checked 7 October 2026. quickbooks.intuit.com
- Xero Product Ideas, Bills: deferred expenses and amortization, status updated 28 March 2022, checked 7 October 2026. productideas.xero.com
- Xero, Prepaid expenses: what they are and how to record them, 8 August 2026. xero.com
- Xero Product Ideas, Repeating manual journals: more frequency options, 7 February 2026. productideas.xero.com
- Xero, US pricing plans, checked 7 October 2026. xero.com
- Oracle NetSuite Help, Amortization Schedules, no date shown. docs.oracle.com
- Oracle NetSuite Help, Amortization Template Term Reference, no date shown. docs.oracle.com
- BrokenRubik (NetSuite partner), NetSuite Advanced Financials guide, 28 February 2026. brokenrubik.com
- Sage Intacct, 2026 R3 Release Notes, 7 August 2026. intacct.com
- Sage Intacct, 2026 Release 3: Automate prepaid expense amortization (Early Adopter), no date shown on the page. intacct.com
- Sage Intacct Help, Field descriptions: Amortization template, no date shown. intacct.com
- Sage Intacct Help, Prepaid Expense Amortization (Platform Services), no date shown. intacct.com
- Microsoft Learn, Defer revenues and expenses in Business Central, last updated 1 October 2025. learn.microsoft.com
- Microsoft, Dynamics 365 Business Central pricing, checked 7 October 2026. microsoft.com
- FinOptimal, Accruer product and pricing, checked 7 October 2026. finoptimal.com
- Xero App Store, Spread listing, checked 7 October 2026. apps.xero.com
- Dext Help, How to use prepayments in Dext, no date shown. help.dext.com
- Ramp Support, Use Ramp amortization with QuickBooks Online, no date shown. support.ramp.com
- Ramp, Pricing, checked 7 October 2026. ramp.com
- BlackLine, Amortization solution, no date shown. blackline.com
- FloQast, FloQast Adds Amortization to Automated Reconciliations Solution, 11 August 2020. floqast.com
- FloQast, Journal Entry Management, checked 7 October 2026. floqast.com
- Numeric, Perfecting Prepaid Reconciliation, 10 March 2025. numeric.io