QuickBooks Online 2021. Make loan payments using an amortization table. Let’s get into it with Intuit QuickBooks Online 2021. Here we are in our great guitars a practice file, we’re now going to make loan payments with the help and use of our amortization table, which we set up in a prior presentation. To do so let’s open up some of our reports, we’re going to duplicate the tabs up top, right click on the tab up top, duplicate it, we’re going to right click on the tab up top again, duplicate again opening up then our balance sheet and P and L Profit and Loss report going on down then to the reports on the left hand side, opening up the balance sheet report.
QuickBooks Online 2021. Make a loan amortization table, which we will then use to record loan payments within QuickBooks Online, making the loan amortization table with the help and use of Excel. Let’s get into it with Intuit QuickBooks Online 2021. Here we are, in our great guitars a practice problem, we’re going to be thinking about making payments on loans and breaking those payments out between interest and principal. As we do so, we’re going to be needing an amortization table. To help with that.
In this presentation, we will introduce the concept of notes payable as a way to finance a business. Most people are more familiar with notes payable than bonds payable, the note payable basically just being a loan from the bank. Typically, the bond payable is a little more confusing just because we don’t see it as often, especially as a financing option. From the business perspective, we often see it more as an investing or type of investment. But from a loan perspective, it’s very similar in that we’re going to receive money to finance the business if we were to issue a bond, or if we’re taking a loan from the bank. And then of course, we’re going to pay back that money. The difference between the note and the bond is that one the note is something we typically take from the bank. Whereas a bond is something we can issue to individuals so a bond we could have more options in terms of issuing the bonds than we do for a loan. Typically when we have a loan, we typically are Gonna have less resources, we can take a loan from the bank. When we pay back the bond, we often think of the bond as two separate things. And we set it up as two separate things, meaning we have the principal of the bond that we’re going to pay back at the end. And then we have the interest payments, which are kind of like the rent on the money that we’re getting, we’re getting this money, we’re gonna have to pay rent on it, just like we would pay rent if we had got the use of any physical thing.
This presentation and we’re going to create a loan amortization table. And this will help us to track our loan payments and break out the principal portion and the interest portion of them. Let’s get into it with Intuit QuickBooks Online. Here we are in our get great guitars file, we’re going to first start off with our reports, we’re gonna go down to the reports down on the left hand side and then we’re going to be opening up our favorite report that being the balance sheet report, opening up the balance sheet report scrolling up top, we’re going to be changing the dates from a 10120 to 1230 120. Then we’re going to run that report. Then I’m going to close up the hamburger to get it out of the way so I don’t doesn’t bother me and I’ve got the 125 on the zoom holding down control scrolling up to get there.