More in Business reports
Where to find it
MenuReports › Group Wise Comparision
This report works like Test Wise Comparision, but it adds up the tests of each test group. It answers the owner's bigger question: which department carries the lab? If Biochemistry bills four times what Serology bills, that is where a second analyser or an extra technician pays back first.
On this screen
- From start of the period; To is the end
- OK fills the grid and both charts
- Test here this column holds the group name
- patients test lines billed in the group
- Count chart one bar per group, by count
- Amount chart one bar per group, by amount
- Total Amount billed value of all groups
Steps
- Open the report
Go to Reports > Group Wise Comparision. - Set the period and click OK
Use a full month, so the figures can be compared month to month. - Read the rows
The column headed Test holds the group name. patients is the number of test lines in that group. amt is their billed value. - Read the charts and totals
The charts show count and amount per group. The totals are at the bottom. - Export for a meeting
Click Excel and keep one sheet per month.
Example: in October, City Care Diagnostics sees Biochemistry 1,240 lines, ₹3,10,000; Haematology 860 lines, ₹1,29,000; Serology 210 lines, ₹42,000.
Cautionpatients counts test lines, not people. A patient with a Lipid Profile and an LFT in Biochemistry adds 2 to that group.
CautionThe printed page may show no group names. Print from the Excel sheet instead, which carries the title "Group Wise Comparision".
Good to knowLike Test Wise, it counts pending, finished and Medical Examination lines, and amounts are before discount.
Questions people ask
A group I expected is missing.
No test of that group was billed in the period.
Can I see the sub groups?
Not on this report. Use Test Wise Comparision for test-level detail.
Why does the Excel title say Test Wise?
That is the title this report writes. Correct cell A1.