Finance Assistant | Excel/Google Sheets

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

TYPE OF WORK

Part Time

SALARY

$4/h

HOURS PER WEEK

15

DATE UPDATED

Oct 1, 2026

JOB OVERVIEW

We are looking for a detail-oriented E-commerce Finance Assistant to manage and improve the financial reporting for our fashion dropshipping business.

We sell across the US, Canada, and UK, so our reporting involves multiple currencies, advertising costs, COGS, refunds, chargebacks, and other e-commerce expenses.

Responsibilities

- Maintain accurate daily, weekly, and monthly profitability reports
- Track revenue, discounts, refunds, chargebacks, COGS, payment fees, ad spend, and other expenses
- Calculate key metrics including gross profit, net profit, profit margin, ROAS, and POAS
- Reconcile data from different sources and identify discrepancies or missing/incorrect data
- Maintain clear profitability reporting across our US, Canadian, and UK markets

What We're Looking For

- Strong Google Sheets / Excel skills, including formulas and working with larger datasets
- Good understanding of revenue, COGS, gross profit, net profit, margins, ROAS, and POAS
- Strong attention to detail and the ability to spot numbers that don't make sense

We want someone who does more than simply enter numbers. You should be able to identify discrepancies, understand what drives profitability, and help us improve our financial reporting.

Required: Spreadsheet Example

- Please include a Google Sheet or Excel example created by you using 100% fictitious data.
- The example should be relevant to a fashion dropshipping store selling in the US, Canada, and UK and demonstrate how you would track profitability.
- We are particularly interested in how you structure the data, use formulas, handle multiple currencies, calculate profitability and ROAS/POAS, and flag discrepancies.

Do not submit any confidential data or spreadsheets from current or previous clients/employers.

This is a remote, part ---------- position with the potential for long-term collaboration.

When applying, please include:
1. Relevant experience
2. Your spreadsheet example
3. Your availability

Applications without a relevant spreadsheet example will not be considered.

SKILL REQUIREMENT
Analysis Finance Management Microsoft Excel
VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0010
Controller Execution Time ( Jobseekers / Job )  0.0132
Total Execution Time  0.0150
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,487,712 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/Finance-Assistant-ExcelGoogle-Sheets-1741664
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0067 seconds)  (Hide)
0.0003   SELECT *
                                FROM exrates
                                WHERE rate_name = 'USD-PHP' 
0.0004   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1741664
 LIMIT 1 
0.0004   SELECT *
FROM `employers`
WHERE `employer_id` = 917442
 LIMIT 1 
0.0009   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1741664
AND `misc`.`id` IS NULL 
0.0005   SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-10-03',ej.date_added) duration_days, DATEDIFF('2026-10-03',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-10-03',ej.date_added) <= 14 ))
                                   AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '1741664' 
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1741664 
0.0007   UPDATE employer_jobs SET hit_counts = '***Oct-01-2026=1430***Oct-02-2026=154***Oct-03-2026=71' WHERE job_id= '1741664'  
0.0007   UPDATE employer_jobs SET monthly_hits = '***Oct-2026=1654' WHERE job_id= '1741664'  
0.0008   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '1741664' AND status LIKE 'sent%' ORDER BY id DESC  
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1741664 
0.0008   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '917442'
AND `date_added` >= '2022-06-08' 
0.0003   select * from teasers 
0.0002   SELECT * FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)