Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
When you post a transaction to the general ledger, the following data is stored in the Business Central database:
- A single row in the G/L register table
- One or more rows in the G/L Entry table
Analyzing the G/L register
You can use the G/L Registers page for financial reporting and transaction tracking. The page gives you an overview of all transactions to the general ledger with the ability to go to related entries in subledgers, such as VAT entries or customer ledger entries. You can also review the type of transaction, the user who made the transaction, and when it was recorded in the database.
The G/L Registers page is useful during audits. The page provides auditors with easy access to related detailed transaction information. It helps identify any discrepancies, errors, or unusual entries that might require further investigation.
Example: use analysis mode to get an overview of G/L transaction types and volume
To get an overview of the types of transactions that happened to your general ledger and the types of sources for them, do as follows:
- Open the G/L Registers list and choose
to turn on analysis mode. - Go to the Columns menu and remove all columns (select the box next to the Search field on the right).
- Drag the Source code field to the Row Groups area.
- Rename your analysis tab to GL entries by source, or something that describes this analysis.
Tip
You can perform this analysis during or after go-live of your environment to understand which types of transactions are used and which types are not yet being used.
The following image shows the result of these steps.
Analyzing general ledger (G/L) entries
Depending on your need for details or aggregation when analyzing general ledger (G/L) entries, you have several options:
- Use the G/L entries page in analysis mode. To learn more, go to Ad hoc analysis on finance data
- Use the Chart of Accounts page for a summary across all your G/L accounts. To learn more, go to Analyze finance data from the Chart of Accounts.
- Run or define a financial report. To learn more, go to Primary capabilities of financial reporting.
Related information
Understand the general ledger
Understand the chart of accounts
Ad hoc analysis on finance data
Financial analytics overview
Finance overview