New: payments, credit notes, tax mapping and order reconciliation for Zoho Books — see all features
Accounting

Reconcile Shopify Orders with Zoho Before Month-End Close

Use the Reconcile page to compare Shopify orders with Zoho invoices or sales orders for any date range. Find missing orders, amount differences, and Zoho-only documents, and fix them before you close the month.

Month-end is the wrong time to find a missing order

Most reconciliation problems are small. One order that never synced because Zoho was briefly unavailable. One invoice whose total is off by a few cents of tax. One document someone created by hand and forgot about. None of them is hard to fix on the day it happens. All of them are painful when you discover them three weeks later, with the books half closed and nobody sure what changed.

The usual way to check is a pair of exports and a spreadsheet lookup. It works, it takes an hour, and so it only happens once a month. Zync has a Reconcile page that does the comparison in the app for any date range you pick, so the check is cheap enough to run every week.

What the Reconcile page compares

The page is called Reconcile Shopify and Zoho, and it sits in the app navigation after Logs. It answers one question: for a date range, which Shopify orders have their Zoho document, which are missing, and where do the totals differ?

A few rules define the comparison:

  • It is read-only. Running a report creates and changes nothing.
  • It compares the Shopify orders placed in the range with the Zoho documents dated in it.
  • Dates are in UTC, the same way documents are dated when they sync.
  • It covers up to 31 days at a time.
  • Which Zoho document it looks at follows your settings. If your document option includes an invoice, it compares against invoices. If orders become sales orders only, it compares against sales orders.

An order is matched to its Zoho document by the link saved on the order when it synced, or failing that by the Zoho reference number, which is the Shopify order name. Two totals count as different when they are 0.01 or more apart. The Shopify total follows the currency setting you chose under Order Settings.

Test orders are left out of the Shopify side, and void documents are left out of the Zoho side. Both are counted and shown under the tiles so you know they were excluded rather than lost.

Run it

Set a Start date and an End date and click Reconcile, or use one of the quick ranges: Last 7 days, Month to date, or Last month. Zoho has to be connected.

The report loads on the same page. If Zoho cannot be reached or the range is invalid, a banner says why.

Reading the five tiles

Across the top are five numbers:

  • Shopify orders is the count of real orders placed in the range.
  • Zoho invoices or Zoho sales orders is the count of live documents dated in the range.
  • Matched is the count of orders with a document whose total agrees.
  • Missing in Zoho is the count of orders that should have a document and do not.
  • Amount differences is the count of matched pairs whose totals disagree.

When there is nothing to fix, a green banner says that every Shopify order in the range that should be in Zoho has a matching document with the same total. That sentence is what you want to see before you close.

Below the tiles are up to four lists. Each shows the order, the date, the Shopify total, the Zoho total, the Zoho document, and a short note explaining why the row is there.

Missing in Zoho

These are Shopify orders that pass your sync filters and have no invoice or sales order in the range. The note tells you which of two situations you are in.

Never synced means the order has no link to Zoho at all. If any rows are like this, a banner above the list counts them and offers Sync these orders. Clicking it queues them, up to 500 at a time, and their progress appears in Logs. This is the one action on the page, and it only ever touches orders that have never synced.

Linked Zoho document is not in this date range means the order does point at a Zoho document, but that document is not among the live ones dated in the range. It may be dated outside the range, or it may have been voided or deleted in Zoho. Open the document in Zoho to see which.

If orders keep turning up as never synced, look for the cause rather than clicking the button every week. Logs filtered to failed orders will show the reason, and the guide to logs, retries and API limits explains how to read them.

Amount differences

These orders have a Zoho document, but its total is not the Shopify order total. The note shows the size and direction of the gap as Zoho minus Shopify. The page describes the usual causes itself: tax, rounding, or an order edited after it synced.

How to work through them:

  • A consistent gap across many orders usually points at tax. Check that each Shopify tax maps to the right Zoho tax, and whether shipping tax or an explicit zero tax should be sent. The tax mapping guide covers each option.
  • A gap of a cent or two on scattered orders is rounding between the two systems.
  • A larger one-off gap usually means the order changed in Shopify after it synced, or the document was edited in Zoho.

The report does not correct amount differences for you. It shows them so that a person decides whether the Zoho document or the setting behind it needs to change.

In Zoho only

This list runs the other way. It shows Zoho documents dated in the range that match no Shopify order in it. The note separates two cases: a document with a reference that matches no order name in the range, and a document created without a Shopify reference at all.

Neither is necessarily a problem. A document created by hand for a phone order belongs here. So does the document for an order placed just outside the range. What you are looking for is a document nobody can explain, or a duplicate of one that is already matched.

Not in Zoho by design

The last list is the one that saves the most time, because it explains orders that look missing and are not. These are orders your settings leave out on purpose:

  • Cancelled orders.
  • Orders held back by a filter, with the filter named, such as a payment status that is not in your allowed list.
  • Orders waiting for payment before the invoice is raised, when you use the option that creates the sales order first and the invoice once Shopify marks the order paid.

Without this list, every unpaid order in a paid-only setup would look like a sync failure. With it, you can confirm at a glance that the gap between the Shopify count and the matched count is intended. If an order is here and you think it should not be, the setting to revisit is under order settings or documents.

A month-end routine

A routine that takes a few minutes and catches nearly everything:

  • Weekly, run Last 7 days. Sync anything that never synced and glance at amount differences while the orders are fresh.
  • On the first working day of the month, run Last month. Clear Missing in Zoho, review Amount differences, and explain anything under In Zoho only.
  • If payments are recorded, check in Zoho that paid orders show paid invoices. Setup is covered in recording Shopify payments in Zoho Books.
  • If refunds are synced, spot-check that refunded orders have credit notes, as described in Shopify refunds to Zoho credit notes.
  • If a gap is large, use the Backfill tab for the same dates instead of syncing order by order. A dry run first shows what it would do. See how to backfill historical orders.

Limits to keep in mind

  • One report covers up to 31 days. Close a quarter by running it three times.
  • Each list shows its first 100 rows and tells you how many there are in total. Narrow the date range to see the rest.
  • A very busy range can hold more than the report reads in one go. When that happens a warning says the lists are incomplete and asks for a shorter range.
  • It compares one document type per run, chosen by your document setting. It does not check payments or credit notes line by line.

Next step

Open Reconcile, click Last month, and read the result from the top down: tiles, then Missing in Zoho, then Amount differences. The reference for every list and note is in the reconcile documentation, and the order reconciliation overview shows how it fits with the rest of accounting sync.

TopicsReconciliationMonth-End CloseZoho BooksAccountingOrder SyncAudit
FAQ

Common questions

How do I check that every Shopify order is in Zoho?
Open the Reconcile page, pick a date range of up to 31 days, and click Reconcile. The report compares the Shopify orders placed in the range with the Zoho documents dated in it and lists anything missing or different.
Does reconciling change anything in Zoho or Shopify?
No. The comparison is read-only. The only action on the page is Sync these orders, which queues orders that have never synced, and you have to click it yourself.
Does it compare invoices or sales orders?
It follows your document setting. If your document option includes an invoice, Shopify orders are compared with Zoho invoices. If it creates sales orders only, they are compared with Zoho sales orders.
Why does an order show an amount difference?
The Zoho total and the Shopify order total are 0.01 or more apart. The usual causes are tax, rounding, or an order edited in Shopify after it synced. The report shows the difference so you can decide what to correct.
Why is a paid-for order listed as not in Zoho by design?
That list holds orders your settings leave out on purpose: cancelled orders, orders held back by a filter, and orders waiting for payment before the invoice is raised. Each row says which reason applies.
Can I reconcile a whole year at once?
Not in one go. The report covers up to 31 days at a time, so run it month by month. If a range holds more than the report reads at once, it warns you that the lists are incomplete and asks for a shorter range.

Connect Shopify and Zoho in an afternoon

Start a free trial, connect your Zoho org, and run a dry-run backfill to see exactly what would land in Zoho. No engineering required.