> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.joincandidhealth.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.joincandidhealth.com/_mcp/server.

# Standard Financial Rollups

> Encounter- and service-line-level financial totals in Candid Data Share

Financial totals Candid has already computed per encounter and service line: billed and allowed amounts, patient responsibility, copay, deductible, coinsurance and projected allowed amounts. Use them for reporting without summing transactions yourself.

## Tables

| Table                                                                                                                         | One row per                           | Primary key       | [Shape](/data-share/data-model#table-shapes) |
| ----------------------------------------------------------------------------------------------------------------------------- | ------------------------------------- | ----------------- | -------------------------------------------- |
| [`export_financial_summary`](/data-share/standard-financial-rollups/export-financial-summary)                                 | Encounter                             | `encounter_id`    | Current state                                |
| [`export_service_line_financial_summary`](/data-share/standard-financial-rollups/export-service-line-financial-summary)       | Service line (none for deleted lines) | `service_line_id` | Current state                                |
| [`export_service_line_projected_financials`](/data-share/standard-financial-rollups/export-service-line-projected-financials) | Service line (none for deleted lines) | `service_line_id` | Current state                                |

## Notes

* **Check `is_persisted_financial_summary_record_stale`** before comparing a summary against the latest transactions.
* **Rows change on claim status changes**, even when no amount changed, so expect them in incremental syncs.

## Common queries

### Billed and allowed per service line

```sql
SELECT
  sl.service_line_id,
  sl.procedure_code,
  slfs.billed_amount_cents,
  slfs.allowed_amount_cents,
  slfs.patient_responsibility_cents
FROM export_service_line sl
JOIN export_service_line_financial_summary slfs
  ON sl.service_line_id = slfs.service_line_id
```