Report Transformations - No-code development platform

Mine is working fine.

You might want to change your transformation because now there’s no Net Sales or Net Purchase prefixes.

You will have to refer to the Reporting Categories directly.

I can provide you with a user account to test it.

maybe because you have assigned the tax codes to the in-built Tax payable account. have you tried changing it to a custom account?

There’s two problems:

The tax code hasn’t been assigned a category.

Or

You need to refer to the amount tax categories Tax rate 10% to get the tax amount

1 Like

But there’s a problem here, the component tax base cannot be assigned to different reporting categories.

this is the solution @Abeiku . i overlooked that.

no we cannot. we have to create seperate tax codes.
but Lubos said he would be working on something which would enable us to select on which forms the tax codes need to appear. so the number of tax codes will not be an issue i think.

How could I have missed that :laughing:

1 Like

we are all on the same boat :sweat_smile: there is just too much data to process that we do miss the small things right before our eyes. but it is fine as long as we can get it to work finally.

2 Likes

@Abeiku @sharpdrivetek but still, I noticed that you can’t show the tax base for individual components. In order to do that, tax code categories should be per line:

@Ealfardan I don’t think that’s required. Base is the same for every tax component which is why it is on tax code level, not on tax component level.

But my understanding if the taxes are of the same category, the rates should be consolidated for e.g. GST 16%.

I though that multi-component tax codes are used when you have a single supply taxed by two different tax categories, eg.:

  1. Environmental tax
  2. Value added tax

So in the VAT return it should show a 10,000 tax base and in the environmental tax return it should again show the same 10,000 tax base, right?

That’s fine. You do not need 2 separate reporting categories for that. Just use the same reporting category on both reports.

1 Like

But then how can you apply two tax categories on a single supply?

Edit: that’s a stupid question :sweat_smile:

What I meant is that I’ve tried to use multi-component tax codes for reverse charged tax codes (since those can’t be used properly by report transformations).

So I need the second call to be negative. How can I do that?

New version (21.11.17) has been just released that allows multi-component tax codes that are reverse charged. But it doesn’t allow you specify “Reverse Charge Reporting Category” yet. That’s coming later today too.

1 Like

I’ ve missed what is the reporting category, I cannot find something about this!!!
Please expalin

Instead of being a custom field dropdown menu item, tax line items now have a life of their own as Reporting Categories.

It should be noted though that each reporting category should for either sales or purchases, but not both – for the most part.

I don’t understand. Can you explain please?
You mean that I have to create for example two VAT, one for sales and one for purchases, although these are the same percentage??
An if yes, then which one I will use in the Inventory Items tab, in the field Tax code, the one for sales, or the one for purchases?
What means
“Tax Codes” and “Tax Amount”, in the picture below?

Tax codes are the net sales, or net purchase and Tax Amount the VAT amount for sales or purchases?
Names are a bit confusing!!

Instead of creating a drop down menu with say:

  • VAT 5%
  • VAT 0%
  • VAT Exempt

You create Tax Code Categories of:

  • VAT 5% - Sales
  • VAT 0% - Sales
  • VAT Exempt - Sales
  • VAT 5% - Purchases
  • VAT 0% - Purchases
  • VAT Exempt - Purchases

This will take care of all tax base reporting, but not tax amounts.

For tax amounts you create Tax Amount Categories of:

  • VAT 5% - Sales
  • VAT 5% - Purchases

Because these are the only two categories with actual tax amounts.

Later on you need to assign your tax codes and tax rates to one or more of these categories like this:

In this example:

  • The Tax Base in Report Transformations can be called by directly selecting Intra in the cell – instead of the previous Net Sales - Intra or Net Purchases - Intra.

  • The tax amounts can be called by selecting either of Intra CGST or Intra SGST, or both – instead of the previous Tax on Sales - Intra CGST or Tax on Purchases - Intra SGST.

I think the new updates of tax rates and reports, should be discussed in more detail with all the necessary information for this new implementation. From a first look, I hope the task didn’t become more complicated to use.