Upload Order Data

Upload your Meesho Order Data files (CSV). You can upload multiple files at once. Recommended: Upload complete month's files (From 1st to Last day) without any modification. All the Orders from this sheet will be compared with payment files. Go to ORDERS > DOWNLOAD ORDER DATA > Select Date range > Export Data.

Upload Payments Data

Upload your Meesho Payment/Settlement files. Go to PAYMENTS > DOWNLOAD > PAYMENT TO DATE > CUSTOM DATE RANGE > Select from Date of Orders Data to all Future months. E.g. If Order Data from 1st Oct to 31 Oct is selected, Download "Payment to Date" File from 1-31 Oct, 1-30 Nov, 1-31 Dec. If you are checking P&L Report on 14 Nov, download "Paymnet to Date" File from 1-31 Oct, 1-14 Nov & "Outstanding Payments> All Payments" file as on 14 Nov. It is important that payment status of all the orders of Oct is present in Payment files. Extract Payment file zip and upload excel file. Files can be renamed but should not be modified.

Upload SKU_Grouping File (Optional for 1st time users)

If you don't have SKU_Grouping File, The system will generate it from Orders data, Update/Assign Group/Head and Cost of all SKU and upload it. If you have a SKU_Grouping file, Update/Assign Groups to all SKU (to get Item wise profit also) and Update the cost of all SKU (Including Packaging cost, Labour, Transport and GST cost on purchase) upload it to get SKU-Wise and Group/Head-wise P&L breakdown. If Cost of any SKU is not mentioned then profit could be wrong.

Generate P&L Report

Click Generate and the system will analyze your data and produce a detailed SKU-wise Profit & Loss report. This report is based on Meesho's Data only, actual profit/loss depends on other cost which are not included here like Rent/Salaries/Electricity/Other Expenses.

Order Data: Go to Orders > Download Orders > Select date range and download

Payments Data: Go to Payments > Download > Payment To Date & Outstanding Payment. Download Files for each payment cycle. Recommended: 3 Months payment report so that all the return period is over and all transactions are settled.

Upload these files directly to generate your P&L Report