Transactions from the Swag Shop are remitted to the Comerica money market account daily and should be booked in NetSuite at the end of each month, per the guidelines below.
In Shopify, download the transaction report in CSV format (found under Orders, then Export).
This report contains swag shop revenue and tax data to be recorded in NetSuite.
In Printfection, download the orders report (found under Reports, then Run a Report).
This report will be used to allocate transaction cost data between promotional, shipping, and merchandise.
In the Shopify transaction report, the amounts in column L reflect the total funds received from each order.
The total tax collected per transaction can be found in column K, with the supporting details found in columns BE-BH.
Create a journal entry in NetSuite under the GitLab Inc subsidiary, using the last day of the month as the entry date.
This journal entry has two parts- One to record the revenues and taxes, which are reported in Shopify, and the second part which includes shipping and merchandise cost information reported in Printfection.
Using the transaction report from Shopify, create line items for the revenue and various tax liabilities.
Carefully review your entries for tax liabilities to ensure they are accurately recorded under the appropriate GL accounts. * Using the orders report from Printfection, create line items for the costs of shipping and merchandise.
Click Save then proceed to final review of the entry.
The journal entry can be tested for accuracy by comparing the balances of the journal entry lines to the balances in the two reports.
Importing Swag Shop data to Avalara
Click on "Orders" in the left-hand toolbar.
Select "Export" and the desired transaction history period.
Download the report in CSV format.
Copy the required transaction data to the Avalara-Shopify template located in the Google Drive.
Save file for the remaining steps below.
Click on "Reports".
Select the "Import Data" option.
When prompted, choose the CSV import option.
Check the import status report to ensure all transactions are successfully imported.