Title: Utility Accountant (1 Year Contract)
Reports To: Manager, Utilities Accounting
Position Summary: Management and validation of utility data and monthly financial reporting as it pertains to the assigned utility.
Responsibilities:
Processing of Utility Bills
Review utility batches and release into the system ensuring accuracy of payee, amount, cheque date, consumption, charges
Validate property address, invoice amounts and rate charges
Liaison with the utility companies on late payment charges and other billing issues
New/sold property billing issues
Coordinate with RAM and RS on tenant charge backs, where applicable
Management of Utility Data
Generate a utility file once a month and send to Utility consultant for assessment of required monthly accrual
Monitor utility schedules on the Consultant's Utility Portal
Work with Consultant and Controller on billing issues
Assist in developing internal reporting /quarterly reports
Correspond and resolve any issues with the data provided by the Consultant on a monthly basis
Reconcile annual Utility contracts
Validate & recommend volumes for renewing utility contracts, where applicable
Financial Reporting
Coordinate the receiving of the monthly accrual file, assess and do a first level review of the data based on thresholds before passing and sending to the Controller for review and sign off of accrual file
Generate the accrual JE and release into the system
Ensure any monthly accrual issues are resolved in the following month
Report variances with explanations on a consolidated basis, actual versus budget
Preparation and reporting of quarterly report of utility consumption, rate and cost vs LY’s quarter by province
Budgeting
Assess and review Consultants proposed budgets and validate rate changes
Responsible to collect data for new acquisition and provide budget for same
Rebate Programs
File, monitor and track Boiler rebates
Other duties
Responsible for month end binders
Other projects as assigned by the Controller
Review utility invoices, post for co-workers during their vacation time (cover-up)
Qualifications:
College diploma or University degree in Accounting or Business
A minimum of 2 years of related experience
Strong analytical and problem solving skills
Ability to work under tight deadlines, multi-task and prioritize
Ability to communicate effectively, both oral and written
Must have strong working knowledge of MS Excel
SAP experience would be an asset
