Edytuj

Udostępnij za pośrednictwem

Trial Balance/Budget Excel (report)

  • Artykuł

The Trial Balance/Budget Excel report shows general ledger data subtotaled by general ledger account for net change, percent of budget net, net budget, balance, percent of budget balance and budget balance. Amounts are in local currency (LCY).

Data is aggregated for the period specified in 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 two worksheets that you can use to analyze your trial balance vs. budget:

  • Trial Balance vs. Budget,
  • TrialBalanceBudgetData

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 vs. Budget worksheet

This worksheet shows the trial balance vs. the budget with amounts in LCY.

Filters and slicers let you zoom in on the balance as seen from global dimensions, or by account categories and subcategories.

Screenshot of the Trial Balance (LCY) worksheet

TrialBalanceBudgetData 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.

Screenshot of the TrialBalanceData worksheet

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 compared to the budget.

Use the report to assess how well you're following your financial plans and identify variances between actual and budgeted amounts. The report is useful for financial analysis and decision-making at the end of an accounting period or fiscal year.

Financial analysts use the report to:

  • Analyze the financial performance of the business. Review the variances between actual and budgeted amounts 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 stakeholders such as investors or executives.

Accountants use the report to:

  • Use the report data in comparison with budget amounts 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, and compare the actual vs. budgeted amounts.
  • Analyze the financial health of the business. Review the variances between the actual and budgeted amounts of each account in the chart of accounts.

Controllers use the report to:

  • Monitor the financial performance of the business. Review the variances between actual and budgeted amounts for 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/Budget 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.

Balance Sheet (Power BI)
Trial Balance/Budget (legacy)
Key finance report overview
Ad hoc analysis on finance data
Power BI finance app
Financial Reporting Financial analytics overview

Find free e-learning modules for Business Central here