Practical writing about operating more than one Shopify store: reporting across them, month-end close, keeping catalogues in step, and what Shopify solves for you versus what it leaves to you.

Running several Shopify stores — notes from building the tool | EcomSolo

Blog


If you keep the books for merchants selling on Shopify, the awkward clients are rarely the big ones. They
are the ones with four stores.

One store is a clean process you have already automated. Four stores is the same process done four times,
with four sets of exports, four currencies, four payout schedules and one deadline. The work is not
difficult. It is repetitive in a way that resists being done once, and that is exactly the kind of work
that eats a practice.

This is a practical account of what that close actually involves and where the time goes.

## What you actually need out of each store

For a straightforward ecommerce close, per store, per period:

- **Orders**, with their dates, totals, discounts, shipping and tax. This is your revenue.
- **Refunds and returns**, separately. Netting them into orders loses you the ability to explain a
  movement later.
- **Transactions or payouts**, which is how the money actually arrived, net of fees.
- **Taxes**, broken down by jurisdiction if the client sells anywhere with a filing obligation.
- **Gift cards and store credit**, if they use them, because issuing one is not revenue and redeeming one
  is not a payment.

In the Shopify admin each of those is a separate export from a separate screen. Multiply by four stores
and a routine month is twenty-plus files before anyone has opened a spreadsheet.

## The part that catches people: payouts never equal order totals

The single most common reconciliation problem is expecting the payout to match the orders, and it never
does. Several reasons stack up:

**Timing.** A payout covers a window that does not line up with your accounting period. Orders placed on
the 31st settle in the following month's payout, so the cut-off in the orders export and the cut-off in
the payout report are different cut-offs.

**Fees.** Payouts arrive net of processing fees. The order says 100, the payout says 97.10, and the
difference is an expense that has to be recorded rather than quietly lost.

**Refunds and chargebacks** land in the payout that happens to be open when they occur, not the one that
contained the original sale.

**Other payment methods.** Anything not taken through Shopify's own payment processing — PayPal, a
separate gateway, cash on delivery, manual wholesale invoices — never appears in a Shopify payout at all,
and has to be reconciled from somewhere else.

None of this is unusual. It just means the reconciliation is genuinely a reconciliation, not a
comparison, and it has to be done per store.

## Multi-currency, where most of the disagreement lives

If the stores sell in different currencies, decide two things before you start, write them down, and
apply them identically every month.

**Which rate.** The rate on the transaction date, a month-average rate, or a fixed rate set by the
client's policy. Any of the three is defensible. Changing between them is not.

**Which amount.** Shopify records both the presentment currency, what the customer paid in, and the shop
currency, what the store is denominated in. Pick one as your source and stay with it.

Most arguments about multi-store numbers turn out to be two people using different rates rather than one
of them being wrong. Writing the policy down once removes an entire category of month-end email.

## Where the hours actually go

In practice, for a four-store client, the time splits roughly like this:

- **Pulling the data.** Twenty-odd exports, done by hand, in a browser. Twenty minutes if nothing goes
  wrong, longer when a filter resets or an export lands in the wrong date range.
- **Normalising it.** Different stores, same columns, four files per entity to stack. Then the currency
  conversion.
- **Reconciling.** The genuinely skilled part, the part your client is actually paying for.
- **Doing it all again next month**, from scratch.

The first two are the majority of the elapsed time and none of the value. They are also the parts that
can stop being manual.

## Making it repeatable

The shape of a better process is not complicated:

1. **Define the extract once.** The entities, the columns, the date range, the currency. Not per store —
   once, for the client.
2. **Have it cover every store in one file**, or one file per store if your working papers expect that,
   but produced by the same job either way.
3. **Put it on a schedule** so it arrives on the first of the month by email or on your FTP server,
   without anyone opening an admin.
4. **Keep refunds, payouts and taxes as separate extracts** rather than one merged file, so you can point
   at the source of any number later.

That turns the first two stages from an hour of clicking into a file that is already waiting for you when
you start the close.

## What Ecomsolo does here

Ecomsolo connects any number of Shopify stores to one account. From there, one export covers all of them —
orders, refunds, transactions, taxes, twenty-seven record types in total — as a single CSV or Excel file,
converted into one currency, and it can run on a schedule so the file arrives without anyone logging in.
Reports run across every store at once rather than one at a time, and there is a query tool for the cases
where the standard shapes never quite match your working papers.

It does not do your reconciliation, and it does not replace your accounting system. It removes the
twenty exports.

There is a free plan that does not expire, so the honest way to evaluate it is to connect one client's
stores and run the extract you would have run by hand.

## FAQ

**Why does the Shopify payout not match the order total?** Because payouts arrive net of processing fees,
cover a settlement window that does not align with your accounting period, and absorb refunds and
chargebacks when they occur rather than when the original sale happened. The gap is expected; it has to
be explained rather than eliminated.

**How should I handle multiple currencies at month end?** Choose a rate policy — transaction-date,
month-average or fixed — and a source amount, either the presentment currency or the shop currency. Write
both down and never change them mid-year. Consistency matters more than which option you pick.

**Can I export several Shopify stores into one file?** Not from the Shopify admin, which exports one store
at a time. Combining them means either stacking the files yourself or using a tool that connects to all
the stores and produces a single export across them.

**What should I pull for a Shopify month-end close?** At minimum orders, refunds, transactions or payouts,
and taxes, kept as separate extracts so each figure is traceable. Add gift cards if the client issues
them, since issuing and redeeming are not revenue and payment respectively.

**Is there a way to automate the monthly extract?** Yes. Define the entities, columns and date range once
and schedule it to deliver by email, FTP or Google Drive on a set day. The pulling and normalising steps
are the ones that automate cleanly; reconciliation stays with you.


A practical account of closing the books when the orders live in several Shopify stores: what to pull, why payouts never match order totals, how to handle multi-currency, and how to stop doing it by hand every month.

Month-end close across multiple Shopify stores | EcomSolo

Month end when your clients run several Shopify stores


Opening a second store is usually an easy decision. A new market, a wholesale arm, a second brand, a
country-specific storefront — the reason is obvious and the setup takes an afternoon.

What is less obvious is that almost every routine you had for one store quietly stops working. Not
dramatically. Nothing breaks with an error message. The work just gets slower, and the answers get less
reliable, and a year later somebody is rebuilding the same spreadsheet every Monday morning.

Here is what actually changes, in the order most people hit it.

## Reporting stops answering the question you asked

With one store, "how did we do last month" has one answer and you read it off one dashboard.

With three, you have three dashboards, three currencies if you sell in more than one country, and three
timezones deciding where a day starts and ends. Nobody reports "we did £40,000 and $12,000 and €8,000".
They convert, they add, and they do it in a spreadsheet.

Two things go wrong there, and the second is worse than the first.

The obvious one is time. Someone opens three admins, exports three files, pastes them into a fourth, and
applies an exchange rate. Half an hour a week, every week.

The subtle one is that **the numbers stop being comparable**. Which exchange rate — the one on the order
date, or today's? Does the Australian store's Monday overlap the UK store's Sunday? If two people build
the report on different days they get different totals, and once that has happened twice nobody fully
trusts the number again. That is the real cost. Not the half hour, the fact that the answer is now a
matter of opinion.

## Exports become a per-store chore

Shopify's exports are per store, per entity, per screen. Orders from one admin, products from another.

For one store that is fine. For five, a request as ordinary as "send the accountant every order from
every store for the quarter" becomes twenty separate exports, each with its own filename, all needing to
be stitched together before anyone can use them.

The same applies to anything on a schedule. A monthly file for your bookkeeper, a weekly product feed for
a marketplace, a nightly inventory extract for a 3PL — each of those is one job per store, which means
they either get done by hand or they get skipped.

## Catalogues drift apart

This one takes the longest to appear and is the hardest to fix.

You launch store two with a copy of store one's catalogue. For a month they match. Then someone fixes a
product description in one store and not the other. A price rises in one place. A new product line
launches on the main store and reaches the second one three weeks later, with a different handle, because
whoever created it typed the title slightly differently.

Six months on, the two catalogues are neither the same nor deliberately different. They are just
inconsistent, and nobody can tell which differences are intentional. Reconciling them by hand is a week
of work that never gets prioritised, because it is not urgent until a customer notices.

## The same customer looks like two customers

If somebody buys from your UK store and your German store, Shopify has no reason to connect them. Two
customer records, two order histories, two lifetime values that are each wrong.

That is fine until you want to answer something reasonable. Who are our best customers across the whole
business? How many people buy from more than one of our brands? Which segment should get this campaign?
Every one of those questions needs the stores joined, and joining them is manual.

## Plan limits, apps and staff accounts multiply

Each store carries its own subscription, its own app installs and its own staff permissions.

Most apps price per store, so the useful ones get installed on the main store and skipped on the smaller
ones — which means your reporting, your reviews and your email tooling only cover part of the business.
Staff access is per store too, so onboarding somebody means repeating the same permissions three times,
and offboarding means remembering all three.

None of this is difficult. It is just repeated, and repeated work is the kind that gets done badly.

## What Shopify does solve

It is worth being accurate about this, because not every multi-store problem needs outside help.

If your stores are the same brand in different countries, **Shopify Markets** handles a lot: one storefront
serving multiple currencies, prices and domains, without a separate store at all. If you are on Shopify
Plus, expansion stores come with the plan and there is central billing.

So before adding anything, the honest first question is whether you need separate stores at all. A
country variant of one brand often does not. Separate brands, separate legal entities, a wholesale arm
with different pricing and different customers — those genuinely do.

## What it does not solve

What stays hard, regardless of plan, is **the data across the stores**: one report that spans all of them
in one currency, one export that covers all of them in one file, moving catalogue data between them, and
seeing a customer who bought from two of them as one person.

Shopify is built around the store as the unit. That is the right design for the vast majority of
merchants. It just means that when you have several, nothing in the admin is thinking about the group.

## A reasonable order to fix it in

If you are already running more than one store and it feels heavier than it should, these are worth
doing in this order.

1. **Get one number you trust.** Pick your handful of real measures — revenue, orders, average order
   value — and get them across all stores in one currency and one timezone, from one place. Until that
   exists, every argument about performance is really an argument about methodology.
2. **Kill the repeated exports.** Anything you export more than once a month should be a scheduled job
   that covers every store and lands in an inbox or on an FTP server. The recurring ones are where the
   hours actually go.
3. **Then fix the catalogue drift**, once you can see it. It is the biggest job and the least urgent, and
   doing it before the first two means doing it blind.

Ecomsolo exists for the parts Shopify leaves to you: every store you run in one account, reports and
exports that span all of them in a single currency, and a way to copy catalogue data from one store into
another with a dry run before anything is written. There is a free plan that does not expire, so the
cheapest way to find out whether any of this applies to you is to connect two stores and run one report.

## FAQ

**Do I need Shopify Plus to run multiple stores?** No. You can run any number of separate Shopify stores
on any plan; each is its own subscription. Plus adds expansion stores within one licence and central
billing, which is a cost and administration benefit rather than a capability one.

**Should I use Shopify Markets instead of a second store?** If it is the same brand selling into another
country, usually yes. Markets handles currencies, pricing and domains from one storefront without the
overhead of a second store. Separate brands, separate legal entities, or a wholesale arm with different
customers are the cases where a real second store makes sense.

**Can I see all my stores' orders in one place?** Not in the Shopify admin, which is organised around one
store at a time. Consolidating across stores means either exporting each one and combining the files, or
using a tool that connects to all of them and reports across the group.

**How do I keep products the same across two stores?** Either a disciplined manual process, or copying
the catalogue from one store into another on a schedule so the second always follows the first. The risk
with a manual process is not that it is wrong on day one, it is that it drifts and nobody notices.

**What about currency when combining reports?** Decide once whether you convert at the order date or at a
fixed rate, write it down, and apply it the same way every time. Most disagreements about multi-store
numbers turn out to be two people using different rates rather than one of them being wrong.


A second Shopify store doubles more than the revenue. Here is what stops working — reporting, exports, catalogue drift, customer overlap, staff access — and which problems Shopify solves for you and which it leaves to you.

Blog

Month end when your clients run several Shopify stores

What actually breaks when you run more than one Shopify store

Get Ecomsolo Now *Free Plan available