Bills - Manually adjust VAT for each line
Ability to edit VAT line by line on bills in order to agree balances to supplier invoices (Due to rounding issues)
Hey community, thanks for all your support on this idea.
Tax adjustment functionality varies by region, as this idea was raised relating to adjusting VAT in the UK I'm popping in to switch it across to delivered!
To adjust the tax amount for a line item when creating a bill:
- Select the Tax exclusive option in the Amounts are field
- Click the + symbol next to the Tax Rate heading to show the Tax amount field.
- Edit the amount shown in the Tax Amount box.
Our Adjust the VAT amount on unpaid transactions support article provides further information on this process.
We have ideas for this similar option in the AU version here, and another for NZ here that you can follow for updates. For other regions, you’re welcome to create a new idea so we can gauge user need for this.
-
Storme Smith commented
Not ideal as we would prefer it to calculate correctly but this helped us. Hopefully it helps someone else.
-
Marciana Nathan commented
Maybe option to override/manually enter GST amounts?
-
Lisa Lenne commented
I can't believe we have to vote to get an Accounting program to account for GST or taxes correctly. Agree with all comments here. Unprofessional and a fundamental error!
-
Melissa Johnson commented
GST is being calculated incorrectly due to this. This is a fundamental error and should be fixed please.
-
milly carmichael commented
it takes twice the time to do separate lines for GST in/out, and also muck around getting the GST to be what it is on the bill sometimes. it will be correct for one part then incorrect according to the bill in another part. other programs have this facility, so feel the annoyance more as i am used to be able to adjust it. thanks
-
Steph Joines commented
This is incredibly frustrating 😤, this is making the invoices showing on Xero vat incorrect, and then in turn the payments through the bank won't match. I don't mind the vat adjustment box, it's the rounding's box that then appears to that needs to go, it puts the vat correction back in and therefore the invoice details are incorrect. I need to know how I can correct, everything I've tried so far doesn't work and to not be able to speak to anyone at Xero is even more frustrating. We should be able to call and deal with the problems as and when they arise! Also, the email I had back commented on the difference being in cents, which is not our currency!
-
Caroline Kemp commented
Can you not add an option to do line by line or calculate GST on invoice subtotal. This does not work for us.
-
David Ledsam commented
We shouldn't need to adjust with a separate line item in the invoice or as part of the reconciliation. The invoice needs to be accurate and professional when created. The rounding error is incredibly frustrating and appears very unprofessional.
-
Aaron OConnell commented
Just use the figures I entered into the system - no need to recalculate them??
-
Aaron OConnell commented
the issue for me is that I entered an exact amount - because this is what I was charged and paid (and more importantly - what cost I can invoice to my customer) BUT then XERO takes the figure and manipulates it by taking off VAT/GST and then adding VAT/GST back again - to arrive at another figure. And my customer questions the amount - because it is different to the receipts I provided (by 1 cent).
Going thru line by line to make the adjustments back to the figure I entered is time consuming (I need to find out where the discrepancies are)
Need a fix please
-
Andrew Joll commented
I've just struck this in a conversion from MYOB where I had to go invoice by invoice adding GST adjustments to make the thing balance.
There are two possible fixes - MYOB's method is just to calculate GST on the total of each code, but that would cause issues if Xero insists on GST on each line. Accredo's method is possibly more appropriate - they work out the running total of the exclusive and GST amounts (per code) on each line, then when calculating GST they use the GST on this running total, less GST included on each prior line, to get the current line's GST. Hard to picture that so I've attached a screenshot where you'll see the 15% GST on $27.50 flipping between $4.13 and $4.12 on each line. With Xero the same invoice would come out to $126.52, instead of $110 + 15% = $126.50.
-
Suzanne Hitchen commented
highly important - we deal with state government and they refuse to accept anything that is not exact - its not acceptable to need to edit a xero invoice in a PDF editing program before you can send it to your client
-
Cheryl Posthouwer commented
Especially important when line items are assigned to clients. Xero's own subscription invoices definitely need to be rethought.
-
Tricia Ainsworth commented
...or why doesn't Xero keep all the decimal places (while only showing tenths and hundredths place) for individual lines and round on the total?
-
Helen Kelly commented
However in Australia we call this GST
-
Andrew McDougall commented
Also important for invoices where line item tax calculations lead to rounding errors on total tax cost