Quarterly sales/PST/GST totals

We need the totals of the following to fill out our sales tax submittal forms:

PST – on sales

GST – on sales

HST – os Sales

PST – on purchases

GST -on purchases

HST – on Sales

Sales

In order to do this:

1 – Look up the chart of accounts

2 – Find PST/GST/sales needed(sales is under the income section)

3 – click on view ledger

4 – set the beginning and ending months required for that period

5 – look at the bottom of the rows and you will see the total for that period, for tax/sales amount needed.

There is a second, simpler way to get the numbers for the sales:

Sales register

Once you see the register, scroll to the bottom of the list, and then scroll to the right. All totals will be there.

https://erpnext.eco2.ca/app/query-report/Sales%20Register

purchase register is here:

https://erpnext.eco2.ca/app/query-report/Purchase%20Register

New way to calculate. The best way so far: There are times where you enter expenses and sales after the period is ended, and they are not reflected in the actual period.

Do the same as for the first method for each of the sales taxes, and look at the bottom for:

Closing(Opening and Total)

Opening – opening balance at beginning of the period

Total – total at the end of the chosen period

The difference is what you owe(a positive balance) or what you can claim(a negative balance)

These means no more trying to add and subtract to find gthe balance of each sales tax

Quarterly sales/PST/GST totals

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to top