 Hello in this lecture we will work on journalizing transactions right here We're gonna journalize those transactions here and then we're gonna post them to three different places one being the quick post to The trial balance and this entry section so we can see the activity in a quick and easy way and see what the effect Is on the trial balance then we're also going to post it to the subsidiary ledger So these are going to affect accounts receivable much of the time and accounts receivable is Representing what is owed to us and therefore we also need to know who owes us the money So we're gonna start recording that to the subsidiary ledger, which will be in order by Client or customer in this case and then we're also going to record it to the general ledger So we want to see all of the type of activity that would happen when we're recording these transactions Focusing on the accounts receivable cycle So we're gonna see the quick reaction here to the trial balance directly analyze that Then recognize the fact that we do want to sort this by Customer in this case and that would be done through the accounts receivable subsidiary ledger And then of course we have the general ledger and we're only including the general ledger here for the accounts receivable account So we're not going to record Every general ledger account of course every other account here would have a general ledger account But we're focusing in on accounts receivable and therefore we're just going to record the general ledger account for receivable to distinction to have a distinction between that and The subsidiary ledger here. So of course we have our trial balance right here and that's gonna have our assets They're gonna be in green We've got our yellow or orange or our liabilities the equity count in the light blue and then we got the revenue And the expenses on the bottom We know that we are in balance because the debits minus the credits equal zero and we're gonna point post our activity here We also can see that net income is here This is actually income not a loss because it's the revenue less the expenses and there we have the income here And then of course we have our accounting equation up here where the assets are the green ones and then the liabilities Notice, there's no negative sign here because we flip the sign and then all of this is the equity That's the equity all right So now let's record these out so the first one says perform work on account and invoice the client and the client is Smith in this case So we got 35,000 we did work. We invoice the client So is cash affected in this case? No, because we did the work on account and we sent out an invoice did not yet get the cash Therefore we did get something we got an IOU that IOU being accounts receivable So we're gonna say accounts receivables what we have received in this transaction And that is an asset account. It's just in undercash and assets have a debit balances We need to make it go up. How do we make something go up? We do the same thing to it as what it is which in this case would be another debit So I'm gonna debit the accounts if I'm gonna copy that right click copy one two copy And then I'm gonna put my cursor in C5 and then right click and paste it one two three So we're placing just the values not the formulas just the values here We'll keep the cells looking like they are in that blue color and then we're gonna put the amount 35,000 Every debit is gonna have an equal number of credits for every transactions We're gonna have at least two accounts So we're gonna have a credit here We will be representing the credits with negative numbers or bracketed numbers in the Excel worksheet So we're gonna type negative 35,000 and I'm gonna hit enter and of course it'll format that cell for us with brackets because of Formatting of the worksheet then we just need to know what this Account should be and why are people gonna pay us 35,000 because we did work and earned Revenue and we could call this depending on the type of company revenue. We could call it incomes We could call it sales. We could call it fees earned It just depends on the type of company But it is going to be a revenue type account and of course it'll be down here in the revenue area I mean it's under the capital section on the Trial balance. I'm gonna copy that right-click copy that We're gonna paste that on the bottom credits traditionally go on the bottoms We are in cell C6 right-click and paste one two three So I'm gonna post this now to basically three different places I'm gonna post it here to the trial balance We can see a quick easy beginning and end at trial balance Then we'll post it to the subsidiary ledger at least the receivable side of it And then we will post the receivable side of it to the general ledger So let's do that now. We're gonna say the receivable is here. So right here's the receivable. It's the second account So we are in I6 and say equals and then we're gonna point to that 35 Thousand what's gonna happen? We'll go up here. We'll go out of bounds by the 35,000 So the 35 represents that customers over 35 and now we are out of bounds by the 35 We will then post of a revenue in I 14 So I 14 equals I'm gonna point to that 35,000 credit What will happen the credit will go up in the credit direction because we're doing the same thing to it We'll be back in balance net income is gonna go up from the transaction So we're recording revenue revenue is being recorded when we did the work not Necessarily when we get the money because we haven't got any money yet So now we're gonna record that same accounts receivable to the subsidiary ledger here So we need to record it by customer why because oftentimes when we look at the trial balance We're gonna say who owes us money or how much do people owe us people owe us 35,000 the next question We're gonna have is well when are we gonna get that money and who owes it to us? Let's call those people and to do that. We're gonna need to know the subsidiary ledger by The account receivable by customer using the subsidiary ledger. So here we have Smith We're just gonna record that same debit side to this account here in the subsidiary ledger I'm gonna say equals and that's gonna point to that 35,000 again Now try to also we're gonna have this stuff in the general ledger So I'm not gonna post the entire general ledger out, but just to recognize that there is a difference We're talking about something different in the subsidiary ledger than what we have seen in the general ledger The general ledger would be posting transactions in order By date or the order of the transaction. So we can post the same thing in the AR subsidiary on general ledger So we could say that this equals that same 35,000 and we see that the 35,000 in this section It's gonna be the same information that will be recorded here It's just that it'll be recorded slightly differently read here. It's only recorded by date right here. It's recorded by Customer and of course the end of it. We have the 35 here 35 is what's adds up all the customers that ties out to the trial balance All right next transaction We're gonna scroll over here and we're gonna say that's received cash on account from client Smith for work performed in the past So now Smith paid us this 35,000 so that would be the natural transaction that would happen Hopefully sometime in the future. We'd get a check in the mail. Therefore. We're gonna ask her questions Is cash affected? Yeah, we received money. We got cash cash has a debit balance We need to make it go up. How do we make something go up? We do the same thing to it which in this case would be another debit. So I'm gonna copy the cash We're gonna put that in cell C8. So I'm gonna right-click and put that in C8 and How much did we receive? 35,000 because that's that's what we billed them for 35,000 and so we're gonna credit the same amount So there's gonna be equal number of debits and credits and then we're gonna say well and Why did they pay us 35,000 because we did work but we did work in the past So we're not gonna credit the receivable account We already did the work in the past. They owe us of course the 35,000 that we put right in the receivable Now they paid us that they no longer owe us that therefore that 35,000 debit there needs to go down How do we make something go down? We do the opposite thing to it as what it is That's a debit therefore. We need to credit it to make it go down We already knew that because we debited cash. So that's where the credit's gonna go It's gonna make it receivable go back down to zero. So I'm gonna copy that I'm gonna paste it in C9 right-click and paste one two three values only in C9 Recognize what is happening here. We're just getting a better asset cash And we're losing the worser asset the accounts receivable. I know that may not be a word But it sounds good. So they've receivables going down cash is going up and No effect on revenue for this transaction. So let's post it out and see what happens We're gonna go up here to I five I five Equals and we're gonna point to that 35,000. What's gonna happen cash will go up by 35,000 because the debit and debit Makes a debit go up in the debit direction to 603,000 then accounts receivable there's something in it here I can see it in the formula bar. Well, of course D5 is in there That's the D5 here in order to post to it. I'm gonna double click on it Go to the end of it and say plus and then point to this 35,000 here and now we see there's two things in there There's the 35 debit the 35 credit ones a positive ones a negative ones a debit ones a credit That's gonna make it go down to zero again. So even though we have a zero there We can see what's in there and I like to use these icons to point to them And we can see okay that makes sense it went up and went down and if you want to know where those icons are they are in the formulas tab and they are in the formulas auditing and here they are here So then I can turn them off with this thing here. Alright, so we're gonna also post those out to the subsidiary ledger and So we're gonna say no one owes us any money right now Therefore we have to reflect that in the subsidiary ledger meaning Smith doesn't owe us any money anymore So we're gonna post that same activity in M10 So this equals the 35,000 and that means Smith no longer owes us So this would be the normal activity within a receivable account Of course it goes up and then hopefully they pay as it goes down. We invoice them. We got a check in the mail That's what should it should look like if we just look at that in the general ledger We'll post the same activity the general ledger again We're not gonna post all the accounts of course to the general ledger We would be posting both the general ledger cash and receivable in Real life we're doing the full problem But we're just looking at the receivable the accounts receivable GL account general ledger account and we are in the credit size We can say this equals that same credit the same activity By date so we don't know who necessarily by this 35 by this general ledger account But we can see that it went up when it went down We could probably make a safe bet that that's the same client and it may not be of course right next to each other in This activity we could have other sales involved, but that's the type of activity We expect to see in the receivable account much of the time So now of course we have zero here the subsidiary ledger adds up to zero and that's what's on the trial balance as well Next one perform work on account and invoice the client atoms. Alright, so we're gonna do work on account So is cash affected or we did work on account is cash affected and Answered no because we did it were on account and we issued an invoice when we issue an invoice That's because we did work and therefore we earned Revenue and we have received we believe we've received the intangible asset of an IOU called Accounts receivable so accounts receivables an asset has a debit balance just like cash It needs to go up because people owe us more money. How do we make it go up? We do the same thing to it which in this case would be another debit So we're gonna copy the receivable and right-click copy that gonna put that in c11 right-click and paste it 123 the amount being for 14,000 in this case if we debit something