Advanced Account Activity Report

Overview

For Legal Pro and Enterprise plan users, the Account Activity Report lists the detailed invoice and payment transactions that make up each client's account activity over a selected date range. Use this report when you need a line-by-line audit trail of billing and payment activity, rather than just summary totals.

Accessing the Account Activity Report

1. Go to the Reports tab.
2. Select the Advanced tab.
3. Scroll or search for "Account Activity." If searched, look for the result with the Advanced badge next to it.
4. Click Open.

Using Filters

The Account Activity Report opens with these filters:

• Date: choose a preset range (e.g. Today, This Month, This Year) or a Custom Range. Defaults to This Month.
• Client
• Matter
• Account Manager
• Client Type
• Matter Type
• Balance View: controls how the running Balance column is calculated. Defaults to Client.
• Currency Code: defaults to your firm's primary currency. Change it if you bill across multiple currencies and want to isolate one.

Click Filters to add more: Matter Assigned To and Item Type.

If your firm is on the Enterprise plan, any custom fields you've configured are also available here as additional filters. Custom field availability is contextual to the report; only fields for the record types actually included in this report will appear. For example, invoice custom fields won't show up as filters on a report that doesn't include invoice data.

Once you land on a combination you'll use again, click Save Filters to to mark it as a favorite, making it accessible from the Favorites report category.

Running the Report

Set your filters and click Run Report. The grid below updates with the individual invoice and payment transactions matching your filters. If it comes back empty, check your date range first, that's the most common reason a report shows nothing.

Understanding the Report Grid

Each row represents a single transaction, such as an invoice being issued or a payment being received. The below are the key columns.

• Client / Client ID
• Matter / Matter ID
• Date
• Item Detail / Description
• Unbilled Labor / Unbilled Expense / Total Unbilled
• Invoiced Labor / Invoiced Expense / Total Invoiced
• Total Paid / Total Refund
• Credit Adjustments / Debit Adjustments
• Credit Amount / Debit Amount
• Balance

Customizing the Report Grid

• Columns: click Columns to show or hide any of the fields above, plus other available columns beyond the defaults listed here.
  • Enterprise plan firms will also see the same custom fields available here as additional columns, following the same contextual rule as the filters above.
• Reordering and resizing: drag column headers to rearrange them, or drag column borders to resize.
• Sorting: click a column header to sort by that field; click it again to reverse the order.
• Page size: the items-per-page menu at the bottom controls how many rows show at once (100 by default, up to 1000), with page controls next to it for the rest.

Exporting the Report

Click Export and choose Export to Excel to download the current view.

Tips & Common Use Cases

• Use this report to answer client questions about specific charges or payments on their account.
• Run it before a client meeting to walk through account history transaction by transaction.
• Reconcile the running balance against your accounting system to catch discrepancies early.

Related Articles

• Advanced Reporting (overview)