Guide · Statements
How to send monthly customer statements from Shopify
If you sell to other businesses on payment terms — Net 30, Net 60, due on receipt — each of your customers has an accounts-payable person whose month starts with a pile of statements. Yours is missing. Shopify's native B2B records the orders, the terms, the due dates and the payments, and it will remind a customer when an invoice is due; it will not tell them, once a month, what they owe you in total.
This guide covers what a customer statement actually needs to contain, the three ways Shopify merchants produce one today, and how to make it happen on the 1st of every month without anyone doing it.
What a statement of account is (and is not)
A statement of account is a periodic summary of one customer's account with you: what the balance was at the start of the period, what was invoiced, what was paid, what the balance is now, and which invoices are still open. It is a balance document, not a tax document — the invoices are the tax documents; the statement lists them.
The bookkeeper on the other side uses it for one thing: to reconcile it against their own ledger and pay what is open. That is why the two tables on a good statement are different. The activity table is the audit trail — every event of the period, in order, with a running balance. The open-items table is the payment list — every unpaid invoice as of the statement date, however old, with what is left to pay and how many days past due it is.
- Header: your name and remit-to details, the statement number, the statement date and the period covered, the customer's name and reference.
- Summary: opening balance, invoiced, paid (and refunded), closing balance, and of which overdue.
- Activity: date, type, reference, due date, amount, running balance.
- Open items: reference, issued, due, amount, paid to date, outstanding, days overdue.
- Aging: current, 1–30, 31–60, 61–90, 90+ days past due — buckets that add up to the closing balance.
- Footer: how to pay, and a line saying this is a statement of account rather than a tax invoice.
Three ways merchants produce one today
By hand, from the orders list. Filter Orders to the company, export, add a spreadsheet, type the opening balance from last month's sheet, and send a PDF. It works for three stockists. At twelve it costs an afternoon a month and one missed payment breaks the running balance for every month after.
From accounting software. If your orders already flow into an accounting system, it can send statements. Many small wholesalers do not run one yet, or run one that does not know about Shopify's B2B orders — and paying a monthly subscription for the one feature you need is a poor trade.
From an app inside Shopify. The statement is computed from the same orders, payment terms and transactions Shopify already holds, rendered in your branding, and emailed to the company's billing contact on a schedule. This is what StatementClerk does.
Getting the numbers right
A statement that is wrong once is worse than no statement: the bookkeeper stops trusting it and goes back to asking for invoices one by one. Three rules keep it right.
- The balance identity must hold on every statement: opening + invoiced − paid = closing, and the open items must sum to the same closing figure. If they do not, something was missed — do not send.
- The opening balance is last month's closing balance. Never recompute it silently. If an old order was refunded or edited after last month's statement went out, show the difference as a labelled correction line on this month's statement.
- Aging counts days past the due date, not days since the order — a Net 60 order placed 45 days ago is current, not overdue.
Automating it
With StatementClerk installed, the schedule is set once — monthly on the 1st, the 15th or the last day, or weekly. On the run day the app builds one statement per company from your Shopify data, checks the balance identity, re-reads every open order from Shopify to make sure nothing changed, and emails each company's billing contact a PDF in your branding. The first cycle waits in a review queue so you can look before anything is sent; after a clean cycle you can switch to automatic.
Anything uncertain is held and explained rather than sent: a possible off-platform payment, numbers that moved since the preview, an address that bounced. Free for up to 5 companies; Pro is $24 a month.