Vatteo accounting library

Shopify accounting guides.

Page 2 of practical payout and QuickBooks guidance.

QuickBooks setup

A Shopify chart of accounts for QuickBooks Online

Use this practical Shopify chart of accounts to organize sales, clearing, fees, refunds, tax, gift cards, inventory and COGS in QuickBooks Online.

9 min read
Profit and inventory

How to calculate and record Shopify COGS in QuickBooks

Calculate Shopify cost of goods sold by SKU, handle refunds and changing product costs, and record the inventory-to-COGS entry in QuickBooks Online.

9 min read
Gift cards and liabilities

How to account for Shopify gift cards in QuickBooks

Record Shopify gift-card sales, redemptions, refunds and outstanding balances in QuickBooks without recognizing revenue twice or losing the liability.

9 min read
Payment reconciliation

How to reconcile Shopify Payments, PayPal and other gateways

Reconcile Shopify Payments, PayPal and other payment gateways in QuickBooks without mixing deposits, fees, refunds or money still in transit.

9 min read
Multi-currency accounting

Shopify multi-currency accounting in QuickBooks Online

Account for Shopify sales, payouts, refunds and fees across currencies in QuickBooks without inventing exchange rates or losing money in transit.

9 min read
Month-end close

Month-end cut-off for Shopify sales, refunds and payouts

Decide which month Shopify sales, refunds, fees and payouts belong in, then close QuickBooks without losing late activity or moving revenue to the bank date.

9 min read
Shopify reports

How to find and export Shopify payout reports

Find the right Shopify payout, reconciliation and finance reports, export them for QuickBooks, and save a clean month-end evidence package.

9 min read
Bookkeeping

Cash vs accrual accounting for Shopify stores

Choose cash or accrual accounting for a Shopify store without confusing sales, payouts and bank deposits. Includes a worked example and QuickBooks setup.

9 min read
Sales tax

How to reconcile Shopify sales tax with QuickBooks Online

Fix a Shopify sales tax report that does not match QuickBooks. Compare taxable sales, refunds, marketplace tax and liabilities before you file.

9 min read