The NetSuite Accountant

How to build a NetSuite segment mapping file

Paul Giese Apr 10, 2020 5:29:17 PM
0

Once the segment structure is complete, the next step is mapping the legacy segment structure to the new NetSuite structure. If you are unfamiliar with NetSuite’s segments, check out our segment structure blog post.

Read More

Segment Structure Basics in NetSuite

Paul Giese Apr 6, 2020 8:00:00 AM
0

intheBlk consulting provides data conversion services for organizations implementing NetSuite. Check out our NetSuite data conversion page to see the options and pricing and our NetSuite implementation resource page for additional help articles.

The segment structure is the backbone of the organization’s financial reporting function. NetSuite’s segment structure is robust compared to QuickBooks and flexible enough to handle most needs. Setting up the segment structure is one of the first implementation tasks. NetSuite segments are general ledger (GL) accounts, departments, classes, and locations. Organizations can also add custom segments.

Read More

Build a journal entry approval saved search in NetSuite

Paul Giese Mar 18, 2020 5:00:00 AM
0

Are you looking for more tips, tricks, and how-to articles on reporting in NetSuite? Check out our NetSuite Reporting Resource page.

Auditors often ask accounting teams to provide a list of journal entries displaying the submitter and approver. This report can serve as a critical control for users to review journal entries created by or approved by a specific user. In this article, we will walk you through how to build this using a NetSuite saved search.

Read More

Can I import historical financial transactions into NetSuite?

Paul Giese Mar 16, 2020 2:15:00 AM
0

Companies always want their historical transactions imported into NetSuite. Implementation partners often advise against this for several reasons:

Read More

How to build a monthly spend by vendor saved search in NetSuite

Paul Giese Mar 9, 2020 5:15:00 AM
0

Are you looking for more tips, tricks, and how-to articles on reporting in NetSuite? Check out our NetSuite Reporting Resource page.

For an accounting team explaining the spending changes, having a report that quickly shows vendor spending is helpful. In this blog post, I will walk you through how to build this with a NetSuite saved search. 

Read More

Five NetSuite preferences you need to know

Paul Giese Mar 2, 2020 5:15:00 AM
0

NetSuite is a flexible accounting solution that has many preferences available to individual users. While an individual setting rarely makes-or-breaks the system, over time, optimizing many small experiences can lead to large efficiencies. In this blog post, I highlight five preferences to improve your NetSuite experience.

Read More

Three tips for importing data from multiple subsidiaries to NetSuite

Paul Giese Feb 10, 2020 5:15:00 AM
0

If you are managing multiple subsidiaries in QuickBooks, it might be time to upgrade your ERP to NetSuite. Basic ERP systems, like QuickBooks, cannot often manage numerous subsidiaries in a single instance in a controlled manner. NetSuite is an excellent option for handling the finances for multiple subsidiaries in one system. Importing this data from a legacy system can be challenging, depending on how it is has been tracked. Here are three tips when importing data from multiple subsidiaries to NetSuite:

Read More

NetSuite | Full transaction import case study - Akouos

Paul Giese Dec 31, 2019 11:21:32 AM
0

Importing historical financial data is a critical component of the NetSuite implementation process. Generally, there are two approaches:

Read More

Best practices to import vendors to NetSuite

Paul Giese Dec 30, 2019 11:36:11 AM
0

intheBlk consulting provides data conversion services for organizations implementing NetSuite. Check out our NetSuite data conversion page to see the options and pricing.

Early in the NetSuite implementation process, organizations will need to import their vendor records into NetSuite. This blog post shares some best practices and standard struggles I've seen in the vendor record conversion process.

Read More

NetSuite | Fixed Asset rollforward report, part 1

Paul Giese Dec 17, 2019 5:15:00 AM
0

The most common report used around fixed assets is the rollforward. The rollforward shows the beginning balance, additions, disposals, depreciation, and ending balance over a given period. Over the next series of blog posts, I will walk you through how to build saved searches and views to compile a rollforward report in NetSuite.

To start, we are going to customize the fixed asset listing view to calculate the beginning and ending balances for gross assets and accumulated depreciation.

Read More