Calculating sales tax backwards from final price

I'm in the EU and my pricelist includes 19% VAT (sales tax).  (This is required by local law.  We cannot provide retail pricing without VAT included.  So, all prices are rounded after VAT inclusion.)  The problem:  If I enter each item with its price divided by 1.19 (to get the pre-VAT price), it almost works but the problem is the final total (due to rounding errors) is not accurate.  For example,  Product Price is EUR 125 (pre-VAT that is approximately 105.042016..., not a nice round number) Shipping cost EUR 10 (pre-VAT that is 8.40336134...)  When VAT is added for the invoice, these end up showing a total of 134.99 instead of the correct 135, because of intermediate rounding errors.  What I want to do instead:  I would like the calculation to go backwards.  That is, for the total, start from the 135 (based on the declared prices of 125 and 10 for the example given), allocate VAT [by doing 135*19/119, or price*VAT_RATE/(100+VAT_RATE)] and then do the same for each individual invoice line [calculating pre-VAT price for each item line by doing price*100/(100+VAT_RATE)]. In all cases results should be rounded to two decimal digits. That way, the totals will be correct both for each line(specially, in case of multiple units per item) and for the grand total.  Is this possible?  (I can do all the calculations and roundings by hand in advance but it's a waste of time.)Also, is there a way to tell Quicken to round on two (or four) decimal digits for each invoice line seperately?  Although, this will work a little better it still isn't as accurate as the above because when dealing with multiple units, the per unit price will be off.

Answer

tonypdmtr:You haven't made it clear which version of Quicken you are using, but it appears that you are talking about H&amp_B.I read your post yesterday and have been giving it some thought._ As you probably know, most of the users on this forum are from the United States and hence are not very familiar with tax laws or business practices in other countries._ I fall into that category and this post is going to be more of a question than a suggestion._ You stated in your post, <STRONG>"I'm in the EU and my pricelist includes 19% VAT (sales tax). (This is required by local law. We cannot provide retail pricing without VAT included. So, all prices are rounded after VAT inclusion.)"</STRONG>I can read this in one of two ways.__The first way is that your_published "Price List," must include VAT and the second way is that the "Price List" you use in Quicken H&amp_B (or any other accounting software for that matter) must include VAT.It would seems to me (based only on logic, not your local law) that as long as_your published price list included VAT that your Quicken price list could omit VAT as long as it is_added to the invoice in a similar fashion as we in the U. S. add state and local sales taxes._ If this is the case, then rounding shouldn't be a problem.As I said, this is a question._ I won't bore you with anything else until you post back._
Was this answer helpful? Yes No
Default user avatars original d5efadcf497ea7b3d86c6f8d148d66633a29ce78fa8391af628adf32d9989354
SuperUser
4 additional answers

No answers have been posted

More Actions

People come to Quicken Community for help and answers—we want to let them know that we're here to listen and share our knowledge. We do that with the style and format of our responses. Here are five guidelines:

  1. Keep it conversational. When answering questions, write like you speak. Imagine you're explaining something to a trusted friend, using simple, everyday language. Avoid jargon and technical terms when possible. When no other word will do, explain technical terms in plain English.
  2. Be clear and state the answer right up front. Ask yourself what specific information the person really needs and then provide it. Stick to the topic and avoid unnecessary details. Break information down into a numbered or bulleted list and highlight the most important details in bold.
  3. Be concise. Aim for no more than two short sentences in a paragraph, and try to keep paragraphs to two lines. A wall of text can look intimidating and many won't read it, so break it up. It's okay to link to other resources for more details, but avoid giving answers that contain little more than a link.
  4. Be a good listener. When people post very general questions, take a second to try to understand what they're really looking for. Then, provide a response that guides them to the best possible outcome.
  5. Be encouraging and positive. Look for ways to eliminate uncertainty by anticipating people's concerns. Make it apparent that we really like helping them achieve positive outcomes.

Select a file to attach:

Do you still have a question?

Ask your question to the community. Most questions get a response in about a day.

Post your question to the community
or contact us