 430 we solve them all so we're going to make our periodic adjustment as of the end of the month we're always going to do it as of the end of the month for the sales side on a periodic basis you might do it weekly but monthly is quite common let's say it's at 430 I need to format this in the date format so I'm going to right click on it right click and format this as a date format I'm going to take the years off so 430 430 okay and then we're gonna sell we sold the total amount of three units but once again I'm gonna put them on the books one at a time so I'm just gonna say one unit at a time and I'm gonna pick the cost up each line item so there's the $20 that we are picking up and basically I notice it's trying to copy down you got to be careful with the table when you when you add formulas because the table will try to basically copy it down I didn't want it to copy that down so I'm gonna undo that bit so I undid that and then and so now I'm gonna I'm gonna copy the same thing just to those couple cells I'm gonna copy this to these cells so there we have it so now we've sold all three units so the unit balance at this point in time I'm just gonna say was one we sold the one so I was gonna go down to zero once again it's trying to copy down so I could undo that so it doesn't copy it down and then I would like to be the one that copies it down just to those number of units and then the ending inventory is going to be then the I usually do it as the cost minus the cost so it goes back down to zero as well and then it's copying it down so I'm gonna undo that and then I want to copy it down to make sure it doesn't mess up if I had any other rows in the table so we sold all of those basically have been sold out and then we're gonna say on the other two items that we didn't sell any of the of the other items at this point in time so now if I look at my total inventory I can say let's bring this back up and bring in all of my inventory I'm gonna remove the filters or select all of them so there we have it and let's pull these ending balances all the way down now so I'm gonna say let's pull these down and so there there they are so now we've got our ending balance here's our ending inventory summing up to 2810 okay we can summarize this in a table I'm gonna go over here and try to make this I'll make this a skinny column and then let's put a little table together and for our summary table and I'm gonna put my headers over here I'll say this is product one which I might be able to get by just well let's just type it in here I'll say product one product two and product three and what do we have thus far we've got all three products and then I'm gonna say this will be the unit balance and then ending inventory and let's do this and let's make this a header I'll make this black and white black and white and I'll make this black and white and this black and white or alright wait I missed it I didn't click on it alright and then we're gonna say the number of units we're gonna use a fancy formula here to do this but it's not too bad it's gonna be equals to the sum if and I'm gonna use the ifs with an s brackets and then I'm gonna say that I want you to sum the units these units I'm just gonna select the entire column or I could select the entire table is to the table I want you to pick up this table I could see the criteria there's my range and then comma the next argument and then and then the criteria range that meaning sum everything in that area if this area I'm gonna pick up this table and notice I'm I'm put my little pointer there what has a down arrow because it's just picking up that table if that and then comma and then the next criteria ties into product number one so in other words the argument is I want you to sum up each one here which is just one unit if it's on hand still if it hasn't been sold if you can tie it out to this side where it says product number one there's not gonna be any ones here because they've all been zeroed out so there's zero let's do the same thing here equals I'm gonna say some if and I'm gonna take the one with the s ifs and I want you to take this range sum up this range comma criteria range which is going to be this range and you have to have that tie out to comma this criteria product number one and so if I say enter it picks up two items because we have these two that are summing up it's summing up these two that correspond to those two product product two let's do it one more time equals some ifs brackets the sum range is gonna be these unit ranges you want to sum those up comma to get to the criteria range this range and then comma if you see in that range a number three so then it's gonna give us four of those because we had four of these with a number three and then let's do the ending inventory similar kind of process we're gonna say equals the sum ifs brackets I want you to sum the ending inventory range here comma if similar process if this product range comma criteria has product one in it so once again it's zero because it's summing these up which are gone and there's nothing of product number one left do it again here equals the sum ifs brackets some range ending inventory comma criteria range here finding the products comma and then the criteria is product number two so there's the 210 210 representing product two product two adds up to 210 for those two line items on product two and then once again equals the sum ifs bracket some range here comma and then the criteria range here comma and then if there's product number three enter and so that's gonna be 2006 which is basically the 650 per unit times four units of product number three and then we could have a total total at the end to make that black and white and centered and we could say some just a normal sum this time this way some that way and then we can also put some brackets around this so that's where our ending inventory should be and therefore we can just do an adjustment now I can go back on over now we can also do that table with a pivot table so we'll get into that more later but right now I just want to do the journal entry real quick because we're running low on time we've got 2872 over here so 2872 is what we currently have in the inventory and if we subtract this out that would be our adjustment we need to we need to decrease it by $62 which kind of makes sense because we sold these three items cost a good sold is the 60 is the $62 right so I'm gonna go back on over and say alright let's go back on over here and just do it with a journal entry new button and we're gonna do the journal entry monthly instead of just like at the end of the year I'll just do a journal entry and say this is as of the end of 0 4 30 to 4 and we're gonna say that that costs of good sold is gonna be here and that was for $62 and then we've got inventory is going down at $62 and both