Skip to main content

Business Process

Screen Financial Reports

The layouting process of financial reports in Odoo, both for Hospitality and ERP implementation will be using the function of Invoicing > Financial Reports. The reports will be consists of cascading reports with each settings as to how the report will be displayed.

Screen Create New Reports

The function of Financial Reports settings consists of:

  1. Report Name
  2. Sequence
  3. Sign on Reports
  4. Reverse Balance Value
  5. Show Total at Bottom
  6. Label Total Bottom
  7. Total Income (as Ratio divisor)
  8. Parent
  9. Type
  10. Financial Report Style
  11. Show row data
  12. Show Border Top
  13. Show Border Bottom
  14. Is Cash Flow Initial Balance

Report Name​

The field will be the name of the report, and displayed in the report. Example:

Screen Income Statement 206

As shown in picture above, the report name is Income Statement - 206. The report will be the root parent of income statement layouting report used in Corporate Hospitality report.

Screen Account Reports Selection

Based on the selection in screen capture above, the reports displayed will be:

Screen Report Name Display

Sequence​

The field sequence will be defined the sequence of reports displaying in report if there are several reports with the same report parent. Example:

Screen Sequence Function

The report display will be sorted based on sequence. Sequence only matters when the reports having the same report parent.

Screen Report Sequence Display

Sign on Reports​

  1. Reverse Balance Sign

If the option Reverse Balance Sign selected, then the value displayed on reports will be reverse or times minus one (-1).

  1. Preverse Balance Sign

If the option Preverse Balance Sign selected, then the value displayed on reports will be displayed as is.

Reverse Balance Value​

  1. Reverse Balance Value (credit-debit)

If the option Reverse Balance Value selected, then the value displayed on reports per account or account groups will be the results of summary from the credit value minus the debit value.

  1. Preverse Balance Value (debit-credit)

If the option Preverse Balance Value selected, then the value displayed on reports per account or account groups will be the results of summary from the debit value minus the credit value.

Show Total at Bottom​

If the option checked, the report will displayed the total of row data or the summary of the child reports under the data or child reports display.

Label Total Bottom​

The field function will be enabled if the option of Show Total at Bottom checked and to differentiate the Report Name and the summary report label. If not filled while the option Show Total at Bottom checked, the label displayed in report will be using Report Name.

Total Income (as Ratio Divisor)​

If the option checked, the summary of the row data or the summary of the child reports will be the divisor of the ratio display in each row data displayed in report.

Parent​

The parent field is used to assign the reports to a parent reports. Example:

Screen Account Report

The list of reports assigned as children, will also available in the parent report as well.

Screen Children Report

Type​

  1. View

If the option View selected, the report will only be a view which could only contains child reports.

  1. Accounts

If the option Accounts selected, the reports will enable chart of accounts selection. All types and all accounts selected could be grouped into one row data in report. The selection Accounts also enable user to choose on how the data will be displayed:

  • No Detail
  • Display Children Flat
  • Display Children with Hierarchy
  1. Account Type

If the option Account Type selected, the reports will enable selection of account type available. All chart of accounts which type is selected, will be summarized into one row data in report. The selection Account Type also enable user to choose on how the data will be displayed:

  • No Detail
  • Display Children Flat
  • Display Children with Hierarchy
  1. Account Group

If the option Account Group selected, the reports will enable selection of account group available. All chart of accounts which grouped into the selected Account Group will be summarized into one row data in report. The selection Account Group also enable user to choose on how the data will be displayed:

  • No Detail
  • Display Children Flat
  • Display Children with Hierarchy
  1. Report Value

If the option Report Value selected, the reports will enable selection of Account Reports available. The total of account reports will be displayed to the row data in report.

Financial Report Style​

  1. Automatic Formatting
  2. Main Title 1 (bold, underlined)
  3. Title 2 (bold)
  4. Title 3 (bold, smaller)
  5. Normal Text
  6. Italic Text (smaller)
  7. Smallest Text

Show Row Data​

If the option checked, the report name will be displayed, and the details based on type settings. If the option unchecked, the report will not be displaying any title. Usually the option usage combined with the Show Total at Bottom function.

Show Border Top​

If the option checked, the report will be displaying a line on the above the report data. Usually the option usage combined with the Show Total at Bottom function.

Show Border Bottom​

If the option checked, the report will be displaying a line under the report data.

Is Cash Flow Initial Balance​

If the option checked, the report will be declared as cash flow beginning balance.