Page 494 - JoFA_2022

December 2022

18 | Using Power BI for 36 | Tax Matters
advanced QuickBooks Improperly forgiven PPP loans must
data analytics be included in income
You can import QuickBooks data ‘Family support’ payments not
into PowerBI in order to perform deductible as alimony
more advanced analytics than
QuickBooks is capable of. This
article gives step-by-step instruc-
tions on how to do so.

40 | Technology Q&A
In this month’s column, learn how
to automatically create subtotals in
Microsoft Excel, use Mail Merge to
send bulk emails, and automatically
30 | Proposed AICPA tax color-code cells in Excel.
This month’s TOP STORIES standards address new
concerns 46 | The Last Word
6 | The trends that will The AICPA is seeking comments Ashley Fogle, CPA, enjoys her
affect CPAs in 2023 by Dec. 31, 2022, on proposed career as a senior tax manager at
changes to the Statements on HoganTaylor in Oklahoma City,
Experts across the profession predict Standards for Tax Services, which while building a local business.
that talent, technology, and ESG will have been reorganized and amend-
ON THIS PAGE: MIDDLE: IMAGE BY RZOZE19/GETTY IMAGES; TOP RIGHT, FROM LEFT: IMAGE BY ILLUSTRATOR DE LA MONDE/GETTY IMAGES;
remain top concerns against a backdrop ed to reflect the current state of
of economic pessimism. the profession and the emerging
needs of today’s members.
12 | 50 years of ALPFA: How
Latino CPAs found strength COLUMNS
in numbers
In the past 50 years, the Asso- 04 | Professional Liability
ciation of Latino Professionals for Spotlight
IMAGE BY STUDIOSTOCKART/GETTY IMAGES; BOTTOM RIGHT: PHOTO BY BRETT DEERING/AP IMAGES
America, or ALPFA, has grown Do I really need a new engagement
from 19 to about 100,000 members letter for that?
in accounting and finance. Along A dually signed engagement
ON THE COVER AND ABOVE: IMAGE BY VYACHESLAV MOTSERENKOV/GETTY IMAGES;
the way, ALPFA has become a letter is always the best way to
vehicle for social change and a net- document agreed-upon services,
working forum for Latino students, especially if a disagreement
professionals, and businesses. arises.

AICPA: Where to turn

Member Service Center AICPA Technical Hotline AICPA Tax Section
1-888-777-7077 1-877-242-7212 Visit www.aicpa.org/tax to
Or chat with us at www.aicpa.org. 9 a.m.–8 p.m. ET, Monday–Friday stay current on the latest tax
Chat and phone service available us.aicpa.org/research/technicalhotline.html developments and access guidance,
9 a.m.–8 p.m. ET, Monday–Thursday The hotline is available for questions about tools, and learning on key topics and
and 9 a.m.–6 p.m. ET, Friday accounting, auditing, and attest. A live chat trending issues.
feature is also available.

journalofaccountancy.com December 2022 | 3