Shopify Payment Reconciliation in Tally: Complete Guide

Payment reconciliation is one of the trickiest aspects of e-commerce accounting. With multiple payment gateways, processing fees, refunds, and settlement cycles, keeping Tally in sync with actual bank deposits requires a systematic approach.

Understanding the Payment Flow

Typical Shopify Payment Journey

Customer Pays → Payment Gateway → Settlement → Your Bank
     Day 1           Day 1         Day 3       Day 3

This delay creates reconciliation complexity:

Setting Up Ledgers for Payment Reconciliation

Gateway-wise Receivable Ledgers

Create separate ledgers for each payment method:

Current Assets
├── Shopify Payments Receivable
├── Razorpay Receivable
├── PayU Receivable
├── COD Receivable - [Partner Name]
└── PayPal Receivable (if international)

Fee Ledgers

Indirect Expenses
├── Payment Gateway Charges
│   ├── Shopify Payments Fees
│   ├── Razorpay Fees
│   └── PayU Fees
└── COD Handling Charges

GST on Payment Fees

Payment gateway fees attract 18% GST:

Payment Gateway Charges (Net)
GST Input Credit - Payment Fees

Most gateways provide tax invoices monthly. Record the GST credit.

Recording Shopify Payments

Step 1: Order with Online Payment

When automated sync creates sales voucher:

Customer Account        Dr.    10,000
  To Sales                         8,475
  To CGST Output                     763
  To SGST Output                     762

Step 2: Mark Payment Received

When order is paid (same day for prepaid):

Shopify Payments Receivable    Dr.    10,000
  To Customer Account                    10,000

With automation, this happens automatically based on order payment status.

Step 3: Record Settlement

When Shopify settles to your bank:

Bank Account           Dr.    9,700
Payment Gateway Fees   Dr.      300
  To Shopify Payments Receivable     10,000

Bulk Settlement Entry

Shopify typically settles multiple orders together. Entry for weekly settlement:

Bank Account                   Dr.    97,000
Shopify Payment Gateway Fees   Dr.     3,000
  To Shopify Payments Receivable        100,000

Match the payout report from Shopify with total orders for that period.

Handling Different Payment Methods

Shopify Payments

Settlement cycle: 2-3 business days Fees: 2% for Indian cards

Daily reconciliation:

1. Check orders marked "Paid" in Shopify
2. Verify receivable ledger balance
3. Match against upcoming payout

Razorpay / PayU

Settlement cycle: T+2 days Fees: 2% + GST

Entry pattern same as Shopify Payments

Additional consideration: Razorpay provides detailed transaction-wise breakdown.

Cash on Delivery (COD)

COD has unique complexities:

Order Placed:

COD Receivable          Dr.    1,000
  To Sales                          847
  To GST Output                     153

Order Delivered:

Delivery Partner Receivable    Dr.    1,000
  To COD Receivable                      1,000

Settlement from Delivery Partner:

Bank Account                   Dr.    950
COD Handling Charges           Dr.     50
  To Delivery Partner Receivable      1,000

Return to Origin (RTO) Handling

When COD order is not delivered:

Sales Returns           Dr.    847
GST Output              Dr.    153
  To COD Receivable              1,000

If inventory is recovered:

Inventory (Returned)    Dr.    [Cost]
  To Cost of Goods Sold          [Cost]

Reconciliation Process

Daily Reconciliation Checklist

Morning (10 minutes):

1. Check Shopify orders from yesterday
2. Verify sync completed (all orders in Tally)
3. Check any failed syncs

Evening (10 minutes):

1. Review expected settlements
2. Check bank for deposits
3. Record settlement entries

Weekly Reconciliation

Time required: 30-60 minutes

1. Run Shopify Payout Report

   • Export payout details
   • Note total payout amount
   • List order IDs included

2. Compare with Tally

   • Total of related sales vouchers
   • Less: Returns for that period
   • Less: Chargebacks (if any)
   • Should equal: Payout + Fees

3. Identify Discrepancies

   • Missing orders in Tally
   • Extra orders in Tally
   • Amount mismatches

4. Resolve Issues

   • Re-sync missing orders
   • Investigate amount differences
   • Create adjustment entries if needed

Monthly Reconciliation

Time required: 1-2 hours

1. Bank Statement Reconciliation

   • Match all deposits with Tally
   • Identify unrecorded transactions

2. Gateway-wise Balance Check

   • Shopify Receivable balance
   • Should equal pending settlements
   • Clear any aged items

3. Fee Verification

   • Total fees recorded
   • Match with gateway statements
   • Claim GST credit properly

Common Reconciliation Issues

Issue 1: Payout Amount Doesn't Match

Causes:

• Refunds processed between order and settlement
• Chargebacks deducted
• Currency conversion differences
• Adjustments by Shopify

Solution: Download detailed payout breakdown. It shows:

• Each order amount
• Each refund deducted
• Fees charged
• Net amount

Issue 2: Missing Orders in Payout

Causes:

• Order was pending payment
• Payment failed
• Order cancelled

Solution: Check order status in Shopify. If legitimately paid but not in payout, contact Shopify support.

Issue 3: Extra Amount in Bank

Causes:

• Multiple payouts on same day
• Manual transfer initiated
• Interest credit (rare)

Solution: Match each deposit with specific payout. Don't combine entries.

Issue 4: COD Reconciliation Gap

Causes:

• Delivery status not updated
• RTO not processed
• Partner settlement delayed

Solution: Weekly review of COD aging:

• Orders shipped but not delivered
• Delivered but not settled
• Age > 7 days needs investigation

Automation Benefits

With Manual Reconciliation

With Automated Sync

The sync automatically:

• Creates vouchers with correct payment method
• Marks payments received for prepaid orders
• Handles partial payments correctly

You only need to record actual bank settlements.

Advanced: Multi-Currency Handling

For international payments:

Exchange Rate Recording

Bank Account (INR)              Dr.    83,000
Foreign Exchange Gain/Loss      Cr.       500
  To PayPal Receivable (USD converted)    82,500

Monthly Rate Adjustment

Revalue foreign currency receivables monthly:

PayPal Receivable              Dr.    1,000
  To Forex Revaluation Gain           1,000

(Or opposite for loss)

Reporting Setup

Key Reports to Generate

Daily:

• Outstanding Receivables by Gateway
• Today's Failed Syncs

Weekly:

• Settlement vs Expected Report
• Gateway Fee Analysis

Monthly:

• Bank Reconciliation Statement
• Gateway-wise Volume & Fees
• Receivable Aging Report

Setting Up Tally Reports

Create custom reports in Tally:

Gateway of Tally → Display → Statements of Accounts
→ Ledger → Outstandings → Receivable-wise

Filter by receivable ledgers to see pending settlements.

Best Practices Summary

1. Separate ledgers for each payment gateway
2. Daily monitoring of sync and payments
3. Weekly settlement recording and matching
4. Monthly deep reconciliation
5. Keep records of all payout reports
6. Automate what you can

Getting Started

Ready to simplify your payment reconciliation?

1. Start free trial - Automatic order sync
2. Set up ledgers - As described above
3. Configure payment mapping
4. Enjoy simplified reconciliation

Start Your Free Trial - 7 days free, no credit card required