 In this presentation, we're going to enter data into our payroll register for the month of November. It's going to be similar to the prior time periods and therefore we're going to enter this a bit faster. So we're going to enter the data into November. We're going to copy and paste some more of the data representing the fact that it will be repetitive for the most part, although we need to be very careful on certain things that will change from pay period to pay period, which is where we will spend our time, including the OASDI wages, the FUTU cap, and the SUTA cap. Gotta be careful on those. Okay, so if the screens are not frozen, we're going to freeze the panes first. So we're going to scroll up top and then we're going to put our cursor in A4. So we're in cell A4. Then we're going to go to the View tab and we're going to go to the Windows group. And we're going to freeze the pane, selecting freeze pane and freeze panes. Now that the pane is frozen, it'll be a little bit easier to work and we'll scroll back down. Hopefully it will. That's the point. We'll scroll back down to November here. So here's our November data. We're going to pull some of this data from the prior time period. So I'm going to scroll back up just a bit. We're going to pick up the filing status and the number of allowances. Those are pretty commonly the same. So we're going to just copy those, right-click, copy, scroll back down, right-click, paste 1, 2, 3. When would they differ, by the way, if someone changed their W4 information. Now we're going to say that the pay period is even the same for these four employees, meaning we have a very standardized pay set. We're going to say that they worked 163 hours again. So I'll copy that, even these hours. And we're also going to copy the rate. So I'm just going to copy this whole thing. So we're going to copy the hours and the rate. We're going to say the hours will be the same, right-click and copy. Now again, it would depend on what type of employees we have to see if the rates would be much the same from pay period to pay period. Sometimes they are very similar, especially if they're salaried employees than they will be. And sometimes they vary greatly. So it just depends what industry we're in. We're going to right-click in D26 and paste either way should work, 1, 2, 3 or not. I'm going to recalculate the regular pay and the overtime pay just to practice that. So we're in F26, we're going to say equals left, left the 163 hours times the regular pay enter. Then in F27, equals left, left the 161 hours times the regular pay enter. And then in F28, we're going to say equals left, left the 140 times the regular pay and enter. And then the regular pay for Judy, remember, is 35,000. So there's the 35,000. The overtime hours, we're going to say are the same as the prior pay period. So I'm just going to copy the prior pay period, right-click, right-click and copy. You can also use control C and go down here to G26, right-click and paste. Either one should work, 1, 2, 3 or normal. Then we'll calculate the overtime rate, the overtime rate, which will equal this 25 and E26 times 1.5 or 150%, 1.5. And then the rate for Cindy will equal the 28 times 1.5, 150%. And then the rate for Jill will equal the 31 times 1.5. And then there's no rate, of course, for Judy. Then we'll go to the overtime pay, which will just equal the 3 hours times the 37.5 enter. And then for Cindy equal the 1 hour times the 42 enter. And then for Jill equals the zero times the 46.50. Then we don't have anything for Judy Jones. And then total earnings will be in G26 equals the regular pay plus the overtime pay enter. And then for Cindy equals the regular pay plus the overtime pay enter. For Jill equals the regular pay plus the overtime pay. And for Judy will equal just the 35,000 salaried pay. Okay, so now we're in the OASDI. Now we need to check these because these could differ. Now, we don't have to worry about these three going over this OASDI. It doesn't look like they're going to make over 124. But Judy may, I mean, that's Judy, right? That's Judy. Yes, she may. So we have to check that one for sure. So these three, I can basically say this will be the same. This will be the same. This will be the same. This one could differ. I want to check her earnings records. So we're going to go over to the right to the earnings records and see if she's over that limit. She's currently at 105. So not quite there yet. So this 105, which means that let's do some math here. If we take the 128-4 minus the 105, there's only 23-4 to get to the cap of 128-4. So therefore, we need to record just that 123-4 to get up to the cap. And we can't record the full 35,000. So this is where we really have to be careful not to miss that or we'll over withhold both on the employee and employer portion. So we'll scroll back over. And so this is where we hit that cap. So we're going to say that this is only 23-4. And so that's, that's important to note. The Futa and Suta for all employees, if we go to Futa and Suta, they should have hit this already because we're past that point in time. So in other words, they're over the 7 and 8,000 and they're both here. So we've got the 7 and 8,000 over the 7 and 8,000 here. Here's this. We're over that. Here's the 7 and 8,000. Here it is. And we're over there. Okay, so there's zeros in other words for Futa and Suta across the board. So 0000 there. And same here 0000 and zero. Then we have the OASDI, which is going to be this column times 0.062. So this equals left, left, left, this column times 0.062. Same for the next employee equals this column times 0.062 equals this column times 0.062 equals this column times 0.062. And there we have the social security. With HI or Medicare, we're going to just say this equals and we're going to scroll all the way to the total column times 0.0145. We'll do the same thing for the next employee. This equals all the way to the total column times 0.0145. Same thing here. We're going to say equals all the way to the total column times 0.0145. And one more time equals all the way to the total column times 0.0145. Now we can copy and paste, which we'll do next month, but I just want to calculate the formulas at least one more time. And then the FIT we're going to say is the same because we had no changes. These would come from the table, but we're going to say this is the same as the prior period because the net income is the same. So it equals the same as the last month equals the same as the last month, which is the last pay period equals the same as the last month, which is the last pay period equals the same as the last month, which is the last pay period for all of them. So here's with the FIT the group insurance will be the same. So the group insurance equals the same as the last month equals the same as the last month equals the same as the last month and the the same as the last month for the four individuals same for the union we're gonna say this equals the same as the last month and equals the same as the last month for one K we're gonna say equals the same as the last month as well as the second employee same as the last month third employee same as the last month and the last employee same as the last month then we'll calculate the net pay so net pay is going to equal we're going to go all the way over to the total earnings i'm going to do this a couple different ways this time we'll do it the long way first minus the OASDI minus the HI minus the FIT minus the group insurance minus the union dues minus the 401k now we'll do our our sum function within this formula for for the second way we can come to the same type of calculation equals all the way over to the total earnings minus the sum shift nine and we're going to go all the way over from left to right this time the N27 social security hold down shift and go right to the 401k and then shift zero to close it up similar formula we're going to say equals same formula similar way of doing it going all the way to the total earnings minus the sum SUM shift nine left once now we're just going to go from left to right hold down shift left to right the OASDI close it up all the same way to get the same calculation tab this third way is the fastest and the fourth way will be the fastest of all which is just to copy the formula down i'm just going to put my cursor on the auto fill here and just drag it down that's what we'll do most of the time next month and that of course will give that same formula and it'll it'll change the relative references which is very nice okay so then we're going to go over to OASDI same thing we're going to say this equals scroll over to the OASDI wages times 0.062 equals scroll over to the OASDI wages times 0.062 equals scroll over to the OASDI wages times 0.062 equals scroll over to the OASDI wages times 0.062 that too we could copy the formula down as we'll do next month. H.I. equals, I'm going to scroll all the way to the earnings times .0145. You can see the calculation up top here. Enter equals all the way over to the earnings for the next employee times .0145. Enter equals all the way over to the earnings times .0145. One more time equals all the way over to the earnings times .0145 and enter. Now FUTAM is going to be zero for all of them so I'm going to say equals go to the FUTA wages times .006 and I'm going to tab over and I'm going to do the same thing for SUTA and then we're going to copy them down. So I'm going to say equals the SUTA wages so SUTA times .054 and then we'll just copy these down. They'll be zero down across. I'm just going to highlight these two, put my cursor on auto fill and then copy that down. So that's a big quicker way to fill out this data. The end.