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

Record Shopify Payments in Zoho Books: Gateway Mapping and Deposit Accounts

Learn how Zync records a Zoho customer payment against the invoice when Shopify collects the money, and how to map each Shopify gateway to its own Zoho payment method and deposit account.

An invoice with no payment is half the story

Getting a Shopify order into Zoho Books as an invoice feels like the finish line. It is not. An invoice only says that money is owed. Until a payment is recorded against it, Zoho shows the invoice as outstanding, your receivables report is inflated by every order your store has already been paid for, and someone on the finance team ends up marking invoices as paid one by one.

That manual step is where books drift. A payment gets recorded against the wrong invoice, lands in the wrong bank account, or is simply forgotten. Zync closes the gap by recording the payment for you at the moment Shopify collects the money, and by letting you decide which Zoho account each payment gateway deposits into. This guide walks through how it works and how to set it up.

What Zync records, and when

Payment recording lives under Orders, on the Documents & Accounting tab, in the Payments section. It is controlled by one switch, Record payments, and it is off by default so that turning on order sync never changes your books in a way you did not ask for.

When the switch is on, the app looks at the transactions on each Shopify order and records a Zoho customer payment for the money Shopify actually collected. In practice that means:

  • Only successful transactions count. A failed or pending attempt is ignored.
  • Only money coming in counts: sales and captures. An authorization on its own is not a payment until it is captured.
  • Each transaction is recorded once. If an order is paid in two captures, Zoho gets two payments.
  • The payment is dated with the day Shopify processed the transaction, and its description names the Shopify order and the gateway.

This runs as part of the same sync that creates the order's documents. Whether the trigger is a new order, an update from Shopify when the order is paid, a manual sync, or a backfill, the app works out what Zoho is still missing and does it in a fixed order: documents first, then the invoice, then payments.

Payments need an invoice to land on

A Zoho customer payment is always applied to an invoice. That makes the document option the first thing to check. Under Documents, the Create each order as setting has four choices:

  • Sales order creates one sales order per Shopify order and no invoice.
  • Sales order, then invoice when paid raises the invoice from the sales order once Shopify marks the order paid.
  • Sales order and invoice together creates both as soon as the order syncs.
  • Invoice only creates an invoice and no sales order.

The plain Sales order option raises no invoice, so there is nothing to record a payment against. If you turn on Record payments while that option is selected, the screen warns you and asks you to pick a document option that includes an invoice. The other three all work. If you are still choosing between them, the guide to document flows covers the trade-offs, and the documents reference lists every option.

One more detail matters here. Zoho only accepts a payment against an invoice that has left draft status. If you save documents as Draft, the app marks the invoice as sent just before it records the payment. Marking an invoice as sent changes its status only. Zoho does not email the customer.

Set your defaults first

Two defaults decide what happens to any payment that does not have a rule of its own:

  • Default payment method is the Zoho payment mode used on the payment. The choices are Cash, Cheque, Credit card, Bank transfer, Bank remittance, Auto transaction, and Others.
  • Default deposit account is the Zoho account the money is deposited to. Leave it on the Zoho default, or pick one of your accounts from the list.

The account list is loaded from your Zoho organisation when you switch the feature on, so Zoho needs to be connected. If the list cannot be loaded, the screen tells you why and offers a retry.

For a store with a single payment processor, the defaults may be all you need. Pick the method that describes how the processor pays you and the account its payouts land in.

Map each gateway to its own method and account

Most stores take money more than one way: a card processor, a wallet, cash on delivery, a manual bank transfer. Those rarely belong in the same Zoho account. The Gateway mapping table is where you separate them. Each row has three parts: the Shopify gateway, the Zoho payment method, and the Deposit account.

You do not have to remember gateway names. Click Find gateways in recent orders and the app scans your last 100 orders and lists every gateway it saw, with a count next to each. Click one to add it as a row, then choose its payment method and deposit account.

If a gateway has not appeared in recent orders yet, add it by hand. Type the name into the empty row and click Add gateway. Use the exact name Shopify uses for the gateway, for example shopify_payments or manual, because the mapping is matched on that name.

A typical table looks like this:

  • shopify_payments goes to Credit card and a clearing account for processor payouts.
  • A cash on delivery gateway goes to Cash and the cash account your courier remits into.
  • manual goes to Bank transfer and your main bank account.

Any gateway without a row uses the default payment method and default deposit account, so a new payment method added to your store later still gets recorded. It just lands in the default account until you give it a row of its own.

How amounts are applied

The app is deliberately conservative about amounts, because a payment that overstates what was received is worse than no payment at all.

  • The amount applied never exceeds the balance the invoice still owes. If the transaction is larger than the remaining balance, only the balance is applied.
  • If the invoice has no balance left, for example because someone already recorded the payment by hand in Zoho, nothing is recorded. The app notes the transaction as settled so it is not looked at again.
  • Amounts follow the currency setting under Order Settings, the same one your documents use.

This is also what makes payment recording safe to switch on for a store that has been running for a while. Orders whose invoices were settled manually are left alone.

Why a retry never records the same payment twice

Every sync in Zync runs as a queued job with up to three attempts and exponential backoff. Retries are good for reliability and dangerous for accounting unless each step can tell whether it already happened. Payments handle that in two ways.

First, each payment is created with a reference that is derived from the Shopify transaction. Before recording anything, the app searches Zoho for a payment with that reference. If one is found, it is linked to the order instead of being created again. That covers the awkward case where Zoho accepted the payment but the response never made it back.

Second, once a payment is recorded, the app writes that fact onto the Shopify order before it moves to the next step. A later sync of the same order skips every transaction already handled. One job runs per order at a time, so two updates arriving in the same second cannot both decide the payment is missing.

If Zoho's API limit is reached partway through, the order waits and is queued again rather than failing, and it picks up exactly where it stopped.

A setup that works for most stores

If you want a sensible starting point, this is the configuration most Zoho Books users end up with:

  • Create each order as set to Sales order, then invoice when paid, so unpaid orders stay as sales orders and revenue appears only when money arrives.
  • Record payments on, with a default method and a default deposit account.
  • One gateway row per payment method you actually reconcile separately.
  • A dry run backfill over the last week before you switch it on for live orders, so you can read in Logs exactly which payments would be recorded. The backfill guide explains how.

After a few days, open the Reconcile page and compare a date range. Matching totals there, plus invoices showing as paid in Zoho, tell you the loop is closed. Reconciling before month-end goes through that check in detail.

What payment recording does not do

It is worth being clear about the edges:

  • It records money collected through Shopify. It does not import bank feeds or match processor payouts and fees.
  • It needs an invoice. With the plain Sales order option, payments wait until a document option that includes an invoice has raised one.
  • It does not email the customer when an invoice is marked as sent.
  • Money going back to the customer is a separate setting. Refunds become credit notes, covered in Shopify refunds to Zoho credit notes.

Next step

Open Orders, go to Documents & Accounting, confirm your document option includes an invoice, and switch on Record payments. Set the two defaults, click Find gateways in recent orders, and map the gateways you see. The full field-by-field reference is in the payments documentation, and the payment sync overview shows where this fits with the rest of accounting sync.

TopicsPaymentsZoho BooksGateway MappingInvoicesAccountingOrder Sync
FAQ

Common questions

Does Zync record Shopify payments in Zoho automatically?
Yes, once you switch on Record payments under Orders, Documents & Accounting. It is off by default. When it is on, each successful Shopify sale or capture transaction becomes a Zoho customer payment applied to that order's invoice.
Why are my payments not being recorded?
The most common reason is the document option. Payments are recorded against an invoice, and the plain Sales order option creates none. Pick a document option that includes an invoice, and the payment is recorded once that invoice exists.
Can each Shopify gateway go to a different Zoho account?
Yes. The Gateway mapping table sends each Shopify gateway to its own Zoho payment method and deposit account. Gateways you have not mapped use the default payment method and default deposit account.
Will a retry or a resync record the same payment twice?
No. Every payment is recorded with a reference tied to the Shopify transaction, and the app looks that reference up in Zoho before creating anything. It also remembers each transaction it has already handled on the order.
What happens if the invoice was already paid by hand in Zoho?
Nothing is added. If the invoice has no balance left, the app notes that the transaction is settled and does not record a second payment. The amount applied never exceeds what the invoice still owes.
Does this work for cash on delivery and manual payments?
Yes, as long as Shopify shows a successful transaction for the money. Map the gateway name Shopify uses for that method to the Zoho payment method and account you want, for example Cash and your cash account.

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.