Accounting Specialist II

SUMMARY

Responsible for performing advanced accounting functions related to accounts payable and receivable, bank reconciliations, data entry, general ledger maintenance, and financial analysis projects, while serving as the Accounting department’s primary “power user” and subject-matter expert for Epicor and the Company’s other financial and accounting systems. Supports system-related projects, troubleshooting, reporting, and process automation initiatives for the department. May develop areas of primary focus, however all functions are expected to be understood as an area of primary focus or in a back-up capacity to our multi-site and multi-company environment.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Serve as the Accounting department's primary “power user” and subject-matter expert for Epicor and other related financial systems; troubleshoot issues, test system changes/updates, and coordinate with IT and outside vendors to resolve problems.
• Support system-related projects for the Accounting department, including software implementations, upgrades, module rollouts, and integrations; assist with testing and user acceptance for system changes.
• Identify, recommend, and implement opportunities to automate and streamline manual accounting processes using system tools, Excel functions/formulas, SQL, and other technology solutions.
• Develop, maintain, and troubleshoot system-generated reports, queries, and dashboards to support financial reporting, analysis, and decision-making across the organization.
• Maintain system user access and configurations for the Accounting department, partnering with IT to ensure appropriate internal controls.
• Train and support accounting staff on system functionality, new features, and best practices; develop and maintain related system documentation and desk procedures.
• Serve as the primary liaison between Accounting, IT, and outside software vendors on system issues, enhancement requests, and upgrades.
• Process Accounts Receivable (A/R) invoicing and cash application, as well as Accounts Payable (A/P) invoicing, monitoring cash requirements and process payments to suppliers, in an accurate and timely manner. This also involves processing debits & credits, as well as regular reconciliation of outstanding balances.
• Analyze trends and patterns in A/P and A/R and provide recommendations for changes. Create/maintain general ledger reconciliations and develop corrective journal entries. Maintain received not invoiced reconciliation. Manage and maintain non-PO intercompany billings and provide reconciliations.
• Maintain database integrity through Supplier Maintenance and Customer Maintenance screens; this encompasses credit terms, credit limits, tax status, all contact information, etc. Manage credit terms (A/P and A/R) and payment types.
• Support A/R and A/P by managing communications, collecting outstanding invoices, resolving issues, and researching creditworthiness (i.e. on-line research, seeking feedback from others within the organization, contacting references, processing D&B’s) to set appropriate policies for suppliers and customers. Manage past due accounts, aging holds, credit holds, recommend escalations, and coordinate with internal and external departments or organizations.
• Generate, process, and audit payroll, credit card, and expense journal entries weekly, including daily cash ledger entries to maintain accurate account balances.
• Process monthly manufacturing and sales expense recap reports.
• Oversee the processing of expense and mileage reporting.
• Assist in the preparation of financial statements and reports.
• Reconcile petty cash at the end of each month; maintain donation worksheet and supporting receipts for tax documentation.
• Assist the Controller with month end and year end closing/reconciliations.
• Maintain financial records and documentation in accordance with company policies, including department work instructions and minutes.
• Support internal and external audits by providing documentation and explanations as needed.
• Ensure compliance with internal controls and accounting standards.
• Generate and document continuous improvements for accounting.
• Perform other duties as assigned.

EDUCATION and/or EXPERIENCE

Bachelor’s degree (or higher) in accounting, finance, information systems, or a similar field, and two or more years of related experience with a strong emphasis on financial systems, ERP administration/support, reporting, or process automation, or equivalent combination of education and experience preferred.

TECHNICAL SKILLS

Advanced, power-user level proficiency with Epicor (the Company’s ERP system) and Microsoft Excel (including pivot tables and advanced formulas/functions; macros/VBA used only when a function-based solution is not feasible) required. Demonstrated ability to quickly learn, configure, and troubleshoot business systems, and to serve as a go-to technical resource for the department. Experience with SQL and other report/query-writing tools (e.g., SSRS or similar) strongly preferred. Familiarity with database concepts, system integrations, and basic IT/systems-administration principles is a plus. Attain established standards of cybersecurity training, including awareness and best practices, through ongoing company provided training when provided with a company email account and phone number.

BENEFITS

• Health Benefits: medical, dental, and vision
• Wellness Program
• Paid Time Off (PTO)
• Holiday pay
• Company 401(k) match
• Tuition reimbursement
• Company-paid short-term and long-term disability