Procom
Burlington, ONAccountant, GL Break Reconciliation w MS Excel
Accountant, GL Break Reconciliation w MS Excel
On behalf of our client in the Banking Sector, PROCOM is looking for an Accountant, GL Break Reconciliation w MS Excel.
Accountant, GL Break Reconciliation w MS Excel – Job Description
- Moving from 2 end of life systems (Asset from CIS & Credit Path from Finestra) into 1 new system (Ambit which is managed by FIS)
- Assist with Show Stopper GL Reconciliation work
- Reconcile breaks and investigate - 35,000 GL breaks
- Determine root cause and if adjusting entry is required, and if so, what are the details of the entry
Accountant, GL Break Reconciliation w MS Excel – Mandatory Skills
- Degree, Ideal candidate would likely have an accounting designation
- Minimum 5+ years Accounting experience
- Ability to create and understand Lease and Loan Amortization schedules with different financing structures
- GL Reconciliation work
- Excellent communication skills in English but bi-lingual French a plus
- Background of closing out projects and getting across the finish line
- Highly advanced Excel capabilities including Pivot Tables, Filtering, advance formula creation
- Nested If Statements, Sumifs or Sumproduct for multivariable summations, use of logical functions AND, and OR, use of IFERROR and other error handling functions
- Use of date functions EDATE, EOMONTH, etc.
- VLOOKUP, importing text files into Excel
Accountant, GL Break Reconciliation w MS Excel – Nice to Have Skills
- Banking background a plus
- MBA preferred
- Cognos
- Ambit/FIS
- Credit Path/Finastra
- Asset/CFS
- Knowledge and experience with lessor accounting an asset
- Bilingual English/French an asset
Accountant, GL Break Reconciliation w MS Excel - Assignment Start Date
ASAP – 6 months to start
Accountant, GL Break Reconciliation w MS Excel - Assignment Location
Burlington, ON – Work Remotely