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
Unlock AI Intelligence, score breakdowns, and real-time alerts
Upgrade to Pro — $29.99/moClient
Spent: $47,478.28Rating: 4.3Verified