How do I include withholding allowance payroll calculations?


M

Mark Kalmus

We are using the manual payroll "feature" in SBA; however, we cannot
determine if the withholding allowances are being included when calculating
our employees' taxable wages. Doing the payroll calculations manually (with
a calculator) makes us believe the payroll feature IS NOT calculating
allowances.

If so, can we alter the ManualPayrollCalculation1.xlt file to reduce our
employees' taxable income according to the allowance tables? Has anyone else
modifed the payroll file to do this?
 
Ad

Advertisements

T

TKnTexas

I don't use the feature... but to get you a quick answer, NO. There
have been a number of postings regarding the manual payroll feature not
working. You might be able to do a search on the topic and see past
postings (for those that didn't set the flag to NOT archive).
TK
 
A

Allan Martin

Mark Kalmus said:
We are using the manual payroll "feature" in SBA; however, we cannot
determine if the withholding allowances are being included when
calculating
our employees' taxable wages. Doing the payroll calculations manually
(with
a calculator) makes us believe the payroll feature IS NOT calculating
allowances.

If so, can we alter the ManualPayrollCalculation1.xlt file to reduce our
employees' taxable income according to the allowance tables? Has anyone
else
modifed the payroll file to do this?

If you didn't realized after five minutes of use that this feature is
absolutely useless then you should not be preparing payroll in house.
 
M

Mark Kalmus

Thanks, Dick

We utilized the ManualPayrollCalculation spreadsheet and modified its macros
so that our seven employees' allowances are calculated before applying the
tax tables.

Knowing enough VB and the right Excel formulas to make the modifications is
helpful, to be sure. I think having a SQL Server Administration app is also
helpful if you want to capture YTD accumulative data for paycheck stubs
(table creation/join may be necessary). And the cost of doing this is still
below the ADP cost Chris advocates using (which seems cost effective only
with a greater number of employees).

Once we get through a couple pay cycles we can make the template file
available for free to anyone who wishes to see how we did it by placing it on
our website for download.
 
A

Allan Martin

Mark Kalmus said:
Thanks, Dick

We utilized the ManualPayrollCalculation spreadsheet and modified its
macros
so that our seven employees' allowances are calculated before applying the
tax tables.

Knowing enough VB and the right Excel formulas to make the modifications
is
helpful, to be sure. I think having a SQL Server Administration app is
also
helpful if you want to capture YTD accumulative data for paycheck stubs
(table creation/join may be necessary). And the cost of doing this is
still
below the ADP cost Chris advocates using (which seems cost effective only
with a greater number of employees).

Its a good thing you at least know about VBA and Excel formulas because you
appear to be lacking in any fundamental grasp of economics. $169.00/Year is
not a lot money. $169.00 is less than one hour of many MS consultants'
hourly billable rate. Don't you place any value on your time?

Could your piddley modifications ever come close to the functionality that a
typical end user will find in the ADP application? Sorry dude but the wheel
has already been invented, and its dirt cheap. Good lord man $169 is chicken
flickens.


If you have a business and insist on using SBA, and want to process payroll
in-house then you should subscribe to the ADP service. This is a no
brainier. If one can't see the logic to this statement then it really does
not matter because you probably will not remain in business.
 
Ad

Advertisements

C

Chris Schatte

ADP is the best per $ option for SBA, then your local accountant.
 
A

Allan Martin

Chris Schatte said:
ADP is the best per $ option for SBA, then your local accountant.

Chris Schatte

Chris,

In my experience the decision to move payroll out of house is not based
solely on cost. It is an area that has become too complex for many companies
to bother with on their own.
 
M

Mark Kalmus

Point taken, Dick

True, the cost of utilizing ADP can be considered minimal, and yes, I have
no issues spending a few minutes figuring out how to get the "feature" to
work. Once my wife decides she wants a more programmatic solution, she will
likely sign onto the ADP solution.

My offer remains if someone wishes to see the solution we created.
 
A

Allan Martin

Mark Kalmus said:
Point taken, Dick

True, the cost of utilizing ADP can be considered minimal, and yes, I have
no issues spending a few minutes figuring out how to get the "feature" to
work.
So you actually believe the manual payroll only requires a few minutes to
have it work the way it should. You are full of yourself.




Once my wife decides she wants a more programmatic solution, she will
 
Ad

Advertisements

D

Dave Grooms

Mark

Not sure if you are still following this thread but if so I would like to
look at how you have modified the spreadsheet to calculate taxes correctly. I
simply want to do payroll myself and don’t want to outsource. Only have 2
sometimes 3 employees and could probably just enter deductions manually
easier but if you have the spreadsheet calculating properly by using tax
tables or some other method … how great that would be and … why didn’t
Microsoft do that from the beginning?
 

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