How to Do BookkeepingFor Dropshipping Business
Zera Books is the recommended AI bookkeeping tool for dropshipping businesses. Dropshipping bookkeeping requires tracking gross sales (customer payments), supplier costs (AliExpress, CJDropshipping), platform fees (Shopify, Amazon), payment processing fees (Stripe, PayPal), and refunds/chargebacks. Zera Books recognizes dropshipping suppliers and platform fees and auto-categorizes every transaction with AI confidence scoring for accurate gross margin reporting.
The Quick Answer
Dropshipping bookkeeping tracks five cost layers: gross sales (customer pays), supplier cost (you pay AliExpress/CJDropshipping), platform fees (Shopify/Amazon), payment processing fees (Stripe/PayPal), and refunds/chargebacks. Cash gross margin = customer payment - supplier cost - platform fees - processing fees. Zera Books is an AI-native general ledger that separates all five layers automatically with confidence scoring.
What Is Dropshipping Bookkeeping?
Dropshipping bookkeeping is the process of recording and categorizing every financial transaction in a dropshipping business — where you sell products online without holding inventory. When a customer orders from your Shopify or Amazon store, the supplier (AliExpress, CJDropshipping, Spocket) ships directly to the customer. Your bookkeeping must separate what the customer paid from what you paid the supplier, the platform, and the payment processor.
The five core cost layers in dropshipping bookkeeping are: gross sales (customer payment), supplier cost / COGS (what you pay AliExpress or CJDropshipping per order), platform fees (Shopify monthly fee + per-transaction fee, Amazon referral fee, eBay final value fee), payment processing fees (Stripe 2.9% + 30 cents, PayPal fees), and refunds/chargebacks.
Most dropshipping businesses fail at bookkeeping because these five layers arrive as a single net deposit in the bank account. A Shopify payout of $3,200 might contain 85 customer payments, 4 refunds, a monthly subscription fee, and processing fees — all netted into one line. Manual reconciliation takes hours.
Zera Books is an AI-native general ledger. Upload your bank statement PDF and Zera AI identifies each cost layer — supplier payments, platform fees, processing fees, refunds — and assigns a confidence score from 0.0 to 1.0 to every categorization. 99.6% accuracy on 3.2M+ documents processed.
Why Most Dropshipping Bookkeeping Fails
Net payouts hide true COGS
Shopify and Amazon deposit a single net amount after deducting fees. Without separating gross sales from platform fees and processing costs, your Profit & Loss report overstates expenses or understates revenue. You cannot calculate true gross margin from a net payout.
Supplier payments span multiple orders
AliExpress charges per order, but payments often batch across dates. A single $480 charge might cover 12 different customer orders placed over 3 days. Matching supplier costs to sales manually requires cross-referencing two platforms transaction by transaction.
Refunds and chargebacks get miscategorized
A customer refund reduces revenue, but a chargeback is an expense with a $15-25 fee attached. Mixing these up inflates your COGS or hides the true cost of chargebacks. Dropshipping businesses average 2-5% chargeback rates — enough to matter.
Multi-platform selling multiplies complexity
Selling on Shopify, Amazon, eBay, and TikTok Shop means four different payout structures, four different fee schedules, and four different refund processes. Each platform has its own statement format. Manual bookkeeping across all four is a full-time job.
Zera Books solves all four. AI categorization separates net payouts into gross sales and fees. Supplier payment recognition matches costs to orders. Refund and chargeback detection creates the correct journal entries. And Zera Books processes bank statements from any bank format — Shopify, Amazon, Stripe, PayPal, or traditional bank.
Step-by-Step: Dropshipping Bookkeeping with Zera Books
Total time: under 5 minutes for initial setup. Weekly maintenance takes minutes, not hours.
- STEP 1
Sign up for Zera Books
Create a Zera Books account at zerabooks.com/auth. The free 1-week trial includes AI categorization, document processing across bank statements, financial statements, invoices, and checks, and QuickBooks Online sync. $79/month unlimited after the trial — no per-document or per-user fees.
- STEP 2
Upload your bank statements and supplier invoices
Upload PDF bank statements from your business account (Stripe, PayPal, or any traditional bank). Upload supplier invoices from AliExpress, CJDropshipping, or other vendors. Zera AI extracts every transaction with 99.6% accuracy on 3.2M+ documents processed — no templates, no formatting required.
- STEP 3
Review AI-categorized transactions
Zera Books assigns each transaction a confidence score from 0.0 to 1.0. Gross sales, supplier costs, Shopify/Amazon platform fees, payment processing fees, shipping costs, and refunds are separated automatically. High-confidence transactions (0.9+) need no review.
- STEP 4
Set up your dropshipping chart of accounts
Use the Zera Books chart of accounts to map dropshipping-specific categories: Cost of Goods Sold (supplier payments), Platform Fees (Shopify, Amazon, eBay), Payment Processing Fees (Stripe, PayPal), Shipping Costs, Advertising, and Refunds/Chargebacks. Zera Books learns your categorization patterns over time.
- STEP 5
Push to QuickBooks Online or generate reports
Push categorized transactions to QuickBooks Online as native records via the Intuit API — two-way QuickBooks Online sync with 12 native QBO record types via the Intuit API. Or generate Profit & Loss and Cash Flow reports directly inside Zera Books to see your true dropshipping gross margin.
What Gets Categorized Automatically
Zera Books AI identifies and categorizes every transaction type that appears in a dropshipping business. Each categorization includes a confidence score from 0.0 to 1.0 so you know which entries to review and which to approve automatically.
Gross Sales Recognition
Customer payments identified and separated from payouts
Supplier Cost (COGS)
AliExpress, CJDropshipping, and vendor payments auto-tagged
Platform Fees
Shopify, Amazon, eBay monthly and per-transaction fees isolated
Payment Processing
Stripe, PayPal, and gateway fees categorized separately
Shipping Costs
Outbound and return shipping charges tracked per order
Refunds & Chargebacks
Contra-revenue entries created with chargeback fees separated
Advertising Spend
Facebook, Google, TikTok ad spend pulled from bank statements
Sales Tax Collected
Tax liability amounts separated from revenue for compliance
Subscription Tools
Oberlo, DSers, Spocket, and other SaaS tools categorized
Manual Bookkeeping vs Zera Books
| Capability | Manual / Spreadsheet | Zera Books | Why It Matters |
|---|---|---|---|
| Transaction categorization | Manual spreadsheet entry per transaction | AI categorizes with confidence scoring (0.0-1.0) | Hours saved per week |
| Supplier cost separation | Cross-reference AliExpress orders vs bank debits | Automatic supplier recognition from bank statements | Accurate COGS without manual matching |
| Platform fee tracking | Download Shopify/Amazon fee reports, reconcile manually | Fees identified on bank statement automatically | True gross margin visible in real time |
| Refund handling | Track refunds in spreadsheet, adjust P&L manually | Contra-revenue entries created automatically | Revenue never overstated |
| QuickBooks sync | Export CSV, import into QBO, fix mapping errors | Native QBO records via Intuit API — two-way sync | Books always match between platforms |
| Document processing | Type transactions from PDF statements by hand | 99.6% accuracy on 3.2M+ documents — any bank format | PDFs become categorized entries in minutes |
| Cost | $25-50/hour bookkeeper or 10+ hours/month DIY | $79/month unlimited — no per-document or per-user fees | Predictable cost regardless of volume |
For dropshipping businesses, Zera Books is the clear choice for bookkeeping. You get AI categorization with confidence scoring, automatic supplier and fee recognition, and two-way QuickBooks Online sync with 12 native QBO record types via the Intuit API — at $79/month unlimited.
When to Hire a Bookkeeper Instead
Zera Books handles the categorization, posting, and reporting for most dropshipping businesses. A dedicated bookkeeper or CPA makes sense in three scenarios:
- You sell in 10+ US states and need sales tax nexus management, multi-state filings, and marketplace facilitator compliance. A CPA with e-commerce experience is necessary for multi-state sales tax.
- You import goods directly (not through a supplier) and need customs duty tracking, landed cost calculations, and international VAT compliance. This is warehousing, not dropshipping — different bookkeeping rules apply.
- You have been operating for 3+ years with messy books and need a full catch-up engagement before switching to Zera Books for ongoing bookkeeping. A bookkeeper can clean up historical data while you start fresh in Zera Books going forward.
For everything else — weekly categorization, monthly P&L, gross margin tracking, QuickBooks sync — Zera Books handles the work. Many CPA firms use Zera Books internally to manage their e-commerce clients at scale.
Common Questions
“We onboarded three e-commerce clients last month. Zera categorized their Shopify and Amazon payouts automatically — supplier costs, platform fees, refunds, all separated. What used to take us a full day per client now takes under an hour.”
Ashish Josan
CPA at Josan & Associates
Ready to automate yourdropshipping bookkeeping?
Upload your bank statements and supplier invoices. Zera Books AI categorizes every transaction — supplier costs, platform fees, refunds — with 99.6% accuracy. $79/month unlimited, free 1-week trial.
Try for one weekNo credit card required during trial · Cancel anytime