G.L. Transaction Ledger Report

The Transaction Ledger Report lists transactions by General Ledger account code including debit and credit amounts in the transaction and base currencies.

This report lists General Ledger transactions for specified accounts and periods.

When the report is output to View or PDF, the information available in the generated report is:

  • Ledger (Code: P=Payables, R=Receivables, G=General Ledger).
  • Code (For Receivables a 6 Character Debtor Code, For Payables a 6 Character Creditor Code).
  • (Debtor or Creditor) Name.
  • Tran(saction) Date.
  • (Transaction) Reference.
  • Transaction Item (Booking reference for bookings related transactions; the original invoice reference for non booking transactions).
  • (Transaction) Currency.
  • Debit (Amount).
  • Credit (Amount).
  • Base Debit (Amount).
  • Base Credit (Amount).
  • Details (Transaction Reference).
  • (Transaction) Description (Line) 1.
  • (Transaction) Description (Line) 2.
  • Debit Posting (Account).
  • Credit Posting (Account).

When running the report to a CSV file the following fields are also available:

  • Account (Number).
  • Account Name.
  • Posting Period.
  • Opening Balance.

NOTE: Data can be ordered by specific options, and order by settings selected within the Other Tab.

The report can be generated with the following parameters:

  • Order By.
  • Consolidate Transactions.
  • Show.
    • Descriptions (Yes or No).
    • Future Entered Transactions (Yes or No).
    • All Ledger Accounts (Yes or No).
Example Transaction Ledger Report:

Transaction Ledger Reports can display the opening and closing balance in transaction currency (if one is selected).

Generating a Transaction Ledger Report

  1. From the Home menu, select .
    1. Click the Reports menu to expand it:

    2. Click the Financial Reports menu option to expand it:

    3. Click Transaction Ledger to go to the Transaction Ledger Parameters screen:

  2. On the blank Transaction Ledger Parameters screen, the Balance Tab will open. Select the required parameters for the Transaction Ledger Report

    NOTE: There are 2 tabs available to select parameters from. These are the Balance Tab and the Analysis Tab (Agent and Supplier).

  3. Check the completed screens.
  4. Click on the Other Tab. Select how the results are to be ordered and filtered in the report from the dropdown selections or checkboxes available.
  5. Select how the report is to display.
    1. To view the report, click .

    2. To Download the report to a PDF file, click .

    3. To Download the report to a CSV file, click .

About Transaction Ledger Parameter Fields

Balance Tab

Period From/To

General Ledger Posting Period range.

Account Code From/To

Transaction General Ledger Account (or range of) - Type the full and correct account code(s).

Transaction Period From/To

Transaction Period (or range of).

Branch

Multi select options for available (Transaction G.L.) branches.

Department

Multi select options for available (Transaction G.L.) departments.

Currency

Multi select options for available (GL Transaction) currency.

All Ledger Values

Multi select Ledger options for All, (G) General Ledger, (P) Creditors and (R)Debtors.

Analysis Tab (Agent and Supplier Analysis)

Analysis Codes 1-6

Multi select list of Debtor Analysis codes and/or Creditor Analysis codes can be used to refine the report if necessary. To expand the fields use the +, and to minimise the list use the -.

NOTE: Analysis codes in the above screen capture are used for training purposes. Users company systems will have analysis fields and codes unique to their organisational requirements.

Other Tab

Order By

GL Transaction Ledger Parameters allow the selection of one of three order by options:

  • Account, Period (Default).
  • Account.
  • Account, Ledger, Tran(saction) Type, (Transaction) Reference.

Consolidate

Dropdown selection available to consolidate by:

  • No Consolidation (Default).
  • By Transaction.
  • By Transaction Line.

Show Description

Checkbox to show transaction descriptions (Default checked).

Show Future Entered Transactions

Checkbox to include Future Entered Transactions.

Show All Ledger Accounts

Checkbox to include All Ledger Accounts.