Financial Statement Setup

You can define your own financial statements that best suit your reporting needs. To specify the content and format of a statement, use the Financial Statement Definition form, along with the Financial Statement Definition Columns form and the Financial Statement Line Definition form.

Designing Your Financial Statement

Financial statement design consists of two major sections:

• Report Columns
• Report Totals

To design the statements, you use four major functions:

• Copying sections of reports
• Resequencing lines
• Automatically generating accounts
• Automatically setting ratio and subtotal levels

You must enter information for the report, such as:

• Headers and titles
• The columns in which to calculate and/or print amounts
• The account numbers for which amounts will be printed
• Descriptive text

You also must decide:

• Whether to print ratios, and if so, where
• When to print totals

It is best to lay out the reports on paper before attempting to define them. Remember to leave enough room to print all the desired amount and ratio columns, because the system does not perform this task automatically.

Creating Your Financial Statement

To create the financial statement:

1. Find one of the demo reports (.RDL) provided with SyteLine that is most like your current financial statement.
2. Make a copy of the .RDL with a new name.
3. In Visual Studio 2008, modify the new report as needed.

   NOTE: The financial statement templates included with SyteLine include several suppressed fields and objects. Ensure that the data you wish to display is unsuppressed. For more information about suppression, see the Visual Studio 2008 online Help.

4. In SyteLine, add a Background Task Definition to point to this new .RDL.
5. Open the Financial Statement Definition form.
6. Specify information in these required fields:
   • Report ID - Enter a unique name for your report. This value can be up to 10 characters.
   • Analytical - Select this field if this report should be pulled from a separate analytical ledger.
   • Task Name - Fill in the task name of the background task you defined in Step 4, above.
7. Click the Columns button.
8. Complete the header definition on the Financial Statement Definition Columns form.
9. After you have defined the header and columns, save and return to the Financial Statement Definition form.
10. To open the Financial Statement Line Definition form, click Lines.
11. Define the statement lines.
12. After you have defined a statement, you can print it by specifying the Report ID in the Financial Statement Output form.

Related Topics

General Ledger Overview

General Ledger Steps

Keywords, Financial Reports