Using the Payroll G/L Transactions Report

Print this report after printing and posting payroll, but before using the Generate G/L Batch feature.

This report includes only G/L transactions that will be created on request using Generate G/L Batch. It does not include G/L transactions created during payroll posting. To review the G/L transactions created during payroll posting, use the G/L Transactions report in Reports > Payroll > Bank Reports.

Information on the report

• The year and pay period number in which the transaction occurred.
• The G/L account that is debited or credited by the transaction.
• If you consolidate G/L batches, all debits to a single account within an entry are collapsed into a single detail and all credits to a single account within an entry are collapsed into a single detail.
• The Transaction Date is based on the Journal Entry Date option you chose on the Integration tab of the Payroll Options window . It is either the check date or the pay period end date. If you consolidate G/L batches, the transaction date is the first date of the fiscal period to which the consolidated entry is posted.
• The posting sequence number of each group of transactions.
• The source code assigned to each transaction. The source codes are:
  • CP-SC (system checks), CP-RC (reversed checks), and CP-CO (consolidated).
  • UP-SC (system checks), UP-RC (reversed checks), and UP-CO (consolidated).
• The transaction Reference is based on the G/L Reference Field option you chose on the Integration tab of the Payroll Options window . You can choose from:
  • Employee Name
  • Check Number
  • Check Date
  • Check Number and Date
  • Posting Date
  • Pay Period Dates
  • Posting Sequence-Calculation Sequence
  • Class 1-4 Value
• The transaction Description is based on the G/L Description Field option you chose on the Integration tab of the Payroll Options window . You can choose from:
  • Employee Name
  • Check Number
  • Check Date
  • Check Number and Date
  • Posting Date
  • Pay Period Dates
  • Posting Sequence-Calculation Sequence
  • Class 1-4 Value
  • The amount by which the transaction debits or credits the G/L account.
  • For reports sorted by account, the total debit and credit amounts for each reported account.
  • For reports sorted by year and period, the total debit and credit amounts for each reported year-period.
  • The total debit and credit amounts for all reported transactions.

Consolidating G/L batches

If you choose the Payroll G/L Integration setup option to consolidate G/L batches, certain details will be consolidated (as described above) on the Payroll G/L Transactions report. To print all transactions in detail on the Payroll G/L Transactions report yet send consolidated batches to General Ledger, set the option to NOT consolidate G/L batches when you are processing payrolls. Then, when you are ready to run the function to create G/L batches, change the option to either of the consolidate G/L batches options (account/fiscal period or account/fiscal period and source code).

To print the report

1. From Payroll Transaction Reports, select Payroll G/L Transactions.
2. Enter the posting sequence through which to base the report.
3. Select either Detail or Summary for the report format.
4. Choose to sort the report by either Account or Year and Period.
5. Click Print.
6. When finished, click Close.