E-Commerce Accounts Receivable Clerk

Job Title: E-Commerce Accounts Receivable Clerk

Department: Finance

Reports To: Accounting Manager

Position Summary

The 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 reports.

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 environment.

Key Responsibilities

1. E-Commerce Order & Invoice Processing

• Download and review daily, weekly, or bi-weekly order reports from Amazon, Walmart, Shopify, TikTok, and other e-commerce portals.
• Post e-commerce orders and invoices into Sage X3 using approved third-party integration tools.
• Ensure completeness and accuracy of order data, including pricing, quantities, taxes, discounts, and shipping details.
• Monitor posting exceptions and resolve errors to ensure transactions are fully captured in the ERP.

2. Cash Application & Payment Posting

• Post daily or bi-weekly batch payments received from e-commerce platforms.
• Apply payments accurately to open invoices, ensuring proper handling of net settlements.
• Identify and document unapplied cash, short pays, and overpayments for follow-up.

3. Fees, Commissions & Credit Memo Management

• Create 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 deductions.
• Ensure proper categorization of all fee types to support accurate reporting and reconciliation.

4. Reconciliations & Discrepancy Resolution

• Independently identify discrepancies between platform reports, bank deposits, and Sage X3 postings.
• Investigate root causes of reconciliation issues, including timing differences, posting errors, missing transactions, or incorrect fees.
• Maintain reconciliation schedules and supporting documentation for audits and period-end close.
• Escalate unresolved issues with clear analysis and supporting data.

Qualifications

Required

• Associate's or Bachelor's degree in Accounting, Finance, or a related field.
• 2-4 years of accounts receivable or transactional accounting experience, preferably in an e-commerce environment.
• Strong working knowledge of accounts receivable fundamentals, including invoicing, cash application, and reconciliations.
• Experience handling large transaction volumes with a high level of accuracy.
• Strong analytical skills with the ability to independently identify and resolve discrepancies.
• Intermediate level proficiency in Microsoft Excel, including formulas such as VLOOKUP/XLOOKUP, SUMIFS, IF statements, and pivot tables.
• Experience working with ERP systems (Sage X3 preferred, but not required).
• Experience in a high-volume transactional environment.
• High attention to detail with strong organizational and time-management skills.

Preferred

• Prior experience with Amazon Seller Central, Shopify, TikTok Shop, or similar e-commerce platforms.
• Intermediate level Excel certification or equivalent demonstrated proficiency.

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 operations.