Rounding sales tax problem

majohnboymajohnboy Member Posts: 7

Hi,

I need to invoice somebody for $306.25 + $30.62 sales tax = $336.87. This is because I have the booking agreement already where the client has rounded the 0.5 cent sales tax down.

However, with wave apps, the sales tax is automatically entered in using the 10% calculation.
When I enter $306.25 (ex tax), the tax is automatically calculated at $30.63. This = $336.88.

If I change my total (ex tax) I cannot make it land on $336.87. eg. I change to $306.24 (ex tax), then my tax is calculated to be $30.62. Total = $336.86.

This means that when I get paid I am going to have a transaction that doesn't match my invoice. Is there any way I can solve this problem?

Thanks!!!!

Comments

  • AlexiaAlexia Administrator Posts: 3,315 admin

    Hi @majohnboy.

    The rounding rules in Wave cannot be changed. Your taxes will always be rounded to the nearest cent. You could modify the invoice and add an item called "Rounding adjustment" for an amount of - $0.01, which would bring down the total amount of the invoice and wouldn't have to be affected by a tax.

    With that said, I would strongly recommend talking to an accountant about the laws surrounding rounding in your country.

  • awaycottawaycott Member Posts: 5

    @Alexia, it appears to me that the rounding rules aren't doing what you said above. Example:

    1212.37 * 15% = 181.8555

    Wave is rounding that to 181.85 when it should be 181.86

  • AlexiaAlexia Administrator Posts: 3,315 admin

    Hi @awaycott.

    I just tested it on my end and it seems to work fine. Can you try it again and share a screenshot? Mine looks like this

    Can you tell me what currency you're using?

  • awaycottawaycott Member Posts: 5

    @alexia, sorry about that. My problem is on a Bill, not an invoice. Try it there.

    I just tested this further. In my case (on a bill), I actually have 2 lines:

    Line 1 is $1035.00
    Line 2 is $177.37

    If I enter a single item for $1,212.37 I get the correct tax calculated @ 181.86.

    However, if I enter the 2 above:

    • the first item calculates tax correctly as $155.25
    • second line calculates incorrectly as $26.60 ($26.6055 should round up to $26.61)

    Hope that is more clear.

    Currency is Canadian Dollars.

    edited April 4, 2018
  • AlexiaAlexia Administrator Posts: 3,315 admin

    Hi @awaycott.

    It's also looking fine for me from the Bills page.

    Could you send me a few screenshots of the process on your end? Just so we can better document what's happening.

  • YellowMachineYellowMachine Member Posts: 1

    Hi Alexia,

    The problem occurs when you have multiple items on the invoice and probably on various other forms (bills and etc.).

    Example:
    Item 1 : 100.05 (taxes rounded to 10.01 => real taxe 10.005)
    Item 2 : 100.05 (taxes rounded to 10.01 => real taxe 10.005)
    Total : 200.10 (addition of the rounded taxes to result 20.02 instead of 20.01)

  • AlexiaAlexia Administrator Posts: 3,315 admin

    Hi, @YellowMachine.

    Wave always calculates taxes per item, not based on the total taxable amount. This isn't an issue with Wave, but a deliberate choice. It's generally considered to be the better way to calculate sales tax on an invoice and is favoured in most countries.

  • cunningacunninga Member Posts: 1

    I am from Canada and process many invoices in my job and I have never seen an invoice where the tax is calculated in this fashion. This also causes problems on the other end as well for the people that are paying the bills. When the invoice is entered into accounts payable, the software won't accurately calculate the tax paid and it will have to be overridden. Its really unfortunate that there is no option to let the user decide how the tax is treated as I am now considering switching over to another accounting software simply because of this issue.

  • AlexiaAlexia Administrator Posts: 3,315 admin

    Hi, @cunninga.

    Thank you for your feedback on this subject.

    While there is no way around that in our software at this time, you could simply to add/discount item on the invoice for $0.01 to match the amounts on your bills and mark it as an adjustment entry for the time being.

  • HillyHilly Member Posts: 3

    Hi Alexa, is there an option to use taxed amount straight away? E.g. the amount of $115 included a tax of 15%, how can I enter the full amount of $115 to the invoice without needing to manually calculating back to the net amount, i.e. $100? At the moment I have to do it manually all the time and it takes unnecessary time and effort. Your support is highly appreciated.

  • AlexiaAlexia Administrator Posts: 3,315 admin

    Hi, @Hilly,

    Not on invoices, no. Taxes are never calculated backwards on invoices, they have to be added on top the price for each of your line items. You can set those line items to be linked to taxes by default on the "Products and Services" page, however. That might help out, depending on your pricing structure.

  • MathieuMathieu Member Posts: 2

    @cunninga said:
    I am from Canada and process many invoices in my job and I have never seen an invoice where the tax is calculated in this fashion. This also causes problems on the other end as well for the people that are paying the bills. When the invoice is entered into accounts payable, the software won't accurately calculate the tax paid and it will have to be overridden. Its really unfortunate that there is no option to let the user decide how the tax is treated as I am now considering switching over to another accounting software simply because of this issue.

    I am in the same situation here. Also from Canada, one of my client was never paying the "real amount" of my invoice... a few cents less all the time. At first I was just thinking they made a mistake (xxxx.85$ instead of xxxx.89$), but after a few invoice I checked a bit further and realized my totals were not correct, from our way of calculating it at least. I most of the time have many lines in my invoices (15+) and it's bad to always have to calculate the real total and adjust. And then after it's on the total of sales tax collected that the problem will also arise... a few dollars at the end of the year. Not a big deal regarding the amounts... but very bad in accounting books.

    Anyway, I get the point where it may be a better way (accounting point-of-view) to calculate it, but no matter if it is, it's not how it's done here and it makes the process just not as easy as it should be. So I will join my voice with cunninga user above and request that to be an option we can choose, as it's really causing pain in my accounting here.

    Thanks.

  • JamieDJamieD Administrator Posts: 675 admin

    Hi @Mathieu. Thanks again for giving your feedback on this particular issue, I've made sure that your voice is heard on resolving this for our future rollouts. We understand that this can be tedious (in terms of the workaround, creating a separate transaction etc) -- but want to make sure we carefully determine what is causing the problem and how to fix it to align with our code. Again, I appreciate the input and hopefully we have a resolve for this in the future.

  • ArletteDArletteD Member Posts: 2

    I would like to know if this issue was resolved. I am in the Netherlands and I have the same issue. My books sells for 17.50 including tax. This 17.50 cannot be changed by law and is the price given to customers. But in Wave I cannot enter the price including tax (on an invoice e.g.), I first have to enter the amount excluding tax. The system then adds the 9% value added tax. But whatever amount I enter, I can never get to 17.50. It is either 17.49 or 17.51.
    REading the above, I assume there is no way to correct this (without adding another line of one cent, which just does not work for my invoices/customers), but can you please confirm?
    I just do not understand this. I used Eazysoft for a while and it had the option to include or exclude the tax when you enter the price of on an invoice. Thank you.

  • alexlewiszarkosalexlewiszarkos Administrator Posts: 232 admin

    Hi @ArletteD . Are you invoicing your customers and receiving processed payments through Stripe, or are you receiving payment outside of Stripe and manually marking your invoices as paid?

  • ArletteDArletteD Member Posts: 2
    Hi @alexlewiszarkos
    , I do not use Stripe. It is all manual.
    edited March 8, 2019
  • Siobhan_HitchmoughSiobhan_Hitchmough Administrator Posts: 10 admin

    Hi @ArletteD thanks for getting back to us about this! It helps to know that you're handling this manually (as that means it's not impacting your payments directly). However, as you've pointed out, this makes invoicing your customers more difficult. Further to Jamie's comments above, we're taking note of all the feedback that's shared. As rounding is a bit different for everyone, understanding the impact to your business is key. I can definitely see why this is frustrating and if there are any changes to how we're handling this going forward we'll follow up here. Thank you for your honesty and taking the time to share your experience with us.

    edited March 14, 2019
  • ZeaferZeafer Member Posts: 2

    @Alexia said:
    The rounding rules in Wave cannot be changed. Your taxes will always be rounded to the nearest cent. You could modify the invoice and add an item called "Rounding adjustment" for an amount of - $0.01, which would bring down the total amount of the invoice and wouldn't have to be affected by a tax.

    With that said, I would strongly recommend talking to an accountant about the laws surrounding rounding in your country.

    Hi. I would like to confirm that in Australia, where an amount of GST includes a fraction of a cent, special rounding rules apply. These are quite complicated, but are in place to allow Total Sales to have the 10% Goods & Sales Tax component included correctly, while still allowing even figures.

    For example, a total sale of $60, including 10% GST should be charged as $54.55 ex-tax + $5.45 GST - in this case the GST is rounded down, because it is calculated as 1/11th of the total, not as 10% of the ex-tax amount.

    The rules are explained in detail on the Australian Taxation Office web site under the heading, Rounding of GST here:
    https://www.ato.gov.au/business/gst/tax-invoices/

    The GST Tax Invoice should not include a "rounding" adjustment, as the Sales Tax amount needs to be displayed and charged correctly. The correct rounding is also needed for Business Activity Statement reporting, which is most often done quarterly by SMBs in Australia.

  • Ryan_WRyan_W Administrator Posts: 460 admin

    @Zeafer thanks for clarifying all of that; this is good to know as we continue to refine the way Wave handles these calculations. I can't guarantee that we can make changes that are this granular, simply because Wave's a global product and everyones' needs differ based on location. That said, this is still incredibly useful information. Thank you!

  • ZeaferZeafer Member Posts: 2

    @Ryan_W said:
    @Zeafer thanks for clarifying all of that; this is good to know as we continue to refine the way Wave handles these calculations. I can't guarantee that we can make changes that are this granular, simply because Wave's a global product and everyones' needs differ based on location. That said, this is still incredibly useful information. Thank you!

    The workaround I have used in other systems, is to set the GST Sales Tax at 9.9999%. This results in the correct rounding every time - but displays 9.9999 on the Invoices. If the displayed amount could be rounded, while the calculated amount is accurate, this would suffice. Even just the ability to display the Tax NAME only, and not the % amount would be sufficient. Perhaps the option to hide the Sales Tax % from the invoices would be easy to implement.

Sign In or Register to comment.