The pinnacle of localizations are country-specific reports to make reporting easier.
Generic reports can be cumbersome to extract the exact figures that tax authority expects the business to lodge.
Report transformations allow to create custom country-specific reports.
This makes it easier for businesses around the world because Manager is able to generate the exact report with the exact figures the business needs.
To create new country-specific report for your country, go to
Then click on
New Report Transformation button.
You will be presented a form.
Let’s come up with very basic country-specific report and call it
VAT Return. This report requires us to report:
We make the report with 3 lines, one for each figure and we name the report
Let’s create this report and
The report shows no figures yet but it’s good start.
So how do we get our figures in? We use
Reporting categories have only one purpose. And that is provide figures for our reporting transformations. Go to
Settings tab, then click on
You will see a few sections but for the purpose of our exercise. We only need two reporting categories under
Tax Amount section.
So create two reporting categories:
Now, we can go back to our
Report Transformation a select these reporting categories in the second column.
Notice that in the third line for
Net VAT payable we select both
VAT collected and
VAT paid because this figure represents sum of both reporting categories.
Now view the updated report.
We see zeroes. Good progress but the report won’t be showing anything but zeroes yet. Even though we have created reporting categories, they are not linked to anything.
We need to link our reporting categories to tax codes. Let’s create our first tax code called
VAT 20% on Sales like this.
Pay attention to
Reporting Category field where we selected
VAT collected. What this means is that we want tax amount of this tax code be categorized under
Now when we use this tax code in a transaction.
And then view our
We see how this tax amount of
200 is flowing into our report. Why is the amount of
VAT Return negative? Sales are credits. And credits are negative. Manager doesn’t know that in this context
VAT amount collected amount should have its sign reversed. But it can be easily improved.
VAT Return and select
Reverse signs from dropdown where the sign should be reversed.
Then view the report again.
You can now create tax code for purchases, assign it
VAT paid reporting category, use the tax code in transaction and see how it will all come together.
Businesses using your country-specific report are not going to be exposed to your reporting categories and report transformations.
When your report transformation is done, you can mark it as
This will make the report available under
And when they create new report, they will see only fields that are relevant.
This basic example is demonstrating mechanics how country-specific reports are created within Manager. It’s important you master these basics before diving into more complex scenarios.