This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello, has anyone here come up with a way to automatically export trial balance data out of NetSuite?  We have multiple subsidiaries and we are looking for a way to automate the loading of trial balance data for each subsidiary into Excel

You are just looking to export to Excel? Or export to another app?

yeah my understanding is there is no TB by subsidiary (with one column per sub) in NetSuite out of the box. You'd have to built that report with a saved search or an analytics query. Unfortunately, I think it's just one of those things you feel like you should get for free but don't

I believe the balance sheet and income statement reports can be run so that one column is included by sub, so that might be the fastest way to get that data exported (though you'd need to export two reports)

I hacked up a report as a matrix for GL data; used the web query to pull it through to excel, then re-created the TB in Excel with sumifs

<@U01B724HGRZ> Which report did you hack up?  I think your solution would work

<@USV3W3YB1> - i used the 'Transactions' report. Only filter is the date - and used an 'after' xx to capture all transactions. All subsidiaries are included. There is a column for subsidiary which allows my Excel logic to split by subsidiary.

not sure - all my subsidiaries are in a single currency

Does this help you? ...
• Reports &gt; Financial &gt; Trial Balance &gt; Customise
• Name: Custom Trial Balance by Subsidiary
• Edit Column Tab
    ◦ Expand ‘Trial Balance’ &gt; + Subsidiary &gt; Expand &gt; Click ‘Name’
    ◦ Move the new column to the far left so it’s the 1st column
    ◦ Click on 1st column (Subsidiary) &gt; Check ‘Group’ if not already checked
    ◦ Click on the 2nd column (Account) &gt; Check ‘Group with previous column’ if not already checked
• Sorting Tab
    ◦ Expand ‘Trial Balance’ &gt; + Subsidiary &gt; Expand &gt; Click ‘Name’
    ◦ Click ‘Add’ on the row that appeared on the right
    ◦ Click on the row you added and move to top &gt; Click Ok
Click ‘Save’ and you should see a full trial balance grouped by each Subsidiary. If you click on ‘collapse’ in the bottom right you will have a neat table of all the subsidiaries and totals. The new report should now be in Reports &gt; Saved Reports and also available in the search

Looks like you still get one column of data (first screenshot), whereas with the BS or IS report you can get a nice side by side comparison of each sub (second screenshot). Not sure what <@USV3W3YB1> was going for though

Sorry reposting the second screenshot here

Correct, pretty sure you can't get TB to format like that out of the box.