This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
Could you advise if there is a way to build a report to reconcile total Transactions to GL balances per natural account and level? We would like a reconciliation to be done as a monthly process to ensure that transactions uploaded per natural account and level match the total GL balances.
Transactions are associated with the Actuals version, but their values are independent of the Actuals and may not tie due to accounting adjustments.
When viewing Actuals data on sheets and reports that corresponds with transaction level data, users with the appropriate permission can drill into the transaction level detail. Transaction drill through is only available in cells where there is transaction level data associated with the account, level, and month of the cell.
You can also create Transaction reports to display Transactions associated with specific accounts and levels.
It is not currently possible to create a single report that finds the variance between the Transactions and the Actual value of the GL account.