Shopify records commerce activity. Accounting software stores the books. Those jobs overlap, but they are not the same. Simple does not mean vague; it means the categories are in place before the sync starts.
Start with the bookkeeping shape
Before you pick a connector or import method, decide whether you want order-level detail or payout-level summaries.
Payout-level syncing is easier to reconcile because it follows the bank deposit. Order-level syncing gives more detail, but it also creates more lines to review every month. For a beginner, fewer moving parts usually matters more than a perfect copy of every order line.
Use a basic direct sync when the store is simple:
- one Shopify store
- one currency
- one tax profile
- regular payouts
- standard discounts, refunds, and shipping charges
Clean up the accounting rules first when the store is more complex:
- multiple states or tax registrations
- marketplaces or POS channels alongside Shopify
- inventory tracked in the accounting file
- subscriptions, preorders, or gift cards that need careful revenue timing
A small test period beats a full import. One clean month shows whether sales tax, shipping income, discounts, fees, refunds, and gift cards land in the right places.
Set the accounts before you connect
The connection itself is rarely the problem. The account mapping is.
Shopify gross sales should not be crammed into one line. Sales tax belongs in a liability account. Payment processing fees belong in an expense account. Discounts reduce revenue. Refunds reverse the original sale. Gift card sales stay as deferred revenue until redemption.
A simple example helps: a $100 order with $8 in tax, $5 in shipping, a $3 card fee, and a later $20 refund does not become one neat revenue number. It creates several entries, and each one needs the right account. If the software treats the bank deposit as sales, the books will look wrong even though the sync technically worked.
A simple setup path
- Clean the chart of accounts so sales, shipping, discounts, tax, fees, refunds, and gift cards have their own homes.
- Choose payout-level syncing unless you truly need order-level detail.
- Set the inventory method before importing old history if inventory is tracked in the accounting file.
- Connect one recent sales period first.
- Match one payout to one bank deposit.
- Leave the chart of accounts alone until the first month closes cleanly.
That first pass is enough for most beginners. If the setup works for one month, expanding it later is much easier than untangling several months of bad entries.
When a basic sync is enough
A simple sync works well for stores with steady payouts, one currency, and basic tax handling. It also fits sellers who want the books to stay readable without hand-entering every order.
This is the right lane for:
- one-store Shopify setups
- low-to-moderate order volume
- simple shipping and discount patterns
- businesses that want bank reconciliation to stay straightforward
When to slow down and clean up first
Some stores need accounting rules before they need automation.
If you sell across states, use marketplaces, or run POS and online sales together, set tax and duplicate-order rules before importing anything. If inventory lives inside the accounting file, lock the inventory method first so cost of goods sold does not get distorted. If you sell subscriptions, preorders, or gift cards, set revenue timing and liability accounts before the first sync.
In those setups, a basic one-click import can create more cleanup than it saves.
When CSV export is the better route
Manual export and import still has a place.
It works for:
- temporary stores
- low transaction volume
- year-end bookkeeping only
- an accountant change
- a messy file that needs to be rebuilt before automation
The trade-off is obvious: more manual work. Once refunds, discounts, and fees start showing up regularly, manual entry becomes the part that gets postponed.
Before you import old sales
Do not start with a full historical import.
Use a short recent period and check these items:
- one regular order
- one discounted order
- one refund
- the payout matched to the bank deposit
- sales tax, fees, and shipping split into separate accounts
- inventory movement, if the accounting software tracks stock
- classes, locations, or departments already set if you use them
If that period is messy, fix the mapping before sending more history through. A broken setup only gets harder to unwind after several months.
Common mistakes beginners make
The usual errors are simple and expensive.
Some people treat the bank deposit as sales. Others import all of Shopify’s history before checking one payout. Duplicate entries from more than one app or connector create the same kind of mess, because they look like extra income until reconciliation catches them.
Gift cards, chargebacks, and partial refunds also need attention. Those items change the books even when the order looks finished in Shopify. Ignoring them leaves gaps that show up later at tax time or month-end close.
What the first month should look like
A good beginner setup should feel quiet after the first pass: import, reconcile, close, repeat.
Once the first month is in place, review payouts, refunds, and fees on a weekly basis, then close the month against the bank deposit. If the same entries need manual fixes again and again, the mapping is too loose or the store has outgrown a basic setup.
That is the point where a cleaner chart of accounts or a more structured accountant-LED setup helps more than another connector.
Decision Checklist
| Check | Why it matters | What to confirm before choosing |
|---|---|---|
| Fit constraint | Keeps the guidance tied to the real setup instead of generic tips | Size, compatibility, timing, budget, skill level, or storage limits |
| Wrong-fit signal | Shows when the default answer is likely to disappoint | The setup, upkeep, storage, or follow-through requirement cannot be met |
| Lower-risk next step | Turns the guide into an action plan | Measure, compare, test, verify, or choose the simpler path before committing |
Quick answers
Should Shopify sync as orders or payouts?
Payout sync is usually easier for beginners because it matches the bank deposit. Order sync gives more detail, but it creates more reconciliation work.
Where do sales tax and fees go?
Sales tax belongs in a liability account. Payment processing fees belong in an expense account. Neither should sit in plain sales revenue.
Can old Shopify sales be imported later?
Yes. Start with a small recent period first, then bring in older history after the mapping is clean.
Is an accountant required?
No. But accountant review helps most when you sell in multiple states, track inventory in the books, or run subscriptions, preorders, or gift cards.