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
-
Signed in to Cointab
-
CSV/XLS/XLSX Flipkart files ready Sales, Settlement, Cashback as applicable
-
You know the month to reconcile
Steps
-
Open the New reconciliation page.
Page shows report cards for Flipkart Sales Report, Flipkart Settlement Report, Flipkart Cashback Report. -
Set 'Reconciliation name' by selecting an existing name or clicking '+ New' and set 'Period' using 'Select month/year'.
Reconciliation name and Period are selected. -
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. -
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. -
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. -
Click 'Run reconciliation' top-right to run the reconciliation.
You are taken to the results page showing summary cards and match lists.
Troubleshooting
-
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. -
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'. -
'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.