Home Page link  

Sales Tax problem

 

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Sales Tax problem Preston Andreas 07-19-2006
---> Re: Sales Tax problem Golden Californ...07-20-2006
Posted by Preston Andreas on July 19, 2006, 6:36 pm
Please log in for more thread options
I have searched help and the knowledge database to no avail. Hopefully
someone can help me.

Our sales are done with "Sales Receipts" and "Invoices". All reports and the
"Pay Sales Tax" window properly reflects this for June. Other sales tax
payables, such as company purchases for internal use, are entered in the
General Journal. For June, the "other" tax payables is $30.44 which is what
the Sales Tax Liability" report shows, yet in the "Pay Sales Tax" window, it
show it to be $61.14. I have already paid all sales taxes that were owed for
May, so I assume the difference between the $30.44 and $61.44 had to occur
during June.

I looked through the Sales Tax Payable account (each entry for June), and
all the Sales Receipts, Invoices, General Journal Entries and the month
ending balance matches the Sales Tax Liability report. Where else could
that difference come from? I have to pay the tax tomorrow, so I hop I find
an answer.

Thanks for your help,

Preston



Posted by Golden California Girls on July 20, 2006, 12:17 am
Please log in for more thread options
Preston Andreas wrote:
> I have searched help and the knowledge database to no avail. Hopefully
> someone can help me.
>
> Our sales are done with "Sales Receipts" and "Invoices". All reports and the
> "Pay Sales Tax" window properly reflects this for June. Other sales tax
> payables, such as company purchases for internal use, are entered in the
> General Journal. For June, the "other" tax payables is $30.44 which is what
> the Sales Tax Liability" report shows, yet in the "Pay Sales Tax" window, it
> show it to be $61.14. I have already paid all sales taxes that were owed for
> May, so I assume the difference between the $30.44 and $61.44 had to occur
> during June.
>
> I looked through the Sales Tax Payable account (each entry for June), and
> all the Sales Receipts, Invoices, General Journal Entries and the month
> ending balance matches the Sales Tax Liability report. Where else could
> that difference come from? I have to pay the tax tomorrow, so I hop I find
> an answer.
>
> Thanks for your help,

General Ledger entries aren't "sales taxable" and may not show in the
pay sales tax window, because there may not be a sales tax vendor
associated with them.

If you include the sales tax liability account in your G/L entry in the
correct amount, you may get an other line on your pay sales tax window,
but it might fall in the wrong period or fail to show at all. If it
doesn't show, that is why there is the adjustment option.

What is the sales tax revenue report showing?

BTW, I suspect a lot of people use the method of filling out the tax
form, then using adjust sales tax payable to put in those purchases
subject to use tax or prepaid sales tax items into SlowBooks.
Unfortunate, but SlowBooks never implemented a way to track them.





Posted by Preston Andreas on July 20, 2006, 10:26 am
Please log in for more thread options
SNIP........
> General Ledger entries aren't "sales taxable" and may not show in the
> pay sales tax window, because there may not be a sales tax vendor
> associated with them.
>
> If you include the sales tax liability account in your G/L entry in the
> correct amount, you may get an other line on your pay sales tax window,
> but it might fall in the wrong period or fail to show at all. If it
> doesn't show, that is why there is the adjustment option.
>
> What is the sales tax revenue report showing?
>
> BTW, I suspect a lot of people use the method of filling out the tax
> form, then using adjust sales tax payable to put in those purchases
> subject to use tax or prepaid sales tax items into SlowBooks.
> Unfortunate, but SlowBooks never implemented a way to track them.
>
> -----------------------------
>
> The sales tax revenue report and the sales tax line do match. It is the
"other line" in the Pay Sales Tax window that you mention that doesn't match
my other purchase that were entered in General Journal entries. These
Journal entries are credited to Sales Tax Payable and associated in the Name
column to the State Comptroller. These entries show up in the "other line".
Unfortunately, all these Journal entries add up to $30.44 while the other
line in the Sales Tax Liability Window shows $61.14. I can't find this
difference of $30.70 in the Sales Tax Payable account, or anywhere else I
look.

Thanks so far.

Preston



Posted by Preston Andreas on July 20, 2006, 1:49 pm
Please log in for more thread options
Inside the "Pay Sales Tax" window, it says "show sales tax through -
06/30/2006". It correctly does this for sales tax collected through sales
receipts and invoices. However, for General Journal entries for sales tax
owed due to other purchases or write-offs, the "Pay Sales Tax" window (in
spite of the date range it shows) gives the tax owed through to the current
date. This means it includes up to July 20th (today), even though it states
in the window it is only through June 30th. Sure sounds like a glitch to
me.

The "Sales Tax Liability" report is correct and is what should be used to
pay last month's sales tax.

Thanks for your help. You have saved my behind more than once.

Preston



Posted by Golden California Girls on July 20, 2006, 11:43 pm
Please log in for more thread options
Preston Andreas wrote:
> Inside the "Pay Sales Tax" window, it says "show sales tax through -
> 06/30/2006". It correctly does this for sales tax collected through sales
> receipts and invoices. However, for General Journal entries for sales tax
> owed due to other purchases or write-offs, the "Pay Sales Tax" window (in
> spite of the date range it shows) gives the tax owed through to the current
> date. This means it includes up to July 20th (today), even though it states
> in the window it is only through June 30th. Sure sounds like a glitch to
> me.
>
> The "Sales Tax Liability" report is correct and is what should be used to
> pay last month's sales tax.
>
> Thanks for your help. You have saved my behind more than once.
>
> Preston
>
>


I said "it may fall into the wrong period."


Similar ThreadsPosted
Problem With Sales Report - PLEASE!!! September 14, 2006, 5:59 pm
Sales by Customer Summary Report problem October 17, 2006, 12:02 pm
Sales tax? December 13, 2006, 8:53 am
Sales by Country July 18, 2006, 10:18 am
Sales by Country July 18, 2006, 10:19 am
Sales orders June 24, 2007, 8:49 am
Sales tax on invoices August 26, 2007, 9:03 am
Recording Sales September 9, 2007, 9:17 am
Sales Receipts October 9, 2007, 11:11 am
Sales on consignment January 14, 2008, 4:34 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap