Skip to content
← Share and support customer ideas for Xero

Settings and activity

1 result found

  1. Bills | NZ - Manually adjust GST for each line

    24 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    18 comments  ·  Purchase orders, bills & inventory » Bills  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    In development  ·  AdminKelly Munro (Community Manager, Xero) responded

    Hi everyone, thanks for continued engagement here. We understand the needs expressed in being able to accurately reflect the supplier invoice you've received.

    We're in the process of releasing a new bills experience for the bill edit and view screens, which is currently being rolled out to organisations.

    When entering bills using tax-exclusive amounts, you’ll be able to adjust the GST on individual lines in the Tax amount column to help resolve rounding differences and match your supplier invoice totals.

    Thank you for continuing to share your feedback and I'll come back to confirm when this has been released to all NZ organisations.

    Andrew Joll supported this idea  · 
    An error occurred while saving the comment
    Andrew Joll commented  · 

    I posted here a couple of years ago. I'm not sure if Xero even read this, but thought I'd re-iterate in case it has gotten lost in the noise.

    The issue appears to be that Xero stores a GST-inclusive amount for each line, but it is rounding on each line instead of considering the total of each invoice.

    There is a way around this - Accredo similarly store exclusive and GST for each line of an invoice, shipment (bill) or whatever, but they calculate it by totalling the exclusive amount and GST of the lines so far by GST code, then taking the difference between the GST on previous lines of that code and that's the GST on the line.

    Easier to show with an example. In the attached, you'll see the first line is $37.50, GST is $5.63. The next line is another $37.50, so Accredo uses the total of $75, GST at 15% is $11.25, to $11.25 - $5.63 = $5.62.

    You'll see the GST amount flipping back and forth between $5.62 and $5.63, and the total at the end is $335.50 plus 15% GST = $385.82. In Xero that would likely be $0.05 out.

    Obviously Accredo is significantly higher price and more complexity than Xero, but it would be nice if Xero could at least get the basics right, and this is a way to do it while still having an inclusive line amount.