Version 2022.3.0 brought an improvement in the form of a rounding method selection. Prior to this version, individual report rows were rounded. Now you can choose how you want the statement to be rounded.
Balance Sheet Rounding
The balance sheet is generated in the usual way via the menu Accounting - Accounting Outputs - Balance Sheet. To be able to select a rounding method, you must choose to recalculate the balance sheet:
If you have not defined the rows yet, you need to define them first — see Generating the Balance Sheet (example).
On the next tab you will find new fields. Once you check rounding to units or whole thousands, the rounding method becomes available, with the following options:
By rows — the entire balance sheet row is rounded
By synthetic accounts — the entire synthetic account is rounded, e.g. 211
By analytical accounts — each analytical account is rounded individually, e.g. 211001, 211002, 211003....
The choice of rounding method is entirely up to you. After setting the period and rounding options, click Calculate. When rounding to whole thousands, a rounding error may occur. This is because assets must always equal liabilities, and after rounding this may no longer be the case. Flexi will therefore prompt you to add the rounding difference to a specific row:
Typically, you select the row where the rounding difference is "least noticeable" — for example, a row with a high turnover. You must also make sure not to select a liabilities row when the positive difference is on the assets side. In that case, you must select a row from assets. If you select the wrong row, Flexi will not allow you to proceed and will display an error message:
Select a different row, and if everything else checks out, the balance sheet report will be generated.
Profit and Loss Statement Rounding
The procedure for the Profit and Loss Statement report is almost identical. This report is also found in the menu Accounting - Accounting Outputs - Profit and Loss Statement. Again, you need to recalculate the report in order to configure rounding, and again you define rows for accounts that may theoretically appear in multiple places within the report.
Rounding can be configured in the same way as for the balance sheet — here too you can choose to round by rows, synthetic accounts, or analytical accounts:
If you added a rounding difference on the balance sheet report, a similar message will most likely appear on the profit and loss statement as well:
Again, you must select the correct row to which the difference should be added — for example, the Net Income row. A detailed example of generating the profit and loss statement can be found here.