Reconcile
Compare the Shopify orders in a date range with the Zoho documents for the same dates, and find what is missing or different.
Reconcile answers one question: for these dates, does Zoho hold the same orders, with the same totals, as Shopify?
It is read-only. Running it changes nothing in Shopify or Zoho. Open Reconcile in the app menu.
Run a comparison
- Pick a Start date and End date, or click Last 7 days, Month to date or Last month.
- Click Reconcile.
You can compare up to 31 days at a time. Dates are in UTC, the same way documents are dated when they sync.
What is compared
Zync reads the Shopify orders placed in the range and the Zoho documents dated in the range:
- Invoices, when your document option includes an invoice.
- Sales orders, when it is Sales order only.
An order and a document are matched by the link saved on the order, or by the document's reference number being the Shopify order name.
Test orders and void documents are left out. The line under the tiles says how many.
The tiles
| Tile | Meaning |
|---|---|
| Shopify orders | Orders placed in the range, without test orders |
| Zoho invoices / Zoho sales orders | Documents dated in the range, without void ones |
| Matched | Orders with a document of the same total |
| Missing in Zoho | Orders that should have a document and do not |
| Amount differences | Orders whose document has a different total |
When everything matches, a green banner confirms that every Shopify order in the range that should be in Zoho has a document with the same total.
The lists
Missing in Zoho
Shopify orders that pass your sync filters and have no document in the range. The last column says why:
| Note | Meaning |
|---|---|
| Never synced | The order has no Zoho link at all |
| Linked Zoho document is not in this date range | The order is linked, but its document is dated outside the range, or was voided or deleted in Zoho |
For the orders that never synced, click Sync these orders. Up to 500 are queued at once. Progress appears in Logs.
Amount differences
Matched documents whose Zoho total is not the Shopify total. The note shows the difference (Zoho − Shopify). Totals count as different when they are 0.01 or more apart.
The usual causes:
- A tax mapped to the wrong rate, or tax left off. Check Tax mapping.
- Rounding, on orders with many discounted lines.
- The order was edited in Shopify after it synced. Resync it from Order sync.
- The document was edited by hand in Zoho.
Reconcile reports differences. It does not change documents to remove them.
In Zoho only
Zoho documents dated in the range that match no Shopify order in it. Either they were created by hand in Zoho, or they belong to an order placed outside the range.
Not in Zoho by design
Orders that your settings leave out, with the reason: cancelled, held back by a filter, or waiting for payment before the invoice is raised. Nothing is wrong with these.
Large ranges
Each list shows its first 100 rows. If a range holds more orders or documents than the report reads in one go, a warning says the lists are incomplete. Use a shorter range.
A month-end routine
- Click Last month and Reconcile.
- Sync anything under Missing in Zoho.
- Work through Amount differences with the notes above.
- Glance at In Zoho only for documents nobody expected.
- Run it again. When the green banner shows, the month matches.