Saurabh Gupta
Victoria
Summary
Analytical Accounts Receivable Specialist with successful career supervising one personnel, including training, work allocation and problem resolution. Skilled in financial statement preparation, general ledger activities, accounts receivable processing and collections. Effective leader with 15 years of hands-on experience in education and diplomatic organisation.
Overview
16
16
years of professional experience
Work History
Bank Reconciliation Accounts Receivable Coordinator
High Commission of Canada in India, New Delhi
01.2014 - 08.2023
- Preparing monthly bank reconciliation packages for 21 bank accounts in 17 client missions and forwarding them to the Finance Section Manager (FSM) for approval
- Managing and supervising assigned team with the workload, advising about service standards and procedures, and ensuring quality delivery of mandated responsibilities of the Common Service Delivery Point (CSDP)
- Preparing weekly and monthly dashboards using data analytical software (ACL and Microsoft Power-BI) , which helps higher management make decisions by monitoring key performance indicators
- Reviewing asset and liability GL accounts every quarter to ensure that recoverable are followed up, petty cash and other advances are in order, and accounts payable entries are accurately recorded
- Monitoring bank balances in mission bank accounts and repatriating excess funds to headquarters in Ottawa
- Collecting cash and cheques for consular revenue and depositing with the bank
- Managing banking relationships on behalf of CSDP and liaising between headquarters and regional banks
- Posting of revenue and bank adjustment entries in the financial management system (SAP)
- Performing cheques encashment
- Analyzing the Financial Administrative Act and financial directives to provide appropriate information to clients
- Reviewing budgets for programs and contributing to the forecasting for next year
- Dealing with complex vendor payments and acquisition card payment issues
- Developing and maintaining standard operating procedures (SOPs) and memorandum of understanding (MOU) and contributing towards standardization of business processes
- Providing training to staff on various finance processes
- Participating in client mission outreach programs through online or face-to-face training (Open House)
- Dealing with interdepartmental settlement transactions
- Manages the client service process and system within the Common Service Delivery Point (CSDP) Section; assesses and recommends on requests for exceptions to mission standard practice
- Reviewing agreements and funding arrangements with third parties in connection with Specified Purpose Accounts (SPA).
Manager Exams Finance - India
British Council, New Delhi
04.2013 - 12.2013
- Performed Month end activities like Accrued expenditure and Deferred income
- Monitored various cost elements, posting corrections, and intercompany journals to show the correct financial reports
- Managed monthly income reconciliations of £ 7 Million from different exams like IELTS, Aptis, University Exams, and Professional Exams
- Recorded all incomes accurately in SAP and processed Freelance Examiners’ payments through separate software for an average of 200 Examiners
- Resolved queries related to Bank Reconciliations, Purchase to Pay and Sales
- Review and follow up for Aged Debtors and outstanding invoices with clients and operations and take follow-up with appropriate action to clear them
- Development of internal control, policies and procedures & ensuring their implementation and monitor compliance on finance & operation systems
- Monitor budget management systems for India and Nepal examinations to ensure accurate and uniform application of revenue and expense codes.
Senior Executive- Accounts Receivable and Bank Reconciliation
British Council Management Services Pvt Ltd
02.2009 - 04.2013
- Uploading Bank statement in SAP and reconciliation of various bank accounts
- Get the payment advices from customers, Business Partners and Vendors for the allocation of received money against their account
- Liaise with the HSBC bank and Customers to get information on the unidentified incomes
- Identify the payment rejections and do the arrangements for reissue
- Extraction of Age Debt Report and try to identify the incomes received from Business Partners
- Working with credit control team to recover the amount from customer
- Processing of Invoices, operation advance, and dealing related Queries Payment Run Processing Vendor Management and Reconciliation Cheque Management (includes assignment and cancellation of cheque) Working on reports (Open PO report, GR/IR reporting, and Aging report)
Associate- Accounts and Finance
Intercontinental Hotels Group, New Delhi
03.2007 - 01.2009
- Order 2 Pay (Invoice Processing) Vendor And Requestor Setup Specialty (Support To Team Members) Vendor Statement Reconciliation Customer Process Support
Education
Masters of Global Management -
Royal Roads University
Victoria, BC05.2025
Master of Business Administration (MBA) -
Sikkim Manipal University
New Delhi, India05.2010
Masters of Commerce (M. Com) -
Himachal University
New Delhi, India06.2007
Bachelor of Commerce (B. Com) -
University of Delhi
New Delhi, India05.2005
Skills
- SAP FICO, Tally, ERP Package People Soft 88, QuickBooks
- Power-BI and ACL
- Team building and networking skills
- Strategic and analytical thinking
- Cross-cultural communication
- Invoice Processing
- Microsoft Office
- Payment tracking
- Cash application
- GL Reconciliation
Courses Certifications
- CSDP Finance Learning Program, Canadian Foreign Service Institute, Ottawa, ON, 08/2016, 12/2016
- Foundations of ACL, MPK Data Analytics, AZ, 12/2021
Recognitions
- Change Management Award, 06/2015, High Commission of Canada in India for outstanding performance to implement change in the High Commission’s operations.
- Spirit Award, 06/2017, High Commission of Canada in India for initiative to improve workplace morale and build team spirit at the High Commission of Canada.
Internship
- Article Assistant, 06/2002, 01/2005, M/s Atulya Jain & Co. (Chartered Accountants)
- Accountant, 02/2005, 02/2007, M/s Priyanka Autos (Manufacturing Unit)
Volunteer Experience
- Vice President Finance and Services, 11/2023, Royal Roads University Student Association, Victoria, Canada. RRUSA’s purpose is to enrich the lives of its on-campus and blended full-time undergraduate & graduate students and stakeholders.
- Co-Chair, 04/2017, 03/2018, Social Committee, The High Commission of Canada, New Delhi. The social committee was responsible to plan and organize social and festival events for locally engaged and Canadian based staff.
- Treasurer, 10/2017, 03/2021, UNNATI Resident Welfare Association. The role of RWAs is to look into improving the amenities and shared facilities for the residents.
Languages
English
Full Professional
Timeline
Bank Reconciliation Accounts Receivable Coordinator
High Commission of Canada in India, New Delhi
01.2014 - 08.2023
Manager Exams Finance - India
British Council, New Delhi
04.2013 - 12.2013
Senior Executive- Accounts Receivable and Bank Reconciliation
British Council Management Services Pvt Ltd
02.2009 - 04.2013
Associate- Accounts and Finance
Intercontinental Hotels Group, New Delhi
03.2007 - 01.2009
Masters of Global Management -
Royal Roads University
Master of Business Administration (MBA) -
Sikkim Manipal University
Masters of Commerce (M. Com) -
Himachal University
Bachelor of Commerce (B. Com) -
University of Delhi
Similar Profiles
Harish DhyaniHarish Dhyani
Administrative Officer Decision Maker (AODM) at British High Commission New DelhiAdministrative Officer Decision Maker (AODM) at British High Commission New Delhi
Swaraj MalekarSwaraj Malekar
INTERN – OSTI Program May’23 at National Human Rights Commission (NHRC) / Delhi, IndiaINTERN – OSTI Program May’23 at National Human Rights Commission (NHRC) / Delhi, India
KELTIE PATTERSONKELTIE PATTERSON
FPDS Program Manager at High Commission of Canada in New ZealandFPDS Program Manager at High Commission of Canada in New Zealand