how do I create GST worksheet in excel

[Niek Otten]

What is a GST worksheet?
Please explain what you're trying to do

 

[Ed Ferrero]

Hi jl,

Sounds like Goods and Services Tax. Are you Australian?

GST is calculated as 10% of sales.
So if you quote a price inclusive of GST, the GST is =price/11

As in;

Total Price $110
Includes $10 GST

So, what do you want the worksheet to do?

Ed Ferrero
http://edferrero.m6.net/

 

[jl]

Hi Ed,
Thanks for your response. I am Canadian and we also have Goods &
Services Tax. I' m a real estate agent collecting GST on my sales, trying to
set up an income & expense sheet and get GST as a spinoff for my reporting
requirements with year to date totals for my personal annual income tax
return.

John Lavin

 

[Ed Ferrero]

Hi John,

I have a workbook that does this (developed for my own personal use).
I will send it to you if you email me personally. Be warned, it is somewhat
sketchy in instructions, but it follows the methods described in
http://edferrero.m6.net/DataTutor01.shtml

Ed Ferrero
http://edferrero.m6.net/

 

[jl]

Hi Ed,
Thanks for your offer. Sending you an email from my website.

John Lavin
www.johnlavin.ca

 

[Kathy]

Hi Ed,
Thanks for your response. I am Canadian and we also have Goods &
Services Tax. I' m a real estate agent collecting GST on my sales, trying to
set up an income & expense sheet and get GST as a spinoff for my reporting
requirements with year to date totals for my personal annual income tax
return.

John Lavin

 

[Norm Talbot]

Hi Ed,

I too require such a template. Please advise. Thanks.