Quick Guide: How to Drill Down to Transactions in Excel for BC in 6 Easy Steps

1. Set up your Excel-to-Business Central connection: Install an Excel add-in that connects directly to your BC database.

2. Select the tables and fields for your report: Choose which Business Central data tables you need for your summary report.

3. Build your summary report in Excel: Create aggregated views using sums, counts, or averages from your BC data.

4. Configure drill-down functionality: Enable the ability to click on any cell and view underlying transaction records.

5. Navigate to transaction-level detail: Click on summary figures to open the supporting transactions instantly.

6. Refresh and share your reports: Use Exsion365's one-click refresh to keep your drill-down reports current and shareable.

How to Perform Drill-Down Analysis to Transaction Level in Business Central

1. Set Up Your Excel-to-Business Central Connection

The first step is establishing a live link between Excel and your Business Central environment. You'll need an Excel add-in that can read directly from your BC database without requiring data exports.

Once installed, open Excel and look for the add-in ribbon tab. From there, create a new connection by entering your BC environment URL and authenticating with your Microsoft credentials.

This connection respects your existing BC user permissions. If you can see a customer record in BC, you'll be able to pull that same data into Excel. If you can't, the add-in won't show it either.

2. Select the Tables and Fields for Your Report

With your connection established, choose which Business Central tables to include. For financial drill-down reports, you'll typically start with the General Ledger Entries table, then add related tables like Customer Ledger Entries or Vendor Ledger Entries.

Select only the fields you need. For a P&L report, you might include Account Number, Posting Date, Amount, and Document Number. Limiting your field selection keeps the data refresh fast.

Consider adding tables that link to your main data. For example, joining the G/L Entry table to the Item Ledger Entry table lets you see both the accounting entry and the inventory movement that created it.

3. Build Your Summary Report in Excel

Now structure your report to show aggregated figures. Use Excel's standard SUM, COUNT, or AVERAGE functions on your BC data, or use the add-in's built-in aggregation methods.

Group your data by the dimensions that matter to your analysis. This might be by account category, cost centre, project code, or time period. A typical management report shows monthly columns with row groupings by account or department.

Keep your summary layout clean. Each cell should represent a single aggregated value that you can later drill into. Avoid merged cells or complex nested formulas that might interfere with the drill-down navigation.

4. Configure Drill-Down Functionality

This step connects your summary cells to their underlying transactions. The Exsion Excel Add-in for Business Central includes a "Details weergeven" (Show Details) feature that does this automatically.

Position your cursor on any cell containing an aggregated value. The add-in's task pane will display the filters applied to that specific cell, showing you exactly which accounts, date ranges, and dimension values contribute to that number.

For custom drill-down paths, define which fields should appear in your transaction list. You might want to see Document Number, Posting Date, Description, and Amount for each individual entry behind a summary figure.

5. Navigate to Transaction-Level Detail

With drill-down configured, click the "Drilldown" button in the add-in ribbon while your cursor is on a summary cell. This instantly generates a new report showing every transaction that makes up that total.

The drill-down results open in a new browser tab or Excel sheet, depending on your settings. Each row represents a single posted transaction from Business Central, complete with all the detail fields you specified.

Use Excel's built-in filters and sorting on this transaction list. You can quickly identify unusual entries, spot patterns, or export specific records for further investigation. The drill-down output is standard Excel data, so all your familiar analysis techniques apply.

6. Refresh and Share Your Reports

Reports lose value if they show outdated figures. Click the "Gegevens vernieuwen" (Refresh Data) button to pull the latest information from Business Central into your existing report structure.

This one-click refresh updates all your summary figures and maintains the drill-down connections. You don't need to rebuild anything or re-export data from BC.

To share reports with colleagues who don't have the add-in, use the "Formulas to values" feature. This replaces all live BC connections with static values, creating a standard Excel file anyone can open. Save a copy with the original formulas intact for your next refresh cycle.

What is the difference between drill-down and drill-through in reporting?

Drill-down moves you vertically through your data hierarchy while staying in the same report context. You might start with annual totals, then drill down to quarterly, then monthly, then daily figures. Each level reveals more granular detail within the same logical structure.

Drill-through takes you horizontally to a completely different report. Clicking a revenue figure might open a separate sales order report showing which specific orders generated that revenue. The destination report has its own layout and purpose.

For Business Central finance teams, drill-down to transaction level is usually the more useful capability. When your CFO asks why travel expenses increased, you want to see the actual posted entries, not a different summary report about travel.

Why should finance teams use Excel instead of Business Central's built-in reports?

Business Central includes financial reporting capabilities, but they operate within the BC interface. This means switching between applications, learning BC-specific report builders, and losing the flexibility Excel offers.

Excel remains the environment where financial controllers do their analysis. You already know the shortcuts, formulas, and formatting options. Adding data from BC shouldn't require learning an entirely new tool.

With an Excel-native approach, you combine BC data with information from other sources in one workbook. Your drill-down report might blend general ledger entries with budget figures from a planning system or headcount data from HR. That cross-source flexibility isn't available in BC alone.

How Exsion365 Helps You Drill Down to Transactions Faster

Exsion365 connects Excel directly to your Business Central data with no exports or intermediate steps. The Exsion Excel Add-in gives you live access to every table and field in your BC database.

Building reports happens in the tool you already know. Define your data sources, apply filters, create aggregations, and format results using standard Excel features. Exsion365 adds the BC connection layer while you keep full control of presentation.

Drill-down to transaction-level detail takes one click. Select a summary cell, press Drilldown, and see every posted entry that contributes to that figure. No waiting for IT, no custom development, no switching between systems.

Multi-company reporting works the same way. If you manage several BC entities, Exsion365 lets you build consolidated reports across all of them, with drill-down capability into each company's transactions.

Ready to stop exporting data and start analysing it? Contact Exsion365 for a demonstration of drill-down reporting in your own BC environment.

FAQs About Drill-Down Analysis in Excel for Business Central

Can I drill down to transactions across multiple Business Central companies?

Yes. Exsion365 supports multi-company reporting, which means you can build a consolidated summary and then drill into transactions from any individual entity. The drill-down results show which company each transaction belongs to, so you maintain full visibility across your organisation.

Do I need special permissions to use drill-down in Excel for BC?

Your drill-down access follows your existing Business Central user permissions. If you can view a specific table or record in BC, you can drill down to it in Excel. The Exsion Excel Add-in doesn't bypass any security settings.

How fast is the drill-down compared to running reports in Business Central?

Drill-down in Exsion365 typically returns transaction lists within seconds, even for large datasets. The speed depends on your BC environment performance and the number of records, but most finance teams find it faster than navigating through BC's interface to find the same information.

Can I save my drill-down results for audit documentation?

Absolutely. When you drill down, the results appear as standard Excel data. You can save this as a separate file, print it, or copy the relevant rows into your audit workpapers. Exsion365's "Formulas to values" feature converts live connections to static data for archiving.

What happens if the underlying BC data changes after I drill down?

Your drill-down results reflect the data at the moment you clicked. If transactions are posted or modified in BC after your drill-down, those changes won't appear until you refresh your summary report and drill down again. For audit trails, this snapshot behaviour helps you document what you reviewed at a specific point in time.