Zync Docs
Monitoring & Reconciliation

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

  1. Pick a Start date and End date, or click Last 7 days, Month to date or Last month.
  2. 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

TileMeaning
Shopify ordersOrders placed in the range, without test orders
Zoho invoices / Zoho sales ordersDocuments dated in the range, without void ones
MatchedOrders with a document of the same total
Missing in ZohoOrders that should have a document and do not
Amount differencesOrders 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:

NoteMeaning
Never syncedThe order has no Zoho link at all
Linked Zoho document is not in this date rangeThe 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

  1. Click Last month and Reconcile.
  2. Sync anything under Missing in Zoho.
  3. Work through Amount differences with the notes above.
  4. Glance at In Zoho only for documents nobody expected.
  5. Run it again. When the green banner shows, the month matches.