GL Report Design

An accounting report includes one, two or three columns (respectively called Column A, Column B and Column C).

In order to create a new report, the report code has to be entered. Then, the titles of the data and the different columns are entered. In the different titles, the following codes are to be used,

• &N : the current year,

• &N-1 : the preceding year,

• &M : the current month,

• &M-1 : the preceding month.

The column type implicitly defines the way data is used:

For the first column (Column A), one can choose:

• Month M, year N : value of the current month,

• Total 1 :M-1 year N : Total of the monthly digits between the first month and the month preceding the current one (in a given yearly period),

• Total 1 :M year N : Total of the monthly digits between the first month and the current one (in a given yearly period),

• Total 0 :M-1 year N : Total of the monthly digits between the first month and the current one (in a given yearly period),

• Total 0 :M year N : Total of the monthly digits between the opening by-law and the current one (in a given yearly period),

• Month 0 year N : value of the opening by-law

• Month M, year N-1 : value of the month preceding the current one,

• Total 1 :M year N-1 : Total of the monthly digits monthly between the first month and the current month of the preceding period,

• Total 0 :M year N-1 : Total of the monthly digits between the opening by-law and the month preceding the current one,

• End year N-1 : Total of the monthly digits between the opening by-law and the closing of the preceding year.

For the second column (Column B), one can choose

• nothing, in this case the accounting report includes a single column, or

• values estimated as in column A, or

• values estimated with a formula (Expression Col B).

For the third column (Column C), one can choose:

• nothing, in this case the accounting report includes a single column or two columns, or

• Total, in this case the value is equal to the sum of the two first columns, or

• Variance, in this case the value is equal to the difference between the first and the second column, or,

• values estimated via a formula (Expression Col C).

These options permit several financial report types. The characteristics of each line of the report are as follows.

Line Type	The line type defines the policy and the line indentation. The titles are indented on the left and the totals are indented on the right. Title 1 and Total 1 are displayed and printed in 12 pts bold characters. Title 2 and Total 2 are displayed and printed in 11 pts bold characters. Title 3 and Total 3 are displayed and printed in 10 pts bold characters. Title 4 and Total 4 are displayed and printed in 9 pts bold characters. Detail is displayed and printed in 8 pts bold characters. The line type Line displays and prints a horizontal line.
Description	The Description zone contains the text displayed in the line. The research button (at the right of the Description zone) permits one to select the description of any account type.
Condition	The drop down list Condition permits one to choose a condition for the estimated amount for the first column : None : the line will be displayed, <> 0 : the line is displayed if the first amount is different from zero, > 0 : the line is displayed if the first amount is strictly positive, >= 0 : the line is displayed if the first amount is positive, < 0 : the line is displayed if the first amount is strictly negative, <= 0 : the line is displayed if the first amount is negative.
Expr. Col A	This cell contains the formula for the computation of the first amount. One or several account numbers are indicated, with the definition of the type of amount to be considered: DA : debit amount, CA : credit amount, DB : debit balance, CB : credit balance. The formulas use the operators + or -. Example : 2 DB – 28 SD + 208000CR The formulas are validated by the Validate button.
Color	The drop down list Color permits one to choose the color for the line.
Font	The drop down list Font permits one to choose the font for the text (italics, underlined)
Expr. Col B	Formula for column B (cfr column A)
Expr. Col C	Formula for column C (cfr column A)

Note: in order to reduce the complexity of the formulas, it is useful to define total accounts.

It is possible to refer to amounts computed in preceding lines with the code LxY, with x the number of the line and Y the column number used.

A line is recorded with the OK button. A line can be deleted by the Delete button. The buttons Insert after and Insert before permits one to move the lines in the list.

The report that is entered can be displayed via the Test button.

With the Export… button it is possible to record all the financial data structure.