Skip to main content
All CollectionsUser GuideFinancial Reporting
Enhanced Reporting - Ledger Account Review Report
Enhanced Reporting - Ledger Account Review Report
G
Written by Geoff Ostrega
Updated over 2 months ago

Description

The Ledger Account Review Report is an analytical report that displays all journal lines for the selected Ledger Account, including related Ledger Account journal lines from transactions where the selected Ledger Account has been included. For example, if you select a Cash Ledger Account, the Review Report will return the Cash journal lines, along with journal lines such as Expense or Revenue lines that were used in transactions on the other side(s) of the Cash (e.g. both debit and credit sides).

Use Cases

See a few use cases to get better idea of how best to utilize the Ledger Account Review Report:

  1. Cash Flow Analysis

    • Use Case: A finance team wants to analyze cash movements in detail, including how cash inflows and outflows are tied to other accounts like revenue, expenses, or accounts receivable.

    • How the Report Helps: By selecting a cash ledger account, the report provides visibility into all cash-related journal entries, including the offsetting accounts, allowing the team to track cash sources and uses effectively.

  2. Audit Preparation and Reconciliation

    • Use Case: During audits or month-end reconciliations, an accountant needs to ensure that transactions tied to a specific account, such as "Accounts Receivable" or "Inventory," are accurately recorded and balanced.

    • How the Report Helps: This report shows all journal entries impacting the selected account and their corresponding offset entries, making it easier to identify discrepancies, missing entries, or improper allocations.

  3. Expense and Revenue Attribution

    • Use Case: A manager needs to review how expenses or revenues are tied to specific transactions and ensure proper allocation across various accounts.

    • How the Report Helps: By selecting an expense or revenue ledger account, the report reveals all journal entries related to that account and the corresponding entries, such as cash or accounts payable, providing a clear picture of the flow and allocation of funds.

      Each use case demonstrates how the report provides granular visibility into journal entries and their relationships, helping with analysis, accuracy, and compliance in financial reporting.

Report Configuration Settings

Ledger Account Review Report config
  • Location:

    • Choose the Location to focus on for your report. The report will show transactions for the selected Location and its child Locations.

    • Defaults to the Location Context Picker if not set

  • LedgerAccount:

    • Select the specific Ledger Account to run the report on. This is a required input.

Filtering

The Ledger Account Review Report offers extensive filtering capabilities. The journal lines in the report table will always be sorted by Journal Number descending.

Below is a table of available columns within the report and their properties:

Field

Default

Sortable

Filterable

Line ID

Journal ID

Number

Status

Ledger

Location Name

Account Name

Account Number

Reference

Description

Transaction Date

Posted Date

Reporting Currency

Reporting Debit

Reporting Credit

Posted Currency

Posted Debit

Posted Credit

Type

Notes

Reverse Date

Journal Created

Journal Updated

Reconciled

System Job

Account Type

Account Subtype

IC Account Name

IC Account Number

Cost Center

Cost Center ID

Product

Product ID

Batch Payment

Transaction Type

Customer Name

Vendor Name

Invoice

Bill

Payment

Sales Order

Location

FX Rate

IC Location ID

ICLocation Name

ICLocation Reporting Currency

Cash Receipt

Vendor Credit

Job #

Job

IC Line

Elimination Line

Reversal Line

Created At

Updated At

The filters listed above are accessible by clicking the Filters button and selecting one or more fields to filter:

Ledger Account Review Report Filters

Column Header Actions

For information on column header actions, please refer to the corresponding section in the Enhanced Reporting Overview article-->


Ledger Account Review Report Manage Columns

Drill-Downs and Nested Fields

The report supports drill-downs for detailed transaction data. To select an item in this report, identify a column that has blue text, and click on the text. This will open a detailed view of the selected item. Here's a list of available drill-downs:

Field

Description

Batch Payment

Opens up the Batch Payment so you can see its full details, Payments, Journal Lines, and Audit Logs

Bill

Opens up the Bill so you can see its full details, Payments, Journal Lines, and Audit Logs

Cash Receipt

Opens up the Cash Receipt so you can see its full details, Payments, Journal Lines, and Audit Logs

Customer Name

Opens up the Customer so you can see its full details, Contacts, Addresses, Sales Orders, Payments, Journal Lines, Pricing and Part Numbers

Invoice

Opens up the Invoice so you can see its full details, Emails, Payments, Journal Lines, and Audit Logs

Journal ID

Opens the Journal view with data and transactions

Number

Opens the Journal view with data and transactions

Sales Order

Opens up the Sales Order so you can see it's full details, line items, emails, fulfillments, unfulfillments, stock adjustments, journal lines, and audit log

Vendor Credit

Opens up the Vendor Credit so you can see its full details, Payments, Journal Lines, and Audit Logs

Vendor Name

Opens up the Vendor so you can see its full details, Contacts, Addresses, Bills, Payments, Journal Lines, Pricing and Part Numbers

System Job

Opens up the System Job so you can see its full details, Journal Lines, and Audit Logs

Saving and Sharing Report Configurations

For information on saving and sharing report configurations, please refer to the corresponding section in the Enhanced Reporting Overview article-->

When a report is saved the following configuration is saved:

  • Visible Columns

  • Column Order

  • Column Width

  • Pinned Columns

  • Filters

  • Location

  • Ledger Account

  • Page Size

Exports

The Ledger Account Review Report will be exported in xlsx format.

Ledger Account Review Report Export

Ledger Account Review Report Export
Did this answer your question?