Get the Word Out: Years of Information Can Be Conveniently Stored at Web Sites

By Lenning, Jeff | Journal of Accountancy, July 2006 | Go to article overview

Get the Word Out: Years of Information Can Be Conveniently Stored at Web Sites


Lenning, Jeff, Journal of Accountancy


EXECUTIVE SUMMARY

* CPAs can use Web sites to store many years of data, permitting clients quick and easy access 24/7. The sites, also called reporting portals, can handle data that are formatted in many different ways.

* Data that are otherwise hard to display can be formatted without any special technology so they can be read by a Web browser.

* A special function in Excel can transform a static file being uploaded to a Web site to a dynamic, or interactive, file. Typical dynamic worksheets are loan-payment calculators and pivot tables, whose data adjust when their underlying information change.

* Easy access to sensitive client data comes with a price. You don't want such information to be easily accessible to everyone, so you must implement very effective security measures.

* If your organization's Internet site does not have effective security, you have two choices: Hire a Web consultant with security experience or rent a professionally managed site and let its specialists set up a security system for you.

**********

How do you distribute financial reports to clients, shareholders and key people in your organization? If you're low-tech, you probably mail them. If you've been following my, suggestions of several years ago, you create hyperlinks in Excel files and e-mail the files so clients can drill down into them for details (see "Financial Reports in a Snap," JofA, Apr.00, page 31). But today's technology lets you do it a better way: uploading all clients' financial information to a Web site so they can access current and past reports 24/7, no matter how the data originally were formatted. If you want to learn how to do that, read on.

As you know, client data come in different formats. For example, tax software programs calculate and display returns with proprietary technology, and usually are able to convert themselves into the free Web-friendly Adobe Acrobat (files with a .pdf extension). Tax professionals usually prepare support data for schedule D basis computations in Excel, which isn't native to a Web browser, but it, too, can convert itself to hypertext markup language (HTML) so browsers can read it. P&L statements, which CPAs usually calculate and display with proprietary accounting software programs, also can translate themselves into Adobe Acrobat. Thus CPAs can easily store this virtual Tower of Babel of financial information, and clients can easily access it any time of the day or night via a Web site without any special technology.

A Web site also lets you extend Excel's presentation in a very powerful way If you display a static worksheet, such as a balance sheet, and change only a single number on it, you have to replace the entire worksheet. But a special function in Excel transforms a static file being uploaded to a Web site into a dynamic, or interactive, file. Typical dynamic worksheets are loan-payment calculators and pivot tables, whose data adjust when their underlying information changes; there's no need to upload a whole new worksheet.

A BANK OF DATA

Now that we've described the flexibility and diversity of information that can be stored on the Web, let's see what such a site, also called a reporting portal, looks like. Exhibit 1, page 66, shows a screenshot of a typical opening page of a portal created by a CPA firm. As you can see, it contains three years of data--2003 to 2005--for client John Smith.

[ILLUSTRATION OMITTED]

A click on any of the years' icons drills down to three further choices for that period: a .pdf copy of the client's 2004 final tax return, an HTML version of an Excel file on schedule D basis support and a .pdf version of final QuickBooks financial statements (exhibit 2).

[ILLUSTRATION OMITTED]

If a client is applying for a mortgage, say, and needs a copy of last year's tax return and a current P&L statement, all he or she has to do is open the portal and click on a few icons for immediate access. …

The rest of this article is only available to active members of Questia

Sign up now for a free, 1-day trial and receive full access to:

  • Questia's entire collection
  • Automatic bibliography creation
  • More helpful research tools like notes, citations, and highlights
  • Ad-free environment

Already a member? Log in now.

Notes for this article

Add a new note
If you are trying to select text to create highlights or citations, remember that you must now click or tap on the first word, and then click or tap on the last word.
One moment ...
Default project is now your active project.
Project items

Items saved from this article

This article has been saved
Highlights (0)
Some of your highlights are legacy items.

Highlights saved before July 30, 2012 will not be displayed on their respective source pages.

You can easily re-create the highlights by opening the book page or article, selecting the text, and clicking “Highlight.”

Citations (0)
Some of your citations are legacy items.

Any citation created before July 30, 2012 will labeled as a “Cited page.” New citations will be saved as cited passages, pages or articles.

We also added the ability to view new citations from your projects or the book or article where you created them.

Notes (0)
Bookmarks (0)

You have no saved items from this article

Project items include:
  • Saved book/article
  • Highlights
  • Quotes/citations
  • Notes
  • Bookmarks
Notes
Cite this article

Cited article

Style
Citations are available only to our active members.
Sign up now to cite pages or passages in MLA, APA and Chicago citation styles.

(Einhorn, 1992, p. 25)

(Einhorn 25)

1

1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

Cited article

Get the Word Out: Years of Information Can Be Conveniently Stored at Web Sites
Settings

Settings

Typeface
Text size Smaller Larger Reset View mode
Search within

Search within this article

Look up

Look up a word

  • Dictionary
  • Thesaurus
Please submit a word or phrase above.
Print this page

Print this page

Why can't I print more than one page at a time?

Full screen

matching results for page

Cited passage

Style
Citations are available only to our active members.
Sign up now to cite pages or passages in MLA, APA and Chicago citation styles.

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn, 1992, p. 25).

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn 25)

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences."1

1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

Cited passage

Welcome to the new Questia Reader

The Questia Reader has been updated to provide you with an even better online reading experience.  It is now 100% Responsive, which means you can read our books and articles on any sized device you wish.  All of your favorite tools like notes, highlights, and citations are still here, but the way you select text has been updated to be easier to use, especially on touchscreen devices.  Here's how:

1. Click or tap the first word you want to select.
2. Click or tap the last word you want to select.

OK, got it!

Thanks for trying Questia!

Please continue trying out our research tools, but please note, full functionality is available only to our active members.

Your work will be lost once you leave this Web page.

For full access in an ad-free environment, sign up now for a FREE, 1-day trial.

Already a member? Log in now.