Financial Reconciliations Technician

**School District No. 62 (Sooke)**

**Financial Reconciliations Technician**:
**Position Title**:Financial Reconciliations Technician
**Affiliation**: CUPE
**Reports to**: Manager, Financial Services
**Date of Revision**: October 24, 2023

**Knowledge and Experience**
- Recent completion of 3rd year of a bachelor’s degree in accounting or recent completion of a three-year diploma in accounting from a post-secondary institution;
- Minimum grade of C+ on all university level accounting courses;
- Minimum of one-year related work experience;
- Proficiency in using Excel, manipulating data, and utilizing advanced 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 & 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;
- Other duties as required.

Education : Bachelor’s degree
Experience : 1 year to less than 2 years