Recipient Created Tax Invoice - Calculate withholding tax and GST
I am a New Zealand sole trader and contractor for a company. I submit a timesheet, and they generate a IRD approved Buyer Created Invoice. They send me my payment with GST added, and witholding tax deducted.
There is no accurate way to extract the witholding tax from the final amount deposited to my account.
There is a hacky way, detailed here:
https://www.laurenson.co.nz/2017/09/accounting-for-the-tax-withheld/
But because Xero doesn't hold a high enough number of decimal places in the percentage field, the amounts are inaccurate by some cents each time. Which over the course of a year increases to a reasonable error.
I do not have to generate an invoice out of Xero for these payments.
What we need is a way of acknowledging that witholding payments have been deducted, and work back accurately to the original amount.
This way of receiving payment is pretty common here in New Zealand, and I daresay other countries like Australia.
I don't know if this may need some form of automatic invoice to be created, as a stand in for an actual invoice I send out. If it did, then some way of having that generate quickly and pretty automatically would be great.
As a note, as part of their process, I do get sent their Buyer Created Invoice in my email, so if that could be read in, as an invoice from my side, then that would probably be a good solution, since it provides all the amounts, in precise detail....
Thanks
-
Freya Pieroz commented
In Australia, the equivalent of a Buyer Created Invoice is a Recipient Created Tax Invoice (RCTI) and we are also required to withhold tax from payments to suppliers if they have not supplied us with an ABN (so we can't verify that they're registered or not) and we're paying more than AU$75 as per the rules from the ATO, but we are also required to provide the supplier with a Payment Summary detailing how much PAYG tax has been withheld: