 Hello, in this presentation we will discuss the reasoning for using a worksheet within the adjusting entry process. A worksheet like the one on the right where we have an unadjusted trial balance, adjustments, and then an adjusted trial balance. We typically think of this worksheet as outside of the normal journal entry process, meaning the normal journal entries that we are going to input will be in the general journal, posted to the general ledger, giving us more detail, and then posted to the trial balance. In this case, we are going to use a worksheet which will go straight to this adjusted column and then show us the unadjusted balance, the change, and then the adjusted balance. If we were using accounting software like QuickBooks, then we would have the normal data input in the system. We would produce then the unadjusted trial balance and put that into a worksheet such as this and then work through this process to have our worksheet show the balances here. Idea being that the worksheet in the adjusting process is going to be outside of the normal system. When we think of the adjusting process, of course, we're thinking of the process after the normal accounting journal entries. So normal checks, normal bills, normal invoices have been entered. Then we have a separate, we can think of a separate department or even an outside CPA firm who will be doing the adjusting process and therefore we will generate from our system a trial balance which we will then within the adjusting process put into our worksheet and call the unadjusted trial balance, then make the adjustments and then have the adjusted trial balance finally ready for the use of the financial statements. So why use this worksheet? Why not just put it into the database system or it through the normal process? Few benefits. It worksheets help provide immediate feedback. So the worksheet's going to give us the immediate input in terms of what's going to happen to this account, what's going to happen to the two accounts affected, what's happening to net income, and it gives it that immediate feedback which we don't see as easily when we have to post it to the general ledger and then to the trial balance. So when there's only a few type of journal entries, it's really helpful to have a little worksheet like this that will give us a nice everything in one snapshot which we'll see in a bit. A worksheet allows the adjusting journal entries to be tested before being entered into the normal accounting system. If we enter this this information into the adjusting process, the addition process is a little bit more complex because it does deal with the with the accrual entries and therefore we do want to test it before we entered into the system and this worksheet can help us to provide that. A worksheet helps to separate the adjusting process from the normal accounting transactions. We do want to keep the worksheet or the adjusting process separate in our minds from the normal journal entry process so that we have the normal day-to-day journal entries and then we have these adjusting journal entries. If we keep them separate, it really helps us to understand how the adjusting journal entries will work and it helps us to basically have these two processes, these two systems which kind of run on a different kind of spectrum that the accounting department does what it does and then the adjusting entries do what they do and it's easier many times to have the accounting department not be interrupted by some of the adjustments in the adjusting department. So we're gonna we're gonna think of them as a separate entity and or not a separate entity. We're gonna think of them as a separate process that we'll be putting in place within the accounting system and taking the information outside of the system and working it into a worksheet and then putting it back into the system helps us really define that separate process. It also might be done by a separate department or by an outside CPA firm in which case we'll also need to generate the trial balance from the system that will then be adjusted and put back into the system. Some characteristics of the worksheet here once again we have our accounts, we've got the unadjusted trial balance, we have the adjustments and then the adjusted trial balance. This will show us very quickly if we put this information into our trial balance we can see very quickly that it is in balance. Now our system here is showing debits as positives credits as negatives rather than having two columns for each of these. If we had two columns for each it would be six columns long and a bit more complex to use excel formulas. This brings it down to a really three columns which is really nice to see and the formulas actually help. So in this case we're going to have positive numbers being debits, negative numbers being credits then if we were to say debits minus the credits we end up with zero and we get that quick check to see that we are in balance in the unadjusted trial balance. We can also see that we are in balance in our adjustments and it's really nice that we only have a few adjustments that are going to happen typically. We're going to adjust basically five to ten accounts possibly and because there's only a few accounts we can post those to this center column rather than post them to the general ledger and this allows us to see the effect very quickly. So we could see for example the landscaping supplies started here at the 325 changed by the 275 to the 50 at the end of the day. The reason we don't do this type of method for all accounts is of course if we had 10 things going to the landscaping supplies then it would this entry this journal entries column wouldn't tell us much because there'd be too much information packed into this one cell but if there's only one account that's being changed if there's only one journal entry adjusting journal entry changing this account then it's really nice to have a worksheet like this because it'll give us a direct view of what is going on and we can also oftentimes see what is happening so I can tick off the accounts here here's the supplies up here here's the other side of it down here here's us being in balance and so we can typically go through here and see those two accounts that are going to be affected on each. We also can see of course that if we add the debits and credits the debits being positive credits being negative in this worksheet then it adds up to zero so that we can see we are in balance very quickly very nicely with a worthy sheet such as this and of course when we get to the adjusted balance here the adjusting balance being the unadjusted balance plus the adjustments given us the adjusted balance and if the unadjusted balance is in balance and the adjustments are in balance and the adjusted trial balance is summing those two up then we will also be in balance in the adjusted trial balance and of course this worksheet will give us a nice quick view of that the debits being positive credits being negative we're able to see that we're in balance very quickly so we get all that information very quickly it's also going to give us what is in net income very quickly and this is another way reason that if we have the revenue as credits and as the credits as negative numbers which include revenue and the debits as positive numbers which include expenses then we can really sum this stuff up and use excel to give us a quick calculation of net income as well so this will give us net income on the unadjusted trial balance very easily by just taking the credits which are which are negative numbers here and then subtracting out the expenses and that's going to give us this net income we do have to note however if we're using negative numbers for credits that this doesn't mean that we have a loss it means that the credits are winning because we have a credit balance that is over or greater than the debit balances leaving us with that 2035 net income in the unadjusted trial balance we can also see that net income in the adjusted trial balance of course and we see it here so here are our adjustments we can see what the difference is what did we do to these accounts and then we can see the net income once again very quickly calculated by excel we have the negative numbers being the credits positive being the expenses and the debits and the credits of revenue minus the expenses of debits gives us net income not a loss of 885 in this case we can also see what the activity is so and this gives us a real uh show of what the impact of our adjustments are on the financial statements so this is what our net income was before remember that's income not loss if we add this column up that will give us the change so we of course have brought down net income by 1150 so we can see we can read it across this way we have the net income and then we brought it down to 885 in this case we can also group counts very very quickly as well we can take a look at the liabilities and within excel we can just highlight these and excel will sum them up we don't even have to use a calculator we don't have to use a sum function or anything we can just highlight the sales and excel will give us that balance in this case 10250 we can do that of course for the adjusted trial balance as well very easy for us to just sum this up it's actually a lot less bulky than looking at a balance sheet and so we can test these accounts if we know what debits and credits are this is a much cleaner way of seeing everything if we want to know what the total equity is we can do that very quickly by just highlighting once again in excel just highlighting this range of sales and it will sum it up for us automatically the credits minus the debits here so it's going to take the credit minus the debit plus the credit minus the debit minus the debit minus the debit giving us 4535 in this case we can do the same for the adjusted trial balance so this is different than net income down here because now we're adding into this capital and draws and all we have to do is highlight this and it'll take the difference between the debits and the credits giving us a balance in this case of the total equity 3385 we can also see total equity and double check our accounting equation by adding up the assets minus the liabilities and if we have this in the system as assets being positive numbers because their debit balances and liabilities and credit numbers because they are credit balances so negative numbers then it will subtract this out for us and we know that according to the accounting equation assets minus liabilities will equal equity because assets equal liabilities plus equity so in essence if we take the assets minus the liability in the top half it'll it'll equal the the credits minus the debits capital minus draws plus revenue minus expenses on the bottom half and we can do that for the adjusted trial balance portion as well as we add up assets minus liabilities we can just highlight those within excel giving us 3385 so the worksheet gives us a really quick view of all of this information all the information we really need so that we can double check it see what's going on before we enter that into the system