Work with FDS Statements
FDS is a particular type of Financial Statement that uses the FS Group 4 and FS Group 5 values in GL Accounts.
FS Group 4 values are used for report line groupings
FS Group 5 values are used for column groupings
See How to Create and Modify Financial Statements for general information on how Financial Statements work.
Building the Template Master
NAVIGATION: MAINTAIN menu > Template Master
- For Housing Authorities
- Do not modify the Template Master Codes FDSH21, FDSH22 or FDSH23.
- These will be built and maintained by Horizon updates.
- For other business organizations
- You may create custom templates using an Account Mode of FDS Reporting.
- This template will use the values in the GL Account Master FS Group 4.
- See How to Work with FS Mode in Financial Statements. Build a template using these instructions as if it was FS Group 4; however, in the template Setup Information tab select FDS Reporting as the Account Mode.
Building the Column Specification Master
NAVIGATION: MAINTAIN menu > Column Specifications
See How to Create and Modify Financial Statements for general information on Column Specifications.
In an FDS statement you may customize column specifications to meet your needs. Each column may be a separate AMP/department/fund, etc. This can be accomplished using the Advanced Filtering selections found at the bottom of the Column Specification Master. There will be a selection field for each segment of your general ledger account structure. Only the first segment shown under Advanced Filtering should be used which should contain the value of the GL Account Master > FS Group 5 field.
For Example: The Template Master using FDS Reporting:
| Function | Comp | Starting Account | Ending Account | Description | OS | LF |
| AP | 10 | CASH | 1 | 1 | ||
| AP | 11 | RECEIVABLE | 1 | 1 |
In the Column Specification Master, the Advanced Filter > first segment (FUND/FDS) has the following values:
| Column 1 | Column 2 |
| 100 | 200 |
The following general ledger accounts have been setup:
| Account # | FS Group 4 | FS Group 5 | Value |
| 100-101 | 10 | 100 | 500.00 |
| 100-102 | 10 | 100 | 200.00 |
| 200-101 | 10 | 200 | 300.00 |
| 100-111 | 11 | 100 | 200.00 |
| 200-111 | 11 | 200 | 300.00 |
| 200-112 | 11 | 200 | 400.00 |
CASH: The report will find and include the accounts as listed below:
| Column 1 Account | Column 1 Amount | Column 2 Account | Column 2 Amount | |
| CASH (10) | 100-101 | 500.00 | ||
| 100-102 | 200.00 | |||
| 200-101 | 300.00 |
With the FS Groups assigned, the report will print like shown below:
| Column 1 Account | Column 1 Amount | Column 2 Account | Column 2 Amount | |
| CASH | 700.00 | 300.00 |
RECEIVABLE: The report will find and include the accounts as listed below:
| Column 1 Account | Column 1 Amount | Column 2 Account | Column 2 Amount | |
| RECEIVABLE (11) | 100-11 | 200.00 | ||
| 200-111 | 300.00 | |||
| 200-112 | 400.00 |
With the FS Groups assigned, the report will print like shown below:
| Column 1 Account | Column 1 Amount | Column 2 Account | Column 2 Amount | |
| RECEIVABLE (11) | 200.00 | 700.00 | ||
Tips
- Always test new reports by running Trial Balance reports or other Financial Statements that will contain the same data.
- You may need to combine the totals of different statements or groups of accounts from a Trial Balance to double check that the new report totals contain all of the expected accounts.
- Complete the Financial statement report by creating the report code in the Financial Statement Master.
- See How to Create and Modify Financial Statements for instructions to complete the Financial Statement Master and more details on how Financial Statements work.
4/2021