 QuickBooks Online 2023. Make loan payments breaking out interest and principal portions. Get ready to start moving on up with QuickBooks Online 2023. Here we are in our Get Great Guitars practice file. We started up in a prior presentation using the 30-day free trial. We also have opened the free QuickBooks Online sample company if you want the two open at the same time. Support Accounting Instruction by clicking the link below giving you a free month membership to all of the content on our website, broken out by category, further broken out by course. Each course then organized in a logical, reasonable fashion, making it much more easy to find what you need than can be done on a YouTube page. We also include added resources such as Excel practice problems, PDF files and more like QuickBooks backup files when applicable. So once again click the link below for a free month membership to our website and all the content on it. We suggest using the incognito window or another browser. You can open the incognito window if using Google Chrome by selecting the three dots in the browser and then incognito window and then search into the search engine for QuickBooks Online Test Drive. We're going to use the sample company to compare and contrast the accounting view, the view that the Get Great Guitars files in and the business view, the view the sample company is in. If you want to toggle back and forth between the two views, hit the cog up top and switch the view down below. Opening a couple tabs to put reports in by right clicking the tab to duplicate it right clicking the duplicated tab to duplicate it and then going back to the middle tab to go to the reports on the bottom. And then once you're in the reports, we're going to go into the balance sheet. And then we're going to go to let's check that out in the business view, by the way, in the business view, it's located in the business overview. And then the okay, I'm going to stop doing that. I won't talk like that anymore. So any case, then we're going to go to the tab to the right and we're going to go down to the reports on the left hand side. And we want to open up the P to the L the profit and the loss close up the boogie change the range up top. I'm going to do that like dual range two months thing by going from 010123 to 022823 and then run it. And then I'm going to go to the months drop down so we can see the side by side for the months, which is totally cool. So now I got January nothing in there for February yet that's the current month we're working on and then the total on the right for the two months up to this time. Let's go to the tab to the left this time I'm just going to do close in the hamburger the normal range from 010123. Let's go to 022823 but I don't really need to do the months thing on the balance sheet because I don't think it's going to add too much value. So we'll just keep it as is there. So that's the setup process we do every time. Now last time we talked about the loan payable and we put together our amortization table. So now we're going to be recording payments with our amortization table. So let's just recap kind of the issues with the loans. We have a loan on the books, which helped us to finance the company couple issues with the loans. One, there's often a short term version proportion and a long term portion when we're paying installment loans off. However, we don't typically want to have two loan accounts a short term and long term version when we're doing normal bookkeeping, because it's better to have one account or easier that I can then tie into my amortization table. Otherwise, the long term and short term portions will differ every time. So you want to just make an adjustment for the long term and short term portion periodically is my suggestion at the end of the month or a year, possibly having your CPA firm help you out just to do that breakout and then reverse it so that you can then do the bookkeeping easily and have the financial statements when they're necessary when you're going to report them. So we'll talk about that in the adjusting process. Two, you might have multiple loan accounts in which case you probably you could put them all in one account, but you probably want a different loan account and we'll talk more about that in a future presentation when we add another loan account. And that way you can tie each loan account into its own amortization table. And then three is the breaking out of each payment. That's what we're going to focus on here when the interest and the loan principle will differ every time. So we're going to be looking at the first two payments. We'll actually record both of these and you can see how the payment is the same, but the interest and the loan reduction or reduction to the principal will differ. So that means there's three accounts affected as opposed to two accounts when you pay like a utility bill, only cash and utilities expenses affected here. We're going to have cash interest expense and then the reduction of the loan impacted that adds a little bit of complexity. Also, I can't really memorize the transaction, whether that be through the bank feeds creating a rule, for example, so I can automate the transaction or when I just record the transaction every month manually, because even though the dollar amount is the same, that breakout that changes between interest and principal makes it a lot more difficult to automate. So what are the workarounds to that? One is that you could try to stay in a cash-based system and so bookkeepers that are trying to scale up the business and work on a cash-based system to the degree they can might then work with a CPA firm to do adjusting entries periodically, possibly at the end of the year when tax returns are prepared or something like that, and then they're just going to record the payments and reduce the loan principle for the full amount with possibly the bank feeds. And then at the end of the year, you ask your CPA firm to say, hey, here's the amortization table, or if you don't have the amortization table, hey, CPA firm or tax preparer, I would like you to make the amortization table based on the loan documentation and then do the necessary adjusting entries, which might be breaking out the interest and principal portion so that you could do the tax returns and the financial preparation at that time and break out the short-term and long-term portion of the loan if necessary for tax return and financial reporting at that time. That's one method you can use to try to automate everything on the bookkeeping side. The other method is we just take our amortization table, which we might have to create as we did here or ask our CPA firm to create and we'll just have to change it every time in accordance with the amortization table. So that's what we'll do here to see what that looks like. So I'm just going to highlight this first one and make it green just to say, okay, that's the first one that we're on. And I'll go over here and say, all right, let's go to the first tab then. And just what's going to happen, by the way, this amount is going to go down by the portion that is the loan reduction taking us to the new loan balance and then $300 will be interest expense on the profit and loss and then the checking account will go down by the full amount. All right, let's do it. Let's go to the first tab, enough talk. I want to see some action here. All you do is talk, man. Okay, here we go with the action. We got the vendor information. I'm going to go into, let's do it with a check form. So I'm going to say the bank that we're paying, let's say is Chase. So let's type in Chase. I think we put that in earlier. I'm just making up a bank name that we're going to be paying. It's coming out of the checking account, tab, tab. Let's say the date is at the beginning of the month. So I'm going to say, let's go February, February 020123. So the beginning of the month. And then the 16th, the check number should be populating properly now. So that's good. I'm not going to print the checks for the practice problem down here. We're going to say, okay, here's where it happens here. So I'm going to see if they have an account for interest expense. I'm just going to type in interest and notice they have this interest paid expense type of account. I don't like the name interest paid because you could have interest that you didn't pay that's still an expense on an accrual basis. I would rather it be called interest expense. So I might change it, but that's being a little picky. I'm not going to create another account called interest expense because I don't like the fact that they called it interest paid because then I'm going to have two accounts that are sounding like interest. And then I'll mess myself up by posting to both of them. So I'm going to do that and then I'll fix it if I don't like the name of that account. And so then you might want to put in the description like first payment or something like that because that might help you to tie it into the amortization table. Now the interest is coming from here. That's the 300. So there's 300. I don't need a billable or a customer. And then the other side is going to go to the loan payable loan payable account. There it is. And then I'll just call it first payment. And that's for the amount of the 105873. So remember that don't forget 1058.73. All right. And then the total comes out to the check of 135873. And that's the total 135873 movie B to the B to the N. So what's this going to do? It's a check. It's going to decrease the checking account by the 135873. It's going to have an interest expense on the income statement of 300. And the loan is going to go down by 1058.73 bringing the balance of the loan to 70,941.27. That's what should happen at least unless someone told me the wrong number when I put that in here and they told me the wrong number. So that'd be their fault and not my fault. So let's go ahead and save it and close it. And then we'll check it out. And then we'll go into the tab to the right and run it again, run it. And then we'll go into the rope to the cash account. And we're in February, February. And so there it is. So there's that amount that looks that looks good movie BN. And then we're going to go back the other side on the expense side of things. We got the $300 in February now. See how we got January and February. Isn't that cool? Yeah, it is. I know, I know it's cool. But anyways, so here's the interest. Now, sometimes you might want to put the interest down here into like other because sometimes you might think of interest as not being like part of your normal operations. It's a financing thing. So we might just change it to put it down here just so you can see what that looks like. And I might change the name at some future point as well. But for now, we can see there it is. And there's the $300 and that looks good just like we would expect. Now the second one, I'm going to record the second one and imagine a month has passed. So I'm going to record this one as well. This one I'll mark off as yellow, meaning it's done or something. Or let's make this one, this one yellow. Yeah. Okay. And so now this one, I'm going to just do it a month later. So I'm still going to put it in February. So we're still working in February, but I'll put it in there February 28th. So you've got to imagine a month has passed. And now I'm going to enter the next one just to see the problem with the fact that I got the same dollar amount, but the interest and reduction principle are different. So I can't memorize the transaction like I'd like to. So let's do that. Let's check that out then. Check it out. Check it out. Let's go to the first tab. I'm going to go to the plus button. Check. We're going to check out the check. And then I'll put this to chase again. Chase. Check out the chase check. Checking out the chase check. Okay. Okay. Just stop. What is this? This is going to be on 228.022823. And then the check number populates automatically. And then down below. Ah, sorry. My throat got clogged up there. We've got the interest. Now it tries to memorize the transaction, which is good. That's what we want to have happen. And if it was a bank fee transaction, that would be totally good. Because then we can make a rule to make it do what we want it to do. But we can't because these numbers change. I've got to change this. See to the 295.50.59. Now 295.59. Is that right? Did I go dyslexic on that one? 29. No, I did it right. I know I'm talking about. And then the other side's going to be 53. The other side's going to be 106.314. So 106.14. That gives us the same total down below here of the 135.8. Is that right? 135.873. But we have a different breakout between these two. Now, like I say, the other way you can work around this is to put the whole amount in loans payable, which means you will not tie out to the amortization table. It will be wrong because you will not have recorded the interest. But you can use that adjusting entry concept of saying, hey, look, I know that and I'm going to adjust it periodically at the end of the month or year, or I'm going to have my CPA do it at the end of the month or year so that I can automate everything, use the bank feeds, use bank rules possibly, make it as easy as possible and know which adjustments need to be made and have my CPA do it based on the loan documents and the amortization table. So that's another method that could work quite well. So I'm going to save it and close it and let's check it out. Check out the check from Chase, tap to the right. We're going to go run and then the cash account. Now it's going to kind of mess us up because we kind of jumped to the end of the month here so later on. But we've got these two. That was a month later even though it's in the same month but you get the idea. The point is same amount comes out of the checking account. That's not the issue. That's normal. That's what we would expect. But if I go to the tab to the right and I refresh it to run it to give a fresh report then in the interest paid, which I don't really like the name. I'd rather call it interest expense but we already talked about that. I might change that later. So then we've got these two here but these are different. That's the thing. That's what happens because interest goes down over time because the principal goes down. Therefore there's less rent on the money that you're being loaned. So it goes down as time passes. The other side's on the loan payable and that's going to be down here. Loan payable right there. There it is. And that one also has a difference between the two amounts in the reduction. We're now at the 6987813 which should match the amortization table 6987813. It does indeed do that. So let's go back up top and that is that. That's the loans. We'll touch more on loans in the future when we have another loan. So we have to deal with two loans and get into this. And then we'll do short-term and long-term loan breakout stuff in the adjusting entries section or course. So I'm going to go to the tab to the right right click on it and duplicate the tab. And then let's go to the trial balance just to check our numbers together. We're going to go to the reports on the left close up the boogie type in up top the trial balance. Trial balance. The balance is on trial. It's a trial about the balance of the nation of the get great guitars. I'm going to end this at what was I doing? Maybe I can do that comparison thing here too. I'm going to go from 010123 to 022823 and then do the month month's thing. So you can see the trial balance. This is where we ended at the end of January and now we've got the Feb nums. So if your Feb nums don't tie out then you can try to run it for the end of January and see if your Jan nums tie out and then and then if they don't you can change the range and see if it's a date range issue and if it's not then we'll be running a detailed report at the end of the Feb and then and so that hopefully helps us to drill down on any differences at that time.