Excel Formula

[Helen]

When i create excel payroll worksheets, i would like certain information
automatically transfered to other excel worksheets instead of
re-entering manually.
How does one do this?

so when i enter payroll for ABC person
ABC Year-To-Date file would be updated
ABC Month-To-Date file would be updated
ABC Quarterly-To-Date file would be updated

In addition - Monthly and Quarterly payroll tax information would be
updated automatically and when updated would compute the various
payroll taxes.

Maybe I am asking for too much?

I only have a handful of clients so I can do this manually but I need
to improve the process, have less keying errors and be able to go after
more clients which i cannot do under current conditions.

 

[Otto Moehrbach]

Helen
Yes, you are asking way too much. I did all you are asking for with my
wife's catering business, so I know what is involved.
The payroll taxes, for instance, change annually so those tables or
formulas have to be revised every year.
To get help with this you have to approach this like you would the task
of eating a cow. One piece at a time.
First you asked about automatically updating another file when you enter
certain data in the first file. Deal with that first until you have it down
pat. By the way, have you considered doing all this in one file (separate
sheets for year-to-date, month-to-date, etc)?. You could have sheets for
every employee and automatically hide all the sheets except those applying
to the employee you are working on at the time. Just an idea to ponder.
If you wish, you can send me a sample of what you have and maybe I can
help you with it. Send it to me direct rather than attach a file to a
newsgroup post (frowned upon). Remove "cobia97" from my email address.
Please include what version of Excel you have and what country you're in.
HTH Otto

 

[Dave Peterson]

Otto,

Did you consider purchasing a software package (maybe something like
QuickBooks).

I've never used it (or seen it), but if you considered it and rejected it, maybe
the OP would want to know your reasons.

I'm not sure if the cost is prohibitive for a small business, but maybe...

 

[Peo Sjoblom]

QuickBooks Pro 2004 can be bought at Costco for $219.99 after $100
rebate, I don't think that is prohibitive for any business.

 

[Otto Moehrbach]

Dave
I think your idea is a good one. Buying an existing package is always
the first thing to look at. Thanks. Otto

 

[fyrfytr265]

I just posted a similar question to yours. Somewhat uncanny. I dont kno
if you have a formula to figure federal withholding using th
percentage method, but if you do not, I would be happy to help you ou
with that. I spent hours trying to figure out the formula for it. Bu
it was worth it. Let me know if you need this, would be happy to shar
the fruits of my labor with you

 

[ockam]

fyrfytr265,

I'd be interested in checking out your withholding formula if you're
still happy to share it. I was just about to start the same exersise
myself.

If you can email me at dwadsworth {at} peoplepc.com or post the details
here, that would be very much appreciated!

Thanks!