I wish to write off a Bad Debt, and we’re using the UK edition and the original invoice has VAT.
I’ve read and tried SuiteAnswers 64438 and although that will process things in the Trial Balance, it does not get into the UK VAT report. We’re using the older International Tax Reports SuiteApp.
Values only get into the Tax Return if they have a Tax Code.
If I try to enter the 3 lines on a journal, each with a Tax code then NetSuite generates 6 lines, with lines 4-6 each being 20% of lines 1-3. These lines are wrong.
If I enter 3 lines on the journal without any tax codes, then nothing gets into the UK VAT return.
If I try to enter a Tax code on only one of the original 3 lines, then Netsuite auto-calcs a Vat amount on that one line, and refuses to save my journal, giving me the Error “Transaction was not in balance”.
If I try to enter a Tax code on just the Gross amount, and I let Netsuite auto-calc the Tax amount, and then I choose a Tax Control account on that same Journal line, and then I enter only one more line on the journal, for the Net amount, then Netsuite again gives me Error “Transaction was not in balance”.
What is the correct method to create a journal to write off a Bad Debt and for it to also be recorded in the Var Report please?