• Go to Daily Reports > Business Analysis.

• A 'Sale Purchase Analysis' window will appear in which the user will select 'Patient' in 'Analysis' field.

• The user needs to select 'Bill' in 'V/S' field and select 'Sale Analysis' in next field.

• Then select 'Detail/Summary/Detailed Summary' as per the requirement.

• Suppose the user will select 'Detail'. 

• The user will select the date range (from which to which the report needs to be viewed).

• Now, click on 'Show' to generate the details of report.

• Now in order to export the report in excel, the user will select Excel, CSV, XML, as per the requirement.

• Suppose the user will select 'Excel'.

After following the above Steps, patient bill sale Report will be generated in excel format.