Skip to main content

GL Reconciliation Cube

Sage XRT Advanced, Dashboard

The GL Reconciliation Cube dashboard for Sage XRT Advanced breaks down general ledger reconciliation by company and bank. It includes imported, automatically reconciled, manually reconciled, and not reconciled entries, and the companies and banks with the most transactions.

How to use the GL reconciliation cube dashboard​

  • Follow imported and reconciled entries for the selected period, along with the year to date totals.
  • Compare automatic and manual reconciliation to see how much of the reconciliation is done by hand.
  • Locate not reconciled entries by group, such as company and bank.
  • Rank companies and banks by transaction quantity to see where most GL transactions occur.

Filters​

Use the filtering panel at the top of the GL Reconciliation Cube dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.

Period: one value

Visual components​

View nameType of viewWhat it shows
SummaryWorksheetLists reconciliation statistics by group, such as company and bank, across all reconciliation statuses, with:
  • Postings Imported: the total GL entries imported for the selected period
  • Automatically Reconciled Entries: the count and percentage reconciled automatically
  • Manually Reconciled Entries: the count and percentage reconciled manually
  • Non-Reconciled Entries: the count and percentage not reconciled in the selected period
  • Year to date metrics: YTD Imported Entries, YTD Auto Reconciled %, YTD Manual Reconciled %, YTD Not Reconciled %
Top 10 CompaniesHorizontal BarRanks the top 10 companies by transaction volume.
Top 10 BanksHorizontal BarRanks the top 10 banks by the number of GL transactions.