 in this presentation we're going to enter data into our payroll register for the third payroll period that being october for our problem it's going to be the first payroll period for the last quarter which will include october november and december in order to do that we're going to freeze the panes so we can see the data we are working on to do that we're going to go up to a four cell a four so scroll all the way up cursor on a four then we're going to go to the view tab up top windows group freeze panes button and freeze the pain okay so then we're going to scroll back down now now that we have no pain or frozen pains so we're going to go back to the payroll for october so we're going to enter in this information again that we're going to have the same information for the filing status and allowances and from here going forward we are in essence going to have the same hours and overtime and just enter this a bit more quickly we just want to get practice and show that there's a real repetition for the most part and not focus so much on on differences that could happen so that we can then get some data input in place and then move to um the year end information so these are basically going to be the same as the prior periods we'll just get practice and doing that's a little bit faster so that we can see multiple sections of data and see what repeats what differs what we really want to watch out for when we differ is going to be these caps what happens to these caps after we have more payroll processes that's really where you've got to be careful so we're going to scroll back up and we're going to these are going to be the same the m and the allowances unless there's any changes then those will be the same so unless anyone adjusted their w four information so i'm going to copy that information right click if i do it right click i was going to or control c and then scroll down and we're going to put that in b 19 right click and we want to paste just the form just the abc not the form well we can paste the format anyway either one whichever you like and then we're going to go to the regular hours and that's going to be we're going to say is 163 and we're going to say that 25 is the rate for more regular pay and note this this should mirror we're basically going to be mirroring what happened up here that won't be the case when we have hourly employees they may have different schedules that are very from time to time or maybe very consistent depending on our who we are working with if we have salaried employees it could be very consistent so it just really depends on whose payroll we're talking about as to how varied their schedule will be for month to month or pay period to pay period we are now going to have a very consistent schedule so that we can just show the same data and put this data in a little bit more quickly and and push forward with it and the rates actually not 17 it's going to be 25 dollars okay and then as we do this i'm actually going to make this green too so we'll make this all green so that we know where we're which data set we're working on so i'm going to highlight from b19 all the way over to um x22 right click and make that green so that when we when we go back and forth we'll be able to see that we'll have to go back and forth a little bit more than the prior i don't mean it's registers as we'll see here so then we got the regular pay which will equal the 163 times the 25 dollar rate we're going to go through this a bit faster so if you want to slow down on a couple of these look at the prior months it'll be much the same type of calculations the overtime hours we're going to say are three the overtime rate is going to be the 25 times one and a half percent or 150 equals the 25 times 1.5 or 150 percent so tab that's the 37.5 now note because we're doing the same thing here we could copy this stuff down because the rate will be the same and the payroll will be the same but we're going to go through the calculations a few more times because this is where we really want to focus in on these calculations of payroll so then we're going to say the overtime pay will equal the three hours times the 37.5 g 19 times h 19 tab total earnings then are going to be the regular pay plus overtime so total earnings equals the regular pay plus the overtime and that will give us the 4187 50 now we got to go to the other types of earnings and see if we hit the cap it would differ if we hit these caps now i'm not worried about hitting the cap here this employee is not going to get up to the 128 400 but we do have to worry about Futa and Suta so in other words the OASDI or social security wages equals the same number remember that the OASDI could differ from total earnings in a case where we have a pre-tax item such as if the group insurance was a qualified cafeteria plan which would be a section 125 plan in this case we're saying the group insurance is not a section 125 plan and therefore will not be reducing the FIT income federal income tax social security or medicare it will however be a post tax deduction and calculated in the calculation of net income now the Futa although this number is under 7000 we have to go to the earnings records the year to date earnings to see if this employee has already met that that Futa cap to do that we would go all the way over here scroll back up and we're looking for Anthony Moore has earned over 7000 in other words if we go to the Futa it's already been completed he's already at the Futa cap so we don't want to include any more Futa so if we scroll back down to where we're at the green area over here we're gonna say that Futa needs to be zero and if we put something in Futa there we're gonna end up paying Futa taxes and we'll overpay Futa and then we'll have to adjust it and amend it and then Suta is the same thing so Suta if we go over to the earnings records for this employee scroll up to the records for earnings we see that he's over 8000 here and we can see that he's over 8000 here so it already he's already hit the cap there so I'm gonna scroll back to the left we're gonna scroll back down and say he's already hit the cap there so that means in other words no Suta OASDI wages now we can calculate our taxes it's gonna equal we're gonna point to the OASDI times 0.062 tab HI is gonna equal the total earnings because there's no cap times 0.0145 FIT we would be getting from the tables here and we but now since we have the same earnings going back here I'm just gonna pick up the same earnings just because we don't want to take the time to go through the tables again so we've already looked at the tables it's the same earnings here and that's one of the reasons we'll keep the same data so we'll say the FIT I'm just gonna say is equal to the prior FIT because we have the same earnings okay got it so now we're gonna go to group insurance it's gonna be the same as the prior year the union it's gonna be the same as the prior year it's not the prior year by the way prior pay period prior month in our case the 401k it's gonna be the same as the prior month and then the net pay we're gonna calculate uh so should be the same as prior month too but we want to calculate that that's gonna be the total earnings minus everything that we're taking out of the total earnings to get to the net pay formula being equals SUM uh i'm sorry no it's equals and we want the total earnings minus SUM double click the sum function and we'll highlight the OASDI to the 401k and it's gonna close it up that's okay good so there it is there so 2052 and 36 cents if we scroll back up that's going to be the same calculation as up there okay so now we're going to go to the employer portion of social security so it's going to be the same remember but we're going to calculate it again equals the OASDI wages times 0.062 hi is going to equal the total wages times 0.0145 tab these two should match what the employer portion was futa equals the futa wages which is zero times 0.006 and we don't need to obviously the formula there but it's nice to have the formula to have everything in conformity so if i was to copy and paste anything it would be uniform even though it's going to be zero and we already know that suit is going to be this times 0.054 so there we have this so let's go to the next employee now we're going to say we've got Cindy we're going to say Cindy is going to be 161 hours rate 28 multiplying this out i'm going to do this all with the keyboard rather than the mouse now equals going left two times to that 161 d20 times going left once the 28 and then tab and then we're going to go to one overtime hour we're going to calculate overtime pay all with the keyboard here so i'm not going to use the mouse at all we're just going to say equals left left left on the arrows to the regular pay in e20 times 1.5 time and a half 150 percent tab uh overtime rate then i mean overtime pay then will equal left left one that one in d20 times left once the 42 tab total earnings then will equal left left left left regular pay plus left once overtime pay tab so there's going to be our total earnings now again she's not going to have uh Cindy's not going to have any problem we're not going to have a problem with her getting up to the 128 so it's going to be the same here for oasdi wages futa however once again if we scroll over we have to we she's over under 7 000 here but we have to look at total earnings to date which is on the earnings records so if we scroll over here up to Cindy we see her total earnings are over 7 000 and she's hit both 7 000 and 8 000 for the futa and suta caps so we have no more futa or suta wages in other words so if we scroll back over we're going to say futa zero suta zero oasdi we can calculate now i'm going to say equals go left left left to the oasdi wages times 0.062 tab hi equals total earnings left left left total earnings times 0.0145 tab f it equals the same as the prior period up up up that 235 tab i'm gonna scroll back down so we can just see our data here group insurance is going to equal up up up up same as prior period for Cindy tab union dues up up up same as prior period 401k equals up up up up up up same as prior period uh net check we'll calculate here so i'm going to do that all with the keyboard now we're going to say this equals left left left left left left left total earnings minus sum shift nine there's our sum function left left left left left left this uh deductions for social security holding down shift now right right right right all the way to the 401k and then shift zero close that up so there's our our formula with just the keyboard now we'll do the oasdi we're going to calculate it again equals this is the employer portion left left left left left left left left left oasdi wages times 0.062 tab hi medicare equals left left left left left left left left left to total earnings times 0.0145 tab now if you couldn't see that i'm gonna here it is here it's also up here in the formula bar so if you it's all it's always there when we do the calculation so this is going to be 0.006 futa so equals left left left left left left left futa times 0.006 tab su ta equals left left left left left left left left left left left left times 0.054 tab and of course those are always going to be zero now that we've cleared the the futa and su ta caps of seven and eight thousand respectively back to the next data the next individual next employee jill uh we're going to say jill uh same status 140 uh the rate is 31 multiplying this out equals left left times left once tab over time zero tab over time rate equals left left left to the regular rate times 1.5 tab over time pay then equals left left to the zero times left once to overtime rate tab total earnings equals left left left left the regular pay times left once the overdone pay tab again we're uh something went wrong there let's do that again equals you wouldn't be happy with that left left to the 4340 plus left once tab i must have multiplied that okay so that once again we're not worried about jill hitting this cap of 128 400 so the oast ag wages are just equals the same amount 7 000 has jill going over the seven and eight thousand cap we have to look at the earnings records let's go to the earnings records we're gonna say you're looking for jill over here oh jill where's jill here's jill so jill is over seven and eight thousand before this pay period and is at the cap for seven and eight thousand respectively so it should be zeros for jill for suta and futa wages so back to our green records we're gonna say this is zero zero oast i calculation equals left left left times 0.062 tab hi medicare equals left left left left times 0.0145 tab f it equals because we didn't make any change from last year we'd have to get this from the table but we're just gonna pull it from last year because it's the same income that 474 tab group insurance equals same as prior tab the there is no uh none of that equals for 401k tab and then the net check will calculate down here because it's good times to do so equals left left left left left left left left all with a keyboard here left there's our total earnings minus the sum s um shift nine then i can go left left left left left to the oast i hold down shift go to the right right right right right and highlight to the 401k shift nine to close it up and enter okay and then we're gonna do the oast i for the employer equals left left left left left left left left left oast i wages times 0.062 tab hi or medicare equals left left left left left left left left to the total earnings times you can see it up here 0.0145 145 tab tab i think that's okay and it should be the same number so it looks good futa equals left left left left left left futa is zero times 0.006 tab equals suta left left left to suta times 0.054 enter all right now we're going to do this for one more employee down here we're going to go to judy jones the owner here who is a salaried employee so we're just going to say salary regular pay 35 000 a month overtime pay it's just going to equal the same as the regular pay total earnings over time sorry that's not true the total earnings will equal the same as the regular pay now she we're worried about her getting over the cap of 128 400 it's probably going to happen maybe not this time period let's go check so if we go over to our big owner here in the company judy is at 70 000 so she's not to the cap yet at this point in time she's clearly over the 7 000 and 8 000 so she's hit the suta and futa caps so we're going to go back over here and enter this data so still first for social security wages equals the same suta or futa is zero suta is zero o asti is going to equal left left left o asti wages times 0.062 h i or medicare equals the total earnings times 0.0145 tab f it equals the same as last pay period tab group insurance equals the same as last pay period equals or tab not a union workers and the 401k equals the same as the prior pay period tab net pay we're going to calculate once again all with the keyboard equals left left left left left left left total earnings minus sum shift 9 for the brackets left left now we could do this faster by going to the left once and then so starting from the end point holding down shift left left left left go into the hi so it doesn't matter if you highlight left to right or right to left in other words it's still the same you can see the formula is the same it's the squares defined as n 22 or it's a rectangle the n 22 colon s 22 shift zero and enter so then we're going to go to o asti for the employer equals left left left left left left left left left times 0.062 hi medicare for the employer equals left left left left left left left left left left left times actually not that one we should be picking up this one that's kind of important times 0.0145 not important yet but it will be so we want to be consistent tab and then fruta equals left left left left left left this number times 0.06 su ta equals left left left left left left left times 0.054 okay so there's going to be our information for the pay period of october last thing we should probably do is clean this up and make it blue again now i'm going to just copy the formatting from this cell up here so that uh because notice we didn't keep the blue from last time this blue blue which is a different blue so i'm going to highlight that i'm going to paint and make that's this color which is one of our standard colors so that one's always there and then i'm going to paintbrush to to ungreen our other one so i'm going to highlight the whole thing not just one cell want to highlight this whole group and then go to the home tab paint brush it and then i'm going to scroll back down and i want to highlight this whole group so that the formatting not just the color but the formatting for the whole thing is this is equivalent so let me never have that okay so there is that the end