Advanced Statement Formats


This selection enables you to create custom financial statement formats.

ProformaStatement.gif (4840 bytes)

    Begin entering data, or enter END to exit this screen.

FORMAT ID

    Enter a unique ID code which identifies the format. The ID should contain standard
    keyboard characters and no spaces. If the ID already exists, the rest of the
    information will be displayed, allowing you to edit from the MODIFICATIONS
    prompt. To search for an ID, enter ??? and RETURN to select from the list displayed.

DESCRIPTION

    Here, you may enter a longer, descriptive name for the format.

WIDTH

    Enter the number of print positions between 0 and 132 which this column will
    occupy on the report. Press the RETURN to to exit this prompt after all column
    information has been entered, to access the line information portion of the screen.

JUSTIFICATION

    Enter an L to have the data start printing at the left side of the column, or enter an
    R for data to be printed on the right side of the column. Example: (ABCD ) vs.
    ( ABCD)

POSITIONS

    Enter the number of decimal positions to show in the column (0,1,
    or 2). Example: 12, 12.0, 12.00

FORMAT

You may enter up to 3 characters for this field from the following list:

$ Prints a dollar sign in front of amounts.
, Prints a comma separating 1000’s in numbers.
C Prints CR following negative values, and nothing following positive or zero values.
D Prints DR following positive values, and nothing following negative or zero values.
E Encloses negative balances. Example: <1234.56>
M Prints - following negative values, and nothing following positive or zero values.
N Causes the minus sign to be suppressed.

     

OUTPUT DATA

    You may specify literal data to be output or a formula to calculate from other columns
    or totals or a code to show an amount desired from the chart of accounts on an account
    type line.

    A formula must start with an "F;". Other column data on the same line is specified with
    a "Cn". Amounts on total lines may be specified by using to total name, i.e.:
    F;(C1*100)/(C2+TOTAL1).

    Literal data may be entered directly.

     

    The codes used with account type lines are:

    GL# display the Chart of Account ID.
    GL#; after the semi-colon (;), the following codes may be
    used to control the display of the ID(END,DEPT,ACCT). All
    other characters will be printed as entered, i.e.: GL#;ACCT or
    GL#;ENT-ACCT
    ENT Entity portion of the ID, DEPT - department, ACCT account number.
    GLDESC General Ledger description from the Chart of Accounts file.
    MTD Month to Date amount.
    MTDBUD Month to Date budget amount.
    MTDLY Month to Date amount last year.
    MTD# Future Month to Date.
    MTD2 2 mos. ahead MTD-# - Previous Month to Date. MTD-2 = 2 mos. prior
    QTD Quarter to Date amount.
    QTDBUD Quarter to Date budget amount.
    QTDLY Quarter to Date amount last year.
    LQ Last Quarter Amount.
    YTD Year to date amount.
    YTDBUD Year to date budget amount.
    YTDLY Year to Date amount last year.
    BYB Beginning Year Balance.
    YTDACT Year to Date Activity

TYPE

    The valid types are:

H - HEADING LINE

    Special text line that should be used at the top of the first page. When a P
    type line is printed, the last H type lines used are printed again. Also, if H type
    lines come after other type lines, a form feed is executed before they are printed
    except when the previous line is a P type line.

C - COLUMN HEADING LINE

    Special text line that operates like the H type line. This allows you to change H
    type lines without affecting C type lines at Page time.

P - PAGE LINE

    Prints the text associated with it, executes a form feed, and prints the most
    current heading and column lines. If H type lines directly follow the P type
    line, they are printed instead of the previous heading lines.

TX - TEXT LINE

    Will be printed "as is" where placed. Useful for putting in commends and
    underlines.

A - ACCOUNT LINE

    A valid Chart of Accounts ID will be prompted for to supply data for the columns.

AS - ACCOUNT LINE

    Account line with output suppressed.

NI - NET INCOME LINE

    Used in balance sheet statements to be added into retained earnings. It will be
    printed out like an account line. When this is used, the system will calculate the
    net income for the entity and departments specified.

NIS - NET INCOME LINE

    Net income line with output suppressed.

S - SUBTOTAL LINE

    This will accumulate all A type and NI type lines since the last S type line and
    will print the data in the columns. If a column formula has been specified, the
    column formula will take precedence. A name for each column’s subtotal amount
    will be prompted for.

SS - SUBTOTAL LINE

    Subtotal line with output suppressed.

T - TOTAL LINE

    Allows the entry of a formula computed on the subtotal lines. The result of this
    formula will be printed. A name for each column’s total will be prompted for.

TS - TOTAL LINE

    Total line with output suppressed.

TEXT OR ACCOUNT NUMBER

For A type lines, enter the Chart of Accounts ID. If you wish to use a description
other than the one in the Chart of Accounts file, type it in after the ID using a ; to
separate. This text will only be used in a GLDESC output column. ie:
01.01.1000;BANK AMOUNT

For NI type lines, the text will be used in the GLDESC output column like the
A type lines.

    All other line types will appear as entered. The text will be printed from left to
    right starting at the first print position.

    On P type lines, the text will be printed before the output is paged.

    In all text lines, some special codes are allowed. They must be separated from each
    other and the normal text by semi-colons (;). The codes insert data into the text. The
    codes are:

T Time, the current system time as HH:MMPM.
D Date, the current system date as /web/YY.
ID Input Date, from input when statement is run.
P Page number.
SPn Number of pages, i.e.: SP5
Cn Center the line on "n" print positions, i.e.: C80

    An example of the codes follows:

T;SP25;THIS IS A HEADING;SP25;D;C132

REV

    These Sub-Value line numbers correspond to the column numbers. Enter Y
    if you wish to multiply the amount by -1 to reverse the sign at display time.

FORMAT

    Enter up to three characters. You may use the $ to print the dollar sign in front
    of the numbers output. Also, a comma (,) may be used to print the comma to
    separate 1000’s in numbers. Only one of the following alphabetic characters
    may be used:

    C causes CR to follow negative values
    D causes DR to follow positive values
    E causes negative balances to be enclosed in arrows, i.e."<1234.56>
    M causes a hyphen (-) to follow negative values
    N causes the hyphen to be suppressed
    S causes all output in this column to be suppressed.

FORMULA

    For NI type lines, enter only on the first Sub-Value line the entities to calculate net
    income, separated by semi-colons (;). Use parentheses to surround the departments
    desired. The same entities and departments will be used in all the columns. i.e.:

    01(01);02(01,02,03);03(04,05)

    Subtotal lines must be named. These lines will total all account lines and NI lines
    since the last subtotal line.
    Total lines must be named. On total lines, a formula may be specified after the name
    with an = separating them. i.e.:

TOT1=ST1+ST2+ST3