Myntra Reconciliation

Automate Myntra reconciliation with Cointab. Match orders, settlements, fees, refunds, and payments to detect discrepancies, reduce manual work, and improve financial accuracy.

By Vishwesh Sarkar

• 12 articles

How do I check the expected data format for a report and download a sample format?

Short Answer: Click 'View format' below a report's upload box to open 'Expected data format', review 'Data preview (sample rows)' and the right-side fields, then click 'Download format'. PreRequisites 1. Open the New reconciliation page or have the report tile visible 2. File(s) prepared if you want to compare to sample rows Steps 1. On the New reconciliation page click 'View format' under the report tile you want to inspect. 'Expected data format — ' modal opens. 2. In the modal review 'Data preview (sample rows)' and the right panel fields: 'Sheet', 'Header row', 'Date', 'Amount', 'Reference / Identifier' and 'Records to include'. You can see sample rows and the mapped tokens examples: 'order_release_id', 'Final_Amount', 'Payment_Date'. 3. If you want the sample file, click 'Download format' at the bottom-right of the modal. A format file sample format is downloaded to your computer. 4. Close the modal with 'Close' or the 'X' when finished. You return to the New reconciliation page. Troubleshooting 1. Downloaded format doesn't match the file you intended. LikelyCause: You opened the wrong report's 'View format' Payment vs RT vs Sales. Action: Re-open 'View format' for the correct report and download that format. Check the modal header 'Expected data format — '. 2. Sample rows don't show the right header row. LikelyCause: 'Header row' field may be set incorrectly. Action: Update the 'Header row' input to the correct row number e.g., '1' and confirm the preview aligns. Note: Field tokens visible in the modals include 'order_release_id', 'shipment_id', 'Sale_Order_Code', 'Payment_Date', 'Final_Amount', 'Total_Amount'.

Last updated on Sep 02, 2026

How do I create and run a new reconciliation for Myntra Marketplace?

Short Answer: On the New reconciliation page set Reconciliation name and Period, upload each report via 'Upload files', verify mappings with 'View format', then click 'Run reconciliation'. PreRequisites 1. Be signed in to the app 2. CSV, XLS or XLSX files ready for each report 3. Know which file maps to which report Myntra Sales - Return report, Myntra Payment Report, Myntra RT Report Steps 1. Open the New reconciliation page and confirm you see 'Reconciliation name', 'Period' and the report tiles. Page shows report tiles for 'Myntra Sales - Return report', 'Myntra Payment Report' and 'Myntra RT Report'. 2. Set the 'Reconciliation name' using the dropdown or '+ New' and choose 'Period' by clicking 'Select month/year'. Reconciliation name and Period are set. 3. Under each report tile click the dashed 'Upload files' area and select the appropriate CSV/XLS/XLSX file(s). Files appear in each report tile upload confirmed. 4. Click 'View format' for each report to open 'Expected data format' and confirm 'Sheet', 'Header row', 'Date', 'Amount' and 'Reference / Identifier' mappings. Mappings align with your column names and sample rows are visible. 5. When uploads and mappings are confirmed click 'Run reconciliation' at the top-right. Reconciliation runs and opens the results page 'Myntra Sales vs Payment Report'. 6. Review results using the summary cards and tabs on the results page. You see 'Total', 'Fully matched', 'Partially matched', 'Unmatched' cards and transaction tables. Troubleshooting 1. 'Run reconciliation' does nothing or appears disabled. LikelyCause: Required files or Period were not provided. Action: Upload all required report files and select a Period, then try 'Run reconciliation' again. 2. Results show fewer matches than expected. LikelyCause: Field mappings Date, Amount, Reference are incorrect. Action: Open 'View format' for each report and verify 'Reference / Identifier', 'Amount' and 'Header row' match your files; re-run reconciliation. Note: Use 'View format' to preview sample rows and confirm the exact column token names before running.

Last updated on Sep 02, 2026

How do I interpret the Total, Fully matched, Partially matched and Unmatched summary cards?

Short Answer: Each card shows per-report totals and transaction counts for that match status; 'Difference' is the monetary gap for that status. Use the cards and tabs to drill into rows. PreRequisites 1. A reconciliation has been run and results page is visible Steps 1. Open the 'Myntra Sales vs Payment Report' results page. You see four summary cards: 'Total', 'Fully matched', 'Partially matched', 'Unmatched'. 2. Read the 'Total' card for overall sums and counts per report and the 'Difference'. Totals and transaction counts are displayed for 'Myntra Sales - Return report' and 'Myntra Payment Report'. 3. Click a card or use the tabs 'Fully matched', 'Partially matched', 'Unmatched' to view the list of transactions in that status. Table of rows for the selected match status appears. 4. Click a transaction row to open 'Matched transaction details' for transaction-level comparison and exact 'Difference'. Modal shows both report rows, the 'Match basis' and the per-transaction 'Difference'. Troubleshooting 1. Fully matched shows a small non-zero 'Difference' example: 1.04. LikelyCause: Rounding differences or mismatched amount fields between reports. Action: Click into 'Fully matched', open suspicious rows' 'Matched transaction details' and inspect the amount columns; correct mapping or data and re-run if needed. Note: Percentages next to transaction counts show the share for that report e.g., '2,074 transactions (74%)'.

Last updated on Sep 02, 2026

How do I map Date, Amount and Reference / Identifier columns for a report?

Short Answer: Open 'View format' for the report, set 'Sheet' and 'Header row', then choose the correct 'Date', 'Amount' and 'Reference / Identifier' tokens shown e.g., 'Payment_Date', 'Final_Amount', 'order_release_id'. PreRequisites 1. Open the report's 'Expected data format' modal 2. Know which columns in your file contain the date, amount and ID Steps 1. Click 'View format' for the report tile to open the 'Expected data format' modal. Modal displays sample rows and field inputs on the right. 2. Set the 'Sheet' e.g., 'Sheet1' or 'CSV' and 'Header row' e.g., '1'. Preview columns align with header row. 3. Enter/select the correct column name for 'Date'. Examples: 'Payment_Date', 'order_created_date', 'Order_Created_Date'. Dates populate correctly in preview. 4. Enter/select the 'Amount' field. Examples: 'Final_Amount', 'Final_amount', 'Total_Amount'. Amounts match preview values. 5. Select one or more columns for 'Reference / Identifier'. Examples: 'order_release_id', 'shipment_id', 'Sale_Order_Code'. Reference tokens display under 'Reference / Identifier'. 6. Click 'Download format' or 'Close' to save and return to the reconciliation setup. Mapping is used during reconciliation. Troubleshooting 1. No matches after mapping. LikelyCause: Reference column differs between the two reports or header row is wrong. Action: Confirm both reports use the same ID column as 'Reference / Identifier' and adjust 'Header row' if needed; re-run reconciliation. 2. Dates or amounts appear incorrect in preview. LikelyCause: Wrong 'Date' or 'Amount' token selected or sheet/header mismatch. Action: Set the correct 'Sheet' and 'Header row', then pick the correct tokens and re-check the preview. Note: Selecting the same 'Reference / Identifier' token across both files is critical for matching.

Last updated on Sep 02, 2026

How do I unmatch a pair of matched transactions?

Short Answer: Open the matched row's 'Matched transaction details' modal and click the 'Unmatch' button in the 'Match basis' panel. PreRequisites 1. You have access to the reconciliation results and a matched row to unmatch Steps 1. From the results page click the matched transaction row to open 'Matched transaction details'. Modal appears showing the matched pair. 2. In the 'Match basis' panel click the 'Unmatch' button. The system begins the unmatch action. 3. Close the modal and inspect the 'Unmatched' or 'Partially matched' tab to confirm the transaction moved. The transaction no longer appears in the matched list. 4. If counts look incorrect, re-run reconciliation or refresh the page. Counts update to reflect the unmatch. Troubleshooting 1. 'Unmatch' button not visible or unclickable. LikelyCause: The row selected may not be a matched pair or the modal's UI state may have changed. Action: Confirm you're viewing a matched row in 'Matched transaction details'. If issue persists, refresh the results page and try again. 2. Transaction still appears matched after clicking 'Unmatch'. LikelyCause: UI did not refresh or server update pending. Action: Refresh the page or re-run the reconciliation to update counts. Note: The 'Unmatch' button is visible inside the 'Match basis' panel of the Matched transaction details modal.

Last updated on Sep 02, 2026

How do I upload files to a report Myntra Sales / RT / Payment?

Short Answer: Click the dashed 'Upload files' area inside the report tile and select your CSV, XLS or XLSX file(s). The UI notes 'CSV, XLS, XLSX — select multiple files'. PreRequisites 1. Be on the New reconciliation page 2. Have the file(s) in CSV, XLS or XLSX format Steps 1. Open the New reconciliation page and locate the report tile you want to populate. Report tile e.g., 'Myntra Sales - Return report' is visible. 2. Click the dashed 'Upload files' area inside the tile. File picker opens allowing selection of files. 3. Select one or more CSV/XLS/XLSX files and confirm the selection. Uploaded file(s) are listed in the tile. 4. Repeat for other report tiles as needed. All required reports have files uploaded. Troubleshooting 1. Upload fails or file not accepted. LikelyCause: Unsupported file type or corrupt file. Action: Save/export the file as CSV, XLS, or XLSX and re-upload. Open the file locally to ensure it contains rows. 2. Uploaded file's columns don't match the expected format. LikelyCause: Wrong file uploaded to the report tile. Action: Click 'View format' and compare 'Data preview (sample rows)' to your file; upload the correct file for that report. Note: The upload area explicitly says 'CSV, XLS, XLSX — select multiple files'.

Last updated on Sep 02, 2026

How do I use the three-dot menu to Share, Copy reconciliation, Delete records or Delete report?

Short Answer: Click the three-dot menu near 'Download report' to open options: 'Share', 'Copy reconciliation', 'Delete records' and 'Delete report'. 'Delete report' is shown in red. PreRequisites 1. Be on the reconciliation results page Steps 1. On the results page locate and click the three-dot menu ellipsis near 'Download report'. Menu expands showing options. 2. Select the desired action: 'Share', 'Copy reconciliation', 'Delete records' or 'Delete report'. The chosen action executes or a follow-up prompt appears. 3. If selecting 'Delete report', note the red styling and follow any confirmation prompts shown. Deletion proceeds after confirmation if required. Troubleshooting 1. Menu actions fail to run or are missing. LikelyCause: You may lack the required privileges to perform that action. Action: Verify your account permissions and try again, or ask the account admin for access if needed. Note: The presence and effect of each action share/copy/delete may depend on your account permissions or system behavior not shown in the screenshots.

Last updated on Sep 02, 2026

How do I view detailed information for a matched transaction?

Short Answer: Click the matched transaction row in the table to open the 'Matched transaction details' modal; review the 'Match basis', both report rows and the 'Difference'. PreRequisites 1. Reconciliation has been run and matched rows are visible Steps 1. Go to the results page and open the tab containing the matched transaction e.g., 'Fully matched'. Transaction table lists matched rows. 2. Click the transaction row you want to inspect for example row with 'ORD102476'. The 'Matched transaction details' modal opens. 3. In the modal review the 'Match basis' panel which shows chips like 'Reference ID' and 'Amount' and the description 'Transactions matched using Identifier and Amount'. You see which fields were used to create the match. 4. Compare the left and right sections to inspect dates, IDs and amount fields and check the 'Difference' at the bottom. You identify any mismatch or confirm amounts equal Difference 0.00. Troubleshooting 1. Modal doesn't show the expected details. LikelyCause: The row selected may be partially matched or mapping has changed since the reconciliation. Action: Verify which tab you're viewing and re-open 'View format' to confirm mappings; re-run reconciliation if needed. Note: Use the 'X' at top-right of the modal to close it when finished.

Last updated on Sep 02, 2026

What does 'Include all records' in 'Records to include' mean?

Short Answer: 'Include all records' toggled ON means every row is included; if OFF, only rows that meet the defined conditions are included and others appear as 'Excluded by rule'. PreRequisites 1. Open the report's 'Expected data format' modal Steps 1. Open 'View format' for the report. 'Expected data format' modal opens. 2. Scroll to the 'Records to include' section in the right panel and read the description. You see: 'Only records that meet these conditions will be included in reconciliation. Others will appear in Skipped as "Excluded by rule"'. 3. Toggle 'Include all records' ON to include every row or OFF to limit rows to matching conditions. Toggle state changes to include or exclude records. 4. Close the modal when done. Your selection is applied to reconciliation. Troubleshooting 1. Some rows expected in reconciliation are missing. LikelyCause: 'Include all records' is turned OFF or exclusion conditions are filtering them. Action: Open 'View format' and turn ON 'Include all records' or review the conditions that exclude rows. Note: The exact explanatory text is shown in the modal as quoted above.

Last updated on Sep 02, 2026

Where do I download or export the reconciliation report?

Short Answer: On the reconciliation results page click the 'Download report' button at the top-right to export the current report data. PreRequisites 1. Reconciliation has been run and results are visible Steps 1. Open the reconciliation results page 'Myntra Sales vs Payment Report'. Results page with 'Download report' visible at top-right. 2. Click the 'Download report' button at the top-right. A file download is initiated file type not shown in screenshots. 3. If needed, update data first using 'Add files & update report' then re-run reconciliation before downloading. Downloaded file reflects the latest data. Troubleshooting 1. Downloaded file missing expected rows or columns. LikelyCause: Active filters/tabs or an incomplete reconciliation run. Action: Ensure the desired tab and filters are selected, or re-run reconciliation via 'Add files & update report' then try 'Download report' again. Note: There may be additional actions in the three-dot menu 'Share', 'Copy reconciliation', 'Delete records', 'Delete report'.

Last updated on Sep 02, 2026

Why are transactions unmatched even though reference IDs look identical?

Short Answer: Common causes: wrong 'Reference / Identifier' mapping, incorrect 'Header row' or 'Sheet', differing amount fields or sign differences, or records excluded by 'Records to include' rules. PreRequisites 1. You have run reconciliation and observed Unmatched results Steps 1. Open 'View format' for each report and confirm the same 'Reference / Identifier' column is selected e.g., 'shipment_id' vs 'order_release_id'. Both reports use the same ID token for matching. 2. Verify 'Sheet' and 'Header row' so the preview rows align with your file headers. Preview displays correct columns under the mapped tokens. 3. Confirm the 'Amount' mapping is the correct column and that signs negative/positive are consistent for returns vs sales. Amounts show expected sign and values in preview. 4. Ensure 'Include all records' is ON if you expect every row to be considered. Rows are no longer excluded as 'Excluded by rule'. 5. Re-run reconciliation and inspect the 'Unmatched' tab or open a given row's 'Matched transaction details' for exact values. You can see why rows did or did not match. Troubleshooting 1. IDs look identical but transactions stay unmatched. LikelyCause: ID column chosen differs between reports, or IDs contain whitespace/case differences. Action: Select the exact same 'Reference / Identifier' token for both reports and clean the source ID values by trimming whitespace and normalizing case before uploading. 2. Amounts close but don't match exactly. LikelyCause: Rounding, tax fields or different amount columns used. Action: Use the same 'Amount' field across reports and inspect 'Matched transaction details' to find which rows cause the discrepancy. Note: Use the 'Data preview (sample rows)' in 'View format' to compare how each file presents IDs and amounts before running reconciliation.

Last updated on Sep 02, 2026

Why does the Fully matched card show a non-zero Difference?

Short Answer: A non-zero 'Difference' within Fully matched usually indicates small rounding differences, different amount columns or tax/fee fields counted differently across the two reports. PreRequisites 1. You can access the reconciliation results and 'Matched transaction details' Steps 1. Click the 'Fully matched' card or tab to list matched transactions. Table of fully matched rows is visible. 2. Open the 'Matched transaction details' modal for rows likely contributing to the small Difference. Compare amount-related columns e.g., 'Final_Amount', 'igst_amt'. 3. Identify whether rounding, tax fields, or a wrong amount mapping cause the gap. You find the specific source of the difference. 4. Correct mappings or normalize amounts in source files and re-run reconciliation if needed. Difference should update after fixes and re-run. Troubleshooting 1. Difference persists after inspecting a transaction. LikelyCause: Amounts may include taxes or fees on one side that are not present on the other side. Action: Ensure both reports point to the same net/total amount column or perform pre-processing to align the columns, then re-run reconciliation. Note: In the example results the 'Fully matched' card shows 'Difference 1.04' — inspect transaction-level details to find contributors.

Last updated on Sep 02, 2026