Restaurant Marketplace Reconciliation

Restaurant Marketplace Reconciliation is the process of comparing restaurant marketplace orders, POS sales, settlement reports, bank entries, and accounting records to identify matched orders, missing orders, commission differences, refund differences, deduction differences, payout gaps, tax differences, and open items.

The main files are usually the POS sales report, restaurant marketplace order report, settlement report, and bank statement. Depending on the workflow, commission reports, cancellation reports, refund reports, discount reports, deduction files, tax reports, ERP exports, outlet master files, or supporting data may also be used.

This workflow can apply to platforms such as Swiggy, Zomato, DoorDash, Uber Eats, Grubhub, Deliveroo, Talabat, Careem, Foodpanda, or any other restaurant marketplace where restaurants receive order, settlement, payout, fee, refund, and deduction reports.

Yes. Cointab can show marketplace orders that do not clearly match POS sales or ERP records.

Yes. POS records that do not clearly match marketplace platform orders can be shown separately for review.

Yes. Settlement reports and bank statements can be added to trace marketplace payouts to actual bank credits.

Yes. Cointab can compare expected marketplace settlement with actual bank credit and highlight short-settled records.

Yes. Marketplace commission, service fees, delivery fees, payment fees, packaging fees, advertising fees, marketing fees, subscription fees, and other commercial deductions can be compared where data is available.

Yes. Customer cancellations, restaurant cancellations, platform cancellations, refunds, complaint refunds, partial refunds, chargebacks, reversals, and adjustment entries can be included.

Yes. Restaurant-funded discounts, platform-funded discounts, coupons, offers, free delivery subsidies, campaign deductions, and loyalty-related adjustments can be compared.

Yes. Complaint deductions, missing item claims, wrong item claims, quality issue claims, cancellation penalties, service-level penalties, dispute adjustments, and other marketplace deductions can be flagged for review.

Yes. GST, VAT, sales tax, service tax, TCS, TDS, taxable value, tax collected, tax deducted, and tax reversals can be compared where data is available.

Yes. Cointab can support outlet-level, city-level, brand-level, franchisee-level, platform-level, entity-level, bank-level, settlement-level, and accounting-level views where the required data is available.

Yes. Once this template is selected and the workflow is used, the same setup can be reused for daily, weekly, monthly, business-day, outlet-wise, platform-wise, payout-cycle, settlement-cycle, or custom reconciliation periods.

Yes. Once configured, Cointab can receive or pull required reports through email, SFTP, or APIs where available, run reconciliation automatically, and push output back to downstream systems.

Cointab validates uploaded files against the expected format. If the file format is different, users can correct the file, update the workflow, or create a custom reconciliation.

Yes. AI can help match difficult open records, review messy order references, analyze platform deductions, create derived columns, and suggest possible reasons and next actions.

Yes. Users can manually match records that the system and AI could not confidently match, and undo manual matches if needed.

Yes. Users can download Excel reports with fully matched, partially matched, refunded, cancelled, deducted, short-settled, unmatched, skipped, order-level, outlet-level, platform-level, settlement-level, bank-level, and accounting-level details.