Consolidated Income Report¶
One report for the hospital's billed income in a period: services (OPD, Laboratory, ECG, X-Ray, Dressing and other departments), Channelling, Wards and Collecting Centres, with a grand total. For a financial year, enter the year's first and last day as the date range.
Page: Reports → Reports → Financial Reports tab → Consolidated Income Report
Privilege: ReportsIncomeBreakdownByCategory (the same privilege as Income Breakdown by Category)
Favorite key: consolidatedIncomeReport (star it to also pin it to the ⭐ Favorites tab)
Filters¶
| Filter | What it does |
|---|---|
| From / To | The period. Bills are counted by the date and time they were raised; ward patients by their discharge date. |
| Institution, Site, Department | The department where the bill was raised. For Wards, the patient's admitting department. Leave them empty for the whole hospital. |
Click Process. Download Excel puts each section on its own sheet in one file; Print prints the report.

The report for one month: the Summary, then each section. Values are hidden in this picture.
How each figure is worked out¶
All figures are billed income, net of cancellations and refunds. A bill and its cancellation or refund are counted together, so a bill cancelled in the same period adds nothing. A credit bill counts when it is billed, not when it is paid.
| Section | Shows | Counted from |
|---|---|---|
| Summary | One line per section and the Grand Total. | The totals of the sections below. |
| Services by Performing Department | One row per department that performs the service, for example Main Laboratory, X Ray, ECG, Dressing, OPD. | OPD bills (including package bills), by the department each service belongs to, not by the department that raised the bill. |
| Channelling | Doctor Fee, Hospital Fee and the total billed. | Channel bookings, including unpaid and completed online bookings, less channelling cancellations and refunds. Paying later for an unpaid booking is not counted again. |
| Wards | One row per admitting department: number of discharges, Professional Fee, Medicine & Pharmacy, Other, Discount and Net Income. | The final bills of patients discharged in the period. Patients still admitted, and patients whose final bill is not completed, are not included. A cancelled final bill is not counted. |
| Collecting Centres | One row per collecting centre. | Collecting centre bills, less their cancellations and refunds. |
Grand Total = Services + Channelling hospital fee + Wards net income + Collecting Centres. The channelling doctor fee is shown for information only; it is paid to the doctor and is not hospital income.
Wards columns¶
| Column | Includes |
|---|---|
| Professional Fee | Consultant fees, assistant (doctor and nurse) fees, technician and paramedical fees. |
| Medicine & Pharmacy | Medicine issued to the patient (from any pharmacy, store, ETU or theatre), medicines and surgical supplies, extra medicine charges, theatre consumables and drugs. |
| Other | Every other charge: rooms, services, investigations, admission fee and so on. |
| Discount | The discount given on the final bill. |
| Net Income | Professional Fee + Medicine & Pharmacy + Other − Discount: the final bill's net total. |