Subledger Reconciliation

Overview of Subledger reconciliation view

The view of the main page of the report is shown in the following screenshot

The below table explains the columns on the main grid:

You can right click on the specific row (Company) and select Drill through, which gives you the option to go to a new page (the relevant ‘details’ page) with additional information:

Following columns will be shown on the drill through page:

• Depending on which ‘details’ drill through page you chose, in the column instead of Client Amount can be Vendor/Bank Amount. Similarly, in these cases Difference column would show the difference between the amount posted through the Vendor/Bank subledger and the general ledger.

You can hover over any row of the main table what gives you the tooltip with additional transaction details:

The visual at the top of the page shows additional information – through which GL posting layer the vouchers of a relevant selection were posted (Current or Operations layer). Ledger Amount in this case represents the total amount posted through the general ledger during the selected period (and for other parameters selected on the main page). Therefore, that amount may differ from the Ledger Amount shown in the main table, as the table only includes vouchers that generated a difference compared to the subledger amount.

By clicking on the specific GL voucher in the main table, the visual on top will update and indicate through which layer that voucher was posted. This is a quick way to check the specific GL voucher you are interested in:

If you want to get a list of all the vouchers that have been posted through a particular layer (e.g. Operations), you can right click on Ledger Amount and use the additional drill through page ‘Posting Layer Details’

Returning to the main page, on the Clients/Vendors/Bank grids we can see the list of main accounts for which the difference (between the amount posted through the relevant subledger and the general ledger) was generated.

You can right click on the specific row (Main Account) and select Drill through, which gives you the option to go to a new page (the relevant ‘details’ page) with additional information.

Following columns will be shown on the drill through page:

• In the same way, if you right clicked on the Vendors/Bank grid, in the column instead of Client Amount can be Vendor/Bank Amount. In these cases Difference column would show the difference
  between the amount posted through the Vendor/Bank subledger and the general ledger.

All subsequent steps and features described above (tooltip, information on posting layer and additional drill through page ‘Posting Layer Details’) are available here as well.