Skip to main content

Journal Entries Details Report

Distributor steps for running the Journal Entry Detail report in Encompass to trace GL journal entries back to invoice transactions and investigate account variances. Requires v22.01+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 22.01

Pre-Conditions

The Journal Entry Details report is a great way to investigate Journal Entries that are derived from Invoice Transactions. There are many columns and filters that can be used to setup the report perfectly for your business case.

Steps

  1. Navigate to the Report Library dashboard using the universal search bar.
    ​
    ​

  2. Select the Admin Report tab.
    ​
    ​

  3. Click the Accounts Payable/GL category.
    ​
    ​

  4. Click the Journal Entry Detail report.
    ​
    ​

  5. Use the different filters and add columns you would like to reflect on the report.
    ​
    ​

  6. The Journal Entry Details report offers a wide variety of ways to analyze accounting data. It offers filtering, grouping and ordering. As well as a choice of columns to display.
    ​
    ​

  7. Click Create Report.

Best Practices

  • When running this report keep in mind that the different Account Mapping tables (Income Account Maps, Asset Account Maps, Etc) control the accounts used for transactions.

  • Commonly used filters are Account, Account Type, and Date Range. These will often help isolate transactions when investigating variances

  • One of the most powerful Columns on this report is Invoice Num. Invoice Num populates a link to the related Invoice Transactions that generated the Journal Entries.

  • Manipulate the Columns and Filters to better help your investigation.

Did this answer your question?