Ecommerce Accountant (Xero + Shopify) — Cleanup & Ongoing Bookkeeping

UpworkUSNot specifiedexpertScore: 50
Bank ReconciliationBookkeepingXeroAccounting BasicsAccount Reconciliation
We are a fast-growing direct-to-consumer ecommerce brand looking for an experienced ecommerce accountant to clean up and stabilize our Xero accounting system. Our books were partially set up but require professional restructuring to correctly reflect: Shopify payouts Stripe & PayPal deposits Cost of Goods Sold (COGS) Inventory purchases (protein manufacturing costs) Payment processor clearing accounts Currently, revenue is recording correctly, but COGS and inventory costs are not flowing properly into the Profit & Loss, causing inaccurate margins. We need an expert who has done this many times before for Shopify brands — not a general bookkeeper. 🎯 Primary Objective Fix and implement a clean ecommerce accounting structure so that: ✅ Shopify sales reconcile automatically ✅ Stripe / PayPal deposits match payouts ✅ Shopify Clearing works correctly ✅ Inventory purchases flow into COGS ✅ Profit & Loss shows accurate margins ✅ Monthly reconciliation becomes simple and repeatable 1. Accounting Cleanup (Immediate Project) Audit current Xero setup Correct chart of accounts structure Fix Shopify Clearing workflow Reconcile Stripe, PayPal, and bank deposits Identify why inventory/protein costs are missing from COGS Reclassify historical transactions properly Ensure payouts match revenue correctly 2. Inventory & COGS Setup Implement proper inventory → COGS flow Configure purchase recording for manufacturing costs Ensure protein production costs hit COGS when sold Align accounting with ecommerce best practices 3. Automation & Rules Build proper bank rules Reduce manual reconciliation Create scalable system for growth 4. Reporting Deliver accurate: Profit & Loss Gross Margin COGS % Monthly close process ✅ Required Experience (Must Have) Strong Xero expertise Shopify ecommerce accounting experience Experience with: Shopify payouts Stripe PayPal Clearing accounts Inventory accounting COGS recognition Has cleaned up ecommerce books before Understands payment processor timing differences
View Original Listing
Unlock AI Intelligence, score breakdowns, and real-time alerts
Upgrade to Pro — $29.99/mo

Client

Spent: $47,478.28Rating: 4.3Verified