How to calculate sales tax

In order to calculate sales tax, we have to download a spreadsheet that includes all information about the transactions in a given timeframe. Open the spreadsheet on Microsoft Excel or Google Spreadsheet and then calculate the sum of sales tax with an easy formula.

1. Click on the "Sales" button on the left navigation menu after logging into the POS system. You will be redirected to a page titled "List of All Sales".

2. Adjust the date range in the top-left corner to the timeframe in which you want to calculate sales taxes. In this example, I chose the date range from May 1st to June 8th, 2018.

3. Go to the bottom of the list, click the button "EXPORT ITEM LEVEL DATA" to download a CSV file containing the information about the transactions in a certain timeframe. The download shall start automatically.

4. Open the CSV file with Microsoft Excel or Google Spreadsheet. Scroll to the right of the table and look for the column that calls "Tax $".

Select a blank cell on the spreadsheet and type the Summation formula in the cell: "=SUM()". Inside the bracket, put the range of the data that you want to add together. This page has more information on the SUM formula: https://exceljet.net/excel-functions/excel-sum-function

5. Press "Enter" key. The sum will appear.