 QuickBooks Online 2022, reversing entry, unearned revenue, customer deposit. Get ready because it's go time with QuickBooks Online 2022. Here we are in our get quick guitars practice file we set up with a 30 day free trial holding down control, scrolling up a bit to get to the 1 to 5% we're currently in the homepage otherwise known as the get things done page, the business view as compared to the accounting view. If you want to change to the accounting view it's something you can do by going to the cog up top, switch to the accounting view down below. We will be toggling back and forth between the two views either here or by jumping to the sample company file currently in the accounting view. Back to the get great guitars we're going to open up a few tabs to put reports in. Right clicking on the tab up top to do so, duplicating it back to the tab to the left two more times, right clicking again, duplicating again, back to the tab to the left one more time, right clicking again and duplicating again as that is thinking. Let's see where the reports are located in the accounting view which is simply on the left hand side under reports. If we jump back on over to the business view to see where the reports are located hold on a second it's thinking my computer is thinking don't rush it we're going to go into the business view here we're into the reports we're going to close up the hamburger and then we'll be opening up the balance sheet first let's open up that big balance sheet and then do the range change up top from 010122 to 022822 0228 being the cutoff date hit the drop down we're looking at the months to see the side by side and then run in it. Let's go to the tab to the right and we're going to go down to the business overview again into the reports again close up the handbook and then go on down to the profit and loss this time the P and the L will do a range change up top from 010122 to 022822 and then change this to the months again for that side by side run it one more time on the tab to the right back to the business overview we want to go into the reports closing up the handbook and this time I'm going to type in trial balance up top trial balance because that's what I want to find a trial balance let's just do a range change on this one from 010122 to 022822 then run that one let's go back to the first tab now and we have the scenario last time where we did an adjusting entry related to unearned revenue which is down here it's a liability account a little bit different than the type of adjusting entry you would see in a textbook type of problem in a textbook type of problem typically the adjusting entry being that we have some kind of method of accounting or some type of industry where we get paid before we do the work which is a bit more unusual of a type of industry but there are many of those industries out there such as a service-based I'm sorry a subscription based industry like applications or possibly newspapers and magazines in which case you would you can imagine then the unearned revenue going up and up and up every time you receive the payment because you have not yet done the work under an accrual basis and then some way or somehow you would have to then determine on a periodic basis possibly monthly or possibly yearly how much of that revenue has been earned lowering the unearned revenue for that earned amount and recording the income for it now that is a classic accrual kind of system however in the accounting side of things we also have another kind of logistical problem which is basically going to be well what what happens in a system where basically I get a down payment kind of situation and then I'm gonna issue an invoice into in the future for the remaining outstanding balance in that case we've got this added problem of needing to link the payment that we got in advance to the invoice it's more difficult to do that with unearned revenue because unearned revenue is not the account that is tracking the customers in the sub accounts the accounts receivable is the account that does that therefore a lot of times people will actually create a payment form which results in a negative receivable as opposed to a positive liability a negative receivable which will then clear itself out it's just a timing difference once we make the invoice but it's going to have that temporary kind of problem where we've got that negative receivable which if we want the accounting department to use that method they often do because it's going to be something that tracks the forms correctly in the system even though it doesn't have that it has that little quirk of having a negative receivable then we could just use our adjusting entries to shore up at the end of the period month or year for financial statement reporting purposes increasing the accounts receivable and then recording the liability for those deposits that we have not yet sent an invoice for so for example if I go into this accounts receivable then we see the adjusting entry I'm going to hold control scroll down just a bit to get down to the bottom here we had an adjusting entry for the for that item which I believe was this entry the 450 if I drill down on that we can see the transaction here now we just want to reverse it I'm going to close this back out I'm going to go back up to the top and go back to the accounting system so we made the books right for the financial reporting purposes and now it's like I don't want to mess up the accounting department so I want to reverse what we did because what the accounting department is doing works great for what they needed for tracking the receivables and the payments and so on the advanced payments and whatnot and we need to but we need to fix it on a periodic basis and then not mess up what they're doing that's the point of the adjusting process so now that I've got my financial statements correct I'm not going to stop there I'm going to then think about how I'm going to help out the accounting department to do what they do well on their end so I'm going to go to the tab to the right right click on it and duplicate this tab and let's open up one more report so we can see this in a bit more detail and that's going to be in the reports on the left-hand side closing up the hamburger and I'm going to then go down did I click on the reports I'm in the reports got a click on it and then close up the hamburger I'm going to go down to who owes you money who owes you money and we're going to go down to the customer balance detail report customer balance detail and then I'm going to choose a custom date as of the cutoff date 0 228 222 and run it so there we have our items and we're looking for those items that have those negative numbers in it notice if I don't add any filters to it then it only shows invoices except right here why did it show a payment because that payment is is basically not tied to an invoice and we have a negative balance that's what's resulting in the negative balance so that one was an issue for us because we didn't owe we don't owe Eric if we owe Eric music money which is kind of what we do owe them we owe Eric music money or we owe Eric what we promised to give Eric which is the completion of the sale in our case the guitar that they put the down payment for and then we'll make an invoice and when we make the invoice will apply the credit to it which means at that point will be fine at that time but we've got this negative amount until we issue the invoice we've got the same here for Sam the guitar man and then if I go down notice when we enter the adjusting entry I didn't make the adjusting entry for Sam the guitar man because that would mess up the accounting department but rather we tried to put the adjusting entry under its own account down here with a new customer we called ZZZ adjusting entry so it would be at the bottom of the report and so that it hopefully it would be out of the way and not mess up the actual customer detail because we're only entering the adjusting entries to fix the financial statements not the sub ledger and we cannot enter a journal entry into QuickBooks without doing something to a customer account therefore we added a new account because QuickBooks doesn't want to allow us to have the sub ledger balance not tie out to what's on the balance sheet the way they do that is they force you to use a customer even if you're just using a journal entry to post to the accounts receivable something that's typically good in most cases that's a kind of a problem in this case but that's okay this is how we're going to work around it we can also try to work around it by creating another accounts receivable account but not call it an AR type of account but rather other current assets type of account so that we don't have to deal with the sub ledger not messing anything up there however if we do that then it's going to make our reports a little bit messier because I can't really make the AR like a sub account I can't make my adjusting entry accounts receivable sub account because it's going to be a different account type okay so that's that so now what we're going to do is is do a reversing entry so i'm going to go back to the first tab here so we're just going to do we're going to reverse exactly what this one did so if i go into this one we're just going to look at it you could take a screenshot if you want to right there boom and then we're going to reverse that exactly here's the here's the zzz entry but there's only two accounts affected so it should be fairly straightforward we're going to credit the accounts payable and debit the unearned revenue so let's go back to the first tab to do it that's our working tab that's where we do stuff this is our do stuff tab so let's let's get things done as the home page says we're going to hit the drop down we're going to go to our journal entry go into the good old journal entry and this is going to be as of the next day after the cutoff date and we're going to say that now we've got the accounts receivable or let's do the unearned revenue we'll put it on top unearned actually let's keep with our system there's only two accounts so i'm going to do accounts receivable and i'm just going to reverse it exactly and i i think this is good practice to do the reversing entries to basically have them in the same order from top to bottom last time we debited the accounts receivable i'm going to credit the accounts receivable for 450 and it's going to be called an adjusting entry a dj entry now again that kind of or this is not an adjusting entry this is a reversing entry now that that you might say why don't i reverse it and put the debit on top you could if there's only two accounts affected but if it's it's a more complex kind of system then if you change the order from top to bottom it could be a little bit more difficult to read or compare it to the adjusting entry so i think it's kind of a good practice to take the same top to bottom as the adjusting entry and then simply reverse the debits and credits so that you can tie it out to the adjusting entry it might be easier to enter and visualize especially if there's more accounts affected however if you're working with someone that really likes having the debits on top instead of a credit on top and it bugs them to have a credit on top then you could you know you could do whatever whatever you need to do for whatever system you're working in so i'm going to go this that i'm going to say this is going to zz adjusting entry i'm not i'm making up this other customer or we made up the other customer in a prior presentation so we don't mess up the customer detail because we just want to do this for financial statement reporting purposes we're not really trying to fix the sub ledger here because that's internal to the accounting department we're just trying to fix the financial statements for external reporting typically so then i'm going to say on the next side this is going to be then going to unearned revenue unearned revenue which is a liability account so we're going to debit it which will make it go back down you might want more detail on the description but at the very least we would want to say it's a reversing entry so that we can locate where it is and we can find it easily and we'll also be able to find by the date all reversing entries on the first day after the cutoff date the cutoff date for us being 228 and then we can also see that it's going to be a journal entry form those three things will help us basically to determine all reversing entries help the accounting department to see them as reversing entries allowing us to then say okay you know they can say this is something that the accounting or adjusting department did so i'm going to then say let's save it and close it see if it does what we expect it to do go into the tab to the right and let's run this again and then if we go into the ar i'm going to go into it we're still in the cutoff date here but i'm going to change the date range so we're still correct we still have our adjusting entry down here as of the cutoff date and then if i add this one more date up to 030122 and run it then right after the cutoff date we have the reversing entry of the 450 which takes us back to where we originally were in essence which is fine from an accounting standpoint the accounting department is doing fine they don't need the adjusting entry we only need the adjusting entry to report the financial statements for that little tweak and then the other side's going to be in the unearned revenue account which is way down here same thing for 450 that's correct as of the cutoff date we have here and then if i was to bring the date up one more day after the cutoff date then we're going to have after the reporting period reversing back to where we originally were so that we don't so that we leave the accounting department alone we're not trying to fix what they're doing they're doing what they're doing we're trying to tweak it as planned for reporting purposes let's go back to the tab to the right and that's going to be our detailed report so if i go into the detail report here and i'm going to say let's let's run it again so this is our cutoff date so the cutoff date still still ties out if i go down here we're going to say it's still 23 150 150 that ties out to what's on the balance sheet if i jump over there i'm jumping fairly quickly sorry about that i've got rapid jumping these days so we got 23 15 150 so 23 15 and then if i bring it up a day bring it up a day we're going to say let's take it the day after the cutoff now we're going to say does that mess any of the detail up for these for these customers no i didn't do anything to the customers even with the adjusting entry we made this new a customer down here so hopefully you can see all these transactions happening it's kind of a nuisance that we have all this detail in this customer down here but hopefully because it's named zzz and it's at the bottom it doesn't bother the accounting department too much because it's not part of an actual customer information and that's where we can house our adjusting entries note that if you put these adjusting entries into an actual customer it causes a problem because you can't really link these two out as easily meaning you're usually have an invoice that's linked to a payment if you have journal entries then that kind of messes the thing up because you can't really link him to the payment and so that so the reports get kind of kind of ugly in that case the other way you can get around this is to not touch the sub ledgers at all by making another accounts receivable account an accounts receivable adjusting entry account and making it not an accounts receivable type account but rather a other current asset which is a bit of a bit of a problem because that means you can't put it right under the accounts receivable on the balance sheet it would be down here somewhere but you want to make it other current assets so it doesn't have a sub ledger that's the point and then you can you can do your adjusting entries without a sub ledger but if you want to do reporting you can't like collapse this account as easily and see it you'd have to export it to excel and combine the two accounts together to make it look nicer so depends on what you're doing if that would work or not if i go back to the first tab and let's go back into the get paid and pay area and then let's close up the hand boogie and if we go down here we didn't do anything to the customer see this is where the accounting department works this is where they're concerned if they go into the music stuff or sam the guitar man and they see journal entries in there they're going to be like oh the accounting department did something funny i can't you know every they're going to talk to the right they're going to talk to the adjusting people put a journal entry and they're i don't know what's going on maybe your account is on you know that's going to cause problems hopefully it won't cause as many problems down here and the zzz adjusting entry because that's not an actual customer hopefully that doesn't you know mess anyone up or anything like that but again even if you don't want to do that to mess up the accounting department because we're trying not to mess up the accounting department as we did the adjusting entry you could make that other accounts receivable account okay so let's see where we stand at this point in time and we're going to go to the trial balance and let's run it again and this is where we are let's do it as of uh 31 or let's make it 03 31 22 the end of the month so you could see this is after this is after the cutoff date so because we did a reversing entry so if your numbers tie out to this great if not then try changing the date range well we will be taking a look at the journal reports to help diagnose any differences at the end