Title: Merchandise Accounts Receivable & Inventory Analyst
TULSA, OK, US, 74134
Primary Purpose of Job:
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:
- Total commitment to satisfying the customer through excellent customer service and support.
- Ability to work effectively and harmoniously as a member of a high functioning team.
- A self-starter who can establish priorities and rely on experience and judgement in order to accomplish goals and objectives, meet rigid deadlines, and develop solutions to problems under general supervision.
- Must be flexible and able to learn and adapt to new functions, processes and procedures as a part of QuikTrip’s change management process.
- Ability to learn quickly and retain knowledge of processes and procedures.
- Ability to analyze data and draw conclusions as to the accuracy and completeness of the information received.
- Must be organized and able to complete multiple tasks simultaneously.
- Must be dependable, accurate, efficient, and thorough.
- Ability to perform repeated tasks for extended period of time.
Starting Salary: $22.13-26.04 per hour
Nearest Major Market: Tulsa
Nearest Secondary Market: Oklahoma