Re: [SL] Payroll

[Chris T. <ch...@me...>]

Jeff Vian wrote:

>
>Just from my limited experience in doing payroll for one company, in the
>US there are things like medicare, ssa, FUTA, SUTA, state income,
>federal income, local taxes, and probably others I have missed. 
>There are also withholdings for IRAs, stock purchase plans,
>garnishments, medical savings plans, insurance plans, etc.
>
>  
>
My draft should be about 50% there for the basic US payroll taxes.  But 
the basic the idea is there and could be expanded.

>This will be a very complex issue even if only addressed for one
>country, and making it multinational will be even more.
>
>My approach would be to do this for one country at a time and then add
>additional countries as the need arises and time permits.  A separate
>payroll module for each country, with the processing output being
>plugged into the GL is likely required in order to make it flexible
>enough for all environments.
>
>  
>
I think that the paycheck database schema I have written should be 
flexible enough to work in a wide variety of circumstances and 
environments.  this would also be useful if you need to print the check 
with the paycheck stub.

However, aside from that, I think that your approach is fairly similar 
to the one I am advocating.  I think one of the questions is how to make 
a flexible framework which can deductions for multiple countries 
simultaneously even (if necessary).  Perhaps if we all get started and 
exchange ideas, this will happen.

Best wishes,
Chris Travers
Metatron Technology Consulting

>A complete knowledge of the requirements for each country/state will be
>needed and the ability to do updates to the calculations (percentages,
>etc.) as changes occur will be mandatory. 
>
>  
>
>>>Could an alternative solution be the integration of a more specialised 
>>>application?
>>>
>>>      
>>>
>>I would vote for this if there was a reasonably functional American 
>>payroll app that might integrate with SQL-Ledger.  Unfortunately there 
>>is not.  The apps I have been able to find are either proprietary or too 
>>immature to be used for production.  The closest application I have 
>>found is pcxpayroll but I have not had time to look at it in depth.
>>
>>I actually don't think that it will be too hard to write something which 
>>can handle US federal payroll taxes...
>>
>>The harder part is again to make something general enough to work.
>>
>>I will attach my database schemas/functions when they are written for 
>>review on this list.
>>
>>Best Wishes,
>>Chris Travers
>>Metatron Technology Consulting
>>
>>    
>>
>>>my 2c worth
>>>
>>>W
>>>
>>>      
>>>
>
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
>Use IT products in your business? Tell us what you think of them. Give us
>Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
>http://productguide.itmanagersjournal.com/guidepromo.tmpl
>_______________________________________________
>sql-ledger-users mailing list
>sql...@sq...
>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>  
>