E-Commerce Bookkeeping Specialist / Accountant

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

TYPE OF WORK

Full Time

SALARY

1400

HOURS PER WEEK

TBD

DATE UPDATED

Jul 6, 2025

JOB OVERVIEW

Please read the whole description in order to be considered:

We are a growing E-Commerce business managing thousands of transactions monthly along with having over 20,000 different variant SKU’s/products, looking for an E-Commerce ROCKSTAR. We sell on most/all platforms and need someone familiar with the entire ecosystem. Inventory is always the most difficult task to manage so someone who has experience with COGS and thoroughly understands clearing accounts. We need someone who can work as a team and has expertise in this specific area, not just general accounting; this is highly specific to our industry (e-commerce) accounting.

This is not an entry-level position, so do not apply if you are new to the accounting industry. That is why we are looking for a rockstar. Someone who likes accounting and takes pride in having the best analytics and reporting. Please do not lie, I will find out in the interview so it’s better to save yours and my time. During the interview, I would like specific scenarios where you have dealt with this ecosystem and what you did to solve them.
Please start your cover letter with the title/words "Bookkeeping Rockstar" - so we know you read the description.

One of the biggest struggles is always dealing with the clearing accounts for the various channels we sell with – provide an example of how you delt with clearing accounts previously and what experience you have related to how they work on the balance sheet and profit & loss. Provide all explanations of every software you have used and what training you have taken with that software.

Our current software stack includes

QuickBooks Online

Shopify

Amazon (multiple stores and countries – so different currencies)

A2X – please be familiar with how this software summarizes and how reconciliation works with this software

Finale Inventory for our Inventory Management System – please list all IMS software that you have experience with

PayPal

eBay

TikTok

Instagram

Excel & Google Sheets – we use both for different reasons

Microsoft teams

Managing databases (strong excel skills, pivot tables, filters, sorting, attention to detail for matching)

Main accounting principles we want to be sure you understand

Clearing Accounts – how sales, fees, refunds, chargebacks, and sales tax affect them

COGS – how to best approach variances, purchase orders, identifying major issues



We are not looking for a specific number of years that you have spent in accounting – we want to hear what results you have provided and how you got those results. This takes critical thinking because of the fast-changing rules in E-Commerce and the changes these marketplaces make regularly and how those affect the bookkeeping. This job does require fluency in English. Initially the hours will be 9-5 Eastern time US, we are based out of Florida. There will be some flexibility in hours in the future but will require you to be available during some US hours (either 9-12 or 2-5) but this will not be until you are trained and have an understanding of how our accounting is managed.

SKILL REQUIREMENT
VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0011
Controller Execution Time ( Jobseekers / Job )  0.0208
Total Execution Time  0.0227
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,520,032 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/E-Commerce-Bookkeeping-Specialist-Accountant-1415587
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0125 seconds)  (Hide)
0.0003   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0010   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1415587
 LIMIT 1 
0.0015   SELECT *
FROM `employers`
WHERE `employer_id` = 766571
 LIMIT 1 
0.0010   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1415587
AND `misc`.`idIS NULL 
0.0005   SELECT e.business_namee.logoe.websitee.rebill_datee.date_added member_datehitsDATEDIFF('2026-04-21',ej.date_added) duration_daysDATEDIFF('2026-04-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-04-21',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != AND ej.deleted AND job_id '1415587' 
0.0007   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1415587 
0.0028   UPDATE employer_jobs SET hit_counts '***Jul-06-2025=92***Jul-07-2025=255***Jul-08-2025=59***Jul-09-2025=35***Jul-10-2025=15***Jul-11-2025=9***Jul-12-2025=8***Jul-13-2025=11***Jul-14-2025=13***Jul-15-2025=6***Jul-16-2025=8***Jul-17-2025=12***Jul-18-2025=7***Jul-19-2025=7***Jul-20-2025=3***Jul-21-2025=3***Jul-22-2025=5***Jul-23-2025=3***Jul-24-2025=6***Jul-26-2025=2***Jul-27-2025=1***Jul-28-2025=1***Jul-29-2025=2***Jul-30-2025=5***Aug-01-2025=5***Aug-04-2025=11***Aug-06-2025=2***Aug-07-2025=7***Aug-08-2025=4***Aug-10-2025=7***Aug-11-2025=6***Aug-12-2025=4***Aug-13-2025=7***Aug-15-2025=1***Aug-16-2025=1***Aug-17-2025=1***Aug-19-2025=1***Aug-21-2025=1***Aug-22-2025=1***Aug-23-2025=1***Aug-24-2025=1***Aug-25-2025=2***Aug-26-2025=1***Aug-27-2025=1***Aug-28-2025=4***Aug-29-2025=1***Aug-31-2025=2***Sep-01-2025=3***Sep-02-2025=1***Sep-03-2025=4***Sep-05-2025=1***Sep-06-2025=1***Sep-08-2025=2***Sep-09-2025=3***Sep-11-2025=2***Sep-12-2025=2***Sep-15-2025=1***Sep-16-2025=4***Sep-17-2025=2***Sep-19-2025=1***Sep-21-2025=2***Sep-22-2025=3***Sep-23-2025=5***Sep-27-2025=1***Sep-28-2025=1***Oct-01-2025=3***Oct-02-2025=1***Oct-03-2025=7***Oct-05-2025=2***Oct-06-2025=3***Oct-08-2025=1***Oct-09-2025=2***Oct-10-2025=1***Oct-11-2025=2***Oct-14-2025=1***Oct-16-2025=1***Oct-17-2025=1***Oct-21-2025=1***Oct-23-2025=3***Oct-24-2025=2***Oct-25-2025=1***Oct-27-2025=6***Oct-28-2025=3***Oct-30-2025=8***Oct-31-2025=2***Nov-01-2025=1***Nov-03-2025=1***Nov-04-2025=1***Nov-05-2025=1***Nov-07-2025=2***Nov-08-2025=3***Nov-10-2025=1***Nov-11-2025=1***Nov-13-2025=1***Nov-14-2025=3***Nov-15-2025=1***Nov-16-2025=1***Nov-17-2025=2***Nov-23-2025=1***Nov-26-2025=2***Nov-27-2025=1***Nov-28-2025=2***Dec-01-2025=2***Dec-02-2025=1***Dec-04-2025=1***Dec-05-2025=1***Dec-06-2025=1***Dec-10-2025=1***Dec-12-2025=1***Dec-13-2025=1***Dec-14-2025=1***Dec-15-2025=2***Dec-16-2025=1***Dec-17-2025=1***Dec-23-2025=1***Dec-25-2025=2***Dec-26-2025=1***Dec-29-2025=1***Jan-03-2026=1***Jan-06-2026=1***Jan-09-2026=1***Jan-16-2026=2***Jan-21-2026=1***Feb-06-2026=1***Feb-14-2026=1***Feb-18-2026=1***Feb-22-2026=1***Feb-24-2026=1***Mar-10-2026=1***Mar-16-2026=1***Mar-29-2026=1***Mar-31-2026=2***Apr-10-2026=1***Apr-12-2026=5***Apr-13-2026=1***Apr-21-2026=1' WHERE job_id'1415587'  
0.0006   UPDATE employer_jobs SET monthly_hits '***Jul-2025=568***Aug-2025=72***Sep-2025=39***Oct-2025=51***Nov-2025=25***Dec-2025=19***Jan-2026=6***Feb-2026=5***Mar-2026=5***Apr-2026=8' WHERE job_id'1415587'  
0.0014   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1415587' 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` = 1415587 
0.0019   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '766571'
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)