Advertisement
The magazines

Kimberly Kirkendall, CPA

Kimberly Kirkendall, CPA, is president of international
Resource Development Inc. in Cleveland.

Change the case of text in Excel

You can change the case of a text string in Excel by using LOWER, UPPER, and PROPER, and they are all so simple to use.

Line items

Tax update: S elections, PTE, and Sec. 1202 (podcast) … Senate Finance airs post-Wayfair sales tax burdens … Midyear IRS mileage rate increase follows precedent, recent pleas … Senators request details on IRS info return destruction … IRS voice bots help set up payment plans

Untangling client affiliates

The AICPA Code of Professional Conduct requires CPA firms to identify all their financial statement attest client affiliates.

Susan M. Tillery, CPA/PFS

Susan M. Tillery, CPA/PFS, is president and co-founder of Paraklete Financial Inc. and co-owner of Financial Planning Advocate LLC, both in Kennesaw, Ga.

Using 3D formulas in Excel

Using 3D formulas is a easy way to manage files than summing each individual spreadsheet tab.

Line items

IRS blames old tech in destruction of information returns … IRS audit rates decreased most for wealthy, GAO finds … Staffing shortages, backlog hampered IRS in 2022 filing season, TIGTA says … Inflation boosts HSA amounts for 2023 … Helping build a better tax system (podcast)

SPONSORED REPORT

Preparing clients for new provisions next tax season

As the 2025 filing season approaches, H.R. 1 introduces significant tax reforms that CPAs must be prepared to navigate. These legislative changes represent some of the most comprehensive tax updates in recent years, affecting both individual and corporate taxpayers. This report provides in-depth analysis and guidance on H.R. 1.