myCPE
myCPE

QuickBooks Advanced Certification (QBAC)

Gain a competitive edge with in-depth skill focused program

Last Updated

December, 2024

Accountant/Bookkeeper/Tax Professionals, CPA in Canada, CPA (US)
28 Hours 
On Demand
Included with Subscription

Why Professionals Trust Our Advance Certification Programs

  • Access to cutting-edge industry knowledge and practices.
  • Comprehensive training designed to meet professional needs.
  • Fulfill compliance requirements while acquiring valuable skills.
  • Ongoing updates to course content for relevant industry trends.
certificate
certificate
certificate

What You’ll learn

Elevate your QuickBooks proficiency to new heights. The QuickBooks Advanced Certification (QBAC) is designed for professionals seeking to refine their abilities in managing complex transactions, navigating multicurrency settings, and mastering advanced reporting techniques. Immerse yourself in sophisticated project management, smooth integrations, and meticulous year-end processes. Equip yourself with the advanced knowledge required to confidently tackle the most intricate QuickBooks functions.

Get Deeper Understanding of:

  • Managing exchange gains/losses in QuickBooks Desktop.
  • Handling loans, bounced checks, and bartering in QuickBooks.
  • Customizing reports and using pivot tables for efficient analysis.
  • Integrating QuickBooks with apps for industries like healthcare and cannabis.
  • Managing not-for-profit accounting, including donor and grant tracking.

Recommended For:

  • CPAs, Accountants, and advanced QuickBooks users looking to enhance their expertise in handling complex transactions, multicurrency management, and advanced reporting features beyond basic QuickBooks functionalities.
  • Professionals in finance, accounting, or bookkeeping who aim to elevate their QuickBooks proficiency for managing large-scale projects, integrating third-party applications, and handling year-end processes effectively.
  • Individuals seeking to master advanced QuickBooks skills to improve business efficiency, automate workflows, and confidently handle intricate financial tasks in dynamic business environments.

Why take the QuickBooks Advanced Certification (QBAC) Course with MYCPE ONE?

Resources included

  • Handout PDFs for every Module
  • Glossary/Key Terms for every module
  • Q&A directly with instructors.

Career Opportunities

  • Senior Financial Analyst
  • QuickBooks Integration Specialist
  • Advanced QuickBooks Consultant
  • CFO
  • Financial Controller
  • Accounting Software Specialist

Value Addition to your skills

  • Advanced Multicurrency Management
  • Project and Job Costing Expertise
  • Third-Party Integration
  • Advanced Reporting Skills
  • Year-End Procedures Proficiency
  • E-commerce Automation within QuickBooks

Courses

Course Title Time
1 Hour
  • Analyze when and how to track multiple currencies in QuickBooks Desktop and the effects of enabling Multicurrency.
  • Recognize the risks and concepts associated with multiple currencies, including exchange rates.
  • Discuss the process of turning on Multicurrency and its impact on your QuickBooks Desktop file.
1.5 Hours
  • Identify the sales and purchase workflows involving foreign currencies and how they affect exchange gains or losses in QuickBooks Desktop.
  • Recognize and analyze the Exchange Gain or Loss account and its impact on foreign currency transactions.
  • Inspect how transfers between currencies are recorded and use the QuickBooks Currency Calculator for accurate conversions.
1.5 Hours
  • Identify how to access and create Home Currency Adjustments, and recognize their impact on the Exchange Gain or Loss account.
  • Describe the process for maintaining static foreign price lists and analyze the QuickBooks Desktop versions required for this feature.
  • Recognize how purchase orders function in a Multicurrency environment and their effects on transactions.
1.5 Hours
  • Identify how to report on foreign currency and exchange gains/losses, and display foreign amounts in QuickBooks Desktop reports.
  • Describe troubleshooting methods for discrepancies in A/R and A/P sub-ledger reports and year-end adjustments for foreign currency accounts.
  • Recognize potential fraud or mistakes, and analyze how to troubleshoot unusual situations for Multicurrency companies in QuickBooks Desktop.
3.5 Hours
  • Practice using QuickBooks Online for Projects, Progress Invoicing, and Job Costing.
  • Review Standard Legal Notices in the context of these features.
  • Discuss settings, progress invoicing, and project management in QuickBooks Online.
4 Hours
  • Identify QuickBooks features and techniques to streamline reports for faster analysis in Excel.
  • Recall how to analyze QuickBooks data using pivot tables in Excel and utilize the Text to Columns feature.
  • Define ideal data for pivot table reports and identify settings and keystrokes for managing Excel files and Slicers.
1 Hour
  • Identify the purpose and steps for implementing third-party apps in the QuickBooks ecosystem.
  • Describe how to address change management during app integration.
  • Discuss best practices for ensuring a smooth experience with third-party apps in QuickBooks.
2 Hours
  • Describe how to connect common payment gateways and manage eCommerce imports in QBO.
  • Identify considerations for importing individual transactions versus daily summaries and the role of clearing accounts.
  • List methods for managing merchant service fees and when 3rd party apps are necessary to automate e-commerce imports.
2 Hours
  • Identify and correct incorrectly categorized transactions, ensuring accurate bank balances.
  • Adjust inventory totals and close out owner equity at year-end.
  • Run key reports for business analysis and taxes, and perform necessary year-end closing actions.
2 Hours
  • Review year-end steps to ensure your books are accurate, including categorizing expenses and reconciling bank accounts.
  • Close out Opening Balance Equity and Owner’s Equity for year-end.
  • Understand and apply depreciation processes for accurate financial reporting.
2 Hours
  • Specialize accounting services for healthcare service providers, focusing on HIPAA compliance and tax issues.
  • Identify the best QuickBooks Online accounts for healthcare providers and manage bank feeds for consistency.
  • Address 1099 issues and implement tax planning strategies for private practitioners, including those practicing in multiple states.
3 Hours
  • Identify how to add situation-specific accounts to the Chart of Accounts.
  • Manage a Line of Credit and separate loan payments for principal, interest, and debt protection insurance.
  • Process bounced checks and track bartering for accurate income and expense reporting.
1 Hour
  • Configure QBO settings, Chart of Accounts, and tax centers for cannabis-specific operations.
  • Implement efficient workflows and integrate cannabis-focused apps for inventory, sales, and bookkeeping.
  • Develop customized reports and insights tailored to cannabis business models.
2 Hours
  • Analyze how to set up Accounts and track programs.
  • Manage donors, fundraising, and restricted grants using specialized tools.
  • Utilize classes, budgeting, and unique QBO options for nonprofit organizations.
Disclaimer : Before attending any course, please verify that the credit details align with your qualification requirements. This certificate is designed to help you acquire new skills and knowledge, which may or may not fulfill specific compliance criteria. While we have made every effort to ensure our courses adhere to compliance standards, we recommend reviewing the details to confirm applicability for your needs.

Instructors

Get Started with Unlimited Learning

Select your plan, complete your payment, and access a world of knowledge.

Subscription Inclusions Silver Gold
13,000+ Hrs of CPE approved Content
tooltip

Largest content library covering all aspects of professional development.

500+ Emerging Subject Areas
tooltip

Wide range of subject areas tailored to meet diverse learning needs of all the department of the firm.

50+ State- Specific Ethics Courses
tooltip

Stay compliant with ethics requirements for every state.

50+ State Compliance Packages
tooltip

Pre-selected courses for quick compliance, saving time and effort.

100+ Advanced Certification Programs
tooltip

Expert-led programs to build advanced expertise and strengthen your career credentials.

AICPA Eligibility Programs (CFF, ABV, PFS)
tooltip

Pre-Packaged Eligibility Courses for AICPA designations such as PFS, ABV, and CFF, offering CPE credits upon completion.

Compliance Tracker and Credit Vault
tooltip

Store all your certificates in one place, stay compliance-ready with ease, and track your progress effortlessly using the built-in credit tracker.

Instant Certification and Fast Reporting
tooltip

Instant reporting to IRS, CFP Board, and other governing bodies.

Mobile App Access (iOS and Android)
25+ Premium Training Programs
tooltip

Focused training with pre-built assessments for all levels to upskill your staff efficiently.

Exclusive Access to Communities
tooltip

Join communities tailored to your specific interests and areas of expertise.

Winter Wisdom
Ends Soon!

Start Your Subscription 

Start your journey towards learning and compliance.

$299$199 For 12 Months

More Reasons to Subscribe

  • true true
    80% of Content Rated 4.5+ Stars
    High-quality content rated by professionals.
  • true true
    4X More Content at 1/3rd the Price
    Serious value compared to your regular provider!
  • true true
    Non-Sponsored Content
    Purely educational, unbiased content for your learning.
  • true true
    Monthly & Quarterly Updates
    Keeping you ahead of trends and changes.
  • true true
    Podcasts with Industry Leaders
    Learn and Earn CPE from experts on the go.

Team Subscription for CPAs & Accounting Firms

  • true true Comprehensive Content Library
  • true true CPE Compliance Automation
  • true true Advanced Training Solutions
  • true true Learning Management System
  • true true Event and Webinar Management

Frequently Asked Questions

This certification covers advanced QuickBooks topics designed for professionals who want to master complex accounting processes. Key areas include managing multicurrency transactions, handling job costing and project management, integrating QuickBooks with third-party applications, automating e-commerce workflows, and mastering year-end closing and troubleshooting reports. By completing this course, you’ll gain in-depth knowledge on advanced features, ensuring you can manage sophisticated financial tasks in QuickBooks with confidence.

This certification will elevate your QuickBooks expertise, allowing you to manage complex transactions, automate processes, and streamline accounting operations. You'll learn to integrate QuickBooks with external systems and manage high-level accounting functions like multicurrency transactions and advanced reporting. These skills will make you a go-to expert in your field, enabling you to support more complex business needs and enhance your efficiency, accuracy, and ability to handle diverse financial challenges.

Certificate course is created by a qualified and experienced instructor(s). myCPE Certificate Courses includes Self-study Courses. Most of the courses are in the form of On-demand Videos. The Self-study Video courses in Certificate courses may be Live recorded presentations converted into Self Study (On-Demand Videos).

You can take your time and attend the course at your own pace. You can take exam unlimited time. So, don’t worry, if you are not able to pass an exam. You will be getting a chance to attend the exam again.

After completion of each course of this Certification Programs, you will be able to download a certificate with the course title and number of hours. Certificates, as well as your study records, are stored for life and you can access them anytime. Certificates are valid proof for your continuing education credits and you can also add it as an additional designation.

Once you register you will have complete access to all the courses of this Certification Programs. The self-study format allows you to access the material online 24x7 and study at your own pace.

As per NASBA guidelines, you have one year from date of purchase of your certificate to complete each program. After completion of each course, you can attend final exam any time and get CPE Credit instantly. You can retake the exam multiple times without any additional charges.

Course have minimum passing score of 70% in the final exam and you can take multiple attempts of the said exam.

Our video player tracks & stores the watch time and will show you in the progress bar. But you make sure that you don’t fast forward or manually try to move the progress bar. If you have fast forwarded the video or tried to manually move the progress bar of the video. System wouldn’t capture your watch time. So please, let the video go on its own. However, being on-demand video you can pause and play and whenever you want and you can watch it in pieces. It will pick up from where you left off. So, for a self study courses you will have to
1. Complete the entire video 100%.
2. Answer all the review questions correctly. The review questions are at the bottom of the same page where you are viewing the course video.
3. Once you have watched the whole video and answered all the review questions, the Final Quiz will open up. You need to score more than 70% in the Final Quiz to avail your CPE credit. Multiple attempts are allowed for submitting Review and Final Quiz questions.
4. Once you have completed the Review and Final quiz questions, you shall be able to download the credit certificate from the ‘My Certificates’ section. Kindly ensure you have allowed Multiple File download from your web browser to download all certificates.
5. You can download individual certificate from your "Account" as well as from this page once you complete a particular courses. Also, you can download "Consolidated Certificate" from the package page or from your account.

A Self-study course is a recorded video (If it’s a recording of a live course you may see polling questions appearing on the screen. You do not need to answer the polling questions and just let the video play). Do not fast forward. If you fast forward, we may not be able to capture your watch time and you may be required to watch it multiple times. In order to avail your credits for the self-study course, you need to answer the review questions correctly and complete the entire video. Once you have done that, the Final Quiz will open up in which you need to score a minimum 70% to qualify for the credit. You can attempt multiple times for answering the review questions and Final quiz questions. Once you have completed the Review and Final quiz questions, you shall be able to download the credit certificate from ‘My Certificates’ section.
If neither of the above cases works, please drop an email to support@my-cpe.com or contact our support team through live chat support.

The evaluation form will be sent to attendees in the next 24 hours after passing the final quiz with at least 70% marks. Kindly note that the evaluation form will only be available to attendees who remained logged in till the end of the course and answered all the polling questions.

MY-CPE LLC is PCI Compliant - Approved. myCPE uses a secure payment gateway (Stripe.com) to process your payment details. This payment gateway is in accordance with the PCI-DSS Compliance. Therefore, your payment details are secure through SSL encryption. CLICK HERE to view our PCI compliance certificate. Once you have register for the package and paid for it you shall not be granted any refund unless you are not able to access courses for any reason etc.
Subscribed
Justin purchased a subscription.
Subscribed
Deborah purchased a subscription.
Subscribed
Diane purchased a subscription.
Subscribed
Brian purchased a subscription.
Subscribed
Jason purchased a subscription.
Subscribed
Kimberly purchased a subscription.
Subscribed
Sharon purchased a subscription.
Subscribed
Dave purchased a subscription.
Subscribed
Yali purchased a subscription.
Subscribed
Angela purchased a subscription.
Subscribed
Neli purchased a subscription.
Subscribed
Kassandra purchased a subscription.
Subscribed
Jennifer purchased a subscription.
Subscribed
Pratisha purchased a subscription.
Subscribed
Lisa purchased a subscription.
Subscribed
Tyler purchased a subscription.
Subscribed
Alexander purchased a subscription.
Subscribed
Madison purchased a subscription.
Subscribed
Rami purchased a subscription.
Subscribed
Hollie purchased a subscription.
Subscribed
Tim purchased a subscription.
Subscribed
Mark purchased a subscription.
Subscribed
Nathaniel purchased a subscription.
Subscribed
Susan purchased a subscription.
Subscribed
Susan purchased a subscription.
Subscribed
David purchased a subscription.
Subscribed
DOROTHY purchased a subscription.
Subscribed
Natasha purchased a subscription.
Subscribed
Seid purchased a subscription.
Subscribed
Keith purchased a subscription.
Subscribed
Sui purchased a subscription.
Subscribed
Dominique purchased a subscription.
Subscribed
Danny purchased a subscription.
Subscribed
Roger purchased a subscription.
Subscribed
Michael purchased a subscription.
Subscribed
Jennifer purchased a subscription.
Subscribed
RICHARD purchased a subscription.
Subscribed
Angela purchased a subscription.
Subscribed
Heather purchased a subscription.
Subscribed
SARAH purchased a subscription.
Subscribed
Grayham purchased a subscription.
Subscribed
Jeanne purchased a subscription.
Subscribed
Keesha purchased a subscription.
Subscribed
David purchased a subscription.
Subscribed
Jeffrey purchased a subscription.
Subscribed
Cindi purchased a subscription.
Subscribed
Mandy purchased a subscription.
Subscribed
Vasilios purchased a subscription.
Subscribed
Darrell purchased a subscription.
Subscribed
Donniece purchased a subscription.
Subscribed
Derrick purchased a subscription.
Subscribed
Artemio purchased a subscription.
Subscribed
Joanne purchased a subscription.
Subscribed
Anthony purchased a subscription.
Subscribed
Robert purchased a subscription.
Subscribed
Sophia purchased a subscription.
Subscribed
Brandon purchased a subscription.
Subscribed
Sym purchased a subscription.
Subscribed
Stacey purchased a subscription.
Subscribed
Sherry purchased a subscription.
Subscribed
Victor purchased a subscription.
Subscribed
Samantha purchased a subscription.
Subscribed
Debra purchased a subscription.
Subscribed
Fahad purchased a subscription.
Subscribed
bankole purchased a subscription.
Subscribed
Cuc purchased a subscription.
Subscribed
Hila purchased a subscription.
Subscribed
LAURA L. purchased a subscription.
Subscribed
TIMOTHY purchased a subscription.
Subscribed
cynthia purchased a subscription.
Subscribed
Christopher purchased a subscription.
Subscribed
James purchased a subscription.
Subscribed
Shirak purchased a subscription.
Subscribed
Lawrence Rhee purchased a subscription.
Subscribed
John purchased a subscription.
Subscribed
Meredith purchased a subscription.
Subscribed
Alex purchased a subscription.
Subscribed
Erica purchased a subscription.
Subscribed
Luis purchased a subscription.
Subscribed
Michelle purchased a subscription.
Subscribed
Jeff purchased a subscription.
Subscribed
Colleen purchased a subscription.
Subscribed
karl purchased a subscription.
Subscribed
Georgiana purchased a subscription.
Subscribed
Michael Scott purchased a subscription.
Subscribed
Michelle purchased a subscription.
Subscribed
Larisa purchased a subscription.
Subscribed
Cynthia J purchased a subscription.
Subscribed
Lisa purchased a subscription.
Subscribed
Octavian purchased a subscription.
Subscribed
Bettina purchased a subscription.
Subscribed
KEYUR purchased a subscription.
Subscribed
Jenny purchased a subscription.
Subscribed
Roger purchased a subscription.
Subscribed
Malinda purchased a subscription.
Subscribed
JOHN purchased a subscription.
Subscribed
Shelley purchased a subscription.
Subscribed
Elizabeth purchased a subscription.
Subscribed
Julieta purchased a subscription.
Subscribed
Christina purchased a subscription.