The Treatment Done Report allows information to be exported to an external text file and can be opened in a spreadsheet (Excel).
Export the Export
-
In the report preview window, click Export
-
Select a location to save the file (eg Desktop)
-
Select HTML from the Save as Type droplist
-
Enter a filename
-
Click Save
Export Details
The names of the exported fields are not shown, so listed below are each of the fields so they can be matched and added to the spreadsheet manually.
-
Treatment date
-
Item
-
Times
-
Account ID (if exists; otherwise – EMPTY string)
-
Fee per item according to the Practice Fees
-
Fee per item according to appropriate Insurance Plan rebate (if the patient has Insurance Plan; otherwise – ZERO)
-
Discount as %
-
Practice Fee Level ID
-
Insurance Plan Series
-
Insurance Plan Number
-
Insurance Company
-
State code
-
Patient’s Card No
-
Surname
-
First Name
-
Middle Name
-
Sex
-
Address
-
DOB
-
Contract Number
-
Patient category
-
Provider code
-
Assistant code
Comments
Article is closed for comments.