Advertisement
TOPICS

AICPA Calls for Safeguards for Electronic Data Provided for IRS Exams

The AICPA called on the IRS to start a dialogue to fix what it views as an important problem for some small businesses under audit examination: providing electronic records to the IRS while protecting confidential information that is not relevant to the IRS’ request.   The IRS maintains that the

SEC OKs New GAAP Taxonomy for XBRL

The SEC has adopted the 2011 U.S. GAAP Financial Reporting Taxonomy, which is used for creating and submitting tagged interactive data files in extensible business reporting language (XBRL), the Financial Accounting Foundation (FAF) said in a press release Tuesday. The taxonomy contains updates for accounting standards and other improvements to

The Blind Side of E-Mail

Q: If someone has sent you an e-mail and it was also sent to a blind cc, and you then hit Reply to All, does it also go to the blind cc or only to the individuals revealed on the e-mail? A: Your concern is understandable, but no, replying to

Are You Linked In?

While LinkedIn provides benefits particularly helpful for accountants, it is important to review all that a free, basic LinkedIn account offers. From profile creation to making connections and recommendations, LinkedIn tools can benefit users in any profession. CREATING AN ACCOUNTGetting started with LinkedIn begins with visiting linkedin.com to create a

I Don’t Want to Lose You

Q: I’ve had two employees lose their cell phones. Each time they lost valuable client contact information. I don’t want this to happen again. What is the best way to back up contact data on a cell phone? A: Backing up your cell phone data is a good idea because

Your Cheating Chart

Q: I find charts helpful, but I’ve heard that they can be used to skew data or distort actual results. Is this true, and if so, how? A: You are correct that charts are useful tools for visualizing and analyzing data. However, what you have heard is also correct—charts can

A Search for a Better Search

Q: Our CPA firm has more than 400,000 data files on the file server, and we constantly struggle to locate the right file. For example, recently an audit staffer retrieved an Excel file that contained fixed-asset depreciation calculations and used this in the audit. Unfortunately, the version of the file

LinkedIn Tips for CPAs

Say you run a small accounting practice but are not a marketing expert. What can you do to build your business that’s easy, quick and inexpensive? The answer is LinkedIn. The LinkedIn platform is designed specifically for business use. It is the social media of choice for more than 90

Five Excel Quick Tips

1. Sticky format painter. Double-clicking on the Format Painter icon will cause it to stick, so that you can continue to apply the desired format to multiple cells, ranges, columns or worksheets. To turn off this effect, either press the Esc key or click the Format Painter icon.   2.

Make Your Mark With Your Social Media Status

Blogging and social networking truly remind your clients and colleagues of why, when and how to recommend or refer you. Here are some tips on how to put social media status updates and other low-maintenance missives to work for you: —By Vikram Rajan (vik@phoneblogger.net), the founder of phoneBlogger.net and author

I Stand Corrected

Q: Sometimes when I misspell a word, Word automatically corrects the spelling for me, but other times it doesn’t. Does this indicate a problem with my spell checker settings? A: Office 2003, 2007 and 2010 include a feature called AutoCorrect that is useful in two ways, as follows: As you

Mobile Devices Top CPAs’ Tech Survey Rankings

CPAs and financial executives for the first time rated the proliferation of smartphones, tablet computers and mobile devices in the workplace as their top business technology concern, according to the AICPA’s 2011 Top Technology Initiatives Survey. Mobile devices edged out information security, which had topped the list of tech concerns

Clarification

Christopher Breslin, a CPA in Louisville, Ky., spotted an important caveat that we neglected to mention in a recent “Better Idea” item (“Technology Q&A,” JofA, Nov. 2010, page 70), which suggested ways of averaging noncontiguous cells in Excel that contain some zero values. The two methods suggested would average all

Heaven Help Us

Q: I am new to Windows 7, and I really like the look and feel as well as the speed of the new operating system. However, I am apprehensive about learning to navigate another computer system. What can I do to learn the ropes as fast as possible? A: The

Dashboard Your Scorecard

Dashboard reports created in Microsoft Excel are powerful, flexible and easy to design. In much the same way that an automobile dashboard graphically displays numerous measures of performance from the gas level to oil pressure, a computer dashboard presents critical data in a variety of visual formats. From this organized

Increase Productivity With Multiple Monitors

CPAs who use dual monitors are finding that the addition of a third or fourth monitor also pays dividends. As the number of applications CPAs depend on expands, so does the need for more screen real estate. While a CPA’s two primary monitors are typically used to manage core applications

Full Screen Ahead

Q: When browsing the Internet, I like to hide my browser’s menu and toolbars by right-clicking on the toolbar and unchecking the various menu and toolbar check boxes. This gives me more room to view the Web page. However, it is a hassle to constantly remove and restore the toolbars.

CPAs Share Continuation Strategies

Editor’s note: Also read “Who Would Run Your Firm?” Feb. 2011, page 40.   In August 1988, 48-year-old CPA Jim Feigel was in an accident that left him in a coma for 23 days. “If anything ever happens to me, the first thing you should do is sell the practice,”

Hidden Tips for Hiding Data

Q: I have a worksheet that has columns hidden, and the worksheet is protected by a password. I found that if I highlight the columns and copy to a new worksheet, I can unhide the hidden columns, and the data is available to the user. How do I protect my

That’s a Shifty Move

Q: Because I live in a rural area, slower Internet access is my only option, but I still do a great deal of reading on the Web. The slower connection makes it frustrating to click back and forth between the articles and the main page because I have to wait

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.