I recently assisted a client with migrating 15 legal entities (with 15 separate QB Online accounts) to a single NetSuite account. The ability to generate historical consolidated financial statements was a project requirement. My approach for meeting this requirement was to import historical transactions to "import only" accounts and reclassify the eliminating balances with monthly advanced intercompany journal entries. This blog post will discuss the detailed steps taken.
As companies expand their operations, they often form new legal entities for legal and tax reasons. As a result, the accounting team must prepare and analyze consolidating financial statements, including eliminating intercompany balances. Unfortunately, QuickBooks does not support this systematically, so accountants must complete this process outside the system. This blog post discusses best practices for organizing these intercompany balances to ease this manual process.
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.
