Quickbooks Desktop Accounting and Admin Specialist

We are a small IT company in Canada. We are seeking a detail-oriented and highly organized Accounting AND Excel Specialist to join our team. If you are skilled in Microsoft Excel, Accounting, Bookkeeping and building reports, we want to hear from you. Looking for a team member to join us and work 9AM - 5PM EST (Eastern Time Zone)

Key Responsibilities:

This position is split between two roles, there will be focus on Accounting and Project Administrative Tasks.

Accounting Role

-Proficiently use Microsoft Excel to create, maintain, and analyze financial reports and data. (MUST KNOW how to use formulas such as index, vlookup, countif, sumif, if statements, and it will be added-value if you can use VBA macro)
-Reconcile bank records with vendor bills to ensure accuracy and completeness of financial records using Accounting software such as Quickbooks Desktop, Dext and using Excel.
-Perform data entry tasks related to financial transactions, maintaining precision and attention to detail.
-Manage bookkeeping activities to keep financial records organized and up-to-date.
-Generate and send invoices to clients, ensuring all necessary information is included and accurate.
-Generate Charts, Pivot Tables, Graphs and Tables for Business Analysis. Such as PNL reports.
-Collaborate with team members to gather and input financial data into various systems.
-Assist with general administrative tasks, utilizing Microsoft 365 for communication and document management.
-Collaborate with the finance team to develop comprehensive financial reports using Excel.

Project Admin Role

-Assist in defining project scope, goals, develop detailed project plans through speaking with customers and other stakeholders.
-Ensure all team members and resources are allocated and scheduled appropriately.
-Contribute with process improvements and developing SOPs.
-Provide administrative support to the project team, including scheduling meetings, preparing agendas, and distributing materials.
-Serve as the main point of contact between stakeholders, providing updates and addressing concerns.
-Prepare and present regular progress reports to management and stakeholders.

Qualifications:

Strong proficiency in Microsoft Excel, including the ability to create complex formulas, pivot tables, and graphs.
Previous experience in report development using Excel.
Proficiency in using Microsoft 365 tools, including Outlook, Word, and Teams.
Previous experience working with Accounting, Finance, and Quickbooks would be preferred.
Excellent organizational skills and a high level of attention to detail.
Understanding of basic accounting principles and bookkeeping practices.
Remote access via VPN to work is required
Strong analytical skills and the ability to generate meaningful insights from financial data.
Exceptional communication skills, both written and verbal.
Strong problem-solving skills and the ability to adapt to changing priorities.

How TO APPLY (MUST REQUIRE):
-Please provide a link to your resume and a 30 seconds short voice clip introducing yourself. Also, fee free to share as much experience you have with Building Reports using Excel or developing Macros using Excel with us.

During Interview:
-You will be tested on your basic accounting and Excel skills (such as IF functions and lookup functions)