Summary:
Establish and maintain customer records, ensure all customer purchase orders are correctly and timely invoiced with the correct supporting documentation as specified by the customer. Provide financial information by researching and analyzing accounts as necessary for management.
Reports To:
Division Controller
Qualifications Required:
- Microsoft Office skills with strong emphasis on Excel and Word.
- Excellent internal and external communication skills.
Qualifications Preferred:
- Experience in customer management
- Two plus years’ experience in a professional setting
- Experience with SAP, preferably within the sales and distribution module
- Experience with the automotive industry
- Understanding of ASC606 revenue recognition, order to cash process
- Knowledge of Waivers of Lien, application for payments, sworn statements, and progress billings
Responsibilities:
Accounts Receivable DMW US:
- Review potential new customers set up documents and credit reports, determine if escalation is required for creation. Create new customer master data in the operating system once all reviews/approvals are obtained.
- Complete modifications to the customer master data after requested changes are reviewed for accuracy. If changes are made to the customer’s credit limit or standard payment terms, obtain approvals as needed.
- Manage customer required software/websites as the DMW administrator. (eSupplier Connect, Covisint, SAP Ariba etc.)
- Proactively seek training on customer required software/websites for invoicing. Maintain proficiency in customer required software/website changes.
- Prepare customer billing requests from Project Managers, including all customer invoices and appropriate supportive documentation. Create and maintain a Statement of Value (SOV) as used in billing. Typically, a monthly activity.
- Create invoice in system once billing approvals received. Submit invoices timely via email and/or customer websites.
- Credit memos/write offs are to be processed timely only after all efforts to collect are exhausted. Credit memos require proper approval.
- Cash applications for payments received are completed in a timely manner.
- Perform aging reviews weekly to identify, investigate and resolve unusual items and to ensure that collection efforts are being pursued. Escalate issues as needed.
- Report a minimum 8 week forecast weekly by maintaining a schedule of incoming payments. (USD, CAD and MXN)
- At year end make determinations as to if items over 120 days aged require to be reserved.
- Retain all supporting documents to the level of reperformance electronically on the accounting SharePoint site.
- Support any and all internal and external audit requests.
- Special projects as required by the Controller.
Project Coordination:
- Review customer purchase order, change order, and bulletins to understand the deliverables and make a determination on the project type and respective revenue recognition in accordance with GAAP.
- Create job numbers for all new projects/sales orders and complete the following set up:
- Create respective work breakdown structures (assign cost codes).
- Obtain and enter the original project budget in the system.
- Obtain budget approval for projects over $10M.
- Process customer purchase orders, including reconciliation of purchase order variances with Customers Purchasing/Buyer.
- Process project bulletins for changes in scope.
- Review aging reports and follow up on delinquent accounts with Project Managers.
- Prepare and maintain Project WIP Summary worksheet and Schedule of Values – (i.e., contract values, change orders, etc.)
- Maintain all subcontract documents (Waivers, Apps, etc.).
- Coordinate/prepare job close-out process for all finished projects.
- Support project team in meeting foreign regulatory and tax waivers. (Canadian 105 Waivers)
Key Performance Indicators:
- Inquires/action items received in the DMW Billing@dmwcc.com inbox are addressed daily.
- Monitor PNC bank daily and record deposits within the week received.
- Record PO receipts and CNs within 2 business days.
- Provide PMs with materials needed to promote monthly invoicing.
- Days outstanding target performance between 75-90 days
Career Form
"*" indicates required fields