 In this presentation, we will enter data for the earnings records for August. Now in the last presentation, we did the payroll register, which gives us the information by employee per pay period. But we also need to track this information to sum up how much someone has earned during their time here. In other words, this will give us the information by employee on the payroll register for a particular pay period, which we need on the pay stub when we give someone a paycheck. We need to tell them, hey, this is how much you earned. This is how much we took out of it. There's your net pay. But we also need to know the year to date totals, which of course will be the same after the first pay period, but we'll differ later. In order to do that, we can't get that information from the payroll register. We have to use an earnings report. Basically the same information is just going to be formatted a bit differently. We put that over here. We scroll into the right. So this is going to be the earnings records. Now the earnings records oftentimes will have the data and the social security number and the name, the allowances on it. We're going to make everything as simplified as possible just to line up to the earnings record to the payroll register so we can see this information in our main goal is really to see it so that we can see what would be needed in order to fill out the pay stub as we enter this data and pay the pay periods out. So what we're going to do is just pull the same information into each employee. It's a similar worksheet. You can see the subtitles are going to be much the same so that we can pull this over as easily as possible. We'll use formulas to do so. And what we're going to do now is not break it out by pay period. It's by the employee. So here's the employee. Here's the pay periods August, September, October, November, December. All we have is August so far. Here's the next employee, Cindy. Here's the pay periods. Here's the next employee. Here's the pay periods. So we're just going to fill up August for each employee. So if we scroll back up, we're just going to basically pull this information over. So the filing status for Anthony, if I scroll back over, I'm just going to pick up that same married filing status, same number of allowances. So all these are going to be in essence the same. So if I go back over here, I'm going to do this with a formula. I'm in AB4. We're just going to say that this equals, scroll all the way over, and pick up that M for married in B5 and tab. So in essence, it's a formula going to B5, B5. Now what we're going to do is we're going to pick up all the information for this month, for this month for Anthony. Now if I scroll back over, it's all in the same format. So we've got the allowances, the regular hours, the regular pay. So we could highlight this whole thing and just copy it over. I'm going to do it with a formula. So we've got the formula picking up this cell. If we copy it to the right, it should just pick up the cell to the right of it. And we should just be able to pick up each cell. So let's see if we can do that. I'm going to scroll back over and we're going to put our cursor on this cell. I'm going to right click on it and copy, right click and copy. Now I'm not going to auto fill it across because I don't want it to change the formatting of the cells. I just want to copy the formulas over. So it picks up the formula but doesn't change the formatting. So then we're going to select from cell C4 or AC4 all the way over. Every cell after that, go into net pay, let go. So here's our selected area. We're going to left click or right click on the selected area. And then we're going to paste it, not normal because that'll paste both the formatting and the formulas, not one, two, three, because that'll give us the values. If we use just the format, then just the formulas, it should pull over the formulas and keep the format of the cells. So we want to paste the formulas. And so you can see what it did here. We still have the regular hours now, not having a dollar sign, having the dollar sign here and having the cell centered. So that's what will, the way we will do this. So it gives us the same information. We just pulled it over. We don't get to see the formulas over here this way, but the formulas are already calculated in the register and we can just pull this information over. Now the benefit here, of course, is that on our earnings records, we can give them the earnings for the time period and we can give them earnings year to date, which is the same right now. It will differ later. Okay. So then we're going to do the same thing. We did that for Anthony. We're going to do the same thing for Cindy. So Cindy in August. So the first pay period for Cindy AB 11, we're just going to say equals. I'm going to scroll to the left and find her filing status, which is in B6. So B6 enter. So all we did is go to Cindy and pick up cell B6 equals B6 and then we're just going to copy and paste. I'm going to right click and copy right click and copy and then select everything after that from CAC 11 all the way over to the net pay right click and paste it with the formulas, just the formulas. And then we have that information. So we'll do the same thing. Note the totals will be down here for Jill. Same information will be an AB 18 equals going to scroll to the left, going to scroll back up. We're going to pick up the S single for Jill. And then we're going to say, if we double click on that, we picked up equals B7. That's the cell going to right click on it, copy it. And then we're going to put an AC 18 all the way over to AT 18 right click and paste just the formulas. Then we'll do the same thing for Judy. Last one. We're an AB 25 August for Judy Jones equals, I'm going to scroll all the way to the to the left all the way up, pick up the married status related to Judy on the payroll register and enter. And then I'm going to copy and paste that all the way across. We're going to put a cursor on AB 25 right click and copy, but our cursor on AC 25 all the way to the end, right click. And we're going to go to paste 123 or I'm sorry, paste formulas only, paste formulas only. And there we have that. So if we were to sum this up, we could get a check figure then if we were to add all this up. So if we go down to our totals down here, I'm just going to sum up for all of our employees and see if that kind of matches what is over here. I'm going to scroll to the left, scroll to the right. So we have our totals down here. We could match that out right now. And that could give us kind of a check that this is in there correctly. So if we scroll back down, for example, if we go to the third quarter totals, I'm just going to go totals for the year, which is going to equal when I scroll up everything that we have so far for Anthony, plus everything we have for Cindy, plus everything we have for Jill, plus everything we have for Judy Jones. So there we have it. The formula is AF9 plus AF16 plus AF23 plus AF30. Comes out to 487.19. If we scroll back over up here, we get 487.19 for regular pay. So let's do that all the way across and we can kind of double check some of our numbers. I'm going to scroll back down. Now the formula is going to be relative the same if we copy it, if we copy and paste it. So if I copy this formula here, it'll pick up the same cells relative, meaning it'll pick up this cell, this cell, and so on. So what we'll do is I'll right click here, copy, and then I'm going to put the same calculation all the way across down here, from here all the way over. I go, we're going to right click and paste, and we could just paste the formulas again. It shouldn't really matter. They're all dollar amounts this time, but we'll paste the formulas. I'm going to make these cells a little bit larger. And then we'll double check the main, here's the 488.90 for the total earnings and notice Suta earnings are the same, but the Futa is less. So Futa earnings are 20,896. So if we scroll back over, double check that here, total earnings 48,896 and the Futa 20,896. So that looks pretty good. If we look, if we look at our net check for everything, kind of like the bottom line number, 28266.11 over here on the register. And if we scroll back over here on the earnings record for everyone, 28266. So that can give us a little bit of a check and note, we have to do this of course once again so that this information for the totals each employee can be summed up and be on the payroll, pay stubs and reported, whereas if we look at the register, we have only one pay period of information per employee per pay period. So we have to sum that up just a little bit opposite here. We got the pay periods and then the employees and the payroll register over here. We have the employees and then the pay periods, which is kind of reversing that ordering to get the summary data, the end.