Construction Portfolio Manager - Mercantile Bank

SUMMARY:Responsibilities of this position include:This role is accountable for the MercForce financial accounting, financial reporting, account reconciliations, and general ledger maintenance. In addition, this role will also produce daily file output, monitoring, and maintenance for iSolved, Master Tax, and all integrated systems. Custom configuration, reporting, supporting and troubleshooting service bureau and client interface files is a key daily function. This role will also provide tax support, tax preparation and processing, and serve as a backup for the Master Tax system. ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.Maintains the highest level of service in dealing with internal staff and external clients including: Administer departmental accounting processes and configurations supporting iSolved Human Capital Management (HCM) system operations:Maintain all checking accounts used in support of iSolved customer processing: Resolve discrepancies that may arise in the daily payroll checking account reconciliation processResolve daily Positive Pay exception decisions for all payroll checking accountsResearch and resolve all stale dated checks and transactionsDocument and track all payroll account manual transactions and manual check requestsComplete the weekly payroll tax account reconciliation procedure Map, define and support iSolved client General Ledger interface file and reporting configurations including QuickBooks Annually prepare and provide support for formal internal audits. Regularly perform audit tasks for all cash management and account reconciliation duties. Administration and support of iSolved and PayChoice daily work file production: Maintain and communicate the monthly fee income reporting for Weiland required by Treasury Management. Maintain the Mercantile MorningStar Health employee work history and demographics filesACH file preparation, verification, and submission with strict adherence to timelinesRun the daily positive pay account interfacesRun and validate the daily iSolved Master Tax exportDaily reporting and validation for tax payment processing from ACH files Administer Master Tax Daily and Periodic Processing Tasks: Daily entry and maintenance of all tax notices received Perform the daily export from iSolved to Master Tax and troubleshoot and resolve file issues Perform a weekly tax transaction audit to reconcile with cash collected including an audit of customer tax liabilities compared to payments and cash on hand. Monitor, resolve, and communicate any discrepancies that arise Perform daily and periodic payroll tax deposits for all taxing authorities on behalf of our tax service clients Assist Payroll Tax Specialist with Quarter End and Year End processing as required Perform all required Master Tax duties in the event the Payroll Tax Specialist is on a planned or unplanned absence Track, monitor and report department performance matrices including: client retention and turnover analysis, benchmarking, profit and loss, break-even analysis, income/expense compared to budget, and income projections. Track, monitor and evaluate competitor pricing. Research, evaluate and prepare recommendations for annual HCM pricing changes Develop and maintain expert knowledge of functions on the HCM system and other bank software and systems. Write and maintain all cash management, tax processing, and department financial accounting procedures Check voicemail and e-mail at least 3 times per day, and respond by the end of the business day in observance with Mercantile Bank's Sunset Rule. High level of written and oral communications experience and timely communication of follow-up with the client, staff, management, and any other interested party as it relates to notice follow-up and resolution. Ability to work and function in a team environment and adjust to varying workload levels. Ability to remain productive while managing multiple tasks. Maintain a high rate of client retention and internal staff satisfaction through quality service and positive team attitude. Work closely with other areas of the Bank Other duties and projects as requested EDUCATION and/or EXPERIENCEThree or more years of experience in the accounting, payroll tax, and/or HR Information System fields. Bachelor's degree (B.A.) from a four-year College or University preferred. Specific education on the iSolved HCM platform preferred. Knowledge of General Ledger and Accounting principles required. A strong working knowledge of Microsoft products including, Outlook, Word, Excel and Access, with an emphasis on the advanced features and functions of Excel and Excel VBA. MATHEMATICAL SKILLSAbility to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference, and volume. Ability to apply concepts of basic algebra and geometry. REASONING ABILITYAbility to apply common sense understanding to carry out detailed but uninvolved written or oral instructions. Ability to deal with problems involving a few concrete variables in standardized situations. WORK ENVIRONMENT Ability to work in an office environment which may include many hours of computer and phone usage. Reasonable accommodations may be made to ensure individuals with disabilities can perform the essential functions. SUPERVISORY RESPONSIBILITIESNone, however ability to work in a team environment is essential.