How to Migrate Partially Amortized Prepaids into NetSuite

Move in-flight prepaid expenses into NetSuite at go-live with one journal that builds amortization schedules for only the remaining balance and months.

The quick answer

Don't re-enter the original bills. Let the opening trial balance put the unamortized amount in your prepaid account, then enter one journal dated at cutover. For each prepaid, debit the expense account for the remaining amount with the vendor in Name, an amortization template in Schedule, and the months left in Start Date and End Date. Credit the prepaid account for the same amount. When you save, NetSuite posts each scheduled debit to the deferral account instead of expense, so the journal nets to zero, and builds an amortization schedule for each debit line that covers only the remaining periods.

A bill for the full contract would post the original amount again and amortize months your old system already expensed. Leaving the balance in the trial balance alone keeps the ledger right, but then nothing in NetSuite will ever recognize it, and someone ends up posting monthly journals by hand. The scheduling journal fixes that without touching the balance.

The screenshots show sample data. Person and operating-company names are fictional. Use your own records and values when following the steps.

Before you start

An administrator needs Accounting Periods turned on, then Amortization. Your role needs to create journal entries and needs the Amortization Schedules permission, which also covers amortization templates. Every accounting period in each remaining term has to exist. Each one should be open when its month is recognized, or NetSuite can post that amount to a later open period instead. If journals in your account need approval, the scheduling journal won't post until it's approved.

In OneWorld, the prepaid and expense accounts have to be available to the journal's subsidiary. With Multi-Book, use a book-specific journal when a schedule belongs to one book only.

The example company cuts over on 09/30/2026 and uses the Administrator role. Its opening trial balance has already loaded 7,650.00 into 1360 Prepaid Expenses, a Deferred Expense account. That's the unamortized part of two contracts the old system was amortizing by hand. Before you start, make sure the balance is in the trial balance once, and that no migrated vendor bill or other journal has already posted the same amount.

01. Read the remaining balances

Start from the legacy prepaid schedule exported at cutover. For each prepaid you need the expense account, the amount still to amortize, and how many months are left.

Pellham Lift Service's forklift maintenance contract charges 6530 Equipment Maintenance. It ran 07/01/2025 to 06/30/2027 for 10,800.00, and 6,750.00 is already amortized, so 4,050.00 remains over 9 months. Corvane Analytics' subscription charges 6240 Software Subscriptions. It runs 01/01/2026 to 12/31/2026 for 14,400.00, with 10,800.00 amortized and 3,600.00 left over 3 months. The Remaining total is 7,650.00.

Only the remaining amounts over the months left go into NetSuite. The original amounts and the amortized-to-date figures stay in the old system.

The legacy export at cutover. The Remaining column, 7,650.00 in total, is what NetSuite still has to amortize.

02. Check the amortization template

Go to Lists > Accounting > Amortization Templates and open the template you'll use. This one is Remaining Term - Even Periods: Type Standard, Method Straight-line, by even periods, so each remaining month gets an equal share.

Three fields decide how the journal lines behave. Deferral Account is Default, so NetSuite takes the deferral account from each line's account record. Target Account is Default, so each schedule recognizes into the account on its own journal line, and one template can serve several expense accounts. Amortization Period is blank, so the Start Date and End Date on each line set the term.

If you pick a specific Deferral Account on the template, it wins over the one on the account record.

Deferral Account and Target Account are Default, and Amortization Period is blank, so each journal line supplies its own accounts and term.

03. Check the prepaid and expense accounts

Go to Lists > Accounting > Accounts. 1360 Prepaid Expenses is a Deferred Expense account with a balance of 7,650.00, the same as the legacy Remaining total. The opening trial balance already loaded it, and the scheduling journal won't change it.

1360 Prepaid Expenses already holds the 7,650.00 from the opening trial balance.

Because the template's Deferral Account is Default, every expense account you'll amortize needs its own. Click Edit on 6530 Equipment Maintenance. Its Deferral Account is already 1360 Prepaid Expenses, so there's nothing to change, and Cancel leaves it as is. If the field were blank, you'd select the prepaid account and save. 6240 Software Subscriptions is set up the same way, so cancel out of that one too.

The expense account names 1360 Prepaid Expenses as its Deferral Account.

04. Enter the scheduling journal

Go to Transactions > Financial > Make Journal Entries. Set Date to your cutover date, 09/30/2026 here, keep the subsidiary, and give it a memo you'll recognize later. This one is "Prepaid schedules in flight at cutover."

The journal is dated at cutover, 09/30/2026, with a memo that says what it's for.

On the Lines subtab, enter the first prepaid as a pair of lines. The debit line is Account 6530 Equipment Maintenance, Debit 4,050.00, Name Pellham Lift Service, Schedule Remaining Term - Even Periods, Start Date 10/01/2026 and End Date 06/30/2027. Click Add. Scroll the grid right to check the Schedule and dates landed on the line.

The debit line carries the template and the 9 months left, 10/01/2026 to 06/30/2027.

The vendor in Name is there for reporting. It doesn't recreate the bill or touch accounts payable.

The credit line is Account 1360 Prepaid Expenses, Credit 4,050.00, with no Name and no Schedule. Click Add.

Enter Corvane Analytics the same way: debit 6240 Software Subscriptions 3,600.00 with Name Corvane Analytics, the same template, Start Date 10/01/2026 and End Date 12/31/2026, then credit 1360 Prepaid Expenses 3,600.00.

One pair per prepaid: debit the expense account with the vendor, credit 1360 Prepaid Expenses.

05. Save and read the saved lines

Click Save. The Confirmation band reads Transaction successfully Saved, and the journal is JE1184, Approved for Posting. Your journal and schedule numbers will be different, and if journals need approval in your account, it will wait in Pending Approval instead.

JE1184 saved and approved for posting.

Look at the Lines subtab. In this example all four lines now show 1360 Prepaid Expenses. Saving moved each scheduled debit from the expense account to the deferral account, so the journal debits and credits the same account and leaves the 7,650.00 balance where it was. That only nets to zero because each debit's deferral account is the same 1360 the credit lines use. The expense accounts become the schedules' target accounts, and they get nothing until the amortization journals post. Some journal forms keep showing the expense account on the debit line after save, so check the GL Impact subtab if yours does.

The Schedule column on the two debit lines now holds links to schedules 31 and 32, next to the Start Date and End Date you entered.

Every saved line posts to 1360 Prepaid Expenses, and each debit line links to its new schedule.

06. Check each generated schedule

Click 31 on the Pellham Lift Service line. The Amortization Schedule shows Created From Journal #JE1184, Template Remaining Term - Even Periods, Start Date 10/01/2026, End Date 06/30/2027, Status Not Started, and Amount and Remaining Deferred Balance of 4,050.00.

Schedule 31 came from JE1184 and covers only the 9 remaining months.

Its rows run from Oct 2026 to Jun 2027 at 450.00 each against 6530 Equipment Maintenance. The Journal column says None on every row. Nothing is recognized yet.

Nine rows of 450.00 into 6530 Equipment Maintenance, none with a journal yet.

Click Journal #JE1184 in Created From to go back, then click 32 on the Corvane Analytics line. It runs 10/01/2026 to 12/31/2026: three rows, Oct to Dec 2026, of 1,200.00 each against 6240 Software Subscriptions, 3,600.00 in all.

Schedule 32 spreads 3,600.00 over the last three months of the subscription.

07. Tie the schedules back to the balance

Go to Lists > Accounting > Amortization Schedules. Schedules 31 and 32 both show Source Transaction Journal #JE1184 and Status Not Started. Their Remaining Deferred Balance is 4,050.00 and 3,600.00, which adds up to 7,650.00: the legacy Remaining total and the 1360 Prepaid Expenses balance.

They agree here because 1360 holds nothing but these two prepaids. If your prepaid account also carries other balances, currency differences or rounding, reconcile those separately.

4,050.00 plus 3,600.00 is the 7,650.00 in the legacy schedule and in 1360 Prepaid Expenses.

Check the result (example values)

  1. JE1184 is saved, and all four of its lines post to 1360 Prepaid Expenses, so the 7,650.00 balance is unchanged.
  2. Schedule 31 is Created From Journal #JE1184 and has nine rows of 450.00, Oct 2026 to Jun 2027, into 6530 Equipment Maintenance.
  3. Schedule 32 is Created From Journal #JE1184 and has three rows of 1,200.00, Oct to Dec 2026, into 6240 Software Subscriptions.
  4. Both schedules are Not Started, and their Remaining Deferred Balance adds up to 7,650.00.

From October on, run Transactions > Financial > Create Amortization Journal Entries for each posting period, selecting that period and, where the page asks, the subsidiary. Each run debits the expense account, credits 1360 Prepaid Expenses, and puts its journal on that month's schedule row. Generated journals can land in Pending Approval, so check they posted. Reports > Financial > Amortization Forecast shows what's still to come. Amortizing a prepaid vendor bill walks through a monthly run.

Common questions

Why not just re-enter the original vendor bills?

A bill for the full contract posts the whole original amount again and amortizes months your old system already expensed. It can also leave a payable that was paid long ago. The go-live journal only deals with what's left: the remaining amount over the remaining months.

Does the scheduling journal have any GL impact?

Not when it's set up like this. On save, NetSuite posts each scheduled debit to the expense account's deferral account, and the credit lines hit that same account, so the net is zero. In this example the saved journal shows 1360 Prepaid Expenses on all four lines. If your form still shows the expense account on the debit lines, the GL Impact subtab shows where the amounts posted.

What does Deferral Account set to Default mean on an amortization template?

It tells NetSuite to use the Deferral Account on each line's account record. Set it by editing the expense account under Lists > Accounting > Accounts and picking the prepaid account in Deferral Account. If you choose a specific deferral account on the template instead, the template's account wins.

How do the Start Date and End Date on the journal line affect the schedule?

They set the schedule's term. With a straight-line, even-periods template, NetSuite splits the line amount equally across the periods between them: 450.00 a month from October 2026 to June 2027 for Pellham, and 1,200.00 a month for October to December 2026 for Corvane. The template's Amortization Period can stay blank. Check the generated rows anyway, because offsets or a residual on the template can still change them.

Should the prepaid balance go in the opening trial balance or in this journal?

The trial balance. Load the remaining 7,650.00 to the prepaid account there, then enter the scheduling journal, which nets to zero in that account. Putting the balance in both places, or loading it to expense, counts it twice.

What if the first remaining period is already closed?

NetSuite still creates the schedule, but the closed month's amount can't post to that period. It can land in a later open period when you create the amortization journals, which makes that month bigger than the rest. Check the schedule's posting periods against your open periods before the first run.