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 with on-screen captions. In a Statement of Profit & Loss by period, the Revenue balance for one period is right-clicked. Caption: Right click to drilldown on balances. Drill Down › Subsidiary opens a new Subsidiary Drill Down sheet. Caption: Review Balance by Subsidiary. The top of the sheet lists the source formula’s arguments, and below it the revenue appears by subsidiary with a total. Caption: Return to source easily. A Return to source link leads back to the original cell. Caption: Drilldown to Transaction Lines. A right-click on an amount and Drill Down › Transaction Lines opens a sheet of the transaction lines behind it. Caption: View Transactions in NetSuite. A transaction link opens the invoice in NetSuite.
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.