The simplest way to keep that trail intact is to use a Shopify clearing account. Customer payments enter the clearing account, fees and refunds reduce it, and each net payout moves from the clearing account to the bank. When all completed payouts have been recorded, the clearing account should return to zero apart from documented timing items.
Map the Money Before Connecting Anything
Set the account structure first. An automation can only post accurately when it has somewhere sensible to send each part of a transaction.
A typical Shopify sale includes these accounting events:
- Sale: Record product revenue, shipping income, discounts, and sales tax separately.
- Customer payment: Post the amount paid into the Shopify clearing account.
- Payment fee: Record merchant processing fees as an expense that reduces the clearing balance.
- Payout: Move the net payout from the clearing account to the bank account.
- Refund or chargeback: Reverse the related revenue, tax, and customer-payment amounts.
Do not treat the bank deposit as the sale. A payout is the amount left after fees, refunds, chargebacks, and other adjustments. Recording that net deposit as revenue understates gross sales and hides processing costs.
Use separate ledger accounts for:
- Sales revenue
- Shipping income
- Sales discounts
- Sales tax payable
- Refunds and returns
- Merchant processing fees
- Shopify clearing account
- Bank account
Gift cards need their own treatment. An unredeemed gift card is a liability because the business still owes merchandise or services to the customer. Record revenue when the gift card is redeemed.
Choose the Right Level of Detail
There are three common ways to move Shopify activity into accounting. The right choice comes down to how much transaction detail the books need to hold.
| Method | Best fit | What reaches accounting | Reconciliation work | Main trade-off |
|---|---|---|---|---|
| Order-level sync | Stores with detailed profitability, inventory, customer, SKU, or channel reporting needs | Individual orders, discounts, taxes, refunds, fees, and payouts | Higher | More entries, mapping rules, and exceptions to review |
| Daily sales summary | Stores that want organized monthly books without every individual order in the general ledger | Daily totals for revenue, shipping, discounts, tax, refunds, fees, and payout activity | Moderate | Individual order research remains in Shopify |
| Manual summarized journal entry | Stores with fewer than 20 simple orders per month and one payment method | Weekly or monthly totals for sales, tax, fees, refunds, and payouts | Low at first; rises as volume grows | Relies on disciplined posting and reconciliation |
Use order-level syncing when the detail matters
Order-level syncing suits stores that need sales records by SKU, sales channel, customer, or order. It can also support workflows tied to inventory, cost of goods sold, wholesale reporting, or multiple legal entities.
The downside is maintenance. Every order status, discount, tax amount, partial refund, cancellation, and alternate payment method needs to land in the right account. A bad mapping does not stay isolated; it repeats across every synced transaction.
Use daily summaries when Shopify holds the order detail
For many established stores, daily summaries keep the accounting file easier to read while preserving accurate revenue and payout reconciliation.
Shopify remains the source for order-level questions. The payment processor explains fees and settlement activity. The accounting platform shows income, expenses, assets, liabilities, and profit.
That division is usually easier to maintain than trying to recreate the entire Shopify order history inside the general ledger.
Use manual summaries only for genuinely simple activity
Manual posting can work for a small store with limited orders, one payment method, no inventory system, and straightforward refunds. Record gross sales, discounts, tax collected, refunds, fees, and net payouts separately, then reconcile the clearing account.
Once manual posting becomes repetitive, it becomes easier to miss a refund, fee, or duplicate entry. At that point, a summarized automated workflow is usually easier to manage.
Match the Workflow to the Store
Order count matters, but it is not the only factor. Payment methods, inventory, taxes, refunds, and sales channels can make a modest store more complicated than a larger one.
| Store situation | Recommended approach | Reason |
|---|---|---|
| One storefront, one payment method, no inventory tracking | Daily summary or manual summary | Fewer moving parts make payout reconciliation straightforward |
| More than 50 paid orders each month | Automated daily summary or order-level sync | Manual posting becomes repetitive and easier to misstate |
| Physical products with inventory and cost tracking | Order-level sync or a workflow tied to inventory records | Revenue, stock movement, returns, and cost of goods sold need coordinated treatment |
| Subscription or prepaid service sales | A workflow that handles deferred revenue | Cash received and revenue earned may fall in different periods |
| Multiple currencies or sales channels | Separate clearing-account structure by channel or currency | A single clearing account becomes difficult to trace across settlements |
| Frequent refunds, exchanges, or partial shipments | A workflow that records refunds and adjustments reliably | Gross sales alone will no longer align with settlement activity |
Inventory is an important dividing line. A sales integration does not handle the full inventory process by itself. Stores that carry physical stock still need a consistent approach for purchase receipts, stock adjustments, returns, inventory value, and cost of goods sold.
Tax treatment also affects the setup. Sales tax collected from customers belongs in a liability account until it is remitted. Recording it as income inflates revenue and makes profit look higher than it is.
Set Up the Integration in Six Steps
1. Create the chart-of-accounts structure
Add the revenue, tax, fee, refund, clearing, and bank accounts before turning on any sync. Keep product sales, shipping income, discounts, and sales tax separate from the start.
This makes reports more useful and makes errors easier to find. If discounts are mixed into operating expenses or sales tax is mixed into revenue, the books become harder to interpret later.
2. Choose a posting trigger
Decide when sales activity should reach the accounting system:
- Paid-order posting records activity when the customer pays.
- Daily summary posting records daily totals.
- Payout-based summaries align closely with cash settlement activity.
Paid-order records provide more immediate revenue detail. Payout-based summaries can simplify bank reconciliation. Whichever trigger you use, do not post the same sale again when the payout arrives.
3. Map every transaction type
Set rules for the events the store actually creates:
- Product sales to sales revenue
- Shipping charges to shipping income
- Discounts to sales discounts
- Sales tax collected to sales tax payable
- Merchant fees to merchant processing fees
- Customer payments to the Shopify clearing account
- Net payouts from the clearing account to the bank account
- Refunds to refunds and returns, with related tax reversal where appropriate
- Gift card purchases to a gift card liability account until redemption
Avoid using merchant fees to reduce sales revenue. Fees are an expense, while sales revenue should show the gross amount earned from customers.
4. Set reference fields to prevent duplicates
Use Shopify order IDs, payout IDs, or transaction IDs as reference fields wherever the workflow supports them. These references make it easier to trace an accounting entry back to Shopify and help prevent the same transaction from posting twice.
Duplicate entries often appear when a historical import overlaps with an automated feed. A good reference system makes these mistakes easier to spot before month end.
5. Pick a clean cutover date
Start the new workflow at the beginning of a month when possible. Reconcile all prior Shopify activity first, then begin automated posting with a known clearing-account balance.
Do not import older orders into periods that already contain manual summaries or earlier automated entries. That is one of the fastest ways to double-count revenue.
6. Reconcile the first payout cycle before relying on automation
After the first set of payouts posts, match each payout to the related bank deposit. Then review the clearing account.
The clearing account should reflect:
- Customer payments received
- Processing fees
- Refunds and chargebacks
- Payouts transferred to the bank
- Any open timing differences
If the balance does not clear after completed payouts, trace the difference before moving forward. The issue is usually a missing fee, refund, payout, duplicate entry, or transaction posted in the wrong period.
Keep a Weekly and Monthly Reconciliation Routine
Automation reduces data entry. It does not remove the need to review settlement activity.
Use a simple schedule:
- Weekly: Review failed syncs, unmatched payouts, refunds, and unusual clearing-account balances.
- Monthly: Reconcile the bank account and Shopify clearing account through the month-end date.
- When adding a payment method: Create its clearing-account and fee rules before it begins processing sales.
- When tax settings change: Confirm that tax still posts to a liability account.
- When discount programs change: Review whether discounts continue to reduce revenue rather than post as operating expenses.
Investigate unmatched payouts that remain open for more than seven days. Small differences are easier to solve while the related orders, refunds, and payout records are still recent.
For month-end balances that remain open because of timing, leave a brief explanation in the reconciliation records. That documentation saves time when reviewing prior periods.
Situations That Need More Than a Basic Order Feed
A Shopify-to-accounting connection is useful for sales and payout activity, but it is not a full accounting design for every business.
Use a broader accounting workflow when the store has:
- Complex inventory valuation
- Multiple legal entities
- Wholesale terms
- Subscription or prepaid service revenue
- Deferred revenue requirements
- Multiple currencies
- Several sales channels that settle separately
- Formal financial reporting requirements
These businesses need accounting rules that cover the full operation, including inventory, receivables, liabilities, revenue timing, and entity-level reporting.
Setup Checklist
Before enabling automatic posting, make sure these rules are in place:
- Gross sales, discounts, shipping income, and sales tax post to separate accounts.
- Each payment method has a defined clearing-account path.
- Merchant fees post as expenses rather than reducing sales revenue.
- Refunds and chargebacks have a documented accounting treatment.
- Gift card sales post to a liability account until redemption.
- Bank deposits match recorded payouts.
- A cutover date prevents duplicate historical entries.
- Completed payouts clear through the Shopify clearing account.
- Inventory and cost-of-goods-sold entries follow a separate, consistent process.
- Someone reviews unmatched items every week.
Common Mistakes to Avoid
The bank feed shows the final deposit. It does not explain the sales, tax, discounts, refunds, and fees behind that deposit.
Avoid these common errors:
- Posting net payouts as revenue: This hides payment fees and understates gross sales.
- Recording sales tax as income: This overstates profit and understates tax liabilities.
- Syncing the same period twice: Historical imports and automated feeds can both post the same sales activity.
- Ignoring refunds until month end: Refunds create clearing-account differences that become harder to trace after several payout cycles.
- Using one clearing account for every channel without references: Marketplace, wholesale, Shopify, and alternate payment activity become harder to reconcile.
- Changing mappings in the middle of a month without documentation: Financial reports can stop aligning across periods.
- Treating inventory as solved by the sales sync: Sales entries do not replace inventory, purchase, return, and cost-of-goods-sold processes.
Keep account names stable, document exceptions, and change one mapping rule at a time. Consistency makes both reconciliation and reporting much easier.
Bottom Line
For most established Shopify stores, a daily summary workflow with a dedicated clearing account provides clean books without filling the general ledger with individual orders. Move to order-level syncing when the business needs transaction-level reporting for inventory, channels, customers, or profitability.
The key is to keep gross sales, taxes, discounts, fees, refunds, and payouts separate. When every completed payout can be traced from Shopify through the clearing account to the bank, the integration is doing its job.
FAQ
Should Shopify sales be recorded by order or by payout?
Record sales by order or daily sales summary, then record payouts separately through a clearing account. A payout settles sales activity; it is not the sale itself. Order-level records support detailed reporting, while daily summaries keep the accounting system less cluttered.
Why does my Shopify clearing account not reconcile to zero?
A nonzero clearing balance usually comes from a missing payout, merchant fee, refund, chargeback, duplicate entry, or transaction posted in a different period. Match each payout to its bank deposit, then compare the remaining balance with unpaid orders and pending adjustments.
Should sales tax from Shopify count as revenue?
No. Sales tax collected from customers belongs in a sales-tax liability account until remittance. Keep product sales, shipping income, discounts, and tax separate so revenue and tax obligations remain accurate.
How often should Shopify payouts be reconciled?
Review payouts within seven days and complete a full bank and clearing-account reconciliation every month. Stores with daily payouts and high order volume benefit from more frequent review because small differences can build quickly.
Do refunds need separate accounting entries?
Yes. Refunds should reduce the original sale and reverse related sales tax where appropriate. Review how payment fees are handled as well, since refund-fee treatment does not always follow the same pattern as the original sale.