Gurpreet Kumar, CPA, CGA
** ******** ********, ********, **, L6Y 4R7
SUMMARY OF SKILLS
Month, Quarter and Year End Closing
Year-end Audit working papers
ASPE and IFRS
Variance and Trend Analysis
Cash Flow Forecast
Fixed Assets/ Intangibles/ CAPEX
Financial Statements analysis
Advanced Excel – Conditional Formattin:, SUMIF, Macros, Pivot Table and VLOOKUP
HST, QST, T5018, WSIB, US Sales Tax submission
Accounting Packages: Microsoft Dynamics Great Plains, Sage 50, SAP, Elite Enterprise, Yardi Voyager, AS400
Industries: Manufacturing, Legal, Property Management and Logistics
General Accountant – Quest Window Systems Inc - Mar 2017- May 2019
Monthly, Quarterly and Year end accounting activities
Responsible for the monthly, quarterly and year end close calendar and process. Co-ordinated with the accounting team to ensure all reporting deadlines are met.
Ensured that accounting records are prepared and maintained in accordance with Quest accounting policies, chart of accounts and related accounting practices/ principles, and Prepared and post journal entries for complex transactions, accruals, and reallocations, subject to approval by the Controller.
Managed and maintained chart of accounts
Prepared and processed disbursement for supplier through cheques, Wire, EFT, Credit Card, Bill payments by verifying documentation.
Prepared and reviewed Prepaid schedule and booked amortization entries
Prepared and submitted T5018 for subcontractors to CRA.
Prepared and submitted monthly Harmonized Sales Tax (HST) Filing.
Accountable for the integrity of Quest’s general financial accounting systems, ensuring accuracy and quality.
Responsible for monthly bank reconciliation statements for all bank accounts and take action on unusual transactions.
Acted as contact person for bank when they have questions about transactions and quickly problem solve bank related issues.
Reviewed weekly cash balance reports and advised Controller as necessary.
Ensured effective internal controls are in place for financial reporting.
Ensured all transactions and expenses are approved and validated.
Monitored compliance to internal controls as part of CEO/CFO certification process.
Continuous improvement of financial policies, process and procedures.
Identified and recommend operational improvements.
Assisted in the development of planning and reporting procedures and user guidelines.
Assisted in special assignments relating to financial programs or processes
Financial Reporting functions.
Prepared quarterly and year-end financial statements
Reviewed quarterly financial statement binder.
Prepared ad-hoc reports as required by the Controller, CFO, senior management and auditors.
Co-ordinated with external auditors for preparation of interim and yearend audit working papers
Managed all yearend audit confirmations to clients and answer requests from clients’ auditors as well
Prepared periodic cash flow forecast reports and assisted Controller to optimize cash management.
Assisted US Controller to set up books, ACH and Wire payments and mentored AP Clerk
Kept track of insurance proceeds and expenses.
Created new GLs/ Division Codes as required and System Admin for Sage 50
Assisted Tax consultant for project costing to file Manitoba Taxes for holdback release.
Assisted CFO for opening balance sheet and working capital at the time of acquisition
Prepared various reports manually from Sage to be pulled out automatically from Microsoft Dynamics Great Plains
Validated and Tested vendor data and EFT files in Great Plains for accuracy of data transfer
General Accountant - ACS, Toronto, ON Oct 2015 – Feb 2017
Full cycle accounting for ACS Inc (parent company in US) and Alcolock Florida (US Subsidiary)
Prepared and analyzed monthly Income Statements and Balance Sheet for ACS Inc and Alcolock FL
Prepared amortization schedule of Fixed Assets and Capital Assets
Prepared inventory schedule
Reconciled intercompany transactions for unrealized gains/losses
Reconciled Bank Statements for ACS Inc & Alcolock FL
Month-end, quarter end and year end closings.
Monthly filing of Sales and Use Tax for Alcolock FL as per IRS
Monthly /Quarterly filing of HST/ QST / PST for ACS Corp, Alcolock Quebec and GIS Canada
Prepared Cash Projection report on a weekly basis
Monthly reconciliation of Prepaid account
AP Clerk - Norton Rose Fulbright Canada LLP April 2012- May 2014
AP Clerk- TransGlobe Apartment REIT Sept 2010- Feb2012
AP Clerk - CEVA Freight Canada Corp Mar 2007 - Aug2010
Responsible for full AP Cycle- coding, posting (USD/CAD), generating cheques, matching, filing
Responsible for full payment process, maintaining and enforcing accountability and strong internal controls to minimize risks.
Managed employee travel and business expense report and verify coding, receipts, tax amounts and approval of expense reports in accordance with the company policy.
Processed Brokers Payroll
Reconciled K84, via downloading the reports from two different systems, compared the reports by using VLOOK-UP function in Excel and adjust the discrepancies and booked cheque
Ensured compliance with internal controls and SOX requirements that are in place
Assisted Accounting Manager for month end and Journal Entries
Member of Focus Group to recommend process improvements for increasing efficiency and productivity (CEVA Freight)
Recommended and successfully implemented float for faster processing of invoices (CEVA, TransGlobe and Norton Rose)
Consolidated multiple pest control invoices to one monthly invoice to reduce processing time (TransGlobe)
CHARTERED PROFESSIONAL ACCOUNTANTS OF ONTARIO
Chartered Professional Accountant, Certified General Accountant (CPA, CGA)
BACHELOR OF COMMERCE – Accounting Degree