AO
Reconciliation

Payment Reconciliation

Match incoming payments to invoices, receipts, clients, retainers, and matters.

Payments to match
13
Matched today
24
Unmatched deposits
$61,800
Duplicate risk
2
Bank statement feed
10 JulExact
WIRE IN · MERIDIAN HLD
Ref MER-2041$24,800
10 JulExact
CARD · LAGOS BAY
Ref LB-2029$14,200
10 JulNo match
WIRE IN · UNKNOWN REF Z9814
Ref —$61,800
09 JulLikely
WIRE IN · KESTREL PARTIAL
Ref KS-2007$18,700
09 JulExact
WIRE IN · HALCYON
Ref HP-2011$31,600
09 JulManual
WIRE IN · BLAKE INDUSTRIAL DE
Ref —$22,400
Match confidence
Exact match68%
Likely match18%
Manual review10%
No match4%
Suggested system records
Meridian Holdings$24,800
Invoice · M-2041 · INV-4820
Vertex Biotech$31,800
Invoice · M-2024 · INV-4823
Kestrel Insurance$18,700
Retainer top-up · M-2007 · —
Halcyon Partners$31,600
Receipt pending · M-2011 · RCPT-3008
Duplicate payment alert
Two identical $12,400 deposits from Nordic Shipping received on 07 Jul and 09 Jul. Confirm not duplicate before matching.
Payment reconciliation

Ashworth & Vance LLP · live demonstration data

Reconciled
94.2%
▲ 12.0%
Unmatched value
$46.2K
▲ 10.1%
Bank items today
68
▼ 8.2%
Auto-matched
58
▲ 13.3%85%
Exceptions
6
▲ 3.4%
Last import
07 Jul 07:05
▼ 14.5%
Trend intelligence
Unmatched value trend
92K79K66K53K40KUnmatched · W1 · 82KUnmatched · W2 · 74KUnmatched · W3 · 61KUnmatched · W4 · 58KUnmatched · W5 · 49KUnmatched · W6 · 52KUnmatched · W7 · 44KUnmatched · W8 · 46KTolerance · W1 · 60KTolerance · W2 · 60KTolerance · W3 · 60KTolerance · W4 · 60KTolerance · W5 · 60KTolerance · W6 · 60KTolerance · W7 · 60KTolerance · W8 · 60KW1W2W3W4W5W6W7W8
UnmatchedToleranceUnit: $K
Comparative analysis
Exception reasons
No matter reference
14
Amount mismatch
9
Split payment
7
Duplicate reference
5
FX difference
3
Payer name mismatch
8
Reconciliation completion
94out of 100
Office account · weight 30%99
Client account · weight 40%92
Card acquirer · weight 20%88
Petty cash · weight 10%100

Daily control target is 97% by 18:00; two accounts remain below tolerance.

Matching workspace

Match a payment to move it between columns

Three-column reconciliation workspace
7 to resolve
Received · unmatched4
BRF-7712102 Jul 11:21
Nordic Shipping AS
$46.0K
Suggested: INV-4811 · M-2035
56%
BRF-7712203 Jul 12:22
Vertex Biotech Ltd
$35.0K
Suggested: INV-4812 · M-2024
99%
BRF-7712506 Jul 15:25
Halcyon Partners
$62.0K
Suggested: INV-4815 · M-2011
79%
BRF-7712708 Jul 17:21
Ashborn Family Trust
$56.0K
Suggested: INV-4817 · M-2018
92%
Partially matched3
BRF-7712001 Jul 10:20
Meridian Holdings PLC
$51.0K
Suggested: INV-4810 · M-2041
96%
BRF-7712304 Jul 13:23
Lagos Bay Estates
$58.0K
Suggested: INV-4813 · M-2029
60%
BRF-7712607 Jul 16:20
Orion Media Group
$18.0K
Suggested: INV-4816 · M-2016
82%
Fully matched2
BRF-7712405 Jul 14:24
Kestrel Insurance
$13.0K
Suggested: INV-4814 · M-2007
94%
Posted to ledger
BRF-7712809 Jul 18:22
Blake Industrial GmbH
$39.0K
Suggested: INV-4818 · M-1998
64%
Posted to ledger
Operational register
Reconciliation audit log
TimeUserBank itemLedger recordAmountConfidenceActionResult
01 Jul 10:00N. SalimBRF-77120INV-4810$51.0K89%Auto-matchPosted
02 Jul 11:01D. FeldBRF-77121INV-4811$46.0K82%Manual matchPosted
03 Jul 12:02SystemBRF-77122INV-4812$34.0K97%Split allocationPosted
04 Jul 13:03N. SalimBRF-77123INV-4813$58.0K68%UnmatchedException
05 Jul 14:04D. FeldBRF-77124INV-4814$12.0K99%Auto-matchPosted
06 Jul 15:05SystemBRF-77125INV-4815$62.0K71%Manual matchPosted
07 Jul 16:00N. SalimBRF-77126INV-4816$17.0K95%Split allocationPosted
08 Jul 17:01D. FeldBRF-77127INV-4817$56.0K84%UnmatchedException
09 Jul 18:02SystemBRF-77128INV-4818$39.0K86%Auto-matchPosted
9 of 9 records
Exceptions and risk
Exception queue and recommended actions
3 open
Bank item unmatched 9 days
REF 55129
$18.4K
Statement import gap
HSBC · 04 Jul missing
—
Split payment unresolved
Kestrel · 2 invoices
$32.1K
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·$73.0K·AUD-7700
  2. Invoice edited02 Jul · 11:11
    A. Okafor·Nordic Shipping AS · M-2035·$65.0K·AUD-7701
  3. Credit note approved03 Jul · 12:12
    D. Feld·Vertex Biotech Ltd · M-2024·$48.0K·AUD-7702
  4. Retainer adjusted04 Jul · 13:13
    J. Hollis KC·Lagos Bay Estates · M-2029·$83.0K·AUD-7703
  5. Trust transfer completed05 Jul · 14:14
    N. Salim·Kestrel Insurance · M-2007·$16.0K·AUD-7704
  6. Expense approved06 Jul · 15:15
    A. Okafor·Halcyon Partners · M-2011·$88.0K·AUD-7705
  7. Tax report exported07 Jul · 16:16
    D. Feld·Orion Media Group · M-2016·$24.0K·AUD-7706