ECOMMERCE FINANCE, P&L & AUTOMATION MANAGER

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Any

SALARY

800

HOURS PER WEEK

40

DATE UPDATED

Jul 11, 2026

JOB OVERVIEW

We are looking for an experienced Ecommerce Finance, P&L & Automation Manager to manage, improve, and automate our daily, weekly, and monthly financial reporting across all stores, brands, and products.

This is not just a basic bookkeeping role.

We need someone who can give management clear visibility into the financial health of the entire company every day, while also helping automate the reporting process so we can reduce manual work, avoid missing expenses, and make faster business decisions.

Responsibilities

* Update and maintain the company’s Daily P&L sheet
* Prepare daily, weekly, and monthly P&L reports
* Track revenue across all stores and products
* Track COGS across all stores and products
* Track ad spend across all advertising platforms
* Track refunds, chargebacks, disputes, and payment processor fees
* Track app costs, subscriptions, software, tools, and recurring expenses
* Track salaries, contractor payments, and team-related costs
* Track fulfillment costs, shipping costs, and operational expenses
* Track profit and loss by store, product, and brand
* Monitor overall company cash flow
* Identify which stores and products are profitable
* Identify which stores, products, or expenses need management attention
* Create clear reports showing daily, weekly, and monthly company performance
* Make sure all financial data is accurate, complete, and updated on time
* Work with the operations team, media buyers, customer service team, and management to collect missing data
* Improve and organize the company’s P&L reporting system

Automation Requirement

We strongly prefer someone who has experience automating ecommerce financial reporting.

The ideal candidate should be able to help automate the process of pulling, organizing, and reporting financial data from different sources such as:

* Shopify
* Meta Ads
* Google Ads
* PayPal
* Stripe
* Klarna
* Payment processors
* Fulfillment providers
* App subscriptions
* Contractor and salary records
* Refund and chargeback reports
* Google Sheets or Excel dashboards

We want someone who can help build a system where daily, weekly, and monthly P&L reporting becomes faster, cleaner, and more accurate.

Preferred Automation Skills

* Google Sheets automation
* Excel automation
* Google Apps Script
* API integrations
* Zapier
* Make
* Looker Studio
* Dashboard building
* Automated data pulling
* Automated financial reporting
* Ecommerce reporting workflows

Proof Required

Applicants with proof of previous automation work will be prioritized.

Please provide examples of financial reports, dashboards, P&L sheets, or automated reporting systems you have built before.

We want to see real examples showing that you have successfully automated similar finance, ecommerce, or reporting work in the past.

What We Need To See

* Daily company cash flow
* Daily profit or loss
* Weekly profit or loss
* Monthly profit or loss
* Profitability by store
* Profitability by product
* Revenue by store and product
* Ad spend by store and product
* Refunds and chargebacks by store and product
* COGS by store and product
* Fixed expenses
* Variable expenses
* App and subscription costs
* Salary and contractor costs
* Areas losing money
* Areas performing well
* Biggest assets of the company
* Areas that need immediate attention

Requirements

* Strong experience with P&L reporting
* Strong understanding of ecommerce financial reporting
* Experience working with Shopify stores
* Experience tracking revenue, COGS, refunds, chargebacks, ad spend, and expenses
* Experience automating reports or dashboards
* Experience with Google Sheets or Excel
* Strong attention to detail
* Strong analytical skills
* Ability to work with daily deadlines
* Ability to organize messy financial data
* Ability to create clear reports for management
* Ability to identify financial problems and opportunities
* Good communication skills
* Reliable, accurate, and consistent

Preferred Experience

* Experience with ecommerce or dropshipping businesses
* Experience with multiple stores or multiple brands
* Experience with Meta Ads, Google Ads, Shopify, PayPal, Stripe, Klarna, and payment processors
* Experience with cash flow reporting
* Experience with bookkeeping or financial controlling
* Experience creating automated dashboards or automated reports
* Experience connecting multiple data sources into one reporting system

This Role Is For You If

* You are very detail-oriented
* You enjoy working with numbers
* You can update financial reports daily
* You can spot missing expenses or incorrect data
* You can automate repetitive reporting tasks
* You understand that small errors can affect company decisions
* You can clearly explain whether the company is profitable or losing money
* You can help management understand where money is being made and where money is being lost

This Role Is NOT For You If

* You only want to do basic bookkeeping
* You cannot work with daily reporting deadlines
* You have no experience with ecommerce financial reporting
* You have no experience automating reports or dashboards
* You are not comfortable handling multiple stores, products, and expense categories
* You are not detail-oriented
* You cannot organize financial data clearly

To Apply

Please send:

* A short introduction about yourself
* Your experience with P&L reporting
* Your experience with ecommerce or Shopify businesses
* Examples of financial reports, dashboards, or P&L sheets you have created
* Proof of reporting automation work you have done before
* Tools you have used for financial tracking and automation
* Your availability
* Your expected monthly rate

Screening Questions

1. Have you managed daily P&L reporting for an ecommerce company before?

2. What expenses do you usually include when calculating true profit for an ecommerce business?

3. How would you organize P&L reporting for multiple stores and products?

4. Have you automated a financial report, dashboard, or P&L sheet before? Please explain what you built.

5. What tools did you use to automate the reporting process?

6. Can you provide proof or examples of automated financial reports or dashboards you created?

7. How do you make sure all expenses are included and nothing is missing?

8. How would you help management understand which products, stores, or expenses need attention?

Important

We need someone who can give us clear daily, weekly, and monthly visibility into the financial health of the company.

The goal is to know whether the company is profitable or not, where the money is going, which stores and products are performing well, and which areas need improvement.

We strongly prefer someone who can automate this process and provide proof that they have successfully built similar reporting systems before.


VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0009
Controller Execution Time ( Jobseekers / Job )  0.0228
Total Execution Time  0.0243
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,540,768 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/ECOMMERCE-FINANCE-PL-AUTOMATION-MANAGER-1656986
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 15 (0.0167 seconds)  (Hide)
0.0004   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0009   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1656986
 LIMIT 1 
0.0008   SELECT *
FROM `employers`
WHERE `employer_id` = 744023
 LIMIT 1 
0.0008   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1656986
AND `misc`.`idIS NULL 
0.0003   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1656986
AND `misc`.`idIS NULL 
0.0005   SELECT e.business_namee.logoe.websitee.rebill_datee.date_added member_datehitsDATEDIFF('2026-08-21',ej.date_added) duration_daysDATEDIFF('2026-08-21',e.rebill_date) duration_rebillej.*, e.deactivate FROM employers eemployer_jobs ej WHERE e.employer_id ej.employer_id AND
                                   ((
e.user_level >= '500' AND ej.date_added <= e.rebill_date)
                                   OR 
e.employer_id '' OR (ej.date_approved <> '2000-01-01' and DATEDIFF('2026-08-21',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != AND ej.deleted AND job_id '1656986' 
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1656986 
0.0003   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1656986
AND `misc`.`idIS NULL 
0.0015   UPDATE employer_jobs SET hit_counts '***May-28-2026=363***May-29-2026=83***May-30-2026=32***May-31-2026=20***Jun-01-2026=29***Jun-02-2026=20***Jun-06-2026=1***Jun-09-2026=1***Jun-11-2026=2***Jun-12-2026=2***Jun-13-2026=1***Jun-19-2026=1***Jun-20-2026=1***Jun-24-2026=155***Jun-25-2026=34***Jun-26-2026=16***Jun-27-2026=3***Jun-28-2026=6***Jun-29-2026=14***Jun-30-2026=6***Jul-01-2026=4***Jul-02-2026=383***Jul-03-2026=75***Jul-04-2026=42***Jul-05-2026=20***Jul-06-2026=19***Jul-07-2026=12***Jul-08-2026=11***Jul-09-2026=5***Jul-10-2026=4***Jul-11-2026=556***Jul-12-2026=69***Jul-13-2026=71***Jul-14-2026=38***Jul-15-2026=24***Jul-16-2026=8***Jul-17-2026=11***Jul-18-2026=7***Jul-19-2026=1***Jul-20-2026=8***Jul-21-2026=1***Jul-22-2026=4***Jul-23-2026=1***Jul-24-2026=6***Jul-25-2026=8***Jul-26-2026=7***Jul-27-2026=2***Jul-28-2026=3***Jul-30-2026=4***Jul-31-2026=5***Aug-02-2026=3***Aug-03-2026=2***Aug-04-2026=2***Aug-05-2026=1***Aug-07-2026=1***Aug-08-2026=3***Aug-12-2026=2***Aug-13-2026=4***Aug-15-2026=1***Aug-21-2026=1' WHERE job_id'1656986'  
0.0006   UPDATE employer_jobs SET monthly_hits '***May-2026=496***Jun-2026=292***Jul-2026=1409***Aug-2026=20' WHERE job_id'1656986'  
0.0007   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1656986' AND status LIKE 'sent%' ORDER BY id DESC  
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1656986 
0.0088   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '744023'
AND `date_added` >= '2022-06-08' 
0.0003   select from teasers 
0.0003   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)