JioMart Marketplace Reconciliation Automation
For JioMart sellers, reconciliation is the process of comparing internal sales and order records with JioMart settlement, invoice, fee, return, and payment data. The goal is to confirm what was sold, what was deducted, what was settled, and what is still open.
Manual spreadsheet checks can work for small volumes, but they become slow and difficult to audit as order counts, deductions, and settlement files increase. Cointab gives finance teams a structured way to upload files, map fields once, run reconciliation, review exceptions, and download audit-ready reports.
What JioMart marketplace reconciliation covers
A JioMart reconciliation workflow usually compares the business's source records with marketplace records and supporting payment data.
Side A and Side B in a JioMart workflow
| Reconciliation side | Typical records | Purpose |
|---|---|---|
| Side A - Your records | Sales report, order report, books, ERP export, internal settlement working | Shows what your business expects to be correct |
| Side B - JioMart and related external records | JioMart invoice report, service invoice, settlement report, return report, bank statement | Shows what the marketplace or bank recorded |
This model helps finance teams separate internal expectations from external outcomes. Once both sides are loaded, the reconciliation engine can compare order IDs, invoice numbers, payment references, settlement IDs, amounts, and other identifiers.
Why JioMart reconciliation matters
Marketplace reconciliation is not only about matching totals. It also helps teams understand why the numbers differ.
Common issues include:
- settlement amounts that do not align with expected sales values
- service fees, commissions, or deductions that need review
- returns that affect the final payable amount
- bank receipts that do not map cleanly to settlement records
- missing or delayed settlement entries
- partial matches where identifiers align but the amount differs
- rows that should be excluded because the source file is incomplete or invalid
When these differences are handled manually, teams often rely on repetitive filtering, VLOOKUPs, and copy-paste checks. Cointab replaces that approach with a reusable reconciliation workflow built for finance review.
How Cointab handles JioMart reconciliation
Cointab follows a simple workflow that finance teams can reuse every period:
- Upload the required reports on Side A and Side B.
- Map the required fields such as date, amount, and reference columns.
- Optionally upload supporting data for lookup, enrichment, or calculation.
- Create derived columns if a clean identifier or calculated amount is needed.
- Run reconciliation manually or on a schedule.
- Review matched, partially matched, unmatched, and skipped records.
- Download the Excel report for internal review or audit.
This approach is useful for recurring JioMart workflows because the same setup can be reused for future periods instead of rebuilt every time.
Reports commonly used in JioMart reconciliation
Different businesses may receive different marketplace files, but the reconciliation pattern is similar.
Internal and marketplace records that are often compared
- Internal sales report vs JioMart settlement report
- Internal order report vs JioMart invoice report
- Marketplace deductions and fees vs internal books
- Return records vs settlement adjustments
- JioMart payout or settlement entries vs bank statement
What each report helps verify
| Record type | What finance teams verify |
|---|---|
| Sales or order report | Order-level value, reference IDs, item totals, and expected revenue |
| Settlement report | Amount actually settled by the marketplace |
| Service invoice or fee report | Marketplace deductions, commission, or service charges |
| Return report | Returned orders and reversal impact |
| Bank statement | Whether the settled amount reached the bank account |
Supporting data can also be used when a finance team needs to enrich missing information before matching, such as product mapping, customer data, or reference lookups.
Matching logic for marketplace reconciliation
Cointab uses structured reconciliation logic instead of simple row-by-row spreadsheet comparison. That is important when marketplace records are not one-to-one.
The engine can support:
- one-to-one matching
- one-to-many matching
- many-to-one matching
- many-to-many matching
- net-to-net matching
- contra matching
- partial matching
This is useful when one JioMart settlement line reflects multiple orders, or when a single order is split across fees, returns, and payout adjustments.
The platform also supports comparison logic such as:
- equals
- contains
- similar
- equals subset
- contains subset
- similar subset
That makes it easier to reconcile records even when partner descriptions, identifiers, or reference formats are not identical.
How exceptions are handled
The report separates transactions into clear status buckets so finance teams can focus on what needs review.
Fully matched
Fully matched records are transactions where the expected identifier and amount align according to the reconciliation logic.
Partially matched
Partially matched records are related transactions where identifiers match, but the amount differs. This often points to deductions, returns, fees, or rounding differences that need review.
Unmatched
Unmatched records exist on one side but do not find a reliable match on the other side. These may indicate a missing payout, a missing order entry, or a settlement file issue.
Skipped
Skipped records are rows that were excluded from reconciliation because of missing data, invalid values, duplicates, or a file format issue.
Showing skipped rows is important because finance teams need to know what was ignored and why.
AI assistance for difficult open items
After structured matching is complete, Cointab can use AI to help analyze open transactions where simple rules are not enough.
AI can help with:
- slightly inconsistent descriptions
- missing or partial identifiers
- complex grouping scenarios
- unclear reference values
- possible reasons for an open item
- suggested next actions for review
The output stays audit-friendly. If evidence is weak, the item remains unmatched rather than being forced into a low-confidence match.
Manual match and report refresh
There are always one-off cases in marketplace reconciliation where human review is needed.
Cointab provides manual match support for transactions that the system or AI could not confidently resolve. This is useful when the user knows the business context and the totals still align.
If a report was missed, the user can upload the missing file under the same reconciliation and refresh the output. That is especially useful when JioMart reports arrive later than expected or a settlement file is delivered after the first reconciliation run.
Reconciliation output for finance review
Once the run is complete, the report dashboard shows transaction-level and summary-level views that help finance teams close the loop faster.
Typical output includes:
- total summary
- fully matched summary
- partially matched summary
- unmatched summary
- skipped summary
- detailed transaction tables
- filters for deeper review
- downloadable Excel report
This makes it easier to investigate marketplace fees, settlement differences, returns, and open items without rebuilding the analysis in Excel.
Reusable automation for recurring JioMart workflows
JioMart reconciliation is usually not a one-time task. Most finance teams repeat it every day, week, or month.
Once the workflow is configured, Cointab can support recurring operations through:
- manual upload for ad hoc review
- email-based data receipt
- SFTP-based file transfer
- API-based data input
- scheduled reconciliation runs
- output delivery back to internal systems through email, SFTP, or API
That means the same reconciliation setup can support ongoing finance operations instead of just a monthly spreadsheet exercise.
Benefits for finance and marketplace teams
A structured JioMart reconciliation workflow helps teams:
- reduce time spent on repetitive file comparisons
- identify settlement differences faster
- review fees, returns, and deductions in one place
- keep matched and unmatched items separate
- maintain a clearer audit trail
- reuse the same setup across periods
- reduce dependency on manual Excel formulas
- make exception handling more consistent across the team
When JioMart reconciliation is most useful
This workflow is especially relevant when a business:
- sells at meaningful volume on JioMart
- receives multiple reports for sales, settlements, and returns
- needs to match marketplace data with books or bank records
- reviews deductions and open items during month-end close
- wants a reusable process instead of rebuilding spreadsheets each cycle
JioMart marketplace reconciliation is ultimately about control, clarity, and repeatability. Finance teams need to know what matched, what did not match, and what needs action. Cointab is designed to make that process structured, reviewable, and reusable.
