# 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. ![Consolidated Income Report for one month (values hidden)](images/19613-consolidated-income-report.png) *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. | --- ## Related - [Report Favorites](Report-Favorites) - [Reports: Institution, Site and Department Filters](Reports-Institution-Site-Department-Filters)