> ## Documentation Index
> Fetch the complete documentation index at: https://trainings.air.athelas.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Bank Deposit Reconciliation Report
#### 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](/insights_biller/reports/site_transaction_report).
For the bank-linking workflow that feeds this report, see [Bank Deposit Verification](/insights_front_desk/utilities/bank_deposit_verification).
#### Data Dictionary
| Column Name | Description |
| -------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| bank\_deposit\_id | The ID of the bank deposit this row belongs to. Every row is tied to exactly one deposit. |
| bank\_deposit\_link | A direct link to this deposit in Insights, so you can open it and see the underlying detail. |
| bank\_deposit\_date | The date the deposit landed in the bank. Used to place the row in the right reporting period. |
| check\_number | The check number printed on the ERA check inside the deposit. Blank means the row is a deposit-level summary line. |
| athelas\_claim\_number | The claim submission ID this row's matched cash pays. Blank on check-level and deposit-level summary lines. |
| date\_posted | The earliest date a payment item was posted for this claim on this check. Only populated on matched-posted rows. |
| notes | Free-text notes captured on the bank deposit when it was reviewed. |
| deposit\_description | The original transaction description from the upstream source (virtual card, Plaid, Anatomy, or BAI). |
| bank\_account\_last\_4 | The last 4 digits of the bank account associated with the deposit. Blank for virtual card transactions. |
| payment\_type | The ERA payment method codes seen on the check (e.g. ACH, CHK). |
| matched\_posted\_usd | Money on this check/claim that has been matched to a bank deposit *and* posted as an insurance payment item. |
| matched\_unposted\_usd | Money matched to a bank deposit but not yet posted as insurance payment items. |
| unmatched\_usd | Insurance cash that arrived in the deposit but cannot be tied to any specific ERA check. Reported once per deposit on the deposit-level summary row. |
| others\_usd | Non-insurance cash captured on the deposit or check — patient payments and refunds (deposit-level), or money for claims submitted outside Athelas (check-level). |
| total\_cash\_usd | The full amount of cash this row accounts for. Summing this column across all rows of a deposit equals the deposit's total bank amount. |
| unmatched\_posted | Deposit not matched to any check but force-posted. Only populated when the report is downloaded by **Date Posted**; a subset of `unmatched_usd`. |
| provider\_level\_adjustment\_usd | Provider-level adjustments deposited in the bank — see the [Provider Adjustments Report](/insights_biller/reports/provider_adjustments_report) for the full breakdown. When downloaded by **Bank Deposit Date**, shows only matched provider-level adjustments; when downloaded by **Date Posted**, shows both matched and unmatched provider-level adjustments. |
`total_cash_usd = matched_posted_usd + matched_unposted_usd + unmatched_usd + others_usd + provider_level_adjustment_usd`. See [Month-End Close](/insights_biller/reports/month_end_close) for how this ties out to your bank statement.
#### Filters Supported
* Date Range Type — Bank Deposit Date or Date Posted
* As-Of Date — snapshot the match state as of a specific date (useful for reproducing a prior close)