Reviewing Reports in Power BI
We rely on the feedback of our attorneys and paralegals to ensure the Collections and Trust team has the information they need to reach out to your clients. As such, we provide a copy of the Accounts Receivable Report and Client Trust balances as frequently as possible - three times a month at a minimum. Attorneys reviewing these reports and ensuring information is accurate isn't just helpful, it's compulsory. To make this admin task more accessible, please review the below tips and call outs for looking over your Power BI Dashboard.
Accounts Receivable
The accounts receivable team relies on the attorneys and paralegals to review their accounts receivable report in Power BI. The information we receive from the attorneys will help our Collections team strategize and organize their monthly outreach to clients. Your client's balances are sorted into columns to make it easy to see how long they have been outstanding. The columns, or buckets, we use at Gravis Law are as follows:
- Current: This is a balance that is currently owed, but the due date listed on the invoice has not yet passed
- 1-30 days: The client has an unpaid balance from an invoice that was due before yesterday, but not longer than a month ago
- 31-60 days: The client has an unpaid balance form an invoice with a due date from longer than one month ago, but not yet two months.
- 61-90 days: The client has an unpaid balance on an invoice older than two months, but not yet older than three months
- Older: The client has an unpaid balance on an invoice older than three months
- Total: The total amount the client has due to Gravis Law
It is expected that you will review your Accounts Receivable report when it is updated in Power BI. Some top things to look for and some commonly asked questions:
- How long has this client been outstanding?
- A client with a long outstanding past due balance may be making monthly payments, but it is required to ensure the AR team is aware of any arrangements. View the collections and AR write off policy for more information.
- Is this my client, or do they need to appear on some one else's AR?
- Each client can only appear once on the AR report, which means if their name appears on your list, they will not appear under some one else's list. If you have a client who is no longer yours, create a ticket using Finance > AR/Collections > Other. The change will be reflected on the next AR Report update.
- My client is VERY past due. Should I withdraw or continue to add time to this matter?
- Review the collections and AR write off policy for standards and exceptions.
- Is this a client who will pay? Is this a matter that payment will be delivered by a third party, or need to be approved by the court/estate?
- If you know the client will be unable to make their payments, notify the collections team as soon as possible and follow the Collections Policy to look over your withdrawal options and recommendations. If you've approved an invoice that cannot be paid by the client until a specific date or court approval (probates, estates GALs, or contingency matters), or is processed by a third party for payment (county payments, Metlife/ARAG), notify accounting using the finance ticket options > AR/Collections > Stop collection efforts. This may involve writing off the time completely, or returning the time to clever case to be invoiced at a later date.
- Does Collections have the tools they need to collect, including valid contact information?
- If you know something we don't, for example that the client is expecting a lotto payout next week, please let collections know so we can coordinate outreach.
- What are these extra notes?
- In the "AR Notes" column on the AR Report, you may see some frequent tags that notify our collections team and you what action we can take. Common groups include "No Interest" (these clients will not receive interest charges), Discount tags, Transferred AR: (Origin), and even Contact Info Invalid. If there is no available contact information, or if one of the status tags no longer apply, create a ticket. Changes will be reflected on the next AR Report Update.
- Does this client's name appear on my trust ledger, too?
- If a client has a balance on the AR report and also appears on your trust ledger, something may be wrong. Create a ticket using Finance > AR/Collections > Other to notify us.
- Oops! This client should not have any invoices outstanding to Gravis Law.
- Create a ticket: Finance > AR/Collections > Write Off Balance. Please be sure to include the reason why this balance should be removed - is it returning to work in process to be invoiced at a later time? Was the invoice generated as an hourly matter when the client has paid a flat fee? Do you believe the client will not pay and don't want us to continue collections efforts? Each of those options has a different impact on our reports and we need to clearly understand the reason to make sure any removed balances are within policy. Include as much information as possible.
When the AR report is updated, it may be easiest to create one ticket and include a list of your clients and what should happen with their current balances. For example:
This should be submitted within three business days of the Accounts Receivable Report being updated in Power BI.
Trust
It is expected that you will review your Trust balances when they are updated in Power BI. Some top things to look for:
- Is this client's matter closed?
- If so, you should create a ticket using Finance > Refunds and Credits > Trust and Client Funds
- Is this my client?
- If you don't recognize the name of the client, it is possible they are supposed to be on another attorney's trust list. If this is the case create a ticket using Finance > Other > Other and let us know
- Is there a large cost or fee amount upcoming that you need to request additional funds in trust for?
- If you need an additional replenishment on top of any recurring replenishments, you can create a ticket using Finance > A/R Collections > Trust Replenishment to let us know how much to collect
- Is the amount listed in trust a flat fee?
- When we received funds and don't have either an invoice to apply it to or an engagement letter informing us of a flat fee, we have to transfer funds to trust. Is is possible that flat fees are in your trust balances, if so create a ticket using Finance > Client Statements and Invoices > Create New Invoice to let us know
- My client's funds are suppose to HELD for a specific purpose, how can I verify this is the case?
- We are trying to list these funds that supposed to be HELD for a specific purpose separately. If yours are not, please let us know by creating a ticket using Finance > Balance Inquiry > Other
- Dose this client appear on my AR Report, too?
- If a client has a balance in trust and also appears on your AR Report something may be wrong. Create a ticket using Finance > AR/Collections > Other to notify us.
Related Articles
Invoicing: Reviewing Invoices
Overview Monthly invoicing review is an opportunity for all attorneys to review the month's time cards for each of their client's matters. On the first business day of each month, the accounting team will generate invoices for all unbilled time ...
Collections Policy: Past Due Balances, Discounts, and Write-Offs
As a firm, we must accurately forecast and manage our write-offs. This policy is designed to create a fluid communication tool between the finance team, accounts receivable department, the practicing attorneys, and the Board/CEO (who determine the ...
Revenue Sharing Program Frequently Asked Questions (FAQ)
Overview The Revenue Sharing Program (“RSP”) is a tiered incentive-based compensation arrangement for eligible attorneys and senior attorneys at Gravis Law, PLLC. Under the RSP, an attorney will share revenue collections after reaching the Revenue ...
Insurance: Metlife
Below are your MetLife resources. These resources include the MetLife Workflow, Cheat Sheet and the Law Firm Manual and training videos. If you have any questions, please reach out to Bergen Finch or submit a ticket. All invoice requests must go ...
Trust: Balance Inquiry
Balance Inquiry During the month, a clients trust balance may fluctuate as costs are paid and payments are made by the client into trust. The Trust Ledger is updated in Power BI at least three times a month. Once before invoicing, once after ...