Sales Tax problem

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."