Form 1099 & Expenses by Vendor Reports 4.30

QuickBooks Online 2021 form 1099. And expenses by vendor reports. Let’s get into it with Intuit QuickBooks Online 2021. Here we are in our free QuickBooks Online test drive practice file, which you could find by searching in your favorite browser. For QuickBooks Online test drive, we’re gonna be looking at our reports down below looking at a 1099 report, you could simply type in the search menu for 1099. But I’m going to locate it down here by scrolling down.

(more…)

Note Payable Journal Entry

In this presentation, we will record the journal entry related to a note payable related to taking out a new loan from the bank. Here’s going to be our terms. We’re going to record that here in our general journal and then we’ll post that to our worksheet. The trial balances in order assets, liabilities, equity, income and expenses, we have the debits being non bracketed or positive and the credits being bracketed or negative debits minus the credits equaling zero net income currently at 700,000 income, not a loss, revenue minus expenses. The difficult thing in terms of a book problem, when we record the loan is typically that we have too much information and this is the difficult thing in practice as well. So once we have the terms of the loan, and we have the information, we’ve already taken the loan out, then it’s the question of well, how are we going to record this thing? How are we going to put it on the books and if we have this information here, if we have a loan for 100,000, the interest is 9%. And then the next number of payments that we’re going to have, we’re going to pay back our 36. Then how do we record this on the books? Well, first, we know that we can ask our question is cash affected? We’re going to say, Yeah, because we got a loan for 100,000. That’s why we got the loan.

 

01:14

So cash is a debit balance, it’s going to go up with a debit, so we’ll increase the cash. And then the other side of it is going to be something we owe back in the future. And that’s going to be note payable. And that’s as easy as it is to record the initial loan. The problem with this the thing it’s difficult in practice, and in the book question is that we’re often given, of course, the other information, like the interest in the number of payments, and possibly more information that can cloudy up the what we’re doing, and the reason these are needed, so that we calculate interest in the future, but they’re not really We don’t even need that information to record the initial loan. All we need to know is that we got cash and we owe it back in the future. And you might be asking, Well, what about the interest we owe interest in the future as well? We do, but we don’t know it yet. And that that’s the confusing thing interest, although we we will pay interest and we know exactly how much interest we’re going to pay in the future. We don’t owe it yet. Why don’t we owe it yet? Because we’re going to pay back more than 100,000. Why don’t we Why don’t we record something greater than 100,000? You might say, because we know we’re going to pay more than 100,000. And that’s because the interest is something that it’s like rent. So we’re paying rent on the use of this 100,000. And just like if we if we had a building that we rented, that we’re using for office space, we’re not even though we know we’re going to pay rent in the future. We’re not going to record the rent now. Because we haven’t incurred it until we use the building.

 

02:41

So the same things happening here. We know we’re going to pay interest in the future we’re no we know we’re going to pay more than 100,000 but it hasn’t happened yet. We haven’t used up we haven’t gotten the use of this hundred thousand and therefore haven’t incurred the expense of it yet. So the interest and is something we need to negotiate when making To turn off the loan, but once the loan has been made, and we’re just trying to record it, it’s not going to be in the initial recording. It will be there when we calculate the payments need and the amortization table. So the initial recording is pretty straightforward. We’re just going to say okay, cash is going to go up by 100,000. And then the notes payable is going to go up from zero in the credit direction to 100,000. So what we have here is the cash increasing the liability increasing, although we got cash, there’s no effect on net income because we haven’t incurred any expenses. We’re going to use that cash most likely to pay for expenses possibly or pay for other assets or pay off liabilities in order to help us to generate revenue in the future. But as of now, we’ve gotten we increase an asset and we increase the liability

Notes Payable Introduction

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.

(more…)

Bond Price Excel Formula

In this presentation, we will calculate the bond price explaining how this can be done using present value formulas within Excel. Remember that the bonds is going to be a great tool for both accounting and finance to describe the present value calculation. So that’s why it’s going to be used. Oftentimes It has two cash flows related to it, one’s going to be the face amount of the bond that’s going to be due at the end of the term of the bond. In our case, it’s going to be two years semiannual or four time periods. And the other is the flow of interest. So bonds are a great example because they have the two types of present value problems that we need in one area. So even if you’re not in an area where you’re dealing with bonds all the time, they’re still going to be used and useful to understand present value types of calculations. So here we’ve got the bond is going to have one cash flow of 100,000 at the end of four periods or two years, and we need to figure out what the present value is in order to price it back here at your at time period zero. And then we have these four payments in terms of the annuity 4000. And we need to take those and present value them, we could take each period and present value each payment and present value it. But the easier thing to do is to present value, an annuity when it’s applicable and present value, the one amount when it’s applicable. And therefore think of that about these as two basically separate cash flows that we’re going to have to present value separately. So we can do this multiple different ways. And it just depends on what you’re what tools you have. And where you are, in order to know how to do it. What you want to know is just that there’s different tools to do it. Anytime someone uses a different tool. What are they doing the same thing? And and when can you apply these tools and what’s actually happening here. So that’s what’s actually happening. We’re present valuing this information.

(more…)

Bonds Present Value Formulas

In this presentation, we will take a look at present value formulas related to bonds. One of the reasons bonds is so important to accounting and finance is because they’re a good example of the term of present value of money. We’re trying to look for an equal measure of money, when we think of bonds and bonds is going to have this relationship between market rates and the stated rate, which helps us to kind of look through and figure out these types of concepts. So even if we don’t work with bonds, in other words, if we’re not planning on issuing bonds, or buying bonds, or knowing anything about bonds not being important to us, the time value of money is a very important concept and bonds is going to be a major tool to help us with that. Why is bonds so useful for learning time value of money, because there’s two types of cash flows with bonds meaning at the end of the time period, we typically are going to get the face amount of the bond that 100,000 similar to a note and then we’ve got the interest payments that are going to happen on a periodic To basis, and therefore we have these two different types of cash flows, that we can use two different formulas for, to think about how to equalize.

(more…)

Cash Internal Controls Overview

In this presentation, we’re going to introduce the internal controls related specifically to cash, cash internal control goals, these are going to be the objectives of the internal control system over cash, we want to have the cash handling separate from the record keeping. So whoever is handling the cash, we would like to have them not be the same person doing the record keeping. And therefore we have that separation of duties. We have the person that is entering the data, not having as much of an incentive to steal the cash because they’re not the ones handling the cash, the people handling the cash, know that if they do steal it, the record keeping should pick that up, and they are a separate person. cash receipts are deposited to the bank. We want to make sure that the cash receipts are going to the bank as soon as possible, hopefully on a daily basis, so that we’re not actually emulating cash. We don’t want a cash to be piling up, because if it is then we have a greater risk of theft to happen and greater loss if that does happen.

(more…)