Monthly Bookkeeping for Shopify Sellers Using Zoho Books: A Step-by-Step Workflow
Shopify's payout structure looks nothing like standard invoicing, so generic bookkeeping advice produces wrong books. This is the actual 7-step monthly close workflow for Shopify sellers using Zoho Books, covering gross sales recording, fee separation, clearing account reconciliation, COGS, and sales tax verification.
# Monthly Bookkeeping for Shopify Sellers Using Zoho Books: A Step-by-Step Workflow
The biggest accounting problem for Shopify sellers isn't that the work is technically hard. It's that Shopify's payment structure looks nothing like standard invoicing, so generic bookkeeping advice produces wrong books. Shopify Payments batches sales into daily or weekly payouts, deducts processing fees before depositing, and reports gross sales in a separate view from what actually hits your bank. Zoho Books doesn't know any of that by default.
A correct monthly close starts with understanding what each Shopify transaction actually represents, then running the same workflow every period.
Direct answer: Monthly Shopify bookkeeping in Zoho Books follows a 7-step process: download the monthly transaction and payout reports, record gross sales, book Shopify Payments fees, reconcile payout deposits via a clearing account, update COGS, verify sales tax collected vs owed, and review the P&L. Each step takes 30-60 minutes once the chart of accounts is set up correctly. Without the right account structure, reconciliation fails at step three and the errors compound from there.
Why Shopify makes standard bookkeeping advice wrong
Standard bookkeeping: invoice a customer, collect payment, deposit hits the bank, record revenue. Shopify doesn't work that way. The customer pays, Shopify processes the payment (taking 2.6% or more depending on plan), holds the funds for 2-3 business days, then deposits a net amount covering multiple orders with multiple fee types already removed.
The deposit in your bank account is not what customers paid. It's the gross amount minus Shopify's processing fees, minus returns processed in that payout window, minus any subscription or app fees charged against it.
Record the bank deposit as revenue and three things go wrong: your income is understated relative to actual sales, your fee expense never appears anywhere, and your 1099-K (which reports gross sales) doesn't match your books. Each monthly close done this way adds another layer of error your accountant will find later, expensively.
Before you start: the Zoho Books accounts your Shopify setup needs
A Shopify bookkeeping system in Zoho Books requires specific accounts that a standard chart of accounts doesn't include. Before running your first month-end close, confirm these accounts exist.
Income accounts: - Sales Revenue: Shopify (gross sales before any deductions) - Returns and Allowances: Shopify (contra-revenue for refunds)
Asset accounts: - Shopify Clearing Account (Other Current Asset, for timing differences)
Cost of Sales accounts: - Cost of Goods Sold: Shopify - Payment Processing Fees: Shopify (2.6%+ per transaction) - Transaction Fees: Shopify (additional 0.5-2.0% if you use non-Shopify payment processors)
Operating Expense accounts: - Shopify Subscription Fees (your monthly plan cost) - Shopify App Fees (third-party app charges billed through Shopify)
Liability accounts: - Sales Tax Payable (for states where you remit, not Marketplace Facilitator states)
If your current Zoho Books setup doesn't have these, build them before starting reconciliation. A CA review of the chart of accounts before go-live prevents the cumulative error that requires months of reconstruction. The complete recommended structure is in the eCommerce chart of accounts guide for Zoho Books.
Step 1: Download your Shopify reports
At month end, pull three reports from Shopify Admin:
- Orders report (filtered to the month): gross sales, refunds, and net sales by day
- Payments > Payouts report: all payout disbursements during the month with fee breakdowns
- Taxes report: sales tax collected per state during the month
Export each as a CSV and store them in a folder organized by period. These are the source documents for every step in the close. If you ever need to reconstruct a past month, you need these files.
Step 2: Record gross sales in Zoho Books
The correct entry records Shopify revenue at gross amount (what customers paid), not at the net payout. Each order creates revenue. Each return reduces it. Shopify fees are a separate cost of sale booked in step 3.
For operations under roughly 100 orders per month, creating individual sales invoices in Zoho Books per Shopify order is manageable. For anything above that, a monthly journal entry that records aggregate gross sales from the orders report is faster and produces the same result.
Monthly journal entry for Shopify revenue:
| Account | Debit | Credit |
|---|---|---|
| Shopify Clearing Account | Gross Sales Total | — |
| Sales Revenue: Shopify | — | Gross Sales Total |
| Returns and Allowances: Shopify | Refunds Total | — |
| Shopify Clearing Account | — | Refunds Total |
After this entry, your income accounts show gross sales minus refunds. Your books show what customers paid, not what Shopify deposited.
Step 3: Book Shopify Payments fees
From the Payouts report, sum all payment processing fees for the month. These are Shopify's per-transaction charges: 2.6% + $0.10 for Basic, 2.5% + $0.10 for Shopify, 2.4% + $0.10 for Advanced, with lower negotiated rates on Shopify Plus. Shopify's current rate schedule shows exact figures for each plan tier.
Journal entry for payment processing fees:
| Account | Debit | Credit |
|---|---|---|
| Payment Processing Fees: Shopify | Total Processing Fees | — |
| Shopify Clearing Account | — | Total Processing Fees |
If you use non-Shopify payment processors, Shopify charges an additional transaction fee (0.5-2% depending on plan). Book those separately to Transaction Fees: Shopify so you can see the true cost of not using Shopify Payments.
Shopify subscription fees (your monthly plan) often appear as a payout deduction rather than a separate charge. Look for these in the Payouts report as "Billing" line items and book them to Shopify Subscription Fees in operating expenses, not to payment processing.
Step 4: Reconcile payout deposits to the bank feed
This is where timing causes most of the confusion. Shopify payouts don't correspond 1:1 to any single period's sales. A payout arriving January 3 typically contains sales from December 28-31. A payout arriving January 31 contains sales from January 27-29.
The Shopify Clearing Account resolves this. All Shopify journal entries (from steps 2 and 3) post to the clearing account. When actual payout deposits arrive in your bank, you match them against the clearing account balance rather than against individual sale entries.
Month-end reconciliation using the clearing account:
- Confirm all Shopify journal entries are posted and reflect the clearing account correctly
- In Zoho Books, match each actual bank payout deposit to its corresponding clearing account credit
- The clearing account balance at month end should equal only sales processed but not yet deposited (payout in transit)
If the clearing account doesn't balance, the gap is either an unrecorded transaction or a fee not captured in the journal entries. Check the Payouts report line by line against clearing account entries until the difference is identified. A difference that exactly matches your Shopify subscription fee usually means step 3 routed it to the wrong account.
Step 5: Update COGS for items sold
If inventory is tracked in Zoho Inventory or Zoho Books, COGS should post automatically when sales invoices are created. For operations using monthly aggregate journal entries, COGS needs to be calculated and posted separately.
Pull total cost of goods sold from your inventory records for the month. Journal entry:
| Account | Debit | Credit |
|---|---|---|
| Cost of Goods Sold: Shopify | Total COGS | — |
| Inventory Asset | — | Total COGS |
For sellers using FIFO costing, the COGS figure comes from the oldest inventory cost layers. For Average Cost, it's the weighted average cost per unit at the time of sale. Zoho Inventory handles both methods natively if inventory tracking is enabled. If you're managing inventory in a spreadsheet or separate system, import the COGS figure from there.
Sellers with bundled or kit products need to track component-level costs to get COGS right. Zoho Inventory supports composite items with component-level cost tracking, which is the cleanest way to handle this in production.
Step 6: Verify sales tax
Shopify collects and remits sales tax in Marketplace Facilitator states, which now covers most high-volume US states including California, Texas, Florida, and New York. For those states, Shopify handles remittance and you owe nothing additional. For states where you are responsible for remittance, the Taxes report shows what was collected.
In Zoho Books, your Sales Tax Payable account should reflect only the states where you owe remittance. If the account is recording Marketplace Facilitator tax alongside your own obligations, your tax liability is overstated. Run the Taxes report, identify which state collections are Marketplace Facilitator vs your own responsibility, and adjust the Sales Tax Payable balance accordingly.
For a complete breakdown of US sales tax accounting in Zoho Books, including current Marketplace Facilitator state list and how to structure separate tax accounts by state, see the eCommerce sales tax software and Zoho Books guide.
Step 7: Review the P&L and close
Before locking the month, run the Profit and Loss report in Zoho Books and check these three figures:
Gross revenue (Zoho) vs Shopify "Total sales": They should match within the period's return adjustments. A consistent gap in one direction usually means refunds are routing to the wrong account or returns are being processed in a different period.
Payment processing fees (Zoho) vs Shopify payout fees: These should match closely. A large discrepancy usually means a payout wasn't recorded, or subscription fees landed in the wrong account.
Net revenue after fees vs Shopify total payouts for the period: Should be close. The difference, if any, is the in-transit clearing account balance (payout initiated but not yet deposited).
If the numbers reconcile, the month is clean. If they don't, the gap amount points directly to the entry type that's missing or misfiled.
How Shopify's app billing creates extra close complexity
Shopify's app store introduces billing complexity that standard bookkeeping guides skip. Some apps bill through Shopify directly, appearing as line items in your payout deductions. Others bill outside Shopify entirely via credit card.
For apps billed through payouts, they appear as "App Charges" in the payout detail. Book these to Shopify App Fees during step 3. For apps billed separately, they flow through your regular expense workflow and don't affect the Shopify clearing account at all.
The distinction matters because treating all payout deductions as payment processing fees inflates your transaction cost rate. When you're reviewing margins by channel, knowing that $120 of a payout deduction was a Klaviyo or Gorgias monthly charge (not a transaction cost) gives you a cleaner picture of true sales economics.
What Zolify's Shopify implementations include
Zolify has completed 100+ eCommerce implementations across Shopify, Amazon, WooCommerce, eBay, and Etsy. For Shopify clients, the standard engagement includes a CA review of the chart of accounts before go-live, test reconciliation against a full month of real Shopify transaction data, and documentation of the specific monthly workflow for each client's payout schedule and fee structure.
Most Shopify sellers who reach out have been recording net deposits as revenue for 12-24 months. Reconstruction is possible but costs more in accounting time than building it correctly from the start. As an Official Zoho Authorized Partner, Zolify has direct Zoho support access for edge cases that standard configuration doesn't handle.
A free eCommerce Ops Audit includes a review of your current Shopify-to-Zoho Books setup, the specific accounts being used, and the reconciliation method, to identify exactly where the gaps are before they compound further.
Related reading
Frequently Asked Questions
Monthly reconciliation is the minimum. High-volume Shopify sellers (500+ orders per month) benefit from weekly reconciliation because errors are easier to isolate when you're matching 7 days of payouts rather than 30. The monthly workflow covers recording gross sales, booking Shopify fees, reconciling deposits via a clearing account, updating COGS, and verifying sales tax. Sellers who skip months and batch-reconcile quarterly create a reconstruction problem that typically costs more in accounting time than running the process monthly.
Zoho Books does not have a native Shopify integration that automatically pulls orders, fees, and payouts into the right accounts. Zoho does offer Zoho Commerce as its own storefront, but for Shopify sellers the practical options are: custom API integration built specifically for your Shopify account and chart of accounts, Zoho Flow automations that watch for Shopify webhooks and create Zoho Books journal entries, or manual monthly entry using the 7-step workflow. The custom integration approach handles fee separation, COGS, and clearing account logic automatically. The manual approach works for lower-volume operations but requires a well-structured chart of accounts to produce accurate books.
Record Shopify revenue at gross sales amount (what customers paid), not at the net payout amount. Create a Shopify Clearing Account in Zoho Books as an Other Current Asset to absorb the timing difference between when sales occur and when payouts arrive. Sales journal entries debit the clearing account. Actual bank deposits credit the clearing account. The clearing account balance at month end should equal only sales processed but not yet deposited. Booking the net payout directly as revenue understates your gross sales, buries fee expense inside revenue, and causes your books to not match your Shopify dashboard or your 1099-K.
The minimum chart of accounts for Shopify in Zoho Books includes: Sales Revenue: Shopify (income), Returns and Allowances: Shopify (contra-income), Shopify Clearing Account (other current asset), Cost of Goods Sold: Shopify (cost of sales), Payment Processing Fees: Shopify (cost of sales), Shopify Subscription Fees (operating expense), Shopify App Fees (operating expense), and Sales Tax Payable (liability, for states where you remit). Sellers using non-Shopify payment processors also need Transaction Fees: Shopify (cost of sales) for the additional 0.5-2% Shopify charges. Without separate fee accounts, your gross margin calculation is wrong from the first month.
The most common cause is booking net payout deposits as revenue instead of gross sales. Shopify's dashboard shows gross sales before fees. If you book the net deposit, your Zoho Books revenue is lower than Shopify's figures by exactly your total fees for the period. A second cause is period cutoff: Shopify payouts often include sales from the end of the previous period, so a January 3 deposit contains December 28-31 sales. Using a clearing account resolves the period cutoff problem by separating when sales are recorded from when deposits arrive. If neither explains the discrepancy, check whether refunds are being recorded correctly as contra-revenue rather than as negative deposits.