Flipkart Reconciliation

Automate Flipkart 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 create a new reconciliation and upload Flipkart files?

Short Answer: On the New reconciliation page set a Reconciliation name and Period, upload each Flipkart report in its 'Upload files' area, confirm mappings via 'View format', then click 'Run reconciliation'. PreRequisites 1. Signed in to Cointab 2. CSV/XLS/XLSX Flipkart files ready Sales, Settlement, Cashback as applicable 3. You know the month to reconcile Steps 1. Open the New reconciliation page. Page shows report cards for Flipkart Sales Report, Flipkart Settlement Report, Flipkart Cashback Report. 2. Set 'Reconciliation name' by selecting an existing name or clicking '+ New' and set 'Period' using 'Select month/year'. Reconciliation name and Period are selected. 3. Under each report card for example 'Flipkart Sales Report' click 'Upload files' and select your CSV/XLS/XLSX files. You can select multiple files. Files appear listed in the report card upload area. 4. For each report click 'View format' to confirm required fields and sample columns. 'Expected data format' modal opens for that report Sales, Settlement or Cashback. 5. In the 'Expected data format' modal confirm or set required fields Sheet, Header row, Date, Amount, Reference / Identifier and toggle 'Include all records' if needed. Mappings match your file columns. 6. Click 'Run reconciliation' top-right to run the reconciliation. You are taken to the results page showing summary cards and match lists. Troubleshooting 1. Run returns zero records or no matches. LikelyCause: Required fields Sheet, Header row, Date or Amount are incorrect or 'Include all records' is turned off. Action: Open 'View format' for the report, set the correct 'Sheet' and 'Header row', map 'Date' and 'Amount', enable 'Include all records' if needed, re-upload and run again. 2. Upload fails or file not accepted. LikelyCause: File is not a supported format or is corrupted. Action: Save the file as CSV, XLS or XLSX and re-upload. The upload area reads 'CSV, XLS, XLSX — select multiple files'. 3. 'Run reconciliation' is not responsive or appears disabled. LikelyCause: No files uploaded or required mappings not confirmed. Action: Upload files to each report card and confirm required fields in 'View format', then click 'Run reconciliation' again. Note: You can upload multiple files per report. Use 'View format' to preview sample columns and download a template if needed.

Last updated on Sep 02, 2026

How do I download or share the reconciliation report?

Short Answer: On the reconciliation results page click 'Download report' to download. Use the three-dot menu to 'Share', 'Copy reconciliation', 'Delete records', or 'Delete report'. PreRequisites 1. Be on the reconciliation results page Steps 1. On the results page click the 'Download report' button near the top-right. A reconciliation report file is downloaded. 2. Click the three-dot menu kebab next to 'Download report' and choose 'Share', 'Copy reconciliation', 'Delete records', or 'Delete report' as needed. The chosen action share, copy, or delete is performed or a confirmation appears. Troubleshooting 1. Menu items not visible. LikelyCause: Your account role may not have permission to perform that action. Action: Check with your admin or use available actions such as 'Download report'; if you need access to other actions request permissions. Note: The 'Delete report' option is shown in red — confirm before using it.

Last updated on Sep 02, 2026

How do I download the expected file template for a report?

Short Answer: Open the report's 'View format' modal and click 'Download format' to download the sample template for that Flipkart report. PreRequisites 1. Open the New reconciliation page 2. Click 'View format' on the desired report card Steps 1. On the New reconciliation page click 'View format' under the report card. 'Expected data format' modal opens. 2. Click the 'Download format' button at the bottom-right of the modal. The report template file begins downloading. Troubleshooting 1. Download does not start. LikelyCause: Browser pop-up blocker or temporary network issue. Action: Allow downloads/pop-ups for this site, check your browser downloads folder, or refresh and try 'Download format' again. Note: Downloaded template matches the sample columns shown in the modal.

Last updated on Sep 02, 2026

How do I include or exclude records from reconciliation?

Short Answer: Open the report's 'View format' modal and use 'Records to include' > toggle 'Include all records' to include every row or apply conditions to include only some rows. PreRequisites 1. Open 'View format' for the report you want to control Steps 1. On the New reconciliation page click 'View format' for the target report. 'Expected data format' modal opens. 2. Scroll to the 'Records to include' section on the right. You see the toggle 'Include all records' and explanatory text. 3. Turn the 'Include all records' toggle On to include every row or Off to apply conditions. The selection is set and will be used when you run reconciliation. Troubleshooting 1. Some expected rows are missing from reconciliation results. LikelyCause: 'Include all records' is turned Off or the inclusion conditions exclude rows. Action: Open 'View format', turn 'Include all records' On if appropriate, verify header row and mappings, then re-run reconciliation. Note: 'Include all records' is useful when you want every row in the file considered for matching; when Off only rows meeting the conditions appear.

Last updated on Sep 02, 2026

How do I map the Date, Amount, and Reference / Identifier fields for a Flipkart report?

Short Answer: Open the report's 'View format' modal and set the 'Required fields' on the right: 'Sheet', 'Header row', select the correct 'Date' and 'Amount' columns, and choose 'Reference / Identifier' e.g., 'Order Item ID'. PreRequisites 1. Have your file's column headers and the header row number ready 2. Open the report's 'View format' modal Steps 1. Click 'View format' for the report on the New reconciliation page. 'Expected data format' modal opens. 2. In the 'Required fields' panel set 'Sheet' and the numeric 'Header row' that contains your column headers. 'Sheet' and 'Header row' reflect your file structure Sales Report, Orders, Cash Back Report as shown. 3. Select the 'Date' field that matches your file. Examples shown: 'Buyer Invoice Date' for Sales, 'Payment Date' for Settlement, 'Invoice Date' for Cashback. The 'Date' field maps to your file's date column. 4. Select the 'Amount' field that matches your file. Examples shown: 'Final_amount' or 'Invoice Amount'. 'Amount' maps to the correct numeric column in your file. 5. Select one or more 'Reference / Identifier' columns. The UI shows 'Order Item ID' or 'Order item ID'. Reference values will be used to match Side A and Side B records. 6. Toggle 'Include all records' in 'Records to include' if you want to include every row from the file. 'Include all records' is On if you want to include every row. 7. Click 'Close' or 'Download format' when done. Modal closes and mappings are set for that report. Troubleshooting 1. Expected column names are not listed in the field pickers. LikelyCause: Header row is set to the wrong row or the file header names differ. Action: Set the correct 'Header row' or rename your file column headers to match the expected fields, then re-open 'View format' and remap. Note: Examples shown in the modals: Sales Report Sheet: 'Sales Report', Header row: '1', Date: 'Buyer Invoice Date', Amount: 'Final_amount', Reference: 'Order Item ID'.

Last updated on Sep 02, 2026

How do I open and interpret 'Matched transaction details'?

Short Answer: Click a matched row or a 'Multiple transactions' link to open the 'Matched transaction details' modal which shows 'Match basis', the Side A and Side B rows, totals and the 'Unmatch' button. PreRequisites 1. A reconciliation run with matched transactions 2. Access to the results page Steps 1. On the results page click a matched row, the row's 'Multiple transactions' link, or the matched amount. 'Matched transaction details' modal opens. 2. Review the 'Match basis' area for example 'Reference ID + Amount'. You see how the system matched the records. 3. Inspect Side A Your Records and Side B External records tables and compare columns such as Order Date, TDS Amount, Order ID, Order Item ID, Seller GSTIN, Invoice Date, Invoice Amount. You can confirm which rows were matched and the amounts involved. 4. Look at the totals at the bottom 'Side A total', 'Side B total', 'Difference'. You see the numeric difference between sides. Troubleshooting 1. Match details show unexpected rows or amounts. LikelyCause: Mapping or file data e.g., wrong sign on amounts is incorrect. Action: Open the report's 'View format', confirm 'Amount' and 'Reference / Identifier' mappings, correct the source file if needed, then re-run reconciliation. Note: The modal lists every matched row from both sides; use it to confirm why two entries were paired.

Last updated on Sep 02, 2026

How do I run a reconciliation and where do I see the results?

Short Answer: After uploading files and confirming mappings, click 'Run reconciliation' top-right. Results appear on the reconciliation page showing Total, Fully matched, Partially matched, and Unmatched cards and transaction lists. PreRequisites 1. Files uploaded to each report card 2. Required fields mapped via 'View format' Steps 1. On the New reconciliation page confirm uploads and mappings for each report. All required files are uploaded and mapped. 2. Click 'Run reconciliation' top-right. The system runs the reconciliation. 3. After the run, review the results page 'Flipkart' which shows summary cards Total, Fully matched, Partially matched, Unmatched and tabbed transaction lists. Summary cards and lists display counts and amounts of matched/unmatched transactions. 4. Click a tab Fully matched, Partially matched, Unmatched to view the detailed transaction table. You can review and click rows to inspect match details. Troubleshooting 1. Results show unexpected zero counts or blank lists. LikelyCause: Files uploaded to wrong report card, fields not mapped, or 'Include all records' set incorrectly. Action: Verify uploads on each report card, open 'View format' to confirm mapping and 'Include all records', then re-run reconciliation. Note: Results card values include both amounts and transaction counts e.g., '175.93 — 340 transactions'.

Last updated on Sep 02, 2026

How do I unmatch a matched transaction?

Short Answer: Open the matched transaction's 'Matched transaction details' modal and click the red 'Unmatch' button shown in the modal. PreRequisites 1. Open a matched transaction's details modal from the results list Steps 1. From the results table click the matched row to open 'Matched transaction details'. Modal opens showing Side A and Side B rows. 2. Click the 'Unmatch' button in the modal visible near the Match basis area. System attempts to remove the pairing. 3. Refresh the results page or re-run reconciliation if counts do not update automatically. The transaction moves to Partially matched or Unmatched lists as appropriate. Troubleshooting 1. Clicking 'Unmatch' does not change the match. LikelyCause: Frontend did not refresh or reconciliation needs to be re-run to reflect change. Action: Refresh the page or click 'Run reconciliation' again; if still unchanged, repeat the unmatch action and confirm. Note: The 'Unmatch' button is visible in the 'Matched transaction details' modal and removes the pairing so you can correct source data.

Last updated on Sep 02, 2026

How do I update files for an existing reconciliation?

Short Answer: Click 'Add files & update report' on the reconciliation results page to upload new files, confirm mappings via 'View format', and then re-run reconciliation. PreRequisites 1. Be on the reconciliation results page 2. Have the updated files ready Steps 1. On the reconciliation results page click 'Add files & update report'. Upload area for adding files appears or you are returned to the New reconciliation layout. 2. Upload the updated file(s) to the appropriate report card. New files are shown in the report card upload area. 3. Open 'View format' to confirm mappings are still correct after the update. Mappings aligned to the new file columns. 4. Click 'Run reconciliation' to apply the updated files. Results page updates with new match counts and totals. Troubleshooting 1. Updated files do not change results. LikelyCause: Files uploaded to the wrong report card or header/mappings mismatch. Action: Confirm the files are uploaded to the correct report card, open 'View format' to verify field mappings, correct header row if needed, and re-run reconciliation. Note: Use 'Add files & update report' when you need to refresh source data without creating a new reconciliation from scratch.

Last updated on Sep 02, 2026

How do I view the expected data format for Flipkart Sales, Settlement, or Cashback reports?

Short Answer: From the New reconciliation page click 'View format' on the report card to open the 'Expected data format' modal showing sample rows and the 'Required fields' panel. PreRequisites 1. Open the New reconciliation page 2. No upload required to view the format Steps 1. On the New reconciliation page find the report card Flipkart Sales Report, Flipkart Settlement Report, or Flipkart Cashback Report. Each report card shows an 'Upload files' area and a 'View format' link. 2. Click 'View format' for the report you want to inspect. 'Expected data format' modal opens. 3. Review the left side sample rows and the right side 'Required fields' Sheet, Header row, Date, Amount, Reference / Identifier, Records to include. You can see the exact column names and sample values used for mapping. 4. Click 'Download format' to get a template or 'Close' to exit the modal. Template starts downloading or modal closes. Troubleshooting 1. 'View format' modal shows unexpected columns or is blank. LikelyCause: You opened the wrong report's format modal or a page overlay prevented loading. Action: Close the modal and re-open the correct report's 'View format'. If blank persists, refresh the page and try again. Note: Each report modal shows the exact 'Required fields' names — use these names when mapping your file columns.

Last updated on Sep 02, 2026

What do Fully matched, Partially matched, and Unmatched mean on the summary cards?

Short Answer: Fully matched: records on Side A and Side B match with no difference. Partially matched: reference matches but amounts or totals differ. Unmatched: a record has no corresponding row on the other side. PreRequisites 1. Have run a reconciliation and be viewing the results page Steps 1. Open the reconciliation results page and read the summary cards Total, Fully matched, Partially matched, Unmatched. You see counts and amounts for each category. 2. Click the tab for 'Fully matched', 'Partially matched', or 'Unmatched' to view the transaction lists below the cards. A table of transactions in the chosen category appears. 3. For partially matched rows click to open 'Matched transaction details' and inspect the difference to decide next action. You can see which values differ and why the row is partially matched. Troubleshooting 1. Many partially matched items due to small differences. LikelyCause: TDS, rounding, fees, or credit notes causing amount differences. Action: Open match details, inspect invoice/settlement rows, correct source data or mapping, or unmatch and adjust entries, then re-run. Note: Each card includes Side A and Side B amounts and transaction counts; use the tabs to drill into details.

Last updated on Sep 02, 2026

Why are some invoice amounts negative in matched transaction details?

Short Answer: Negative 'Invoice Amount' values usually represent credit notes or refunds; the sign must be present in your source file and correctly mapped as the 'Amount'. PreRequisites 1. Open the 'Matched transaction details' modal Steps 1. Open the matched row's details to inspect the Side B 'Invoice Amount' values. You see positive and negative invoice amounts e.g., 20.0 and -20.0 listed. 2. Check the original Cashback/Sales/Settlement file to confirm whether the negative value is a credit note or refund. Source file shows matching sign for that invoice row. 3. If the sign is incorrect or missing, correct the source file or mapping Amount field and re-run the reconciliation. Amounts align and differences update after re-run. Troubleshooting 1. Totals do not cancel out though positive and negative rows are present. LikelyCause: A matching credit or debit is missing on the opposite side or the sign was lost during upload/mapping. Action: Confirm both files include the corresponding credit/debit rows with correct signs and re-run reconciliation. Note: Credit notes often appear with negative invoice amounts; ensure your 'Amount' mapping preserves the sign.

Last updated on Sep 02, 2026