Matter Balances Report

This will show the total that is due for all invoices for that matter as of the date. An invoice must be dated on or before the report date to affect the value in this column and must have an amount unpaid or owing as of the date of the report.

For example:

• If a $1,000 invoice is created with a created date on or before the date of the report, it will increase the amount in the Unpaid Bills column by $1,000.
• If a $100 payment is made on a bill for that matter that is dated on or before the date of the report, it will decrease the amount in the Unpaid Bills column by $100.
• If a $300 write-off dated on or before the date of the report is applied to an invoice for the matter, it will decrease the amount in the Unpaid Bills column by $300.
• If a $50 Credit Note is applied to the invoice on the matter and the applied date is on or before the date of the report, it will decrease the amount in the Unpaid Bills column by $50.
• If an invoice is created and dated after the date of the report, it will not affect the amount in the Unpaid Bills column.
• If a payment is applied to an invoice and the date of the payment is after the date of the report, even if the invoice date is before, it will not affect the amount in the Unpaid Bills column.
• If a credit note is created for the matter but not applied to any invoice, regardless of the date of the credit note, it will not affect the amount in the Unpaid Bills column.

This will show the total due of any credit notes for the matter that are open on or before the date of the report. A credit note must be dated on or before the report date to affect the value in this column and must have an amount unallocated or owing as at the date of the report.

For example:

• If a credit note for $600 is created and dated on or before the report date, it will increase the amount in the Unallocated Credits by $600.
• If a $150 of a credit note is allocated to an invoice and the date of that allocation is on or before the date of the report, the Unallocated Credits column will be reduced by $150. 
• If a $200 write off is applied to a credit note and the date of the write-off is on or before the date of the report the Unallocated Credits will be decreased by $200.
• If a credit note is created and dated after the date of the report, it will not affect the amount in the Unpaid Bills column.
• If a credit note allocation is applied to an invoice and the date of the allocation is after the date of the report, even if the credit note date is before, it will not affect the amount in the Unpaid Bills column.
• If an invoice is created for the matter, regardless of the date of the invoice, it will not affect the amount in the Unpaid Bills column.

This will show the total that is owing by the client at the date of the report. 

This column will total the Unpaid Bills column and the Unallocated Credits column. AR stands for Accounts Receivable in this instance.

This is the value of any fees or time records that are recorded against the matter that have not been billed at the date of the report. A time record must be dated on or before the date of the report and it must not have been added to a bill before or on the date of the report to contribute to this column.

For example:

• A time entry worth $30 is recorded on or before the date of the report will increase the amount in the Fees column by $30. 
• A time entry that is worth $50 is added to a bill that is dated before the date of the report it will reduce the Fees column by $50. 
• If a time entry is entered after the date of the report it will not affect the Fees column.
• If a time entry is added to a bill and the bill date is after the date of the report it will not affect the Fees column.

This is the value of any disbursement/expense or time records that are recorded against the matter that have not been billed at the date of the report. A disbursement/expense must be dated on or before the date of the report and it must not have been added to a bill before or on the date of the report to contribute to this column.

For example:

• A disbursement/expense entry worth $10 is recorded on or before the date of the report will increase the amount in the Fees column by $10. 
• A disbursement/expense that is worth $80 is added to a bill that is dated before the date of the report it will reduce the Fees column by $80. 
• If a disbursement/expense is entered after the date of the report it will not affect the Fees column.
• If a disbursement/expense is added to a bill and the bill date is after the date of the report it will not affect the Fees column.

This is the amount that could be recovered from the matter if all billable items were billed and paid on the date of the report and all bills paid and credits applied.

This column will total the AR Balances column, the Fees column and the Disbursements column. 

This will total the amount of funds in trust for any trust current accounts for the matter at the date of the report.

If the firm has multiple trust current accounts, then this will total the amounts from all trust current accounts. 

If there are no trust current accounts for the firm the column will be hidden.

This will total the amount of funds in trust for any trust investment accounts for the matter at the date of the report.

If the firm has multiple trust investment accounts, then this will total the amounts from all trust investment accounts.

If there are no trust investment accounts for the firm the column will be hidden.

This will total the amount of funds in retainer for the matter at the date of the report.

If the firm does not use general retainers, then the column will be hidden.

This is the date that the report will display values for. 

The report will show AR, WIP, Trust and retainer balances for each matter at the date that you enter here. 

These balances are made up of transactions that happen up to this date. Any transactions after this date will not affect results shown in this report.

Click on the date to select the date from the calendar displayed or type in the date you wish to use.

Select the currency that you wish to see results for.

Matters that have amounts in a currency other than the one selected will not show in the report. 

The responsible Lawyer is an internal contact on a matter who is responsible for the billing. You can set this based on participant types on the matter on the Billing Settings screen (Admin > Billing).

By filtering by the Responsible Lawyer, you will only be able to see matters where that contact is the Responsible Lawyer. The list will show only contacts with a login to the system and only those who are a Responsible Lawyer on a matter. 

You can scroll and select or search for a contact based on their name or their initials. Selecting a Responsible Lawyer will display the contacts initials and name in the Responsible Lawyer box, but you can still search for and select other users. 

There is no limit to the number of Responsible Lawyers you can choose.

You can remove a contact from the Responsible Lawyer box by clicking the cross to the right of their name.

If you leave this box blank then all matters, regardless of Responsible Lawyer will be shown.

The Matter Types are the types of matters that you can create and view in your system.  Most Matter Types will be customised to be unique from other matter types. Typically, Actionstep users have Matter Types for the different types of law they practice.

By filtering by the Matter Type, you will only be able to see matters of that type. The list will show the Matter Types in your system. 

You can scroll and select or search for a Matter Type based on its name. Selecting a Matter Type will display the Matter Type in the Matter Types box, but you can still search for and select other matter types. 

There is no limit to the number of Matter Types you can choose.

You can remove a Matter Type from the Matter Type box by clicking the cross to the right of its name.

If you leave this box blank then all matters, regardless of Matter Type will be shown.

The Customer is typically the Client on a matter. Some Actionstep systems can be customised to call the “Customer” by another name but it will always be the contact or one of the contacts who will be billed when the matter is billed. 

By filtering by the Customer, you will only be able to see matters where the nominated contact is the customer /Client. The list will show all contacts in the system. 

You can scroll and select or search for a contact based on its name. Selecting a Contact will display the Contact in the Customer box, but you can still search for and select other contacts. 

There is no limit to the number of contacts you can choose.

You can remove a contact from the Customer box by clicking the cross to the right of their name.

If you leave this box blank then all matters, regardless of Customer will be shown.

Matters are the file or record of work, typically used to manage and record the details of an engagement with a client. 

By filtering by the Matter, you will only be able to see the selected matters. The list will show all matters in the system. 

You can scroll and select or search for a matter based on its name or ID. Selecting a matter will display the Matter in the Matter box, but you can still search for and select other Matters. 

There is no limit to the number of Matters you can choose.

You can remove a Matter from the Matter box by clicking the cross to the right of its name.

If you leave this box blank then all matters will be shown.

This will change the amounts shown in any column that shows AR or WIP balances so that they either include sales tax or exclude sales tax. 

When set to off, all amounts in Unpaid Bills, Unallocated Credits, AR Balance Fees, Disbursements and Total Lockup Amount will be exclusive of any sales tax. 

When set to on, all amounts in Unpaid Bills, Unallocated Credits, AR Balance Fees, Disbursements and Total Lockup Amount will be inclusive of any sales tax

By default this is set to off.

Trust Account balances and General Retainer balances are not applicable to sales tax so amounts in those columns will be unaffected by this option. 

This will change the amounts shown in any column that shows AR columns so that they either include draft invoices or not. As an invoice is being prepared and can sit in a “draft” status. In this status the WIP is no longer against the matter but in the draft invoice but the draft invoice has not been saved yet.

When set to off, all amounts in Unpaid Bills and AR Balance Fees, will exclude draft invoices. 

When set to on, all amounts in Unpaid Bills and AR Balance Fees, will include draft invoices.

By default this is set to on.

On screen (HTML) 

PDF

MS Excel 

Save XLSX file to a matter 

After you have selected to run the report in MS Excel you can choose to save the XLSX file directly to a matter using this button. 

Save PDF file to a matter

After you have selected to run the report in PDF you can choose to save the PDF directly to a matter using this button.