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)
• 6 Character 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)
• (Transaction) Description (Line) 1
• (Transaction) Description (Line) 2

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

• Account (Number)
• Account Name
• Posting Period
• Opening Balance
• Debit Posting (Account)
• Credit Posting (Account)

The report can be generated with the following parameters:

• Period From and to
• Show
  • Deceptions (Yes or No)
  • Future Entered Transactions (Yes or No)
  • All Ledger Accounts (Yes or No)

• Consolidate Transactions

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 Home > Reports > Financial Reports > Transaction Ledger.
   

   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 (Agent and Supplier) Analysis Tab.

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 drop-down selections or check boxes available.
5. Select how the report is to display.
1. To view the report, click View.

   

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

   

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

   

4. To print from NX, click Print.

   

Period From and To - General Ledger Posting Period range.

Account Code From and To - Transaction General Ledger Account Number range.

Transaction Period From and To - Transaction Period range.

Branch - Multi select  Transaction G.L. Branch check boxes.

Department - Multi select Transaction G.L. Department check boxes.

Currency - Multi select GL Transaction Currency check boxes.

All Ledger Values - Multi select Ledger check boxes for All, (G.L.) General Ledger, (P) Creditors, (R)Debtors.

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.

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 - Drop down selection available to consolidate by:

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

Show Description - Check box (Default checked).

Show Future Entered Transactions - Check box to include Future Entered Transactions.

Show All Ledger Accounts - Check box to include All Ledger Accounts.