Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I create GST worksheet in excel
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I create GST worksheet in excel
What is a GST worksheet?
Please explain what you're trying to do -- Kind regards, Niek Otten "jl" wrote in message ... |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I create GST worksheet in excel
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/ |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I create GST worksheet in excel
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/ |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I create GST worksheet in excel
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/ 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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I create GST worksheet in excel
Hi Ed,
Thanks for your offer. Sending you an email from my website. John Lavin www.johnlavin.ca "Ed Ferrero" wrote: 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/ 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 |
#7
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/ |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I create GST worksheet in excel
Hi Ed,
I too require such a template. Please advise. Thanks. -- Norm Talbot Windsor ON Canada "Ed Ferrero" wrote: 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/ 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Create a Pop window in a Excel Worksheet | Excel Discussion (Misc queries) | |||
Create invoice from Excel worksheet | Excel Discussion (Misc queries) | |||
Merging data from an excel worksheet into an excel template | Excel Worksheet Functions | |||
Need to remove a password that noone placed on Excel worksheet. | Excel Worksheet Functions |