Bank reconciliation
HSBC Operating Account
June 2024 · GBP
Source A
Bank statement
HSBC · June 2024 · 142 lines
Loaded
Source B
General ledger extract
SAP · Cash account 10001 · 138 lines
Loaded
Run reconciliation
Total lines
142
Bank statement
Matched
Run to calculate
Exceptions
Require investigation
Timing diffs
Expected to clear
Match rate
Confidence score
Intercompany reconciliation
Entity A ↔ Entity B
June 2024 · GBP
Entity A
UK HoldCo ledger
Interco payable / receivable · 52 lines
Loaded
Entity B
EU OpCo ledger
Interco payable / receivable · 49 lines
Loaded
Run reconciliation
Entity A balance
£2.84m
Interco receivable
Entity B balance
£2.84m
Interco payable
In-agreement
Run to calculate
Disagreements
Require elimination
Net difference
Must be zero at group level
Accounts payable reconciliation
Supplier statements vs ledger
June 2024 · 6 suppliers
Source A
Supplier statements
6 suppliers · 87 invoices total
Loaded
Source B
AP ledger extract
SAP · Vendor accounts · 83 invoices
Loaded
Run reconciliation
Total supplier value
£487k
Per statements
Matched invoices
Run to calculate
Missing in ledger
Invoices not posted
Duplicates flagged
Potential double-pays
Value at risk
Unreconciled amount