What is Unicommerce vs Payment Gateways reconciliation?

It is the process of comparing Unicommerce order, payment status, refund, and sales records with payment gateway transaction, fee, refund, settlement, and payout reports to identify matched records, amount differences, deductions, and open items.

What files are required?

The main files are usually the Unicommerce order or sales report and payment gateway transaction report. Depending on the workflow, refund, fee, settlement, payout, bank, ERP, books, or supporting data files may also be used.

Can Cointab reconcile refunds?

Yes. Unicommerce refund data and payment gateway refund data can be included in the workflow so the team can review whether refunds, cancellations, returns, and customer credits are correctly reflected.

Can Cointab identify payment gateway fees and deductions?

Yes. Where fee, GST, tax, adjustment, dispute, chargeback, or deduction data is available in the reports, Cointab can use it to explain payout differences.

Can Cointab reconcile multiple payment gateways together?

Yes. Multiple payment gateway reports can be included where the workflow requires comparison across different PSPs, payment methods, or settlement sources.

Can Cointab compare payment gateway payouts with bank receipts?

Yes. If bank statement data is added, Cointab can compare payment gateway payout records with actual bank credits and identify bank receipt differences.

Can I reuse this reconciliation every month?

Yes. Once this template is selected and the workflow is used, the same setup can be reused for future periods.

Can this run automatically?

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.

What if my Unicommerce or payment gateway report format is different?

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.

Can AI help with Unicommerce payment reconciliation?

Yes. AI can help match difficult open transactions, review messy references, analyze exceptions, and suggest possible reasons and next actions.

Can I manually match Unicommerce and payment gateway transactions?

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

Can I download the Unicommerce payment reconciliation report?

Yes. Users can download Excel reports with fully matched, partially matched, unmatched, skipped, and transaction-level details.

Popular reconciliation template

Unicommerce vs Payment Gateways Reconciliation

Reconcile Unicommerce orders with payment gateway transactions, refunds, fees, settlements, and payout reports in one structured workflow.

Upload your Unicommerce and payment gateway reports, select the period, run reconciliation, and review fully matched, partially matched, unmatched, and skipped records.

Start this reconciliation Schedule guided setup

View demo report

Ready-made workflow · Reusable every period · Manual upload or automated data flow

Unicommerce Orders

Payment Gateway Transactions

Refund / Fee Data

Settlement / Payout Data

Cointab Unicommerce Payment Reconciliation

MatchedPartially MatchedUnmatchedSkipped

Reconcile Unicommerce orders with payment gateway collections

Unicommerce and payment gateway reports can include orders, payment status, transaction IDs, refunds, fees, settlements, adjustments, and payout amounts. Cointab helps bring these into a clear reconciliation report.

The Unicommerce vs Payment Gateways reconciliation helps finance teams compare order and sales records from Unicommerce with payment, refund, settlement, and payout data received from payment gateways.

This helps finance teams answer questions such as:

Which Unicommerce orders were successfully paid through payment gateways?
Which Unicommerce orders are missing in payment gateway reports?
Which payment gateway transactions do not have a matching Unicommerce order?
Which refunds, reversals, disputes, or cancellations reduced the payout?
Which fees, taxes, or adjustments explain the difference between sales and settlements?
Which transactions were paid in one period but settled in another?
Which items need follow-up or internal review?

This template is useful for eCommerce brands, D2C companies, online sellers, marketplace operations teams, accounting teams, and finance teams that need a repeatable Unicommerce payment reconciliation process.

Required files for this template

Cointab's ready-made workflow is designed around Unicommerce order records and payment gateway reports used for payment, refund, fee, settlement, and payout reconciliation.

Data source	Example records
Unicommerce Order / Sales Report	Used as the internal source-of-truth report containing orders, order IDs, channel orders, invoice numbers, customer details, payment method, order status, sale amount, tax, discounts, and expected payment values.
Payment Gateway Transaction Report	Used to compare Unicommerce orders with payment gateway transactions, payment IDs, order references, transaction status, customer references, payment dates, and payment amounts.
Payment Gateway Settlement / Payout Report	Used to compare payment activity with settlement-level or payout-level data and final amounts received from the payment gateway.
Refund Report	Used where refunds, cancellations, failed payments, customer credits, or reverse transactions need to be reconciled separately.
Fee / Adjustment Report	Used where payment gateway fees, processing charges, GST, taxes, chargebacks, disputes, adjustments, or balance movements need to explain payout differences.
Bank Statement	Optional, but useful if the finance team also wants to compare payment gateway payouts with actual bank credits.
Internal ERP / Books Report	Optional, but useful if the finance team wants to compare Unicommerce and payment gateway data with accounting, ERP, revenue, receivable, or books records.
Supporting Data	Optional supporting files can be used for channel mapping, SKU mapping, order mapping, payment method mapping, tax logic, customer mapping, store mapping, or other enrichment.

What Cointab matches in Unicommerce payment gateway reconciliation

Cointab compares Unicommerce orders, payment gateway transactions, refunds, fees, settlements, payouts, and bank receipts across internal and external reports.

Unicommerce orders and payment gateway transactions

Match Unicommerce orders, order IDs, invoice numbers, or payment references with corresponding payment gateway transactions.

Multiple payment gateways

Reconcile payments across gateways such as Razorpay, Cashfree, Stripe, PayU, PayPal, Shopify Payments, or other PSPs, depending on the reports used.

Refunds and cancellations

Identify whether refunds, cancellations, failed payments, and customer credits are correctly reflected across Unicommerce and payment gateway records.

Fees and deductions

Track processing fees, gateway charges, GST, taxes, chargeback fees, dispute fees, currency conversion, or other deductions where available.

Settlement and payout amounts

Compare expected payment collections from Unicommerce with actual payment gateway settlements or payouts.

Bank and books records, if added

If bank statements, ERP, or books data are included, Cointab can also compare payment gateway payout records against bank credits and accounting entries.

Common Unicommerce payment reconciliation exceptions

Cointab helps finance teams focus on differences instead of manually reviewing every Unicommerce order and payment gateway transaction.

Unicommerce order not found in payment gateway

An order appears in Unicommerce but is not found in the payment gateway transaction report for the selected period.

Payment gateway transaction without matching order

A payment gateway transaction appears without a clear matching Unicommerce order, invoice, customer, or internal sales record.

Amount mismatch

The order or payment reference matches, but the Unicommerce order amount and payment gateway transaction amount are different.

Refund difference

A refund appears in Unicommerce or the payment gateway report but does not match the expected refund, cancellation, return, or customer credit record.

Fee or deduction difference

Payment gateway fees, processing charges, GST, dispute fees, taxes, currency conversion, or adjustments explain part of the difference between gross sales and net payout.

Settlement timing difference

A payment belongs to one order period but is settled or paid out in a later payment gateway settlement cycle.

Failed or reversed payment difference

A failed, reversed, cancelled, or partially paid transaction appears differently across Unicommerce and payment gateway records.

Bank receipt mismatch

The payment gateway payout amount does not match the amount received in the bank statement.

Duplicate or repeated entry

The same Unicommerce order, payment gateway transaction, refund, settlement, or payout entry appears more than once or is included in multiple files.

Missing or unclear reference

Unicommerce order ID, invoice number, payment ID, transaction ID, settlement ID, payout ID, or bank reference is missing, incomplete, or appears inside a description field.

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 Unicommerce payment gateway reconciliation setup every period.

Select the template

Choose Unicommerce vs Payment Gateways from popular reconciliations.

Select the period

Choose the day, week, month, quarter, year, lifetime period, or custom period you want to reconcile.

Upload Unicommerce and payment gateway reports

Upload your Unicommerce order or sales report, payment gateway transaction report, and any required refund, fee, settlement, payout, bank, 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 Unicommerce and payment gateway data.

Review output

View fully matched, partially matched, unmatched, 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 transactions where fixed rules are not enough.

Structured matching

Structured matching can use:

Unicommerce Order IDChannel order IDInvoice numberCustomer IDCustomer emailPayment gateway transaction IDPayment IDGateway order IDRefund IDSettlement IDPayout IDBank referencePayment methodOrder amountPayment amountRefund amountFee amountTax fieldsDate fieldsDerived or cleaned identifiers

Matching scenarios

One-to-one
One Unicommerce order matches one payment gateway transaction.
One-to-many
One Unicommerce order maps to multiple payment gateway records such as payment, fee, refund, adjustment, settlement, or payout entries.
Many-to-one
Multiple Unicommerce orders or payment transactions are grouped into one settlement, payout, or bank deposit.
Many-to-many
Multiple Unicommerce records and multiple payment gateway records are grouped and compared.
Partial matching
Identifiers match, but amounts differ.
Net and contra matching
Sales, refunds, disputes, fees, taxes, adjustments, reversals, and payouts are netted where required.

AI-assisted transaction matching

After structured rules run, AI helps match difficult open transactions where:

References are incomplete
Unicommerce and gateway references do not match directly
Descriptions contain embedded order, customer, payment, or payout references
Refund or reversal entries do not directly map to sales
Amounts require contextual understanding
Payment and settlement dates fall in different periods
Multiple payment gateways are used for the same order set
Multiple possible matches exist

AI exception analysis

For transactions that remain open, AI can help identify possible reasons such as:

Settlement timing differenceMissing payment gateway reportRefund adjustmentFailed or reversed paymentFee or deduction differenceGST or tax differenceBank receipt mismatchDuplicate entryInternal Unicommerce data issueIncorrect payment statusMissing order or payment reference

AI assists matching and exception review, but Cointab keeps reconciliation transparent, reviewable, and audit-friendly.

Audit-ready Unicommerce payment reconciliation reports

Cointab gives your team a clear report showing which Unicommerce and payment gateway transactions matched, partially matched, remained unmatched, or were skipped.

Report categories

Fully matched
Unicommerce and payment gateway records where identifiers and amounts match.
Partially matched
Records where identifiers match but amounts differ.
Unmatched in Unicommerce
Payment gateway transactions, refunds, fees, settlements, or payouts that do not clearly match Unicommerce orders.
Unmatched in payment gateway
Unicommerce orders, refunds, or internal sales records that are not found in payment gateway reports.
Skipped
Records excluded due to missing, invalid, duplicate, incomplete, or unusable data.

Report capabilities

Summary cards
Transaction-level details
Filters for review
Payment gateway view
Payment-method view
Payout-level view
Difference amounts
Matched transaction drill-down
Manual match
Undo manual match
Excel export
Audit-friendly output

Automate recurring Unicommerce payment gateway 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:

EmailSFTPAPI integrations, where available

Run automatically

Schedule reconciliation:

DailyWeeklyMonthlyEnd of dayAfter file receiptAfter all required files are availableAt a custom frequency

Push output back

Send reconciliation output to:

ERPAccounting systemBI dashboardInternal finance systemAnalytics databaseData warehouseInternal exception trackereCommerce operations system

Matched Unicommerce orders
Matched payment gateway transactions
Unmatched Unicommerce records
Unmatched payment gateway records
Refund differences
Failed or reversed payment differences
Fee or deduction differences
Settlement differences
Bank receipt differences
Open items
Suggested actions
Excel reconciliation report
Structured API output

View a Unicommerce payment reconciliation demo report

See how Cointab presents Unicommerce vs Payment Gateways output with matched, partially matched, unmatched, and skipped transactions.

Unicommerce vs Payment Gateways Demo

Explore a sample report showing Unicommerce orders, payment gateway transactions, refunds, fees, settlements, payouts, bank receipts, and open items.

View demo report

Explore related payment gateway and eCommerce reconciliations

Cointab supports other eCommerce, PSP, payment gateway, settlement, and payout reconciliation workflows.

Sales vs Payment Gateway

Use a general payment gateway reconciliation workflow for sales, payments, refunds, fees, and settlements.

View template

Shopify vs PSP

Reconcile Shopify orders with PSP payments, refunds, fees, settlements, and payouts.

View template

Sales vs Razorpay

Reconcile internal sales with Razorpay payments, refunds, settlements, fees, and payouts.

View template

Sales vs Stripe

Reconcile internal sales with Stripe payments, refunds, settlements, fees, disputes, and payouts.

View template

Built for eCommerce teams reconciling Unicommerce and payment gateway data

This template is useful for teams that regularly reconcile Unicommerce orders, payment gateway transactions, refunds, fees, settlements, payouts, and bank receipts.

eCommerce brands

For brands using Unicommerce to manage orders and reconciling payment gateway collections with sales and refunds.

D2C companies

For D2C teams managing high-volume online orders, multiple payment gateways, refunds, and payout differences.

Online sellers

For sellers using Unicommerce across channels and needing a repeatable payment reconciliation process.

Finance teams

For teams handling Unicommerce reports, PSP reports, settlement files, bank deposits, and exception review.

Accounting teams

For teams preparing reconciliation reports for month-end close, books, revenue review, receivables, and audit.

Outsourced finance teams

For accounting firms or finance operations teams handling Unicommerce and payment gateway reconciliation for multiple clients.

Trusted by teams handling eCommerce and payment reconciliation

Cointab is used by finance and operations teams that reconcile high-volume, multi-source transaction data across eCommerce platforms, payment gateways, marketplaces, banks, partners, 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.”
— Urbanic

Unicommerce vs Payment Gateways FAQs

Start Unicommerce vs Payment Gateways reconciliation

Use Cointab's ready-made Unicommerce payment reconciliation workflow to match orders with payment gateway records, identify payout differences, review exceptions, and export audit-ready reports.

Start this reconciliation Schedule guided setup

View demo report

Ready-made workflow · Reusable every period · Manual upload and automation supported

Unicommerce vs Payment Gateways Reconciliation

Reconcile Unicommerce orders with payment gateway transactions, refunds, fees, settlements, and payout reports in one structured workflow.

Upload your Unicommerce and payment gateway reports, select the period, run reconciliation, and review fully matched, partially matched, unmatched, and skipped records.

View demo report

Ready-made workflow · Reusable every period · Manual upload or automated data flow

Data source

Example records

Unicommerce Order / Sales Report

Used as the internal source-of-truth report containing orders, order IDs, channel orders, invoice numbers, customer details, payment method, order status, sale amount, tax, discounts, and expected payment values.

Payment Gateway Transaction Report

Used to compare Unicommerce orders with payment gateway transactions, payment IDs, order references, transaction status, customer references, payment dates, and payment amounts.

Payment Gateway Settlement / Payout Report

Used to compare payment activity with settlement-level or payout-level data and final amounts received from the payment gateway.

Refund Report

Used where refunds, cancellations, failed payments, customer credits, or reverse transactions need to be reconciled separately.

Fee / Adjustment Report

Used where payment gateway fees, processing charges, GST, taxes, chargebacks, disputes, adjustments, or balance movements need to explain payout differences.

Bank Statement

Optional, but useful if the finance team also wants to compare payment gateway payouts with actual bank credits.

Internal ERP / Books Report

Optional, but useful if the finance team wants to compare Unicommerce and payment gateway data with accounting, ERP, revenue, receivable, or books records.

Supporting Data

Optional supporting files can be used for channel mapping, SKU mapping, order mapping, payment method mapping, tax logic, customer mapping, store mapping, or other enrichment.

Start Unicommerce vs Payment Gateways reconciliation

Use Cointab's ready-made Unicommerce payment reconciliation workflow to match orders with payment gateway records, identify payout differences, review exceptions, and export audit-ready reports.

View demo report

Ready-made workflow · Reusable every period · Manual upload and automation supported