Go Back  IT Forums > Software > Financial Software
User Name
Password
Reply
 
Thread Tools Search this Thread Display Modes

GST Canadian Question
  #1
Old 10-07-2006, 11:34 PM
Scraps
Junior Member


Scraps is offline
Scraps's Info
Join Date: Jul 2005
Posts: 30
Default GST Canadian Question

Entering in a receipt from Grocery store. Total of receipt is 354.17. As
most food is not taxable the total GST is only 9.14.

I use Vendor enter bills window, type in name of vender, go to account. In
this case foods, enter in tax code G for GST. The GST then shows up as
23.17. I change this manually to 9.14 then when it is recorded the amount
due goes to 340.14.

Is there a way for me to enter in this transaction to reflect the actual GST
paid.

Thanks in advance.


Reply With Quote
GST Canadian Question
  #2
Old 10-08-2006, 03:37 AM
Laura
Junior Member


Laura is offline
Laura's Info
Join Date: Feb 2005
Posts: 81
Default GST Canadian Question

"John Pippy" <scraps@warp.nfld.net> wrote in message
news:tS1Wg.2000$cz.30673@ursa-nb00s0.nbnet.nb.ca...
Quote:
Entering in a receipt from Grocery store. Total of receipt is 354.17. As most food is not taxable the total GST is only 9.14. I use Vendor enter bills window, type in name of vender, go to account. In this case foods, enter in tax code G for GST. The GST then shows up as 23.17. I change this manually to 9.14 then when it is recorded the amount due goes to 340.14. Is there a way for me to enter in this transaction to reflect the actual GST paid. Thanks in advance.


It sounds like you are putting the total amount it as taxable. Split the
details into taxable and non taxable so that the GST calculates the amount
on the taxable items only.

Reply With Quote
GST Canadian Question
  #3
Old 10-08-2006, 06:17 AM
Arno Martens
Junior Member


Arno Martens is offline
Arno Martens's Info
Join Date: Jan 2004
Posts: 30
Default GST Canadian Question

On Sun, 08 Oct 2006 07:34:49 GMT, "John Pippy" <scraps@warp.nfld.net>,
wrote:
Quote:
Entering in a receipt from Grocery store. Total of receipt is 354.17. Asmost food is not taxable the total GST is only 9.14.I use Vendor enter bills window, type in name of vender, go to account. Inthis case foods, enter in tax code G for GST. The GST then shows up as23.17. I change this manually to 9.14 then when it is recorded the amountdue goes to 340.14.Is there a way for me to enter in this transaction to reflect the actual GSTpaid.Thanks in advance.


You have one real problem and another easy one to get the above right.

Real Problem:
Your G Tax Code should have been changed as of 2006-Jul-01 from 7% to 6%
Go to List > Tax Code List > G and change the value in the GST column.

Easy solution to your question:
Enter your Bill as usual. Use tax code G, [Tab], type in FULL amount,
type a - (minus) and the amount of the GST per your receipt, then click
[Enter].
Now go to the GST field and enter the GST amount per your receipt.
Click [Save&Close] and you are done.

http://i12.tinypic.com/30i9u2r.jpg is a sample.
Change your particulars as needed.

Suggestion for testing procedures you are not sure about.
File > Close Company.
File > Open Company.
Right click on company.qbw
Click on Copy, with the cursor in the Files field
Click Open

You have now created an exact copy of your regular file.
To avoid carrying on with the copy after a successful test, click
Company > Company information and change company name to XXXXXXXXXX or
??????????? or any such obvious non name.
If the test screws up, just close _that_ copy and delete it in the Open
Company screen and make another test copy.

After a successful experiment close this copy, open the real company and
apply what was needed.

Sounds a little involved but it can solve hours of screwed up Journal
entries to eventually correct booboos.

BTW, if you are reporting quarterly you should still be able to correct
the GST changes.
Just noted your address. Aren't you on HST down East?
--
Arno

Reply With Quote
GST Canadian Question
  #4
Old 10-08-2006, 07:54 AM
John Pippy
Junior Member


John Pippy is offline
John Pippy's Info
Join Date: Jun 2006
Posts: 9
Default GST Canadian Question

Thanks Arno for your suggestion, however you lost me. Where do I type in
the - minus and the amount of GST at? Also when I do hit enter at any point
QuickBooks automatically records it. Your sample pic shows exactly what I
want to happen, would it be too much of an inconvenience to walk through it
in stages as per your instructions so that I can better understand where you
are coming from.

Thanks again,



"Arno Martens" <snetram@sympatico.ca> wrote in message
news:vjuhi25ob05cen9bvrfmpnqr0kf15s6k7r@4ax.com...
Quote:
On Sun, 08 Oct 2006 07:34:49 GMT, "John Pippy" <scraps@warp.nfld.net>, wrote:
Quote:
Entering in a receipt from Grocery store. Total of receipt is 354.17. Asmost food is not taxable the total GST is only 9.14.I use Vendor enter bills window, type in name of vender, go to account.Inthis case foods, enter in tax code G for GST. The GST then shows up as23.17. I change this manually to 9.14 then when it is recorded the amountdue goes to 340.14.Is there a way for me to enter in this transaction to reflect the actualGSTpaid.Thanks in advance.
You have one real problem and another easy one to get the above right. Real Problem: Your G Tax Code should have been changed as of 2006-Jul-01 from 7% to 6% Go to List > Tax Code List > G and change the value in the GST column. Easy solution to your question: Enter your Bill as usual. Use tax code G, [Tab], type in FULL amount, type a - (minus) and the amount of the GST per your receipt, then click [Enter]. Now go to the GST field and enter the GST amount per your receipt. Click [Save&Close] and you are done. http://i12.tinypic.com/30i9u2r.jpg is a sample. Change your particulars as needed. Suggestion for testing procedures you are not sure about. File > Close Company. File > Open Company. Right click on company.qbw Click on Copy, with the cursor in the Files field Click Open You have now created an exact copy of your regular file. To avoid carrying on with the copy after a successful test, click Company > Company information and change company name to XXXXXXXXXX or ??????????? or any such obvious non name. If the test screws up, just close _that_ copy and delete it in the Open Company screen and make another test copy. After a successful experiment close this copy, open the real company and apply what was needed. Sounds a little involved but it can solve hours of screwed up Journal entries to eventually correct booboos. BTW, if you are reporting quarterly you should still be able to correct the GST changes. Just noted your address. Aren't you on HST down East? -- Arno



Reply With Quote
GST Canadian Question
  #5
Old 10-08-2006, 09:31 AM
Arno Martens
Junior Member


Arno Martens is offline
Arno Martens's Info
Join Date: Jan 2004
Posts: 30
Default GST Canadian Question

TOP POSTED

I have taken this off list.
Arno

On Sun, 08 Oct 2006 15:54:53 GMT, "John Pippy"
<scraps(removemetorespond)@warp.nfld.net>, wrote:
Quote:
Thanks Arno for your suggestion, however you lost me. Where do I type inthe - minus and the amount of GST at? Also when I do hit enter at any pointQuickBooks automatically records it. Your sample pic shows exactly what Iwant to happen, would it be too much of an inconvenience to walk through itin stages as per your instructions so that I can better understand where youare coming from.Thanks again,"Arno Martens" <snetram@sympatico.ca> wrote in messagenews:vjuhi25ob05cen9bvrfmpnqr0kf15s6k7r@4ax .com...
Quote:
On Sun, 08 Oct 2006 07:34:49 GMT, "John Pippy" <scraps@warp.nfld.net>, wrote:
Quote:
Entering in a receipt from Grocery store. Total of receipt is 354.17. Asmost food is not taxable the total GST is only 9.14.I use Vendor enter bills window, type in name of vender, go to account.Inthis case foods, enter in tax code G for GST. The GST then shows up as23.17. I change this manually to 9.14 then when it is recorded the amountdue goes to 340.14.Is there a way for me to enter in this transaction to reflect the actualGSTpaid.Thanks in advance.
You have one real problem and another easy one to get the above right. Real Problem: Your G Tax Code should have been changed as of 2006-Jul-01 from 7% to 6% Go to List > Tax Code List > G and change the value in the GST column. Easy solution to your question: Enter your Bill as usual. Use tax code G, [Tab], type in FULL amount, type a - (minus) and the amount of the GST per your receipt, then click [Enter]. Now go to the GST field and enter the GST amount per your receipt. Click [Save&Close] and you are done. http://i12.tinypic.com/30i9u2r.jpg is a sample. Change your particulars as needed. Suggestion for testing procedures you are not sure about. File > Close Company. File > Open Company. Right click on company.qbw Click on Copy, with the cursor in the Files field Click Open You have now created an exact copy of your regular file. To avoid carrying on with the copy after a successful test, click Company > Company information and change company name to XXXXXXXXXX or ??????????? or any such obvious non name. If the test screws up, just close _that_ copy and delete it in the Open Company screen and make another test copy. After a successful experiment close this copy, open the real company and apply what was needed. Sounds a little involved but it can solve hours of screwed up Journal entries to eventually correct booboos. BTW, if you are reporting quarterly you should still be able to correct the GST changes. Just noted your address. Aren't you on HST down East? -- Arno

Reply With Quote
GST Canadian Question
  #6
Old 10-09-2006, 10:08 PM
John Pippy
Junior Member


John Pippy is offline
John Pippy's Info
Join Date: Jun 2006
Posts: 9
Default GST Canadian Question

Arno, I would like to thank you for your help it was greatly appreciated.

"Arno Martens" <snetram@sympatico.ca> wrote in message
news:uedii2h808fb91ruuc1ctgm3m95i9jlepg@4ax.com...
Quote:
TOP POSTED I have taken this off list. Arno On Sun, 08 Oct 2006 15:54:53 GMT, "John Pippy" <scraps(removemetorespond)@warp.nfld.net>, wrote:
Quote:
Thanks Arno for your suggestion, however you lost me. Where do I type inthe - minus and the amount of GST at? Also when I do hit enter at anypointQuickBooks automatically records it. Your sample pic shows exactly what Iwant to happen, would it be too much of an inconvenience to walk throughitin stages as per your instructions so that I can better understand whereyouare coming from.Thanks again,"Arno Martens" <snetram@sympatico.ca> wrote in messagenews:vjuhi25ob05cen9bvrfmpnqr0kf15s6k7r@4ax .com...
Quote:
On Sun, 08 Oct 2006 07:34:49 GMT, "John Pippy" <scraps@warp.nfld.net>, wrote:>Entering in a receipt from Grocery store. Total of receipt is 354.17.>As>most food is not taxable the total GST is only 9.14.>>I use Vendor enter bills window, type in name of vender, go to account.>In>this case foods, enter in tax code G for GST. The GST then shows up as>23.17. I change this manually to 9.14 then when it is recorded the>amount>due goes to 340.14.>>Is there a way for me to enter in this transaction to reflect the actual>GST>paid.>>Thanks in advance.> You have one real problem and another easy one to get the above right. Real Problem: Your G Tax Code should have been changed as of 2006-Jul-01 from 7% to 6% Go to List > Tax Code List > G and change the value in the GST column. Easy solution to your question: Enter your Bill as usual. Use tax code G, [Tab], type in FULL amount, type a - (minus) and the amount of the GST per your receipt, then click [Enter]. Now go to the GST field and enter the GST amount per your receipt. Click [Save&Close] and you are done. http://i12.tinypic.com/30i9u2r.jpg is a sample. Change your particulars as needed. Suggestion for testing procedures you are not sure about. File > Close Company. File > Open Company. Right click on company.qbw Click on Copy, with the cursor in the Files field Click Open You have now created an exact copy of your regular file. To avoid carrying on with the copy after a successful test, click Company > Company information and change company name to XXXXXXXXXX or ??????????? or any such obvious non name. If the test screws up, just close _that_ copy and delete it in the Open Company screen and make another test copy. After a successful experiment close this copy, open the real company and apply what was needed. Sounds a little involved but it can solve hours of screwed up Journal entries to eventually correct booboos. BTW, if you are reporting quarterly you should still be able to correct the GST changes. Just noted your address. Aren't you on HST down East? -- Arno



Reply With Quote
GST Canadian Question
  #7
Old 10-10-2006, 04:51 AM
Arno Martens
Junior Member


Arno Martens is offline
Arno Martens's Info
Join Date: Jan 2004
Posts: 30
Default GST Canadian Question

You are very welcome, John.
Arno

On Tue, 10 Oct 2006 06:08:30 GMT, "John Pippy" wrote:
Quote:
Arno, I would like to thank you for your help it was greatly appreciated."Arno Martens" <snetram@sympatico.ca> wrote in messagenews:uedii2h808fb91ruuc1ctgm3m95i9jlepg@4ax .com...
Quote:
TOP POSTED I have taken this off list. Arno On Sun, 08 Oct 2006 15:54:53 GMT, "John Pippy" <scraps(removemetorespond)@warp.nfld.net>, wrote:
Quote:
Thanks Arno for your suggestion, however you lost me. Where do I type inthe - minus and the amount of GST at? Also when I do hit enter at anypointQuickBooks automatically records it. Your sample pic shows exactly what Iwant to happen, would it be too much of an inconvenience to walk throughitin stages as per your instructions so that I can better understand whereyouare coming from.Thanks again,"Arno Martens" <snetram@sympatico.ca> wrote in messagenews:vjuhi25ob05cen9bvrfmpnqr0kf15s6k7r@4ax .com...> On Sun, 08 Oct 2006 07:34:49 GMT, "John Pippy" <scraps@warp.nfld.net>,> wrote:>>>Entering in a receipt from Grocery store. Total of receipt is 354.17.>>As>>most food is not taxable the total GST is only 9.14.>>>>I use Vendor enter bills window, type in name of vender, go to account.>>In>>this case foods, enter in tax code G for GST. The GST then shows up as>>23.17. I change this manually to 9.14 then when it is recorded the>>amount>>due goes to 340.14.>>>>Is there a way for me to enter in this transaction to reflect the actual>>GST>>paid.>>>>Thanks in advance.>>>> You have one real problem and another easy one to get the above right.>> Real Problem:> Your G Tax Code should have been changed as of 2006-Jul-01 from 7% to 6%> Go to List > Tax Code List > G and change the value in the GST column.>> Easy solution to your question:> Enter your Bill as usual. Use tax code G, [Tab], type in FULL amount,> type a - (minus) and the amount of the GST per your receipt, then click> [Enter].> Now go to the GST field and enter the GST amount per your receipt.> Click [Save&Close] and you are done.>> http://i12.tinypic.com/30i9u2r.jpg is a sample.> Change your particulars as needed.>> Suggestion for testing procedures you are not sure about.> File > Close Company.> File > Open Company.> Right click on company.qbw> Click on Copy, with the cursor in the Files field> Click Open>> You have now created an exact copy of your regular file.> To avoid carrying on with the copy after a successful test, click> Company > Company information and change company name to XXXXXXXXXX or> ??????????? or any such obvious non name.> If the test screws up, just close _that_ copy and delete it in the Open> Company screen and make another test copy.>> After a successful experiment close this copy, open the real company and> apply what was needed.>> Sounds a little involved but it can solve hours of screwed up Journal> entries to eventually correct booboos.>> BTW, if you are reporting quarterly you should still be able to correct> the GST changes.> Just noted your address. Aren't you on HST down East?> --> Arno>

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump



Powered by: vBulletin Version 3.0.7
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Style Design by vBStyles.com


Top Contact Us - IT Forums - Archive - MyLounge Top
MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service