Enhanced Reporting - Ledger Account Review Report

Created by Travis Lander, Modified on Wed, 27 Nov at 3:32 PM by Travis Lander

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
Report Configuration Settings

Use Cases

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

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.
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.
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

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