Report Transformations - No-code development platform

  • Go to Reports → Profit and Loss Statement → New Report
  • Set title to something like “Profit and Loss Statement - BAS 2020 / 2021”
  • Set Description to something like “BAS 2020 / 2021”
  • Create a column for each quarter, with a column names “BAS Q1”, “BAS Q2”, “BAS Q3”, “BAS Q4”
  • Set the From & to date for each BAS quarter
  • Set the Accounting method based on how you submit your records to the ATO
  • At the start of each financial year clone this report and update the final year digit by 1 for each date.

When doing you BAS view this report.

  • Your profit / loss for the quarter will be listed at the bottom. If you have more complicated accounts such as a sole trader with some no tax deductible items recorded in Manager or a business with income tax allowance then you would have created a “Taxable income” total and you would use that instead.

  • Multiple this figure by 30% to get your PAYG tax withheld

By the way, when looking at your annual tax return to the ATO

  • Go to Reports → Profit and Loss Statement → New Report
  • Create a report identical to above except enter financial years for each comparator period

May I suggest to take inspiration from Matabase? It has a very simple no-code interface that can be turned in a low-code interface if needed.

1 Like

For me code is absolutely necessary. No code environment only works when you have some control over the structure of the data. But when you don’t, code can easily compensate for that.

An interface like Metabase can replace both Custom Reports and Report Transformation.

Does what work, @annalivan? This topic has covered several related issues. You need to be specific on the forum.

Thanks @lubos for this new function. How we can type a plain text into fields just like built-in VAT Return Form?

@alosultan just start plain text with " character which will create text value. You can see plain text in autocomplete fields is wrapped in " character.

1 Like

Thanks :pray:

I would like to prepare a Report Transformation for the VAT Return of Trading Details report used in Ireland

As you can see, this report has 5 columns and a number of rows - the rows represent different rates of VAT (Exempt, 0% Export, 0% Home,4.8, 5.6, 9, 13.5, 21, 23, …)

Would it be possible to increase the Report Transformation Layout to from 3 columns to 5 columns?

1 Like

@Joe91 your requirements are a lot less compared to the requirements of users from India. we require a minimum of 11 to 12 columns even for monthly filing reports. have a look at an example below just for reporting the sales details.

2 Likes

Yes, we do not have to supply details of invoices - presumably we have a higher rate of tax compliance :slight_smile:

1 Like

@lubos can you please remove the limit on number of columns.
for me this is the limiting factor to even try creating any local reports currently (possibly users of other countries too).

How many columns do you need? I can see @Joe91 requesting 5. Is that enough?

i am afraid that would be a lot less for our country.
my earlier post below.

there are many reports for us with varying number of columns. the issue is that it may change from time to time. so i cannot give you a definite number at present.

is there any complications with development to provide more than a pre-defined number of columns? i was hoping we could have something similar to image where users can add any number of columns as required.

@sharpdrivetek the report you are creating is listing invoices. Is that correct? Currently report transformation is not able to enumerate through invoices but it can be added.

But if you have like 1000s of invoices? This could be very long report.

yes. the example i provided was for the monthly sales report we need to submit where details of every invoice is submitted.

you are correct but that is what we are required to provide unfortunately.
anyway our government does provide an offline tool where we can bulk import these details. so i was hoping we could create a report in the defined format in Manager and this could be imported to the said offline tool.

Yes. It can all be done. I will add ability to enumerate through invoices so you can create invoice-based report. Then once you have that working and all that is needed are more columns. That can be added too and the report will be fully functional.

3 Likes

thank you. this could be the first stepping stone to our localized reports.

Version 21.11.15.

Report transformation is not picking up tax code values set under Reporting Categories, am I the only one facing this?

did you assign the tax components to the new Tax Amount category?

read below.