Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sahil Chhabra

Markham,Canada

Summary

Dynamic financial professional with a proven track record, excelling in financial analysis, and problem-solving. Expert in advanced MS Excel and vendor management, I successfully led projects that enhanced billing automation and cash application processes, driving efficiency and accuracy in financial reporting.

Overview

8
8
years of professional experience

Work History

ACCOUNTS RECEIVABLE SP

Cold Haus Direct/Powerbev INC.
Brampton, Canada
11.2021 - 01.2022
  • Working in an Accounting and Finance department of a fast-paced group of companies keeps me very proactive and help develop problem solving skills in the dynamic business environment.
  • Starting as an AR specialist on a 6-month contract, I was promoted to Financial Analyst within a span of two months and my hard work and dedication towards my work landed me another promotion as a Senior Financial Analyst (team leader) in July 2023.
  • My job responsibilities during my tenure in this organization include (not limited to):
  • Financial planning and Analysis: Working with CFO on FP&A tasks. Analysing the P&L and volume (sales) forecast to capture the actual vs budgeted. Investigating and providing commentary for all significant discrepancy. Conducting trend analysis to provide insights to SMTs for forecasting.
  • Accounts Reconciliation: Reconcile various sub ledgers on weekly and monthly basis. Conducting variance analysis to identify the reason for discrepancies. Posting rectifying journal entries to fix any issues when spotted.
  • Billing: Performed billbacks on weekly basis. This include deductions, discounts, freight, and fulfilment billbacks to the vendors. Currently reviewing all the billbacks and conducting monthly freight analysis to ensure the margins (revenue vs expense) are appropriately reflected in P&L.
  • Payment Application: Processed payment application for any transaction in timely manner. Review all payment application to ensure all deductions are booked correctly and completed before the weekly close.
  • Budgeting: Assist CFO with setting up the financial budget based on the information gathered from different covenants.
  • Gate keeping all price changes, discounts for existing and new national customer by running test invoices. Ensuring all discounts are mapped correctly and flowing through the correct GL.
  • Calculation and payment of rebates as well as AR collection to subs on weekly basis. Generating appropriate Journal entries to capture the rebates correctly in P&L.
  • Other business as usual tasks include (but not limited to)
  • Update Financial statements and Sales reports and make comparison.
  • Prepare freight analysis, expenses tracking, and other analysis as requested by management.
  • Calculate Management fee. Posting accruals and reversal of accrual when the entry for actuals is booked.
  • Post accruals, Bank and Loan entries, Inventory/Cost Adjustments.
  • Bank, Cheques, GL and Inventory reconciliation.
  • Prepare Inbound and Outbound Freight, Handling reports and billback to Customers.
  • Prepare reports for Discounts, promotions, deals, Samples, Demos and billback to Suppliers accordingly.
  • Resolve difference between sub ledger and General ledger.
  • Perform annual inventory count and year end as needed.
  • Prepare and submit HST remittance and Borrowing limit certificate.
  • Performs financial forecasting and reconciliation of internal accounts.
  • Creates and analyse monthly, quarterly, and annual reports and ensures financial information has been recorded accurately.
  • Projects: I teamed up with IT and other department personnel to work and successfully complete the following projects within the proposed timelines.
  • Billing Automation
  • Cash Application automation
  • Amalgamation of two companies and their accounting softwares
  • Subs payable

Accountant

Green Access Limited
Auckland, New Zealand
01.2017 - 07.2021
  • Financial Reporting: Preparation of year-end accounts to present to the director. Worked closely with the director and external CPA in finalizing the annual report.
  • Payroll: Calculated weekly and fortnightly wages using payroll software. Ensured all leave balances and other allowances for all the employees are correctly accrued.
  • Bank reconciliation: Reconciliation of the bank statement on a weekly basis. Performing payment applications and check runs. Providing monthly reports to the director.
  • Managed accounts receivables: Generated invoices using the bookkeeping software (XERO), validated against the purchase orders, and the project progress report. Ensured the smooth running of the process by providing excellent customer service to clients.
  • Accounts payable: Inputting all the payable bills into the system and validating them against our PO/BOL. Ensuring the timely payment of all bills.
  • Taxation: Ensured timely calculation and filing of GST, PAYE, as well as income tax. Dealt with the Inland Revenue for tax-related issues, such as setting up installment payments, managing all tax accounts, etc.

Actuarial Associate

WNS Global Services
Gurgaon, India
01.2014 - 07.2015
  • Assisted with the generation of end-to-end monthly economic assumptions, validation, and analysis for MCEV and IFRS reporting requirements for a UK-based client.
  • Independently worked on the Financial Reporting Control Framework to validate the accuracy of Prophet-Actuarial software by replicating the in-built actuarial model in Excel spreadsheets using advanced Excel formulas and VBA macros. This involved rigorous testing of multiple master life insurance products.
  • Worked on a variance analysis project by applying stress (up or down) to various economic and demographic assumptions, and reporting the results and findings to senior management.
  • Assisted with maintaining actuarial models for pricing, reserving, and capital management.

Education

CPA Course - Auditing

Seneca College of Applied Arts And Technology
North York, None
08-2024

Diploma in Professional Accountancy -

Unitec Institute of Technology
Auckland, New Zealand
12.2016

Actuarial Science Exam - Actuarial Mathematics, Financial Mathematics, Pro

Society of Actuaries
USA
04.2015

Bachelors in Statistics -

Sri Venkateswara College, University of Delhi
New Delhi, India
06.2013

Skills

  • Advanced MS Excel
  • MS Office
  • In-depth accounting knowledge
  • ERP systems
  • Data handling
  • Financial reporting
  • Freight analysis
  • IFRS regulations
  • Analytical skills
  • Problem-solving skills
  • Vendor management
  • Communication skills
  • Multicultural interaction

Timeline

ACCOUNTS RECEIVABLE SP

Cold Haus Direct/Powerbev INC.
11.2021 - 01.2022

Accountant

Green Access Limited
01.2017 - 07.2021

Actuarial Associate

WNS Global Services
01.2014 - 07.2015

CPA Course - Auditing

Seneca College of Applied Arts And Technology

Diploma in Professional Accountancy -

Unitec Institute of Technology

Actuarial Science Exam - Actuarial Mathematics, Financial Mathematics, Pro

Society of Actuaries

Bachelors in Statistics -

Sri Venkateswara College, University of Delhi

Similar Profiles

CREATE PROFILE
Sahil Chhabra