Greetings Everyone,

I need your help with a FUTA payroll tax report. I've got it working - to a point!

The picture below explains my problem.

The futa tax should max at $56.00 but it doesn't.

Don't run away when you see my calcs below. I know it needs help!

FUTA Cal = Gross Pay*FUTA Rate

FUTA Excess = If ( Gross Pay YTD ≥ FUTA Max Wages ; Gross Pay YTD-FUTA Max Wages)

FUTA Excess Wages = If ( FUTA Max True=0;FUTA Excess ; 0)

FUTA Max = Round(FUTA Rate*FUTA Max Wages;2)

FUTA Max True = If(Gross Pay YTD > FUTA Max Wages;1;0)

FUTA Max Wages = Setup::Max FUTA Wages

FUTA Rate = Setup to::FUTA Tax%

FUTA Tax = Round(If(FUTA Max True;1;FUTA Cal);2)

FUTA Taxable = If (Gross Pay YTD ≤ FUTA Max Wages;FUTA Max Wages-Gross Pay YTD)

FUTA Taxable Wages = If ( FUTA Max True=1 ; 0 ; SumGross-SumFUTA Excess )

FUTA Tax Rate = .008 and Maximum Taxable wages is 7,000

Thanks so much!

Deb C.

Yeah, I may have an error in that calc. Let's re-write it and see if the logic makes sense:

Let([

//Gross Pay YTD is the sum of all pay including this week's. So let's subtract this week's pay and get all pay up until this one.

prevPay = Gross Pay YTD - Gross Wages ;

//what wiggle room do we have between our old pay and max wages?

availablePay = Max Wages - prevPay ;

//but let's not let that number be less than zero

availablePay = Max ( availablePay ; 0 ) ;

//which is less, available or actual pay?

taxable = Min ( availablePay ; Gross Wages )

];

taxable

)

The result of this calc is the taxable wages. Multiply that by the tax rate.