GL Reconciliation Report - Generate Powerful Reconciliation Reports

GL Reconciliation Report Overview

The GL Reconciliation Report within SapphireOne Payroll/HR Mode generates an audit style report for the Journal to be transferred to the General Ledger. 

When the GL Reconciliation Report is selected from the PayRoll/HR History Reports menu, SapphireOne will present a print dialog screen for the user to select and customise the criteria and data they would like included within the report.

Print Destination Menu

The Print Destination Popup Menu allows the user to choose the destination for the Report, and select from the options which include Printer, Custom Report, Quick Report and Labels.

Printer  Tells SapphireOne to send the report straight to the Printer. 
Custom Report  This allows the user to create a custom designed report. Once it has been created the user will be able to use this option from the Print Destination menu. 
Quick Report  Selecting this option will open the Sapphire Quick Report function. 
Labels Selecting this option will open the Sapphire Label Design Report Editor, allowing the user to design Labels as required. Labels can be designed and printed on a sheet or roll.

Report Type Menu

Selecting the Report Type menu option will enable the user to print different layout styles of the Details Report.

GL Reconciliation This provides an audit style report for the accumulative totals to be posted or entered into the General Ledger. The report allows you to reconcile PayRoll against the General Ledger Journals generated.

Report Sort Order Menu

The Report Sort Order Menu allows the user to select from various sorting methods and criteria to organise data in different sequences while still maintaining the same fundamental report format. The user can sort data by:

No Sort This will display the Details Report in the order they are displayed.
By ID This will sort the order of the data by employee ID.
By Payrun No This will sort the order of the data by Payrun number.
By GL A/C This will sort the order of the data by General Ledger Account.
By Sequence This will sort the order of the data by the Transaction Sequence Number.
By Payrun No and GL A/C This will sort the order of the data by Payrun number and General Ledger Account.
By GL A/C and Payrun No This will sort the order of the data by General Ledger Account and Payrun number.

Report Selection Menu

Active Only This will only display transaction records that are currently active. All inactive records will be excluded from the report.
All Records  This will display all transaction records, including inactive records.

Report Buttons

Print button Select this button to Print the Report.
Cancel button Select this button to Cancel the Report.
Record List Button Selecting this button brings up a list of all inventory items within the users SapphireOne data file. The user can then use the ‘command/F’ and ‘ctrl/F’ search function to search for the inventory item to be printed.
Options Button When active, the Options Button allows for even further customisation of the Report.
Queue Button Selecting this button will put the report in a Queue, allowing the user to select the time and day for the report to run and print.
Background Button Selecting this button allows the user to run the report in the background of the SapphireOne server, allowing the user to continue with other tasks while the report is generating.

The user also has the option to create custom reports using SapphireOne Quick Reports or Custom Reports. 


You can review our Blog and YouTube channel for additional information and resources on SapphireOne ERP, CRM and Business Accounting software.

Was this helpful?