Welcome! If you're on this page, you may have come from the SST Guide - September 2018 article.
If you don't have a lot of experience working with spreadsheets, this article is for you.
This support article will be wholly focused on bulk changing your tax exclusive pricing in your BackOffice to be SST-compliant.
Flashback: The full "Make sure my business is SST compliant steps" can be accessed here.
Bulk update product price list to be SST tax exclusive (existing price -6%)
Just to recap - following the steps here will cause the prices of your selected products to be slashed by 6% so you can retain your pre-SST prices after Sep 1.
Not sure what we mean? Read this.
Open the SST CSV template by clicking here.
Make a copy of the SST CSV template, since you will be needing it to edit.
Click File > Make a Copy to save it to your Google Drive.
Important: Kindly use Google Sheets to complete these steps.
If this is your first time with Google Sheets, head over to https://www.google.com/sheets/about/ which, as of January 2018, looks like this:
Click on the Go To Google Sheets button in the middle of the screen. You’ll be prompted to login:
Kindly use your Google email ID to login and access the Google Sheet. (You will need to create a new ID you do not have one yet).
After you have logged in, you will be able to view your Google Drive. Simply click on the link above to Open the SST CSV template in Google Sheets.
Next, open up your Exported Products CSV
(as mentioned in Step 3 of "No, my business IS NOT eligible for Service Tax" in the original guide.)
Next, let's open Sheet 1 in the copy of the SST CSV Template that you saved.
Copy all data from the Exported Products CSV. (Don't miss out a single cell; make sure you copy all data).
Paste that data into SST CSV Template's Sheet 1.
In Sheet 1, change the tax codes in the 'Tax' column, accordingly. Ensure the tax name you've created matches exactly ('sales tax' or 'service tax').
Before you proceed, please make sure you remove your Quantity, Warning Stock Level, and Ideal Stock Level columns from Sheet 1.
The Barcode Column should immediately be followed by the Supplier Column.
We have set up a formula in Sheet 2 to do the following:
* If your tax on an item is 'sales tax', your current prices will be divided by 1.1.
*If your tax on item is 'service tax', your current prices will be divided by 1.06.
Check Sheet 2 to see the automatic changes to your pricing.
Finally, export (only) Sheet 2 as a CSV file.
Do this by viewing Sheet 2, go to File > Download as > Comma-separated values, .csv
WARNING: Only do this on 31 August after you have closed your last shift for the day.
Upload the newly exported CSV file to your BackOffice > Products > Manage Products > Import CSV.
Go to your BackOffice > Settings > Stores > Choose your store > You will see a new field called SST ID and key in your SST ID.
Don't edit or change the existing GST ID. After that, Save.
If you do charge Service Charge, make sure you are not collecting any additional tax on top of your Service Tax.
In BackOffice > Settings > Account > Scroll down to Service Charge and ensure at Service Charge Tax, you select None.
Finally, you can change the Tax Name on Receipt.
Go to your BackOffice > Settings > Receipt Templates > Choose your usual Receipt Template and then untick the Tax Name on Receipt checkbox. Don't forget to Save.
Note: Once the SST Submission Report format is finalised, StoreHub will make this available so you can export it from your BackOffice in time for November 2018.
You're done! Just have a check to see if your prices have updated accordingly in the BackOffice :