QBO to NetSuite Preparing the JE template from a transaction list

Monthly Net Change Journal Entries | QBO Transaction Detail to NetSuite CSV

In this lesson, we walk through how to export monthly net change data from QuickBooks Online and convert it into journal entries for NetSuite using the Transaction Detail by Account report.

This video focuses on the incremental portion of the net change trial balance approach. After loading the opening balance sheet, we now use transaction-level detail to calculate month-by-month net changes and prepare clean CSV files for NetSuite import.

Contents

0:00 Overview of monthly net change approach
0:09 Exporting transaction detail from QuickBooks Online
0:16 Using the Transaction Detail by Account report
0:55 Clearing groups and limiting columns
1:14 Selecting required transaction fields
1:37 Adding account and class segments
1:57 Saving the custom QBO report
2:24 Classic vs modern report view differences
3:05 Exporting the report to Excel
3:31 Removing headers and footers
3:54 Aligning QBO columns to the NetSuite template
4:24 Copying data into the net change template
4:45 Month-end date calculation
4:58 SUMIFS logic for net change calculations
5:18 Adjusting formulas for additional segments
5:43 Handling blanks vs double-dash values
6:23 Removing duplicates by account, class, and month
6:50 Validating gross debits and credits
7:18 Ensuring net impact equals zero
7:48 Why NetSuite requires net values
8:10 Final formula-driven journal entry lines
8:35 Preparing the CSV upload file
9:07 Converting formulas to values
9:31 Cleaning up false values
9:56 Final file ready for NetSuite import
10:00 What’s next

What You’ll Learn in This Lesson

In this video, you will learn how to:

• Export transaction-level detail from QuickBooks Online
• Configure the Transaction Detail by Account report correctly
• Prepare monthly net change data in Excel
• Use SUMIFS logic to calculate net journal entries
• Handle segment combinations correctly
• Avoid double-counting debits and credits
• Prepare a clean CSV file for NetSuite upload

This workflow allows you to load incremental activity without reloading full trial balances each month.

Why This Matters in a NetSuite Migration

Loading historical data month by month using net changes allows you to:

Reduce the number of journal entries

Preserve monthly financial trends

Keep NetSuite performant

Simplify validation and tie-outs

Avoid duplicating balances

This approach is especially useful when loading multiple years of history.

Best Practices

• Keep QBO reports as minimal as possible
• Ensure column order matches the NetSuite template
• Always remove duplicates before calculating net values
• Validate that total debits equal total credits
• Save a formula-based support file and a value-only CSV
• Test one month before bulk loading

What’s Next

In the next lesson, we’ll walk through how to import these net change journal entries into NetSuite, including field mapping, validation, and common pitfalls.