Popular reconciliation template
Sales vs Instamart Reconciliation
Reconcile internal sales records with Instamart reports to match orders, SKUs, delivered quantities, cancellations, returns, refunds, commissions, platform fees, discounts, deductions, taxes, settlements, bank credits, and open items in one structured workflow.
View demo reportReconcile internal sales with Instamart reports
Instamart reports can include order-level, SKU-level, payout-level, return, refund, fee, discount, deduction, and tax information that may not directly match internal sales or ERP records. Cointab helps bring these records into one clear reconciliation report.
The Sales vs Instamart Reconciliation template helps finance, marketplace operations, eCommerce, retail, D2C, and accounting teams compare internal sales records with Instamart reports.
This helps teams answer questions such as:
- Which internal sales orders are correctly present in Instamart reports?
- Which Instamart orders are missing from internal sales or ERP records?
- Which orders, SKUs, invoices, quantities, and values differ between internal records and Instamart?
- Which Instamart orders were cancelled, returned, refunded, short-delivered, adjusted, or deducted?
- Which commissions, platform fees, service fees, fulfilment fees, logistics fees, advertising fees, penalties, or claims explain the payout difference?
- Which Instamart discounts, coupons, promotional deductions, seller-funded discounts, or platform-funded discounts need review?
- Which Instamart settlements were received in the bank?
- Which Instamart payouts were short-paid, delayed, overpaid, reversed, or adjusted?
- Which items need Instamart follow-up, ERP correction, marketplace operations review, finance review, or accounting correction?
This template is useful for D2C brands, FMCG brands, grocery sellers, retail brands, marketplace sellers, Instamart sellers, quick commerce teams, eCommerce finance teams, marketplace operations teams, controllers, CFOs, and accounting firms that need a repeatable Sales vs Instamart reconciliation process.
Required files for this template
Cointab's ready-made workflow is designed around common internal sales reports, Instamart order reports, Instamart settlement reports, payout reports, commission files, return reports, refund files, deduction reports, bank statements, ERP exports, and supporting eCommerce finance data.
| Data source | Example records |
|---|---|
| Internal Sales / Order Report | Used as the internal source-of-truth report containing order IDs, invoice numbers, customer IDs, SKU details, product names, order dates, dispatch dates, delivered quantities, gross sales, discounts, taxes, net sales, cancellation status, return status, and accounting status. |
| Instamart Order Report | Used as the Instamart-side order report containing Instamart order IDs, item IDs, SKU codes, product details, order dates, delivery status, accepted quantities, cancelled quantities, returned quantities, item value, discounts, tax values, and order status. |
| Instamart Settlement / Payout Report | Used to compare settlement IDs, payout dates, gross sales, commissions, platform fees, discounts, penalties, refunds, claims, taxes, deductions, net settlement amounts, and payout status. |
| Instamart Commission / Fee Report | Optional, but useful where Instamart commission, platform fees, marketplace fees, service fees, fulfilment fees, logistics fees, advertising fees, payment fees, packaging fees, or subscription fees need to be reconciled. |
| Instamart Returns / Refunds Report | Optional, but useful where customer returns, refund adjustments, quality issues, damaged goods, cancelled orders, return-to-origin, expired items, short delivery, or Instamart-side refund claims affect settlement. |
| Instamart Deductions / Claims Report | Optional, but useful where Instamart penalties, short delivery claims, inventory mismatch claims, service-level penalties, damage deductions, expired stock deductions, promotional deductions, and dispute adjustments need to be reviewed. |
| Inventory / Dispatch Report | Optional, but useful where dispatched quantity, delivered quantity, accepted quantity, rejected quantity, returned quantity, and stock movement need to be compared with Instamart records. |
| Tax Report | Optional, but useful where GST, VAT, TCS, TDS, tax collected, tax deducted, taxable value, tax reversal, and invoice-level tax values need to be compared. |
| Bank Statement | Optional, but useful where Instamart payouts need to be compared with actual bank statement credits. |
| ERP / Accounting Export | Optional, but useful if sales, customer receivables, Instamart receivables, commission expenses, deductions, tax entries, refunds, settlements, bank entries, and accounting postings are maintained in SAP, Oracle, NetSuite, Microsoft Dynamics, Tally, Zoho Books, QuickBooks, or another accounting system. |
| Supporting Data | Optional supporting files can be used for order mapping, SKU mapping, Instamart mapping, store mapping, warehouse mapping, invoice mapping, settlement mapping, tax mapping, GL mapping, entity mapping, or other enrichment. |
What Cointab matches in Sales vs Instamart reconciliation
Cointab compares internal sales records with Instamart reports across orders, SKUs, quantities, values, commissions, discounts, refunds, returns, deductions, taxes, payouts, bank credits, and optional accounting data.
Internal sales and Instamart orders
Match internal sales orders with Instamart order records.
Order and invoice references
Compare internal order IDs, Instamart order IDs, invoice numbers, item IDs, SKU codes, product IDs, store IDs, warehouse IDs, shipment references, and settlement references.
SKU and quantity details
Compare SKU codes, product names, ordered quantity, invoiced quantity, dispatched quantity, accepted quantity, delivered quantity, cancelled quantity, returned quantity, and adjusted quantity.
Sales values
Compare gross sales, item value, net sales, taxable value, discount amount, tax amount, customer paid amount, Instamart reported value, and expected receivable.
Instamart commissions and fees
Match commission, platform fee, service fee, fulfilment fee, logistics fee, payment fee, advertising fee, packaging fee, and other Instamart commercial deductions.
Discounts and promotions
Compare seller-funded discounts, Instamart-funded discounts, coupon discounts, promotion deductions, marketing support, freebie adjustments, and campaign-level discounts.
Returns, refunds, and cancellations
Match customer returns, Instamart refunds, cancellation reversals, refund adjustments, RTO, damaged goods, expired stock, short-delivery claims, and quantity differences.
Deductions and penalties
Compare penalties, claims, short delivery deductions, service-level deductions, damage deductions, inventory mismatch deductions, dispute adjustments, and other Instamart charges.
Settlement and bank credits
If settlement and bank files are included, compare Instamart payout values with actual bank statement credits.
Accounting postings
If ERP or accounting data is included, compare sales revenue, Instamart receivables, commissions, deductions, refunds, tax entries, bank receipts, and journal postings.
Common Sales vs Instamart reconciliation exceptions
Cointab helps finance teams focus on Instamart differences instead of manually reviewing every order, SKU, commission, refund, return, deduction, and payout line.
Internal sale not found in Instamart report
An internal sale or invoice exists, but no matching Instamart order is found.
Instamart order not found internally
A Instamart order appears without a matching internal sales or ERP record.
Order amount mismatch
The order reference matches, but internal sales value and Instamart-reported order value differ.
SKU mismatch
Order-level references match, but SKU code, product name, item ID, or product mapping differs.
Quantity mismatch
Internal quantity, Instamart quantity, delivered quantity, accepted quantity, returned quantity, or cancelled quantity does not match.
Cancellation mismatch
An order is cancelled on one side but shown as delivered, invoiced, payable, or settled on the other side.
Return mismatch
A return or refund appears in the Instamart report but is missing or recorded differently internally.
Refund mismatch
A customer refund, Instamart refund adjustment, cancellation refund, or settlement refund differs across reports.
Commission mismatch
Instamart commission, service fee, fulfilment fee, logistics fee, payment fee, or commercial fee differs from expected values.
Discount mismatch
Seller-funded discount, Instamart-funded discount, coupon discount, promotional deduction, or campaign support amount does not match.
Deduction mismatch
Instamart deductions, short delivery claims, damaged goods deductions, service-level penalties, expired inventory charges, or dispute adjustments require review.
Tax mismatch
GST, VAT, TCS, TDS, taxable value, tax collected, tax deducted, or tax reversal differs across internal and Instamart reports.
Settlement mismatch
Expected Instamart receivable does not match net settlement after commissions, discounts, refunds, taxes, penalties, and deductions.
Bank credit mismatch
The Instamart settlement report shows payout, but the actual bank credit is missing, delayed, short, excess, or posted in another period.
Duplicate order
The same order ID, Instamart order ID, invoice number, SKU, customer, amount, or settlement line appears more than once.
Wrong store or platform allocation
An order, refund, deduction, payout, SKU, or invoice is mapped to the wrong platform, store, city, warehouse, entity, GL account, or business unit.
Missing or unclear reference
Order ID, Instamart order ID, invoice number, SKU, item ID, settlement ID, payout reference, UTR, or narration is missing, incomplete, or inconsistent.
Skipped record
A row cannot be reconciled because required data is missing, invalid, duplicate, incomplete, or unusable.
How this ready-made reconciliation works
Cointab pre-configures the workflow so your team does not need to rebuild the Sales vs Instamart reconciliation setup every period.
Select the template
Choose Sales vs Instamart from popular reconciliations.
Select the period
Choose the day, week, month, quarter, order cycle, payout cycle, settlement cycle, financial year, lifetime period, or custom period you want to reconcile.
Upload internal sales and Instamart reports
Upload the internal sales report, Instamart order report, and any required settlement, payout, commission, return, refund, deduction, inventory, tax, bank, ERP, or supporting files.
Validate file format
Cointab checks whether the uploaded files match the expected structure and highlights missing or incorrect columns.
Run reconciliation
Cointab applies predefined data preparation and matching logic for sales, Instamart order, SKU, settlement, commission, refund, return, deduction, tax, bank, and accounting data.
Review output
View fully matched, partially matched, unmatched, refunded, returned, deducted, and skipped records.
Download or automate
Download the Excel report, or automate future data input and output through email, SFTP, or APIs.
Structured matching first, AI assistance for difficult cases
Cointab applies structured reconciliation logic first, then uses AI to help with difficult open records where fixed rules are not enough.
Structured matching
Structured matching can use:
Matching scenarios
One-to-one
One internal sales order matches one Instamart order.
One-to-many
One internal order maps to multiple Instamart item lines, SKU lines, fee lines, refund lines, return lines, deduction lines, tax lines, or settlement entries.
Many-to-one
Multiple internal orders are grouped into one Instamart payout, settlement batch, bank credit, or accounting entry.
Many-to-many
Multiple internal sales records, Instamart order records, commission lines, return lines, refund lines, deduction lines, settlement entries, and bank entries are grouped and compared together.
Partial matching
Identifiers match, but sales value, quantity, discount, tax, commission, refund, deduction, settlement value, or status differs.
SKU-level matching
Order-level and SKU-level quantities, values, discounts, returns, refunds, and taxes are compared together.
Settlement-level matching
Orders, commissions, discounts, refunds, returns, penalties, taxes, deductions, settlement IDs, payout values, and bank credits are compared together where required.
Platform-level matching
All orders, deductions, refunds, returns, settlements, and bank credits for Instamart, a store, city, or business unit are grouped and compared.
Net and contra matching
Sales, cancellations, returns, refunds, commissions, discounts, platform fees, penalties, claims, tax deductions, settlement adjustments, and bank credits are netted where required.
AI-assisted transaction matching
After structured rules run, AI helps match difficult open transactions where:
- References are incomplete
- Order IDs are missing or formatted differently
- Instamart order IDs are embedded inside narration fields
- SKU names differ across internal and Instamart files
- Product codes are mapped differently
- One order has multiple SKU-level Instamart lines
- One settlement contains many orders and deductions
- Refunds or returns do not clearly link to original order lines
- Instamart deductions are described inconsistently
- Settlement narration is messy
- Bank narration is unclear
- Amounts require business context
- Multiple possible matches exist
AI exception analysis
For transactions that remain open, AI can help identify possible reasons such as:
AI assists matching and exception review, but Cointab keeps reconciliation transparent, reviewable, and audit-friendly.
Audit-ready Sales vs Instamart reconciliation reports
Cointab gives your team a clear report showing which internal sales, Instamart order, SKU, return, refund, deduction, settlement, bank, and accounting records matched, partially matched, remained unmatched, or were skipped.
Report categories
Fully matched
Internal sales and Instamart records where identifiers, quantities, statuses, and amounts match.
Partially matched
Records where identifiers match but sales value, SKU value, quantity, discount, tax, commission, refund, deduction, or settlement amount differs.
Unmatched in internal sales
Instamart orders or settlement entries that do not clearly match internal sales records.
Unmatched in Instamart report
Internal sales records that do not clearly match Instamart records.
SKU and quantity differences
Records where SKU mapping, item quantity, accepted quantity, delivered quantity, returned quantity, or cancelled quantity requires review.
Commission and fee differences
Records where Instamart commission, service fee, fulfilment fee, logistics fee, payment fee, advertising fee, or other commercial fee requires review.
Refund and return differences
Records where customer refunds, returns, cancellation reversals, refund adjustments, or return quantities require review.
Discount differences
Records where seller-funded discount, Instamart-funded discount, coupons, promotions, or campaign deductions require review.
Deduction and claim differences
Records where penalties, short delivery claims, damage claims, inventory mismatch deductions, expired stock charges, or dispute adjustments require review.
Tax differences
Records where GST, VAT, TCS, TDS, taxable value, tax collected, tax deducted, or tax reversal requires review.
Settlement and bank differences
Records where settlement amount, payout date, settlement ID, UTR, bank credit, or payout status requires review.
Accounting differences
Records where sales revenue, Instamart receivable, commission expense, deduction expense, tax entry, refund entry, bank posting, or journal entry requires review.
Skipped
Records excluded due to missing, invalid, duplicate, incomplete, or unusable data.
Report capabilities
- Summary cards
- Order-level filters
- SKU-level filters
- Instamart store filters
- City-level filters
- Settlement-level filters
- Refund and return filters
- Deduction filters
- Difference amounts
- Instamart payout view
- Matched transaction drill-down
- Manual match
- Undo manual match
- Excel export
- Audit-friendly output
Automate recurring Sales vs Instamart reconciliation
Once this workflow is stable, Cointab can automate file input, reconciliation runs, and output delivery.
Bring data into Cointab
Data can be received or pulled through:
Run automatically
Schedule reconciliation:
Push output back
Send reconciliation output to:
- Matched sales orders
- Matched Instamart orders
- Matched SKU lines
- Matched settlement records
- Matched bank credits
- Unmatched internal sales records
- Unmatched Instamart orders
- Order amount differences
- SKU quantity differences
- Commission differences
- Discount differences
- Return differences
- Refund differences
- Deduction differences
- Claim differences
- Tax differences
- Settlement differences
- Bank credit differences
- Wrong store allocation records
- Timing differences
- Open items
- Suggested actions
- Excel reconciliation report
- Structured API output
View a Sales vs Instamart demo report
See how Cointab presents Sales vs Instamart output with matched, partially matched, refunded, returned, deducted, unmatched, and skipped records.
Sales vs Instamart Demo
Explore a sample report showing internal sales, Instamart orders, SKU lines, commissions, discounts, returns, refunds, deductions, taxes, settlement payouts, bank credits, and open items.
View demo reportExplore related quick commerce and marketplace reconciliations
Cointab supports other quick commerce, marketplace, sales, payment gateway, bank, refund, return, books, ERP, and finance reconciliation workflows.
Sales vs Quick Commerce Platform
Reconcile internal sales records with quick commerce platform reports across orders, payouts, commissions, discounts, refunds, returns, deductions, and settlements.
View templateBook vs Swiggy Quick Commerce Reconciliation
Reconcile books or ERP records with Swiggy quick commerce reports across sales, payouts, deductions, refunds, returns, taxes, and bank credits.
View templateSales vs Blinkit
Reconcile internal sales records with Blinkit reports across orders, SKUs, commissions, discounts, returns, refunds, deductions, and settlements.
View templateSales vs Zepto
Reconcile internal sales records with Zepto reports across orders, SKUs, commissions, discounts, returns, refunds, deductions, and settlements.
View templateMarketplace Sales vs Settlement
Reconcile marketplace sales with settlement reports across commissions, fees, returns, refunds, deductions, and payouts.
View templateBank Statement vs Books
Compare bank statement entries with accounting or books records.
View templateBuilt for teams reconciling sales with Instamart reports
This template is useful for teams that regularly reconcile internal sales, Instamart orders, SKU quantities, commissions, discounts, returns, refunds, deductions, settlement payouts, bank credits, and accounting records.
D2C brands
For D2C brands selling on Instamart and reconciling orders, commissions, discounts, refunds, returns, deductions, and payouts.
FMCG brands
For FMCG businesses reconciling SKU-level Instamart sales, quantity movement, platform deductions, promotions, claims, taxes, and settlements.
Grocery brands
For grocery and food brands reconciling Instamart sales, returns, expired stock deductions, short delivery claims, promotions, and payouts.
Retail brands
For retail brands reconciling Instamart sales with ERP records, inventory reports, settlement files, and accounting ledgers.
Marketplace sellers
For sellers managing high-volume Instamart orders and needing clear payout, deduction, return, and refund visibility.
eCommerce finance teams
For teams preparing recurring Instamart reconciliation reports for daily review, month-end close, reporting, and audit.
Marketplace operations teams
For teams reviewing Instamart deductions, claim disputes, SKU mismatches, return differences, and settlement follow-ups.
Inventory teams
For teams reviewing dispatched quantity, accepted quantity, returned quantity, stock deductions, and Instamart-reported quantity differences.
Accounting teams
For teams reconciling sales revenue, Instamart receivables, commission expenses, deductions, refunds, tax entries, bank credits, and journal postings.
Controllers
For controllers who need visibility into settlement gaps, Instamart deductions, refund differences, tax mismatches, SKU-level issues, and bank posting gaps.
CFOs
For finance leaders who want stronger control over Instamart revenue, platform receivables, deduction leakage, payout accuracy, accounting accuracy, and audit readiness.
Accounting firms
For CA, CPA, or outsourced accounting teams handling eCommerce, D2C, FMCG, retail, marketplace, Instamart, and quick commerce reconciliation for multiple clients.
Trusted by teams handling Instamart reconciliation
Cointab is used by finance and operations teams that reconcile high-volume, multi-source transaction data across sales systems, Instamart, quick commerce platforms, marketplaces, payment gateways, banks, inventory systems, books, ERP systems, and internal systems.
“We have worked on many softwares but we love the ease of using cointab. The staff and support is very instant. They are approachable, proficient and patient. Team is very cooperative with the customisations. The experience of using cointab was nice.”
Sales vs Instamart FAQs
Start Sales vs Instamart Reconciliation
Use Cointab's ready-made Sales vs Instamart reconciliation workflow to match orders, SKUs, commissions, discounts, returns, refunds, deductions, taxes, payouts, bank credits, accounting postings, review exceptions, and export audit-ready reports.
View demo reportReady-made workflow · Reusable every period · Manual upload and automation supported