QuickBooks Expert for Shopify & Manufacturing
Only freelancers located in the U.S. may apply.U.S. located freelancers only
Job Title QuickBooks Expert for Shopify & Light Manufacturing | Inventory Specialist (Pre-Launch) Job Overview We are a growing hardware startup seeking a meticulous, senior-level Bookkeeper to manage the financial infrastructure for our product, which is currently in the pre-launch phase. We assemble our units in-house from approximately 40 individual components imported from China and sell directly to consumers via Shopify.We need a specialist who understands that bookkeeping for a manufacturing company isn't just about tracking cash—it’s about accurate inventory valuation and protecting our margins. Key Responsibilities Inventory & BOM Management: Track a Bill of Materials (BOM) consisting of 40 components. You will manage the valuation transition from "Raw Materials" to "Finished Goods" as we build stock.Landed Cost Accounting: Accurately capitalize Chinese supplier invoices, ocean freight, customs duties, and import fees into the inventory asset value rather than expensing them immediately.Shopify Reconciliation: Reconcile daily Shopify Payments payouts, ensuring gross sales, processing fees, and refunds are correctly mapped to QuickBooks Online.Inventory Valuation: Maintain accurate records using the Moving Average Cost (MAC) method or specific identification to ensure our COGS reporting is flawless.Month-End Close: Perform full-cycle reconciliation of our business checking and credit accounts, providing monthly P&L and Balance Sheet reports.Required Qualifications QuickBooks Online Plus Expertise: Deep familiarity with the 2026 "Modern View" reporting and advanced inventory modules. Manufacturing Background: Proven experience handling light manufacturing or assembly-based businesses. You must understand how to record the assembly process via manual journal entries or third-party integrations.E-Commerce Specialist: Expert-level knowledge of Shopify accounting, specifically handling the "net deposit" reconciliation of Shopify Payments.Landed Cost Knowledge: Experience with international trade accounting and the proper capitalization of import-related costs. Preferred Skills: C ertified QuickBooks ProAdvisor.Experience with inventory apps (e.g., Katana, SOS Inventory, or Stocky).Ability to advise on SKU mapping and internal inventory audit workflows. Engagement Details Project Type: Hybrid (One-time setup project followed by an ongoing monthly retainer).Estimated Hours: 5–10 hours for initial setup; 4–6 hours per month thereafter. Budget: We are looking for an expert and are prepared to pay a competitive hourly rate commensurate with manufacturing accounting experience.Application Questions: How do you handle the reconciliation of a Shopify payout that includes multiple orders, refunds, and merchant fees into a single bank deposit?Describe your process for allocating ocean freight and customs duties to the unit cost of 40 different components.Which third-party inventory tools or manual workflows do you recommend for tracking assemblies in QuickBooks Online Plus?
- More than 30 hrs/weekHourly
- 1-3 monthsDuration
- IntermediateExperience Level
$40.00
-
$60.00
Hourly- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:10 to 15
- Last viewed by client:3 weeks ago
- Interviewing:0
- Invites sent:0
- Unanswered invites:0
About the client
- United States1:16 PM
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers 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