QBO to NetSuite Preparing the JE template from a TB point in time approach

Point-in-Time Trial Balance Journal Entry Upload | QBO to NetSuite Migration

In this lesson, we walk through how to prepare and upload point-in-time trial balance journal entries into NetSuite as part of a QuickBooks Online to NetSuite data migration.

This video covers the end-to-end Excel workflow, including account mapping, internal IDs, handling AR and AP balances correctly, and managing fiscal year crossovers so your NetSuite balances tie cleanly to QuickBooks.

Contents

0:00 Overview of point-in-time trial balance uploads
0:15 Downloading trial balances from QuickBooks Online
0:22 Using the provided migration spreadsheet
0:32 Reviewing required fields on a NetSuite journal entry
0:49 Currency and exchange rate setup
1:05 Finding currency internal IDs
1:18 Subsidiary, memo, and approval status fields
1:39 Name lookup for import AR and AP entities
1:55 Account and class mapping tabs
2:09 Cleaning and formatting the trial balance
2:32 Copying debits and credits into the template
2:51 Identifying unmapped accounts
3:01 Troubleshooting retained earnings
3:33 Using filters to isolate missing mappings
3:48 Adding new accounts to the mapping table
4:14 Why mappings should live in the map (not the upload)
5:03 Validating AR and AP name population
5:30 Memo and document number formulas
5:49 External ID usage for batch uploads
6:08 Point-in-time approach explained
6:25 Handling fiscal year crossover reversals
6:43 Why NetSuite auto-reversals fail at year-end
7:18 Manually reversing December trial balances
7:48 Redirecting P&L reversals to retained earnings
8:59 Validating no P&L impact post-reversal
9:09 Loading the next month’s trial balance
9:44 Scaling the process month-over-month
10:18 Using the template for repeated uploads
10:39 Creating the final CSV upload file
11:12 Ready for NetSuite import

What You’ll Learn in This Lesson

In this video, you will learn how to:

• Prepare point-in-time trial balance journal entries
• Map QuickBooks accounts to NetSuite using internal IDs
• Handle AR and AP balances correctly in summary journals
• Manage fiscal year crossover reversals safely
• Avoid P&L misstatements at year-end
• Build a reusable Excel upload template
• Convert Excel files into clean CSV uploads

This is one of the most critical steps in ensuring your NetSuite opening balances are correct.

Why This Matters in a NetSuite Migration

Trial balance uploads are where most migrations succeed or fail.

If done incorrectly, you can end up with:

P&L balances posting to the wrong period

Retained earnings mismatches

Broken AR/AP detail

Audit and reconciliation issues

By using a point-in-time approach with controlled reversals, you preserve historical accuracy while keeping NetSuite clean.

Best Practices

• Always use internal IDs for account references
• Store mappings in a centralized map table
• Manually reverse entries that cross fiscal years
• Test with a single period before bulk loading
• Save support versions of your Excel files
• Upload only the final CSV tab into NetSuite

What’s Next

In the next lesson, we’ll take this journal entry file and walk through the NetSuite CSV import process, including field mapping and validation.