 seven right click and paste it one two three the amount being four fourteen thousand in this case if we debit something 14,000 we're also going to credit something 14,000 so I'm going to go and sell e12 negative for the credit for this worksheet 12,000 no commas or anything push enter and that will format the cell with the brackets and then we just need to know what that account should be here and of course why are people going to pay us 12,000 I'm sorry 14,000 should be negative 14,000 so why are people going to pay us 14,000 in the future because we did work and earned revenue or income or sales depending on what we do we can call it whatever we want but it's in the revenue section and it's going to be a revenue type account meaning it has a credit balance and revenue accounts generally only go up so how we're going to make it go up we're going to do the same thing to it which of course is another credit so we're going to credit the revenue account we always credit revenue only gets credited so I'm going to copy that I'm going to put that on the bottom in C12 right click and paste it one two three so then let's post this out again we're going to post it to our three locations so let's first post it to our trial balance so we're going to go into the receivable there's a zero in it so we don't want to delete the zero even though it's a zero because I know there's two things in it there's D5 plus E9 and I'm going to double click on it go to the end of it and so and then go plus and point to the new receivable 14 that way we can see the activity in there when we hit enter we goes up by 14 takes us out of balance by 14 we can then see the activity that is in there like so and then we're going to post the other side to the revenue once again something's in it E6 is in it so we can double click on it go to the end of it and then say plus and point to the revenue the credit of the 14 what's going to happen it's going to take revenue up by the 14 put his back in balance so revenue which is the credit minus the debits is now went up to 137 855 all right so now we're going to post this same thing out to the receivable accounts this was Adams down here so we're going to be down here in the receivables in the debit side I'm going to post this same activity out say Adam owes us money so now we can answer the question if we say who owes us money how much do people owe us 14,000 says on the trial balance who owes us 14,000 well we have to look at the subsidiary ledger and we can see now that Adams is the one that owes us the 14,000 we also will have that activity by date on the GL for all accounts so on the GL we can post that same activity would look like this for the receivable equals the 14,000 and enter and now of course the receivables in the general ledger ties out to the receivable on the subsidiary ledger ties out to the receivables on the trial balance so all that activity is there and once again note that we would have a receivable account for all the trial balance I mean a general ledger account for all the trial balance accounts as well all right so let's see what the next one is we got deep form work on account and invoice the client Ryan so same activity we did work and we invoice the client so is cash affected no we invoice the client we haven't got the cash yet but we did work and therefore people owe us money the account that people owe us money is represented by the accounts receivable account it has a debit balance represented by the fact that it has no brackets in the number and we need to make it 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 I'm gonna copy this one gonna put that on top again the amount being 27,000 if we debit something we're also gonna have to credit something so I'm gonna put a negative 27,000 in e15 and enter that'll put brackets around it then what should that account be well why are people gonna pay us 27,000 because we did work and therefore earned revenue again so we earned revenue we can see that revenue has a credit balance revenue only goes up we're gonna make it go up again by doing the same thing to it which in this case would be another credit which we already knew because we debited the receivable so there's the credit we're gonna credit to and so let's copy that and put that in the credit side of our journal entry alright so let's post this out and of course the two accounts we're focusing on are having a lot of activity in them but let's post that out again we got 14,000 here if we double click on it we can see what is in there so of course this is what's in there and now we're gonna go to the end of it after the D 11 and say plus and point to the 27,000 which of course will make the receivable go up again by 27,000 put us out of balance down here then we're gonna post the other side of it to the receivable double-clicking on the receivable go to the end of it and plus and then point to the revenue sorry the other side of it is revenue and the revenue of course will go up in the credit direction bringing net income up and putting us back in balance here so there we have that we're gonna post this out once again to our subsidiary ledger we can see our question who how much do people owe us 41,000 well who owes us 41,000 well then we're gonna go to our subsidiary ledger over here and say well Adam owes us and then we have Ryan who we need to record over here in P 9 so P 9 we're gonna say equals that same 27,000 needs to be recorded there and now we have the 20 27 by Ryan and the total adds up to of course the 41 which is on the trial balance we will also have this activity by date on the general ledger not as useful in this particular type of account which is why we need the extra ledger of the subsidiary ledger by client but the activity for all accounts will be represented in the general ledger by date so we're gonna go by date we're gonna be in a cell T 12 T 12 equals the same activity so I'm just gonna post that same debit bringing this 14 up in the debit direction because the same thing makes it go up and there we have that let's take a look at the last one here we're gonna say receive cash on account from Adams so now Adams is gonna pay us this 14 that we build them in the past that's what we expect to happen we we invoice them and then we received a check in the mail and what that's nice so then we are going to say well is cash affected yes cash is affected we just got the check cash is gonna go up cash has a debit balance we make something go up by doing the same thing to it in this case that would be another debit a debit and a debit are the same thing making the debit go up copying that right-clicking pasting 123 so that's gonna be the 14,000 then we're gonna credit something of course 14,000 represent the credit with a negative for this worksheet 14,000 and then we just need to know what account we're gonna credit well why did people pay us 14,000 because we did work and we did earn revenue but we earned revenue in the past and people already we already recorded that revenue up here now we need to see the fact that we also recorded up here the receivable that represents the fact that people owe us money that now needs to go down because somebody paid us money that has a debit balance in it and how do we make something go down we do the opposite thing to it which in this case would be a credit and we already knew that we're gonna credit it because we debit cash there's the credit right there that we will credit it for so what is happening we receivables will go down we're losing one asset but we're gaining a better asset that asset being cash so I'm gonna copy the receivable we're gonna post that underneath in see 18 right click and paste it one two three okay then we're gonna post this out so let's post this out we're gonna post cash cash has something in it so I'm gonna double click on it we're gonna go to the end of it and say plus and so I can see what's in there there and I'm gonna put this 14 in there as well what's that gonna do increase cash put us out of balance so there we have that then we're going to record the receivable so here's the receivable in I a six double clicking on I six go into the end of it it's getting kind of long I see that but we could see everything that's in there and we're gonna go to the end say plus and then point to that 14,000 and then when we hit enter what's gonna happen the receivables gonna go down because it has a debit balance it's gonna go down and puts it back in balance down here so now we can see the receivable if we ask someone asks us if our boss asks us if we're the owner and we're asking who owes us money or how much do people owe us people always 27,000 while who owes us 27,000 and of course we're gonna have to look at the subsidiary ledger for that we need to record this same activity for the subs atoms down here is the one who paid us the 14,000 so we're gonna go into the credit side for atoms and we are in cell and 17 equals and we're going to point to that 14,000 over here that will bring the 14 down by 14 to zero so atoms no longer owes us the money we can see that that all of the subsidiary ledger accounts now add up to 27,000 just what Ryan owes us that ties out to the trial balance and of course with this information would be on the general ledger as well and it would be recorded by date so we need to record that as well in the general ledger for accounts receivable so I'm going to say the same activity equals the 24,000 here bringing the 47 down by the 14 to the 27 so the 27 in the GL ties out to the 27 in the subsidiary ledger ties out to the 27 in the trial balance also note that if we look at the GL we can see that the activity being the fact that the same thing makes it go up the opposite thing makes it go down so we see that we have the debit side here are always going to win because it's an asset account and you can think of it kind of a race that we're saying you know it's the debits against the credits which ones are going to win and how much are they going to win by well we already know the debits are always going to win because it's an asset account so therefore the credit makes it go down so the 35 minus the credit makes it go down then we're going to say plus the debit makes it go back up to the 14 then plus the debit makes it goes up to 47 and then we say minus the credit makes it go down to 27 other way we can think about it is of course the debits add up to a total of 76,000 minus the credits which add up to the 49,000 if you subtract those two outs you get the 27,000 so that's how the activity will work in the GL that same activity is a little bit more difficult to see in the subsidiary ledger because it is of course broken out in a bit more detail by customer and of course we can see the summary of that same activity in the trial balance by just taking a look at what is being included here so the debit making it go up credit making it go down debit making it go up debit making going up credit making it go down