Create country-specific reports

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 Settings tab.

Then click on Report Transformations

And click 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:

  • VAT amount collected
  • VAT amount paid
  • Net VAT payable

We make the report with 3 lines, one for each figure and we name the report VAT Return.

Let’s create this report and View it.

The report shows no figures yet but it’s good start.

So how do we get our figures in? We use Reporting Categories.

Reporting Categories

Reporting categories have only one purpose. And that is provide figures for our reporting transformations. Go to Settings tab, then click on Reporting Categories.

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:

  • VAT collected
  • VAT paid

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 VAT collected.

Now when we use this tax code in a transaction.

And then view our VAT Return

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.

Edit 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.

Publishing

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 Published.

This will make the report available under Reports tab.

And when they create new report, they will see only fields that are relevant.

Final words

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.

Get Involved
Subscribe to Updates

Subscribe to our newsletter and get exclusive product updates you won't find anywhere else straight to your inbox.

© 2022 — Based in Sydney, Australia but providing goodness globally