Re: [SL] Payroll

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

Since I am neither an accountant nor a tax lawyer, and I live in a state 
without state income tax, I have an interesting question for folks---

Are there any states in the US (or regions elsewhere) where certain 
payroll deductions may be exempt from state or regional taxes but not 
from federal taxes or vice versa?  This is something which could greatly 
complicate payroll.

My idea is as follows:
1)  Simple percentage deductions will be defined in a table.
2)  Complex deductions (such as US Federal Income Tax) would be handled 
by stored procedures, allowing these to be swapped out for other 
countries.  These may need to be specifically coded for specific regions.
3)  The actual paycheck deduction definition would be handled in a 
stored procedure and returned as a set of records.

Best Wishes,
Chris travers
Metatron Technology Consulting

Santoken wrote:

> List,
>
> After the last few weeks' discussions regarding payroll, and what 
> appeared to be an opinion of work-arounds, lack of need, etc. I 
> started planning my own.
>
> My theory was a plugin to SL.  Working with SL, but not within.  My 
> fear would be to create a module, then the next update that I wanted 
> came out, I'd have to recode the payroll.
>
> I'm not a coder, but I do dabble.  I'm sure that I will be using 
> improper jargon, but here's what I've came up with at this point:
>
> My module would be perl/sql based.  It would work hand in hand with 
> SL, posting approiatly directly to the SL db.  First, the deductions 
> would be defined in a Deductions Definition screen.  Each deduction 
> would be entered in a formula format and assigned a deduction varible 
> or tag name.  Example being for the FICA deduction, you could name it 
> FICA. For Barney Fife's child support, you could name it BFCS, etc.  
> You could assign each deduction an order of preference, if you so 
> need.  Some deductions would be pre-tax, some post-tax.
>
> We then move on to the employee definition screem, where you assign 
> the deduction tags to the employee.
>
> Then, a payroll generation screen, to select/deselect the employees 
> for that generation.  Once the generation is complete, you print 
> checks, and post.
>
> While I'm sure that I have missed some things, that is the general 
> jist of what I had in mind.  Funny this came up just today, because I 
> actually started work last night  :)  I spent the last few days with 
> the concept, and figured that with winter coming, I would have 
> something by spring.  Anyone have an thoughts?
>
> Kent
>
>
>
> Vicki Reeves wrote:
>
>> I'm thinking that an international payroll might be possible if it 
>> included lots of ways to adjust withholdings.
>>
>> For example, choices for each withholding might include:
>> * will this formula operate against gross (stage 1) or against 
>> 'almost net' which would be the total after all stage 1 adjustments 
>> are completed?
>>
>> * will this withholding be a percentage, a set amount or a user 
>> defined formula? User defined formulas could allow for things like 
>> ((gross - 241) * 0.125)
>>
>> * is this withholding applied every payperiod or event triggered? 
>> Perhaps this could be used to allow for once a month withholdings 
>> when the payroll is prepared weekly, etc.
>>
>> * what will be the title of this withholding?
>>
>> * to what vendor and account will this withholding relate?
>>
>> Since the withholdings are very flexable and you would be able to 
>> setup as many as necessary, this should take care of the tax type 
>> requirements of wherever and allow for things like garnishments, 
>> insurance, etc.
>>
>> Something similar could be used to allow for additions such as 
>> payments of child care allowances, commissions, etc.
>>
>
>
> -------------------------------------------------------
> 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
>
>