Discussions
Vendor invoice CSV import with custom tax
Hello Guru's,
I have created a CSV import for our employee credit card statements. The import works great and is very quick and easy for everyone. The one issue I have run into is with the tax.....
In Canada, we have a GST of 5% on everything except for essential groceries and other random things. When it comes to the accounting side, we can only claim 50% of the GST on entertainment or dining. I can't simply have a tax code in NetSuite that takes everything into account.
The easiest thing I have been able to come up with is for the cardholder that is doing the expenses, to enter the GST from the receipt into a field on a data entry page. They also select the Expense Category, and if it is entertainment, the GST will be reduced by 50% and the difference added back to the subtotal.