Lewis A. Dulitz, vice president of accounting policies and research at Covidien—a $10.7 billion health care products company with 42,000 employees in more than 60 countries—was part of a team that implemented the necessary technology changes in Europe to help Covidien convert to IFRS and led a similar team in
Information management and technology assurance
Create Your Own Lookalike Office 2003 Toolbar and Add It to the Ribbon
Q I’ve just switched from Office 2003 to Office 2007, and although it’s clearly more powerful, I’m not enamored with the Ribbon. I waste loads of time in frustrating searches through its scattered maze of functions. Isn’t there some way I can keep the Office 2007 muscle but go back
Toward a (More) Paperless Tax Practice
Nearly all CPA firms prepare tax returns electronically. However, many still also use some old-fashioned methods, such as sending out tax organizers manually. Here are tips to more fully realize what it means to go paperless. First, understand and share the goal: A more efficient, digital tax process can help
Reader Input
Paul McClain, controller at the Hillcrest Medical Center in Tulsa, Okla., reminded me of this handy tip for those still using Office 2003: If you have files or folders you use fairly often but you do not want to clutter your desktop or your Start menu with shortcut icons, click
Small Business
Highlighting the experiences of successful entrepreneurs, the U.S. Small Business Administration, in partnership with Dell Inc., launched an online video series offering tools and strategies to help small business owners rebound from the recession and put themselves in a position to expand and create jobs. Strategies for Growth: Advice
Office 2007 Users Can Change Their “Save As” Defaults to Accommodate Those Still Using Office 2003
Q Although I upgraded to Office 2007 soon after Windows 7 came out, many of my clients and colleagues are still using Office 2003. As a result, they often can’t open my Word or Excel files. So I try to remember to save all the files I share with them
The F8 Key Adds a Sophisticated Assist When You Need to Highlight Text in Word
Q I once read that the F8 key provides a better way to custom-select text you want to copy, delete or just format. But I can’t figure out how to do it. Can you help? A Sure, in fact it’s one of my favorite shortcuts. As you know, the basic
Windows Explorer Renames Multiple Files in One Fell Swoop
Q I have a large group of files, all with different names, that relate to one subject. I’d like to rename all of them with the same name, but I also want to give them individual identifiers—such as Money Smith (1), Money Smith (2), etc. I really don’t want to
Adjust the Size of Desktop Icons With a Spin of the Mouse Wheel
Q I sure would like to be able to customize the size of my Windows 7 Desktop icons. Do you know how I can do that? A The icons in the Desktop’s toolbar can be adjusted to either large or small—but nothing in between (see screenshot below). The default
Shortcuts
+ E: Opens the Explorer Window. + D: Toggles between the Desktop and returns you to the last open screen. + L: Locks your computer. + F1: Displays the Windows Help menu. + Pause: Displays the System Properties dialog box. + U: Displays the Utility Manager with accessibility options:
Grow and Thrive
What are you doing to grow your practice? How can you help your clients become more profitable? Use the following tips to redefine the services you provide clients, and look for additional opportunities to develop new revenue sources: —By Alexandra DeFelice (adefelice@aicpa.org), a JofA senior editor, based on a presentation
Financial Accounting Foundation to Maintain XBRL Taxonomy for U.S. GAAP
The Financial Accounting Foundation announced it will take on responsibility for the ongoing maintenance of the XBRL U.S. GAAP Financial Reporting Taxonomy. Its activities will focus on updating the taxonomy for changes in U.S. GAAP, best practices in taxonomy extensions, and technical enhancements. The taxonomy is a list of computer-readable
How to Get Those Vanished Tabs at the Bottom of an Excel Workbook to Reappear
Q Every now and then the tabs at the bottom of an Excel workbook disappear. I don’t know what I did to cause that to happen, and I can’t figure out how to get the tabs to reappear. Please help. A Any number of things can trigger that disappearing act—
Avoiding Common Errors of XBRL Implementation
Following three years of voluntary XBRL submissions, the SEC’s mandatory requirements for XBRL financial report submissions began phasing in June 15, 2009. As with any new process, companies can easily underestimate the challenges posed by this complex reporting technology and make mistakes along the way. This article describes common errors
Improve Tax Tracking With Automated Workflow
“Why should we change the way we track tax work through the office? Isn’t the manual system better?” I have heard these types of questions many times over the years, and it never surprises me because accountants, like many of us, don’t like change. Firms that use a manual system
Client Portals: A Secure Alternative to E-Mail
Federal and state laws continue to get stricter about maintaining the security of clients’ Social Security numbers. Accountants in Massachusetts and Nevada are required to encrypt e-mails that contain clients’ personally identifiable information, and several states have similar legislation pending. Client portals—secure online storage areas—offer an alternative to e-mail for
What’s New for CPAs in Office 2010
Microsoft has updated one of the most important tools in the accountant’s tool kit, Microsoft Office. This article describes the features in the new versions of Excel, Word, Access, PowerPoint and Outlook that are likely to be most important to CPAs when Office 2010 is released in June. Each module
Program Word to Identify the Last Person Who Reviewed a Memo
Q In our firm, various partners frequently review client memos, and it would be very useful if we could identify the last person on the network who worked on the document. Is there a way to do that? A Yes, both Word 2003 and 2007 can do it. In Word
Add the File and Path to a Document or Worksheet So You Can Find It Easier Later
Q When I review a paper copy of a worksheet or a document that I prepared some time ago, I’m forever searching around my computer for where I saved it on my hard drive. Is there a way to automatically insert the name and path of the document so it
The Power of the New Multifunction Calculator in Windows 7
Q I’ve always been a critic of Windows Calculator. Is the calculator in Windows 7 any better? A Yes, it’s much more functional than the earlier version. For example, no longer will you need to turn to Excel to calculate the number of days, weeks, months or years between two
Features
FROM THIS MONTH'S ISSUE
AI risks CPAs should know
Are you ready for the AI revolution in accounting? This JofA Technology Q&A article explores the top risks CPAs face—from hallucinations to deepfakes—and ways to mitigate them.
