More in Business reports
Where to find it
MenuReports › Test Wise Comparision
This report tells you how often each test was billed and what it brought in. Use it to decide which tests to promote, which reagent kits to stock, and which machine is earning its keep. "Comparision" is spelt this way in the menu.
On this screen
- From start of the period; To is the end
- OK fills the grid and both charts
- patients times each test was billed
- amt billed value before discount
- Count chart one bar per test, by count
- Amount chart one bar per test, by amount
- Excel export, then sort by count or amount
- Total Amount sum of amt; No. of Patients beside it
Steps
- Open the report
Go to Reports > Test Wise Comparision. It stays empty until you click OK. - Set the period
For example, the whole of last month. Click OK. - Read the grid
Columns Test, patients and amt, tests in A to Z order. - Read the charts
One chart shows the count per test, the other the amount per test. The tallest bars are your busiest tests. - Rank the tests
Click Excel and sort by count or amount there.
| Item | What it counts |
|---|---|
| patients | How many times the test was billed. A patient with three tests adds 1 to each. |
| amt | Total of the test's price on each bill, before the bill discount. |
| No. of Patients | Sum of the patients column, shown with two decimals, such as 245.00. |
| Total Amount | Sum of the amt column. |
CautionThe report reads every test line in the period: pending, finished and Medical Examination lines. Items such as "Height" from a medical report appear with an amount of 0. The amt column is billing, not money received.
CautionThe printed page may show no test names. For a paper copy, click Excel and print from Excel.
Good to knowTests are grouped by name. Two tests with the same name in different groups show as one line.
Questions people ask
Why isn't my most popular test at the top?
The list is A to Z. Look at the chart, or sort in Excel.
Is "patients" the number of people?
No. It is how many times the test was billed.
Does amt include the discount?
No. It is before the bill discount.