Accessing the Ledger Report

In this article:

• How to Access the Ledger Report
• How Filtering Works
• Additional Filter Options
• Predefined Ledger Views
  • Common Views and Their Purpose
• When a Predefined View Is Not Enough
• Helpful Tip

The Ledger report displays detailed financial transactions recorded against files. It is used to review fees and time entries, expenses and disbursements, payments and receipts, trust transactions, work in progress (WIP), and account balances (AR, Trust, Retainers)

How to Access the Ledger Report

Follow these steps to generate a Ledger report:

1. Go to Reports > Contact > Ledger

2. Click the dropdown icon to open the Ledger Options window

3. Select a View

   • Views are predefined report layouts designed for common use cases

4. Choose an output format under Generate To

5. Click Play to run the report

How Filtering Works

Filters are applied before the report is generated to limit results to only the data you need. You can filter the Ledger report by:

• Date range

• File

• Contact

• Responsible Lawyer

• Working Lawyer

• File Introducing Lawyer

• Area of Practice

• Referral

• Billing Group

• Tax Group

• Interest Group

• Rate Group

• File Group

• Department

• Tag

Additional Filter Options

You can further refine results using advanced filters, including:

File Status and Balances

• Include or exclude closed files

• Exclude on-hold files

• Exclude contingency files

• Exclude TAF-exempt files

• Show firm totals only

• Filter files with:

  • AR balances

  • Trust balances

  • WIP balances

  • Retainer balances

Billing and Entries

• Include Billed, Unbilled, or Both

• Ignore billing date for status

• Only include files with unbilled charges above a set amount

• Treat Provisional Write-Offs as finalized

Entry Type Filters

Filter by transaction type, such as:

• Billable Fees

• Non-Billable Fees

• Hard Expenses

• Soft Expenses

• Operating Receipts

• Trust Entries

• Other Entries

Trust-Specific Filters

• Filter by payment method

• Include In, Out, or Both

• Filter by Bank Account

Display Options

• Control entry sort order

• Show Top Clients Summary

Predefined Ledger Views

The Ledger report includes predefined views designed for common reporting scenarios.
Each view automatically applies specific filters and layouts.

Common Views and Their Purpose

• ledger – Full detailed client ledger

• ledger tr – Trust ledger with detailed trust transactions

• listing tr – Trust listing of files with trust balances

• cash in – Files that received cash payments over a specified amount

• tl cash in – Trust cash payments over a specified amount

• client wip – WIP, billings, collections, and adjustments

• client wip referral – Same as Client WIP, grouped by referral source

• wip detail – Unbilled charges by file with entry details

• wip matter – Unbilled time, fees, and disbursements by matter

• wip summ – WIP summary by fee earner

• wip + ar + trust – Combined outstanding AR, Trust, Retainers, and WIP

• fee – Listing of files with time and fee entries

• expenses – Hard and soft costs within a date range

• expensesint – Unbilled costs plus calculated interest

• costanalysis – Detailed cost breakdown by type and billing status

• costanalysissummary – Summarized cost totals

• summary – Client summary for files with balances

• summaryall – Client summary for all files

• taf listing – Trust Administration Fees by criteria

• top all fees – Clients ranked by total fees

• top billed disbs – Clients ranked by billed disbursements

When a Predefined View Is Not Enough

If a predefined view does not fully meet your needs:

1. Start with the closest matching view

2. Apply additional filters to refine the results

If you still cannot generate the report you need:

• Submit a support ticket and include:

  • What you have already tried

  • The report you generated

  • What information is missing or required

While not all report variations are available, the team can review possible options.

Helpful Tip

To quickly find a specific entry in the report:

• Press CTRL + F on your keyboard

• Use your browser’s search function to locate text within the report