Summary
This report breaks down every bank deposit for the reporting period, down to the individual claim, and shows exactly where the money in each deposit came from and what state it is in. It answers the question: “For each dollar that hit our bank account, do we know which check it came from, which claim it pays, and have we posted it in our system yet?” Each deposit is represented by three kinds of rows:- One line per claim on each check — how much of that check was matched & posted vs. matched & unposted for that specific claim.
- A check-level summary line (claim number blank) — leftover cash on the check that could not be tied to a specific claim line on the 835, plus any non-Athelas cash on the check.
- A deposit-level summary line (check ID and claim number both blank) — cash on the deposit that is not tied to any specific check.
The Four Buckets
Every dollar of every deposit lands in exactly one of four buckets, so the buckets always add up to the bank deposit total:- Matched & Posted — insurance cash on a check that has been matched to the deposit and posted in the system, broken out per claim.
- Matched & Unposted — insurance cash matched to the deposit but not yet posted. When the 835 identifies which claims the money is for, this is split per claim; any remainder shows on the check-level summary line.
- Unmatched — cash that arrived in the deposit but is not tied to any specific check (shown once per deposit on the deposit-level summary line).
- Others — non-insurance cash (patient payments, refunds, miscellaneous receipts, or money for claims submitted outside Athelas).
Key Use Cases
- Trace every dollar of a deposit back to the check and claim it pays.
- Surface insurance cash that has been received but not yet posted.
- Separate insurance cash from patient payments and other non-insurance receipts.
- Support month-end bank reconciliation alongside the Site Transaction Report.
For the bank-linking workflow that feeds this report, see Bank Deposit Verification.
Data Dictionary
Filters Supported
- Date Range — filter by Bank Deposit Date