 Normal starting point, home tab, font group, I'm gonna make it bold as well, just so it stands out, you don't have to do that. But when I'm recording, I'm told by my editors and producers that I have to be bold. Have to be bold, so I'm being as bold as I can. So there's gonna be the form, the account, and then I'm gonna say this is debit slash credit. And the credits I'm gonna say are gonna be negative. If my spelling is wrong, then I apologize. Okay, I'm gonna actually pull this down. I'm gonna say cut and paste it down here. I'm gonna scroll in a little bit. These are my headers for my journal entries. And I'm gonna make this my header label. So I'm gonna go up top and say home tab, font group, making this black and white. That's what I typically do with my headers. I'm gonna center this one, home tab, alignment, and center it. And so the first one we had, the forms are an estimate where there is no financial transaction. So in other words, nothing's being reported to my actual financial statements for that one. And then we had a sales order, where once again, let's skip a column, this is where the journal entries would go, but there is none because there was no financial transaction. And then we entered a purchase order, or order, and once again, no financial transaction. Okay, okay, on the right hand side, I'm gonna make my reports where I'm gonna put an E here. I'm gonna make my format where I'm gonna post my stuff. So I'm gonna make a skinny D and then skinny D, let's make it really skinny. And then I'm gonna copy the account, making that a little bit larger. And I'm gonna say this is the beginning trial balance which has nothing in it. These are gonna be my entries and then I have an ending trial balance. Let's just call it trial balance. And then I'm gonna pull this down. This is gonna be what we'll post it to just so we can see this. I'm gonna go home tab, font group, black, white, center, make this black, white. Okay, and I'll just add some accounts now so we can get a feel for what this is gonna look like. And then once we start actually posting things, we'll see the debits and credits. So we're gonna say there's gonna be a cash account. There's gonna be an accounts receivable. That's gonna be one of the key accounts that we'll have to deal with. There's gonna be an inventory account. Let's just call it inventory. And then there's gonna be an accounts payable account. And we'll just call it an equity account. There's gonna be an income account and there's gonna be a cost of goods sold, which I'm just gonna say cost of goods sold. And then that's gonna give us our total debits and credits. I'm gonna say the credits are gonna be negative in the worksheet, so I don't have to have six columns, but only three columns to do this. And then my net income. And I'm just gonna color code this thing so it looks fancy. I'm gonna make my assets green. So I'm gonna go up top and say home tab font group. I'm gonna make this dark green and then white. On my assets and then my liabilities, I'm gonna make those orange. Let's make that orange and white. Equity, I'm gonna make this lighter blue and then this white and then all of my expense accounts, income or expenses. I'm gonna make both of them the darker blue and then this white. And then down here, I'm gonna make this kind of like my header one, but now it's the footer black and white. Okay, and then I'm just gonna sum up. This is gonna start with zeros. There's nothing in the beginning balances. That's different than what's in QuickBooks because we had something in the beginning balances, but I'm gonna start with zero equals the sum brackets of this. And then my entries will be here and I'm gonna copy this across. And then the ending balance is gonna be equal to the sum of these two because my credits will be negative. So this is gonna be my little worksheet that we'll work on. And then I'll do some fancy formatting down here because I'll say that if this is between, if this is between negative one and one, I wanna make it green because then I'm good. If, because it's rounding, I'll give it some rounding between negative one. And if it's greater than one, it needs to be red. And then if it's less than one, less than one, negative one, hold on a sec, less than negative one, it needs to be red. So let's test it out. If this goes to one, it's good, but if it goes to two, red. And if it goes to negative two, red, okay, good. So that looks good. And then down here, the income is just gonna be this minus this. So I'm just gonna say this equals the sum of these two. I'm adding them up because the income's gonna be a credit or negative. And so I know I'm doing this fast, but I'm gonna copy this across. So this is gonna be my net income. And I want my net income, if there's income, it's gonna be a credit here, like a 100. And if there's an expense, it's gonna be a debit. So I don't want, now it looks like I have a loss. I don't, I have income. So I wanna make it not red. And then I'd like to indicate that it's good with green, even though it's a negative number. So I'm gonna say right click, I'm gonna format these cell and I'm gonna remove the number of currencies being negative and just make it normal. And then I'm gonna say conditional formatting, if this is less than, if it's less than, let's say zero, then we wanna make it green. It's actually good because that means the credits are greater than the debits. And you wanna green. And then if it's, let's actually make it less than, let's say this is gonna be, if it's less than negative one, so that that zero will be green. So I'm gonna make it green. I'm sorry, less than positive one. Then it's gonna be green. Okay, so zero is included. And then if I say this is gonna be, if it's greater than, if it's greater than, let's say zero, then I wanna make it red. Okay, so that means that if my, if my cost of goods sold was at 150, this would be positive. And it turns, this, it didn't turn red. Okay, Paso. Let me do that again. Conditional formatting, if this is greater than one, we want it to be red. Okay, so this turned out to be 150, it turns red. Okay, I don't know exactly what I did there, but there it is. Let's bring this back to zeros. And then I like to make my little worksheet where I'm gonna be doing data input blue. I'm, so I'm gonna right click, I'm gonna format the sales for my data input, or let's do it this way. I'm gonna go to the home tab font group bucket dropdown. My blue isn't there. So I go to more colors and standard colors. I like that blue right there. That's the one I've worked with for a long time. So that's the one I use. You can use something different if you want. I'm gonna put borders around it, border blue. Do the same thing here, home tab font group border blue. And then I'm gonna put borders around this whole thing. Okay, so there's a little worksheet. I know that was kind of a long tedious worksheet, but I think it's useful to set up. Hopefully it'll make more sense. It might not be what you're kind of used to because it has debits and credits on one column, but hopefully that'll make sense. And we'll play with that in the future.