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
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.
@alosultan just start plain text with " character which will create text value. You can see plain text in autocomplete fields is wrapped in " character.
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?
@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.
@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).
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 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.