CPE & Event Calendar

You could pay $0 for this course!This course qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% of the cost of training reimbursed. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website a minimum of three weeks before the start date of the course to be eligible. The course code for this program is C-6212. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.Save time and keep current on the latest tax developments. This comprehensive course covers all legislative, judicial, and IRS developments of the past year with a focus on implementation and compliance. Discover how to effectively and confidently complete tax planning and compliance engagements. Cover current developments affecting individuals (including those regarding income, deductions and losses, tax calculations, individual credits, filing matters), business entities (including those regarding S corporations and their shareholders, C corporations, partnerships), estates and trusts, retirement plans, and more.

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is 1137506. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.As spreadsheets evolve, so must your creating, editing, and auditing practices. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today's best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this "must-see" CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel fully.

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is C-3368. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.Most review techniques developed by professionals are self-taught and fine-tuned via experience. Yet how does one start? The purpose of this course is to give both new and seasoned reviewers additional and advanced procedures via a multitude of checklists to thoroughly review various tax returns. Its emphasis is not planning; rather, it is to develop a strategy to properly review a return effectively and thoroughly. The course includes dozens of practice tips for new reviewers and is updated for impacts of newly enacted legislation.

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is C-8023. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.Artificial Intelligence (AI) and automation tools offer incredible opportunities for all business professionals to improve productivity and accuracy. For example, generative AI tools such as ChatGPT and Bard can be beneficial when conducting research or drafting reports and correspondence. Likewise, Microsoft's Power Automate platform and similar tools such as Zapier can help you elevate efficiency to levels you may have thought unattainable. If this sounds appealing, plan to participate in this session to modernize your workflows and take advantage of these tools. This session will teach you practical applications of today's AI and automation tools. Moving beyond fundamental discussions, you will learn how to use AI and automation to streamline workflows, improve internal control, maximize productivity, and even improve team member morale. In addition, you will learn about some potential pitfalls associated with these technologies and how to avoid making mistakes when using these tools. In sum, this session is "must-see CPE," and you should plan to participate in this class today.

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbursement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible 1137511. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.orgWith the explosion of technology over the past thirty years, one fair question is, "what are the ethical considerations and impacts related to this technology?" Of course, practical technology issues such as data privacy and security undoubtedly carry ethical considerations. However, technology also affects the ethics associated with work-life balance, the digital divide, training needs, copyrights, and fraud, to name a few. This course will teach you about "technoethics" and its implications for individuals and organizations. To that end, you will explore many current and emerging issues associated with ethics and technology, such as copyrights, cybercrimes, privacy versus security, and geo-tracking technologies. Given the profound implications of ethics and technology, this could be the most impactful session you will ever attend.

The ultimate objective of a financial statement audit is to issue the independent auditor's report. Reviews and preparations are different. This course discusses the review and preparation process, introduces key elements of financial statements, and provides best practices for auditors who either prepare or review the client's financial statements. Most CPA firms perform some level of compilation and review engagements, and some perform engagements under attestation standards. This course provides a deep dive into the most frequently missed issues in compilations and reviews engagements. We will also focus on attestation engagements and the various types of engagements a CPA can perform.

The most difficult concepts to master when dealing with flow-through business entities are the basis and distribution concepts. Major error and malpractice issues occur if the CPA does not fully understand the impact of these rules. This course is designed to focus on the practical applications of these rules.

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is 1138118. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing - three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills.

Tax practitioners advising their business clients must be fully informed regarding the multiple loss limitation provisions that apply to individuals conducting businesses and pass-through entities. This program covers the loss limitation rules that tax practitioners must know in order to advise their individual and pass-through entity clients fully and adequately as to when and if a loss limitation applies. The loss limitations discussed in this program start with an introductory discussion of hobby loss rules and graduate to a more substantive discussion of the remaining loss limitations: basis limits, at-risk rules, passive loss limits, excess business loss limits, net operating losses, and the Section 163(j) interest limitation. Knowing when loss limits apply is essential for any tax practitioner. This program will put you in a position to advise clients fully and intelligently regarding each of the loss limits.

Forensic accounting encompasses fraud investigation and prevention, as well as a wide variety of functions in litigation. Forensic accountants provide services ranging from serving as an expert witness, to litigation consultant and bankruptcy trustee. As our economy grows more complex, the need for forensic accountants grows as well. One critical role of the forensic accountant is exposing and examining financial fraud. Technology expands the way companies conduct business; however, technology also provides greater opportunities for those willing to commit fraud. Forensic accountants rely on their skills in accounting, coupled with their investigative skills, to explain to clients, courts, and jurors how fraudulent schemes occur and the effect caused by fraud. Forensic accountants also provide expert opinions in calculating damages in litigation and administering bankruptcy estates, as well as a host of other services.

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is 1138598. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel's more advanced features - some new and some legacy - to elevate your productivity to higher levels. In this session, you will learn about many of Excel's newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel's FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

Instances of financial statement fraud have occurred ever since the first financial statements were prepared. Financial statement fraud poses a significant threat to all businesses regardless of size. In this program, we will discuss fraud, the Fraud Triangle, who commits fraud, fraud red flags and motivations to commit fraud, common fraud activities, COSO internal controls, and selected financial statement fraud case studies.

This course is a `deep dive' into all things real estate tax-related for the mid-level practitioner moving into this complex area. You will deepen your understanding of the complex considerations and strategies that individuals must navigate in acquiring, holding, managing, constructing, and disposing of real estate. You will leave the course able to navigate critical issues associated with the relevant returns and plan strategically for your company or clients. We will discuss in detail the impact of recent tax legislation, as well as historically difficult areas of the law like passive activity and at-risk rules.

You could pay $0 for this course!This course qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% of the cost of training reimbursed. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website a minimum of three weeks before the start date of the course to be eligible. The course code for this program is C-9414. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.This 2-hour mini course is from our Level V course, which highlights leadership skills and situations that are common for managers and senior managers in CPA firms. Participants will be encouraged to examine and challenge their beliefs and approaches to managing and leading people. Leading Others - Coaching & Developing Staff - prioritizing the coaching and development of staff in a post-pandemic work environment, including delegation for development, effective feedback, and managing virtual employees. Building Leadership Communication Skills - strategies to influence and lead others through effective communication in both individual and group settings. Helping the Firm Grow - the three levels of helping the firm grow and how to involve the entire team in expanding services to existing clients and generating referrals to new clients. All of AHI's courses rely heavily on participant interaction and these virtual programs have co-opted many of Zoom's features to preserve the same strengths of the in-person training: visual interaction between the instructor and all participants (plan to be "on screen" throughout the program) breakout rooms to ensure small group engagement and instructor interaction screen share for small group presentations easy delivery of video presentations fillable PDF for online note-taking in the course material.

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is 1138116. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment. Isn't it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.

You could pay $0 for this course!This course qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% of the cost of training reimbursed. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website a minimum of three weeks before the start date of the course to be eligible. The course code for this program is C-8960. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.This course is designed for firm partners and managers to explore ways to incorporate data analytics and related technologies in their audit practices. Participants explore how small and mid-size firms are using these tools to improve engagement efficiency and quality while providing opportunities for value-added services to clients. All of AHI's courses rely heavily on participant interaction and these virtual programs have co-opted many of Zoom's features to preserve the same strengths of the in-person training: visual interaction between the instructor and all participants (plan to be "on screen" throughout the program); breakout rooms to ensure small group engagement; and instructor interaction screen share for small group presentations easy delivery of video presentations fillable PDF for online note-taking in the course materials.

This course addresses the most recent tax legislation, rulings and developments occurring in 2022-23 that will impact both the business and individual taxpaying client. The course is designed to prepare the practitioner for the upcoming filing season and provide useful strategies to assist in the tax preparation process.  

When a purchaser buys an existing partner's partnership interest or the interest of a member of a limited liability corporation (LLC) taxed as a partnership, the amount paid becomes the basis for the purchaser's partnership interest (outside basis). If the partnership's assets have appreciated sufficiently, the difference between the new partner's inside and outside basis can be substantial. This disparity can deprive the new partner of depreciation deductions and inflate his or her share of the gain from subsequent property dispositions unless a Section 754 election is in effect. The Section 754 election can also apply when a partnership makes a distribution of property and the basis of the distributed property to the partnership and the basis the partner/distributee will take in the distributed property are not equal. In this case, a partnership can recover basis it would otherwise lose if the 754 election were not in effect.

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is 1130296. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel's "legacy" features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to format your spreadsheets quickly and efficiently to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.

Tax practitioners are responsible for presenting partner capital accounts on the tax basis. But what does this mean and how have rules changed in recent years regarding partner capital accounts? This course covers exactly that. For tax practitioners preparing partnership 1065 forms, this program explains these complex rules in practical and understandable terms.