Payroll in excel

[nathanheyer]

How do you create the vba code for a payroll form in excel?? I have tried to but not avail..... and is it possible???

Regards..
Nathan...

 

[logius]

Are you talking about creating a custom sheet to perform a payroll function or are you talking about creating a GUI where you can enter data in? ----------------------------------------
If you are reading this, then you have read too far...

lightwarrior@hotmail.com

 

[Guest_imported]

Logius
Thanks for replying what it is my boss needs to know if he can get away with using excel for a payroll maker with out buying acounting software I need a GUI for the form but I need some help on calucation code

Nathan

 

[logius]

Well, it depends on the total size of the payroll system. Accounting isn't my field, so I don't know what all a payroll system would entail. You'd be amazed at what Excel can do, but if the intent is for a large-scale tracking/accounting/management system, the code could get pretty tricky and it might be beyond Excel's capabilities. On the other hand, if you're thinking of a small/fair-sized system, that would interface with Access for data storage (or Excel alone could hold the information), then it's definitly possible. ----------------------------------------
If you are reading this, then you have read too far...

lightwarrior@hotmail.com

 

[MichaelRed]

Nathan,

IMHO, excel is a possible -but inappropiate- vehicle for a payroll package. For corporations over 50 employees, Federal regulations require a fair amout of reporting as well as historical record keeping which go far beyond the intracies of the accounting process.

For smaller organizations, it is simply a matter of knowing the various business, local (county/city/...), state and federal requirements, and -of course- implementing them.

If the 'Boss' wants to 'get away with' the simplistic approach by doing this 'in-house', ask for the pertinent rules and regulations for each jurisdiction involved.

Based on these, provide him with a project outline, implementation plan and man-hour estimate to implement the process. If, at this point, the project still appears to be a viable approach, please consider hiring me as the outhouse programmer to implement your payroll processing.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[nathanheyer]

Michael,
I thank you for your comments but consider these varibles...
I am in australia were the accounting rules are sligtly differentbut this is only an intermedite thing till we can afford the real software @ $1000+ but as we just bought Office 2000 @ $980 just alittle hard up for cash there are 5 in the business

Plus it is a major assignment for Bussiness Manganent and IT

Nathan

 

[bryanbayfield]

What calculation code do you need help with Nathan?

Bryan.

 

[nathanheyer]

Bryan,
I am trying to get a form in Excel to use and refference the payroll sheet but it won't reff like access. all of the fomulas are in the sheet
The form has the fields of Employee, hours, OT, Pay rate, gross, Tax, super, net

thanks for trying to help

Nathan

 

[bryanbayfield]

Hmmm .. still don't think I understand.

You have a form that constitutes your graphical interface. Through this interface the user enters data. This data is then used for accounting calcs.

Your problem is that you can't get the information from the form so that it can be used in the calculations? This should be fairly simple, so I can't see where the problem is.

What you might like to consider is doing the software as an add-in. The variable values can then be assigned to cells you pre-determine in ThisWorkbook, whenever a textbox value changes. When it comes to doing the calculation, the variable values can then be read from ThisWorkbook. This could be a useful way of working if you have lots of variables.

By the way, ThisWorkbook is how you reference teh workbook that actually constitutes the add-in. If you need a lot more detailed help then maybe you'd consider getting Steven Roman's book on Excel macros. I found it a bit dry and intense but really helpful too (you have to stick with it). I'll help you if you need some advice in the meantime too though!

Bryan.