AO
Bank Control

Bank Reconciliation

Match bank statement entries to invoices, receipts, retainers, refunds, expenses, and client fund movements.

Statement entries
184
Reconciled
161
Unmatched
17
Exceptions
6
Reconciliation progress
161 of 184 matched (87.5%)Firm operating · Trust · Escrow
Bank statement
DateDescriptionDebitCreditRefStatus
10 JulWIRE IN · MERIDIAN HLD$24,800MER-2041Matched
10 JulCARD SETTLE · STRIPE$14,200STR-9812Matched
10 JulWIRE IN · UNKNOWN Z9814$61,800Unmatched
09 JulWIRE OUT · WHITMORE QC$12,000WHT-018Matched
09 JulWIRE IN · HALCYON$31,600HP-2011Matched
09 JulCHARGE · FX FEE$42BNK-018Exception
Match state
Matched161
Partial8
Split required5
Duplicate risk4
Manual review6
System records
INV-4820 · Meridian$24,800
Card batch · Lagos Bay$14,200
External counsel · Whitmore$12,000
Retainer top-up · Halcyon$31,600
Account balances
Firm operating$412K
Trust account$1.28M
Escrow$940K
Bank reconciliation

Ashworth & Vance LLP · live demonstration data

Accounts
6
9.0%
Reconciled
4
9.1%2 open
Statement lines
214
13.2%
Matched
198
4.3%
Variance
$1.2K
14.4%
Sign-off
Pending
3.5%
Trend intelligence
Statement lines by account and status
705335180Barclays office · Matched: 48Barclays office · Pending: 4Barclays office · Exception: 1Barclays officeBarclays client · Matched: 52Barclays client · Pending: 6Barclays client · Exception: 3Barclays clientHSBC office · Matched: 26HSBC office · Pending: 2HSBC office · Exception: 0HSBC officeHSBC client · Matched: 31HSBC client · Pending: 3HSBC client · Exception: 2HSBC clientLloyds · Matched: 22Lloyds · Pending: 1Lloyds · Exception: 0LloydsCard acquirer · Matched: 19Card acquirer · Pending: 2Card acquirer · Exception: 1Card acquirer
MatchedPendingExceptionStacked · unit
Operational register
Statement line register
DateAccountDescriptionDebitCreditBalanceLedger refStatus
01 JulBarclays officeMeridian Holdings PLC transfer$56.0K$1.29MGL-4400Unmatched
02 JulBarclays clientNordic Shipping AS transfer$26.0K$664.0KGL-4401Matched
03 JulHSBC officeVertex Biotech Ltd transfer$26.0K$1.40MGL-4402Matched
04 JulBarclays officeLagos Bay Estates transfer$12.0K$534.0KGL-4403Matched
05 JulBarclays clientKestrel Insurance transfer$15.0K$1.34MGL-4404Matched
06 JulHSBC officeHalcyon Partners transfer$7.0K$911.0KGL-4405Unmatched
07 JulBarclays officeOrion Media Group transfer$47.0K$1.14MGL-4406Matched
01 JulBarclays clientAshborn Family Trust transfer$21.0K$1.21MGL-4407Matched
02 JulHSBC officeBlake Industrial GmbH transfer$72.0K$819.0KGL-4408Matched
9 of 9 records
Detail panel
Balance comparison
Bank statement
$4,182,410
07 Jul close
General ledger
$4,181,210
posted entries
Variance
$1,200
2 items in transit
Outstanding deposits
$14,200
clearing
Unpresented cheques
$6,800
3 cheques
Adjusted balance
$4,182,410
agrees
Control checklist
Reconciliation control checklist
29% complete
Exceptions and risk
Exception queue and recommended actions
3 open
Unpresented cheque > 90 days
CHQ-2214
$6.8K
Unidentified credit
HSBC client account
$12.4K
FX rounding variance
Nordic Shipping EUR receipt
$1.2K
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·$58.0K·AUD-7700
  2. Invoice edited02 Jul · 11:11
    A. Okafor·Nordic Shipping AS · M-2035·$56.0K·AUD-7701
  3. Credit note approved03 Jul · 12:12
    D. Feld·Vertex Biotech Ltd · M-2024·$79.0K·AUD-7702
  4. Retainer adjusted04 Jul · 13:13
    J. Hollis KC·Lagos Bay Estates · M-2029·$25.0K·AUD-7703
  5. Trust transfer completed05 Jul · 14:14
    N. Salim·Kestrel Insurance · M-2007·$88.0K·AUD-7704
  6. Expense approved06 Jul · 15:15
    A. Okafor·Halcyon Partners · M-2011·$14.0K·AUD-7705
  7. Tax report exported07 Jul · 16:16
    D. Feld·Orion Media Group · M-2016·$83.0K·AUD-7706