Revised: 10/25/2012
Go to Maintain>>Column Specifications
This is step two of setting up a financial statement. This program will set the type of information in each column and applies special filters.
See Also:
Enter a new code to begin setting up a new column specification, or enter / select an existing code to edit.
This code is used in the financial statement master with a template code.
Enter a description for the Column Specification you are setting up. This description will not be seen on the financial statement.
Select one of the following types:
Balance Sheet
Cash Flow Statement (The template master to associate with this column specification should be set to balance sheet)
Profit and Loss
Note:
These types are important and will effect how data shows in the statement. Select the type that matches the type of accounts that are included in your template.
This area is used to specify what information will print in the columns on the financial statement, headings for each column, delete a column, insert column(s) and perform calculations.
You may assign or edit the information for any column.
When you are first entering a new column this field will begin with the number one in it. The column numbers will auto increment every time you save or tab through all the fields.
To pull up an existing column number, please enter or select the column number you wish to edit.
Type in a label for the column to reflect the information you are pulling into it. This is what will show above the column to identify the contents on the financial statement.
Select one of the following types (they may not be in exactly this order):
Alternate Tracking 1
Alternate Tracking 2
Annual Budget (Original)
Annual Budget (Working)
Blank Column
Blank Column with Underline
Calculates a ratio of selected accounts
Column Calculation
Current Actual - use only with Profit and Loss accounts, do not use with Balance sheet accounts
Current Actual (1 Year Ago) - use only with Profit and Loss accounts, do not use on statements with Balance sheet accounts
Current Actual (2 Years Ago) - use only with Profit and Loss accounts, do not use on statements with Balance sheet accounts
Current Actual (2 Periods Ago) through Current Actual (11 Periods Ago) - use only with Profit and Loss accounts, do not use on statements with Balance sheet accounts
Current Actual (Last Period) - use only with Profit and Loss accounts, do not use on statements with Balance sheet accounts
Current Budget - use only with Profit and Loss accounts, do not use on statements with Balance sheet accounts
Encumbrance
Page Break command
Performs a calculation based on information entered
Ratio Calculation
Special Period 01 (Actual) through Special Period 24 (Actual)
Special Period 01 (Budget) through Special Period 24 (Budget)
Year to Date (1 Year Ago) - may be used on any statement, This is the recommended column type to be used on balance sheets instead of Current Actual
Year to Date (2 Years Ago) - may be used on any statement, This is the recommended column type to be used on balance sheets instead of Current Actual
Year to Date Actual - may be used on any statement, This is the recommended column type to be used on balance sheets instead of Current Actual
Year to Date Budget - may be used on any statement, This is the recommended column type to be used on balance sheets instead of Current Actual
YTD (2 Periods Ago) through YTD (6 Periods) - may be used on any statement, This is the recommended column type to be used on balance sheets instead of Current Actual
YTD (Last Period) - may be used on any statement, This is the recommended column type to be used on balance sheets instead of Current Actual
Enter a width amount. Try 400 or 500 to start and adjust if needed.
Enter the number of segments, usually "1" unless you are doing a balance sheet and then it may be "2" or "3". For a balance sheet there is usually only one column that is divided into 2 or 3 segments. The OS column on the worksheet may contain a number 1, 2 or 3 (if you entered a 3 for segments) to identify which segment the information or totals need to go in to.
Enter the number of decimal places for this column. A "2" would mean that amounts would be displayed as 000.00.
If the column type is one that allows calculations, such as Column Calculation then special calculations may be done in this area, such as adding columns together. Please call the horizon help desk for additional assistance with this if needed.
For example:
C4+C5
The amount of column 4 will be added to column 5 and the total will be displayed in this column.
Other Expressions:
For PUM calculations: column #/[PUMM or PUMY(area#,community#)] NOTE: DEFINE must be setup on the first line of the template with the formula entered in the description area.
Used for budget variance columns so that all variances will show as a positive number if good and a negative number if bad.
You may enter or select filtering information (a portion of your GL account number) to filter account information.
Press this button to renumber the columns. Renumbering may be needed if a column was deleted or inserted.
This information goes with the Insert Columns button. Enter the column number to begin inserting columns.
This information ties to the Insert Columns button. Enter the column number to stop inserting columns.
Press this button after entering information in the starting column and ending column field. The number of columns inserted depends upon the starting and ending column information you entered.