Skip to main content

Custom reports

How the Accounting Report Generator Calculates, and a Description of All Fields on the Report Card and Its Lines

Written by Lenka Haringerová

Accounting reports in ABRA Flexi – the balance sheet, the profit and loss statement, the cash flow statement, and reports you create yourself – are built in the general report generator. This article explains how the generator calculates, and describes all fields on the report card and its rows. It is useful when you are building your own statement or looking for the reason why a particular row does not add up.

💡 In brief

A report consists of rows. A regular row is filled from account balances or turnovers according to a rule, while a total row adds up other rows according to a summation. Standard reports defined by legislation cannot be modified – you create your own report by copying one of them or from scratch.

For a step-by-step procedure (copying a report, setting up rows, manual values, printing), see the guide List of Reports. Reports can also be calculated via the REST API – see Accounting Reports in the API.


Where to find reports

In the desktop application, open the menu Accounting → List of Reports. The list contains two kinds of reports:

Type

Description

Modifications

Standard

Reports defined by legislation (balance sheet, profit and loss statement, cash flow). They are linked to the legislation table.

Cannot be changed. The user only chooses the placement of accounts that have more than one possible row.

Custom

A report you create yourself – by copying a standard report or from scratch.

The header, rows, rules, and summations are fully editable.

⚠️ Calculate your custom report in the List of Reports. The menu Accounting → Accounting Outputs contains only standard reports (Balance Sheet, Profit and Loss Statement). A custom report is not offered there.


How the report generator calculates

Each report is a form made up of four parts. During calculation, ABRA Flexi goes through the rows from top to bottom and fills them with values for the selected period.

Part

What it determines

Where to find it

Report rows

The structure of the statement – the row number, designation, and name.

Report Rows panel on the report card

Standard rule

Which synthetic accounts (e.g., 311) belong to which row and column.

Standard Rule tab of the row

Custom rule

The final placement of analytical accounts (e.g., 311001) in rows. This is what the report is actually calculated from.

Custom Rule tab of the row

Summation

Which rows are added into a total row (subtotals, Assets, Liabilities, profit or loss).

Summations in Reports tab of the row

The custom rule is created from the standard one: for each synthetic account in the standard rule, all of its analytical accounts are looked up in the chart of accounts and entered into the custom rule with the same placement.

An account with multiple possible rows. Some synthetic accounts have more than one placement in the standard rule – for example, account 311 Receivables can belong among both short-term and long-term receivables. For such an account, you must decide when creating the chart of accounts where its analytical accounts belong. This does not apply to accounts that are automatically assigned to assets or liabilities based on their balance.


Example: the Profit report

We will create a report with three rows: costs (accounts 501 Material consumption and 521 Payroll costs), revenues (601 Revenue from own products and 602 Revenue from services), and profit as their difference.

Procedure:

  1. In the List of Reports, create a report called Profit (type General).

  2. Create three rows: 1 – Costs, 2 – Revenues, 3 – Profit.

  3. In the custom rule of row 1, add analytical accounts 501 and 521 with the calculation method Turnover for the period.

  4. In row 2, add accounts 601 and 602 with the calculation method Turnover for the period and select Reverse sign – revenue accounts have turnover on the Credit side, so they would otherwise come out negative.

  5. In the summation of row 3, add row 2 and row 1 with Reverse sign selected.

  6. Click the Calculate Report button. Row 3 will show revenues minus costs.

Standard reports are built on the same principle – they just have dozens of rows and summations on several levels.


Report card

The report card contains a header (the basic panel and report properties) and, in the lower part, a panel with rows.

Basic panel

Field

Description

Report abbreviation

Unique report code.

Report type

Balance sheet, Income statement, CashFlow, or General. A custom report can only have the type General.

Calculate previous period

When selected, values for the specified period are calculated into columns 1–3 and values for the same period of the previous year into columns 4–6.

Name – Name C

Required field, max. 255 characters. Names A–C are used for foreign languages – see the article on foreign-language names in code lists.

Organization type

Selection from the list of organization types. Not available for custom reports.

Columns 1–6

The Columns 1–3 and Columns 4–6 tabs define the six numeric columns of the report. For each column, you enter a name in the home language and in languages A–C, and by selecting Show column you determine whether the column appears in the window and on the printed report. The meaning of the columns is based on the balance sheet:

Column

Meaning

1

Gross – gross account balances

2

Adjustment – balances of adjustment accounts (accumulated depreciation, allowances)

3

Net = Gross + Adjustment

4

Gross, previous period

5

Adjustment, previous period

6

Net, previous period = column 4 + column 5

The standard balance sheet needs all six columns for its calculation, but it displays only columns 1, 2, 3, and 6. The standard income statement needs only columns 1 (current period) and 4 (previous period).

Field

Description

Column 3 is the sum of columns 1 and 2

Selected for the balance sheet: column 1 contains gross values, column 2 adjustments, and column 3 their sum.

Column 6 is the sum of columns 4 and 5

The same for the previous period.

Add a row from another report

This tab is used to take over a value from another report. Typically, the result from the income statement is added to the balance sheet row Profit or loss for the current accounting period.

Field

Description

Target row

The row of the current report to which the value is added.

Source report

The report from which the value is read.

Source row

The row of the source report whose value is added.

⚠️ Copying both the balance sheet and the income statement? Check that the copy of the balance sheet adds the result from your copy of the income statement, not from the standard income statement. Otherwise, changes to the income statement will not be reflected in the balance sheet.

Administration and Texts

On the Administration tab, you can limit the validity of the report to a range of accounting periods using the Valid from and Valid to fields. Outside this range, the report is not displayed in the list. Empty fields mean unlimited validity; the same period in both fields limits the report to a single period. Validity is tied to the accounting period, so it also works with a non-calendar fiscal year.

The Texts tab contains the free-form fields Description and Note – for example, to let other users know what the report is for.


Generating the rule and calculating the report

The report card has two buttons that run the generator's calculation logic:

Button

What it does

Generate custom rule from standard rule

Goes through the rows of the standard rule and, for all analytical accounts of the given synthetic account, creates custom rule rows with the same column and calculation method. If a synthetic account appears in the standard rule more than once, its first occurrence is used.

Calculate report

Asks for the range of periods (months), for example 04–06, and whether to calculate for the whole company or only for selected cost centers. Account turnovers are broken down by cost center; when calculating for the whole company, the turnovers of all cost centers are summed.

After adding an analytical account to the chart of accounts, run the generation of the custom rule again; otherwise, the new account will not be included in the report. For a detailed calculation procedure for standard statements, see the generation examples for the balance sheet and the profit and loss statement.


Report rows

The Report Rows panel in the lower part of the card represents the report form itself. Each row has several tabs.

Report Rows tab

Field

Description

Row number

Rows in the report are sorted by this number.

Designation

Row designation according to legislation (e.g., B.II.1.).

Name – Name C

Required field, max. 255 characters.

Description, Note

Free-form texts on the Texts tab.

Breakdown of report rows by account

During calculation, this table records which accounts and which values a row is made up of – one record with values 1–6 is created for each account. The breakdown is the fastest way to find out why a row does not add up. You can print the same information using the Report Rows (Breakdown by Account) report.

Standard report rule

The standard placement of synthetic accounts in rows. For standard reports, the table is read-only for users – only service support can change it.

Field

Description

Synthetic account number

If an account has more than one possible placement, it is repeated in the rule multiple times.

Account type

Asset or Liability. Used only for the standard balance sheet; not available for custom reports.

Report column number

1–3 when the previous-period calculation is enabled, otherwise 1–6.

Calculation method

How the account value is calculated – see Calculation methods.

Reverse sign

The program reverses the sign of the result.

Consider positive values only

The program does not include a negative result.

Custom report rule

The final placement of analytical accounts in rows. For standard reports, the table is created automatically and the user does not change it – the user only decides for accounts with multiple possible placements. For custom reports, you can edit it freely. It contains the same fields as the standard rule, except that instead of a synthetic account you enter the analytical account number.

Summations in reports

The rule for total rows – subtotals and final totals (Assets and Liabilities in the balance sheet, profit or loss in the income statement).

Field

Description

Add row

The report row whose value is added to the total.

Reverse sign

The value of the added row is subtracted.


Calculation methods

The calculation method determines how the value for a row is calculated from the account turnovers for the specified period. Turnover is always calculated as Debit − Credit.

Calculation method

Calculation

Use

Account balance at the beginning of the period

Debit − Credit turnover of month "00" (opening balances) + Debit − Credit turnovers before the first month of the calculated period

balance sheet, general report, cash flow

Turnover for the period

Sum of Debit − Credit turnovers in the calculated period

income statement, general report, cash flow

Account balance at the end of the period

Balance at the beginning of the period + turnover for the period

balance sheet, general report, cash flow

Debit turnover for the period

Sum of Debit turnovers in the calculated period

general report, cash flow

Credit turnover for the period

Sum of Credit turnovers in the calculated period

general report, cash flow

⚠️ Liability and revenue accounts come out negative. They have a balance or turnover on the Credit side, so Debit − Credit is negative. To make them display as positive in the report, select Reverse sign for them.


Most common errors

When a report does not add up, start with this table:

Symptom

Cause

Solution

A standard report cannot be edited

Standard reports are defined by legislation.

Create a copy of the report and edit it – see List of Reports.

A custom report is not in Accounting Outputs

Accounting Outputs offer only standard reports.

Calculate your custom report in the List of Reports.

A new analytical account is missing from the report

The custom rule was created before the account was added.

Run Generate custom rule from standard rule, or add the account manually.

A row has the opposite sign

The account has a balance or turnover on the Credit side.

Select Reverse sign in the rule or in the summation.

Profit or loss in the balance sheet does not match

The copy of the balance sheet adds the result from the standard income statement.

Correct the source report on the Add a row from another report tab.

A row cannot be assigned

The account has multiple placements in the standard rule.

Choose the placement of analytical accounts in the custom rule.


Frequently asked questions

Can I edit the standard balance sheet or income statement?

No. For security reasons, for standard reports you can change only the placement of accounts with multiple possible rows. For your own structure, create a copy.

How do I calculate a report for just one cost center?

After clicking the Calculate Report button, select a list of cost centers instead of the whole company.

How do I compare a report with the previous year?

In the basic panel, select Calculate previous period, and on the Columns 4–6 tab, enable the display of the relevant columns.

How do I find out which accounts a row is made up of?

After the calculation, open the row and look at the Breakdown of report rows by account tab, or print the Report Rows (Breakdown by Account) report.

Can I generate a custom report via the API?

Yes, both calculation and export of a report are available via the REST API – see the article Accounting Reports in the API.

Did this answer your question?