Financial Reports
Generate revenue, outstanding, P&L, and branch comparison reports with CSV export
Overview
SehaFile's financial reporting module provides comprehensive analytical views of your clinic's financial performance. Reports include revenue analysis by day and payment method, outstanding invoices tracking, full profit and loss statements with expense breakdowns, and multi-branch performance comparison. All reports support custom date ranges and can be exported to CSV for external analysis.
Available Reports
1. Revenue Report
- Navigate: Go to Financial > Reports > Revenue.
- Set Parameters:
- Start Date - Beginning of period (defaults to 1st of current month)
- End Date - End of period (defaults to today)
- Branch - Optional branch filter
- View Results: Shows daily revenue breakdown with:
- Date, total collected, transaction count
- Breakdown by payment method (cash, card, bank transfer, insurance)
- Total revenue for the entire period
2. Outstanding Report
- Navigate: Go to Financial > Reports > Outstanding.
- Set Branch Filter (Optional): Filter by specific branch.
- View Results: Lists all unpaid and partially paid invoices:
- Invoice number, patient name
- Total, amount paid, remaining balance
- Issue date and due date
- Invoice status (unpaid/partial)
- Aggregate total outstanding across all invoices
3. Financial Report (P&L)
- Navigate: Go to Financial > Reports > Financial.
- Set Date Range: From and To dates.
- View Results: Complete profit and loss breakdown:
- Total Revenue - All payments collected
- Revenue by Method - Cash, card, transfer, insurance totals
- Payments by Type - Consultation, procedure, lab, etc. with counts
- Total Expenses - All expenses recorded
- Expenses by Category - Rent, salaries, supplies, utilities, etc.
- Net Income - Revenue minus expenses
- Invoices by Status - Count and total per status (paid, unpaid, partial, void)
4. Branch Comparison Report
- Navigate: Go to Financial > Reports > Branches.
- Set Date Range: From and To dates.
- View Results: Side-by-side comparison of all active branches:
- Branch name (Arabic and English)
- Revenue per branch
- Expenses per branch
- Net income per branch
- Totals row aggregating all branches
Exporting Data
- Invoices Export: Go to Financial > Invoices and click Export CSV. Columns: invoice_number, patient, total, paid, status, date.
- Payments Export: Go to Financial > Payments and click Export CSV. Columns: date, patient, amount, method, type, invoice, reference.
- Expenses Export: Go to Financial > Expenses and click Export CSV. Columns: date, description, amount, category, vendor.
Tip: Use the Financial Report (P&L) for monthly accounting close. It provides everything needed for bookkeeping: revenue by method, expenses by category, and net income calculation.
Tip: The Branch Comparison report helps identify underperforming locations. Compare net_income across branches to make data-driven decisions about staffing and resource allocation.
Warning: CSV exports include ALL records (up to 10,000). For very large clinics, this may take a moment to generate. Use date filters to limit the export size.
Financial report showing revenue by payment method, expenses by category, net income calculation, and branch comparison table
Frequently Asked Questions
What date format does the CSV export use?
Dates are exported in ISO format (YYYY-MM-DD). The CSV file includes a BOM character for proper Arabic display in Excel.
Can I schedule automatic report generation?
Currently, reports are generated on-demand. Navigate to the report you need and set your date parameters each time.
Why does my revenue report differ from the dashboard?
The dashboard shows current-month and today's figures only. The Revenue Report allows custom date ranges and breaks down data by day and payment method, which may reveal different groupings.
How are refunds shown in reports?
Refund payments appear as separate payment entries with payment_type = "refund". They are included in total revenue calculations. For net revenue, subtract refund amounts manually or check the payments_by_type section in the P&L report.
Was this article helpful?