Sage50 Simply Accounting Record GST Payable

Hi,

I think there is some confusion around GST / HST and how to get the appropriate reports and record the liability to Revenue Canada.

Here is a tutorial on how I figured it out. I think it’s the easiest way to do it if you don’t want to use Sage 50 tax function. I like to get the GST general ledger report myself so I am sure the proper amount is being paid.

for this tutorial I will be in classic mode of Sage 50. this is the home screen.

Record GST Payable 1From the Reports menu click on financials – Transactions by Account or General ledger (depending on the version of Sage 50 you have)

Record GST Payable 2

I Have some important fields circled. From the top, you can set this report as a template and give it a name. Make sure the fiscal year and the dates are within the time that you need. Mine is January to march 2015 the first quarter of GST. Some companies have yearly or monthly GST but for our purpase this is a quarterly GST remittance. pick your GST accounts and click on date. your report will be in date format and you dont want to see corrections. Click Ok.

Record GST Payable 3

 

This is your report. Make sure the balance forward is zero. in this example both GST accounts start off with a zero balance once the previous balance is recorded. Always choose the total in the balance colum to pay. this way if you make adjustments after remitting GST to Receiver General you can capture it in the next GST quarter as part of the balance colum.

You also need to report net sales. Bring up an Income Statement report by dropping down the Reports menu – financials and income statement. Make sure your date reflects the January to March GST quarter and click ok.

Record GST Payable 4Now you know what the GST collected on sales is, the GST paid on purchases as well as net sales for the quarter. Open the purchase journal and bring up the Receiver General vendor. We need to record the liability.

 

Record GST Payable 5Here is how the purchase journal should be recorded. the entry should be as pay later. the invoice number should reflect the GST quarter for future reference and the date should be the last day of the GST quarter. record the net salesĀ in description and the tricky part is to make sure to put a negative beside the amount for GST on Purchases. The net liability to Receiver General is $11,181.82.

Hope this tutorial helped. If you a question or comment I would be happy to hear from you.