GL Reconciliation Report

GL Reconciliation 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. 
LabelsSelecting 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 ReconciliationThis 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 SortThis will display the Details Report in the order they are displayed.
By IDThis will sort the order of the data by employee ID.
By Payrun NoThis will sort the order of the data by Payrun number.
By GL A/CThis will sort the order of the data by General Ledger Account.
By SequenceThis will sort the order of the data by the Transaction Sequence Number.
By Payrun No and GL A/CThis will sort the order of the data by Payrun number and General Ledger Account.
By GL A/C and Payrun NoThis will sort the order of the data by General Ledger Account and Payrun number.

Report Selection Menu

Active OnlyThis 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 buttonSelect this button to Print the Report.
Cancel buttonSelect this button to Cancel the Report.
Record List ButtonSelecting 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 ButtonWhen active, the Options Button allows for even further customisation of the Report.
Queue ButtonSelecting 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 ButtonSelecting 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?