1. Login to Ventura Securities backoffice: https://backoffice.ventura1.com/

2. From the left panel click on 'Equity'.

Click image for larger version  Name:	How_to_get_Ventura_Securities_Excel_statement_for_single_day_in_MProfit_1.PNG Views:	1 Size:	51.8 KB ID:	474


3. Click on 'Financial Ledger'.

Click image for larger version  Name:	How_to_get_Ventura_Securities_Excel_statement_for_single_day_in_MProfit_2.PNG Views:	1 Size:	101.8 KB ID:	475


4. If the ledger is not already displayed then choose the period and click on Submit. Then click on the link from the narration.

Click image for larger version  Name:	How_to_get_Ventura_Securities_Excel_statement_for_single_day_in_MProfit_3.PNG Views:	1 Size:	119.6 KB ID:	476


5. The bill will open in new window. Click on 'Excel' icon to import it

Click image for larger version  Name:	How_to_get_Ventura_Securities_Excel_statement_for_single_day_in_MProfit_4.PNG Views:	1 Size:	84.0 KB ID:	477


6. Use "Ventura Securities - Excel (v1)" template to import the file in MProfit.