In this one-hour course, users will apply Excel and Power BI tools and skills directly to tables in Excel. Users will work alongside the instructor to create named tables, create structured references, enter formulas, and prepare the tables for input into Power Query. Users will be introduced to the preparation of the first level of...
Accounting and financial reporting for construction contractors may be the most difficult area to be in compliance with the various standards. Also, construction engagements are, in many instances, more "dangerous" than most lines of business due to the many users of the financial statements (especially considering the impact of COVID-19). In this course, we will...
For roughly 90% of American retirees, Social Security income will be the foundation of their retirement income. Yet, many are ill-prepared and lack understanding of the critical aspects of making an informed claiming decision. Further challenged to separate fact from fiction, consumers crave accurate information from knowledgeable professionals to make the most out of these...
This program is an in-depth analysis of the Section 754 election and the two adjustments associated with the election under Section 743(b) and Section 734(b). The 754 election is a highly technical provision that provides great tax benefits to the owners of the partnership, and particularly in the case of Section 743(b), a new partner....
In today's rapidly changing world, finance professionals are required to wear many hats and are often the keys to the success of the organization. On one hand, they need to be abreast of the latest proven financial skills for making the best decisions, and on the other hand they need the best skills to motivate,...
During this interactive game, participants take the role of an auditor performing a physical inventory observation at a client's warehouse. Participants will have the opportunity to use their powers of observation and exercise professional skepticism in identifying areas of risk that might need follow-up, interviewing Wally the client, and performing inventory test counts. After performing...
As you advance in your public accounting careers, your responsibilities significantly increase. The skills required for continued success go beyond your technical skills but also include others that you may not have had a chance to develop earlier in your careers. Several of these new responsibilities involve engagement management and managing your team. Mastering these...
With a greater-than-ever 179 deduction boosted by additional first-year depreciation and pandemic-related business-friendly provisions, these are unprecedented times for businesses to make major asset investments.From the most up-to-date depreciation regulations to inflation adjustments and technical corrections, this course provides guidance for navigating the complex maze of rules dealing with depreciation, amortization, and sales of property....
Quality should be the primary focus of all engagements. Since initiating its Enhancing Engagement Quality initiative in 2014, the AICPA has been using its peer review program as a way to assess the improvement in engagement quality.In this course, we'll review the latest results from the peer review program, identify areas of focus for both...
The one constant in life is change. This is true in the A&A world as well. 2021 will continue to challenge the accounting profession in many areas, including accounting for the impact of the COVID-19 pandemic, working in a virtual environment, and implementing new AICPA and FASB pronouncements. In this monthly series, we will explore...
Trusts are not cookie-cutter documents. In fact, they can be rather unwieldy, especially in explaining the functions to a client and then having the client comply with the trust terms. This course delves into best practices. Given common scenarios, what are the best trusts to use? And how can the client be best protected?
As financial and tax professionals well know, information overload is a constant struggle we face because things change quickly, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and...