CPE Catalog & Events

In this course, we will focus on Text functions and Date and Time functions. Want to automatically update the date and time on your spreadsheet? Or pick text strings from other cells to automatically copy and update to a different cell? You will learn how to incorporate text, date and time functions in your spreadsheet that will make data entry a breeze. In the Text function section, you will learn how to use the various Text functions to join and separate text entries as well as formatting the results. In the Date and Time function section, you will learn how to perform various date and time calculations. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel.

This course examines actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters' ability to accomplish their nefarious acts.

Once a disaster has struck and it's time to rebuild, what resources are available? We will discuss finding money to rebuild through FEMA, charities, and the tax system, and we will discuss the tax implications of each. The Financial Remediation of Disaster Losses course is designed for CPAs, accounting, financial advisers, and tax professionals who work with individual and small business clients.

Description:This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives:After attending this presentation, you will be able to... Apply advanced Excel auditing tools, such as Trace Precedents, Trace Dependents, and the Error Checking feature, to effectively identify and rectify complex errors in financial spreadsheets. Analyze and interpret common error messages and anomalies in Excel, enabling the ability to diagnose underlying issues in spreadsheet formulas and data inputs. Distinguish between different types of Excel errors, including formula errors, reference errors, and logical errors, to implement targeted corrective actions for enhanced spreadsheet accuracy and reliability. Program Content: The major topics that will be covered in this class include: Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors. Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis. Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies. Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively. Who should attend: This course is ideal for anyone who uses Excel extensively in their work, especially those involved in financial analysis, reporting, auditing, or any role where accuracy and efficiency in handling Excel spreadsheets are paramount. Developed By: DataSmithPro Instructor: Bryan Smith (DSP)CPE Credit: 2.00Field of Study: Auditing (2.00) Prerequisites: A comprehensive working knowledge of ExcelAdvanced Preparation: Download the handout and practice material prior to courseFormat: QAS Self Study

The Florida Sales & Use Tax - Navigating the Unpleasant Florida Tax Audit course is designed for anyone who has a desire to learn about exposure areas involving Florida sales and use tax. This program was developed for the FICPA by David J. Brennan, Jr., Esq., LLM. It was previously recorded on April 27, 2022, at 11 a.m. The course has been approved for up to one ( 01 ) hour(s) of TB CPE credit.

In this seminar, we present an overview of the most effective asset protection trusts and LLCs, available both in the U.S. and abroad. Discussion will include the pros and cons of domestic vs. offshore planning and how to avoid U.S. tax. The Inflation Reduction Act is also discussed. The Foreign and Domestic Trusts and LLCs: Structuring and Tax Avoidance Strategies course is designed for CPAs, Attorneys, and other Financial Professionals who desire a basic understanding of effective asset protection strategies using LLCs and trusts in both the U.S. and abroad. Other topics discussed include: expatriation, pre-immigration, compliance issues, and the Inflation Reduction Act. Basic Understanding of U.S. Taxation, LLCs, Trusts; General Concept of Asset Protection  Integrated Asset Protection: Using LLCs, Trusts, Exempt Assets, and Titling Trusts: Domestic and International The Taxation of Trusts: Domestic and International Tax Expatriation of People and Assets Pre-Immigration Planning Inflation Reduction Act (IRA)  

This course discusses forensic accounting and fraud investigations. Gary mentions that his firm, Fisk and Company, primarily focuses on forensic accounting and valuation. He explains that forensic accounting involves investigating people and money and educating the court on the numbers. Gary also provides insights from a survey on fraud, including the types of fraud, red flags, and recovery of losses. He highlights the importance of analyzing data and using technology, such as artificial intelligence, to detect fraud. Gary concludes by emphasizing the role of CPAs as trusted advisors in proactively identifyng and addressing fraud risks for their clients.

" This course discusses the importance of engagement letters in the accounting profession. It covers topics such as the purpose and benefits of engagement letters, key elements to include in an engagement letter, and how to document scope creep. It also provides tips on implementing and increasing the usage of engagement letters in a firm. The course emphasizes the need for clear communication with clients and understanding the implications of engagement letter changes. It also provides resources and sample engagement letters for reference."

" For the past thirty years the Government Finance Officers Association (GFOA) has devoted considerable?time and other?resources to developing a comprehensive set of?Best Practices?for all of the major aspects of state and local government finance. This session will focus on those GFOA Best Practices of special interest to accounting, auditing, financial reporting, and budgeting professionals. The GFOA Best Practices course is designed for accounting and auditing professionals who provide services to state or local governments."

Financial statement forecasting is essential for predicting a company's future financial health, guiding strategic decisions, and attracting investments. By analyzing historical data, market trends, and assumptions, businesses can anticipate risks and opportunities, enabling effective planning, resource allocation, and long-term stability and growth. -Forecasting Process: This involves projecting future income, expenses, and resources. By leveraging historical data and market insights, businesses can predict financial health, shaping strategic planning, investment decisions, and risk management. -Forecasting Profitability: Predicting future earnings informs strategic decisions, investment planning, and resource allocation. It facilitates effective budgeting, cash flow management, risk assessment, and enhances attractiveness to investors for sustainable growth. -Forecasting the Balance Sheet: Analysts forecast to predict a company's future financial position, assessing growth potential, solvency, and capital structure. This informs investment decisions, strategic planning, and risk management, ensuring financial stability and growth. Join our webinar to explore these concepts with a practical example, guiding you through the forecasting process and demonstrating its practical applications in real-world scenarios. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.  Learning Objectives:After attending this presentation, you will be able to...• Formulate the ability to project future income, expenses, and resources using historical data and market trends for strategic planning and investment decisions.• Calculate future earnings and financial positions to evaluate growth potential, solvency, and capital structure for effective budgeting and risk management.• Apply forecasting insights to enhance resource allocation, manage risks, and attract investments, supporting long-term financial stability and growth Program Content:The major topics that will be covered in this course include:• Introduction to Financial Statement Forecasting• Overview of the importance and benefits of forecasting for strategic planning and investment attraction.• The Forecasting Process: Steps to project future income, expenses, and resources using historical data and market trends.• Analyzing Historical Data: Methods for leveraging past financial data to inform future projections.• Incorporating Market Trends: How to integrate market insights into financial forecasts.• Forecasting Profitability: Techniques for predicting future earnings and their implications for budgeting, cash flow management, and investment planning.• Forecasting the Balance Sheet: Approaches for predicting future financial positions, including growth potential, solvency, and capital structure Who should attend: Finance and accounting professionals interested in a better understanding of financial analysis Developed By: Eric Knight, CPA, DBA Instructor: Eric KnightCPE Credit: 2.00Field of Study: Finance (2.00) Prerequisites: NomeAdvanced Preparation: NoneFormat: QAS Self Study

Description: The term "artificial intelligence" (AI) has become mainstream and while most have a layperson's understanding of AI, few know the depth and breadth of this technology's capability. AI is affecting just about everything in business and in people's personal lives. The operation of an internal control system is also changing because of this incredible advancement. This session explains what AI is and how it works and then goes into detail about how it can be applied to a system of internal control. The material speaks about changes occurring in today's world as well as what's coming in the not-too-distant future. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation, you will be able to...Recognize changes that are occurring because of AI.Recall specific control types that have changed.Identify ways AI will strengthen controls. Program Content: The major topics covered in this class include:An explanation of Artificial Intelligence (AI).Specific ways AI is replacing human cognition. What is on the internal control horizon related to AI and other technologies. Who should attend: Accounting and other business professionals with a need to understand internal control changes driven by AI technology. Developed By: Taymes, LLC Instructor: Karl Egnatoff CPE Credit: 4.00 Field of Study: Accounting (4.00) Prerequisites: None Advanced Preparation: None Format: QAS Self Study

Description: The term "artificial intelligence" (AI) has become mainstream and while most have a layperson's understanding of AI, few know the depth and breadth of this technology's capability. AI is affecting just about everything in business and in people's personal lives. The operation of an internal control system is also changing because of this incredible advancement. This session explains what AI is and how it works and then goes into detail about how it can be applied to a system of internal control. The material speaks about changes occurring in today's world as well as what's coming in the not-too-distant future. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation, you will be able to...Recognize changes that are occurring because of AI.Recall specific control types that have changed.Identify ways AI will strengthen controls. Program Content: The major topics covered in this class include:An explanation of Artificial Intelligence (AI).Specific ways AI is replacing human cognition. What is on the internal control horizon related to AI and other technologies. Who should attend: Accounting and other business professionals with a need to understand internal control changes driven by AI technology. Developed By: Taymes, LLC Instructor: Karl Egnatoff CPE Credit: 4.00 Field of Study: Accounting (4.00) Prerequisites: None Advanced Preparation: None Format: QAS Self Study

Description: The term "artificial intelligence" (AI) has become mainstream and while most have a layperson's understanding of AI, few know the depth and breadth of this technology's capability. AI is affecting just about everything in business and in people's personal lives. The operation of an internal control system is also changing because of this incredible advancement. This session explains what AI is and how it works and then goes into detail about how it can be applied to a system of internal control. The material speaks about changes occurring in today's world as well as what's coming in the not-too-distant future. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation, you will be able to...Recognize changes that are occurring because of AI.Recall specific control types that have changed.Identify ways AI will strengthen controls. Program Content: The major topics covered in this class include:An explanation of Artificial Intelligence (AI).Specific ways AI is replacing human cognition. What is on the internal control horizon related to AI and other technologies. Who should attend: Accounting and other business professionals with a need to understand internal control changes driven by AI technology. Developed By: Taymes, LLC Instructor: Karl Egnatoff CPE Credit: 4.00 Field of Study: Accounting (4.00) Prerequisites: None Advanced Preparation: None Format: QAS Self Study

Many small to medium sized companies do not properly address the risk that arises related to fraud because these organizations do not have the resources needed to mitigate this risk or because owners or those in top level management underestimate the scope of the issue. All organizations, regardless of size, must be aware of the risks associated with intentional fraudulent acts and know that a significant and effective fraud scheme could even create going concern issues for some entities. In this session, we delve into the reasons that fraud takes place. The material discusses the types of defalcations that are often executed against smaller entities and then explores measures that organizations can implement to help stop fraud activities and add security.

Penalty abatement is a technique that tax practitioners can utilize to help their clients reduce penalties and interest they owe to the IRS if the taxpayer can prove "reasonable cause". This informative and insightful webinar will provide you with some insider tips, practical steps and effective strategies to help your client manage IRS tax penalties and interest. Learn about various types of penalties that you may face, and the various forms and procedures used for requesting penalty and interest abatement, including First Time and Reasonable Cause abatement. Plus, learn about the procedure to follow when requesting refund of paid penalties.

CPAs, accountants and tax preparers need to understand IRS collection procedures. This session will provide updates to IRS controversy and representation Issues such as examination, collections and appeals activities. It will cover relevant Internal Revenue Code Sections, administrative law and case law as well as sections of the Internal Revenue Manual. • Review recent legislative actions impacting nonprofit organizations.• Identify Unrelated Business Income (UBI) risk areas.• Recognize potential tax and compliance risks in your organization.• Understand filing changes.• Explore the Employee Retention Credit (ERC).

Many organizations are successful as they create a system of internal controls, however some fail to properly implement the measures that are established. Moreover, entities regularly neglect the important process of testing, monitoring, and updating control procedures, which weakens the entire internal control structure. This session provides an overview of control creation methods and discusses ways to successfully implement policies and procedures. Additionally, it includes an array of control maintenance checklists that participants can take and adapt to their organization as they work to improve policies and procedures. Finally, it provides an understanding of the need for dynamic, fluid controls that adapt to changes in business tools and methods. Participants that take this course will have a strengthened ability to implement and maintain an internal control system.

Many organizations are successful as they create a system of internal controls, however some fail to properly implement the measures that are established. Moreover, entities regularly neglect the important process of testing, monitoring, and updating control procedures, which weakens the entire internal control structure. This session provides an overview of control creation methods and discusses ways to successfully implement policies and procedures. Additionally, it includes an array of control maintenance checklists that participants can take and adapt to their organization as they work to improve policies and procedures. Finally, it provides an understanding of the need for dynamic, fluid controls that adapt to changes in business tools and methods. Participants that take this course will have a strengthened ability to implement and maintain an internal control system.

Description: Financial statements prepared for stockholders and external users follow Generally Accepted Accounting Principles (GAAP), while tax returns adhere to the Internal Revenue Code (IRC). These frameworks differ in recognizing profitability, influencing reported income significantly. Companies often aim to minimize taxable income within legal bounds, while maintaining compliance with both financial reporting and tax regulations. -Timing Differences: Variations in income recognition and deductible expenses between GAAP and IRC create timing differences, impacting reported profitability and tax liabilities. -Deferred Tax Assets: Companies accrue deferred tax assets from overpaid taxes or carried-forward credits, which can offset future taxable income, reducing tax liabilities. -Deferred Tax Liabilities: When taxable income is less than reported income, deferred tax liabilities arise, necessitating future tax payments when temporary differences reverse. Join us to delve into these concepts, exploring how financial reporting choices and tax strategies shape a company's financial performance and compliance obligations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation, you will be able to...Recognize variations in income recognition.Recognize deductible expenses between GAAP and IRC affect reported profitability and tax liabilities.Compute deferred tax assets and liabilities, learning their impact on financial statements and future tax obligations. Program Content: The major topics that will be covered in this course include:Introduction to GAAP and IRC FrameworksKey Differences Between Financial Reporting and Tax ReportingUnderstanding Timing DifferencesRecognition of Revenue and Expenses Under GAAP vs. IRCDiscussion of Deferred Tax AssetsImpact of Deferred Tax LiabilitiesPermanent vs. Temporary DifferencesReconciliation of Book Income to Taxable Income Who should attend: Accounting professionals Developed By: Eric Knight, CPA, DBA Instructor: Eric Knight CPE Credit: 2.00 Field of Study: Taxes (2.00) Prerequisites: None Advanced Preparation: None Format: QAS Self Study

CPAs and accountants need to understand income and estate tax minimization techniques. The current $12.92 million estate and gift tax exemption will ""Sunset"" after December 31, 2025. The loss of approximately $6-7 million in exemption can result in an additional estate tax of $2.4 million or more if proper planning is not implemented prior to December 31, 2025. Tax Attorney, Nicholas C. Guerra, Esq., LL.M., explores creative estate planning strategies to minimize both income taxes and estate taxes. The presentation will provide an overview of the estate tax, and estate planning techniques to address the scheduled reduction in gift and estate tax exemptions at the end of 2025. Topics that will be discussed are (i) strategic leveraged gifting transactions, (ii) income tax minimization strategies utilizing C corporation stock (QSBS), (iii) state income tax minimization strategies utilizing out-of-state trusts, and (iv) income and estate tax minimization strategies utilizing life insurance structures.The course has been approved for up to one hour(s) of Accounting & Auditing CPE credit.