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.