John was one of three founding partners in a firm formed 35 years ago. He oversaw the buyout of the other two founding partners and, as managing partner, groomed three young managers as his successors. However, when the time came for these managers to be admitted as partners, two of
Advertisement
TOPICS
Information management and technology assurance
Transposition errors in Excel
Q: Is there an easy way to copy formulas that are arranged horizontally across an Excel worksheet and paste them vertically down the page? When I try this using Excel’s Paste-Transpose command, the cell references change and no longer reference the correct cells. A: I can think of three ways
I read you loud and clear
Q: Because of the smaller screen size of my laptop, I find it difficult to read news and articles on the Web. Is there a way to make Web content easier to read? A: I know exactly what you are talking about. I do most of my reading on a
A wealth of opportunity
Much has been written in recent years about wealth management services that call for practitioners, including CPAs, to have personal financial planning certification and to come under investment-adviser or other regulations. Much less attention has been paid to PFP services that don’t require specialization or additional licensing. One of these
Secure your laptop
Q: I use a Windows password to protect my laptop computer (which runs Windows 7 Professional), but my colleague has advised me to set up a BIOS password, too. Is a BIOS password warranted? A: The use of BIOS and Windows passwords will prevent others from turning on your
Keep the best and brightest
The AICPA’s Private Companies Practice Section (PCPS) recently completed a national survey about the attitudes and aspirations of the most promising young accounting professionals. The 2011 PCPS Top Talent Study (available at tinyurl.com/6tygubv) suggests how firms of all sizes can hang on to top talent. —By Yasmine El-Ramly, CPA/CITP, (yelramly@aicpa.org),
CPAs prioritize security, unsure how to best leverage new technologies
CPAs are confident that their organizations can secure their IT networks and manage data, but they doubt whether their employers will be able to generate revenue streams and other benefits from emerging technologies such as cloud computing and mobile devices, the AICPA reported Wednesday in releasing the results of its
A strategic approach to IT budgeting
Organizations of all types struggle with information technology (IT) budgeting. This often happens because the IT team doesn’t understand the budgeting process and the finance team doesn’t understand IT. CPAs, whether in public practice, business and industry, the not-for-profit sector or government, can remedy this disconnect by changing their organization’s
Daily money management
As Americans enter old age in rapidly increasing numbers, more accountants will run into situations like the one a Virginia CPA encountered last year. The CPA spent five hours rummaging through the home of a 94-year-old client, trying to find the paperwork needed to complete the man’s 2010 tax return.
Ready, set, Excel!
Q: I’ve just installed Excel 2010. Can you tell me which default settings, if any, I should change to make it easier to use? A: When I install Excel, I typically adjust the default settings as outlined below. (These suggestions tend to be more of a personal preference than
Monitoring the field
Q: I enjoyed the February 2011 JofA article “Increase Productivity With Multiple Monitors” (page 28), which addressed using multiple monitors with a desktop computer, but is there an easy solution that allows our audit staff to use dual monitors with their Windows laptops in the field? A: I applaud the
Heads in the cloud: Part 2
The rapid growth of cloud computing is whipping up a storm of change and challenges, opportunities and obstacles for CPA firms. While many firms have embraced the Internet as a place to conduct business more efficiently and effectively, others are holding back, often due to concerns about the security of
Watering your documents
Q: Is there an easy way to insert a prominent disclaimer on each page of a Word 2010 document that reads “For Management’s Eyes Only”? A: Word 2010, 2007 and 2003 provide a watermark solution that likely meets your needs. To use this feature in Word 2010 and 2007, click
Tagging along
Q: I see an increasing number of colorful square patterns popping up in magazines and newspapers, but I don’t understand their purpose. Could you enlighten me? A: Those colorful square patterns you see are Microsoft Tags. To use them, download the free Microsoft Tag reader to your smartphone and scan
Heads in the cloud
Editor’s note: This is the expanded version of the cloud computing round-table discussion from “Heads in the cloud: Part 1,” Feb. 2012, and “Heads in the cloud: Part 2,” March 2012. To help CPAs better understand the benefits and challenges of the cloud, the JofA invited five CPAs to
Keep those names flowing
Q: We have 170 hourly employees and, as part of my job, I prepare job assignment reports in Microsoft Word that contain several lists, sorted by name. As you can see in the attached example report, I use a three-column table in Word to list these names. The problem arises
Ready, set, action!
Q: We would like to produce and publish on our website a simple, three-minute movie clip featuring two people talking about the merits of our financial services. I don’t want to spend a lot of money or take a lot of time, but I am finding this task to be
PivotTable growing pains
Q: I have created several dozen PivotTable reports in Excel to meet our reporting needs. However, as new rows of data are added to the source data, I must constantly redefine the source data range for all PivotTables, which is very time-consuming. Is there a way to make my PivotTables
Help for people with dating problems
Q: I have a problem copying dates to a certain spreadsheet. After pasting a date from another Excel spreadsheet, the new spreadsheet changes the date to one day and four years later! However, if I enter a current-year date (such as 9/15) and hit enter, the date correctly defaults to
Pricing, billing and collecting fees
CPA firms provide invaluable advice to business clients but often struggle to run their own businesses effectively, particularly in the areas of pricing, billing and collections. Failure to set appropriate fees, deliver bills in a timely fashion and collect payment promptly—or even in full—cuts into a firm’s profitability, hurting the
Features
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.
From The Tax Adviser
October 31, 2025
Recent developments in estate planning
October 31, 2025
Current developments in taxation of individuals: Part 2
September 30, 2025
Current developments in taxation of individuals: Part 1
August 30, 2025
