Filters Sort results
Reset Apply
| This course introduces junior tax professionals to the fundamentals of individual tax preparation. Participants will learn the essentials of Form 1040, including filing requirements, income reporting, and deductions. The session will also cover preparer responsibilities, due diligence, and taxpayer rights under Circular 230. With a theoretical and practical study of Form 1040, and certain accompanying schedules, this course provides critical discussion of tax preparation. Additionally, preparer due diligence requirements, responsibilities and obligations will be covered… | |
| Tax resolution means providing solutions to businesses and individuals alike who find themselves in trouble with the IRS. To resolve tax matters with the IRS, the IRS’ Offer in Compromise (OIC) program encourages delinquent taxpayers to settle their back taxes, often for reduced amounts. The areas covered are: Offers in Compromise, Wage Garnishments, Bankruptcy, Installment, Delinquent Tax Returns, IRS Bank Levies, Freedom of Information Requests, IRS Payment Plans, Payroll Tax Problems, IRS Audits, Penalty Abatement… | |
| Are you Ready to elevate your accounting game and streamline your financial and accounting operations? In a age where automation, AI, technology, and ingenious frauds are common place, everyone needs to be on their toes whether you work in, manage, or simply have responsibility for the accounts payable function. In this fast paced section we not only review the processes from the best practices stand point we investigate the new challenges of technology, AI, new… | |
| In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide participants through various payroll-related Excel techniques. Topics covered include contrasting using Flash Fill versus the TEXT function to reformat Social Security Numbers. You'll see how to calculate total payroll and total payroll taxes with the SUMPRODUCT function for data analysis, and understand the nuance of adding up time values in Excel. David will also show how to calculate employee tenure with the… | |
| This informative course covers traditional planning tools and their utilization to protect assets. The Uniform Fraudulent Conveyance Act, the Bankruptcy Code, and various aspects of the tax law are highlighted in describing asset protection aspects of corporations, partnerships, limited liability companies, family partnerships, trusts, retirement plans, insurance products, and other conventional tools. Special topics include protection against lawsuits, costs of long-term illness, divorce settlements, foreign asset protection trusts, statutory protections, homestead provisions, exempt assets, cancellation… | |
| In every audit, the auditor is required to specifically assess the risk of material misstatement of the financial statements due to fraud. Fraud auditing is a course that examines the types of fraud considered by auditors when auditing financial statements: fraudulent financial reporting and misappropriations of assets. This course describes the way auditors gather information to assess fraud risk in every audit and develop appropriate responses to identified fraud risks, after considering the effectiveness of management's anti-fraud programs… | |
| The auditor uses four phases to meet the overall objective of the audit, which is to express an opinion on the fairness with which the financial statements present fairly. Every audit requires planning, which occurs during the first of the four audit phases. Audit planning is a course that will review the audit planning process. This course will discuss the important of evaluating materiality and risk, which will impact the auditor's planned audit evidence. This… | |
| Internal controls are required to ensure the integrity of financial and accounting information, promote accountability, and prevent fraud. This course will describe the importance of internal controls and the purpose of audit committee. This course will review the goals for internal controls and discuss the internal control framework used by most companies based in the United States. This course will describe the interrelated components for an effective internal control system. This course will discuss the… | |
| Every audit requires planning. Audit planning requires evaluating materiality and risk. Both materiality and risk evaluation require judgement from the auditor because both concepts directly impact the auditor's planned audit evidence. Materiality is important because the auditor provides assurance to financial statement users that the financial statements are free of material misstatements. This requires the auditor to develop a preliminary judgment about materiality when planning the audit, which will provide the basis for that important… | |
| The Bankruptcy Abuse Prevention and Consumer Protection Act was enacted to minimize abuse of the bankruptcy system. Included in this Act were tax law changes and other changes that individuals, partnerships, and corporations will see in the bankruptcy procedures and qualifications. This mini-course both ex-amines these changes that debtors will face when filing for federal bankruptcy and also explores the many tax issues of bankruptcy. Practitioners will also learn about other issues such as homesteading… | |
| Many accounting professionals are unaware of Excel features and functions that improve spreadsheet accuracy and efficiency. In this presentation, author and Excel expert David Ringstrom, CPA, contrasts the SUM, SUBTOTAL, SUMIF, and SUMIFS functions, along with the Subtotal feature. You'll also learn how to use the Table feature to streamline sifting through lists of data, create self-expanding charts, and PivotTables that have much better integrity.Topics covered:• Inserting totals into lists using the Subtotal feature. •… | |
| This course is an overview of basic fringe benefits and examines their mechanics, compensation methods, valuation, withholding, and accounting. Achievement awards, term life insurance, medical reimbursement, meals & lodging, educational assistance, dependent care, employer-provided automobiles, interest-free loans, etc. are identified. Employer and employee economic and tax considerations are recognized. Fringe benefit requirements and limits are specified and ERISA compliance requirements are determined.AssignmentAt the start of the materials, participants should identify the following topics for study:*… | |
| In this mini-course, initial marital tax matters such as living together, property rights, premarital agreements, filing status, exemptions, and dependents are explored. The detailed support test for children of divorced or separated parents, the tax treatment of back child support, the deduction of divorce costs, and estimated tax payments are reviewed. Emphasis is given to marital property rules, married versus unmarried tax rate comparison, head of household status, and treatment of refunds and deficiencies.AssignmentAt the… | |
| This course will teach participants how to apply, implement, and evaluate the strategic tax aspects of marital dissolutions and living together arrangements. Current perspectives on property transfers, asset divisions, alimony, filing status, exemptions, and child support are examined with an emphasis on planning considerations. The cancellation of indebtedness income inclusion rules are examined in the context of debt forgiveness and property foreclosure. Emphasis is given to the exceptions from income inclusion contained in §108. The… | |
| In this session, author and Excel expert David Ringstrom, CPA, shares techniques you can use to verify the integrity of even the most complicated Excel workbooks. Features covered include Show Formulas, Evaluate Formulas, Trace Precedents, and the FORMULATEXT function. David will contrast editing traditional formulas with dynamic array formulas in Excel 2021 and Excel for Microsoft 365 and writing formulas by using structured references.Topics typically covered:• Utilizing the Error Checking command to locate cells that… | |
| This course provides an overview on the basic concepts and tools of business. Every functional aspect of business is covered. Topics covered are management, organization, human resource management, purchasing, production/operations, accounting, finance, marketing, quantitative methods, legal environment, information technology, business ethics, and international business. | |
| The major purpose of Business Law: The Legal Environment of Business is to provide you with a concise summary of the major legal principles affecting businesspeople and business transactions. It provides a quick, yet comprehensive, review of this vital and wide-ranging area of the law. You will be able to analyze business decisions from a legal responsibility perspective. | |
| Taxpayers are once again looking to CPAs for guidance and planning related to travel and entertainment expenses. This comprehensive mini-course examines and explains the practical aspects of business travel and entertainment deductions. To determine the expenses that taxpayers are able to deduct, fundamentals are reviewed and planning opportunities are identified. Practitioners will learn to master the proper administration of these complex and often cumbersome provisions.ASSIGNMENTAt the start of the materials, participants should identify the following… | |
| This mini-course describes and compares sole proprietorships, partnerships, limited liability companies, “C” corporations, and “S” corporations. It examines their advantages and disadvantages, permitting the participant to properly select the right business entity for their tax and liability needs.ASSIGNMENTAt the start of the materials, participants should identify the following topics for study:* Advantages and disadvantages of sole proprietorships* Taxes for self-employed individuals* Definition of partnership* Partnership tax return & year taxable* Contributed property, assets & services*… | |
| Complete Business Math for Accountants provides accountants, managers, and business entrepreneurs with the information, analyses, and insights necessary to analyze and calculate the consequences of a wide range of business financial strategies and problems. The ability to select the right operational technique is vital if the business is to survive, profit, and grow in today's uncertain economic environment. The owner of a small business must be able to make the right financial decision based on… | |
| The Generally Accepted Governmental Auditing Standards, also known as the Yellow Book (2024 Version), provides a comprehensive framework for conducting governmental audits with a focus on high quality, integrity, competence, independence, and objectivity. The Yellow Book is used by auditors of government organizations, entities that receive government awards, and any other audit organization performing Yellow Book audits. The Yellow Book outlines all requirements for governmental audit reports, professional qualifications for auditors, and audit organization quality… | |
| While tax reform visions have changed the tax on profits realized from the disposition of real estate, investors still seek escape hatches from the capital gain tax. Tax-deferred exchanges permit the disposition of property often with the taxpayer receiving significant cash but without the payment of any tax. Functionally, an exchange is a bridge over the normally taxable event of moving from one property to another. This course alerts the practitioner to the different planning… | |
| The Conditional Formatting feature in Excel enables you to draw attention to different aspects of your data by applying on-demand colors, number formatting, and borders. In this presentation author and Excel expert David Ringstrom, CPA, helps you delve into and master the art of conditional formatting. Nuances such as identifying duplicate values, filtering by color or icon, and creating in-cell charts with Data bars will be covered. You'll also see how to create formula-based Conditional… | |
| Cost Management: Accounting and Control covers the managerial use of accounting, financial, and operating data for planning, control, and decision making. Emphasis is placed on how to manage costs strategically in order to be globally competitive. The course is designed for managers and entrepreneurs who seek continuous improvement (CI) strategies. Topics include analysis of costs; job order and process costing; break-even and contribution analysis; activity-based costing (ABC); balanced scorecard, cost allocation; responsibility accounting; budget for… | |
| In this presentation, author and Excel expert David H. Ringstrom, CPA, will delve into the essential features of Excel that enhance collaboration and data integrity, focusing on the concept of an Audit Trail. Attendees will learn how to enable Track Changes to monitor spreadsheet edits, restore workbook sharing, and effectively review changes made by collaborators. David will also explore the Show Changes feature in Excel Online, demonstrate the use of the FORMULATEXT function for better… | |
| In this presentation author and Excel expert David Ringstrom, CPA, shows you how to create and remove duplicate data in Excel. You'll see mouse tricks for quickly duplicating rows, columns, and entire worksheets, as well as duplicating formatting to disparate cells. David will demonstrate the nuances of duplicates when using lookup functions, and how to easily identify duplicate data with the Conditional Formatting feature. You'll also see how to use the Data Validation feature to… | |
| This mini-course brings the practitioner information on tax issues affecting interest and debt. The various types of interest and their required allocation are explored and reviewed. For the economically troubled client, special attention is devoted to debt cancellation, repossession, discounts, and foreclosure. The program also discusses installment sales, taxable interest, and bad debts.ASSIGNMENTAt the start of the materials, participants should identify the following topics for study:* Deductible interest & debt* Nondeductible interest* Below-market interest rate… | |
| Today taxpayers must plan for their children's education. Touching on various topics such as qualified tuition programs (QTPs), scholarships, and fellowships, this mini-course examines the tax treatment of costs related to education. Practitioners will learn the ins and outs of the tax benefits concerning education and will be able to identify those educational expenses that are deductible. Additionally, financial planning strategies and techniques are outlined to better prepare taxpayers for future educational costs.ASSIGNMENTAt the start… | |
| We are all (including tax practitioners) getting older, and the need for effective retirement planning has never been greater. This course is essential for participants who wish to attain a comfortable retirement for themselves and their clients by maximizing tax-saving strategies. Retirement income needs are calculated; net after-tax Social Security benefits are determined; and distribution options from IRAs and retirement plans are explored. Special consideration is given to the tax treatment of the home and… | |
| The various ideas, methods, and techniques to optimize the overall compensation package for key employees and principals are examined in this mini-course. Generally, businesses may deduct employees’ pay including wages, salaries, and other perks. Certain fringe benefits that can provide an unusually tax-favored manner of supplementing compensation are described and evaluated. In addition, equity participation is explored through stock sales, repurchase agreements, incentive stock options, ESOTs, stock options, and bonuses. Finally, deferred compensation arrangements are… | |
| Before launching into an estate planning program, it’s important to know who owns what and exactly for whom you are planning. This requires that methods of holding title must be analyzed, considered, and selected. Sole proprietorships, S corporations, C corporations, partnerships, and limited liability companies are analyzed as to formation, operation, and ultimate disposition. Since who or what holds title imposes its own unique tax and legal consequences on the estate plan, emphasis is given… | |
| Estate planning doesn't have to be a daunting maze of tax codes and regulations; instead, it can be approached as a practical, real-life strategy to protect and distribute assets. This course focuses on the key elements and tools for a successful estate plan, from basic wills and healthcare directives to more complex trusts and partnerships, it explores comprehensive strategies that serve your unique needs. This approach encompasses a range of tools designed to minimize both… | |
| Estate planning is when tomorrow becomes today! As a result of recent legislation, estate planning has been made surprisingly simple. This mini-course surveys wills, living trusts, gifts, insurance, marital property, and probate avoidance. The will and trust forms are explored along with living wills, durable powers of attorney, and nominations of conservator.AssignmentAt the start of the materials, participants should identify the following topics for study:* Estate planning team & administration* Unlimited marital deduction & applicable… | |
| Practitioners are brought up-to-date information on tax issues affecting estate planning and business issues. A major emphasis of this mini-course is practical estate planning solutions that are cost-effective. Devised to reduce or eliminate estate problems and death taxes, this comprehensive guide examines wills, trusts, gifts, insurance, private annuities, and other general estate planning tools. The planning issues and problems that arise from owning a business interest are also addressed.ASSIGNMENTAt the start of the materials, participants… | |
| Everyone needs to do estate planning. It is more than just planning for death. Estate planning is designing a program for effective wealth building, preservation, and disposition of property at the minimum possible tax cost. This exceptional mini-course surveys wills, living trusts, gifts, marital property, and probate avoidance. Designed to eliminate estate problems and death taxes, the emphasis is on practical solutions that are cost-effective. The text reviews and explains both federal gift and estate… | |
| In this presentation author and Excel expert David H. Ringstrom, CPA, shows you how to harness the full power of Data Validation to guide data entry and reduce errors in your spreadsheets. David explains how to create standard drop-down lists—including lists for all twelve months and self-expanding lists based on Excel tables—as well as how to craft dependent lists that adapt based on prior selections. You’ll learn how to apply validation for whole numbers, dates… | |
| While the nuclear family remains the center point of society, today it is under tremendous economic and social pressure. This mini-course is designed to cover “hot” topics having a direct impact on the practitioner who represents any client with family issues. The emphasis is on using tax solutions to ease family economic concerns permitting the practitioner to be a real tax hero.AssignmentAt the start of the materials, participants should identify the following topics for study:*… | |
| We are all (including tax practitioners) getting older, and the need for effective retirement planning has never been greater. This mini-course is essential for participants who wish to attain a comfortable retirement for themselves and their clients by maximizing tax saving strategies. Retirement income needs are analyzed; Social Security benefits are determined, and distribution options from IRAs and retirement plans are explored.AssignmentAt the start of the materials, participants should identify the following topics for study:*… | |
| Major federal tax reform was passed in July 2025 and this course brings business tax professionals up to speed on what changes. Designed for fall delivery, this update covers the key provisions of the new law that directly impact business owners, passthrough entities, and self-employed taxpayers. Whether your clients file via S corporations, partnerships, sole proprietorships, or farming operations, this course covers the new rules and what they mean for 2025 filings and 2026 planning.We’ll… | |
| A new federal tax law was signed July 4th, 2025—and this course will cover it. If you’re looking for a fall 1040 update that includes the latest legislation, you’re in the right place. This session is built to reflect all changes impacting 2025 individual tax returns, including updates to rates, deductions, credits, and planning strategies.Whether you’re preparing returns, advising clients, or updating internal processes, this course will help you apply the new rules with clarity… | |
| The Generally Accepted Governmental Auditing Standards, also known as the Yellow Book, provides a comprehensive framework for conducting governmental audits with a focus on high quality, integrity, competence, independence, and objectivity. The Yellow Book is used by auditors of government organizations, entities that receive government awards, and any other audit organization performing Yellow Book audits. The Yellow Book outlines all requirements for governmental audit reports, professional qualifications for auditors, and audit organization quality control.This course… | |
| This advanced course builds on the foundational principles introduced in Fundamentals of the 1040 – Core Concepts, guiding participants into the complexities of business income taxation and expanded reporting requirements. Learners will gain practical skills for accurately reporting self-employment income and pass-through entity activity on Form 1040. Income and expense reporting on Schedule C and Schedule E will be covered as well as the integration of essential forms such as Form 7203 (S corporation shareholder… | |
| This mini-course examines the various ideas, methods, and techniques capable of optimizing the overall compensation package for key employees and principals in small to medium-sized businesses. Qualified and non-qualified deferred compensation, benefit targeting, insurance programs, statutory fringe benefits, interest-free loans, and investment planning are investigated. Consideration is given to indirect compensation in the form of business entertainment, expense accounts, auto use, travel, and transportation. The new field of professional services is probed to provide tax… | |
| An installment sale is a sale of property where one or more payments are received after the close of the tax year. This mini-course discusses the particulars of installment sales, including requirements, calculations, and pitfalls. Cross issues such as a combined installment sale and like-kind exchange, the impact of related parties, pledging, repossession and contingent payments are reviewed. Also, the importance of recognizing the dangers of dealer status, inventory, purchase price allocation, and installment note… | |
| This course focuses on tax issues affecting the treatment of interest and debt. It covers the definition of bona fide debt, the impact of related parties, the avoidance of equity and lease characterization, and deductible versus nondeductible interest factors. Sticky cross issues such as the impact of at-risk rules under §465, passive loss restrictions of §469, and below-market rate loans under §7278 are examined. In addition, the accounting method treatment of interest, points, prepaid interest… | |
| The introduction of the Sarbanes-Oxley (SOX) Act law fueled rapid growth in the organizational im-portance of internal control systems. Appropriate interpretation and implementation of the inter-nal control framework are vital for every organization. This course incorporates and reflects up-to-date guidance from the PCAOB, the AICPA, the ACFE, and the principles of 2013 the COSO Frame-work as amended. The course not only addresses the theoretical concept of the internal control system but also provides readers with… | |
| This course focuses on the fundamentals of individual tax preparation. Participants will learn the essentials of Form 1040, including filing requirements, income reporting, and deductions. The session will also cover preparer responsibilities, due diligence, and taxpayer rights under Circular 230. With a theoretical and practical study of Form 1040, and certain accompanying schedules, this course provides critical discussion of tax preparation. Learners will gain practical skills for accurately reporting self-employment income and pass-through entity activity… | |
| This mini-course will teach participants how to apply, implement, and evaluate the strategic tax aspects of marital and financial setbacks. Property transfers, asset divisions, alimony, filing status, exemptions, and child support are examined.The cancellation of indebtedness income inclusion rules are discussed in the context of debt forgiveness and property foreclosure. Emphasis is given to the exceptions from income inclusion contained in §108. The tax treatment of property repossession under §1038 and bad debt treatment under… | |
| In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide attendees through essential techniques to streamline and enhance their Excel experience. David begins by showing how to use the F4 key to toggle between absolute and relative references, making formula adjustments quick and efficient. He’ll delve into assigning names to key input cells and demonstrate the “Create Names from Selection” feature to simplify referencing ranges. Next, David will cover the LET and… |