AICS Research


Financial
Statements


Last updated:

February 15, 1999
Summit Spectrum 28.13

Report highlights

This report produces a one page Statement of Financial Condition and a one page Profit and Loss Statement. Each includes last year, last month, current month and budget information, as well as variances to budget and last year. Additionally, several pie charts have been created to show the composition of various balance sheet and income statement categories.

Budget information is manually input, in lieu of using the Budget module. Actual data is pulled directly from the databases.

The worksheet is all that is necessary to create the report. However, the report has been automated to run at the end of the month without input or interference from an operator. In this way, the financial statements are printed and waiting with the other month end reports.


Files included
  • FinStmtW - QueryCalc worksheet
  • FinStmtM - QueryCalc macro
  • FinStmtJ - job which runs the macro
  • Readme.txt - a text file of instructions

Databases accessed
  • GLDATA - Spectrum Image Database

Special Requirements

PostScript printer. In order to print the report to the PostScript form provided, you must have a PostScript printer. If you do not have a PostScript printer, you will need to edit the layout page(s).

QC Reports   QueryCalc

     Top