Shopify sales, posted the way you would post them yourself. One consolidated sales invoice per period and per currency, with line-level account coding, tax split by the rate actually charged and no duplicates.
Most Shopify connectors flood the ledger with one invoice per order and one contact per customer. Supply Lens takes the approach you would take manually: a periodic summary invoice raised against a single sales contact, structured exactly how you want the P&L to read.
The thing accountants worry about with any automated posting is whether they can trust it at year end. This one is built so the answer is yes.
The core flow is the consolidated invoice. These are the areas where the detail matters and where you choose how it is handled.
Break each period's activity into the summary lines you choose, each mapped to its own account code. The structure is yours, and it is set once.
Daily or weekly. Boundaries are fixed in your store's timezone, so an order at 23:58 is in the day it was placed and not the day after.
Choose the summary lines you need (gross sales, shipping, discounts, refunds and any others) and map each to the Xero account it should hit.
Each rate charged in Shopify mapped to a Xero tax type, with a rule for what happens when a rate appears that has not been mapped yet.
Shop or presentment amounts, one invoice per currency and the name of the single sales contact the invoices are raised against.
Accounting integrations fail quietly and get found by the accountant months later. These are the four we hear about most, in the words customers use.
One invoice per period, per currency, against one sales contact. A year of daily statements is a few hundred documents, each of which a person can open and read.
Posting is idempotent. A retried run finds the statement already exists and leaves it alone, so the same period cannot be posted twice however many times it is attempted.
Tax is analysed per line, not per order. A basket with standard, reduced and zero-rated items splits into three tax lines on the invoice, each at the rate actually charged.
Each currency gets its own invoice in that currency, using shop or presentment amounts as you choose. Xero's own currency handling then does the rest.
Supply Lens handles the connection and the posting. You provide access to both systems and confirm how the invoice should be structured. Most of the time goes on agreeing account codes with whoever owns the chart of accounts.
No. One consolidated invoice per statement period and per currency, against a single sales contact, with summary lines coded to their own accounts. That is what you would do posting manually and it keeps the ledger reviewable.
It groups by time period rather than by payout batch, so the invoice total reconciles to net revenue for the period, not to a bank deposit. If payout-level reconciliation is your priority, that is a different kind of tool and we will say so on the call.
No. Period boundaries are deterministic and posting is idempotent, so every order lands on exactly one statement and a retry cannot create a duplicate. Each invoice carries a statement reference back to the source orders.
Statement periods are daily or weekly. Weekly is the longest single period, which keeps each invoice to a size a person can review and keeps the tax analysis close to the orders it came from.
Tell us how you want the P&L to read and which tax rates you charge. Twenty minutes with whoever owns the chart of accounts is usually enough.