DBG Canada

Account Receivable Analyst

Mississauga, OntarioFull-time
CA$50,000 - CA$65,000 annually
About the Job
DBG is a full-service organization that is committed to providing our Customers with exceptional quality, on time delivery and cost saving opportunities. DBG supplies high quality metal stamping & fabrication to the automotive, heavy truck and appliance industries.

OVERVIEW OF RESPONSIBILITIES:
  • Review and Clean up databases for inaccuracies.
  • Follow the Customer Pricing Update process to ensure most current pricing is reflected in software database to minimize Customer short payments due to pricing problems.
  • Establish Customer DB update process to ensure proper setup, control and processing of changes/additions/deletions on a timely basis.
  • Ensure existing customers are set up for GST/HST and other applicable sales taxes.
  • Cash application of customer remittances in JDE.
  • Research and resolve payment discrepancies.
  • Monitor customer account details for past-due, delayed and other payments.
  • Maintain timely & accurate credit note processing and tracking process (i.e. debit tracker).
  • Reconcile debit tracker to general ledger on monthly basis (using V-look up).
  • Investigate and reconcile customer accounts.
  • Timely analyze and resolve customer accounts with credits, discounts, deposits & rebate issues.
  • Investigate and initiate appropriate action on payment discrepancies/disputes.
  • Investigate and reply to inquiries regarding customer accounts.
  • Prepare and follow up on credit note requests with internal and customer resources.
  • Summarize weekly A/R aging report and identify outliers and changes.
  • Generate and analyze customer receivable aging reports.
  • Prepare/review 12-week collections forecast.
  • Monitor 12-week forecast to actual collections for anticipated deviations and notify Supervisor & Corporate Controller.
  • Report past due/potential problem accounts to Controller and other internal stakeholders with action plans for resolution/ mitigation of DBG exposure.
  • Prepare/review month-end processing and reporting requirements including allowance for doubtful accounts.
  • Preparing weekly sales reports against budget for management.
  • Proactively liaise with internal clients (Sales & Marketing, Shipping, IT, Management) to resolve issues, discrepancies and ensure timely collection/follow up on past due accounts.
  • Accountable for collecting AP and minimizing overdue accounts receivable and oversee collections.
  • Contact customers regarding past due amounts.

Education Required:
  • College diploma in Accounting or Business or equivalent experience.
  • Working toward or is in good standing with a credit designation or equivalent experience.
  • Continuing education courses in credit and collections.                    

QUALIFICATIONS:
  • 5 years A/R experience in automotive industry or other high transaction volume industry.
  • 5 years collection experience.                                                         
  • Working knowledge of basic accounting principles with strong analytical skills.
  • MS Office applications – Good in Excel.
  • Exposure to JDE or another major ERP systems a plus.
  • Sales and excise tax experience.