QRG General Ledger - Key Information

​

About

​

Prerequisites

1. 2cloudnine Payroll Users must be running the Salesforce Lightning Experience.
2. Ensure the latest General Ledger Package is installed.
3. The configuration must be completed by Consultants as outlined in the 2cloudnine General Ledger - Configuration and Implementation Guide.
4. Pay Codes must be appropriately set up and functional.
5. Users processing within the General Ledger objects must have access to create, edit and delete the records

​

Definitions

• Accounting Payroll Journal 2cloudnine Payroll is able to produce Cost of Payroll Journals and Leave Accrual Journals which are collectively referred to as Accounting Payroll Journals. These journals are created against each completed Pay Batch
• Accounting Invoices 2cloudnine Payroll is able to produce AR invoices that are summarised and split by the General Ledger Revenue posting accounts. These Accounting Invoices are created from Temp, Perm and Fee invoices
• Accounting System Setup The Accounting System Setup is where all default General Ledger posting accounts, departments and Costs codes are defined. It is the key setup record from which the creation of Accounting Payroll Journals and Accounting Invoices are based.
• Accounting Segments Accounting Segments define accounting dimensions that are associated together by 2cloudnine Payroll to form various Accounting Payroll Journals and Accounting Invoices. These are available to be created in the various record types of:
  • Payment Entity
  • Invoice Entity
  • Natural Accounts
  • Assignment Departments
  • Cost Codes
  • Locations
• Accounting Assignment Department Accounting Assignment Departments allow the users to further split a Payroll Journal or Accounting Invoice across one or more departments
• Accounting Default Accounts The Accounting Default Accounts are used by the General Ledger package to automatically assign the default Natural Account dimension for a specified Pay Code, which is different from the Default Natural Account specified in the Accounting System Setup record.
• Accounting Payment Entity Defaults The Accounting Payment Entity Default record contains all the Default Accounting dimensions of each Payment Entity.
• Employment Costs and Assignment Costs Employment Costs are used within both Rate Calculators to define employment costs for the Invoice Rate calculation, as well as in the General Ledger, to detail the specific employment costs that need to be accounted for as additional on costs in the Payroll Journals. This includes support for Payroll Tax, Workcover and Superannuation calculations for each Pay Transaction.
• Employment Cost Template Groups Employment Cost Template Groups are used to define a group of Employment Cost records to be created on the related Assignment.
• Locations The Locations record holds the location information that is used to filter and relate Employment Cost Item records.
• Pay Transaction Distribution Pay Transaction Distribution records are a breakdown of all the Employment Costs against each Pay Transaction. Note that these are created once the Pay Batch associated with the Pay Transaction has a status of Payment File Released.

​

General Ledger Interface Appearance and Usability

• The pages within the General Ledger package are Lightning Enabled and must only be used when the Salesforce Lightning Experience is active.
• All dates and times are displayed as per the location of the logged in User.
• Currency is calculated at 6 decimal places.
• The default display resolution supported for the General Ledger package is 1920 x 1080 (1080p) scaled at 100%. The minimum display resolution supported is 1024 x 768 as per the Salesforce standard.
• The pages within the General Ledger package will automatically resize in width and height so that the components are stretched appropriately depending on resolution.
• In the event that the fields / tabs within the package are unclear or overlap, zoom out (or zoom in) through the web browser as needed.

​

General Overviews

​

Core Setup

• QRG Accounting System Setup (Steps 1 and 2)
• Accounting Segments:
  • QRG Create Accounting Segments - Payment Entity
  • QRG Create Accounting Segments - Invoice Entity
  • QRG Create Accounting Segments - Natural Account
  • QRG Create Accounting Segments - Assignment Department
  • QRG Create Accounting Segments - Cost Code
  • QRG Create Accounting Segments - Location
• QRG Accounting System Setup (Step 3)
• QRG Accounting Payment Entity Defaults
• QRG Accounting Invoice Type (if invoicing occurs in this Org)
• Accounting Default Accounts:
  • QRG Accounting Default Account - Earnings
  • QRG Accounting Default Account - Deductions
  • QRG Accounting Default Account - Allowances and Expenses
  • QRG Accounting Default Account - Leave Rules
• QRG Create a Location Record
• QRG Create an Employment Cost record - All record types
  • Payroll Tax
  • Custom Cost 1, 2, 3, and 4
  • Custom Post Cost 1, 2, 3, and 4
  • Insurance
  • Superannuation
  • WHS
  • WorkCover
• QRG Create an Employment Cost Template Group

​

Referencing GL data

• Assignments to reference the Department:
  • Creation of Accounting Assignment Departments (created automatically if the Department field is populated on the Assignment record).
• Assignments to reference the Employee Cost Template Group:
  • Creation of Assignment Costs
  • Pay Transaction Distributions will create and report in the Payroll Journal
• Timesheet Entries to reference the Cost Codes:
  • Payroll Journal will breakdown to the Cost Codes

​

System Processes

• Generate Invoices
  • QRG Create an Accounting Invoice
• Progress Pay Batch to Payment File Released
  • Payroll Journal creates automatically