We will show you how to create an amortization journal entry in NetSuite. Here’s the outline of what we will be discussing in today’s post:

I suggest you watch the video. It’s easier to understand if you are a visual/audio learner. The content below is the same as the video. It’s for those who learn by reading.

 

How Create Amortization Journal Entry

To create amortization journal entry in NetSuite, we will have to go through the GL Account Set-Up first and then we will walk you through the step-by-step process of creating that amortization entry including the schedule, the start date, end date, how the prepaid balances get created, finding the journal entry, and approving the amortization.

 

Going through GL Account Set-Up

To start, log in to NetSuite. Go to List – Accounting – Accounts, and it will open up the chart of accounts for you.

Instructions for NetSuite Create Amortization Journal Entry
Step 1 – Instructions for NetSuite Create Amortization Journal entry going to Charts of Accounts

The first step in creating an amortization journal entry is to make sure that the GL account has a child account or sub-accounts attached to it. For example, we will be amortizing an insurance expense, so look for insurance expense and click edit.

Instructions for NetSuite Create Amortization Journal Entry insurance expense
Step 2 – Instructions for NetSuite Create Amortization Journal entry for insurance expense and click edit

 

Deferral Account

In insurance expense, the important account will be the deferral account. Under deferral account, we have number 1300 prepaid expenses. The GL account 1300 has to be populated in order for this expense to be recognized or in order to create the amortization journal entry.

Instructions for NetSuite Create Amortization Journal Entry deferral account
Step 3 – Instructions for NetSuite Create Amortization Journal entry and the important account is the deferral account

Once that’s been set up, we’re ready to create our journal entry.

 

Creating Amortization Entry

To start, we now go to Transactions – Financial – Make Journal Entry and open it in a new tab.

Instructions for NetSuite Create Amortization Journal Entry ready to create an amortization JE
Step 4 – Instructions for NetSuite Create Amortization Journal Entry

This is what a blank journal entry form looks like. We’re going to choose the subsidiary that you want to create this journal entry for. We’re using sub1 in this example.

Instructions for NetSuite Create Amortization Journal Entry
Step 5 – Instructions for NetSuite Create Amortization Journal entry going to Charts of Accounts

In the memo field, we are going to put the description create an amortization journal entry.

Next, we have to select the GL account type. In the accounts field, choose expense as part of that drop down menu.

Instructions for NetSuite Create Amortization Journal Entry select GL account
Step 6 – Instructions for NetSuite Create Amortization Journal entry going to Charts of Accounts select GL accounts and choose expense

We will then select insurance expense as the next one. You’ll notice that the account is 6100, so you’ll click it.

Instructions for NetSuite Create Amortization Journal Entry chose 6100 Insurance Expense and click it.
Step 7 – Instructions for NetSuite Create Amortization Journal entry choose 6100 Insurance Expense and click it

For our example, we are going to fill out the debit amount, which is 12,000, and the memo is creating an amortization JE. That description carried over for the first tab.

Instructions for NetSuite Create Amortization Journal Entry debit amount
Step 8 – Instructions for NetSuite Create Amortization Journal entry debit amount and memo field

 

Schedule, Start date, End date Fields

For amortization journal entry, there are 3 important fields needed: schedule, the start date, and the end date. Click on schedule, and there is an annual prepaid insurance schedule already. In order to use the schedule, we actually first have to set it up.

That was one of the set-up or configurations that you can set certain things up to amortize over 3 months, over 6 months, in our case, annual means over 12 months. Now, we look at the start date. We’ve inputted March 1, 2016 and the end of next year because it’s 12 months; it’s going to be February 2017.

Instructions for NetSuite Create Amortization Journal Entry 3 important fields for amortization
Step 9 – The three (3) important fields needed for amortization is Schedule, Start date and End date. These 3 have to be populated.

For this example, we’re going to be using accounts payable as the credit account. You’re going to click accounts payable, and you’re going to select accounts payable.

Instructions for NetSuite Create Amortization Journal Entry accounts payable
Step 10 – Instructions for NetSuite Create Amortization Journal entry choose accounts payable

 

 

Creating Prepaid Balance

One thing to know is that the account 6100 for insurance expense will change to become a prepaid expense. It’s now a balance sheet account.

As soon as you click save, your journal entry won’t show insurance expense anymore. It’s now converted to a prepaid expense, and it will then take this expense over time, over the 12 months, which is what we wanted. Then you’re going to fill out the credit amount of 12,000, and the memo field is the same as before. Then we click add.

Instructions for NetSuite Create Amortization Journal Entry
Step 11 – Instructions for NetSuite Create Amortization Journal Entry. Fill out the credit of $12,000 and we will be using the same memo as above and click “add”.

Now, you’ll see your prepaid expenses. The account 6100 insurance expense has now changed to account 1300 prepaid expense.

Instructions for NetSuite Create Amortization Journal Entry insurance account has change to prepaid expense account
Step 12 – Instructions for NetSuite Create Amortization Journal entry. Screenshot that the 6100 insurance expense account has now changed to account 1300 prepaid expense

The reason is that in our chart of account, we set up the deferral account for expenses to be prepaid expenses. That’s why that first step was very important to make sure in our chart of accounts we set up the right balance sheet account when we are creating the prepaid balances.

 

Finding the Amortization Journal Entry

How do we find the amortization journal entries? You’re going to go to Transactions – Financial – Create Amortization Journal Entry.

Instructions for on how to create NetSuite Amortization Journal Entry
Step 13 – Instructions for NetSuite Create Amortization Journal entry on how to find Amortization JE

You’ll then see the list of our amortizations schedules.

Instructions for NetSuite Create Amortization Journal Entry list
Step 13 – Screenshot of the List Amortization Schedules

In this example, we’ve chosen Subsidiary 1. These are just the different filters to show us and find what journal entries you want to amortize.

You’ll notice there’s a box called “All.” You want to select “All” in order to amortize all of the journal entries and approve it. If you unmarked “All,” you can then delete it. Note that you can check each of the amortization journal entries, each of the 12 journal entries separately because remember it’s 12,000 for the year, so each month, there is 1 journal entry for $1000. If you don’t want to select them individually, you can uncheck the box, and it will amortize all of the journal entries at once.

Instructions for NetSuite Create Amortization Journal Entry on how to amortize all or individual JE
Step 15 – Instructions for NetSuite Create Amortization Journal entry on how to amortize all or individual Journal Entries

You can actually drill into individual journal entries to make sure that it’s amortizing the way you expect. You can click the individual schedules, and you can select the journal entry created and click into it.

Instructions for NetSuite Create Amortization Journal Entry select individual schedule and click create journal entries
Step 16 – Instructions for NetSuite Create Amortization Journal entry. Select individual schedule and select the one you just created and click Create journal entries.

 

Approving Amortization

Now, you’ll see the journal entry that was automatically processed. In this case, it is entry 10066, and you can click it.

screenshot processed Amortization Journal Entry
Step 17 – Instructions for NetSuite Create Amortization Journal entry. Screenshot of processed Amortization Journal Entry

You can see now that the amount that we’ve amortized is $1,000, which is what we wanted. Again, check if the expense is going to an insurance expense. The prepaid expense where it’s been taking out of is account 1300.

Final Amortize Journal Entry
Step 18 – Instructions for NetSuite Create Amortization Journal entry. Final Amortize Journal Entry

That’s it! That’s how we create the journal entry for amortizing monthly, quarterly, or annual expenses.

I hope this is helpful, and we’ll talk to you in the next session. To recap, here’s what we have tackled with regard to creating amortization journal entry:

 

watch video in youtube

 

If you found this post helpful and
want to receive the next segment
sign up for blog