Shopify Ecommerce P&L Analyst / Bookkeeper
Worldwide
We are a growing Shopify ecommerce company looking for a detail-oriented P&L analyst to maintain our daily profit and loss reporting. This is an ongoing position. We are looking for someone who can update our financial dashboard daily and provide accurate reporting on store performance. Responsibilities - Update our daily P&L spreadsheet - Pull revenue data from Shopify - Pull ad spend data from Meta Ads Manager - Pull ad spend data from TikTok Ads Manager - Track product costs and cost of goods sold - Track Stripe and payment processor fees - Track refunds and chargebacks - Track app/software expenses - Calculate daily, weekly, and monthly profit - Verify numbers are accurate and report discrepancies - Maintain organized financial records Requirements - Experience with Shopify - Experience with Meta Ads Manager - Experience with TikTok Ads Manager - Strong Google Sheets skills - Experience maintaining ecommerce P&L statements - Strong attention to detail - Fluent written English - Ability to work independently Nice to Have - Ecommerce bookkeeping experience - QuickBooks experience - Experience working with dropshipping or ecommerce brands - Understanding of contribution margin and net profit calculations Deliverables Each day you will provide: - Revenue - Ad Spend - Product Costs - Payment Processor Fees - Refunds/Chargebacks - App Costs - Daily Profit/Loss - Monthly Profit/Loss You will update our existing Google Sheets P&L dashboard and ensure all numbers are accurate. Please begin your application with: "I have ecommerce P&L experience." Then answer the following: - Have you worked with Shopify stores before? - Have you worked with Meta Ads and TikTok Ads reporting? - What ecommerce brands have you worked with? - What tools have you used for bookkeeping and financial reporting? We are looking for a long-term team member.
- More than 30 hrs/weekHourly
- 6+ monthsDuration
- IntermediateExperience Level
$4.00
-
$6.00
Hourly- Remote Job
- Ongoing projectProject Type
Skills and Expertise
Activity on this job
- Proposals:5 to 10
- Last viewed by client:last week
- Interviewing:1
- Invites sent:0
- Unanswered invites:0
About the client
- United StatesClackamas6:05 PM
- $2.8K total spent7 hires, 6 active
- 555 hours
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