Financial Reconciliations Technician

FINANCIAL RECONCILATIONS TECHNICIAN Located at the school board office at 3143 Jacklin Road in Langford, the Finance Department of School District No. 62 (Sooke) is presently seeking a permanent Financial Reconciliations Technician. It is a 35 hour per week permanent position, 12 months per year. School District 62 (Sooke) is the fastest growing school district on Vancouver Island and one of the fastest growing districts in British Columbia.  The District is in the Capital Regional District and operates in five municipalities: Langford, Colwood, Metchosin, Sooke and the Highlands.  The operating budget for the District is in excess of $180 million, with a student population of over 14,000. For further information about School District No.62 (Sooke), please access our district website at .ONE POSITION FOR THE FINANCE DEPARTMENT. THIRTY-FIVE HOURS PER WEEK. TWELVE MONTHS PER YEAR. KNOWLEDGE AND EXPERIENCE Recent completion of a two-year diploma in accounting or two years completed of a bachelor’s degree in accounting; Minimum grade of C+ on all university level accounting courses; Minimum of two years related work experience;Proficiency in using Excel, manipulating data, and utilizing advance formulas/functions such as vlookup, pivot tables, and IF statements;Previous accounting related office experience and experience with accounting software an asset;Customer service and/or client service experience is considered an asset; Familiarity with Atrieve ERP and KEV School Cash Online software programs an asset;Ability to accurately perform repetitive tasks under minimum supervision;Ability to respect the confidential nature of financial transactions, correspondence and discussions.   SKILLS AND ABILITIES Strives for Personal Excellence: is mindful, remains calm and responds thoughtfully; takes pride in work; possesses strong attention to detail; takes initiative and proactively plans, prioritizes and organizes work. Practices a Growth Mindset: demonstrates a positive outlook towards learning and is committed to ongoing development to expand skill set; stays current; reflects on self to continually learn and improve; remains positive; demonstrates adaptability and is willing and able to adjust to changes. Thinks Critically and Creatively: asks questions for better understanding; uses a solution-based approach to analyze relevant facts, evidence and data to determine specific issues and inform ways forward; thinks outside of the box; looks for opportunities to continuously improve. Effectively Communicates and Collaborates: clearly articulates thoughts and ideas and shares timely and relevant information openly, honestly and respectfully using oral, written and visual formats; actively listens and respond appropriately; seeks opportunities to gain input and is open minded to the ideas and point of views of others. Builds Relationships, Fosters Interconnectedness and Cultivates Community: supports a welcoming and safe environment that values and appreciates differences and is reflective of everyone; actively shows courtesy and respect to all, proactively builds healthy and trusting relationships with all; contributes to a positive working environment. Problem Solving/Sound Judgment: analyzes problems systematically, organize information, and identify key factors and options leading to successful outcomes. RESPONSIBILITIES BANK RECONCILIATIONS ·          Review District bank accounts and prepare entries to record revenue and expenditures; ·          Prepare bank transfers between school and District bank accounts; ·          Ensure bank fees and other NSF entries are recorded, reported, and corrected; ·          Prepare the District’s operating and elementary bank reconciliations for approval; ·          Review secondary school bank reconciliations to ensure completeness and accuracy.   OTHER RECONCILIATIONS ·          Prepare and process journal entries; ·          Prepare monthly BMO transaction uploads into Atrieve; ·          Reconcile and prepare monthly GST returns for submission; ·          Prepare a variety of reconciliations and reports using excel, researching accounting discrepancies, determining most appropriate methods to correct discrepancies and preparing corrections. ACCOUNTS RECEIVABLE (A/R) ·          Maintain fee schedule and prepare monthly A/R invoices for District rental contracts; ·          Prepare and issue miscellaneous invoices as required; ·          Export and review School Cash Catalogue reports to record monthly revenue transactions; ·          Monthly reconciliation of the A/R sub ledger; ·          Generate monthly aged A/R report and follow up on outstanding balances.   SUPPORT ·          Provide assistance, training, and technical support to users of the District’s financial reporting systems and accounting systems; ·          Create and maintain process documentation; ·          Work with District staff to answer questions and problem-solve to rectify accounting and reporting issues.   OTHER ·          Assist with internal audits as directed; ·          Prepare EFT information forms for vendor direct deposits; ·          Provide support to the Accounts Payable Technician; ·          File BMO reports; ·          Other duties as required. RATE OF PAY AS PER THE COLLECTIVE AGREEMENT. DUTIES TO COMMENCE AS SOON AS POSSIBLE.  BENEFITS 3 weeks’ vacation to start (based on the terms outlined in the current CUPE Local 459 Collective Agreement) Professional Development: 2 CUPE Professional Developments Days per school year plus access to additional funds for further professional development such as course fees. Self-Directed Professional Development Day, 1 day per year Comprehensive medical and dental benefits to support you and your family, regardless of what life throws at you Life insurance at 3X your annual salary Located beside the Galloping Goose Trail Membership in the Municipal Pension Plan, putting you in a strong position when it comes time to retirement Various programs that support employees such as an Employee & Family Assistance Program and Health and Wellness initiatives and events aimed at fostering your mental health  School District No. 62 (Sooke) is an equal opportunity employer that is committed to diversity, equity and inclusion in the workplace that is free of discrimination and harassment.  We believe in a learning and work environment that is welcoming and safe that values, reflects and appreciates differences.