Payroll error message

Posted by Laura on December 12, 2006, 10:48 pm

Please log in for more thread options

Thank you for the link.

If we decided to skip this year's payroll subscription do I need to do
anything other than replicate the existing tax IDs (FICA, FUTA, SIT) that
exist for 2006 in the Peachtree maintained tables and create them for 07 in
the user maintained section?

> The Circular E isn't up on the IRS web site yet. Here's a link to part of

> the 2007 rates:

> http://www.irs.gov/formspubs/article/0,,id=164272,00.html

> --

> Diane Koers

> www.thepeachtreelady.com

> Co-author Peachtree for Dummies

>>> wrote:

>>>

>>>>> Hello. I've got a new installation of PT Complete 2006 and have

>>>>> generated my own tax formulas.

>>>>>

>>>>> When I try to generate payroll checks, I get error messages ("Can't

>>>>> find FIT 07, Can't find FICA EE 07"). When I click OK to the

>>>>> messages, the payroll deductions are calculated correctly and

>>>>> deducted from the paycheck gross amount as you would expect.

>>>>>

>>>>> So, my question is, if PT can't find my formulas, how come it

>>>>> has no trouble using them for the payroll deductions?

>>>>>

>>>>> Thanks in advance for any help with this one.

>>>>

>>>

>>>>Check the date of the paycheck. It should not be looking for the 07 tax

>>>>Ids

>>>>until January 07 paychecks.

>>>

>>> Hmmm. A possibility. However, the error message states that it

>>> indeed is looking for FIT 07 (which really is there). I'll wait a few

>>> weeks until it really is 07. Then, if it still doesn't work, I'll

>>> have a more valid reason to panic. Thanks very much.

>> why wait? Change your computer clock to 1/1/07 and see what happens.

>> The other possibility is that there is a problem with how you have

>> specified the tax IDs or tax names on those entries and PT can't find

>> those codes. I would check both the default employee settings as well as

>> your employee profiles. Something is not specified correctly.

>> Is the IRS pub 15 for the 2007 tables available yet? we are thinking of

>> skipping the tax subscription this year and doing it ourselves.

Posted by RCW on December 13, 2006, 5:58 am

Please log in for more thread options

wrote:

>Thank you for the link.

>If we decided to skip this year's payroll subscription do I need to do

>anything other than replicate the existing tax IDs (FICA, FUTA, SIT) that

>exist for 2006 in the Peachtree maintained tables and create them for 07 in

>the user maintained section?

>> The Circular E isn't up on the IRS web site yet. Here's a link to part of

>> the 2007 rates:

>> http://www.irs.gov/formspubs/article/0,,id=164272,00.html

>> --

>> Diane Koers

>> www.thepeachtreelady.com

>> Co-author Peachtree for Dummies

>>>

>>>> wrote:

>>>>

>>>>>> Hello. I've got a new installation of PT Complete 2006 and have

>>>>>> generated my own tax formulas.

>>>>>>

>>>>>> When I try to generate payroll checks, I get error messages ("Can't

>>>>>> find FIT 07, Can't find FICA EE 07"). When I click OK to the

>>>>>> messages, the payroll deductions are calculated correctly and

>>>>>> deducted from the paycheck gross amount as you would expect.

>>>>>>

>>>>>> So, my question is, if PT can't find my formulas, how come it

>>>>>> has no trouble using them for the payroll deductions?

>>>>>>

>>>>>> Thanks in advance for any help with this one.

>>>>>

>>>>

>>>>>Check the date of the paycheck. It should not be looking for the 07 tax

>>>>>Ids

>>>>>until January 07 paychecks.

>>>>

>>>> Hmmm. A possibility. However, the error message states that it

>>>> indeed is looking for FIT 07 (which really is there). I'll wait a few

>>>> weeks until it really is 07. Then, if it still doesn't work, I'll

>>>> have a more valid reason to panic. Thanks very much.

>>>

>>> why wait? Change your computer clock to 1/1/07 and see what happens.

>>>

>>> The other possibility is that there is a problem with how you have

>>> specified the tax IDs or tax names on those entries and PT can't find

>>> those codes. I would check both the default employee settings as well as

>>> your employee profiles. Something is not specified correctly.

>>>

>>> Is the IRS pub 15 for the 2007 tables available yet? we are thinking of

>>> skipping the tax subscription this year and doing it ourselves.

Thank you all for your suggestions. I have tried re-setting the
computer clock to 2007. No dice. Very strange. When I load a sample
company, all is well even though the tax files are named the same as
mine. Yet mine don't work. Yup, something is certainly wrong.

For what it's worth, here are the FIT formulas I entered for 2006.
2007 shouldn't be too much different. I don't think my formulas are my
problem, I'm listing them here in case others can use them.

Richard

A=ANNUAL(ADJUSTED_GROSS)-(EMP_FEDERAL_ALLOWANCES*3299.92);
B=0;
B=IF(A>8008, 0.1*A - 800.80, B);
B=IF(A>22906, 0.15*A - 1946.10, B);
B=IF(A>68042, 0.25*A - 8750.30, B);
B=IF(A>126906, 0.28*A - 12557.48, B);
B=IF(A>195442, 0.33*A - 22329.58, B);
B=IF(A>343538, 0.35*A - 29200.34, B);

ANSWER=-PRORATE(B)-EMP_FEDERAL_EXTRA

Posted by RCW on December 13, 2006, 6:57 am

Please log in for more thread options

HA!

Found the problem. My FIT formula was listed as "married/jointly"
whereas my employee record was just plain "married" Makes a
difference.

Sorry for my confusion.

Posted by Laura on December 13, 2006, 7:27 am

Please log in for more thread options

> Thank you all for your suggestions. I have tried re-setting the

> computer clock to 2007. No dice. Very strange. When I load a sample

> company, all is well even though the tax files are named the same as

> mine. Yet mine don't work. Yup, something is certainly wrong.

> For what it's worth, here are the FIT formulas I entered for 2006.

> 2007 shouldn't be too much different. I don't think my formulas are my

> problem, I'm listing them here in case others can use them.

> Richard

> A=ANNUAL(ADJUSTED_GROSS)-(EMP_FEDERAL_ALLOWANCES*3299.92);

The PT supplied formula is
ANSWER = -PRORATE (TABLE (ANNUAL (ADJUSTED_GROSS) -
(EMP_FEDERAL_ALLOWANCES * 3300))) - EMP_FEDERAL_EXTRA

> B=0;

> B=IF(A>8008, 0.1*A - 800.80, B);

> B=IF(A>22906, 0.15*A - 1946.10, B);

> B=IF(A>68042, 0.25*A - 8750.30, B);

> B=IF(A>126906, 0.28*A - 12557.48, B);

> B=IF(A>195442, 0.33*A - 22329.58, B);

> B=IF(A>343538, 0.35*A - 29200.34, B);

> ANSWER=-PRORATE(B)-EMP_FEDERAL_EXTRA

How are you entering these? Did you use the tables or is the above entered
in the formula area?

The Peachtree supplied tables use the formula plus table entries that look
like this:

Married:
Gross> withhold Plus %
8000.00 0.00 10.00
22900.00 1490.00 15.00
68040.00 8261.00 25.00
etc

These tables match the annual tables found in the IRS pub 15-percentage
method. Yours look similar but the wage brackets are slightly different than
those used by the IRS.

Posted by RCW on December 13, 2006, 4:31 pm

Please log in for more thread options

>> A=ANNUAL(ADJUSTED_GROSS)-(EMP_FEDERAL_ALLOWANCES*3299.92);

>The PT supplied formula is

>ANSWER = -PRORATE (TABLE (ANNUAL (ADJUSTED_GROSS) -

>(EMP_FEDERAL_ALLOWANCES * 3300))) - EMP_FEDERAL_EXTRA

>> B=0;

>> B=IF(A>8008, 0.1*A - 800.80, B);

>> B=IF(A>22906, 0.15*A - 1946.10, B);

>> B=IF(A>68042, 0.25*A - 8750.30, B);

>> B=IF(A>126906, 0.28*A - 12557.48, B);

>> B=IF(A>195442, 0.33*A - 22329.58, B);

>> B=IF(A>343538, 0.35*A - 29200.34, B);

>> ANSWER=-PRORATE(B)-EMP_FEDERAL_EXTRA

>How are you entering these? Did you use the tables or is the above entered

>in the formula area?

The above are the married rates. I'm guessing that when the Bush tax
cut was passed, the methods for calculating withholding changed. The
above numbers I used is from the 2006 IRS tables. There is a slight
difference between the weekly table and the bi-weekly table but it's
not much.

Below are the single rates:

A=ANNUAL(ADJUSTED_GROSS)-(EMP_FEDERAL_ALLOWANCES*3299.92);
B=0;
B=IF(A>2652, 0.1*A - 265.20, B);
B=IF(A>10010, 0.15*A - 765.70, B);
B=IF(A>32240, 0.25*A - 3989.70, B);
B=IF(A>73242, 0.28*A - 6186.96, B);
B=IF(A>156650, 0.33*A - 14019.46, B);
B=IF(A>338390, 0.35*A - 20787.26, B);

ANSWER=-PRORATE(B)-EMP_FEDERAL_EXTRA

I just copied and pasted the whole block into the formula window. I
didn't use PT's table at all.

I've tried writing sample paychecks and the formulas seem to agree
with the IRS tables. Maybe 2007 will be slightly different but it
should be no big deal to make slight adjustments to these formulae.

>The Peachtree supplied tables use the formula plus table entries that look

>like this:

>Married:

>Gross> withhold Plus %

> 8000.00 0.00 10.00

>22900.00 1490.00 15.00

>68040.00 8261.00 25.00

>etc

>These tables match the annual tables found in the IRS pub 15-percentage

>method. Yours look similar but the wage brackets are slightly different than

>those used by the IRS.