The user has imported a sales transaction through CSV import of general journals and the CSV template has no mapping for Tax Account column in the Journal which in result made the sales transaction not reflect in the Business Activity Statement Report.

It is the standard behavior in NetSuite to post the transaction in GST Paid (GST on Purchase) by default, when the user has not set the Tax Account. To resolve this, the user can do CSV import to update the Journal using a template with Tax Account mapping:

1. Navigate toSetup>Import/Export>Import CSV Records

2. In theImport Assistantpage >Step 1. Scan & Upload CSV File, kindly set the following:

-Import Type:Transactions

-Record Type:Journal Entry

- Upload the CSV file template with Tax Account column added as mapping

3. Click onNextbutton

4. InStep 2. Import Optionssection, kindly do the following:

- SelectUpdate inData Handlingfield

- Click onAdvanced Options> tickOverwrite Sublistscheckbox

Note:For updates, enable this option to cause imported sublist data to completely replace existing sublist data, instead of selectively updating or being appended. When this option is disabled, imported sublist data selectively updates keyed sublists and appends to non-keyed sublists.

5. Click onNextbutton