You can easily achieve this using Report Transformations
. The only thing you have to do is to create relevant Tax codes
and Reporting categories
. For Example, you must create a tax code for export sales and another for local sales, this will help you to capture them in the report.
Example:
To get a report like the below:
I created a report transformation that looks like this:
Yes, I know you won’t see things clearly in the screenshot above, the aim is to offer you a general sense of the tasks you need to undertake, which are quite straightforward if you are familiar with the process. There are plans to improve this report (Report Transformations
) so that you won’t have to consider opening and closing balances on VAT accounts in your calculations when making payments to the tax authorities, Manager will be able to tell you your VAT assets or liabilities at any given time. See this guide: Add support for opening and closing balances - ideas - Manager Forum
I think Custom Report should be able to easily handle this if you have set up custom fields to capture transaction information such as Release number.