Q. I regularly print many different sections of a large and complex spreadsheet. Since I don’t want to print the entire workbook, I must highlight the area to be printed and then, when I evoke the print menu, I click on Selection so that only the highlighted area is printed.
Automate Shortcuts
ccountants spend hours working at computers, and usually much of that time they’re doing repetitive tasks—such as opening the same group of spreadsheets or creating the same header or formatting for each new workbook and document. Wouldn’t it make sense to invest a little time to create programs that
IRS Can’t Invalidate Return After Accepting It.
In 1996 after 15 years of marriage and of filing joint federal income tax returns, a husband and wife divorced. Shortly thereafter, a professional tax preparer filed a joint 1995 return on their behalf, without either the husband’s or wife’s signature. The IRS accepted and processed the return, and the
Word Format Check
» Key to Instructions To help readers follow the instructions in this article, we used two different typefaces: Boldface type is used to identify the names of icons, agendas and URLs. Sans serif type shows the names of files and the names of commands and instructions that users should type into
Financial Reporting
Corporations whose press releases provide pro forma earnings should also include a reconciliation to GAAP results, according to best practices guidelines jointly issued by the Financial Executives Institute and the National Investor Relations Institute ( www.niri.org/publications/alerts/ea042601.cfm ).
Work Better In Outlook’s Tasks
Q. I use the Tasks feature in Microsoft Outlook to keep a schedule of files—both documents and spreadsheets—that I must open and review in the weeks ahead. Although the feature is a handy tool for alerting me, I wonder if there is a more efficient way to accomplish that chore.
Smart Stops on the Web
Links, Links and More Links www.estateplanninglinks.com This site offers both the consumer and the professional planner links to estate planning and related sites. The home page is organized under headings such as Charitable Planning, Elder Law, and Probate and Living Trusts. The Understanding Estate Planning section offers links to glossaries
Personal Financial Planning
Fewer than three of four workers saved for retirement in 2000, says a new survey. According to researchers, while health care expenses worry workers who have tried to estimate their retirement needs, those who have not fret less about their retirement income ( www.ebri.org/rcs/2001/index.htm ).
Has the IRS Killed Split-Dollar?
Insurance Issues is a new column making its debut in the JofA this month. It will provide regular coverage of insurance-related subjects of interest to CPAs, their clients and employers. or more than four decades, split-dollar plans have been a popular way to fund employee insurance benefits, deferred compensation,
len_ex12
Exhibit12
Finance Execs Make More, Risk More of It
CFOs’ compensation increased 17% in 2000, but more than half their pay consisted of stock options. The at-risk (nonsalary) share of pay went up for other financial executives as well, reflecting corporations’ greater emphasis on tying compensation to performance. CFO Controller Treasurer Top tax executive Top audit executive
Insurance
The National Association of Insurance Commissioners says its plan to improve the uniformity, efficiency and effectiveness of state insurance regulation will serve consumers better than the American Council of Life Insurers’ call for an optional federal charter for life insurance companies. Meanwhile, the Shadow Financial Regulatory Committee—an independent research group—evaluates
FYI
Gary S. Schieneman, CPA, begins a two-year term with FASB on July 1, replacing Anthony T. Cope, who has joined the International Accounting Standards Board ( http://accounting.rutgers.edu/raw/fasb/news/nr051401.html ). The United Kingdom’s accounting standards board appoints Douglas Flint to a three-year term ( www.frc.org.uk/publications/publication335.html ).
AICPA Names Albrecht Outstanding Educator
The Institute honored W. Steve Albrecht, associate dean of the Marriott School of Management at Brigham Young University, at its spring council meeting, with the 2001 Distinguished Achievement in Accounting Education Award for excellence in teaching and national prominence in the accounting profession. A frequent speaker on forensic accounting and
International
A new IFAC discussion paper examines the methods different countries’ accounting organizations advocate for defining and achieving competence in professional accountancy. Comments are due by October 31 ( www.ifac.org/News/LastestReleases.tmpl?NID=99010990012150 ). The Organisation for Economic Co-operation and Development’s initiative on harmful tax practices draws the opposition of the U.S. Treasury secretary,
Accounting
For news from the AICPA and state societies, visit www.cpaweb.org , which also offers online CPE, AICPA professional literature, practice management aids and links to state society Web sites. FASB reaffirms its restrictions on how banks can qualify for sale accounting treatment and issues a series of related questions and
hayes_ex
Tools You Can Use NetMeeting www.microsoft.com/windows/netmeeting/download/ Online conferences and collaboration. ASP. Free. PlaceWare www.placeware.com Excellent tool for larger groups, online seminars and conferences. Pricing varies based on size of audience and frequency of use. CoWorking www.coworking.com Updates on telework techniques and collaborative online tools. Gil Gordon www.gilgordon.com The guru of
Home Sale Exclusion Limited
More and more individuals are using living trusts to avoid probate court and transfer their property to named beneficiaries upon their death. A new letter ruling exposes a potential problem if a married couple’s revocable trust becomes irrevocable after the first spouse dies and the trust then sells the surviving
phil_ex2
Exhibit 2: Guidance From the EITF SEC Issue to Address Priority (By SEC) Where Found ) EITF Status Advertising barter transactions Level 1 Issue 99-17 Consensus* Gross vs. net revenue and display cost Level 1 Issue 99-19 Consensus* Accounting for the costs of developing a Web site Level 1 Issue
Line Items
OK to Donate Stock With No Voting Rights Revenue ruling 81-282 states that, if a taxpayer contributes voting stock to a qualified charitable recipient but retains the right to vote, IRC section 170 (f)(3), which disallows charitable deductions for partial interests in property, will deny a charitable contribution deduction if
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.
