How often to reconcile your Shopify store

Most stores reconcile monthly, because that is when the accounts are done. It is the worst available frequency, and understanding why makes the alternative obvious.

The chain has three joins running on three different clocks, and treating them as one monthly task means each is done at the wrong moment.

Why monthly costs more than it saves

Four reasons, and they compound.

The queue is at its largest. A month of exceptions arriving at once, at exactly the point in the cycle when the finance team has least spare capacity.

The trail has gone cold. A query about a three-week-old payment requires reconstruction. The same query on the day is a glance. Nobody remembers what happened three weeks ago, including the people who were there.

Problems have compounded. A reference that stopped flowing on the fourth has produced a month of unmatched transactions before anyone notices. Caught on the fifth, it is one day's worth.

Decisions were made on unreconciled numbers. For most of the month, whatever you thought your margin was, you did not know. Pricing, promotion and buying decisions taken in that window were taken on estimates.

That last one is the real cost and it never appears as a cost. Monthly reconciliation means monthly information, and monthly information is a month out of date at its worst.

Three joins, three frequencies

The chain does not need one cadence. It needs each part done when its data becomes available.

Store to gateway: daily. Orders and transactions are available immediately, the match is mostly automatic, and exceptions found today are cheap to resolve. This is a minutes-long task and it is where nearly all the value is.

Gateway to bank: as payouts arrive. Not on a fixed day. A payout lands, its report arrives, the decomposition runs. Driven by the provider's cycle rather than by your calendar — see decomposing a payout line by line.

Completeness sweep: weekly. A full pull compared against what you hold, catching anything a missed notification dropped. Weekly is frequent enough that a gap is small and infrequent enough not to be a burden — see Shopify webhooks and why they are not enough.

Then month end confirms rather than reconstructs, because everything has already been matched as it arrived — see month-end without the scramble.

What daily actually involves

Worth being concrete, because daily sounds like a burden and is not.

Most of it is automated and produces nothing to look at. What reaches a person is the exception list, which on a well-configured store is a handful of items: a payment with no order, an ambiguous match, an unexpected fee. Each is a short decision.

The realistic figure is minutes, and it replaces a monthly session measured in hours. The saving is not primarily time, though — it is that problems are found while they are still one day old — see the exception queue and how to size it.

Where the frequency has to bend

Three cases where the general answer needs adjusting.

A provider that reports slowly. If a settlement report arrives days after its payout, the gateway-to-bank join cannot run faster than that. The deposit sits as an unallocated credit until the report lands, which is a state to represent rather than a delay to fight — see when the payout arrives before the report.

A very low volume store. A handful of orders a week does not need a daily routine. Weekly is proportionate, and the principle that matters is regularity rather than frequency.

A promotional peak. The period that most needs daily attention, and the one where it is most likely to be skipped because everyone is busy. Volume, exception count and reserve withholding all rise together, which is exactly when a month of accumulated problems is least affordable — see settlement timing and your cash forecast.

The question that decides your cadence

Not how often you should reconcile, but: how long are you willing to be wrong about your margin?

If the answer is a month, monthly reconciliation is consistent with that. If you make pricing, promotion or buying decisions more often than monthly — and almost every store does — then you are making them on numbers that reconciliation has not yet confirmed.

Daily reconciliation is not about tidiness. It is about the figures you are deciding on being current, which is a different benefit from the one usually claimed for it — see measuring whether AI accounting worked.

Common questions

How often should a Shopify store be reconciled?

Not on one cadence. Store-to-gateway matching daily, since orders and transactions are available immediately and exceptions found the same day are cheap to resolve; gateway-to-bank decomposition as each payout arrives, driven by the provider's cycle rather than the calendar; and a weekly completeness sweep comparing a full pull against what you hold.

Why is monthly reconciliation more expensive?

Because the exception queue arrives all at once when the finance team is busiest, the trail has gone cold so each query requires reconstruction rather than a glance, problems have compounded for up to a month before being noticed, and every decision taken during the month was taken on unconfirmed numbers.

Is daily reconciliation a lot of work?

No, when it is automated. Most of it produces nothing to look at, and what reaches a person is a short exception list — a payment with no order, an ambiguous match, an unexpected fee — each a quick decision. It is minutes a day replacing a monthly session measured in hours.

When does a lower frequency make sense?

At genuinely low volume, where a handful of orders a week does not warrant a daily routine and weekly is proportionate. What matters more than frequency is regularity. The opposite case is a promotional peak, which most needs daily attention and is most likely to have it skipped, since volume, exceptions and reserve withholding all rise at once.

Related: month-end without the scramble · the three-way match a Malaysian store needs · how often to reconcile Shopee sales