Bahrain

We don’t really. It’s just to hold the reverse sign reverse charged taxable amount just so I can figure out where the difference in totals is coming from.

But that will be gone once that’s sorted out.

I just checked Ireland localization and it seems like the entire issue was about the tax amount and not the taxable amount. So I guess I have some explaining to do here:

Here’s a sample of the tax return without reverse signing the RCM Tax codes:

The first column adds up. However the RCM codes are negative.

In the tax return form, we can only enter taxable amounts and the tax portal will calculate the tax amounts for. This creates two problems

  1. The VAT/I - RCM must be added to item 1. The tax portal expects us to input 300 for item 1 (100 VAT+200 RCM) to get the correct 15 tax amount. But it’s not possible at the moment.

  2. if I keep the VAT/I - Domestic RCM in it’s own cell and reverse the sign, the totals will not add up anymore.

I’m not sure why not… are you sure you are using realistic transactions? When I click on your Standard rated sales figure, I see purchase invoice transaction in there.

Shouldn’t you use sales transactions for sales-related tax codes?

Reverse charged rates only apply to purchases.

The reverse charge is when you create input (purchase) VAT charge and an output (sales) VAT charge on a VAT free purchase transaction.

This way if you have say 20% exempt supplies, and you have imported a service from abroad for 100. You have this effect going on for the RCM transaction.

Tax item Tax w/o RCM Tax w/RCM
Taxable amounts
Output 0 100
Input 0 100
Tax amounts
Output 0 5
Input 0 -5
Apportiontment 20% of input VAT 0 1
Net tax liability on import 0 1

Note that apportionment only affects input VAT claimed.

In simpler terms, it’s the government’s way of saying if you import something and it skips being charged VAT at customs you will have to pay the full VAT (output vat) of it and claim back only a part of it (input vat less apportionment).

It’s highly advisable that the Localization to be divided into phases:

Phase 1:
Apply and fix those issues that were already applied and implemented.

Phase 2:
Any future requirements to be consider once we perfected the phase 1.

Currently the dilemma is how to get the VAT Returns working from top to bottom based on the current VAT rules and regulations, since the next VAT Returns over our head Dec 31, 2021 (4th Qtr). Therefore the focus to fix the Net VAT Due or Claim, once we have the confidence that phase 1 is completed than we can work to complete phase 2, the RCM and other systems GCC Intra VAT etc are not even announced to be apply or not.

Note: We are advocating Manager since 2015 and applied several useful changes as part of eco-system, not good to be called as no participation without having the past knowledge….

Good work done by anyone is highly appreciable but we need to see the timing and set our priorities.

@lubos kindly let’s fix the existing report for VAT as it’s an immediate challenge. If you are applying Input and Output VAT separate than we have to convince the users about this change and may the VAT rate revise not yet confirmed though from the beginning of 2022.

What issues?

The VAT due figure was always matching the Tax summary report since day 1.

  1. The RCM was in effect starting day 1 of VAT adoption in Bahrain, however, as discussed earlier, it’s only a necessity if you have mixed taxable/exempt supplies.

  2. The unified GCC VAT though not yet implemented, you’re still expected to report GCC exports @ VAT0% separate from all other exports.

  1. Continuing to use unified tax codes for Sales and Purchases isn’t a valid option anymore. The only way to ensure conformance with tax forms is to separate those. This isn’t specific to the case of Bahrain, this is a global change.

  2. Once localizations are finished, you will be able to restrict use of codes (e.g. Input VAT 5% will not show on sales invoices, Export VAT will not show on purchase invoices, Adjustment codes will only be available in Journals, CRN and DRN and apportionment will only be available in Journals) so you will never confuse the two. No convincing is required for end users because they will eventually have a shorter more precise list will smaller room for error.

  3. You can always go to Settings > Tax Codes and make any unwanted tax codes disappear by checking this box:

I haven’t heard any requests from any Bahraini users – including yourself – regarding wanting a localization. So now that it’s already announced, suddenly it’s a matter of life and death! Sorry but I can’t follow your logic.

Finally and more importantly

I can see from your comments that you’re upset for some reason. But you can just randomly point fingers here and there because people will be quick to point out any false statements.

Instead, you need to provide a valid reason for your requests in order for it to be taken seriously. For example:

  • Did you already install Bahrain localization?
  • Did you face any problems with merging of tax codes?
  • Do you require any help whatsoever with managing the transition?

If you have any such problems please say so and everybody will be glad to offer you help. Do you?

OK, so we have reporting category VAT/I - Domestic RCM 5% which shows in row 11.

image

An then again as part of total purchases.

image

I agree with this and no problem.

My issue is that you want to show this purchase amount under Total sales too.

image

And I think this is problematic.

What I suggest is that Standard Rated Sales would simply be this.

image

And Total sales this:

image

To my knowledge, in other countries, it is not expected for reverse charged purchases to inflate your sales figures.

The total sales part can be removed entirely.

My problem is with item 1.

Item 1 should add up:

  1. VAT/O - Standard 5%
  2. VAT/I - RCM 5% – sign reversed

Because this taxable amount will be inputted into tax portal so they calculate the tax amount correctly.

For domestic RCM, there is

How come there is no field for RCM imports? Because that would solve this problem just like it’s solved with domestic RCM.

I really have no idea.

In the UAE, the entire RCM is grouped together in one line item and that’s more logical.

But here in Bahrain, domestic RCM is displayed separately and the import RCM is combined with standard rated supplies.

Just to drive home the point of not mixing up domestic and import output RCM, there’s a context help note on the former that reads:

Sales at standard rate that are made to a domestic purchaser who has the right granted by NBR (supported by a valid certificate) to apply the domestic Reverse Charge Mechanism

I found this screenshot. It doesn’t look like you can enter VAT amount in VAT on sales anywhere except for Standard rated sales. I don’t really understand why on purchase side, VAT amount for reverse charge mechanism is shown and on Sales it’s not. How does this balance out?

Also, this entire concept of submission that “You tell us your total sales” and “We tell you VAT amount” is going to cause problems due to rounding.

For example. You are reporting 100 sales 1.09 each which would have VAT 0.05 each.

Total sales is 109.00 and total VAT collected is 5.00.

Then you enter 109 sales into this form and this form will multiply 109 by 0.05 and will insist you have collected 5.45 in VAT even though you collected 5.00 only.

Actually, all the blue cells are “automatically populated” as you can see in the legend at the bottom of the screenshot. So, you really can’t enter the VAT amount anywhere except for previous period corrections.

That’s true but that’s not something that a journal entry can’t handle. I usually post it without a tax code and it would show up in the Tax Reconciliation report as other movements. I am not worried about that, though.

Yeah, I get that. But my point was that for example, in line 3 where it says Sales subject to domestic reverse charge mechanism, there isn’t even VAT amount field.

So how does it balance out in the end if reverse charged tax amounts are shown in purchases but not in sales section.

Could you enter random figures into this form into every field and then take screenshot?

That applies to all VAT submissions. There is always a difference between the rounding used but the tax authority and that used by Manager. For example in Australia cents a generally not included (the allowed rounding options varying with each form).

The ideal solution is for the Manager localisation to calculate the difference in rounding used by Manger and that used by the tax authority which can then be used when entering the payment to ensure exact clearance of holding accounts.

It doesn’t balance out

I am on it

That’s a lot of work for just fractions, wouldn’t you agree?

You can call me lazy but I would rather just write-off or write-on the difference using a journal entry and that’s all the effort I am willing to put in. :grimacing:

The suggestion is the Manager localisation tells you what the journal entry amount should be for. Journal entry or adjustment on the payment achieves the same thing. In both cased someone needs to know what amount to write-off.

1 Like

Yes, that could be very useful, I guess that is achievable using the script section of report transformations.

1 Like

Done. Here are the most relevant screenshots

Note the following:

  1. Item 1 Tax Amount is more than 5% of Taxable Sales. This is the breakdown of it:

  2. The Domestic RCM has been reverse signed in outputs, this made it impossible to reverse sign it in inputs because they have the same ID and somehow this messed something up. Please check it out.

  3. The total sales is off due to what we’ve discussed earlier. Should I just remove the total sales and total purchase amount and leave the totals showing tax amounts only?

Also,

Sales exceptions removed. I just kept a note at the bottom.

Also also,

I missed this before, but if you miss accounting RCM outputs, your apportionment becomes larger and you end up overpaying the government.

Suppose we have made 10,000 taxable sales and 10,000 exempt sales, this means that you need to apportion (write-off) 50% of your claims, that is [ 10,000 / (10,000 + 10,000) ] . Now suppose you also have 5,000 in RCM purchases, this would lower your apportionment to 40% which is [ 10,000 / (10,000 + 10,000 + 5,000) ].

The idea is that when you import you must pretend to have generated the supplies and sold it to yourself, if that makes any sense.