Title:  Merchandise Accounts Receivable & Inventory Analyst

Category:  Corporate Office
Date:  Feb 21, 2025
Location: 

TULSA, OK, US, 74134

Primary Purpose of Job:

Responsible for the timely and accurate accruals of all Merchandise Accounts Receivable transactions, ensuring compliance with internal controls and accounting policies.   Maintains and reconciles accounts receivable ledger and is responsible for customer billing. Research and response to customer inquiries regarding bills. Responsible for Accounts Receivable processes required in JD Edwards (E1) for QTD/QTK, Merchandise Vendors, and Merchandise Rebates, etc.  Responsible for the weekly review and analysis of merchandise inventory transactions originating at the stores. Research and respond to merchandise inventory store problem research requests and correct as needed in the AS400 Store Reporting System and/or the Sales ODS/Data Warehouse.   

 

Major Functions

 

Responsible for the clean, timely, and accurate preparation of all merchandise Rebate Accounting general ledger account reconciliations and Customer Ledger reconciliations, including but not limited to the following:

  • Calculate and record CMA rebate accruals utilizing purchase information from the in-store Order Book’s receiving/invoice program.  Maintain by item (SKU) by vendor rebate tables.  Review and analyze reports for accuracy, completeness, and reasonableness.
  • Calculate and record RDA rebate accruals based on sales information obtained from our POS registers and/or register scanning at the stores.
  • Process payments (checks or credit memos) from vendors making the proper application to the receivable or income rebate account.
  • Reconcile all Merchandise Inventory Transfer general ledger accounts.
  • 20% of total job
      • Frequency of function:  Monthly

 

Responsible for all facets of Merchandise Accounts Receivable processing. 

  • Accrue and record the billing of customer invoices as well as receipt payment application and credit memos into QT’s ERP System (E1), including but not limited to: promotions, disbursements, coupons, Common Carrier, rebates, receivables, deductions, recalls, and settlements. Ensure accuracy in accordance to internal controls and accounting policies.
  • 25% of total job
  • Frequency of function:  Daily

 

Match all unapplied cash to the appropriate open invoice for the correct Customer within JD Edwards (E1) and research any unapplied cash without proper backup.

  • 15% of total job
  • Frequency of function: Daily

 

Analyze the Accounts Receivable Aging Reports for assigned Customers.  Research overdue customer accounts prior to contacting CSM’s and/or DSMs, for inquires related to reasons for past due business to business accounts and provide updates of outstanding balances to Management. Respond to customer inquiries regarding billing.

  • 5% of total job

Frequency of function:  Weekly

 

Backup the Corporate Rebate Accountant as necessary (high volume periods, vacations, illness, etc.) and perform functions associated with these positions on a regular basis in order to stay current on function procedures.

  • Rebate accrual calculations
  • Cigarette and Tobacco Payment applications
  • Cigarette Buydown & Rebate Estimate
  • 5% of total job
  • Frequency of function: As needed

 

Responsible for the review, analysis, and correction of merchandise inventory transactions.  Determine if the correction is needed in the Store Reporting System, the Sales ODS/Data Warehouse, or both. 

  • 20% of total job
  • Frequency of function:  Weekly

 

Review the “Unmatched Merchandise Inventory Transfer Report” and determine the correcting entries needed to the Store Reporting System and Sales ODS/Data Warehouse.

  • 5% of total job
  • Frequency of function:  Weekly

 

Balance the Sales ODS/Data Warehouse merchandise inventory transaction data to the AS400 Store Reporting System utilizing the Perpetual Merchandise Inventory Report.  Determine if the differences are reasonable or if the differences require more in-depth research (possible system deficiency).

  • 5% of total job
  • Frequency of function:  Weekly

 

Special projects, tasks, functions, or research as directed by the Corporate Price Book & Accounts Receivable Manager.

  • Frequency of function:  As needed

 

Position in Organization

Reports to: Corporate Price Book & Accounts Receivable Manager

 

 

Relationships

Inside the Company: Corporate and Division Sales, Corporate Accounting, Treasury Department, Information Technology Department, and QTD/K Logistics Team.            

Outside the Company: Merchandise Suppliers and 3rd Party Companies (i.e. InMar Coupon Clearing House).           

 

Position Specifications

The required specifications (education, experience, and skills) are those that the employee must have to hold the position.  Applicants applying for this position must possess the required specifications in order to be considered for the job. The desired specifications are those that are not required for the employee to hold the position but the employee should try to obtain the desired education, experience, and/or skills to be effective and successful in the position.

 

 

Required education: Must have successfully completed Intermediate Accounting I and all pre-requisite courses.   

Desired education: Successfully completed Intermediate Accounting II, and all pre-requisite courses. 

Required experience:  Two years’ experience in an office/accounting environment.

Desired experience: Three years’ experience in an office/accounting environment.

Required skills: Excellent customer service, communication, organizational and time management skills.  Strong analytical and number perception skills.  Proficiency in the use of Microsoft Office products with Intermediate skill level in the use of Microsoft Excel.  Ability to prioritize and handle multiple tasks and/or projects simultaneously and detail oriented.                    

Desired skills: Advanced skill level in the use of Microsoft Excel, Strong general ledger reconciliation skills.

 

Additional criteria:

 

 

Starting Salary: $22.13-26.04 per hour


Nearest Major Market: Tulsa
Nearest Secondary Market: Oklahoma