Report Transformations - No-code development platform

[Patch]

@Davide

How can we make calculations based on the data we get from Report Transformations.

@eko

would you consider to include at least some basic arithmetic operations rather than automatic additions of the selected figures?

To do that the Report Transformation environment would need the capability to Name / reference prior results not just Figures predefined in the report development environment. Enabling such functionality would require a slightly different approach to Report Transformation - No-code development platform. Such as discussed here, where the “Figures” definition is exposed and names given to “Figures” could be subsequently used in other parts of the Report transformation.

@Patch

creating an interface analogous to a spread sheet with a formula entry bar

I strongly support the addition of this capacity as it would enable inclusion of rounding consistent with individual countries tax authorities requirements. Such as

@Patch

For example in an annual tax return to the ATO

• income subgroups are rounded down (floor)
• total income must be the sum of the rounded values
• expense subgroups can be rounded up (ceiling)
• total expenses must be the sum of the rounded values.
• net taxable income must be income total minus the expenses total. Which typically differs from the same calculation done to 1 cent precision by multiple dollars.
• in a trust the after tax profit is the distributed, the amount available for distribution varying if a different amount if tax is actually paid.

In summary for submissions to a tax authority rounding requires

• specification of rounding method of sub values (floor, ceiling, or rounded)
• addition / subtraction of intermediate values

Similarly the ATO GST Worksheet also specifies rounding down of all intermediate values Complete your BAS | Australian Taxation Office

@Patch

rounding is inconsistent with the ATO requirements https://www.ato.gov.au/WorkArea/DownloadAsset.aspx?id=59740

Note
Calculation of returns with rounding would also enable calculation of a “Rounding adjustment” to deduct from the “GST/VAT Payable” account when GST/VAT is paid in accordance with a countries tax authorities rounding requirements.