Sales transactions need to be imported into Netsuite, through journal entries generated to be imported from another system. Now, the sales transactions (which are a journal entry actually) need to be connected with specific tax codes so tax reports etc. will work properly. The issue is that the journal entry requires a debit and credit balance. So I wanted to a journal of a sale of 10$, where one line is credit 10$ and the other debit 8$ + a tax code which would total the row to 10$. But the system wont let me, it does not recognize the amount of the tax code to balance the journal. Is there any way around this?

Have you considered that the tax line is it’s own journal line? Have a look at the GL Impact of a sales order with tax.

you should be able to do journals with a tax code and tax amount (fields are available on the csv import template). The journal has to balance at the Gross Amt. level (and it creates the tax line automatically). I'm not sure if you can override the tax amount, but I assume you can as you can't always guarantee tax calcs balance to the cent from one system to another

Netsuite Tragic: Right now that it the only way forward I can imagine, but then reports which pick up sales tax on tax code level wont recognize the tax, since it is a debit or credit line which itself will not have a tax code?

I do like Jons method but I haven’t investigated. For reports use the Tax GL account as the criteria which is the way I see it in Au taxes. Might be specific to your nexus.

see screenshot. This is a valid journal because even though the debit and credit amounts don't balance, the gross amt does

@Jon Kears thanks for the screenshot. The accounts I have don't have the tax/vat field on journals. Good to see the end result is the same though.

@Jon Kears Thanks for this, I am testing this out as we speak.