eCommerce Finance Inventory Analyst

THE ROLE

The analyst is responsible for managing the companys Amazon Walmart & other eCommerce billing reports intercompany billing reports accounts payable processes including invoice input and generation of disbursements accounts receivable processes as well as other assigned general accounting responsibilities. The ability to work both independently and within a team in a fastpaced high volume environment with emphasis on accuracy and timeliness is critical.

RESPONSIBILITIES

• Handle Amazon business accounting on Seller Central and Vendor Central including:
  • Gathering information for monthly advertising spend and ensure accurate allocation across brands
  • Generate Monthly Billing Reports by brand review and get signoff from key stakeholders submit to brands and ensure timely payment
  • Manage Inventory Counts and Profit Margin per SKU
  • Conduct conclusive and accurate margin analysis while reviewing reorder recommendations
  • Create profit and loss analysis on Inventory level and for the company as a whole
  • Intercompany billing reconciliation
  • Identify billing errors/discrepancies payment periods when payments should be coming in from Amazon/Walmart/Shopify/other sales channels and reconcile with billing reports to ensure accuracy
  • Manage financial communication process between ExKaliber and 67 other portfolio companies
  • Reviewing past/ present invoices from Amazon to ensure no overcharges on FBA fees
  • Create Cases for Amazon overcharges and reconciliation discrepancies
  • Filing cases for missing inventory
  • Record receipt of inventory and outbound movement; maintain inventory balance sheet at SKU level
  • Manage returns management accounting
  • Manage reimbursement for damages
  • Create Sales Forecasts and Financial Budgets and Profit and Loss as instructed
  • Create new reports as per deemed necessary by Management
• Accounts Payable:
  • Generation of Purchase Orders
  • Keeping track of all payments and expenditures including purchase orders invoices statements etc.
  • Invoice tracking verifying payments due and payment scheduling (submitting vendor invoices to parent company accounting department)
  • Interfacing with all vendors regarding finance / billing inquiries
• Forecasting healthy inventory coverage creating purchase orders and reordering inventory as needed
• Own and manage Accounts Receivable Process (invoice and report generation collecting aging invoices)
• Preparing analyses of accounts and producing monthly reports
• Reconciling processed work by verifying entries and comparing system reports to balances with bookkeeper
• Ensure proper documentation is in place and organized for financial transactions and audit preparedness
• Maintain confidentiality with sensitive information on behalf of company
• Reconcile accounts and audit
• Flexibility to perform other duties as required related to assisting the accounting department and other management teams
• Key member of the audit process including preparation of materials for the financial statement audit and coordination with external audit team

SKILLS & EXPERIENCE

• Bachelors degree in accounting finance or a related discipline
• 3 years of relevant experience in ecommerce and an inventorybased consumer products company
• MUST HAVE: 3 years experience with Amazon seller business accounting Seller Central and Vendor Central)
• Experience in Walmart platform is a huge plus!
• MUST HAVE: Strong Accounting Skills with Inventory Management experience
• MUST HAVE:Expertise in Excel intermediate to advanced level
• MUST HAVE: Knowledge QuickBooks Online or comparable system to be able to make sure that the bookkeeper is accurate

THIS IS EST / PST Schedule