CPA firm owners say succession planning is important, and a growing number of firms have formal plans in place. Still, many firms and sole proprietors have a great deal of succession planning work ahead of them. Among the challenging statistics that emerged from a recent AICPA survey on the topic:
Information management and technology assurance
Touchy underlines
Q: Because I think the solid underlines on my Excel-based financial reports look less professional, I insert thin, blank columns between my data so the underlines don’t touch one another. This process of inserting and reformatting columns is tiresome. Is there another way to produce the underline breaks I want
National mobility campaign adds California and D.C.
As California and the District of Columbia reach major milestones related to individual CPA mobility laws, profession leaders pause to reflect on what this means and assess the next steps in promoting cross-border practice. California Gov. Jerry Brown on Sept. 20 signed legislation that facilitates cross-border mobility for out-of-state CPAs
Practice safe e-filing
Since 2012, e-filing generally has been mandatory for tax preparers or firms that anticipate filing 11 or more federal individual or trust returns in a calendar year. However, e-filing presents a variety of dangers and unintended consequences not present with paper filing. Here are tips to make e-filing as safe
Green computing tips
Q: Should we be concerned about the amount of energy our computers consume, and if so, what measures can we take to conserve energy and reduce the cost of operating our computers? A: Of course, we should all strive to use energy efficiently. Accordingly, listed below are possible computer-related tips
Wireless breadcrumbs
Q: How can we determine if any of our employees are visiting inappropriate websites at the office using company-supplied computers and internet access? A: The process of browsing the internet leaves telltale breadcrumbs on your wired or wireless routers, enabling you to monitor web activity by user. Almost all routers
Three IT challenges to watch for in 2013
The global information systems organization ISACA is urging businesses to prepare for tough decisions in the year ahead in three areas: data privacy, cloud computing, and increasingly complex cyber-threats. Interest in private or hybrid (public/private) cloud solutions is expected to grow because of information security concerns, according to ISACA. Meanwhile,
KPMG revenue tops $23B on gains in advisory, tax
Fiscal 2012 financial results released by KPMG International suggest that strong demand for advisory and tax services and rapid revenue gains in emerging markets helped the Big Four accounting firm shrug off the effects of the eurozone crisis. The global network of firms that make up KPMG International reported $23.03
Google, Apple, Samsung surge to top of market for smartphones, tablets, PCs
Google, Apple, and Samsung are leading a sales surge in the worldwide smart connected device market—a category consisting of personal computers, tablets, and smartphones—that should continue for at least the next five years, according to new research from International Data Corp. (IDC). The IDC’s Worldwide Quarterly Smart Connected Device Tracker
Most CPAs see role in helping clients adopt technology, AICPA survey finds
Nearly 40% of CPAs see themselves as catalysts for their clients’ adopting innovative technologies such as cloud computing and mobile devices, according to survey results released Wednesday by the AICPA. The survey of 624 AICPA members in public accounting found that an additional 43% of CPAs will respond to clients’
What’s your fraud IQ?
Trying to uncover evidence of fraud in a data set of millions of records is somewhat akin to searching for a needle in a haystack. Fortunately, the successful employment of data analysis techniques can clear away most of the “hay” and leave the fraud examiner or auditor with a much
The games people play
Q: I have an employee who plays social media games on his lunch break. Will playing these games slow down his computer or cause other harm? A: The vast majority of computer performance issues and crashes occur when a computer runs out of available memory. Because many computer games involve
2012 MAP Survey: Signs of recovery
Accounting firms aren’t all the way back to where they were before the Great Recession, but they are making progress. That’s one of the many findings of note in the 2012 National Management of an Accounting Practice (MAP) survey, sponsored by the AICPA Private Companies Practice Section in association with
I’ve got you pegged
Q: We use a wall map with pushpins to keep track of the location of our service technicians, but this manual method requires continual phone calls and pushpin adjustments. Can you recommend a cheap and easy technology solution that would enable us to see where our service technicians are and
Small keys create big problem
Q: Help! My laptop has half-size keys, and this keyboard is almost impossible to use with my large fingers. What can I do? (The image at right shows two normal size left and right arrow keys, and two half-size up and down arrow keys.) A: The same thing happened to
Run a tab for this table
Q: I use a lot of tables in Word, and it would be nice if the Tab key would actually indent my table data, but that functionality does not work—the Tab key simply moves my cursor to the next cell in the table. Is there a setting that makes the
Sum highlights for you
Q: I was disappointed to find that Excel’s AutoSum tool produced an error in my workbook, which I did not catch until it was too late. The problem resulted when I highlighted row 15 (as pictured below), and then clicked the AutoSum tool to insert formula totals at the bottom
Five tips using Excel’s Fill Handle
1. Drag the Fill Handle of a single cell to copy that cell. The Fill Handle is at the bottom right of any selected cell or group of cells. 2. Drag the Fill Handle of a cell containing January, Jan, JAN, Monday, Mon, or MON, Quarter 1, or Q1 to
Table rows are a drag
Q: I often rearrange rows in Word tables, and I find it cumbersome to insert a new blank row, copy and paste row data, and then delete the original row. Is there a faster way to accomplish this task? A: To rearrange rows in a Word table, you need not
Online shopping sends business productivity down the Amazon
With the arrival of the holiday shopping season, the analysis of a particular work email account serves as a cautionary tale to employers. Barb Bowes, a human resources consultant and president of Legacy Bowes Group in Winnipeg, Manitoba, offered the example of a company that found an average of 35
Features
ALSO FEATURED
How to protect nonprofits from hidden fraud risks
CPAs can help not-for-profits spot the red flags of common schemes, so they can take steps to tighten controls and reduce exposure.
