

Accounts Receivable Analyst
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for an Accounts Receivable Analyst, offering $33.00 - $37.00/hr for a contract exceeding 6 months. Requires 4+ years in AR with large retailers, strong Excel skills, and familiarity with ERP systems. Remote work available.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
296
-
🗓️ - Date discovered
August 28, 2025
🕒 - Project duration
More than 6 months
-
🏝️ - Location type
Unknown
-
📄 - Contract type
Unknown
-
🔒 - Security clearance
Unknown
-
📍 - Location detailed
Miami, FL
-
🧠 - Skills detailed
#Microsoft Power BI #Base #Leadership #Monitoring #Oracle #Visualization #SAP #Tableau #Microsoft Excel #Documentation #Compliance #BI (Business Intelligence) #AI (Artificial Intelligence) #Pivot Tables #Consulting #Datasets
Role description
Payrate: $33.00 - $37.00/hr.
Summary:
The Analyst Payment’s role is responsible for managing high-volume retailer accounts. This position supports the Credit & Collections department by monitoring payment activity, reconciling accounts, investigating deduction trends, and ensuring timely resolution of outstanding balances and claims. The role requires extensive interfacing with customer finance teams, internal business partners, and retailer portals to ensure accuracy in payment applications, deduction validation, and post-audit compliance.
The ideal candidate will have a strong analytical mindset, exceptional Excel proficiency, and a proactive approach to resolving discrepancies. The role demands clear and consistent communication, detailed documentation, and the ability to work cross-functionally to minimize financial exposure and ensure operational efficiency. This role also encompasses other responsibilities as assigned to support the overall goals of the department.
Responsibilities:
• Analyze and reconcile payment discrepancies and AR agings to ensure accurate billing and maintain invoice aging 95% current (1-30 days), claims aging 90% current (1-90 days), and minimize bad debt.
• Investigate the root causes of payment variances, short-pays, and unapproved deductions. Resolve discrepancies by collaborating with internal departments and external partners.
• Conduct in-depth research and root cause analysis on post audits, returns, warehouse fees, shortages, substitutions, and freight & handling claims.
• Reconcile and validate all returns deduction exceptions, including 812 tables and price adjustments. Verify serial number issues and ensure appropriate supporting documentation is in place.
• Generate monthly credit and debit memos for shortages, paybacks, and refusals by reviewing master logs and remittance activity.
• Maintain accurate return resolution tables by ensuring supporting documentation aligns with requirements and internal tolerance thresholds.
• Support 3PL’s and maintain accurate tracking logs. Coordinate efforts with fulfillment teams.
• Collaborate with sales and retailer accounting teams to address past due balances, follow up on collections, and document all communication.
• Analyze payment trends and provide detailed reports on variances, patterns, and resolutions for leadership review.
• Assist in month-end close reporting and accrual preparation for retailer accounts. Ensure variances between estimates and actuals are within acceptable thresholds.
• Ensure compliance with established processes, including claim resolution deadlines, accurate documentation, and adherence to retailer guidelines.
• Participate in process improvement initiatives to enhance efficiency and accuracy in payment processing and reconciliation.
• Support internal and external audits by providing necessary documentation and explanations.
Qualifications:
• Associate’s degree or equivalent work experience in accounting, finance, or a related field required (bachelor’s preferred).
• Minimum of 4 years of accounts receivable and payment reconciliation experience, preferably with large retailers such as Walmart.
• Strong proficiency in Microsoft Excel (pivot tables, VLOOKUPs, formulas); advanced Excel skills preferred.
• Working knowledge of ERP systems (Oracle, SAP), and experience with Noetix and OFS platforms preferred.
• Strong analytical and problem-solving skills; ability to interpret large datasets and draw actionable conclusions.
• Excellent verbal and written communication skills; ability to interact professionally with internal teams and external customers.
• Exceptional organizational and time management skills; ability to manage multiple priorities and meet deadlines independently.
• High level of accountability, accuracy, and ownership of responsibilities.
• Familiarity with retailer portals (e.g., Walmart Retail Link) and claim backup requirements a plus.
• Experience with data visualization tools (e.g., Tableau, Power BI) is a plus.
Pay Transparency: The typical base pay for this role across the U.S. is: $33.00 - $37.00/hr. Final offer amounts, within the base pay set forth above, are determined by factors including your relevant skills, education and experience and the benefits package you select. Full-time employees are eligible to select from different benefits packages. Packages may include medical, dental, and vision benefits, 10 paid days off, 401(k) plan participation, commuter benefits and life and disability insurance.
For information about our collection, use, and disclosure of applicant's personal information as well as applicants' rights over their personal information, please see our Privacy Policy (https://www.aditiconsulting.com/privacy-policy).
Aditi Consulting LLC uses AI technology to engage candidates during the sourcing process. AI technology is used to gather data only and does not replace human-based decision making in employment decisions. By applying for this position, you agree to Aditi’s use of AI technology, including calls from an AI Voice Recruiter.
#AditiConsulting
#25-22017
Payrate: $33.00 - $37.00/hr.
Summary:
The Analyst Payment’s role is responsible for managing high-volume retailer accounts. This position supports the Credit & Collections department by monitoring payment activity, reconciling accounts, investigating deduction trends, and ensuring timely resolution of outstanding balances and claims. The role requires extensive interfacing with customer finance teams, internal business partners, and retailer portals to ensure accuracy in payment applications, deduction validation, and post-audit compliance.
The ideal candidate will have a strong analytical mindset, exceptional Excel proficiency, and a proactive approach to resolving discrepancies. The role demands clear and consistent communication, detailed documentation, and the ability to work cross-functionally to minimize financial exposure and ensure operational efficiency. This role also encompasses other responsibilities as assigned to support the overall goals of the department.
Responsibilities:
• Analyze and reconcile payment discrepancies and AR agings to ensure accurate billing and maintain invoice aging 95% current (1-30 days), claims aging 90% current (1-90 days), and minimize bad debt.
• Investigate the root causes of payment variances, short-pays, and unapproved deductions. Resolve discrepancies by collaborating with internal departments and external partners.
• Conduct in-depth research and root cause analysis on post audits, returns, warehouse fees, shortages, substitutions, and freight & handling claims.
• Reconcile and validate all returns deduction exceptions, including 812 tables and price adjustments. Verify serial number issues and ensure appropriate supporting documentation is in place.
• Generate monthly credit and debit memos for shortages, paybacks, and refusals by reviewing master logs and remittance activity.
• Maintain accurate return resolution tables by ensuring supporting documentation aligns with requirements and internal tolerance thresholds.
• Support 3PL’s and maintain accurate tracking logs. Coordinate efforts with fulfillment teams.
• Collaborate with sales and retailer accounting teams to address past due balances, follow up on collections, and document all communication.
• Analyze payment trends and provide detailed reports on variances, patterns, and resolutions for leadership review.
• Assist in month-end close reporting and accrual preparation for retailer accounts. Ensure variances between estimates and actuals are within acceptable thresholds.
• Ensure compliance with established processes, including claim resolution deadlines, accurate documentation, and adherence to retailer guidelines.
• Participate in process improvement initiatives to enhance efficiency and accuracy in payment processing and reconciliation.
• Support internal and external audits by providing necessary documentation and explanations.
Qualifications:
• Associate’s degree or equivalent work experience in accounting, finance, or a related field required (bachelor’s preferred).
• Minimum of 4 years of accounts receivable and payment reconciliation experience, preferably with large retailers such as Walmart.
• Strong proficiency in Microsoft Excel (pivot tables, VLOOKUPs, formulas); advanced Excel skills preferred.
• Working knowledge of ERP systems (Oracle, SAP), and experience with Noetix and OFS platforms preferred.
• Strong analytical and problem-solving skills; ability to interpret large datasets and draw actionable conclusions.
• Excellent verbal and written communication skills; ability to interact professionally with internal teams and external customers.
• Exceptional organizational and time management skills; ability to manage multiple priorities and meet deadlines independently.
• High level of accountability, accuracy, and ownership of responsibilities.
• Familiarity with retailer portals (e.g., Walmart Retail Link) and claim backup requirements a plus.
• Experience with data visualization tools (e.g., Tableau, Power BI) is a plus.
Pay Transparency: The typical base pay for this role across the U.S. is: $33.00 - $37.00/hr. Final offer amounts, within the base pay set forth above, are determined by factors including your relevant skills, education and experience and the benefits package you select. Full-time employees are eligible to select from different benefits packages. Packages may include medical, dental, and vision benefits, 10 paid days off, 401(k) plan participation, commuter benefits and life and disability insurance.
For information about our collection, use, and disclosure of applicant's personal information as well as applicants' rights over their personal information, please see our Privacy Policy (https://www.aditiconsulting.com/privacy-policy).
Aditi Consulting LLC uses AI technology to engage candidates during the sourcing process. AI technology is used to gather data only and does not replace human-based decision making in employment decisions. By applying for this position, you agree to Aditi’s use of AI technology, including calls from an AI Voice Recruiter.
#AditiConsulting
#25-22017