Skip to content

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)

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.