Bank Reconciliation

Reconciliation brief · action-oriented

Bank received $257k this week vs $265k posted in AMD. $47k across 4 items needs attention, and two payer recoupments ($55k) closed claims in AMD without new cash hitting the bank. Recommended next action: reverse-post the Aetna $42k recoupment against CLM-71442 to keep bank-to-AMD in balance.

Bank deposits

week to date

$256.8k

Actual cash into bank

Posted in AMD

matched postings

$264.9k

Payments applied to claims

Unmatched

4 items

$46.7k

Target: ≤ $10k21% to goal

Recoupments

2 offsets

$54.8k

Closed in AMD, no new bank cash

Why AMD balances alone aren't enough

Claims can appear closed in AMD while cash never reaches the bank — payer offsets, prior-period overpayment recoupments, and timing gaps all distort the picture. Bank Reconciliation separates Posted Cash, Actual Bank Cash, Recoupments, and Timing Differences so leadership sees the true spendable position.

Bank deposits vs AMD posted

Actual cash into bank compared with payments posted in AMD

Bank deposits

$2519k

AMD posted

$2338k

Gap (Bank − Posted)

+$181k

92.8% posted vs deposited

May 10 → Jul 8

Reconciliation queue

9 of 9 items

Date	Bank ref	Payer	Bank $	AMD posted $	Variance	Reason	Action
Jun 24	DEP-88214	Aetna	$84.2k	$84.2k	—	Match EFT 835 auto-posted	No action
Jun 24	DEP-88215	BCBS	$28.4k	—	$-28400	Timing 835 expected within 48h
Jun 23	DEP-88198	UHC	$18.1k	$14.0k	$-4100	Variance $4,100 variance — biller review
Jun 23	DEP-88196	Medicare	$62.5k	$62.5k	—	Match EFT · matched by check #	No action
Jun 22	DEP-88180	Cigna	$14.2k	—	$-14200	Unposted No matching 835 — 3d aging
Jun 21	OFFSET-2201	Aetna	$0	$42.0k	+$42.0k	Recoupment Prior overpayment recovery · CLM-71442
Jun 21	DEP-88155	Medicare	$8.1k	$8.1k	—	Review Reference truncated · needs biller confirm
Jun 20	OFFSET-2198	BCBS	$0	$12.8k	+$12.8k	Recoupment Coordination-of-benefits reversal
Jun 19	DEP-88121	Aetna	$41.2k	$41.2k	—	Match EFT · auto-posted	No action