AO
Finance · July

Finance Dashboard

Where the money is, where it isn't, and where it needs to go.

Total revenue MTD
$482,500
Retainers received
$288,000
Outstanding invoices
$177,700
Paid invoices
$62,700
Monthly expenses
$142,300
Revenue trend
Payment activity
  • INV-4821
    Meridian Holdings PLC
    $48,200
    Paid
  • INV-4822
    Nordic Shipping AS
    $26,400
    Sent
  • INV-4823
    Vertex Biotech Ltd
    $31,800
    Overdue
  • INV-4824
    Lagos Bay Estates
    $14,500
    Paid
  • INV-4825
    Kestrel Insurance
    $62,100
    Part-paid
  • INV-4826
    Orion Media Group
    $22,750
    Draft
Finance command centre

Ashworth & Vance LLP · live demonstration data

Revenue vs target
$482.5K
▲ 11.0%104% of July target
Realisation rate
91.4%
▲ 7.1%+2.1 pts
Collection days
38d
▼ 14.2%-4d vs Q2
WIP at risk
$318K
▲ 2.3%9 matters
Cash on hand
$1.92M
▲ 14.4%Above floor
Finance health
82/100
▼ 6.5%Stable
Performance versus target
Revenue performance versus target
12 monthsQuarterYTDBy officeBy practice
732K549K366K183K0KAug · actual $560.0K · target $460.0K · var 22%+22%AugSep · actual $449.0K · target $466.0K · var -4%-4%SepOct · actual $611.0K · target $472.0K · var 29%+29%OctNov · actual $333.0K · target $478.0K · var -30%-30%NovDec · actual $616.0K · target $484.0K · var 27%+27%DecJan · actual $425.0K · target $490.0K · var -13%-13%JanFeb · actual $574.0K · target $496.0K · var 16%+16%FebMar · actual $527.0K · target $502.0K · var 5%+5%MarApr · actual $492.0K · target $508.0K · var -3%-3%AprMay · actual $595.0K · target $514.0K · var 16%+16%MayJun · actual $382.0K · target $520.0K · var -27%-27%JunJul · actual $620.0K · target $526.0K · var 18%+18%Jul
Actual revenueTargetPrior yearValues in $K · hover a bar for exact figures
Composition analysis
Revenue composition by source
Retainers: $188.0K (39%)Hourly billing: $142.0K (29%)Fixed fees: $61.0K (13%)Success fees: $44.0K (9%)Advisory subscriptions: $28.0K (6%)Disbursement recovery: $19.5K (4%)Recognised$482.5K
SourceAmountShareMoM
Retainers$188.0K39%+1.0%
Hourly billing$142.0K29%+2.1%
Fixed fees$61.0K13%-3.2%
Success fees$44.0K9%+4.3%
Advisory subscriptions$28.0K6%+5.4%
Disbursement recovery$19.5K4%-6.5%
Highest contributor: Retainers · $188.0K
Lifecycle conversion
Billing lifecycle funnel
Unbilled work214 records$942.0Kavg 21d in stage
66% converts to Draft invoices
Draft invoices96 records$618.0Kavg 6d in stage
75% converts to Partner review
Partner review54 records$466.0Kavg 4d in stage
83% converts to Sent invoices
Sent invoices41 records$388.0Kavg 17d in stage
78% converts to Collected payments
Collected payments33 records$301.0Kavg 9d in stage
Active stageDelayedBottleneckCompleted
Aging analysis
Collections and invoice aging overview
43%
24%
15%
9%
8%
Current
$612.0K
43% of book
1–30 days
$342.0K
24% of book
31–60 days
$218.0K
15% of book
61–90 days
$134.0K
9% of book
90+ days
$114.0K
8% of book

Ten largest outstanding invoices listed below; collection owners are assigned in the action centre.

Movement bridge
Cash movement bridge — July
$2.83M$2.12M$1.41M$707.3K$0Opening cash: +$1.62M → $1.62M+$1.62MOpeningcashClient payments: +$486.0K → $2.11M+$486.0KClientpaymentsRetainer deposits: +$288.0K → $2.39M+$288.0KRetainerdepositsEscrow receipts: +$132.0K → $2.53M+$132.0KEscrowreceiptsExpense payments: $-142300 → $2.38M$-142300ExpensepaymentsSupplier payments: $-186000 → $2.20M$-186000SupplierpaymentsRefunds: $-28400 → $2.17M$-28400RefundsTax remittances: $-252000 → $1.92M$-252000TaxremittancesClosing cash: +$0 → $1.92M+$0Closingcash
Opening / closingInflowOutflow
Comparative analysis
Finance health score
82out of 100
Collections performance · weight 25%78
Billing speed · weight 20%74
Retainer health · weight 15%81
Reconciliation accuracy · weight 15%94
Expense control · weight 15%88
Compliance readiness · weight 10%86

Weighted across six control domains; reconciliation accuracy is the leading contributor.

Portfolio positioning
Matter profitability snapshot
604530150High revenue / high marginHigh revenue / low marginLow revenue / high marginReview requiredM-2041 · Revenue $799.0K · Profit margin % 26% · 389hM-2041M-2035 · Revenue $467.0K · Profit margin % 46% · 118hM-2035M-2024 · Revenue $953.0K · Profit margin % 40% · 420hM-2024M-2029 · Revenue $119.0K · Profit margin % 35% · 113hM-2029M-2007 · Revenue $969.0K · Profit margin % 49% · 391hM-2007M-2011 · Revenue $396.0K · Profit margin % 20% · 253hM-2011M-2016 · Revenue $843.0K · Profit margin % 52% · 306hM-2016M-2018 · Revenue $700.0K · Profit margin % 20% · 359hM-2018M-1998 · Revenue $595.0K · Profit margin % 49% · 179hM-1998RevenueProfit margin %
CorporateShippingIPReal EstateInsuranceMediaPrivate ClientCommercialBubble size = billable hours
Operational register
Ten largest outstanding invoices
InvoiceClientMatterAmountDueDays overOwnerLast contactRisk
INV-4820Meridian Holdings PLCM-2041$51.0K5 Jul89dA. Okafor14d agoHigh
INV-4821Nordic Shipping ASM-2035$32.0K7 Jul4dN. Salim6d agoMedium
INV-4822Vertex Biotech LtdM-2024$60.0K9 Jul91dE. Cole12d agoLow
INV-4823Lagos Bay EstatesM-2029$11.0K11 Jul32dA. Okafor10d agoHigh
INV-4824Kestrel InsuranceM-2007$61.0K13 Jul78dN. Salim8d agoMedium
INV-4825Halcyon PartnersM-2011$28.0K15 Jul63dE. Cole13d agoLow
INV-4826Orion Media GroupM-2016$54.0K17 Jul53dA. Okafor4d agoHigh
INV-4827Ashborn Family TrustM-2018$46.0K19 Jul84dN. Salim14d agoMedium
INV-4828Blake Industrial GmbHM-1998$39.0K21 Jul19dE. Cole4d agoLow
9 of 9 records
Detail panel
Retainer health panel
Healthy retainers
24
Above 50% balance
Below 50%
9
Monitor weekly
Below 25%
5
Top-up drafted
Awaiting top-up
4
$186K requested
Depletion in 14 days
3
Meridian, Kestrel, Orion
Depletion in 30 days
6
$402K exposure
Action centre
Financial action centre
17 open
Requires partner approval(3 pending)
Write-off request · Blake Industrial
Critical
$74.0K
A. Okafor · 12d old · due 10 Jul
Discount 12% · Orion Media
High
$42.0K
N. Salim · 1d old · due 11 Jul
Fee split revision · M-2041
Normal
$89.0K
E. Cole · 12d old · due 12 Jul
Requires finance review(3 pending)
Unallocated payment $38.4K
Critical
$74.0K
A. Okafor · 12d old · due 10 Jul
Draft invoice batch 07-B
High
$42.0K
N. Salim · 1d old · due 11 Jul
Rate card mismatch · M-2024
Normal
$89.0K
E. Cole · 12d old · due 12 Jul
Requires client follow-up(3 pending)
Retainer top-up · Kestrel
Critical
$74.0K
A. Okafor · 12d old · due 10 Jul
Disputed line · Nordic Shipping
High
$42.0K
N. Salim · 1d old · due 11 Jul
Payment promise expiring
Normal
$89.0K
E. Cole · 12d old · due 12 Jul
Reconciliation exceptions(3 pending)
Bank item unmatched 9d
Critical
$74.0K
A. Okafor · 12d old · due 10 Jul
Duplicate reference RCPT-3009
High
$42.0K
N. Salim · 1d old · due 11 Jul
Negative client balance
Normal
$89.0K
E. Cole · 12d old · due 12 Jul
Compliance deadlines(3 pending)
VAT return Q2
Critical
$74.0K
A. Okafor · 12d old · due 10 Jul
Trust reconciliation sign-off
High
$42.0K
N. Salim · 1d old · due 11 Jul
WHT certificate upload
Normal
$89.0K
E. Cole · 12d old · due 12 Jul
High-value releases(2 pending)
Escrow release $420K
Critical
$74.0K
A. Okafor · 12d old · due 10 Jul
Settlement payout $186K
High
$42.0K
N. Salim · 1d old · due 11 Jul
Exceptions and risk
Exception queue and recommended actions
4 open
Unreconciled bank item
9 days old · Barclays client account
$38,400
Retainer below floor
Kestrel Insurance · M-2007
$12,100 remaining
Missing tax narrative
4 invoices lack VAT reference
$61,800
Write-off above threshold
Blake Industrial · needs MP approval
$18,400
Audit and history

Every financial change is captured with user, timestamp, value movement and audit reference

Recent activity
  1. Payment posted01 Jul · 10:10
    N. Salim·Meridian Holdings PLC · M-2041·$71.0K·AUD-7700
  2. Invoice edited02 Jul · 11:11
    A. Okafor·Nordic Shipping AS · M-2035·$40.0K·AUD-7701
  3. Credit note approved03 Jul · 12:12
    D. Feld·Vertex Biotech Ltd · M-2024·$85.0K·AUD-7702
  4. Retainer adjusted04 Jul · 13:13
    J. Hollis KC·Lagos Bay Estates · M-2029·$7.0K·AUD-7703
  5. Trust transfer completed05 Jul · 14:14
    N. Salim·Kestrel Insurance · M-2007·$87.0K·AUD-7704
  6. Expense approved06 Jul · 15:15
    A. Okafor·Halcyon Partners · M-2011·$33.0K·AUD-7705
  7. Tax report exported07 Jul · 16:16
    D. Feld·Orion Media Group · M-2016·$75.0K·AUD-7706