17- GST, HST Reports & Remittance

Set up Tax Tables with Split Taxes

Hi everyone.

Recently I was asked how to set up tax table with split taxes.

ex: 5% GST (2.5% and 2.5%)

if you have man suppliers or customers with this type to of tax splitting you can set it up in the tax section.

if not I will show you how to enter it at the time of posting the invoice.

This tutorial will be in the classic mode as shown below.


Sage 50 Home Screen

From the top menu choose Setup – Settings – Company – Sales Taxes.

This is where you should be.

Settings Taxes

From here chose Tax Codes below.

in this screen you will record all the tax code you have followed by a description.

you can also choose to see the tax code in a specified journal. either payable or receivable.


Settings Taxes codes

No click on Taxes below.

here you will issue the codes a relative account number. one for payables and one for receivables.

Settings Taxes with accts

Now that we are familiar with the Taxes and Taxes Code screen.

lets go back to Taxes Code screen and choose the GS Tax Split in order to give it a percentage for calculate.

Tax Code Details Do the same for the SG code and press OK.


Now lets test the taxes created.

Go to purchase journal, choose a vendor and test the tax codes.

Purchase journal with split taxes


Now lets look at an entry with the tax codes not set up.

Purchase journal with split taxes 2


Hope this tutorial helped.

if you have other questions please drop me a note.





Be the first to comment - What do you think?

GST Tax Table Setup

How to set up tax table in Sage 50

from home screen drop down Setup menu – Settings – Company – Sales Taxes.


First, lets click on taxes.

Settings TaxesIn the Tax colum you can give unique tax names.

Ex: GST, HST, PST depending on the province.

indicate the account number that will be tracking this tax.

For payables account description “GST on Purchases”

and receivables account description ” GST on Sales”

These two accounts should already be setup in the chart of accounts in the liability section.


account 2410   Description  “GST on Purchases”   ( for type choose the subgroup account)

account 2420   Description  “GST onSales”    (for type choose the subgroup account again)

Account 2430   Description  “Net GST Remit / Refund”    (for type choose subgroup total)

now, lets click on Tax Code

Settings Tax CodesThe code section is designated for your taxable goods.

ex: GS   and in the description section type:  GSTon Sales

GP and in the description section type:  GSTon Purchases

GV – and in the description section type:  GST on Vehicle – if you are a company that uses a percentage of the vehicle for business and rest for personal than you have to take a percentage of GST as well. do not claim the full amount of GST when the vehicle is being used fa portion of time.

GM – and in the description section type:  GST on Meals – Themeals are expenses at 50% so the GST has been claimed at 50%.

in the USE In Colum – indicate if its for Venor purchases or sales receivable.


Now lets click on the first code “G”

Tax Code DetailIn the tax colum you will put GST or PST, the name of the tax.

Status is Taxable

Rate is 5% or other rate depending on the provice

Included in price will be “yes” if its for tracking vendor taxes

it will be “No” if its for tracking sales tax

Is refundable will be “Yes” for GST and will be “No” for PST

Hope this helped with setting up tax tables.

Please send me note if you need further explanation.



2 comments - What do you think?

Next Page »