The NetSuite Accountant

Build a journal entry approval saved search in NetSuite

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

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 5: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 8:15:00 AM
0

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 8: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 8: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 2:21:32 PM
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 2:36:11 PM
0

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 8: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

NetSuite | Net change journal entry import case study - Oncorus

Paul Giese Dec 11, 2019 8:15:00 AM
0

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

Read More

NetSuite | Common biotech GL account structures

Paul Giese Dec 10, 2019 8:15:00 AM
0

The general ledger (GL) account structure is an art, not a science. Every company has unique reporting requirements. The GL structure is a way to ease reporting requirements. There are good ways and bad ways to structure the GL. Here are a few tips and tricks that I've found after advising several biotech organizations on restructuring their GL during a NetSuite ERP implementation:

Read More