Reverse Charged Tax Code - Tax Summary vs Tax Transactions Report

@WZM, you have made a confusing series of posts:

  • Post #10 shows a Tax Summary for a time period ending August 7th. That was before the reverse charge scheme changed. Based on your later posts, it is not clear which version of the program generated this report.
  • Post #11 is only a fragment of a General Ledger Transactions report. It is impossible to know what this should show, as purchase invoice #2 was not illustrated.
  • Post #13 compares Tax Summary reports from two versions of the program. But they are also for different date ranges.
  • Post #15 says you started over by emptying an existing test business and double-checked all tax codes. But you did not illustrate your age 19% tax code from this business. You only illustrated it from a different business in Post #10.
  • Post #15 shows the Summary from a test business with no transactions after you said you entered two purchase invoices. You appear to have hidden zero-balance accounts, making it impossible to know how this test business is set up.
  • Post #15 shows a fragment of a General Ledger Transactions report, again making it impossible to know what has happened.

To tell what is going on, it will be necessary for you to post the following screen shots from the new test business:

  • Edit screen for your igE 19% tax code
  • Edit screen for the purchase invoice for the EU supplier
  • Summary showing all accounts
  • General Ledger Transactions report for all accounts

@Tut

screenshots as requested
Summary showing all accounts

@Tut

second set of screenshots

Edit screen for your igE 19% tax code
Edit screen for the purchase invoice for the EU supplier
General Ledger Transactions report for all accounts

@WZM, are you absolutely certain everything you have shown from your new test business is using version 20.8.67? I have duplicated equivalent entries in a test business and do not get the same results you do. Your results only seem to be available from versions before 20.8.65.

@tut, I can confirm, that I used ver 20.8.67.

I suspect something to be corrupted in the Tax Code settings
I erased again all transactions from this business and also
deleted the Reverse Charge Tax Code igE 19% and created
a new one with the same settings, created a new purchase invoice
and applied the Reverse Charge Tax Code igE 19%.
General Ledger Transaction and Tax Summary reports show ok now.

I still have this test business file on another pc running ver 20.8.63.
created a backup, imported it into manager on another computer
running ver 20.8.67. does not work.

would you like to have this file for further investigation ?

just thought of the problems if something like this happens with
a business file, that has hundreds or even thousends of transactions

regards

@WZM any chance I could see the file where it doesn’t work? You can send it to lubos@manager.io.

@WZM the issue fixed in the latest version (20.8.71)

1 Like

Is it possible to download a copy of desktop manager before version (20.8.65)? Since this new update, my sales figures don’t match anymore and the Tax Transaction report and Tax Summary report are not showing accurate information

@chrissyzmissy, you need to specify what version you are referring to as “this new update.” How and what don’t your sales figures match. How are the reports not accurate?

For example, before version 20.8.65, my tax summary report for June-2020 would show my sales/purchases and taxes as below

but when I pull the same report after the update of 20.8.65 the report shows as below which is not correct and the same happens for all previous months.

In January-2020, I had a transaction report saved which showed totals as below

but when I pull the same report after update, I get these totals which are incorrect

I just don’t understand why the sales/purchase and tax figures have suddenly changed with this new update.

I assume you enter “Cash” transactions via receipts/payment. Negative line items can be entered by users when

  • Entering a negative amount sales or purchase line item or
  • Entering a counter transaction ie a purchase line item on a sales document (or vis vera)

The above examples require the opposite sale / purchase assignment.
Lubos is in the process of enabling the user to specify what they actually require in each case. Hence the changes you have observed in sale / purchase but identical overall net tax liability. I believe a true solution is close now which covers invoices, receipts/payments and journal entries.

To answer your direct question, yes archived versions of the program are available. To use them you will need an archived version of your data file containing all the data you want and not converted by opening it with a later incompatible version see

For an overview of the changes and my understanding of the plans see

and

@chrissyzmissy your tax liability figures are the same between versions. It’s just how Manager decides whether tax transaction belongs to sale or purchase side. Manager is phasing out this concept since consensus among users cannot be reached. If you want to track tax on sales and tax on purchases separately, you will need two different tax codes. Tax Summary will look different in near future to reflect this.

Honestly, both your answers are a bit too complicated for my little brain. I just wanted taxes on purchases and taxes on sales to show up correctly on the transaction and summary reports as they used to because I rely on these reports to remit my monthly taxes to the government. Now since the update, everything has changed and I have taxes due on the 31st of August and have no way of calculating the correct amount to submit

I was able to revert back to version 20.8.53 where everything works fine for me again. It’s sad because I will no longer be able to take advantage of any manager updates anymore but at least I have everything working again.

I use separate tax codes for sales and purchase. As Inventory items can only have one tax code, @lubos is it possible to add a second tax field for consistency so there is one tax code for purchase side and one tax code for the sales side ?

tax code

@Tor actually forget what I wrote in the previous comment. I’m still trying to make sales / purchases work with single tax code.

See: Added ability to attach customer or supplier to any tax transaction

@chrissyzmissy try to upgrade to the latest version. You should see your figures back to normal on Tax Summary report.

Thank you so much lubos! I just upgraded to the latest version and everything is working again. Both the Tax Summary and Transaction reports are giving correct figures. Thank you so much for all the hard work you put into this program, it’s very much appreciated.

I am somewhat flabbergasted by this comment - accounting software should be designed based on accounting principles and where applicable Levy law. User consensus isn’t a consideration.

In part a few of them (users) are, as for a number of years Manager had functioned very solidity and successfully albeit the originally adopted Levy model (single code) had some short comings with a minuscule number of transactions. Then came a number of agitators, who disrupted the status quo because of their unprofessional understanding on the differentiation between financial and Levy reporting.

Unfortunately, for the other part, Manager got sucked into these agitations and started redesigning itself in various ways which has done nothing but caused confusion and conflicts and totally unsatisfactory outcomes - which should never have occurred.

Now the question you have to ask yourself, why don’t any of the other major accounting software programmes have these conflicts - because they are implemented to meet the requirements of the accounting principles and where applicable Levy Law - not user consensus.

@Brucanna I am in full agreement with you that new feature upgrades are not handled optimally and in various other posts, I have repeatedly suggested implementing a development and stable track to properly roll out new upgrades. I am hoping after the latest couple of blowouts, that he will come round to my viewpoint on this.

However, in defence of the developer, I think it is a bit harsh to say that he made these changes as a result of a small minority of “agitators” who wanted the program to change to suit their particular needs for a minuscule number of transactions. I believe that he genuinely wanted to find a way to keep Manager as simple as possible to use without introducing multiple tax codes. I believe that he thinks very hard about how he wants the program to evolve and it shows as Manager has no bloat, is simple to use, very rarely has any issues like crashing, slowness etc!

I don’t always agree with him and I very much want a proper roadmap and development and stable track introduced but I do think he genuinely cares about his product more than other developers who very often focus on what will market well, not what is best for the end user. The real problem is the way updates are rolled out with any prior feedback from users before releasing to the public domain.

I completely agree with you.

I was so disappointed at first by the new tax module upgrade. But after a couple of days of adjustments @lubos came up with a flexible and innovative way of managing taxes together with the possibility to link Customers and Suppliers to Payments and Receipts.

I think that he would have reached the same result without or, at least, with less issues and polemics if he had involved some “beta tester” for a few days.

Anyone that usually attends the forum knows the names of the users that are experienced enough to support Lubos in this kind of activity.