E-Commerce Accounts Receivable Clerk
- company
- Developlus Inc
- location
- Corona, CA, United States
- posted
- 1 Jun
- **Job Title:**
- E-Commerce Accounts Receivable Clerk
- **Department:**
- Finance
- **Reports To:**
- Accounting Manager
- **Position Summa**
- ryThe E-Commerce Accounts Receivable Clerk is responsible for accurately recording and reconciling high-volume e-commerce transactions across multiple online sales channels, including Amazon, Walmart, Shopify, TikTok, and other third-party platforms. This role ensures timely and accurate posting of orders, invoices, payments, fees, and credits into Sage X3 using third-party integration tools and platform report
- s.As Developlus continues to grow its e-commerce footprint and transaction volume, this role is critical to maintaining clean receivables, identifying discrepancies early, and preventing reconciliation issues related to commissions, fulfillment fees, promotions, chargebacks, and platform deductions. This position requires strong analytical skills, solid Excel capabilities, and a working knowledge of accounts receivable fundamentals in a fast-paced, high-volume environmen
- **t.
- Key Responsibilit**
- **ies1. E-Commerce Order & Invoice Process**
- ingDownload and review daily, weekly, or bi-weekly order reports from Amazon, Walmart, Shopify, TikTok, and other e-commerce porta
- ls.Post e-commerce orders and invoices into Sage X3 using approved third-party integration too
- ls.Ensure completeness and accuracy of order data, including pricing, quantities, taxes, discounts, and shipping detai
- ls.Monitor posting exceptions and resolve errors to ensure transactions are fully captured in the E
- **RP.2. Cash Application & Payment Post**
- ingPost daily or bi-weekly batch payments received from e-commerce platfor
- ms.Apply payments accurately to open invoices, ensuring proper handling of net settlemen
- ts.Identify and document unapplied cash, short pays, and overpayments for follow-
- **up.3. Fees, Commissions & Credit Memo Managem**
- entCreate and post credit memos for e-commerce platform fees, including sales, refunds, commissions, fulfillment and shipping fees, advertising charges, promotions, rebates, and discounts, chargebacks and other platform deductio
- ns.Ensure proper categorization of all fee types to support accurate reporting and reconciliati
- **on.4. Reconciliations & Discrepancy Resolut**
- ionIndependently identify discrepancies between platform reports, bank deposits, and Sage X3 postin
- gs.Investigate root causes of reconciliation issues, including timing differences, posting errors, missing transactions, or incorrect fe
- es.Maintain reconciliation schedules and supporting documentation for audits and period-end clo
- se.Escalate unresolved issues with clear analysis and supporting da
- **ta.
- Qualificat**
- **ionsRequ**
- iredAssociate’s or Bachelor’s degree in Accounting, Finance, or a related fi
- eld.2–4 years of accounts receivable or transactional accounting experience, preferably in an e-commerce environm
- ent.Strong working knowledge of accounts receivable fundamentals, including invoicing, cash application, and reconciliati
- ons.Experience handling large transaction volumes with a high level of accur
- acy.Strong analytical skills with the ability to independently identify and resolve discrepanc
- ies.Intermediate level proficiency in Microsoft Excel, including formulas such as VLOOKUP/XLOOKUP, SUMIFS, IF statements, and pivot tab
- les.Experience working with ERP systems (Sage X3 preferred, but not requir
- ed).Experience in a high-volume transactional environm
- ent.High attention to detail with strong organizational and time-management ski
- **lls.Prefe**
- rredPrior experience with Amazon Seller Central, Shopify, TikTok Shop, or similar e-commerce platfo
- rms.Intermediate level Excel certification or equivalent demonstrated proficie
- ncy.
- This role is ideal for a detail-oriented accounting professional who thrives in high-volume environments, enjoys problem-solving, and wants to develop deep expertise in e-commerce accounting operat
- ions.