Trial Balance Excel (report)
The Trial Balance Excel report shows aggregated and summarized general ledger data for a trial balance with debit and credit columns for net change and balance.
Your trial balance shows in both your local currency (LCY) and additional reporting currency (ACY). However, the report only shows data for the latter if you have setup the additional reporting currency feature.
Data is aggregated for the period specified by the Datefilter parameter on the report's request page and summarized by the two global dimensions per G/L account category.
The Excel workbook contains three worksheets that you can use to analyze your trial balance:
- Trial Balance (LCY)
- Trial Balance (ACY)
- TrialBalanceData
Use the worksheets for different ways to analyze data.
Tip
If you configure OneDrive for system features, the Excel workbook opens in your browser by using Excel for the web.
Note
This report does the calculations when you view it in Excel online, or when you download and open it. If a banner displays text about external data connections, you might need to choose the Enable content button to load data. The report doesn't connect to any external data sources. All calculations are done in Excel with Power Query. In some cases (depending on the security configurations for your organization), you might also need to right-click on a pivot table in one of the worksheets and choose Refresh to update data in the reports.
Trial Balance (LCY) worksheet
This worksheet shows the trial balance with amounts in LCY. The accounts from the chart of account hierarchy don't display as a hierarchy in the report. You can't expand or collapse an account in the report to summarize its data.
Filters and slicers let you zoom in on the balance as seen from global dimensions, or by account categories and subcategories.
Trial Balance (ACY) worksheet
This worksheet shows the trial balance with amounts in ACY. The report requires that you use ACY.
Filters and slicers let you zoom in on the balance as seen from global dimensions, or by account categories and subcategories.
TrialBalanceData worksheet
This worksheet shows the raw data used in the report. The dataset for the report is aggregated, so the worksheet doesn't show individual transactions.
Use this worksheet for data analysis assisted by built-in tools in Excel, such as Excel Copilot, or the What-if-analysis or Forecast Sheet tools.
To learn more, go to Get started with Copilot in Excel.
Use cases
Use Excel to view a snapshot of your chart of accounts at a given point to check the debit and credit net change and closing balance.
Use the report to verify the accuracy of your financial data by ensuring that debits and credits balance. Businesses typically use the report at the end of an accounting period to prepare financial statements and assess their financial health.
Financial analysts use the report to:
- Analyze the financial trends of the business by reviewing the balances and net changes of each account in the chart of accounts over time.
- Identify areas to save cost or generate revenue, and make recommendations for improving financial performance.
- Use the report data to prepare financial reports for stakeholders such as investors or executives.
Accountants use the report to:
- Use the report data to prepare financial statements, such as income statements, balance sheets, and cash flow statements.
- Verify the accuracy of the financial data by ensuring that debits and credits balance.
- Analyze the financial health of the business by reviewing the net changes and closing balances of each account in the chart of accounts.
Controllers use the report to:
- Monitor the financial performance of the business by reviewing the balances and net changes of each account in the chart of accounts.
- Identify areas to save cost or generate revenue, and make recommendations for improving financial performance.
- Use the report data to prepare financial reports for internal and external stakeholders such as board members or regulatory agencies.
Try the report
Try the report here: Trial Balance Excel
Tip
If you hold down the CTRL key while you select the report link, the report opens on a new browser tab. In this way, you can stay on the current page while you explore the report on the other browser tab.
Alternative reports
There are several other ways to analyze your balance. To learn more, go to:
Contributors
Microsoft maintains this article. The following contributors provided some or all of its contents.
- Kim Dallefeld | Microsoft MVP
Related information
Balance Sheet (Power BI)
Trial Balance (legacy)
Key finance report overview
Ad hoc analysis on finance data
Power BI finance app
Financial Reporting
Financial analytics overview