General Ledger

General Ledger Report Overview

The General Ledger Report in SapphireOne PayRoll/HR Mode generates a detailed report for all General Ledger accounts within the users datafile. This is useful for checking that the correct General Ledger accounts have been used for the appropriate expenses and liabilities. 

When the General Ledger Report is selected from the PayRoll/HR 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. 
CSVThis outputs a CSV file that may be opened by an external spreadsheet application.

Report Type Menu

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

One LinerThis is a simple report giving contact information. 
Two LinerThis expands on the above report with basic address details. 
Four LinerThis report gives full address details. 
Loan ProgressThis generates a General Ledger Loan report for each General Ledger account, including details such as Interest, Liability Remaining, Interest Remaining.
Audits Base StyleThis option enables the user to generate a Basic Audit report for the General Ledger. During the process the user will be asked if instead of printing it, SapphireOne will generate a CSV file which may be opened with any spreadsheet program.
Audits Full StyleThis option enables the user to generate a Full Audit report for the General Ledger. During the process the user will be asked if instead of printing it, SapphireOne will generate a CSV file which may be opened with any spreadsheet program. 
Audits Old Full StyleThis option enables the user to generate a Full Audit report for the General Ledger with legacy styling. During the process the user will be asked if instead of printing it, SapphireOne will generate a CSV file which may be opened with any spreadsheet program. 

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 Account ID Sorted and totalled by each General Ledger Account ID.
By UDF 1Sorted and totalled by UDF-1.
By Alternate IDSorted and totalled by Alternate ID.
By ClassThis will sort the order of the data by Class.
By DepartmentThis will sort the order of the data by Department.

Report Selection Options

All Records This will display all transaction records, including inactive records.
By DepartmentThis will sort the data by Department.

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?

Previous Article

Payment Summary

Next Article

Employee Super Summary