Trial Balance by Period (report)

The Trial Balance by Period report shows general ledger (G/L) accounts with an opening balance and net changes for up to 12 accounting periods. The period columns show movements, not cumulative closing balances. You can filter the report by dimensions.

Enter an accounting period start in Starting Date. You can select an Indentation Level to control the account detail and a Rounding Factor to show rounded amounts.

Use cases

Get a detailed breakdown of your net changes over up to 12 accounting periods for each general ledger account.

Financial accountants can use the report to:

  • Verify the accuracy of the financial data. Review the movements in the selected accounting periods and ensure that they match the expected values.
  • Identify discrepancies or errors in financial data and investigate them.
  • Use the report data to prepare financial statements, such as income statements, balance sheets, and cash flow statements.

Financial analysts can use the report to:

  • Analyze financial performance over specific accounting periods by reviewing the movements and identifying trends and variances.
  • 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.

Financial controllers can use the report to:

  • Monitor the financial health of the business. Review the movements in the selected accounting periods and ensure that they are within the expected range.
  • 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 by Period

Tip

If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.

Built-in key finance reports
Ad hoc analysis on finance data
Financial analytics overview

Find free e-learning modules for Business Central here