 In this presentation we will enter data into our earnings record from the payroll register. Here's our earnings record. We're going to have four employees. We have frozen the panes up top so we can see the panes are not moving from lines one, two, and three. Support accounting instruction by clicking the link below giving you a free month membership to all of the content on our website broken out by category further broken out by course then organized in a logical reasonable fashion making it much more easy to find what you need than can be done on a YouTube page. We also include added resources such as excel practice problems PDF files and more like QuickBooks backup files when applicable. So once again, click the link below for a free month membership to our website and all the content on it. We have four employees that we're going to be dealing with Judy Jones scrolling back up Jill Jackson, Cindy Lewis and Anthony Moore. We're going to pull this information from I'm scrolling to the left from the payroll register. The difference between the two we want to keep straight the payroll register is going to emphasize the pay period in this case the months we're going to be paying people monthly and then have the employees per pay period per month in this case whereas the earnings records is going to emphasize first the employees and then the pay period. So it's basically same information just flipped. So now we have the employee being the primary source of each earnings record and then the pay periods in this case were paying monthly related to that employee. So what we're going to do then is just create the earnings record from the payroll register. So if we scroll back over to the payroll register we're going to scroll down to the month of December that's going to be the current month we need to put in place. Note that this will give the current data for each of our employees for the current month and that's kind of enough to create the paycheck because we'll end up here with the net pay and that's what I will give to the employees. However it doesn't give the employees detail in terms of how much we've taken year to date so that's the information that's not on the payroll register which will be on the earnings records and that's why we need to reformat this data. So all we're going to do then is take this information for each employee and put it into the earnings record. Same it's going to be the same data but we're going to then transform it or transpose it to the earnings record. So first the first employee is going to be Anthony Moore. We're just going to take the same data and put it up into the earnings record for Anthony Moore. So if we scroll up we're going to have to do some scrolling here we'll learn a little bit on the Excel to the earnings record. So here's the earnings record and I'm in AB 8 so AB 8 for Anthony Moore. We're just going to fill out all this data the way this is formatted is that the columns will all be the same. So all we have to do is just use formulas to pull this number over. So we're going to be over here in Anthony Moore so here's the earnings record for Anthony Moore. We're in cell AB 8 where we will say equals and then scroll to the left and scroll down and we're looking for December. So December here's the first M I'm just going to pull over that marital status for December and enter. So I'm going to scroll over a little bit so there we have it. Now if we copy and paste that over it'll just copy and paste the relative references. So I'm going to right click and copy that right click and copy we're going to put it in the cells to the right of it all the way over to net pay and then right click and paste it the formulas. We want to paste the formulas if we paste it then the main one then it will overwrite this formulas and so and if we paste that won't work so we want to do the formulas only and there we have it. So now we've pulled over all this information and it'll tell us one what the information is per pay period what the regular pay is what the overtime pay is overtime and total earnings. It'll tell us how much was taken out for OASDI HI FIT group insurance and it'll give us the net check but also give us the year-to-date numbers. So here's where we're at year-to-date after that this last component. So that's going to be important that's why we're doing this. We're going to do this for the next employee same thing there's four of them. Cindy Lewis we're just going to pull over that data to the December area for Cindy Lewis. So we are in AB 15 where we will say equals scroll to the left I'm going to go all the way down to December and we're going to pull over that M for Cindy Lewis and enter. So we just pulled over this data in B 34 then we're just going to copy that I'm going to right click on it and copy it put it to the cell to the right go all the way to the end let go right click and we're going to paste the formulas so there are the formulas and once again we get the net pay for that pay period but also year-to-date net pay and and year-to-date and that pay period for everything else as well. So let's do that again Jill Jackson and so here's Jill Jackson's the employee we're in AB 22 we're going to say equals we're going to go to the left scroll down December there's Jill Jackson we're pulling this S in B 35 and enter and then we'll just copy that right click and copy and put that in the area to the right where we will right click and paste the formulas so again that'll give us the year-to-date total and the total for that pay period and we'll do this one more time for our last employee our the big earner Judy Jones okay so we're in here in AB 29 we're going to say equals go to the left and go down we're looking for Judy Jones on M and enter then we're just going to copy that M right click and copy and put it to the cells to the right and right click and paste formulas only and that'll give us that data and the year-to-date data so so remember what the goal here is on these two records they can be confusing because they look they're you know it's the same data it's just reorganized this is going to be in order by employee and then pay period in this case months and that's going to be the earnings record this is the earnings record and then this is the payroll register which is in order by pay period and then by employee