E-Commerce Bookkeeper

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

TYPE OF WORK

Full Time

WAGE / SALARY

$900 monthly 10-6pm mon-friday

HOURS PER WEEK

TBD

DATE UPDATED

May 11, 2026

JOB OVERVIEW

This is not a traditional bookkeeping role. We need someone who can go beyond recording transactions — we want a financial partner who can analyze SKU-level profitability, track every fee and cost, and help us make smarter pricing and inventory decisions. You will own the books, the numbers, and the insights.
Key Responsibilities
• Bookkeeping & Reconciliation: Maintain accurate books in QuickBooks Online (or similar) — categorize all transactions, reconcile bank/credit card accounts, and ensure month-end close is timely and clean.
• Profitability Analysis: Calculate true profit per unit per SKU across all marketplaces, factoring in COGS, marketplace fees (FBA/referral/placement), ad spend, shipping, returns, and refunds.
• Marketplace Reporting: Pull and analyze settlement reports from Amazon, Walmart, eBay, Shopify, and other marketplaces; reconcile platform payouts to the books.
• Accounts Payable: Process vendor bills, manage payment schedules, and maintain vendor records.
• Accounts Receivable: Track customer payments, marketplace reserves, and outstanding receivables.
• Inventory & COGS: Work with inventory data to maintain accurate COGS, track landed costs, and support FIFO/lot tracking.
• Financial Reporting: Prepare monthly P&L, balance sheet, and cash flow statements; deliver SKU-level and marketplace-level profitability reports.
• Item-Level Analysis: Flag underperforming SKUs, identify margin compression, spot fee anomalies, and recommend corrective actions.
• Cross-Entity Bookkeeping: Support bookkeeping across multiple related business entities and keep records cleanly separated.
• Year-End Prep: Organize records and supporting schedules for the US-based accountant at year-end.


please fill out the google form we will only be looking at candidates who filled it out
thanks
----------

SKILL REQUIREMENT
VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0007
Controller Execution Time ( Jobseekers / Job )  0.0446
Total Execution Time  0.0461
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,501,504 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/E-Commerce-Bookkeeper-1644052
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0391 seconds)  (Hide)
0.0003   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0004   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1644052
 LIMIT 1 
0.0008   SELECT *
FROM `employers`
WHERE `employer_id` = 404363
 LIMIT 1 
0.0185   SELECT COUNT(DISTINCT t.id) as cnt
FROM 
`t_thread` `t`
INNER JOIN `t_message` `mON `t`.`id` = `m`.`thread_id`
INNER JOIN `t_message_employer` `eON `m`.`id` = `e`.`message_id`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1644052
AND `misc`.`idIS NULL 
0.0006   SELECT e.business_namee.logoe.websitee.rebill_datee.date_added member_datehitsDATEDIFF('2026-06-20',ej.date_added) duration_daysDATEDIFF('2026-06-20',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-06-20',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != AND ej.deleted AND job_id '1644052' 
0.0008   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1644052 
0.0008   UPDATE employer_jobs SET hit_counts '***May-11-2026=470***May-12-2026=357***May-13-2026=153***May-14-2026=57***May-15-2026=44***May-16-2026=17***May-17-2026=26***May-18-2026=25***May-19-2026=24***May-20-2026=19***May-21-2026=17***May-22-2026=11***May-23-2026=7***May-24-2026=7***May-25-2026=13***May-26-2026=13***May-27-2026=8***May-28-2026=11***May-29-2026=4***May-30-2026=3***May-31-2026=2***Jun-01-2026=16***Jun-02-2026=11***Jun-03-2026=5***Jun-04-2026=5***Jun-05-2026=7***Jun-06-2026=1***Jun-07-2026=2***Jun-08-2026=2***Jun-09-2026=4***Jun-10-2026=2***Jun-11-2026=9***Jun-12-2026=2***Jun-13-2026=3***Jun-14-2026=2***Jun-15-2026=3***Jun-16-2026=6***Jun-17-2026=6***Jun-18-2026=5***Jun-19-2026=1***Jun-20-2026=3' WHERE job_id'1644052'  
0.0006   UPDATE employer_jobs SET monthly_hits '***May-2026=1288***Jun-2026=95' WHERE job_id'1644052'  
0.0016   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1644052' 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` = 1644052 
0.0140   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '404363'
AND `date_added` >= '2022-06-08' 
0.0004   select from teasers 
0.0003   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)