CPE Catalog & Events

Excel shortcuts Conditional summing Removing duplicate values VLOOKUP function

The major topics that will be covered in this course include:Recent pronouncements issued by the Governmental Accounting Standards Board (GASB)GASB Statement No. 103 (financial reporting model)GASB Statement No. 104 (disclosures for capital assets)cGASB Statement No. 105 (subsequent events)Active GASB exposure drafts and ongoing projects

The major topics that will be covered in this course include:IRC § 274 meals and entertainment rules Tax Cuts and Jobs Act changes affecting meals and entertainment Deductible versus nondeductible expenditures Definition of “entertainment” Definition of “business associate” Reimbursement arrangements Exceptions under IRC § 274(e) Compensation-related exceptions Recreational activity exceptions Public availability exceptions Goods or services sold to customers Separately stated food and beverage costs Employer-provided meals Per diem reimbursements Compliance and documentation requirements

The major topics that will be covered in this course include:What accounts should get reconciled?Why the banking feed still needs reconciliationThe Reconcile interfaceStep-by-step reconcilingTricks to locate errors quicklyHow to solve common QBO workflow errors that create extra transactions...and a slew of time-saving techniques

The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage  data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.

Constitutional limits and Public Law 86-272 Interstate activity Nexus, UDITPA and MTC Calculation of state taxable income Filing methods for multistate taxpayers Apportionment and allocation Multistate income tax planning

The major topics that will be covered in this class include:The importance of valuesIdentifying successEthical dilemmasMitigation strategiesCreating tools to help make better decisionsPersonal accountability strategies

The major topics that will be covered in this course include:Comprehensive overview of SOC 2 reports, focusing on their structure, purpose, and how to interpret and apply them in a compliance or risk management context. The five Trust Services Criteria (Security, Availability, Processing Integrity, Confidentiality, and Privacy).The difference between Type I and Type II reports.The key components of a SOC 2 report including the system description, management assertion, and testing results.

The major topics that will be covered in this course include:Advantages of budgetingThe role of budgetingMaster budgetingFlexible budgetingStandards and variancesCapital budgeting

The major topics that will be covered in this course include:Planning the Exit or Ownership ChangeChoice of transaction structureAsset sale vs. equity sale vs. redemption vs. liquidationBuy-sell agreement design and valuation implicationsCore Basis ArchitectureInside vs. outside basisPartnership liability allocations under Section 752S corporation stock basis and debt basis limitationsSales and Transfers of Ownership InterestsPartnership interest sales and Section 751 hot assetsS corporation stock salesDeath, Section 1014 basis adjustments, and successor-owner issuesPotential Section 1202 considerations where relevantLiquidations and DissolutionsPartnership liquidating distributions under Sections 731, 732, and 736S corporation liquidations under Sections 336 and 331Treatment of cash, property, liabilities, and built-in gain or lossRedemptions and Internal Ownership ShiftsSection 302 testsSection 301 fallback treatmentCross-purchase vs. redemption economics and tax consequencesRestructuring and Entity ModernizationF reorganizationsPre-sale and post-sale restructuring considerationsBasis and attribute preservation issuesSpecial SituationsTransfers incident to divorce under Section 1041Suspended losses and carryover basis issuesGoodwill and Section 197 intangiblesFamily and related-party complicationsAncillary Tax ConsequencesSection 1411 NIITState tax nexus, trailing nexus, and dissolution-related state filingsTransfer tax and valuation overlap where applicableFinal-Year Reporting and ComplianceFinal Forms 1065 and 1120-SForm 966 and related dissolution filingsEIN closure and administrative wrap-upPractical reporting checklistsValuation of Closely Held InterestsRev. Rul. 59-60 principlesDLOM and minority discountsSection 2703 and buy-sell agreement enforceability for transfer tax purposes

The major topics that will be covered in this course include:IRS digital asset compliance and enforcement strategy Cryptocurrency transactions and tax compliance Digital wallets, exchanges, and blockchain activity IRS identification and analysis of digital asset data Use of digital asset information in IRS examinations Use of digital asset information in collections Use of digital asset information in criminal investigations Exchange reporting IRS summons activity involving digital assets Blockchain analytics Third-party digital asset data sources Common digital asset compliance failures identified in audits Limitations of current digital asset reporting regimes Digital asset reporting and visibility gaps Taxpayer and practitioner risk assessment Red flags associated with digital asset activity Digital asset compliance risk Responding to IRS inquiries involving digital assets Evolving digital asset reporting obligations Practical IRS enforcement considerations for digital assets

The major topics that will be covered in this course include:Key accounting and auditing developments affecting governmental and not-for-profit organizations. Accounting Standards Updates issued by the Financial Accounting Standards Board.The purpose of INPAS and how it compares conceptually to U.S. GAAP for not-for-profit entities.Recent developments affecting Single Audits, including the 2024 Uniform Guidance overhaul, updates to Appendix B of the AICPA GAS/Single Audit Guide, and recent guidance issued through the Office of Management and Budget (OMB). 

The major topics that will be covered in this course include:Participants will review the scope of the interpretationsThe responsibilities of members in public practice and members in businessConsiderations involving confidentiality, communication, documentation, withdrawal, and further action in the public interest. Related requirements under SAS No. 147 and the 2024 Yellow Book, including how auditors must handle communications related to NOCLAR.

The major topics that will be covered in this course include:Discuss ethics from an every-day real-world perspectiveHow to prevent an ethical lapse that can turn your business into the next news story

The major topics that will be covered in this course include:Identify tax deductions available to real estate professionalsIntegration of the real estate professional rules with reporting on Form 1040, Schedule EReal estate professionals and indirectly owned (partnerships, S corporations) entity’s reporting on Form 1040Real estate professionals and the Form 8582 (Passive Activities)How "real estate business" is interpreted under the Section 199A rules and how it integrates with the passive activity rulesHow to make the "grouping" election for passive activities and the flow-through deduction

The major topics that will be covered in this course include:Benefits and pitfalls of artificial intelligence in the accounting professionSelecting and utilizing artificial intelligence resourcesApplying professional skepticism to resultsMaintaining independence while utilizing artificial intelligenceUpholding client confidentialityData security and retentionCitation of sources and related reporting considerationsApplication of the AICPA Code of Professional ConductEthical considerations when crafting policies and establishing best practices

The major topics that will be covered in this class include:The foundational ethical principles CPAs are required to follow and how these principles apply to audit quality, data privacy and security, and the use of emerging technologies.The profession's need to change to meet its ethics standard in a technology-centric environment.Changes being considered by the AICPA and the National Association of State Boards of Accountancy that could impact the profession.

The major topics that will be covered in this course include:Introduction to Copilot in ExcelAutomating Tasks and Enhancing ProductivityAdvanced Data Insights with Copilot

The major topics that will be covered in this class include:How accountant liability is a very real threat in today's litigious society.A discussion of scenarios in which accounting professionals can find themselves inadvertently involved in a lawsuit.Pitfalls in which the accountant may find him- or her- self while dealing with clients.Real-life examples from the speaker's extensive experience as a practitioner and as an expert witness in accounting malpractice cases.