Note by X4apL3

VIEWS: 0 PAGES: 1

									  MAKING FINANCIAL REPORTS AVAILABLE ON AN INTRANET
                      Financial Reporting Index
                      ABC Company

                          1.   Current reports
                          2.   Past reports
                      Note: Row & Column headers in this Excel file were
                            omitted so as to have a Weblike appearance.

                                    Index.xls (Sheet: "Welcome")


 Current Reports
 ABC Company

 I. FINANCIAL REPORTS:
           Name            File Type           Date/Period      Contact     Description
    1. Income Statement       Excel               3/01           Arnie    Operating results
    2. Balance Sheet          Excel             3/31/01          Arnie    Financial position
    3. Cash Flow Statement    Excel                3/01           Arnie   Cash flows

 II. OPERATING REPORTS:
     1. Headcount                    Word          3/01          Arnie    Employee listing

                          Index. xls (Sheet: "Current Reports")


                         A                        B            C             D
               1 Income Statement--March 2001
               2 ABC Company (has a calendar year-end)
               3                                         Year -to-Date
               4                              March 2001   (3 months)
               5 Sales. . . . . . . . . . . . . $100,000    $440,000
               6 Cost of sales. . . . . . . (60,000)         (260,000)
               7 Expenses . . . . . . . . . (22,000)         (103,000)
               8    Net Income . . . . . . $ 18,000          $ 77,000

                   Note: The two other Sheets in this Excel file are:
                        "Balance Sheet--3/01"
                         "Cash Flow Statement--3/01"

                          2001-03.xls (Sheet: "Income Statement--3/01")



Advantages of Using Excel's Hyperlink function on an Intranet
 versus uploading to a Web server :
 1. Simpler--no need to convert to HTML.
 2. Makes reports " dynamic " (any change in in underlying data is automatically updated
    in displayed data)--not "static."
 3. User retains full control of the data presentation, formatting and the printing setup.
 4. Users drill down reports for details right to the source of the data.
 5. Access to files can be restricted with network security.

For more detailed information, see "Financial Reports in a Snap" by Jeff Lenning in
 Journal of Accountancy, April 2000, pp. 31-35.




                                 996cd201-01db-48ba-9301-46747e314d00.xls                      8/7/2012   2:58 AM

								
To top