Creating a Statement

See Also...  

Creating the historical statement for a client is a key function.  When you initiate a statement for a client, you set up the first period at the same time.

Steps: Getting to the Create Statement and First Period Dialog Box

You have two ways of accessing the Create Statement and First Period dialog box, from which you create a statement:

Steps: Add Statement and First Period

To create a statement for a client:

  1. Access the Create Statement and First Period dialog box, as described in the preceding steps.

  2. Complete the fields in the Create Statement and First Period dialog box that appears.

    Field Name

    Required Field?

    Description

    Industry

    Yes

    Choose the client's industry from the drop-down list. The client's statement will be spread using the chart of accounts for the selected industry.

    A single client can be assigned one industry only; you can't create different spreadsheets for different industries.

    Note: After you click OK in this dialog box to create the statement, the only way to change the industry is to delete the statement and start over.

    Industry Template

    No

    If you wish to apply an industry template when creating a new statement, select the template from the Industry Template drop-down list. This field is initially filled with the name of the template marked as the default for the selected industry.

    Statement Currency

    Yes

    Select the currency to use for the statement. You will be able to change the currency and convert to a different currency later if necessary.

    Statement Unit

    Yes

    Choose Actual, Thousands, Millions, Billions, or Trillions from the drop-down list.

    If you choose Actual, the application will assume that the numbers on the spreadsheet are full dollar amounts; if you choose Thousands, the application will add three zeroes behind the scenes to the numbers that you enter; and so on.

    A client can be assigned one Statement Unit value only; the application will assume this dollar unit for the client's entire statement.

    Date Order Ascending

    Yes

    If you keep this check box selected, the periods in the statement will appear in ascending chronological order so that the most current period will always be the right-most period in the spreadsheet.

    If this check box is deselected, the periods in the statement will appear in the order in which they're added to the statement.

    Fields Specific to the First Period

    Period Date

    Yes

    Enter the date representing the end of the first period.

    Months

    Yes

    Enter the number of months in the first period.

    Number of Periods

    Yes

    Type the number of periods you want the statement to cover.

    You can now create multiple periods when creating a statement. You can enter any number of periods between 1 and 60; 1 is the default value for this field.

    Note: If you add another period, it will end on the date entered in the Period Date field plus the number of months entered in the Months field.

    Period Type

    Yes

    Select the type (historical, budgeted, or currency) for the first period in the statement from the drop-down list. You can change this selection later if necessary.

    Note: If you entered more than one period, then the value you enter in this field will be used for every period.

    Quality

    Yes

    Select the first period's quality rating.

    Note: If you entered more than one period, then the value you enter in this field will be used for every period.

    Preparer

    No

    Select the preparer for the first period. Your system administrator defined the options in this drop-down list. (If the preparer you need is not on the list, ask your administrator to add it to the list.)

    Note: If you entered more than one period, then the value you enter in this field will be used for every period.

    Analyst

    No

    This drop-down list consists of all the users set up in your application's security.

    Note: If you entered more than one period, then the value you enter in this field will be used for every period.

    Short Description

    No

    Enter a description to distinguish between the current period and others  with the same date, length, type, currency, and quality.

    Period Status

    No

    Select the status best describing this period.

    Note: Do not select Complete if you want to edit data in the statement. Setting the Period Status to Complete makes a statement period read only.

    Note: If you entered more than one period,then you will enter the information for the Period Status field for each period individually.

    Period Comments

    No

    Enter any comments about this first period.

    Note: >If you entered more than one period,then you will enter the information for the Period Comments field for each period individually.

     

  3. Click OK.

The historical statement page appears, with the chart of accounts reflecting the industry you selected and the first period ready for input.

You can later modify the settings you selected for the statement (you cannot change the industry, however) and for the first period.