Shopify E-Commerce Finance Controller — P&L, ROAS & Cashflow for a 12-Store Dropshipping Group

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

: TYPE OF WORK

Full Time

: SALARY

$3-10

: HOURS PER WEEK

20

: DATE UPDATED

May 21, 2026

JOB OVERVIEW

Summary
Shopify E-Commerce Finance Controller — Daily Store P&L, ROAS & Cashflow Reconciliation for a 12-Store Dropshipping Group (Proactive, Self-Directing)

Intro
We run a portfolio of around 12 Shopify dropshipping stores across two entities (Netherlands and US), scaling toward roughly €25M this year. We need someone who lives and breathes Shopify store economics — daily revenue, COGS, ad spend, ROAS, payment fees and refunds — and who can make every store's P&L tie out to the actual cash landing in our accounts. If you have run the numbers behind Shopify dropshipping stores before, this will feel familiar. If you have only done traditional bookkeeping, it will not.

About us
We operate a growing portfolio of Shopify dropshipping stores in fashion and home décor. We launch, scale and sell individual stores, so each one is run as a standalone business unit with its own daily P&L — and each one has to stay sale-ready, meaning a buyer can review clean store-level financials at any ---------- nt. Quiet months run €400K–500K; Black Friday peaks hit €1M–2M. We buy traffic primarily through Google Ads (and Pinterest on some stores), fulfil through a 3PL partner, and run a multi-provider payment stack.

What you'll do

Own the daily P&L for each Shopify store — either filling it directly or coordinating the tea ---------- mber(s) who do, while owning the accuracy either way. Each daily row tracks: Revenue, COGS, Google Adspend, Mediabuying fee, transaction/payment provider fee, refunds, and the resulting Profit, ROAS, Profit %, COGS % and CVR %

Pull supplier and fulfilment invoices from Slack daily and book accurate COGS per store (product + shipping + fulfilment, often combined on one invoice)

Reconcile daily ad spend pulled from the Google Ads and Pinterest accounts against what is logged in each store P&L, and against Shopify revenue and order counts

Track real payment provider fees and payout timing across Shopify Payments, multiple PayPal accounts, PayPal Hong Kong, WOP Payments, Ocean Payments and Airwallex — not estimates
Catch the leaks that distort dropshipping P&Ls: refunds processed through old/disconnected PayPal accounts, chargebacks and dispute fees, FX conversion costs (EUR/USD/HKD), and payout delays — and make the internal P&L reconcile to actual bank cash
Build and own weekly, monthly and quarterly reporting per store and per entity

Evolve our current daily P&L template into a complete, sale-ready store-level reporting standard
Coordinate the existing operational finance team (payments processing and invoice control)

What we're looking for

Hands-on experience running or controlling the financials of Shopify (or comparable DTC) e-commerce stores — this is a hard requirement

You understand store-level unit economics: ROAS, AOV, CVR, COGS %, blended margin, and how ad spend, refunds and payment fees move the real profit number

Comfortable pulling and reconciling data from Shopify, Google Ads, and multiple payment providers in multiple currencies
Strong reconciliation discipline — you know why reported profit and bank cash diverge in an e-commerce business, and how to close the gap

Reliable async communicator inside a remote international team

Nice to have

Dropshipping / 3PL fulfilment invoicing experience
Experience preparing store-level financials for a sale or due diligence (we sell stores)
Yuki (NL) and/or Xero (US) experience

Experience automating Shopify/ad-account/payment-provider data into reporting

The mindset that matters most

We have worked with bookkeepers who fill cells correctly and stop there. That is not enough for a fast-moving store portfolio. We want someone who notices a store's COGS % drifting and digs into why, who spots a refund leak through an old PayPal account before it eats a month of margin, and who proposes and builds improvements to the reporting system on their own initiative. You should be the person who makes the numbers trustworthy without being asked twice.

How to apply
Start your application with the word RECONCILED so we know you read the full post.

Then answer briefly:

Which Shopify or DTC stores' financials have you run or controlled? Give revenue scale and your exact role.
Walk us through how you would find and close a gap between a store's reported P&L profit and the actual cash in the bank.
Would you prefer to do the daily store P&L hands-on, coordinate a team that does it, or both — and why?

SKILL REQUIREMENT

Financial Accounting Shopify Financial Reporting

SHARE THIS POST

Job Post	Reporter	Rank	Reason	Date

BENCHMARKS

Loading Time: Base Classes	0.0007
Controller Execution Time ( Jobseekers / Job )	0.0377
Total Execution Time	0.0390

GET DATA

No GET data exists

MEMORY USAGE

1,524,120 bytes

POST DATA

No POST data exists

URI STRING

jobseekers/job/Shopify-E-Commerce-Finance-Controller-PL-ROAS-Cashflow-for-a-12-Store-Dropshipping-Group-1652491

CLASS/METHOD

jobseekers/job

DATABASE: onlinejobs (Jobseekers:$db) QUERIES: 13 (0.0300 seconds) (Hide)

0.0010	`SELECT * FROM exrates WHERE rate_name = 'USD-PHP'`
0.0010	SELECT * FROM `employer_jobs` WHERE `job_id` = 1652491 LIMIT 1
0.0014	SELECT * FROM `employers` WHERE `employer_id` = 727234 LIMIT 1
0.0014	SELECT COUNT(*) AS `numrows` FROM `t_thread` `t` LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id` WHERE `t`.`job_id` = 1652491 AND `misc`.`id` IS NULL
0.0011	SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-07-14',ej.date_added) duration_days, DATEDIFF('2026-07-14',e.rebill_date) duration_rebill, ej.*, e.deactivate FROM employers e, employer_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-07-14',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '1652491'
0.0009	SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 1652491
0.0013	UPDATE employer_jobs SET hit_counts = '*May-21-2026=126May-22-2026=32May-23-2026=14May-24-2026=8May-25-2026=8May-26-2026=6May-27-2026=2May-28-2026=5May-29-2026=2Jun-01-2026=2Jun-02-2026=15Jun-04-2026=1Jun-06-2026=1Jun-08-2026=1Jun-09-2026=4Jun-13-2026=1Jun-14-2026=1Jun-15-2026=2Jun-19-2026=1Jun-20-2026=1Jun-21-2026=2Jun-23-2026=1Jun-29-2026=1Jul-02-2026=1Jul-03-2026=1Jul-05-2026=2Jul-06-2026=1Jul-07-2026=1Jul-09-2026=1*Jul-14-2026=1' WHERE job_id= '1652491'
0.0012	`UPDATE employer_jobs SET monthly_hits = '*May-2026=203Jun-2026=34**Jul-2026=8' WHERE job_id= '1652491'`
0.0014	`SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '1652491' AND status LIKE 'sent%' ORDER BY id DESC`
0.0009	SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 1652491
0.0168	SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '727234' AND `date_added` >= '2022-06-08'
0.0009	`select * from teasers`
0.0008	`SELECT * FROM skill_categories WHERE skill_cat_id=''`

HTTP HEADERS (Show)

SESSION DATA (Show)

__ci_last_regenerate	1784027699
last_page	https://v1.stage.onlinejobs.ph/jobseekers/job/Shopify-E-Commerce-Finance-Controller-PL-ROAS-Cashflow-for-a-12-Store-Dropshipping-Group-1652491
csrf-token	d44876c9c5c7523aeba79982e80334f4

CONFIG VARIABLES (Show)

base_url	https://v1.stage.onlinejobs.ph
log_threshold	2
enable_profiler
index_page
uri_protocol	PATH_INFO
url_suffix
language	english
charset	UTF-8
enable_hooks	1
subclass_prefix	MY_
composer_autoload	vendor/autoload.php
permitted_uri_chars	a-z 0-9~%.:_\=\-\+\@?\&
enable_query_strings
controller_trigger	c
function_trigger	m
directory_trigger	d
allow_get_array	1
log_path
log_file_extension
log_file_permissions	420
log_date_format	Y-m-d H:i:s
error_views_path
cache_path
cache_query_string
encryption_key	OdBUArjiWg9I7u7bvAwQ7Fu35VB1kzga
sess_driver	files
sess_cookie_name	ci_session
sess_expiration	2678400
sess_save_path
sess_match_ip
sess_time_to_update	300
sess_regenerate_destroy
cookie_prefix
cookie_domain
cookie_path	/
cookie_secure
cookie_httponly
standardize_newlines
global_xss_filtering	1
csrf_protection
csrf_token_name	csrf_test_name
csrf_cookie_name	csrf_cookie_name
csrf_expire	7200
csrf_regenerate	1
csrf_exclude_uris	Array ( )
compress_output
time_reference	local
rewrite_short_tags
proxy_ips
ojadmin	JpjZkQN5A8l@^L
salt	+UFjSAT49tPZLtmU2CIG2FYN7pRhgsWyLHgSyQa6k3I=
queue_enabled
twilio	Array ( [sid] => AC00c0594045c6eef9407e8fff01f3d467 [token] => f0bfc0b73444a077894a43f5f75e6d41 [length] => 6 [from] => +639221200200 [code_expiry_seconds] => 14400 )
maintenance	Array ( [admin] => Array ( [verification] => ) [announcement_bar] => Array ( [show_slow_issue_message] => ) )
trustpilot	Array ( [to_email] => onlinejobs.ph+3d844ebf71@invite.trustpilot.com )
services	Array ( [google_tag_manager] => Array ( [id] => GTM-T5CQMS6P ) [chatgpt] => Array ( [secret] => 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 ) [claude] => Array ( [secret] => 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 ) )
v2_url	https://v2.onlinejobs.ph
replacemyself_secret_key	Kk1WpgTMkc4wBQOqC5rqCssdLhACKrsJeTtO1ywUkT4=
app	Array ( [app] => Array ( [command] => Array ( [map] => Array ( [OnlineJobs\Mailer\Command\SendEmailCommand] => OnlineJobs\Mailer\Handler\SendEmailHandler [OnlineJobs\Mail\Command\SendEmailCommand] => OnlineJobs\Mail\Handler\SendEmailHandler [OnlineJobs\Mail\Command\QueueEmailPendingCommand] => OnlineJobs\Mail\Handler\QueueEmailPendingHandler [OnlineJobs\Mail\Command\QueueJobEmailPendingCommand] => OnlineJobs\Mail\Handler\QueueJobEmailPendingHandler [OnlineJobs\Mail\Command\QueueUnapprovedEmailCommand] => OnlineJobs\Mail\Handler\QueueUnapprovedEmailHandler [OnlineJobs\Mail\Command\ProcessEmailQueueCommand] => OnlineJobs\Mail\Handler\ProcessEmailQueueHandler [OnlineJobs\Mail\Command\PutJobseekerEmailOnHoldCommand] => OnlineJobs\Mail\Handler\PutJobseekerEmailOnHoldHandler [OnlineJobs\Purchase\Command\RealEstateVaCourseCommand] => OnlineJobs\Purchase\Handler\RealEstateVaCourseHandler [OnlineJobs\Test\Command\HelloCommand] => OnlineJobs\Test\Handler\HelloHandler ) [middleware] => Array ( ) ) [providers] => Array ( [0] => OnlineJobs\Bus\BusServiceProvider [1] => OnlineJobs\Database\DbServiceProvider [2] => OnlineJobs\Mailer\MailerServiceProvider [3] => OnlineJobs\Support\SupportServiceProvider [4] => OnlineJobs\Employer\ServiceProvider [5] => OnlineJobs\Jobseeker\ServiceProvider [6] => OnlineJobs\Mail\ServiceProvider [7] => OnlineJobs\Postal\ServiceProvider [8] => OnlineJobs\Queue\ServiceProvider [9] => OnlineJobs\Courier\ServiceProvider [10] => OnlineJobs\Job\ServiceProvider [11] => OnlineJobs\Purchase\ServiceProvider ) ) )
meta	Array ( [facebook] => Array ( [input] => 1 [connect] => 2 [timezone] => 3 [url] => 30 [id] => 31 [photo] => 32 [name] => 33 [email] => 34 [review] => 35 ) [trust] => Array ( [government_id] => 4 [utility_bill] => 5 [selfie_photo] => 6 [profile_picture] => 7 [phone_number] => 8 [facebook] => 9 ) [verify] => Array ( [profile_picture] => 10 [government_id] => 11 [selfie_photo] => 12 [utility_bill] => 13 [address] => 14 [name] => 15 [reviewed] => 16 [government_group] => 28 [address_group] => 29 [mobile] => 38 ) [address] => Array ( [complete] => 17 [room_unit_no] => 20 [house_no] => 21 [street] => 22 [subdivision] => 23 [barangay] => 24 [city] => 25 [province] => 26 [postcode] => 27 ) [reviewed] => Array ( [similar_names] => 1 ) [name] => 18 [phone] => 19 [sms_verification_code] => 36 [resend_verification_code] => 37 [address_read] => 39 [first_name] => 100 [middle_name] => 101 [last_name] => 102 [edit] => Array ( [government_id_group] => 40 [address_group] => 41 [mobile_group] => 42 ) [salary_re_entry] => 103 [id_proof_recalibrate] => 104 [email] => 44 [mobile_verification_type] => 45 )
honeypot	Array ( [name_field] => my_name [enabled] => 1 )

HTTP_ACCEPT	/
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_CONNECTION	Upgrade
SERVER_PORT	80
SERVER_NAME	v1.stage.onlinejobs.ph
REMOTE_ADDR	127.0.0.1
SERVER_SOFTWARE	Apache/2.4.58 (Ubuntu)
HTTP_ACCEPT_LANGUAGE
SCRIPT_NAME	/index.php
REQUEST_METHOD	GET
HTTP_HOST
REMOTE_HOST
CONTENT_TYPE
SERVER_PROTOCOL	HTTP/1.1
QUERY_STRING
HTTP_ACCEPT_ENCODING	gzip, br, zstd, deflate
HTTP_X_FORWARDED_FOR	216.73.216.67
HTTP_DNT

Shopify E-Commerce Finance Controller — P&L, ROAS & Cashflow for a 12-Store Dropshipping Group

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

TYPE OF WORK

SALARY

HOURS PER WEEK

DATE UPDATED

Why is this blurred?