|
Posted to microsoft.public.excel.newusers
|
|
|
how do I create GST worksheet in excel
"jl" wrote:
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" wrote:
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/
|