Ecommerce Bookkeeper Needed for Shopify + Amazon Brand (QuickBooks Online + A2X)

Posted last month

Worldwide

Summary

We're a DTC home and wellness brand (think candles, diffusers, and a few wood home goods) doing about $3.2M in annual revenue, split roughly 60% on our Shopify store and 40% on Amazon (FBA). We carry around 30 SKUs and use a 3PL plus Amazon FBA for fulfillment. Here's the honest situation: I've been doing the books myself in QuickBooks Online and I'm in over my head. Our Amazon deposits come in as these huge lump sums and I have no real idea how to split out the fees, refunds, and ad spend. Our COGS is basically a guess, so I genuinely don't know our true margin by channel. We're about 4 months behind, and our CPA already told me last year that the books were "not clean enough to file from" without a cleanup. I do not want a repeat of that. What we need help with: Clean up and catch up the last ~4 months in QuickBooks Online Set up and run A2X to properly reconcile Amazon and Shopify payouts Get COGS and inventory tracked accurately so I can see real margins Monthly bank, credit card, and payout reconciliations A monthly close with P&L, balance sheet, and ideally a channel-by-channel view Deliver books each month that our tax accountant can actually file from Our stack: QuickBooks Online, Shopify, Amazon Seller Central, Stripe, PayPal, Gusto (payroll), and a 3PL. Open to adding A2X or whatever you recommend. You're a great fit if you: Have done bookkeeping specifically for multi-channel ecommerce sellers (Shopify + Amazon), not just general small business Understand Amazon settlement reconciliation cold Are accurate, reliable, and communicate proactively (I don't want to chase you) A CPA or equivalent credential is a big plus — I'd rather pay more for someone I can trust with this This would start with a cleanup project and move into an ongoing monthly engagement if it goes well. US-based preferred for timezone overlap. Looking forward to hearing how you'd approach this. — Jenna

  • Less than 30 hrs/week
    Hourly
  • 3-6 months
    Duration
  • Expert
    Experience Level
  • $45.00

    -

    $65.00

    Hourly
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Microsoft Excel
Data Entry
Nice-to-have skills
Bookkeeping
Accounting
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:2 weeks ago
  • Interviewing:
    0
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Jan 20, 2025
  • United States
    San Francisco4:47 AM

Explore similar jobs on Upwork

Handyman/Property Manager for RentalHourly‐ Posted 2 weeks ago
Customer Service
Administrative Support
Phone Communication
Email Communication
Bookkeeping
Intuit QuickBooks
Accounting
Financial Accounting

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo