Drill Down into NetSuite from Excel
Right-click any NetSuite balance in your Excel report to see what makes it up, by segment, by period or line by line.
Screen recording in Excel and NetSuite with on-screen callouts. In a Statement of Profit & Loss for FY 2025 built from Finsyte functions, the Q1 Revenue balance, 4,316,848, is selected and right-clicked. Callout: Right-click any balance › Drill Down. Drill Down › Subsidiary is chosen. Callout: Break it out by Subsidiary. A new Subsidiary Drill Down sheet opens and its balances load. Callout: The balance, split by subsidiary. The revenue appears for US-2, Canada, Vietnam, United Kingdom and United States, with a total that ties to the 4,316,848 on the report. Callout: Each drill sheet keeps its source formula. The source formula’s value is selected at the top of the sheet. Callout: Return to source jumps back to the report. The Return to source link leads back to the Q1 Revenue cell. Back on the drill-down sheet, the total is selected and the source formula’s value is right-clicked. Callout: Drill deeper, to Transaction Lines. Drill Down › Transaction Lines opens a 4110 - Transaction Lines sheet. Callout: Every transaction line behind the number. Callout: Scroll across every column. The horizontal scroll bar is dragged right to the Amount column and back to column A. A Transaction Id is clicked and the sheet scrolls down. Callout: Open any transaction in NetSuite. An invoice link with the tip Open in NetSuite is clicked. Callout: The invoice opens right in NetSuite. Invoice INV1916, dated 03/25/2025 and Paid in Full, opens in NetSuite; the page is scrolled to the bottom and back to the top.
Every balance comes with its detail
A Finsyte balance is a live formula, so Finsyte knows exactly what it adds up. Right-click it and choose Drill Down, and a new sheet in your workbook breaks that one number down, within the same parameters as the cell.
- Break a balance down by subsidiary, department, class, location, entity, transaction type or period
- Custom segments appear in the Drill Down menu alongside the standard ones
- List the transaction lines behind any amount, with links to each transaction in NetSuite
- A Return to source link takes you back to the cell you started from
- Drill into several cells at once, or into a summary account’s underlying accounts
From a report total to the source transaction in four steps
Right-click a balance
Any cell with a Finsyte balance function, such as GLAccountBalance, offers Drill Down at the bottom of the menu.
Pick a breakdown
Choose a segment, Period, or Transaction Lines. Finsyte opens a new sheet with the result.
Keep drilling
Right-click an amount on the drill-down sheet to break it down again, down to individual transaction lines.
Open it in NetSuite
Transaction lines link to their transactions in NetSuite, and Return to source brings you back to the report.
Explain any number without leaving Excel
Month-end questions usually start with one number: why is revenue up, what hit this expense line, which subsidiary moved. Drill Down answers them where the question starts, in the report.
Scoped to the cell’s own parameters
A drill-down sheet covers exactly what the cell covers: the same account, subsidiary, fiscal year, period range and filters. The top of the sheet lists every argument from the source formula, so you always know what you are looking at.
By segment, period or transaction line
The Drill Down menu offers Subsidiary, Department, Class, Location, Entity, Transaction Type and Period, plus your custom segments, and Transaction Lines for the individual postings. A Period drill-down of a balance sheet account at YTD includes the prior year’s balance, so the periods add up to the balance in the cell.
All the way to NetSuite
At the transaction-line level, each line links to its transaction in NetSuite. It is the quickest way to trace an amount that doesn’t look right, then fix it at the source.
Several cells, or a whole rollup
Select several cells that use the same function with the same parameters except the account, and Drill Down combines them into one sheet. A cell that totals a summary account drills across every account in the rollup, and its menu adds Base Accounts to list each underlying account on its own row.
Explain variances at month end
Pair Drill Down with a comparative report. When a line on the comparative income statement moves more than you expect, drill into each period’s balance by department or entity, then down to the transactions behind the change, and note the explanation beside the number. Each drill-down sheet keeps the parameters it used, so the workbook shows how every variance was traced.
Choose the columns
The Drilldown Options pane in Finsyte Preferences sets which columns the results show and in what order, including Subsidiary and your custom segments.
Works across the report
Drill Down works on GLAccountBalance and its debit and credit versions, item quantities and statistical accounts, so it is available in the report templates and in any report you build with Finsyte functions.
NetSuite drill down in Excel: FAQ
- QHow do I see the transactions behind a NetSuite balance in Excel?
- Right-click the balance, choose Drill Down, then Transaction Lines. A new sheet lists the transaction lines that make up the amount, and each links to its transaction in NetSuite.
- QCan I break a balance down by subsidiary or department?
- Yes. Drill Down offers Subsidiary, Department, Class, Location, Entity, Transaction Type, Period and your custom segments. Each opens a sheet with the balance split that way.
- QDoes the drill-down use the same filters as the cell?
- Yes. Every drill-down stays within the parameters of the cell you started from, and the sheet lists those parameters at the top.
- QCan I drill into several cells at once?
- Yes. Select cells that use the same function with the same parameters except the account, then right-click and choose Drill Down. Finsyte combines them into one drill-down sheet.
- QWhich Finsyte functions support Drill Down?
- GLAccountBalance, GLAccountDebitBalance, GLAccountCreditBalance, GLAccountSummaryBalance, GLItemQuantity and StatAccountAmount.
- QHow do I get back to my report?
- Each drill-down sheet has a Return to source link at the top that takes you back to the cell you drilled from.
Try it with your own NetSuite data
30-day free trial with every Finsyte feature included. No credit card required.