Q: I’ve been trying to convince my partners that we can boost productivity if we add a monitor to each desktop computer so each workstation will have dual displays. Most of the partners think it’s a waste of money. Since most of them read your Tech Q&A column, I figure
Advertisement
TOPICS
Information management and technology assurance
Who Says You Can’t Create a Watermark in Excel?
Q: My firm’s tech support guy says watermark functionality is not available in Microsoft Office Excel 2003. I can’t see how Microsoft could have left it out. Accountants typically have to be able to circulate a financial report with such words as CONFIDENTIAL or DRAFT printed in light type right
When to Use Stand By, Hibernate or Sleep—It Does Make a Difference
Q: Does it make any difference whether I put my computer to “sleep” by choosing Stand by or Hibernate? A: They both are techniques for putting your computer to sleep—and saving power. So, when you wake them up, the recovery is fast—that is, relative to a startup from a complete
Shortcuts
For Excel Ctrl+Shift+!—Applies the number format with two decimal places, thousands separator and minus sign ( – ) for negative values. Ctrl+Shift+$—Applies the currency format with two decimal places (negative numbers in parentheses). Ctrl+Shift+%—Applies the percentage format with no decimal places. Ctrl+Shift+#—Applies the date format with the day, month and
Compilation and Review Engagements: Why Tackle This Project Now?
Editor’s note: This article is a sidebar to “A Fresh Approach for Compilation and Review.” Based on concerns expressed by stakeholders in compilation and review engagements, the Accounting and Review Services Committee (ARSC) turned to the AICPA’s Private Companies Practice Section (PCPS) for help in its consideration of how to
Supercharge Your Excel Sum Operations
Many CPAs, frustrated by rigid and inadequate reports from their general ledger or other enterprise systems, turn to Microsoft Excel. Nimble but powerful, Excel often manipulates data faster and more effectively than less agile applications. But to perform certain tasks optimally, a CPA sometimes may have to bypass what apparently
CPAs Embrace Twitter
Twitter has taken the Internet by storm. Like LinkedIn and Facebook, Twitter hosts a growing community of CPAs and financial professionals, but unlike its social-networking peers, the microblogging Web site limits users’ messages, questions and conversations to 140 characters (including spaces). To put this limit into perspective, this paragraph has
ETAAC Recommends Congress Mandate More E-Filing
Do-it-yourself e-filing by individual taxpayers increased 19% from 2008 to 2009, the Electronic Tax Administration Advisory Committee (ETAAC) said in its 2009 Annual Report submitted to Congress on Wednesday. However, e-filed returns by tax preparers were down 1%. Overall, the committee estimates that for major form types, 59% of returns
Revamped IT Certification Available
The AICPA on Monday unveiled revisions to the Certified Information Technology Professional (CITP) credential that will reward accountants for real-world experience, life-long learning and, optionally, similar credentialsfrom other organizations. The announcement came at the AICPA Tech+ Conference in Las Vegas. Because CPAs have taken on more responsibility in the areas
Explaining the Sample Fixed-Price Agreement
Editor’s note: This is a Web-exclusive sidebar for “Pricing on Purpose: How to Implement Value Pricing in Your Firm.” Also see Exhibit 7, a sample fixed-price agreement. Date of the FPAThe fixed-price agreement (FPA) shown in Exhibit 7 can be either for a calendar or fiscal year, depending on
A Lesson in Value Pricing Ice Cream: From an Accountant
Editor’s note: This is a Web-exclusive sidebar for “Pricing on Purpose: How to Implement Value Pricing in Your Firm.” The history of business is the history of epiphanies. Sometimes the fog clears up, and the right path is seen. This certainly happened—with respect to pricing—for Ben Cohen and Jerry
After Action Review
Editor’s note: This is a Web-exclusive sidebar for “Pricing on Purpose: How to Implement Value Pricing in Your Firm.” The following questions should be answered by the pricing council/CVO after each major engagement: Did we add value for this client? How could we have added more value? Did we
Sample Change Order
Editor’s note: This is a Web-exclusive sidebar for “Pricing on Purpose: How to Implement Value Pricing in Your Firm.” Client: Date: Project description and scope of services [and estimated completion date, if appropriate]: ________________________________________________________ __________________________________________________________ Price:$_____________ We believe it is our responsibility to exceed your expectations. This Change Order
Pricing Council and CVO Purpose and Criteria
Editor’s note: This is a Web-exclusive exhibit for “Pricing on Purpose: How to Implement Value Pricing in Your Firm.” Examples of purpose and strategy statements for the role of the pricing council and chief value officer (CVO) are: To ensure the firm prices on purpose, according to the value received
Disadvantages of Hourly Billing
Editor’s note: This is a Web-exclusive exhibit for “Pricing on Purpose: How to Implement Value Pricing in Your Firm.” Hourly billing misaligns the interests of the CPA and the client—the client wants work done effectively, whereas the CPA firm wants to log more hours. It does not focus on what
Sample Fixed-Price Agreement
Editor’s note: This is a Web-exclusive exhibit for “Pricing on Purpose: How to Implement Value Pricing in Your Firm.” November 19, 2009 Dear Client: In order to document the understanding between us as to the scope of the work that ABC, CPAs will perform, we are entering into this Fixed
The Five Cs of Value
Editor’s note: This is a Web-exclusive exhibit for “Pricing on Purpose: How to Implement Value Pricing in Your Firm.” For a firm to price on purpose, it must understand the Five Cs of Value: 1. Comprehend value to clients. 2. Create value for clients. 3. Communicate the value you create.
Finally, A Simple But Effective Tool Overcomes Office 2007 Complexity
Q: I’m at my wits’ end. I haven’t got the time or patience to figure out how to use—and let alone find—all the wonderful tools I’m told are in Office 2007. Isn’t there something to get me up to speed so I can concentrate on my work—at least until Microsoft
Shortcuts
EXCEL: WORD: Ctrl+Shift+D—Double underlines the selected text Ctrl+Shift+N—Applies Normal style to current paragraph If you want to change the formatting of a paragraph—say from align left to center—just click anywhere in the paragraph and then right-click, opening this menu: Then click on Paragraph and make your
Price Psychology
Editor’s note: This is a sidebar to “Pricing on Purpose: How to Implement Value Pricing in Your Firm.” People tend to buy emotionally and justify intellectually, which makes the study of price psychology a worthwhile endeavor. Essentially, price psychology has two characteristics: 1. Price leverage 2. Pricing emotions
Features
FROM THIS MONTH'S ISSUE
Create interactive dashboards with Excel PivotCharts and slicers
Leave the static spreadsheets behind. This JofA Technology Q&A article with video walkthrough provides a step-by-step guide for creating interactive dashboards in Excel that decision-makers can use.
From The Tax Adviser
January 31, 2026
Trust distributions in kind and the Sec. 643(e)(3) election
January 31, 2026
Effects of the OBBBA on higher education
December 31, 2025
