Browse Business Software Categories

A
B
C
D
E
F
H
I
M
N
P
R
S
W
Close  

Accounting

ERP

NetSuite Amortization Schedules: Templates, Prepaid Expense Setup and Journal Generation

Sherman Hsieh
Share This Post!
Published
NetSuite Amortization Schedules: Templates, Prepaid Expense Setup and Journal Generation

Last updated: October 16, 2026 · Independent guide · We do not sell rankings or coverage.

A NetSuite amortization schedule is a non-posting record that NetSuite generates when you save a vendor bill or vendor credit whose line carries an amortization template. The bill posts the full amount to a Deferred Expense account, the schedule lists what moves to expense in each period, and nothing reaches the general ledger until you run Create Amortization Journal Entries at month end. This guide covers setup, templates, the monthly run, catch-up entries and reconciliation.

Before you start

Step 1: Enable the Amortization feature

Go to Setup > Company > Setup Tasks > Enable Features, open the Accounting subtab, check Accounting Periods and Amortization, and click Save. NetSuite adds a default Deferred Expense account to the chart of accounts. Then confirm periods exist far enough ahead at Setup > Accounting > Manage Accounting Periods (NetSuite Help, no date shown).

NetSuite treats prepaid and deferred expense as the same thing and reports Deferred Expense accounts as Other Current Assets (NetSuite Help, no date shown).

Step 2: Set amortization preferences

Go to Setup > Accounting > Accounting Preferences and open the General subtab. The Amortization section holds these settings (NetSuite Help, no date shown):

  • Allow Users to Modify Amortization Schedule: lets users change unrecognized amounts after a schedule exists. You need it for the catch-up method in Step 7.
  • Default Amortization Journal Date To: Last Day of Period or Current Date.
  • Default Amortization Journal Entry Form: Standard Journal Entry or a custom form.
  • Number of Short-Term Expense Periods: how many monthly columns the Deferred Expense Waterfall shows, from 0 to 52, default 12.

Step 3: Decide where the deferral account comes from

A line cannot be amortized without a deferral account. NetSuite takes it from one of three places, and the template’s account takes precedence over the other two (NetSuite Help, no date shown):

Where Menu path and field Precedence
Amortization template Deferral Account on the template Highest
Item record Lists > Accounting > Items, Accounting subtab, Deferred Expense Account Item lines, when the template has none
Expense account record Lists > Accounting > Accounts, Deferral Account Expense lines, when the template has none

Changing a deferral account affects only new schedules.

Step 4: Build your amortization templates

Go to Lists > Accounting > Amortization Templates > New. Enter a name, choose the Type and Method, then set Term Source, Deferral Account, Target Account (Default uses the expense account on the transaction or item record), Amortization Period, and optionally Period Offset, Start Offset, Residual and Initial Amount (NetSuite Help, no date shown).

Standard templates and the straight-line methods

Standard templates offer four straight-line methods plus Custom (NetSuite Help, no date shown). Oracle’s own example spreads $400 from August 20 to December 19 across five periods (NetSuite Help, no date shown):

Method How it calculates August / December in Oracle’s example
Straight-line, by even periods Equal amount per period, no day proration $80.00 / $80.00
Straight-line, prorate first & last period First and last periods by days, middle periods equal $39.34 / $62.30
Straight-line, using exact days Every period by its own day count $39.34 / $62.30
Straight-line, prorate first & last period (period-rate) Full periods at a flat rate, partial periods as a fraction of that rate $38.71 / $61.29

Use even periods when coverage starts on the first of the month, and exact days for mid-month starts.

Custom and Variable templates

For uneven patterns choose the Custom method and add lines at the bottom of the template, each with an Account, a Period Offset (the first period is zero) and an Amount as a percentage or currency value. The Variable type is for percent-complete recognition on project service items, requires Project Management, and disables Method, Term Source, Amortization Period, offsets and Initial Amount (NetSuite Help, no date shown). Do not choose Variable for an ordinary uneven prepaid.

Step 5: Default templates on purchase items

If you buy prepaids through items, go to Lists > Accounting > Items, edit the item, set the Deferred Expense Account on the Accounting subtab, then set Amortization Template, Residual and Amortization Period on the Revenue Recognition / Amortization subtab. Only Non-Inventory, Other Charge and Service items for Purchase/Resale support amortization (NetSuite Help, no date shown). The template then defaults on bill lines, and AP can override it.

Step 6: Create schedules from vendor bills

Go to Transactions > Payables > Enter Bills. On the Expenses subtab, choose the expense account and amount, select a template in the Amort. Schedule column, enter the amortization start and end dates and any residual, click Add, then Save (NetSuite Help, no date shown). Both dates must fall in periods that exist, and neither can be earlier than the bill’s posting period.

NetSuite creates the schedule when the bill is saved, or on approval if bills use approval routing. You cannot create a schedule on a bill line that comes from a purchase order line with an accrual (NetSuite Help, no date shown).

Illustration: a $12,000 annual software subscription runs October 1, 2026 to September 30, 2027. With the even-periods template, the bill and each month’s journal post as follows.

Account Debit Credit Note
Prepaid Software (Deferred Expense) $12,000 Vendor bill, October
Accounts Payable $12,000 Vendor bill, October
Software Expense $1,000 Amortization journal, each month
Prepaid Software (Deferred Expense) $1,000 Amortization journal, each month

Step 7: Handle catch-up entries

Catch-up arises when a bill arrives after coverage has started. If a schedule’s start date is in a closed period, the amount for that period posts to the oldest open period (NetSuite Help, no date shown). On a bill, the start date also cannot precede the bill’s posting period.

Illustration: the same $12,000 subscription started October 1, but the bill is posted in December. Set the start date to December 1 and the end date to September 30, 2027, which gives ten periods at $1,200 under even periods. That understates October and November. With Allow Users to Modify Amortization Schedule on, go to Lists > Accounting > Amortization Schedules, click Edit, and change the December line to $3,000 and the nine later lines to $1,000 each. You cannot add lines, and lines must total the schedule amount (NetSuite Help, no date shown).

If you book a catch-up by manual journal instead, check Is Recognized on the schedule lines it covers. NetSuite then leaves those lines off the Create Amortization Journal Entries page (NetSuite Help, no date shown).

Step 8: Generate amortization journals at month end

  1. Go to Transactions > Financial > Create Amortization Journal Entries (NetSuite Help, no date shown).
  2. Select the Posting Period. In OneWorld, select the Subsidiary, and with Multi-Book Accounting, the Accounting Book. Both filters are required where they appear.
  3. Leave Select Individual Schedules cleared to create journals for every schedule due, and click Estimate to preview the count and amount. Check it to mark specific schedules into one journal.
  4. Check Approve Journal if your role can enter approved journals, then click Create Journal Entries.
  5. On the status page, click Refresh until Percent Complete reaches 100%, then open the Processed Schedules page and review the journals.

Oracle caps one run at 10,000 schedule entries (NetSuite Help, no date shown). For a dashboard prompt, add Amortization Entries Pending in the Reminders portlet through Set Up (NetSuite Help, no date shown).

Step 9: Reconcile the prepaid balance

Run Reports > Financial > Deferred Expense Waterfall after the journals post. Oracle states that the Summary report “reconciles the deferred expense account balance on the balance sheet and provides a forecast of the expected expense stream” (NetSuite Help, no date shown). Two columns flag problems:

  • Prior Unrecognized: amounts planned through the current period but not yet posted. It points to a missed or unapproved run.
  • Unplanned deferred expense: balances in no schedule, such as manual journals or bills coded to the prepaid account without a template.

Then run the Deferred Expense Rollforward report, which starts from the opening balance and shows the period’s activity to the ending balance. In OneWorld, Oracle says to run it for each subsidiary in its base currency (NetSuite Help, no date shown). Tie the ending balance to the trial balance and keep the report as support. Our general ledger reconciliation guide covers review and sign-off.

Common mistakes and how to fix them

  • Treating the schedule as posted. A schedule does not touch the GL (NetSuite Help, no date shown). Add the journal run and the waterfall check to the close checklist.
  • Bills coded to the prepaid account with no template. These land in Unplanned on the waterfall. Add the template to the line, or amortize the balance by manual journal with support.
  • No schedule on a PO-matched bill. Lines from purchase order lines with accruals cannot carry a schedule. Bill the prepaid portion on a separate expense line.
  • Editing the original bill to fix a prepaid. Oracle recommends changing expenses on purchase transactions with a vendor credit rather than editing the original transaction, which preserves the audit trail (NetSuite Help, no date shown).
  • System journals stuck in approval workflows. Create a custom journal form, set it as the Default Amortization Journal Entry Form, and have your administrator exclude that form from the workflow (NetSuite Help, no date shown).

Limitations of the native feature

The help pages we reviewed document no automatic journal run, so someone runs the page each period. Schedule lines cannot be added, and the edit preference is a single company-wide accounting preference. Foreign currency schedules are limited to U.K. editions (NetSuite Help, no date shown). In Multi-Book accounts, a primary book change does not flow to secondary books, which you update only through the Update Amortization button on the bill (NetSuite Help, no date shown).

When companies add a third-party tool

Some add-ons feed NetSuite’s own engine rather than replace it. Brex, which sells spend management, lets you attach an imported NetSuite template with start and end dates to a bill or expense and exports those details to NetSuite, which then amortizes the transaction under that template. Brex notes that expenses must use the Journal Entry export type for this to work, because NetSuite does not support amortization on expenses exported as credit card transactions (Brex support, no date shown). Close tools take over more of the process. Netgain’s NetClose runs an Amortizations module as a NetSuite SuiteApp and its documentation covers catch-up journals for start dates backdated into earlier months (Netgain support, no date shown; Netgain sells the product). A NetSuite implementation partner can configure either route.

How we researched this

We worked from Oracle’s NetSuite help topics on expense amortization, checked on October 16, 2026, and used only menu paths printed there. We also reviewed the top results for “netsuite amortization schedule,” including pages from Steltix, SixLakes Consulting, Houseblend, Zone & Co and Kolleno. Most sell NetSuite services, and few cover catch-up or reconciliation. We have no commercial relationship with Oracle NetSuite or any vendor named here.

Related guides

Frequently asked questions

Why didn’t my vendor bill create an amortization schedule?

The usual causes are a missing template on the line, no deferral account on the template, item or expense account, a bill still awaiting approval, or a line that comes from a purchase order line with an accrual. Schedules are created when the bill is saved, or on approval when approval routing is on.

How do I amortize a prepaid unevenly in NetSuite?

Create a Standard template with the Custom method and add one line per period with its offset and amount. The Variable type is for percent-complete recognition on project service items, so it is not the right choice for an ordinary uneven prepaid.

What happens if the amortization start date is in a closed period?

NetSuite posts the amount that would have been recognized in the closed period to the oldest open period. Expect that month’s expense to run above normal.

Which report reconciles the prepaid balance?

The Deferred Expense Waterfall Summary report ties to the deferred expense balance on the balance sheet and shows unposted and unplanned amounts. The Deferred Expense Rollforward report shows the opening balance, the period’s activity and the ending balance, which makes it suitable reconciliation support.

Sources

Oracle NetSuite help pages show no publication date; we checked each on October 16, 2026. Vendor sources that sell the product are marked.

  • Oracle NetSuite Help, Expense Amortization, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Setup for Amortization, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Enabling the Amortization Feature, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Setting Amortization Preferences, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Specifying Deferral Accounts for Amortization, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Creating Amortization Templates, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Amortization Template Term Reference, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Straight-Line Amortization Method Examples, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Setting an Amortization Template on an Item Record, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Associating Amortization Templates with Expenses, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Amortization Schedules, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Viewing an Amortization Schedule, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Editing an Amortization Schedule, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Generating Amortization Journal Entries, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Approving an Amortization Journal Entry, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Setting Up a Reminder for Amortization Journal Entries, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Deferred Expense Waterfall Summary Report, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Deferred Expense Rollforward Report, no date shown. docs.oracle.com
  • Oracle NetSuite Help, Expense Amortization Schedules in Multi-Book Accounting, no date shown. docs.oracle.com
  • Oracle NetSuite, Advanced Financials data sheet, copyright 2025, no date shown (vendor). netsuite.com
  • Brex, Amortization for NetSuite, no date shown (vendor; sells spend management). brex.com
  • Netgain, NetClose Amortizations Tips and Troubleshooting, no date shown (vendor; sells the product). support.netgain.tech

Sherman Hsieh

CEO & Editor-in-Chief, Business-Software.com
Independent analysis of enterprise software — ERP, CRM and more
Sherman Hsieh is the founder, CEO, and editor-in-chief of Business-Software.com. He leads the site's independent, buyer-focused coverage of ERP, CRM, and other business systems, including vendor-neutral comparisons, pricing analysis, and implementation guidance. Before founding Business-Software.com, Sherman was an executive at Siebel ...

Users Who Read This Article Also Read