How Do I .... Work out income from Disp Fees?
Since dispensing fees etc. are a topic of conversation here is a simple way to see what income you are generating from them. There area few ways of doing it:
- Use Microsoft Excel, OpenOffice or other Spreadsheet
The system records in a csv file everytime a dispensing fee is used. You can use the option: Reports -> Windows Export Files -> Scan -> dispfee.csv The different columns in
dispfee.csvare:Date work was entered
Animal record it was added to
Disp Fee before any discounts/classifications
The amount of the Dispencing fee
The classification the animal was in
Analysis code of the item
Fees component of the line
Drugs component of the line
User who did the work
You can use the functions withon your spreadsheet to add and manipulate the data as required.
- Use DataMajor
There are reports in DataMajor that will report on the dispensing fee (or lack of it).
Stored Reports -> Stock Related:
Fees Components on drugs *
Stock Items in last 60 days with no disp fee *Stored Reports -> Stock Related -> Markup and Cost Related
Income from Stock over last year
Items with no dispensing fee - Use 'Search for Code' *
Run the report for the client range/type you are interested in. Restrict the search to JUST stock analysis codes and make sure 'Abort once found' is set to NO, set the dates to cover the period you are interested in.
Note:This is a very slow method.
I would STRONGLY suggest you send this report to the spooler (F9 and swap printers) as it will be quite large.
Go into the spooler, select the correct report, view it, jump to the bottom (e.g. press the
key). The bottom line will show you the total of the 'fees' column - this is the income from disp fees. Note: You can setup a history report to give you the split on a per animal/client basis from the clinical screen.
- Use the Monthly/Yearly summary.
It is possible to work it out via the totals here BUT it depends on your AP setup. Rather than confuse some I will ignore this method other than say - the figures shown on the turnover report show the Fees/Drugs as per clinical records and the Analysis code shows the line total - subtract the two and you have it.
--- Make sure you are separating out your disp/Inj/Supply fees ---This is switched off/on via the option:
--- if you haven't you can get the split. ---