IS THE FIRM AS
PROFITABLE AS IT LOOKS?
QuickBooks Online · Clio Manage
The partners read revenue in Clio and expenses in QuickBooks, and they were replacing a separate KPI reporting service. They wanted the margin calculated in the open, with the formula on the screen.
- Revenue collected
- $2.10M18% vs prior compared with the previous period
- Trust (IOLTA)
- $412.6KQuickBooks bank balance
- Operating
- $186.3KQuickBooks bank balance
- AR outstanding
- $205.9KAs of Sep 30
- YTD billed time
- $2.29MClio activities
Revenue and expenses
Monthly totals from the QuickBooks profit and loss report.
- Revenue
- Expenses
Aging
Receivables and payables by days outstanding.
Revenue collected
QuickBooks income accounts.
| Legal fees | $1,704,355 | 81.2% |
| Flat-fee services | $281,411 | 13.4% |
| Consultation fees | $78,255 | 3.7% |
| Reimbursed costs | $36,132 | 1.7% |
Expense details
Select an account for its monthly trend.
| $732,775 | +2% | |
| $102,360 | +1% | |
| $86,969 | −0% | |
| $72,989 | +5% | |
| $36,554 | +2% | |
| $25,213 | +2% |
This demo runs on sample data, and the firm and people in it are fictional. Change the filters and every figure recalculates.
What we
built.
We connected QuickBooks Online through Intuit’s API and placed its profit and loss beside Clio’s billing and time entries. Margin and collections update together for whichever period the partners choose.
Billable hours sit against each attorney’s target, and anyone reading the dashboard can check how a figure was calculated.
Where the data comes from
- QuickBooks Online
- Revenue, expenses and profit and loss
- Clio Manage
- Invoices, payments and time entries
Related platforms
Bring last quarter’s numbers, and we’ll walk through what a dashboard like this would say about them.
Discuss a financial dashboard