Appearance
Financial Reports
Financial reports translate invoice payments, ledger movements, expenses, and adjustments into management views of cash position and revenue. Use them for daily reconciliation, month-end close, and referral settlements.
Available reports
| Report | Route | Primary question |
|---|---|---|
| Cash Flow | /reports/cash-flow | What cash moved in/out each day? |
| Cash Flow Summary | /reports/cash-flow-summary | Aggregated inflows vs outflows |
| Financial Summary | /reports/financial-summary | Revenue, discounts, net position |
mermaid
flowchart TB
INV[Patient invoices] --> CF[Cash Flow]
EXP[Daily expenses] --> CF
LED[Ledger entries] --> CF
CF --> CFS[Cash Flow Summary]
CFS --> FS[Financial Summary]Cash Flow report
Purpose: Transaction-level cash movements over a selected period.
Typical columns
| Column | Description |
|---|---|
| Date | Posting date |
| Reference | Invoice #, voucher ID |
| Patient / party | Counterparty |
| Description | Payment, refund, expense |
| Inflow | Money received |
| Outflow | Money paid |
| Payment method | Cash, card, bank transfer |
| Center | Collection branch |
| Running balance | Cumulative cash position |
Use cases
| User | Task |
|---|---|
| Reception supervisor | End-of-shift drawer reconciliation |
| Accountant | Match bank deposit slip |
| Auditor | Trace invoice payment to ledger |
Daily habit
Export cash flow for each business day before next-day opening — catches unposted invoices early.
Cash Flow Summary
Purpose: Roll up cash flow detail into category buckets without line-by-line noise.
| Bucket | Examples |
|---|---|
| Patient receipts | Invoice payments |
| Referral payouts | Settlements |
| Operating expenses | Utilities, consumables |
| Adjustments | Balance corrections |
| Transfers | Inter-ledger moves |
Compare periods week-over-week for seasonal labs (e.g., dengue season spikes).
mermaid
pie title Example inflow mix
"Walk-in cash" : 45
"Card" : 35
"Corporate credit" : 20Financial Summary
Purpose: Executive snapshot of laboratory financial performance.
Metrics often included
| Metric | Source |
|---|---|
| Gross revenue | Invoice totals before discounts |
| Discounts | Rate lists, coupons |
| Net revenue | After discounts |
| Collected vs due | Patient due report alignment |
| Expense ratio | Expenses ÷ revenue |
| Referral commission | Accrued vs paid |
Use for monthly board packs alongside operational volume.
Filters
Apply consistent filters across financial reports:
| Filter | Effect |
|---|---|
| Date range | Required — default to current month |
| Collection center | Branch P&L |
| Payment method | Channel analysis |
| User / cashier | Accountability |
| Referral doctor | Commission subset |
See Export & Filters.
Data sources and integrity
| Source module | Feeds |
|---|---|
| Invoices | Revenue and receipts |
| Ledgers | Journal accuracy |
| Daily expense | Operating costs |
| Deleted invoices | Excluded from active totals |
| Balance adjustment | Billing corrections |
Deleted invoices
Hard-deleted invoices disappear from active financial totals but remain in audit log — restated reports may differ from historical exports.
Reconciliation workflow
mermaid
flowchart LR
A[Cash flow detail] --> B[Match daybook]
B --> C[Bank statement]
C --> D[Financial summary]
D --> E[Sign-off]| Step | Owner |
|---|---|
| 1 | Export cash flow |
| 2 | Compare to daybook_summary |
| 3 | Post missing ledger entries |
| 4 | Lock period in policy |
Permissions
| Report | Suggested permission |
|---|---|
| Cash flow | cash_management.view or analytics.view |
| Summary views | analytics.view |
| Export | Same as view |
Finance roles should not require invoice delete rights.
Read-only mode
Financial reports remain available when subscription is locked — critical for negotiating renewal with accurate numbers.