Is anyone ever going to answer me?


J

John

PLEASE . . .

I need to know how to balance my Liability Accounts with the amounts
shown in the Pay Payroll Liabilities window.

Right now the amounts in the Liabilities account list is correct
(79.56 & 79.56 for employee & company respectively)

But when I try to pay my health insurance through the Pay Liabilities
window it shows a negative number (-65.42 & -65.42 for employee &
company respectively)

If I change the date range going all the way back to Dec 1 2001 then
the amounts are correct in the Pay Liabilities Window.

This problem only showed up after upgrading to QB2003 six months ago
and was in balance the previous 3 years with QB 99

THANKS SO MUCH

-
____ _
| __\_\_o____/_|
<[___\_\_-----<------------------<no spam please><
| o'
 
Ad

Advertisements

J

John

Thanks

It may take a while but I'll try to read your reply (bellow) as soon
as I have some coffee


<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Have you checked the QB knowledge base on their website?&nbsp; This came
from there and sounds similar to your problem.&nbsp; <br>
<br>
<!-- Main column -->
<table width="659" border="0" cellpadding="0" cellspacing="0" summary="">
<tbody>
<tr>
<td colspan="2"><img
src="cid:p[email protected]_spam_hatfields.org" width="18"
height="1"><img src="cid:p[email protected]_spam_hatfields.org"
width="134" height="24" alt="Help &amp; Support"></td>
</tr>
<tr>
<td colspan="2" height="54"><!-- #BeginEditable "subhead" --><img
src="cid:p[email protected]_spam_hatfields.org"
alt="QuickBooks Basic and Pro 2003" height="21" width="481"><!-- #EndEditable --><br>
<br>
<img src="cid:p[email protected]_spam_hatfields.org"
width="659" height="1" alt=""></td>
</tr>
</tbody>
</table>
<table width="659" border="0" cellpadding="0" cellspacing="0" summary="">
<colgroup><col align="left" valign="top" width="100"></colgroup> <colgroup><col
align="left" valign="top" width="359"><col align="left" valign="top"
width="100"><col align="left" valign="top" width="100"></colgroup> <tbody>
<tr>
<td width="100"><b>Title</b></td>
<td width="559" colspan="3"><b> </b><!-- #BeginEditable "title" --><b>Negative
numbers in the Pay Liabilities window and on payroll liabilities reports</b><!-- #EndEditable --></td>
</tr>
<tr>
<td width="100"><b>KB ID#:</b></td>
<td width="559" colspan="3"><!-- #BeginEditable "kbid" -->102541<!-- #EndEditable --></td>
</tr>
<tr>
<td width="100"><b>Categories:</b></td>
<td width="559" colspan="3"><!-- #BeginEditable "categories" -->Payroll<!-- #EndEditable --></td>
</tr>
<!--dotted line--> <tr>
<td colspan="4" valign="bottom" height="28"><img
src="cid:p[email protected]_spam_hatfields.org" width="659"
height="1" vspace="12" alt=""></td>
</tr>
<tr>
<td valign="top" width="100"><b>Question:</b></td>
<td valign="top" width="559" colspan="3"><!-- #BeginEditable "question" -->Why
are the amounts for employee-paid health insurance showing as negative
numbers in the Pay Liabilities window and on payroll liabilities
reports?<!-- #EndEditable --> </td>
</tr>
<!--space--> <tr>
<td colspan="4">&nbsp;</td>
</tr>
<tr>
<td valign="top" width="100"><b>Possible<br>
Cause:</b></td>
<td valign="top" width="559" colspan="3"><!-- #BeginEditable "possible_cause" -->
<p>Employee-paid
payroll items (for example, employee-paid health insurance premiums)
were paid for by the company before the money was collected from
employees.
</p>
<p>The Pay Liabilities feature in QuickBooks is designed to work
correctly when the company pays out monies <i>after</i> they are
collected from employees. If the company pays the liabilities <i>before</i>
collecting employees' payments, negative amounts will be displayed in
the Pay Liabilities window and on Payroll Liabilities reports.<!-- #EndEditable --></p>
</td>
</tr>
<!--space--> <tr>
<td colspan="4">&nbsp;</td>
</tr>
<tr>
<td valign="top" width="100"><b>Answer:</b></td>
<td valign="top" width="559" colspan="3"><!-- #BeginEditable "content" -->
<p>To resolve this issue:
</p>
<ol>
<li>Create a new asset account for prepaid health insurance
premiums:
<ol>
<li type="a">From the QuickBooks <b>Lists</b> menu, choose
<b>Chart of Accounts</b>.</li>
<li type="a">Click the <b>Account</b> button at the bottom
of the <b>Chart of Accounts</b> window, and choose <b>New</b>.</li>
<li type="a">From the <b>Type</b> drop-down list in the <b>New
Account</b> window, select <b>Other Current Asset</b>.</li>
<li type="a">In the <b>Name</b> field, enter a name for
the account (Prepaid Health Insurance, for example).</li>
<li type="a">Click <b>OK</b>.<br>
<br>
</li>
</ol>
</li>
<li>Use the Write Checks feature (rather than Pay Liabilities)
to prepay your health insurance premiums:
<ol>
<li type="a">From the QuickBooks&nbsp;<b>Banking</b> menu,
choose <b>Write Checks</b>.</li>
<li type="a">Use the <b>Expenses</b> tab in the <b>Write
Checks</b> window to assign the premium amount to the new asset account.<br>
<br>
<strong>Note:</strong> If part of the insurance premium
is company
paid, that amount needs to be entered on a separate line on the check
and offset to the appropriate expense account.<br>
<br>
</li>
</ol>
</li>
<li>Edit the existing payroll deduction item to replace the
Payroll
Liabilities account with the asset account you created in step 1:
<ol>
<li type="a">From the <strong>Lists</strong> menu, choose <strong>Payroll
Item List</strong>.</li>
<li type="a">Double-click the deduction item to edit it.
Follow the onscreen instructions.</li>
<li type="a">When the payroll deduction occurs, it will
reimburse the asset account.<br>
<br>
</li>
</ol>
</li>
<li>The <strong>Payroll Liabilities</strong> report will no
longer display the deduction item. Instead, you can track this item
using the <strong>Custom Transaction Detail Report</strong> filtered
for the new asset account (and whatever other filters are appropriate):
<ol type="a">
<li>From the <strong>Reports</strong> menu, choose <strong>Custom
Transaction Detail Report</strong>.</li>
<li>Click the <strong>Filters</strong> tab, and then make
the appropriate filter selections.</li>
</ol>
</li>
</ol>
</td>
</tr>
</tbody>
</table>
<br>
John wrote:<br>
<blockquote type="cite"
cite="(e-mail address removed)">
<pre wrap="">PLEASE . . .

I need to know how to balance my Liability Accounts with the amounts
shown in the Pay Payroll Liabilities window.

Right now the amounts in the Liabilities account list is correct
(79.56 &amp; 79.56 for employee &amp; company respectively)

But when I try to pay my health insurance through the Pay Liabilities
window it shows a negative number (-65.42 &amp; -65.42 for employee &amp;
company respectively)

If I change the date range going all the way back to Dec 1 2001 then
the amounts are correct in the Pay Liabilities Window.

This problem only showed up after upgrading to QB2003 six months ago
and was in balance the previous 3 years with QB 99

THANKS SO MUCH

-
____ _
| __\_\_o____/_|
&lt;[___\_\_-----&lt;------------------&lt;no spam please&gt;&lt;
| o'
</pre>
</blockquote>
<br>
</body>
</html>
-
____ _
| __\_\_o____/_|
<[___\_\_-----<------------------<no spam please><
| o'
 
L

Lisa C

John said:
No! This article is not what I need to make a one time ADJUSTMENT to
my affected accounts.

I guess I'll just have to write a couple of checks to myself to
balance the accounts.

It's hard to believe that there is no on in this NewsGroup that knows
how to fix this.
I think Jack Hatfield did. You mentioned that your liabilities account
showed positive (and correct) amounts. The pay liabilities window shows
negative amounts -- and you mentioned that the liability you were trying to
pay was health insurance. Jack included the information from this link
http://www.quickbooks.com/support/faqs/qbw2003/102541.html
The information stated that one possible cause of negative amounts in the
payroll liabilities window was payment by the company before money was
collected from employees. The information states that BY DESIGN, pay
liabilites works ONLY when the company pays out monies AFTER they have been
collected. This means that for 'liabilities' where you pay before you
collect the money you CANNOT use the pay liabilities window.

For health insurance, specifically, the work around is to create a seperate
asset account for the employee health insurance contributions, edit the
payroll deduction item to point to the new asset account. When you pay the
health insurance, use the write checks window to create a check that has two
lines... one points to the asset account you created (where the employee
contributions go) one points to the expense account you use for company
health insurance expense. Your post indicated that you also have a company
health insurance payroll item. If that is the case, then that item also
would have to be edited.

It seems you did not like the answer.
If you want more options or different solutions to your problem, or if your
situation has been misunderstood, post back. Be specific as to what your
problem is and what you want to do.
 
B

Bailey's Dad

It's hard to believe that there is no on in this NewsGroup that knows
how to fix this.
What is harder to believe is that a grown man gets free help from volunteers
in a forum he is not paying for and then bitches about the supposed
knowledge level of the volunteers. Kinda like winning a dinner for four at
Ruth's Chris and then not tipping your server because she forgot your salad
fork.

Try this site:
http://www.blocktax.com/. I have found incredible help just by perusing
this site.

If you still need someone to hold your hand, find a Quickbooks certified
accountant in your area and pay the bill. That way, if you don't like the
solution given, you will at least be within your rights to complain.

BD
 
Ad

Advertisements

J

John

Thanks for the post Lisa Anne.

I would have assumed that If the article covered my particular
problem, then it would only be off by the amount I pre-payed before
collecting it through the payroll AND I would have always had this
problem for the last three years but it only showed up 3 months ago
after upgrading to QB2002

I don't pre-pay with a liability check. I payed the first installment
with a regular check and only payed with a liability check after the
liability account showed the correct ammounts. I do the same thing
with WorkComp and it always balances

I'll try a few things and let you know how I cured it in a day or two.
I just got home from vacation and don't feel like messing with it
tonight.

What I want to do is a _one_time_ ADJUSTMENT to the liability account
without it affecting the Pay Liability window and payroll reports.

John

I think Jack Hatfield did. You mentioned that your liabilities account
showed positive (and correct) amounts. The pay liabilities window shows
negative amounts -- and you mentioned that the liability you were trying to
pay was health insurance. Jack included the information from this link
http://www.quickbooks.com/support/faqs/qbw2003/102541.html
The information stated that one possible cause of negative amounts in the
payroll liabilities window was payment by the company before money was
collected from employees. The information states that BY DESIGN, pay
liabilites works ONLY when the company pays out monies AFTER they have been
collected. This means that for 'liabilities' where you pay before you
collect the money you CANNOT use the pay liabilities window.

For health insurance, specifically, the work around is to create a seperate
asset account for the employee health insurance contributions, edit the
payroll deduction item to point to the new asset account. When you pay the
health insurance, use the write checks window to create a check that has two
lines... one points to the asset account you created (where the employee
contributions go) one points to the expense account you use for company
health insurance expense. Your post indicated that you also have a company
health insurance payroll item. If that is the case, then that item also
would have to be edited.

It seems you did not like the answer.
If you want more options or different solutions to your problem, or if your
situation has been misunderstood, post back. Be specific as to what your
problem is and what you want to do.
-
____ _
| __\_\_o____/_|
<[___\_\_-----<------------------<no spam please><
| o'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top