1. Login to JM Financial backoffice.


Click image for larger version  Name:	1final.png Views:	8 Size:	402.1 KB ID:	1175


2. Go to the Equity Broking tab. Next, click Combined Ledger - All Segments.


Click image for larger version  Name:	2final.png Views:	3 Size:	83.6 KB ID:	1176


3. Select your time period. Next, click on Generate Report.


Click image for larger version  Name:	3.PNG Views:	3 Size:	158.9 KB ID:	1177


4. Click on the Excel Icon to export the file in Excel format.


Click image for larger version  Name:	4final.png Views:	3 Size:	131.3 KB ID:	1178


5. The file will be downloaded in Excel format. You must open the Excel file and save it in “CSV (Comma delimited) (*.csv)” format.

6. From MProfit, use the "JM Financial Excel - Ledger (v2)" template to import your file.


Click image for larger version  Name:	import.PNG Views:	3 Size:	4.0 KB ID:	1179


7. Here is the image of the sample backoffice file from JM Financial.


Click image for larger version  Name:	JM_Financial_Excel_Ledger_v2_Sample.png Views:	3 Size:	89.6 KB ID:	1180