The NetSuite Accountant

intheBlk consulting can complete these tasks on your behalf, including loading detailed transactions. Our self-service tool can create the NetSuite CSV import templates directly from the QuickBook trial balance and subledger files. Contact us today!

Companies implementing NetSuite need to load monthly historical financial statements and open transactions. This article will discuss the debits and credits in this process. This process is relevant for companies loading monthly net change entries (also known as monthly trial balances). This process is not needed if you are loading detailed transactions.

A general ledger (GL) export is a common request for budgeting purposes and for the financial statement auditors. In this blog post, we will discuss how to build this with a NetSuite saved search, utilizing the CASE WHEN formula to include the header-level and line-level name information in a single column.

Changing transaction coding via a CSV import template is critical when the volume of transactions is too high to do this task manually. Two use cases for this skill are updating the department coding for all transactions with a specific vendor for comparative financials or adding a class code for transactions migrated from QuickBooks during a NetSuite implementation. This blog post will walk through the steps to complete this process.

Bill.com is an excellent tool for creating and paying vendor bills. If you used Bill.com with QuickBooks and plan to continue using it with NetSuite, there are some steps to ensure the sync works correctly with your QuickBooks to NetSuite data migration. In this blog post, we are specifically discussing the Accounts Payable sync with Bill.com.

You’ve successfully loaded your data into NetSuite. How do you validate that the data migration worked? And what do you need to document for the financial statement auditors? This blog post discusses three tieout procedures recommended to finalize the data conversion project.

The ability to mass change the account coding of transactions is extremely useful. A few all-to-common scenarios might be (1) you are the new controller at a company, and the old team's chart of accounts is a mess, (2) you have added a new GL account or class that previously wasn't needed, and now you want to go back and update the past year's transactions for comparative purposes, or (3) you are about to start a NetSuite implementation, and you'd like to change the coding on transactions before migrating your data.

Paul Giese from intheBlk consulting joined Liz Keefe, Client Engagement Manager at Sikich, to discuss the data migration process for life science companies. Specifically, we discussed how life science accounting teams can start to prepare for in advanced for their implementation and some tips and tricks to ease the data migration process.

If your organization needs their historical data imported into NetSuite, contact intheBlk consulting to learn about our solution for migrating QuickBooks data to NetSuite.

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.

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.