Related topics

About Bank Reports

Using the Bank G/L Transactions Report

The G/L Transactions report is a list of the general ledger transactions created from all posted transactions and revaluations (in multicurrency ledgers).

Use the report as your audit trail for generated general ledger transactions.

When to print

  • Before using the Create G/L Batch window to send transactions to the general ledger.

    Note: You cannot print the G/L Transactions report if you use the option Create G/L Transactions During Posting. In this case, the program sends the transactions immediately to General Ledger. However, you can print a report of the transactions in General Ledger using the Batch Listing Report form, available in the G/L Reports folder.

  • After you clear printed posting journals (or transaction history, depending on the Sage HRMS program you are using), you can no longer print the G/L Transactions report.

Information on the report

  • The level of detail for transactions on the detailed report depends on your choice for the Consolidate G/L Batches option. For example, if you selected Consolidate by Account and Fiscal Period, the report shows a total for each general ledger account and fiscal period. If you selected Do Not Consolidate, the report shows full details for each transaction.
  • You can print detailed or summary versions of the report. A summary report lists one total for each account number.
  • If you have a multicurrency system and you print a detailed report in source currency, the report shows the exchange rate used to calculate the functional-currency equivalent of each transaction amount.

To print the report

  1. From the Navigation Pane, select Reports > Payroll > Bank Reports > Transactions
  2. In the G/L Transactions report window, select:
    • The latest posting sequence number for which to send transactions to the General Ledger. The report lists all transactions for posting sequences up to and including the number you specify.
    • A detailed or summary report.
    • If you are printing a detailed report, use the Sort By field to specify the order in which to list transactions.
    • If the account is multicurrency, whether to include transaction information in your company's functional currency or in the source currencies of the transactions.
  3. Click Print.

After printing the report

Run Generate G/L Batch (from the Navigation Pane, select Payroll > Task >  Generate G/L Batch) to send the transactions to General Ledger.

Additional information

If you do not use Sage HRMS General Ledger, your program creates the general ledger batches in a CSV (Comma Separated Values) file, tailored to the Sage HRMS General Ledger format.

You can send the file to a remote location that uses Sage HRMS General Ledger, or modify the information in the file for another general ledger program.