Report
Realization SuggestionThe Reporting Library widely depends from the Project Specifications and Account Schema. The BFC Application, by default, provides only the following Reports leaving to the Project Team the ownership of its realization.
> Balance Sheet
> Profit and Loss
> Cash Flow
The Reports above are available as much as Group Reports and Local Reports. These latter are available in the Local Reporting Capsule.
Report
Realization Suggestion
Reporting Account
The Reporting Account is a grouping criteria that sits on the top of the Group Account and that facilitates the realization of Statutory Schema by regulation driven.
Additional Reporting Account dimensions can be added on demand if multiple schemas must be implemented.
This Grouping Criteria doesn't influence the Consolidation Logics and Process. It can be held for pure reporting purposes. If the Group Chart of Account already matches with the Reporting Needs the usage of the Reporting Account is of course not mandatory.
The following logics must be implemented :
> Code and Description : Load or Insert proper Code and Description for all the Accounts
> Relationships with the Group Accounts : Load or Insert proper relationship between n Group Account and one Reporting Account. This can be done in the Account Grouping Screen
> Row Format Template : please refer to Board Help On Line , how to Format Row Items. You can use the Reporting Account Template (that is provided empty but already setup in the default report).
> Account Rule Visualization Order : it can be done with a proper Coding (Order by Code option) or using a Sort By info-cube (S Reporting Account Order by).
> Account Rule : Account items rule must be provided for calculated items. You can use the Reporting Account Rule (that is provided empty but already setup in the default report).
Reporting Rules
The following best practices must be adopted :
| Dimension | Screen Selection | Pager No All |
| Scenario | Dynamic
F [Open - Closed] or
Dynamic F [Open - Archived] |
Y |
| Month | Dynamic
F [Open - Closed] or
Dynamic F [Open - Archived] |
Y |
| Consolidation Node | Exclude Conso Node = 99 | Y |
| Movement | on
P&L Report Select CLOsing only
on BS Report Select Exclude CLOsing only |
N |
| Layer | Select
L13 only or
Exclude Layer 13 only (row total) |
N |
If such rules are not properly used the Reports is potentially false. Selections on all the other dimensions can be multiple and depends from the nature of the report.
The Following Reports are Available
| Screen | Short Description | Select | Pager | by Column | by Row |
| 100-01 Balance Sheet | Balance Sheet Report | Month
: Dynamic Selection (open - Archived)
Scenario : Dynamic Selection (open - Archived) Consolidation Node : Exclude 99 Statement : 01 Balance Sheet Movement : 01 Closing Balance Layer : from L09 (Proportionalization) to L13 (Total) |
Month
Scenario Consolidation Node |
Layer | Account |
| 100-02 Income Statement | Profit and Loss Report | Month
: Dynamic Selection (open - Archived)
Scenario : Dynamic Selection (open - Archived) Consolidation Node : Exclude 99 Statement : 04 Income Statement Movement : 01 Closing Balance Layer : from L09 (Proportionalization) to L13 (Total) |
Month
Scenario Consolidation Node |
Layer | Account |
| 100-03 Cash Flow | Cash Flow Report (1) | Month
: Dynamic Selection (open - Archived)
Scenario : Dynamic Selection (open - Archived) Consolidation Node : Exclude 99 Layer : L13 (Total) |
Month
Scenario Consolidation Node |
Layer | Cash Flow Account |
| 100-04 Statutory Reporting | Statutory Report (1) | Month
: Dynamic Selection (open - Archived)
Scenario : Dynamic Selection (open - Archived) Consolidation Node : Exclude 99 Layer : L13 (Total) |
Month
Scenario Consolidation Node |
none | Reporting Account |
(1) All the Reports are immediately actualized after the execution of the Consolidation Process but the Cash Flow Report. To actualize this you must click the Gear Icon .