Q: Why is it that sometimes when I type a webpage address in Word, it converts to a hyperlink automatically, and sometimes it does not? A: Word recognizes and converts to a hyperlink webpage addresses containing “www” (such as www.irs.gov), but not those that don’t (such as irs.gov). The next
Information management and technology assurance
Staffing, succession emerge as top CPA firm concerns
Succession planning and staffing joined new client acquisition and dealing with the complexities of rapidly changing tax regulations as the top issues facing U.S. accounting firms, according to an AICPA survey released Tuesday. The 2013 Private Companies Practice Section (PCPS) CPA Firm Top Issues survey found evidence that CPA firms
Excel at hyphen removal
J. Carlton Collins outlines two ways to remove hyphens from Social Security numbers in Excel.
OverScan
Q: I purchased a new television for use as a computer monitor and connected the device using an HDMI cable, but this solution is not working properly as my computer displays an oversized screen image that is about 10% too big for my monitor. This prevents me from viewing the
Survey spotlights need for data and security strategies
On the surface, the results of the 2013 North America Top Technology Initiatives survey show that “managing and retaining data” nudged past “securing the IT environment” to become the top technology priority cited by the nearly 2,000 accounting professionals polled. Dig a little deeper, and the evidence indicates that the
Going paperless checklist
Q: Our company has finally decided to go paperless, but we are not exactly sure where to begin. Can you provide some guidance for getting started? A: Most CPAs who go paperless later report they are glad they did. There are many ways to reduce the amount of paper your
Independence is in the eye of the beholder
The independence of CPAs is the hallmark of the profession. As such, accountants put forth significant focus and effort to comply with independence requirements related to everything from investments to business and employment relationships to services delivered to clients. But being what accountants call independent in “fact” isn’t enough. CPAs
Five iPhone tips
1. Magnify. To magnify the iPhone’s screen to improve readability and view image details, enable screen zooming by double-tapping the screen with three fingers. You can then pan the screen image by dragging with three fingers. To use this feature, you must first turn it on by selecting Settings, General,
Trigger happy
Q: I use my client’s GoToMyPC connection once a month to log in to her Windows 7 system to inspect her bookkeeping system and financial reports, and this application is not used for any other purpose. My client does not like having this application up and running on her computer
Seven ways to address IT vulnerability
When Mike Foster hears from CFOs about IT security issues, he gets the sense they’re focusing on a single hacking event here or there, instead of viewing IT security as a project that needs constant management and attention. What Foster tells the CFOs is this: “We don’t want to fight
Data, security take top two spots in AICPA technology priorities survey
On the surface, the results of the 2013 North America Top Technology Initiatives survey, released Wednesday by the AICPA and CPA Canada, show that “managing and retaining data” nudged past “securing the IT environment” to become the top technology priority cited by the nearly 2,000 accounting professionals polled. Dig a
Good vibrations
Q: Most of the decent portable speakers available in stores are too bulky to carry as portable speakers, and the few small ones I’ve tried aren’t loud enough. Can you recommend a small portable speaker that actually works well? A: As a CPE presenter, I typically play a few video
Top concern of FVS practitioners: Business development
The top priorities of forensic and valuation services (FVS) accountants have changed drastically over the past few years, with business development concerns outpacing technical issues, according to a new AICPA study. The 2013 FVS Membership Top Issues Survey found that “bringing in new clients,” the classic business development imperative, ranked
Assurance opportunities broaden
Editor’s note: Beth Schneider is the chair of the AICPA Sustainability Task Force under the Auditing Standards Board. Corporate and public interest in sustainability and climate change issues, and voluntary reporting of greenhouse gas (GHG) emissions information, has grown significantly in the United States during the last decade. Companies have
Restore Windows 8 Start button
Q: I recently upgraded my computer to a Windows 8 system, and so far I like the new operating system. As suggested by many articles, I find that I can do most everything on Windows 8 without the old Start button, but I still would like to have the Windows
Preparing for disaster
One CPA firm is still recovering from a “superstorm” that damaged nine of its 14 offices. Another has constructed a safe room in its new office, which was built after a tornado destroyed its previous office. A third firm is adjusting to the “new normal” in a city forever changed
Use Excel 2013 this instance!
Q: When I open two Excel files in two instances of Excel and display them on two monitors, I find that I cannot then copy formulas back and forth between the files—only the formula’s calculated value is pasted to the other instance of Excel. What’s happening here, and what can
Five iPad questions
1. Print Screen on an iPad Q: I know how to create an image of my computer screen simply by pressing the PrintScreen button, but is there a way to do this on my iPad or iPhone? A: Holding down the Home button and pressing the Power button will create
Time to stock up
Q: Can you tell me where to find good, free internet-based resources and information that will help me analyze my stock portfolio? A: A plethora of web-based resources is available to help you analyze investments and investment options, and I am certainly not familiar with them all. However, over the
Time to recruit talent
Millions of Baby Boomers will leave their jobs in the next 10 to 12 years. This exodus of talent will place extraordinary pressure on every U.S. organization’s talent recruitment and retention efforts. Consider these strategies to help your organization compete in an unprecedented people cycle: Ensure your HR leadership
Features
SPONSORED REPORT
How to find the right CAS clients
The key to success with CAS is selecting the best clients. Tools like ideal client profiles (ICPs), buyer personas, and even artificial intelligence can help identify the businesses that best fit each CAS practice.
