Shopify Tally Integration in India: What Syncs and How

Ask an Indian D2C founder what they do at month end and you'll often hear the same answer: someone exports orders from Shopify, someone else downloads the Shiprocket COD remittance and the Razorpay settlement report, and an accountant types the lot into Tally. The question keeps coming up on r/IndiaBusiness and r/StartUpIndia, usually as "how are you handling Shopify to Tally sync?"

There are apps that do part of this. Before you pick one, it helps to know why the two systems disagree in the first place.

Why Shopify and Tally never quite agree

Shopify records orders. Tally records accounting entries. One Shopify order can turn into several entries in Tally:

• a sales voucher with the GST split by rate and by state
• a receipt when the money actually arrives, which for COD can be weeks later through your courier
• a gateway fee and the GST on that fee, deducted before the payout
• a credit note if the order is returned, and sometimes a reversal of the shipping charge

So "sync Shopify to Tally" really means four flows: orders to sales vouchers, payouts to receipts, fees to expenses, and returns to credit notes. Most of the mess comes from handling only the first one.

What a sync has to carry

Before any tool goes in, agree these with your accountant:

If the SKU names don't match, nothing else will. Fix that first.

Apps, connectors or your own sync

There are three routes, and each fits a different stage:

1. Export and import apps turn Shopify orders into a file Tally can read. They're cheap and fine for a few hundred orders a month, as long as someone checks the file before importing it.
2. Connector platforms that sit between Shopify, marketplaces and Tally. They make sense if you also sell on Amazon or Flipkart and want one place for stock.
3. A custom sync that reads Shopify, your gateway and your courier, and posts finished vouchers to Tally on a schedule. This is worth it when volume is high, you sell in several channels, or your accountant spends days each month on reconciliation.

How Tally accepts data

Tally's own documentation explains the two ways in. TallyPrime can run as a server and accept XML requests over HTTP on a port you set, as long as it's running with a company loaded. Since Release 7.0, TallyPrime can also import masters and transactions from JSON files. Any app or custom sync uses one of these underneath, so ask a vendor which one they use and what happens when Tally is closed. We cover the design side in more detail in our post on ERP choices for manufacturers.

The entries apps usually get wrong

• COD. The sale happens on delivery, and the cash arrives in a courier remittance that bundles dozens of orders after deducting charges. If your sync marks COD orders as paid on the order date, your receivables will never reconcile.
• Gateway payouts. Payouts are net of fees and GST on fees. Post the gross receipt and the fee separately, or your bank balance won't match.
• Partial returns and exchanges. Make sure the credit note references the original invoice and reverses stock to the right godown.
• Edited orders. If staff edit orders after they're placed, decide whether the sync posts the original or the final version, and stick to it.

Shiprocket's Shopify integration lets you map each payment gateway to COD or prepaid. Use the same mapping in your accounting sync so both systems agree on what was paid.

A month-end check

Whatever route you take, run these four checks each month:

1. Shopify order count and value for the month against sales vouchers in Tally.
2. Gateway settlement reports against receipts posted.
3. Courier COD remittances against COD orders marked delivered.
4. Returns in Shopify against credit notes in Tally.

If all four match, the sync is working. If one drifts every month, that's the flow to fix, or the point at which a custom sync starts paying for itself. Our GST on Shopify guide covers the tax settings that need to be right before any of this works.