Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 |
#8
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() "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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |