Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
jl
 
Posts: n/a
Default how do I create GST worksheet in excel


  #2   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
Ed Ferrero
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
jl
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
Ed Ferrero
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
jl
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 144
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003, Convert EXISTING Worksheet Data to XML? [email protected] Excel Discussion (Misc queries) 4 November 16th 05 04:45 AM
Create a Pop window in a Excel Worksheet RKH Excel Discussion (Misc queries) 0 August 2nd 05 09:58 PM
Create invoice from Excel worksheet Pat Flynn Excel Discussion (Misc queries) 3 July 20th 05 01:43 AM
Merging data from an excel worksheet into an excel template pkasler Excel Worksheet Functions 1 March 13th 05 04:36 AM
Need to remove a password that noone placed on Excel worksheet. tuffy1104 Excel Worksheet Functions 2 January 2nd 05 07:12 PM


All times are GMT +1. The time now is 07:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"