For more general information on how to find and run MerusCase reports, visit our Reports page.
This Billing Reports article will provide more in-depth summaries regarding each individual billing report in the MerusCase system, and what information the reports capture.
Cash Flow by Attorney Responsible
This report is viewable by users with the following permission levels: Administrator, Power User with Accounting. This report is available in the Reports > Accounts Receivable section.
Displays all invoices (fees and expenses), receivables, and write offs by Attorney Responsible, for a specific time frame. The report displays sums of invoices for a specific time frame based on the invoice billed date.
Expenses (pass-through costs) are separated from fees. Cases without an Attorney Responsible present are included; branch offices are determined based on the company associated with the Attorney Responsible. It is assumed, unless otherwise specified on per-invoice basis, that receivables on partially reconciled invoices should be applied to expenses first. The 'unidentified' entry is a sum of all invoices, receivables, and write-offs for cases without an Attorney Responsible assigned.
The columns included on the Cash Flow by Attorney Responsible Report are:
- Attorney Responsible: The user assigned to the 'Attorney Responsible' field from the staff section of a case. The 'unidentified' entry is a sum of all invoices, receivables, and write-offs for cases without an attorney responsible assigned.
- Branch Office: The branch office set on the Attorney Responsible's account under tools & settings (gear icon in the top right corner of Merus) > my account.
- Fees Invoiced: This includes any ledger items invoiced that fall under the 'Invoice' ledger type.
- Expenses Invoiced: This includes any pass-through costs or ledger items invoiced that fall under the 'Expense' ledger type.
- Fees Paid: This column reflects any receivables made on an invoice. The column will only reflect a receivable if the receivable is allocated and applied to the invoice's invoice-type ledger entries.
- Expenses Paid: Similar to above, this column reflects any receivables made on an invoice. The column will only reflect a receivable if the receivable has been allocated and applied to an invoice's expense-type ledger items. By default, allocating and applying a receivable to an invoice will always be applied to expenses first over fees unless manually specified.
- Write Down: This column reflects any discounts, write-downs, cash discounts made on an invoice.
PLEASE NOTE: This report uses the billing date/billed date on invoices, to determine whether or not an item will appear on this report, for the specific date range.
For example, if this report is run for 12/1/21 - 12/31/21 but the billed date of an item does not fall into that range, that item will not appear on this report. Below in yellow is an example of where the billing date/billed date appears on an invoice, for reference:
A/R Ledger Report by Ledger Type
This report is viewable by users with the following permission levels: Administrator, Power User with Accounting. This report is available in the Reports > Accounts Receivable section.
The purpose of the report is to capture the transactions going in and out of the firm based on ledger type.
Reports with Payment type ledgers also display the check number as Reference Number, and Payment Method.
The columns included on the A/R Ledger Report by Ledger Type are:
- Case Number
- Client/Case
- Bill To
- Description
- Ledger Type
- Invoice Number
- Date Posted
- Billed By
- Logged By
- Costs
PLEASE NOTE: This report uses the date posted, to determine whether or not an item will be included on this report, inside a specific date range.
For example, if you go to a Case > $ (Ledger Tab) > Operating Account & Time Tracking > Click a ledger Item > the Date field here is the date posted referred to above. This date posted is NOT the same as the date the item was created. The dates could be different in the system. Below in yellow is an example of where this date is located, inside a ledger item, for reference.
