Shopify Reconciliation
Reconcile Shopify orders with Order Management System, Payment Gateways, Cash-on-Delivery Partners, Bank Statement and ERP.
Shopify with Payment Gateway
Reconcile Shopify order report with Payment Gateway settlement reports.
- Verify payments for dispatched orders
- Identify pending payments with ageing
- Verify refunds for RTO and customer returns
- Identify pending customer refunds
Shopify with COD Remittance
Reconcile Shopify order report with COD remittance reports.
- Verify payments for dispatched orders
- Identify pending payments with ageing
- Verify refunds for RTO and customer returns via bank statement, payout reports/links
- Identify pending customer refunds
Shopify with Order Management System
Reconcile Shopify order report with Order Management System (OMS) order reports.
- Verify Shopify orders in OMS
- Identify any order not added in OMS
- Verify if all OMS orders are added via Shopify
Shopify with ERP
Reconcile Shopify order report with ERP sale and credit ledgers.
- Verify Shopify orders present in ERP
- Identify any order not added in ERP system
- Verify if all ERP orders are added via Shopify
- Verify Shopify RTO and customer returns in ERP
Order Management System with Payment Gateway
Reconcile Order Management System order, sale invoice, cancellation invoice, return invoice reports with Payment Gateway settlement reports.
- Verify payments for dispatched orders
- Identify pending payments with ageing
- Verify refunds for RTO and customer returns
- Identify pending customer refunds
Order Management System with COD Remittance
Reconcile Order Management System order, sale invoice, cancellation invoice, return invoice reports with COD remittance reports.
- Verify COD payments for dispatched orders
- Identify pending payments with ageing
- Verify refunds for RTO and customer returns via bank statement, payout reports/links
- Identify pending customer refunds
Order Management System with ERP
Reconcile Order Management System order, sale invoice, cancellation invoice, return invoice reports with ERP sale and credit ledgers.
- Verify net OMS invoice amount with net ERP ledger amount
- Identify any order pending to be added in ERP
- Identify any RTO and customer return pending to be added in ERP
- Identify any extra ERP entry not present in OMS
Payment Gateway Fee Verification
Verify Payment Gateway fees per transaction as per payment mode used by the customer.
- Verify fee charged on every order per payment mode such as credit card, debit card, internet banking, etc.
- Identify transactions where you have been overcharged
- Verify taxes charged on fees
- Verify settlement amount by adding (amount - fee - tax) = (settlement amount) check
Courier Charge Verification
Verify courier invoices per AWB number using SKU weights and distance between warehouse and customer destination.
- Verify forward, RTO, DTO charges using SKU weight
- Verify zonal charges using the distance between warehouse and customer destination
- Verify COD charges as per the bill amount
- Identify AWB numbers where you have been overcharged
Payment Gateway with Bank Statement
Reconcile Payment Gateway settlement reports with Bank statement.
- Verify if all transactions are settled in bank account
- Identify transactions yet to be settled
- Verify consolidated settlement amount in bank statement at UTR level
Details about reconciling Shopify orders with various systems.
To learn how to reconcile your Shopify orders with OMS, Payment Gateways, COD Partners, Bank Statements and ERP, talk to our experts and request for a demo.
