Advertisement
TOPICS

Government Auditing

The U.S. Office of Management and Budget (OMB) issued the Circular A-133 2006 Compliance Supplement ( www.whitehouse.gov/OMB/circulars/a133_compliance/06/06toc.html ), which identifies important federal requirements to be considered as part of an audit in accordance with the Single Audit Act and OMB Circular A-133, Audits of States, Local Government, and Not-for-Profit Organizations.

Print Any Mix of Pages/Sections from a Document

I get into trouble when I want to print various pages or sections of a Word document. More often than not, I end up either printing the whole document or the wrong pages. Can you help me figure out the Print Range controls? Let’s start from the beginning. When you

Pensions

The Pension Benefit Guaranty Corporation published a final rule requiring sponsors of insured defined benefit pension plans to submit their premium filings electronically. As of July 1, sponsors of plans with 500 or more participants must do so for plan years beginning on or after January 1, 2006; for all

Print Outlook’s Contacts As A Paper Phone Directory

Call me old-fashioned, but when it comes to things like address and phone directories, I prefer a paper book. Is there some way to print a little booklet of my Outlook contacts with phone numbers and addresses? Since I didn’t immediately know the answer to that question but realized it

Nudge a Word File that Opens Slowly

I have a few files that open very slowly even though none is unusually large. Do you have any suggestions? First make sure that Track Changes is turned off; it can slow the opening of a file to a crawl. Then, as a further check, click on Tools , Options

Financial Reporting

As part of a broader initiative to improve financial reporting for insurance accounting, FASB issued an invitation to comment on whether bifurcating insurance and reinsurance contracts into insurance and financing components would improve the transparency of financial reporting for insurance accounting ( www.fasb.org/draft/ ). Current standards give insurers and reinsurers

Auditing

The AICPA Center for Public Company Audit Firms (CPCAF) issued a report on the Public Company Accounting Oversight Board’s findings from its inspections of eight PCAOB-registered firms that audit more than 100 public companies ( www.aicpa.org/cpcaf/download/PCAOB_inspection_deficiency_analysis_january2006.pdf ). An earlier analysis focused on PCAOB deficiency reports for firms with 100 or

Save Excel Formulas Without Using Macros

I often repeat formulas in worksheets. I know I can save them as macros and then insert them anytime with a few clicks, but I really don’t like macros. Is there an easy alternative? There is, but I urge you to rethink your aversion to using macros. They actually are

Program Excel’s Page-Order Print Sequence

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

FYI

The Financial Accounting Foundation, which funds and oversees the Financial Accounting Standards Board (FASB) and the Governmental Accounting Standards Board (GASB), appointed Thomas J. Linsmeier, CPA, to FASB for a five-year term that began July 1. A nationally respected accounting educator and researcher, he is chairman of the department of

International

The International Accounting Standards Board published an ED of proposed amendments to International Accounting Standard (IAS) 23, Borrowing Costs ( www.iasb.org ). The proposal requires entities to capitalize borrowing costs that are directly attributable to the acquisition, construction or production of a qualifying asset as part of its cost, rather

Highlights

As initially announced in the July JofA Highlights, the AICPA and FASB issued a joint proposal to improve the standard-setting process for the constituents of private company financial reporting ( www.pcfr.org). The initiative seeks feedback from owners, preparers, auditors, lenders, investors and bonding agencies on proposed enhancements to the board’s

A Better Way To Stamp

In the December 2005 column , I suggested a way to place a stamp ( Prepared By: Reviewed By: ) in a spreadsheet. Reader Allison A. Schultz, CPA, CFO of Southern Aluminum, Magnolia, Ark., suggests an alternative method. After creating the stamp in Excel, highlight it and press Shift+Edit, bringing

Outlook Has A “You’ve Got Mail” Option

I get so wrapped up in my work that I often forget to check my incoming e-mail for hours at a time. Is there some way to program Outlook to give me a nudge or even ring a bell when a message comes in? Outlook does AOL’s “You’ve Got Mail”

Print With Or Without Track Changes Comments

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

A Good Idea

In the February 2006 item “ Out, Out and Stay Out, You Stubborn Reviewing Toolbar, ” several readers correctly noted that the macro I suggested be recorded to Personal Macro Workbook , not New Workbook ; in that way it can be accessed whenever needed.

Search Multiple Worksheets

I usually work with a spreadsheet that contains as many as 24 worksheets. When I do a search using the Find command, I have to repeat the command for each worksheet. Is there a way to command Find to search all the worksheets in one swoop? Yes, not only can

The Small Firm Advantage

EXECUTIVE SUMMARY Despite their modest size, local practices have many real advantages that give them a competitive edge in recruiting, retention, client service and other vital business areas. PCPS is undertaking many new efforts to support its small firm members, and is rededicating itself to initiatives and publications that highlight

A Fast Way To Replace Two Spaces After The Period With One

As the officer manager of a midsize firm, I review all documents created by the accountants for spelling, grammar and style. No matter how often I tell them that the period at the end of a sentence is followed by one space—not two—I get memos with mostly two spaces. The

Another Better Way

In the February 2006 item “ Overcome Excel’s Sort Function Shortcoming,” reader Rick Childs, CPA, CFA, a Crowe Chizek executive, suggests using Excel’s custom format to overcome its Sort function limitation. He selects the 0 format category (see screenshot below) and then adds the necessary letters in front of the

FROM THIS MONTH'S ISSUE

Data governance: How finance builds trust in data

Learn how finance can use data governance to improve data quality, strengthen internal controls, and build trust in business data.