More in Business reports
Where to find it
MenuReports › Date Wise Comparision
Use this report to plan staff and stock. If every Monday brings 60 bills and Thursday brings 25, you know when to call the part-time phlebotomist and when a technician can take leave. Each row is one day.
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 date
- patients bills made that day
- Count chart bills per day
- Amount chart billed amount per day
- Total Amount billed value of the whole period
Steps
- Open the report
Go to Reports > Date Wise Comparision. - Set the period and click OK
A month or a quarter works well. - Read the rows
The column headed Test holds the date (dd-MM-yyyy). patients is the number of bills that day. amt is the test total of those bills. - Look at the charts
One chart shows the bills per day, the other the amount per day. The bars show at a glance which days were heavy. - Export
Click Excel. In Excel you can add a weekday column and compare Mondays with Thursdays.
Cautionamt is billed value by bill date, before discount and without extra charges. It is not the money collected that day. For cash in hand, use the Daily Collection Report.
CautionOn the printed page only the day number of each date comes through. Print from the Excel sheet when you need full dates on paper.
Good to knowDays with no bills do not appear, so a Sunday when the lab was closed leaves no row.
Questions people ask
Why does the list start with the last day?
The newest day comes first, so the latest figures are on top.
Does it count pending bills?
Yes. Pending and finished bills both count, by the bill date.
Why does today's amt differ from today's Daily Collection?
Date Wise counts bills made today. Daily Collection counts money received today, including old dues.