CPE + Events Catalog

This course provides a concise overview of Google Sheets, a cloud-based spreadsheet application by Google. Similar to Excel, the tool allows users to enter numbers, apply formulas, prepare graphs, create charts, use pivot tables and more. While Excel is the default tool and industry standard for most accountants, Sheets has many underrated capabilities which are clearly superior to Excel. These include online collaboration, team communications, mobility, version control, revision history, cloud storage, translation, Google integration, and scores of third-party add-ons. You'll walk away knowing how to use a whole new array of spreadsheet features not found in Excel that can boost your analytical powers and accelerate your financial workflow. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The QuickBooks ecosystem of accounting tools remains the most widely-used set of accounting applications used by small businesses. Yet, many of these organizations struggle because of inadequate internal controls. In this seminar, you will learn options for improving internal controls in small businesses running QuickBooks Pro, Premier, Enterprise, or Online. Participate in this program to understand how you can create a robust system of internal controls in a small business environment, including businesses using QuickBooks accounting solutions. In this session, you will also learn about the four common types of internal controls and how to assess the relative condition of the internal control structure of a small business. With this background in place, the focus then shifts to discovering the opportunities to enhance internal controls in QuickBooks-based environments using features found in the application. In addition, you will learn about additional internal control procedures for situations where you cannot establish adequate controls in QuickBooks. In sum, while many believe that QuickBooks-based organizations will forever face weak internal control structures, by participating in this session, you will learn how QuickBooks-based businesses can benefit from strong internal controls.

How good are you with the technology you use daily?  What new technology tools are available that could save you time and make you more effective?  Technology continues to accelerate rapidly, and the need to keep pace is essential. If you are not an information technology (IT) expert but need a technology update to maintain and improve your skills to serve your companies or clients more efficiently and effectively, this course is for you! In this fast-paced, update-style course, you will survey today’s IT environment, learning about computer hardware, software (including Microsoft Office), operating systems (including Windows 10), and what they mean for you, and peripheral devices. You will also learn about significant trends in information technology and how to take advantage of the opportunities presented by these trends.  Examples include the latest Excel features, working with PDF files, and security and privacy issues. Additionally, you will learn how to improve the overall performance of your IT investment, thereby increasing your return on investment. Throughout this program, you will learn from real-time demonstrations of practical applications of the latest tools, which can provide you with the knowledge you need to harness the power of technology, both now and in the future. Register now for this “don’t miss” opportunity to get the skills required to enhance the value of your IT investment.  

A discussion of the latest 2021/222 tax developments impacting business taxpayers, with a focus on important provisions, rules and concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many entities look to their CPA as a trusted advisor when tackling complex accounting topics. This is more relevant now than ever. The FASB's big three accounting pronouncements involving revenue recognition, leasing and credit losses have placed a magnifying glass on this reality. Practitioners need to exercise caution to ensure they maintain independence as they assist their review and audit clients with such matters, as well as with compilation engagements. This course addresses these issues and explores best practices and guidance provided by the AICPA's Code of Professional Conduct. **Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.

Accountants have increasingly become the primary advisors for businesses of all sizes. Clients are seeking assistance with all aspects of business planning. Are you prepared to support your clients on aspects such as business expansion, sources of capital, and determining growth strategies? This course introduces accountants to the essential elements of finance for business with an emphasis on the interrelationship with the traditional functions of accounting, explaining sources and costs of capital, and making educated capital decisions about growing business. Bringing a new appreciation of the vital role accountants play in business development, this dynamic and fast-moving session will explore key finance concepts and tools, including some of the best methodologies for making capital business decisions.

With the roll out of a new Form W-4 in late 2019, the IRS made significant changes to employers' withholding and payroll reporting requirements. In addition to the myriad of changes brought about by COVID-19 legislation, carried out through the payroll function, the IRS fundamentally revamped Form W-4 for employee reporting, doing away with the concept of allowances and requiring changes to payroll administration and employee communications. Now more than ever, employers need to know that the W-4 they are working with is working to withhold income taxes correctly for their employees. In addition, it is the employer's responsibility to ensure Form W-4 is filled out correctly and accurately. Employers need to understand the nuances and requirements that come with this obligation. This course will review the Form W-4 in all its glory, including all the changes that were made to the format and substance of the form, understanding what an employer can and cannot do, and how to actually fill out the Form W-4. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

To make more money in less time, all accountants need to learn to market themselves effectively to their clients or their firm. For better or worse, promotions and more money go to those who are the best marketers, rather than the most competent accountants.  In this fascinating and fun workshop, participants will learn seven key ways to get more clients and/or promotions through the art of marketing.

This course covers recently issued accounting and financial statement reporting standards from the Financial Accounting Standards Board. Key implementation challenges and experiences from public company filings will be identified. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Auditing PP&E, Including Leases under Topic 842 - Digesting the Risks of Improper Treatment of Tangible Long-Lived Assets will address tips and techniques for auditing tangible long-lived assets for various assessed risk levels, with a special emphasis on lease accounting under Topic 842. Property, plant and equipment can range from a low-risk to a high-risk audit area, depending on the nature of transaction and events engaged in by the reporting entity. Construction, capitalized interest and complex leasing arrangements tend to result in higher risk of material misstatement. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Accounting standards affecting not-for-profit (NPF) organizations have become increasingly complex, and, as a result, a great deal of confusing exists as to how to properly account for certain transactions unique to these organizations. This course will clarify proper accounting and reporting for these troubling areas. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Environmental, Social and Governance (ESG) has become a hot topic among standard setters. This session will look at the work of the FASB, GASB, and AICPA in the areas of ESG. We’ll also look at the types of engagements CPAs can provide to entities who want assurance around their ESG reporting.

Do you dread that annoying ERROR! message popping up on your spreadsheets? Tired of using the same long, elaborate formulas when you could be using Excel's built-in formulas? Then this webcast is for you!

The process of closing out the books every month can make year-end accounting a breeze! But isn't this time consuming? Not when you know the steps to take on a monthly basis. We'll show you what to do in QuickBooks Online as well as what you can do monthly to ensure a tax return that will stand up again an IRS audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Stop struggling with PDFs! Adobe Acrobat and other PDF tools provide access to features that make working with PDF files a breeze. In this course, you will learn how to use tools and features such as PDF forms, redaction, converting PDFs to Word and Excel files, and electronic signatures. You will also learn how to create and apply tick marks, build indices, catalogs, and portfolios, and secure PDF documents to their fullest. The popularity and usefulness of PDFs increase daily, but most PDF users have not learned how to manipulate PDF documents effectively. Accordingly, they struggle and strain with these standard files. You do not need to let this be the case. Join us in this very timely session where you will learn the top features necessary to optimize your work with PDF documents.

Looking for an idea that will help recruit and retain employees, engage customers, and invite investors? Sustainability is the solution! Sustainability is no longer just a "nice thing to do," it is both a business and moral imperative. Incorporating sustainable strategies into your day-to-day operations creates a competitive advantage, enhances your brand, and benefits the bottom line. On the business side, according to Harvard University, companies with strong sustainability initiatives have 4 times the sales growth, 8 times the employee engagement, and a 47% greater increase in stock value than their non-sustainable competitors. On the moral side, your customers and employees will no longer support an organization that does not address environmental and social issues. This session will explain the 6 benefits of sustainability and 6 steps to building a sustainable business. Learn how to make sustainability a competitive advantage to attract and retain loyal customers and high-performing employees. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Innovation is key to finding success in the face of change - but how do you actually achieve it? In this course, you'll learn why innovation matters, what you need to build an innovation strategy, and how to get your team's buy-in along the way. Leaders of teams and organizations of any size will gain practical takeaways to start developing an innovation system.

This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel.  Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.

Most organizations have many of the basic controls required to operate in place. However, a notable percentage of these companies do not have important measures that can help enhance security, productivity, and the quality of information available for decision making. In this session, we work to identify areas where important internal control measures are needed. We spend time explaining why these controls should be created, and show in detail some specific controls that would be beneficial if utilized. Those wishing to strengthen an internal control system should strongly consider attending this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

What can we learn from one of the largest municipal frauds in U.S. history? Rita Crundwell stole nearly $54 million from the citizens of Dixon, Illinois over the course of two decades. This course examines circumstances that allowed this landmark fraud to occur. We will explore internal control deficiencies and other circumstances that hindered prevention or timely detection of Rita's scheme. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.