Sales vs Razorpay
Category: Payment Gateway Reconciliation
Output: Fully matched, partially matched, unmatched, and skipped records
Popular reconciliation templates
Ready-made reconciliation templates for finance teams
Start faster with pre-built reconciliation workflows for sales, payment gateways, marketplaces, COD partners, banks, books, vendors, and partner reports.
View demo reportUsed by teams with recurring reconciliation workflows
Cointab helps finance teams across eCommerce, retail, education, travel, logistics, consumer brands, and payment-heavy businesses reconcile high-volume data from multiple systems.
What are popular reconciliations?
Popular reconciliations are ready-made workflows created by Cointab for common reconciliation use cases.
Many companies reconcile the same types of external reports. For example, marketplace reports, payment gateway reports, bank statements, COD partner reports, and settlement reports often follow standard formats.
Cointab can pre-build these reconciliations so users do not need to configure everything from scratch.
With a popular reconciliation, Cointab already defines:
- Required file formats
- Required reports
- Data preparation logic
- Amount and identifier fields
- Matching rules
- Output report structure
Users only need to:
- Select the reconciliation
- Select the period
- Upload the required files
- Run reconciliation
- Review the report
Popular reconciliations are best for standard partner reports. For business-specific workflows, users can create custom reconciliations.
Sales vs Razorpay
Each popular reconciliation template includes the reports, matching logic, and output structure your team needs.
View template
Payment gateway reconciliation templates
Match sales, payments, refunds, fees, settlements, and payout reports from PSPs and payment gateways.
Payment Gateway Reconciliation
Sales vs Razorpay
Reconcile internal sales with Razorpay payments, refunds, settlements, and fees.
Output: Fully matched, partially matched, unmatched, and skipped records
View templatePayment Gateway Reconciliation
Sales vs Cashfree
Match order records with Cashfree payment and settlement reports.
Output: Fully matched, partially matched, unmatched, and skipped records
View templatePayment Gateway Reconciliation
Sales vs Stripe
Reconcile sales, payments, refunds, fees, and payouts from Stripe.
Output: Fully matched, partially matched, unmatched, and skipped records
View templatePayment Gateway Reconciliation
Sales vs PayU
Compare order records with PayU transaction, refund, and settlement reports.
Output: Fully matched, partially matched, unmatched, and skipped records
View templatePayment Gateway Reconciliation
Sales vs PayPal
Reconcile internal sales with PayPal payments, refunds, fees, disputes, settlements, and payouts.
Output: Fully matched, partially matched, unmatched, and skipped records
View templatePayment Gateway Reconciliation
SAP vs PSP Reconciliation
Best for matching SAP sales, receivables, and ledger records with PSP transactions, refunds, chargebacks, fees, settlements, and payouts.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateSubscription and recurring revenue reconciliation templates
Match subscription billing, renewals, payment gateway collections, refunds, and settlements.
Subscription Billing vs Payment Gateway
Category: Subscription Reconciliation
Required reports: Subscription billing report, Payment gateway transaction report, Refund and chargeback report, Settlement or payout report
Output: Fully matched, partially matched, unmatched, and skipped records
Subscription Reconciliation
Subscription Invoice vs Books
Best for comparing subscription invoices, revenue entries, receivables, taxes, and accounting records.
Required reports: Subscription invoice report, Books or ledger report, Credit note report, Accounts receivable report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateSubscription Reconciliation
Subscription Refund Reconciliation
Best for matching refunds, reversals, customer credits, chargebacks, and accounting entries.
Required reports: Subscription refund report, Payment gateway refund report, Chargeback or dispute report, Credit note report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateSubscription Reconciliation
Subscription Revenue vs Deferred Revenue
Reconcile billed revenue against deferred and recognized revenue records.
Required reports: Subscription billing report, Revenue recognition report, Deferred revenue ledger, General ledger or ERP export
Output: Fully matched, partially matched, unmatched, and skipped records
View templateMarketplace reconciliation templates
Reconcile marketplace sales, settlements, returns, deductions, commissions, and payout reports.
Marketplace Reconciliation
Flipkart Sales vs Settlement
Reconcile Flipkart sales, settlements, returns, deductions, and payouts.
Required reports: Flipkart sales report, Flipkart settlement report, Return report, Fee / deduction report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateMarketplace Reconciliation
Myntra Sales vs Payment
Match Myntra sales, payments, returns, and settlement records.
Required reports: Myntra sales report, Myntra payment report, Return / reverse shipping report, if applicable
Output: Fully matched, partially matched, unmatched, and skipped records
View templateMarketplace Reconciliation
Marketplace Sales vs Settlement
A general template for reconciling marketplace sales with settlement and payout reports.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateCOD and delivery partner reconciliation templates
Match delivered COD orders with remittance reports from logistics and delivery partners.
COD Reconciliation
Sales vs Delhivery COD
Reconcile sales or order records with Delhivery COD remittance reports.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateCOD Reconciliation
Sales vs Blue Dart COD
Match delivered orders with Blue Dart COD remittance data.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateCOD Reconciliation
Sales vs Shiprocket COD
Reconcile COD orders with Shiprocket remittance and delivery reports.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateCOD Reconciliation
SAP vs COD Reconciliation
Best for matching SAP sales and receivables with COD partner remittances, AWB records, returns, RTOs, deductions, and payouts.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateLogistics reconciliation templates
Reconcile shipment records, carrier invoices, freight charges, surcharges, and logistics billing.
Shipment Report vs Carrier Invoice
Category: Logistics Reconciliation
Required reports: Shipment report, Carrier invoice, Carrier rate card, Surcharge or adjustment report
Output: Fully matched, partially matched, unmatched, and skipped records
Logistics Reconciliation
AWB Reconciliation
Best for matching AWB-level delivery, shipment, invoice, RTO, and partner records.
Required reports: Shipment report, Carrier or delivery partner report, Delivery status report, COD or settlement report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateLogistics Reconciliation
Logistics Invoice vs Rate Card
Best for comparing billed logistics charges with expected charges based on rate cards, weight slabs, zones, and service types.
Required reports: Carrier invoice, Contracted rate card, Zone or service mapping file, Surcharge matrix
Output: Fully matched, partially matched, unmatched, and skipped records
View templateBank and books reconciliation templates
Compare bank statements, accounting records, ERP data, receipts, payments, and ledgers.
Bank Statement vs Books
Category: Bank Reconciliation
Required reports: Bank statement, Books ledger, Receipt register, Payment register, ERP report
Output: Fully matched, partially matched, unmatched, and skipped records
Bank Reconciliation
Bank Statement vs Sales Receipts
Match bank credits with expected sales, collections, or receipt records.
Required reports: Bank statement, Sales receipt / collection report, Invoice report, Customer ledger
Output: Fully matched, partially matched, unmatched, and skipped records
View templateBank Reconciliation
Books vs Payment Gateway
Best for matching accounting records with payment gateway transactions, refunds, fees, and settlements.
Required reports: Books / accounting ledger, Payment gateway transaction report, Settlement / payout report, Refund report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateBank Reconciliation
Books vs Sales Register
Best for reconciling accounting sales entries with invoice, order, customer, and sales register data.
Required reports: Books / accounting ledger, Sales register
Output: Fully matched, partially matched, unmatched, and skipped records
View templateBank Reconciliation
Bank Statement vs ERP
Compare bank debits and credits with ERP receipts, payments, journals, and internal finance records.
Required reports: Bank statement, ERP bank ledger, ERP transaction export, Receipt register, Payment register
Output: Fully matched, partially matched, unmatched, and skipped records
View templateBank Reconciliation
Payment Gateway Settlement vs Bank
Match payment gateway settlements, fees, refunds, and final bank credits.
Required reports: Payment gateway settlement report, Bank statement, Payment gateway transaction report, Refund or chargeback report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateBank Reconciliation
Customer Collections vs Bank
Reconcile customer receipts, invoice collections, payment references, and bank credits.
Required reports: Customer collection report, Bank statement, Customer ledger, Invoice report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateBank Reconciliation
Vendor Payments vs Bank
Match vendor payment records with bank debits, UTRs, payment references, and accounting entries.
Required reports: Vendor payment register, Bank statement, Vendor ledger, Invoice report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateBank Reconciliation
Refunds and Reversals vs Bank
Compare refunds, reversals, chargebacks, failed payments, and bank entries.
Required reports: Refund transaction report, Reversal or failed refund report, Bank statement, Payment gateway report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateBank Reconciliation
Bank Charges Reconciliation
Review bank fees, cheque bounce charges, transaction charges, service charges, and related ledger entries.
Required reports: Bank statement, Books or ledger report, ERP export, Bank charges register
Output: Fully matched, partially matched, unmatched, and skipped records
View templateBank Reconciliation
SAP vs Bank Reconciliation
Best for matching SAP ledger, receivable, and payable records with bank credits, debits, charges, reversals, transfers, and open items.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateIntercompany and entity ledger reconciliation templates
Compare entity ledgers, intercompany accounts, related-party balances, and group company records.
Entity A Ledger vs Entity B Ledger
Category: Intercompany Reconciliation
Required reports: Entity A ledger, Entity B ledger, Intercompany invoice register, Debit note / credit note register, Journal voucher report
Output: Fully matched, partially matched, unmatched, and skipped records
Intercompany Reconciliation
Due To vs Due From Reconciliation
Best for matching intercompany receivable and payable balances across entity pairs.
Required reports: Due To ledger, Due From ledger, Intercompany invoice register, Debit note / credit note register, Journal voucher report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateIntercompany Reconciliation
Intercompany Invoice Reconciliation
Best for matching invoices raised by one entity with payables recorded by another entity.
Required reports: Intercompany invoice register, Issuing entity ledger, Receiving entity ledger, Due To / Due From ledgers, Payment / receipt report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateIntercompany Reconciliation
Intercompany Payment Reconciliation
Best for matching payments, receipts, settlements, and bank references between group entities.
Required reports: Entity A receivable or payable report, Entity B receivable or payable report, Intercompany payment report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateVendor and customer reconciliation templates
Match ledgers, statements, invoices, payments, credit notes, debit notes, and balances.
Vendor Reconciliation
Vendor Ledger vs Vendor Statement
Compare your vendor ledger with the vendor's statement.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateVendor Reconciliation
Books vs Vendor Statement
Match accounting records with vendor invoices, payments, debit notes, credit notes, and balances.
Required reports: Books vendor ledger, Vendor statement, Payment register, Invoice report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateVendor Reconciliation
Purchase Register vs Vendor Statement
Reconcile purchase invoices, tax amounts, vendor records, and statement balances.
Required reports: Purchase register, Vendor statement, Payment register, Tax report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateVendor Reconciliation
SAP vs Vendor
Best for reconciling SAP vendor ledger, AP, invoice, and payment records with vendor statements, debit notes, credit notes, and balances.
Required reports: SAP vendor ledger or AP report, Vendor statement, Invoice or payment report, Debit note or credit note report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateVendor Reconciliation
Vendor Payment Reconciliation
Match vendor payments from books or bank records with vendor statement entries.
Required reports: Vendor payment register, Vendor ledger, Invoice report, Bank statement
Output: Fully matched, partially matched, unmatched, and skipped records
View templateCustomer Reconciliation
Customer Ledger vs Customer Statement
Match customer ledger records with customer statements, payments, and credit notes.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateCustomer Reconciliation
Books vs Customer Statement
Match accounting records with customer invoices, receipts, credit notes, debit notes, deductions, and balances.
Required reports: Books customer ledger, Customer statement, Receipt register, Invoice report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateCustomer Reconciliation
Customer Payment Reconciliation
Best for matching customer payments from books, banks, payment gateways, or collection reports.
Required reports: Customer payment / receipt report, Invoice report, Customer ledger, Bank statement
Output: Fully matched, partially matched, unmatched, and skipped records
View templateCustomer Reconciliation
Invoice vs Receipt Reconciliation
Best for matching invoices raised with payments received from customers.
Required reports: Invoice report, Receipt register
Output: Fully matched, partially matched, unmatched, and skipped records
View templateeCommerce reconciliation templates
Bring together sales, PSP, marketplace, COD, returns, refunds, and settlement reports.
eCommerce Reconciliation
Website Sales vs Payment Gateway
Match website or app orders with payment gateway transactions and settlements.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateeCommerce Reconciliation
Sales vs PG vs Bank
Match sales with payment gateway records and final bank credits.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateeCommerce Reconciliation
Sales vs Returns vs Refunds
Reconcile sales, return records, and refund transactions.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateeCommerce Reconciliation
Marketplace Sales vs Settlement + Returns
Reconcile marketplace sales, returns, deductions, and settlement payments together.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateeCommerce Reconciliation
Shopify vs COD Reconciliation
Best for matching Shopify COD orders with delivery partner remittance, AWB, return, RTO, deduction, and bank reports.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateeCommerce Reconciliation
Shopify vs PSP Reconciliation
Best for matching Shopify orders with PSP payments, refunds, fees, disputes, settlements, and payouts.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateQuick commerce reconciliation templates
Reconcile quick commerce orders, settlements, commissions, discounts, returns, refunds, deductions, and bank credits.
Sales vs Quick Commerce Platform
Category: Quick Commerce Reconciliation
Required reports: Internal sales / order report, Quick commerce platform order report, Quick commerce settlement / payout report, Commission / fee report
Output: Fully matched, partially matched, unmatched, and skipped records
Quick Commerce Reconciliation
Sales vs Blinkit
Best for reconciling internal sales with Blinkit order, commission, deduction, settlement, and payout reports.
Required reports: Internal sales / order report, Blinkit order report, Blinkit settlement / payout report, Blinkit commission / fee report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateQuick Commerce Reconciliation
Sales vs Zepto
Best for matching ERP sales with Zepto order, refund, deduction, inventory adjustment, and settlement reports.
Required reports: Internal sales / order report, Zepto order report, Zepto settlement / payout report, Zepto commission / fee report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateQuick Commerce Reconciliation
Sales vs Instamart
Best for reconciling internal records with Instamart order, commission, refund, adjustment, and settlement reports.
Required reports: Internal sales / order report, Instamart order report, Instamart settlement / payout report, Instamart commission / fee report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateQuick Commerce Reconciliation
Quick Commerce Settlement vs Bank
Best for matching quick commerce platform settlements, deductions, fees, and final bank credits.
Required reports: Quick commerce settlement / payout report, Bank statement, Commission / fee report, Returns / refunds report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateQuick Commerce Reconciliation
Quick Commerce Refund and Return Reconciliation
Best for comparing internal refund, return, and claim expectations with platform refund and adjustment records.
Required reports: Quick commerce return report, Quick commerce refund report, Internal sales / order report, Quick commerce settlement / payout report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateQuick Commerce Reconciliation
Quick Commerce Commission and Deduction Reconciliation
Best for reviewing platform commissions, service fees, logistics charges, discounts, taxes, inventory deductions, and other adjustments.
Required reports: Quick commerce commission report, Quick commerce deduction report, Quick commerce settlement / payout report, Internal sales / order report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateQuick Commerce Reconciliation
Books vs Blinkit Quick Commerce Reconciliation
Best for matching books and ERP records with Blinkit sales, settlements, deductions, discounts, returns, and bank receipts.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateQuick Commerce Reconciliation
Books vs Swiggy Quick Commerce Reconciliation
Best for matching books and ERP records with Swiggy sales, settlements, deductions, discounts, returns, and bank receipts.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateQuick Commerce Reconciliation
Books vs Zepto Quick Commerce Reconciliation
Best for matching books and ERP records with Zepto sales, settlements, deductions, discounts, returns, and bank receipts.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateEducation and fee reconciliation templates
Reconcile student fee collections, payment gateway transactions, refunds, settlements, and education finance records.
Fee Collection vs Payment Gateway
Category: Education Reconciliation
Required reports: Fee collection report, Payment gateway transaction report, Settlement / payout report, Refund report
Output: Fully matched, partially matched, unmatched, and skipped records
Education Reconciliation
Fee Collection vs Bank
Best for comparing student fee collections, offline deposits, gateway settlements, and final bank credits.
Required reports: Fee collection report, Bank statement, Receipt register, Refund report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateEducation Reconciliation
Student Ledger Reconciliation
Best for reviewing student opening balance, fee demand, paid amount, concessions, refunds, outstanding amount, and closing balance.
Required reports: Student ledger report, Fee demand report, Fee collection / receipt report, Concession / waiver report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateEducation Reconciliation
Offline Collection Reconciliation
Best for reconciling cash, cheque, DD, counter collections, campus deposits, and bank entries.
Required reports: Offline collection report, Receipt register, Bank statement, Cash deposit report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateEducation Reconciliation
Concession and Waiver Reconciliation
Best for comparing scholarships, sibling discounts, staff concessions, waivers, approvals, and accounting entries.
Required reports: Concession report, Waiver report, Student ledger, Fee demand report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateEducation Reconciliation
Refund and Reversal Reconciliation
Best for matching duplicate payment refunds, cancelled admission refunds, failed payments, reversals, and bank entries.
Required reports: Refund report, Payment gateway refund report, Bank statement, Sales return report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateEducation Reconciliation
School ERP vs Accounting Ledger
Best for comparing fee collections, receivables, concessions, refunds, and accounting ledger entries.
Required reports: School ERP fee report, School ERP receipt report, Accounting ledger export, Student ledger report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateGaming and wallet reconciliation templates
Reconcile player deposits, wallet movements, payment gateway transactions, withdrawals, settlements, and gaming finance records.
Player Deposits vs Payment Gateway
Category: Gaming Reconciliation
Required reports: Player deposit report, Payment gateway transaction report, Wallet ledger report, Settlement report
Output: Fully matched, partially matched, unmatched, and skipped records
Gaming Reconciliation
Player Wallet vs Game Rounds
Best for matching wallet debits, winnings, game entries, rake, and round-level game records.
Required reports: Player wallet ledger, Game round report, Player balance report, Bonus report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateGaming Reconciliation
Player Withdrawals vs Bank
Reconcile player withdrawal records with bank debits, payout files, failed payouts, reversals, and open items.
Required reports: Player withdrawal report, Bank statement, Wallet ledger report, Payout processor report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateGaming Reconciliation
Wallet Ledger Reconciliation
Reconcile wallet credits, debits, deposits, withdrawals, bonuses, refunds, reversals, and balances.
Required reports: Wallet ledger report, Deposit report, Withdrawal report, Game round report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateGaming Reconciliation
Withdrawals vs Payout Partner
Best for comparing approved player withdrawals with payout partner status files and bank debits.
Required reports: Withdrawal report, Payout partner transaction report, Wallet ledger report, Failed payout report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateGaming Reconciliation
Player Wallet Balance Reconciliation
Best for reviewing opening balance, deposits, winnings, losses, withdrawals, bonuses, refunds, adjustments, and closing balance.
Required reports: Player wallet balance report, Wallet ledger report, Deposit report, Withdrawal report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateGaming Reconciliation
Bonus and Promotion Reconciliation
Best for comparing issued bonuses, used credits, expired credits, reversed credits, and wallet movements.
Required reports: Bonus / promotion report, Wallet ledger report, Player bonus balance report, Game round report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateGaming Reconciliation
Rake and Commission Reconciliation
Best for reviewing platform revenue across game rounds, wallet transactions, accounting records, and settlement data.
Required reports: Rake / commission report, Game round report, Wallet ledger report, Settlement report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateLending reconciliation templates
Reconcile loan disbursements, repayments, borrower payouts, bank debits, collections, LMS records, and lending finance workflows.
Loan Disbursement vs Bank
Category: Lending Reconciliation
Required reports: Loan disbursement report, Bank statement, Loan management system export, Payout partner report
Output: Fully matched, partially matched, unmatched, and skipped records
Lending Reconciliation
Loan Disbursement vs Payout Partner
Reconcile loan disbursement records with payout partner reports across borrower payouts, failed disbursements, retries, reversals, UTRs, and fees.
Required reports: Loan disbursement report, Payout partner transaction report, Failed payout / rejection report, Retry report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateLending Reconciliation
Loan Repayment vs Bank
Best for comparing borrower repayments, collections, and bank credits.
Required reports: Loan repayment / collection report, Bank statement, Loan management system export, Payment gateway / NACH report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateLending Reconciliation
EMI Schedule vs Collections
Best for matching expected EMI schedules with actual borrower collections, part payments, and missed repayments.
Required reports: EMI schedule report, Collection report, Loan management system export, Payment gateway / NACH report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateLending Reconciliation
LMS vs Payment Gateway
Best for reconciling loan repayments collected through payment gateways with LMS records and settlement files.
Required reports: LMS repayment / collection report, Payment gateway transaction report, Payment gateway settlement report, Failed payment report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateLending Reconciliation
Loan Repayment vs Payment Gateway
Reconcile borrower repayments with payment gateway reports across successful payments, failed payments, refunds, fees, and settlement differences.
Required reports: Loan repayment / collection report, Payment gateway transaction report, Payment gateway settlement report, Failed payment report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateLending Reconciliation
LMS vs NACH
Best for matching scheduled auto-debit payments, NACH success records, bounce records, and LMS repayment status.
Required reports: LMS repayment / collection report, NACH presentation report, NACH success / debit confirmation report, NACH bounce / failure report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateLending Reconciliation
Borrower Ledger vs Accounting Ledger
Best for comparing borrower-level balances, principal, interest, charges, waivers, and closing balances with accounting records.
Required reports: Borrower ledger / loan ledger report, Accounting ledger / GL report, Repayment / collection report, Loan disbursement report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateLending Reconciliation
Co-lending Reconciliation
Best for reconciling lender and co-lender loan shares, disbursements, repayments, interest, charges, and settlements.
Required reports: Originator LMS / loan report, Co-lender loan report, Borrower ledger / loan ledger report, Co-lender share / allocation report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateTravel and booking reconciliation templates
Reconcile travel bookings, payment gateway collections, supplier statements, cancellations, refunds, OTA settlements, and bank credits.
Bookings vs Payment Gateway
Category: Travel Reconciliation
Required reports: Booking report, Payment gateway transaction report, Payment gateway settlement report, Refund report
Output: Fully matched, partially matched, unmatched, and skipped records
Travel Reconciliation
Bookings vs Supplier Statement
Best for comparing internal booking records with airline, hotel, bus, or travel supplier invoices and statements.
Required reports: Booking report, Supplier statement, Supplier invoice report, Cancellation report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateTravel Reconciliation
Cancellations vs Refunds
Best for reconciling cancelled bookings with refund approvals, payment gateway refunds, wallet credits, and bank refunds.
Required reports: Cancellation report, Refund report, Payment gateway refund report, Bank statement
Output: Fully matched, partially matched, unmatched, and skipped records
View templateTravel Reconciliation
IRCTC Reconciliation
Best for matching IRCTC bookings with payments, cancellations, refunds, commissions, settlements, and bank receipts.
Required reports: IRCTC booking report, Payment report, Settlement report, Cancellation / refund report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateTravel Reconciliation
OTA / Partner Settlement Reconciliation
Best for matching partner bookings, commissions, deductions, settlements, and payout records.
Required reports: OTA / partner settlement report, Internal booking report, Partner commission / fee report, Bank statement
Output: Fully matched, partially matched, unmatched, and skipped records
View templateTravel Reconciliation
Travel Booking and Refund Reconciliation
Best for teams that want to reconcile bookings, cancellations, refunds, payments, supplier charges, and bank credits together.
Required reports: Travel booking report, Cancellation report, Customer refund report, Supplier refund / credit report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateGift card reconciliation templates
Reconcile gift card sales, activations, redemptions, liabilities, refunds, and settlements across retail and finance systems.
Gift Card Sales vs Activation
Category: Gift Card Reconciliation
Required reports: Gift card sales report, Gift card activation report, Gift card redemption report, Refund or cancellation report
Output: Fully matched, partially matched, unmatched, and skipped records
Gift Card Reconciliation
Gift Card Redemption vs POS
Best for comparing gift card redemptions with POS or eCommerce order records.
Required reports: Gift card redemption report, POS transaction report, Refund or return report, Gift card balance report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateGift Card Reconciliation
Gift Card Balance Reconciliation
Best for reviewing opening balance, loaded value, redeemed value, refunded value, expired value, and closing balance.
Required reports: Gift card balance report, Gift card platform report, Accounting liability ledger, Redemption and adjustment report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateGift Card Reconciliation
Gift Card Liability Reconciliation
Best for matching gift card liability movements with accounting, ERP, or ledger records.
Required reports: Gift card liability report, General ledger liability account, Gift card redemption report, Gift card expiry and breakage report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateGift Card Reconciliation
Gift Card Refund and Reversal Reconciliation
Best for comparing gift card refunds, cancelled redemptions, failed transactions, reversals, and balance adjustments.
Required reports: Gift card refund report, Gift card reversal report, POS refund report, Accounting adjustment report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateGift Card Reconciliation
Gift Card Settlement vs Bank
Best for matching gift card settlements, payouts, adjustments, and final bank credits.
Required reports: Gift card settlement report, Bank statement, Gift card provider payout report, Refund and adjustment report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateGift Card Reconciliation
Retail Gift Card Reconciliation
Best for retail teams that want to reconcile store-level sales, activations, redemptions, refunds, balances, settlements, and accounting entries.
Required reports: Gift card sales report, Gift card activation report, Gift card redemption report, Gift card liability or balance report, Settlement or accounting report
Output: Fully matched, partially matched, unmatched, and skipped records
View templateGift Card Reconciliation
SAP vs Gift Card Providers
Best for reconciling SAP gift card sales, liability, redemption, and accounting records with gift card provider issuance, redemption, settlement, fee, and balance reports.
Required reports: SAP sales, ledger, or liability report, Gift card issuance report, Gift card redemption report, Settlement or payout report, Balance, fee, or refund report
Output: Fully matched, partially matched, unmatched, and skipped records
View templatePOS and restaurant reconciliation templates
Match POS sales with delivery platforms, payment processors, banks, and store-level records.
POS Reconciliation
POS vs Food Delivery Platform
Best for matching internal POS orders with food delivery platform order reports.
Output: Fully matched, partially matched, unmatched, and skipped records
View templatePOS Reconciliation
POS vs Zomato
Best for reconciling internal restaurant sales with Zomato order, deduction, settlement, and payout reports.
Output: Fully matched, partially matched, unmatched, and skipped records
View templatePOS Reconciliation
POS vs Swiggy
Best for matching POS sales with Swiggy order, commission, refund, adjustment, and settlement reports.
Output: Fully matched, partially matched, unmatched, and skipped records
View templatePOS Reconciliation
POS vs DoorDash
Reconcile POS sales with DoorDash orders, payouts, fees, and adjustments.
Output: Fully matched, partially matched, unmatched, and skipped records
View templatePOS Reconciliation
POS vs Uber Eats
Reconcile POS sales with Uber Eats reports across restaurant orders, commissions, adjustments, refunds, and settlements.
Output: Fully matched, partially matched, unmatched, and skipped records
View templatePOS Reconciliation
POS vs Grubhub
Best for reconciling POS sales with Grubhub orders, payouts, fees, and adjustments.
Output: Fully matched, partially matched, unmatched, and skipped records
View templatePOS Reconciliation
POS vs Online Ordering System
Best for matching POS sales with online ordering platforms such as Olo or internal ordering systems.
Output: Fully matched, partially matched, unmatched, and skipped records
View templatePOS Reconciliation
POS vs Payment Processor
Match store POS sales with card processor payments and settlements.
Output: Fully matched, partially matched, unmatched, and skipped records
View templatePOS Reconciliation
POS vs Bank Deposits
Compare POS expected collections with bank deposits.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateFood delivery reconciliation templates
Match food delivery platform settlements, payouts, refunds, and commissions with bank credits and restaurant records.
Food Delivery Reconciliation
Food Delivery Settlement vs Bank
Best for matching platform settlement reports with final bank credits.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateFood Delivery Reconciliation
Food Delivery Refund Reconciliation
Best for comparing internal refund expectations with platform refund and adjustment records.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateFood Delivery Reconciliation
Commission and Deduction Reconciliation
Best for reviewing platform commissions, service fees, delivery charges, discounts, taxes, and deductions.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateFood Delivery Reconciliation
Restaurant Marketplace Reconciliation
Best for teams that want to reconcile POS sales, food delivery platforms, refunds, commissions, settlements, and bank credits together.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateMore Reconciliation Templates
Explore reconciliation workflows across payments, banking, marketplaces, ERP systems, vendors, and more.
OMS & COD Reconciliation
OMS & COD Reconciliation
EasyEcom vs COD Reconciliation
Best for matching EasyEcom COD order records with delivery partner collections, remittances, RTO data, and bank reports.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateOMS & COD Reconciliation
Unicommerce vs COD Reconciliation
Best for matching Unicommerce COD orders with delivery partner remittance, AWB, return, RTO, and bank reports.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateOMS & COD Reconciliation
Vinculum vs COD Reconciliation
Best for matching Vinculum COD orders with delivery partner remittances, AWB records, returns, RTOs, deductions, and payouts.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateOMS & Marketplace Reconciliation
OMS & Marketplace Reconciliation
EasyEcom vs Amazon Reconciliation
Best for matching EasyEcom orders with Amazon sales, MTR, settlements, returns, deductions, fees, and disbursements.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateOMS & Marketplace Reconciliation
EasyEcom vs Flipkart Reconciliation
Best for matching EasyEcom orders with Flipkart sales, settlements, returns, deductions, fees, commissions, and payouts.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateOMS & Marketplace Reconciliation
EasyEcom vs Myntra Reconciliation
Best for matching EasyEcom orders with Myntra sales, payments, returns, reverse shipping, deductions, fees, and settlements.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateOMS & Marketplace Reconciliation
Unicommerce vs Amazon Reconciliation
Best for matching Unicommerce orders with Amazon sales, MTR, settlements, returns, deductions, fees, and disbursements.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateOMS & Marketplace Reconciliation
Unicommerce vs Flipkart Reconciliation
Best for matching Unicommerce orders with Flipkart sales, settlements, returns, deductions, fees, commissions, and payouts.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateOMS & Marketplace Reconciliation
Unicommerce vs Myntra Reconciliation
Best for matching Unicommerce orders with Myntra sales, payments, returns, reverse shipping, deductions, fees, and settlements.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateOMS & Marketplace Reconciliation
Vinculum vs Amazon Reconciliation
Best for matching Vinculum order and sales data with Amazon MTR, settlements, returns, deductions, fees, and disbursements.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateOMS & Marketplace Reconciliation
Vinculum vs Flipkart Reconciliation
Best for matching Vinculum order and sales data with Flipkart sales, settlements, returns, deductions, fees, and payouts.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateOMS & Marketplace Reconciliation
Vinculum vs Myntra Reconciliation
Best for matching Vinculum order and sales data with Myntra sales, payments, returns, reverse shipping, deductions, and settlements.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateOMS & Payment Reconciliation
OMS & Payment Reconciliation
EasyEcom vs Payment Gateways Reconciliation
Best for matching EasyEcom sales and order records with PSP transactions, refunds, settlements, fees, and payouts.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateOMS & Payment Reconciliation
Unicommerce vs Payment Gateways Reconciliation
Best for matching Unicommerce order data with payment gateway transactions, refunds, settlements, fees, and payouts.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateOMS & Payment Reconciliation
Vinculum vs Payment Gateways Reconciliation
Best for matching Vinculum order and sales data with payment gateway transactions, refunds, settlements, fees, and payouts.
Output: Fully matched, partially matched, unmatched, and skipped records
View templateHow popular reconciliations work
Cointab pre-configures the workflow so your team does not need to rebuild the same reconciliation every period.
01
Select a template
Choose a ready-made reconciliation such as Sales vs Payment Gateway, Amazon MTR vs Disbursement, or Bank Statement vs Books.
02
Select period
Choose the month, quarter, year, lifetime period, or custom period you want to reconcile.
03
Upload required files
Upload the files required for that template. Cointab already knows the expected report structure.
04
Run reconciliation
Cointab applies the predefined data preparation and matching logic.
05
Review report
See fully matched, partially matched, unmatched, and skipped records.
06
Download or automate
Download the Excel report, or automate future data input and output through email, SFTP, or APIs.
Once used, the same popular reconciliation can be reused for future periods without configuring everything again.
View demo reports before signing up
Explore sample reconciliation reports and see how Cointab presents matched, partially matched, unmatched, and skipped records.
Sales vs Payment Gateway
See how internal sales are matched with payment gateway transactions.
View demo reportMarketplace Sales vs Settlement
Review settlement differences, returns, deductions, and open items.
View demo reportCOD Partner Reconciliation
Match order records with delivery partner remittance reports.
View demo reportDon't see the reconciliation you need?
Build a custom reconciliation for your own reports, matching logic, and business rules.
Cointab can reconcile many workflows beyond the templates listed here. If your reports are specific to your company, region, ERP, partner, or internal process, you can create a custom reconciliation.
With custom reconciliation, you can:
- Define Side A and Side B reports
- Upload multiple files on both sides
- Select amount and identifier columns
- Add supporting data
- Create derived columns using AI
- Save and reuse the workflow
- Automate future runs
Custom workflow
ERP sales vs Stripe + PayPal + Adyen
Upload reports on Side A and Side B, map amount and identifier columns, add supporting data, and save the workflow for every future period.
Explore custom reconciliation →Why start with a popular reconciliation?
Faster setup
Use a ready-made workflow instead of configuring every report, field, and rule from scratch.
Fewer mistakes
Cointab already knows the expected report structure and matching approach for common workflows.
Reusable every period
Run the same reconciliation again for future months, quarters, or custom periods.
Clear reports
Review fully matched, partially matched, unmatched, and skipped records in one place.
Easier onboarding
Finance users can start with familiar workflows before moving to more advanced custom reconciliations.
Automation-ready
Once the workflow is stable, automate data input, reconciliation runs, and output delivery.
Trusted by finance teams handling recurring reconciliations
Cointab is used by finance and operations teams that reconcile high-volume, multi-source financial and operational data.
“We are very delighted to share this feedback and appreciate the efforts Cointab team is making in providing the reconciliation services of E-Commerce Marketplaces. Though this process involves lots of permutations and combinations, this software is making everything so simple that everyone can understand it. Also the efforts which you guys are putting in turning all the solutions is highly appreciated.”
Popular reconciliation FAQs
Start with a ready-made reconciliation
Pick a popular template, upload your files, and get a clear reconciliation report. If your workflow is unique, build a custom reconciliation or schedule a guided setup.
View demo reportNo credit card required · Popular and custom reconciliations supported