Summary
Overview
Work History
Education
Skills
Languages
Work Availability
Work Preference
Quote
Timeline
Generic
Robert Macdonald

Robert Macdonald

Sarnia,ON

Summary

Professional with strong background in accounting, equipped to drive financial accuracy and efficiency. Skilled in financial analysis, budgeting, and regulatory compliance. Known for reliable collaboration with teams and adaptability to changing needs. Excel in delivering results through strategic planning and problem-solving with complete client confidentiality.

Overview

10
10
years of professional experience

Work History

Consulting Advisor

RM Consulting
05.2024 - Current
  • Assist in the implementation and setup/customization of QuickBooks Online for new businesses and advise on best practices
  • Setup and link third party payroll accounts such as Payworks
  • Assist with the development of time tracking sheets and/or other internal policies and procedures where necessary
  • WSIB/HST Declarations and Remittances
  • Posting Bank and Credit Card transactions
  • Account Reconciliations

Accountant/Consulting

Lakeside Childcare & MRC
12.2023 - 05.2024
  • Implementation of Sage Accounting for Small Business Software
  • Recording back-dated entries from August 1, 2023, to December 1, 2023, and forward
  • Transition Payroll from MRC (sister company) to Payworks under Lakeside Childcare (Setup timesheets, hourly tracking, payroll masterfiles, etc.)
  • Tracking Due to/from accounts for funds used in the initial renovations for the LSCC daycare startup
  • Train MRC Billing Manager on Payworks solution and provide training on Sage Accounting Software
  • Use of HiMama/Lillio for Accounts Receivables processing and Worldline-Bambora through the Lillio software for incoming tuition payments
  • Training Billing Manager on Accounts Receivables processing within Lillio and Sage
  • Training Billing Manager on Accounts Payable processing and bill payments in Sage
  • Mainstreet Banking and use of Paymentstream AFT services
  • Complete and submit required reporting to the County of Lambton for CWELCC Capital Funding, WEG/AI, CWELCC GAP Funding, and CWELCC Fee Reduction Claims

Senior Accountant

Lasalle Agri Inc
06.2023 - 10.2023
  • Accounts Receivables processing and customer data validation within Quickbooks to ensure timely delivery of invoices, ultimately reducing AR turnover
  • Review and monitor accounts receivable aging reports weekly for follow-up on past due accounts in coordination with sales managers
  • Update internal process documentation where changes have been made
  • Process Credit Card reconciliations for over 30 corporate cards (development of more efficient processes to hold cardholders accountable for the validation of expenses and submission of receipts)
  • Involved in management discussions with outside consultants regarding the implementation of new accounting procedures including accruals, inventory management, cash flows, and capitalization of various assets
  • Cheque deposits using teller scan through the RBC online portal
  • Posting cash receipts for cheques, direct customer payments, and intercompany transfers

Senior Accountant/Financial Lead

Thrufow Inc
03.2018 - 01.2023
  • Manage all day-to-day bookkeeping activities and facilitate the complete month-end process
  • Conduct monthly reconciliations for all bank and balance sheet accounts to ensure financial integrity
  • Produce monthly multi-division financial statements (Multi-year Income Statement, Balance Sheet, Cashflow, Statement of Retained Earnings)
  • Financial forecasting and analysis of variances from prior period reports and the company budget
  • Provide necessary working papers/documents to CFO/KPMG for yearend Review Engagement
  • Prepare and submit backup documentation in response to CRA audit of travel expenses resulting in a clean audit report
  • Review documents and accounts for discrepancies and resolve variances
  • Training of new controllers in 2021 and 2022; acted as the financial lead in the absence of the controller
  • Oversee Sage 50 software transition to Cloud in 2020 (Extensive Sage 50 technical knowledge)
  • Sage 300 Implementation kicked off January 1, 2022 (Sage 300 F/S ready for first QTR)
  • Oversee accounts payable; monitor cash flow and aging reports to ensure timely payment of all outstanding invoices (train/oversee accounting support staff)
  • Review accounts receivable invoices for accuracy and monitor aging reports to facilitate collections on past due accounts
  • Manage accounts receivable insurance (credit applications, bank reports, reporting, etc.)
  • Process and pay internal/external sales commissions monthly
  • Payroll processing and benefits
  • Security System Administrator – Neware Paradox system with occasional third-party support from Security One
  • Work with management to develop and implement administrative policies and procedures
  • Assist with annual budget for each operating division including bonus pay structure
  • Inventory management and adjustments (reconciled monthly)
  • Foreign exchange sales and management of multi-currency bank accounts including bank reconciliations
  • Analyzed financial statement discrepancies, identifying issues, and recommending corrective actions to prevent future occurrences

Production Associate/Maintenance

Sof Surfaces Inc
07.2008 - 10.2013
  • Developed firsthand knowledge of product costing based on direct material inputs
  • Use hydraulic presses and mixers, material augers, forklifts, Bobcats, etc
  • Worked efficiently by providing basic maintenance of equipment and applying problem-solving skills
  • Troubleshooting mixers, presses, augers, and material flow problems on a routine basis
  • Supervising/training new hires in a team environment, while ensuring high-level quality and output

Education

CPA Candidate - Accounting

CPA Ontario
ON

Bachelor of Business Administration - Accounting Stream

Nipissing University
Remote, ON
12.2017

Business Administration - Advanced Diploma - Accounting Stream

Lambton College
Sarnia, ON
08.2016

Skills

  • Proficient in Microsoft Office 365
  • SAGE 50/SAGE 300
  • QuickBooks Desktop/Online
  • Budgeting and reporting
  • Financial audit assistance
  • EHT/WSIB reporting processes
  • Account reconciliation expertise
  • HST compliance and reporting
  • GAAP compliance expertise
  • Intercompany transactions
  • Payroll management
  • Foreign currency transactions/FX sales
  • Month-end closing coordination
  • Meticulous attention to detail
  • Analytical thinking/Critical analysis
  • Commitment to client confidentiality
  • Effective written communication
  • Effective team collaboration
  • Skilled in prioritizing tasks under stress
  • Financial reporting/variance analysis

Languages

English

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Work Preference

Work Type

Full TimeContract WorkPart TimeInternship

Work Location

RemoteOn-SiteHybrid

Important To Me

Career advancementWork-life balanceCompany CultureFlexible work hoursHealthcare benefitsWork from home optionPaid time offPaid sick leave

Quote

Do not go where the path may lead, go where there is no path and leave a trail.
Ralph Waldo Emerson

Timeline

Consulting Advisor

RM Consulting
05.2024 - Current

Accountant/Consulting

Lakeside Childcare & MRC
12.2023 - 05.2024

Senior Accountant

Lasalle Agri Inc
06.2023 - 10.2023

Senior Accountant/Financial Lead

Thrufow Inc
03.2018 - 01.2023

Production Associate/Maintenance

Sof Surfaces Inc
07.2008 - 10.2013

CPA Candidate - Accounting

CPA Ontario

Bachelor of Business Administration - Accounting Stream

Nipissing University

Business Administration - Advanced Diploma - Accounting Stream

Lambton College

Similar Profiles

CREATE PROFILE
Robert Macdonald