Two different brackets system

General support regarding TimeTrex, such as
configuring policies/taxes or processing payroll.
bonhomme
Posts: 93
Joined: Tue Mar 11, 2008 12:30 pm
Location: The Netherland
Contact:

Re: Two different brackets system

Post by bonhomme »

bonhomme wrote:Dear Shaun,

In the attachment is the document requested. I am using one payperiod because we are tested the new version. But we at the moment we really would this feature to be part of the application.

B.Sanon
I just install an earlier version of Timetrex and it remains the same I am afraid that can be a burg in the application.

Greetings
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Two different brackets system

Post by shaunw »

Unfortunately we can't help you if you don't read my posts in full and answer all the questions that I have asked along with provide all the requested information as well.

You need to send us the entire TimeTrex.log file from your TimeTrex log directory only after you have deleted and re-generated the pay stubs.

You still haven't answered these questions.
What does your pay period schedule look like? How many pay periods in a year do you have? (attach screenshots)

Also what version of TimeTrex are you using? (exactly what version)
bonhomme
Posts: 93
Joined: Tue Mar 11, 2008 12:30 pm
Location: The Netherland
Contact:

Re: Two different brackets system

Post by bonhomme »

OK

I am testing the version 2.2.22 and the last version. I would like to let you know that we are using a old fashion payroll system but we are planning next year to move to Timetrex Business seeing the complexity of our administration.

We just want to be sure

Open attachment please
Attachments
timetrex_cron_last_executed.log
(22 Bytes) Downloaded 157 times
timetrex.log
(253.58 KiB) Downloaded 164 times
Pay_period.doc
(623 KiB) Downloaded 184 times
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Two different brackets system

Post by shaunw »

Okay, so according to the log file this is what is happening:

Code: Select all

DEBUG [583]:    <b>UserDeductionFactory::getDeductionAmount()</b>: Percent: 30.4 Wage Base: 250000 Exempt Amount: 9750<br>
DEBUG [1001]:   <b>PayStubFactory::getSumByEntriesArrayAndTypeIDAndPayStubAccountID()</b>: PS Entries: current Type ID:  PS Account ID: Array<br>
DEBUG [1468]:   <b>CompanyDeductionFactory::getPayStubEntryAmountSum()</b>: Type Amount: 0 Regular Amount: 2000.0000000000 Total: 2000.0000000000<br>
DEBUG [1001]:   <b>PayStubFactory::getSumByEntriesArrayAndTypeIDAndPayStubAccountID()</b>: PS Entries: current Type ID:  PS Account ID: Array<br>
DEBUG [1468]:   <b>CompanyDeductionFactory::getPayStubEntryAmountSum()</b>: Type Amount: 0 Regular Amount: 1055.1800000000 Total: 1055.1800000000<br>
DEBUG [1548]:   <b>CompanyDeductionFactory::getCalculationPayStubAmount()</b>: Include Amount: 2000.0000000000 Exclude Amount: 1055.1800000000<br>
DEBUG [1556]:   <b>CompanyDeductionFactory::getCalculationPayStubAmount()</b>: Amount: 944.8200000000<br>
DEBUG [1001]:   <b>PayStubFactory::getSumByEntriesArrayAndTypeIDAndPayStubAccountID()</b>: PS Entries: current Type ID:  PS Account ID: Array<br>
DEBUG [1468]:   <b>CompanyDeductionFactory::getPayStubEntryAmountSum()</b>: Type Amount: 0 Regular Amount: 2000.0000000000 Total: 2000.0000000000<br>
DEBUG [1001]:   <b>PayStubFactory::getSumByEntriesArrayAndTypeIDAndPayStubAccountID()</b>: PS Entries: current Type ID:  PS Account ID: Array<br>
DEBUG [1468]:   <b>CompanyDeductionFactory::getPayStubEntryAmountSum()</b>: Type Amount: 0 Regular Amount: 1055.1800000000 Total: 1055.1800000000<br>
DEBUG [1548]:   <b>CompanyDeductionFactory::getCalculationPayStubAmount()</b>: Include Amount: 2000.0000000000 Exclude Amount: 1055.1800000000<br>
DEBUG [1556]:   <b>CompanyDeductionFactory::getCalculationPayStubAmount()</b>: Amount: 944.8200000000<br>
DEBUG [609]:    <b>UserDeductionFactory::getDeductionAmount()</b>: Amount: 132.3200000000<br>
DEBUG [987]:    <b>UserDeductionFactory::getDeductionAmount()</b>: Deduction Amount: 40.2252800000<br>
What all that means is this:

- Wage bracket: Percent: 30.4 Wage Base: 250000 Exempt Amount: 9750
- Included Pay Stub Account Total: 2000
- Excluded Pay Stub Account Total: 1055.18
- Gross Taxable Wage for one pay period: (2000-1055.18) = 944.82 <-- Same as your example

- Exempt Amount based on tax bracket (9750/12 pay periods) = 812.50/pay period
- Pay Period Net Taxable Wage: (944.82/PP Gross Taxable Wage - Exempt 812.50/pp) = 132.32
- Resulting Tax for just this bracket: (132.32 * 30.4%) = 40.23

So TimeTrex is doing exactly what you've told it to do, however the error I see is in your own calculations you neglected to account for the 9750 exempt amount for this bracket.
bonhomme
Posts: 93
Joined: Tue Mar 11, 2008 12:30 pm
Location: The Netherland
Contact:

Re: Two different brackets system

Post by bonhomme »

Thanks Shaun,

Everything is working fine

Greetings

B.Sanon
Locked