QuickBooks Desktop 2023 bank feeds. Let’s do it with Intuit QuickBooks Desktop 2023. And prior presentations, we downloaded and installed the QuickBooks Desktop Software indicated by this icon here, comparing it in our analogy to the Microsoft Word software, this would be similar to the Microsoft Word software.
00:25
We then downloaded the sample file the data file, which is here similar or comparison to, in our analogy, a Microsoft Word document, we’re now going to be opening up the program and then opening up the data file within it. We’ll do that typically by double clicking on the software itself.
00:46
If it does not open to the last data file we had open, that will usually be the first option up top, you can see the location, have it down below, mapping it on where it is on the computer. Remember, you want to know where that is, even though it’s easiest to just open it from right here by just say opening that file, we’ll do our general setup process that I do basically,
01:10
every time I’m going to close this out, here’s our homepage, if that homepage doesn’t open, and you want to open it, you can go to the company’s drop down homepage right here, then we have this into our display window, I want to maximize it to the gray area.
01:26
Typically, I will do that by maximizing this window into our display area, then I want to see the open windows. So I can toggle between any open windows, I could do that by hitting the open windows here. But usually, I go to the View drop down and open windows.
01:42
Now we have our toggling screen, then I’ll open up my major two reports that being the financial statement reports balance sheet and income statement. So I’m going to go to the reports drop down company and financial open up the profit and loss otherwise known as the income statement,
02:00
I’ll change the date range up top. The fastest way to do that as usually just to type it in there, I believe by going from Oh 101 to four we’re working in the future as compared to when I’m recording here to 1231 to four.
02:14
And so there we have it. And then I’m going to open up the balance sheet, you can see I have two things open on the left hand side by going to the reports drop down company and financial going down to the balance sheet standard, changing the date to 1231 to four and tab.
02:31
So that’s what I’ll typically do every time we open up the software. I’m going to toggle back on over to the homepage. And future presentations were to go through each of these cycles, vendors, customers and employees in detail.
02:44
Looking at each of these forms and how the forms were then used to enter the data that were used to construct the financial statements that being the balance sheet,
02:54
the income statement or profit and loss. Or in other words, we’ll look at the balance sheet and income statement or profit and loss that has been created, deconstruct it and see how it was put together with the use of the data input forms,
03:08
the data input forms then being used to enter the double entry transactions in a double entry system. And that since the journal entries, now as we go forward, you might be saying Hey, shouldn’t the next step be that we connect to the bank and we use the bank feeds to do the data input and create the balance sheet and the income statement, you can’t do that.
03:29
And we will have a whole section simply on the bank feeds. However, I highly recommend first getting some idea of the data input forms. Because if you just go right to the bank feeds, and you try to just connect to the bank, what will happen oftentimes is people get overwhelmed because they download a bunch of information from the bank.
03:49
And it doesn’t actually go all the way through into the balance sheet and the income statement, you still need to do some work to get everything set up.
03:57
And to do that work, you still need to understand what the forms are. Because even when using the bank feeds, it’s going to be using these forms. And depending on the type of business you are in, sometimes the bank feeds are a lot easier to use, you can use a lot easier of a system.
04:12
And sometimes you have to account for the fact that you have a bit more complication in place that you need to understand. And the only way to understand that is to really understand the cycles that we’re looking at, and how these forms are going to be impacting the financial statements. So that’s kind of why we’re doing the process that we are doing.
04:31
But again, if you wanted to try to jump to the bank feeds themselves and go right to connect into the bank, you can do so just kind of be careful, beware. So let me give you a little bit more detail on this in our sample file.
04:44
You could look at the bank feeds section by going to the banking drop down, we go into the bank feeds and let’s look at the bank feeds center here. So the bank feed center already has some bank feeds that have been set up I’m going to close this window on the left hand side with the carrot.
04:59
So these are the The bank accounts that we have basically put together at this point, I’m going to maximize the screen to the gray area.
05:07
And so if I go here, for example, on the second one, you can see there seven transactions are waiting to be added, meaning they’ve connected to the bank, the bank feeds have flow and through to our system, we now need to add those transactions to the system.
05:21
Now the thing that gets people messed up when they first start the bank feeds, if I look at these transactions, these are the three these are the few transactions that have been put into the system, but they have not yet been added to the financial statements.
05:35
In other words, they’re not being used to construct the balance sheet and the income statement, we still need to add some data to the system before they’re going to be going into the balance sheet and the income statement constructing our financial statements. So a lot of times when people start out, they connect to the bank, and they download a whole year’s worth of data.
05:54
And then they end up with all this stuff, which I call is in now bank feed limbo. That’s what I call it, because it’s in your quickbooks file. But it hasn’t been used to actually be part of your bookkeeping to construct the end result of the balance sheet and the income statement.
06:11
And then they don’t really know what to do, or possibly we start entering the actual transactions, not quite correctly, because we don’t understand how the forms work and that kind of stuff.
06:21
So usually, oftentimes the name of QuickBooks, and even the advertising of QuickBooks is kind of geared towards the idea that you could just set up QuickBooks set up the bank feeds, and everything will just work from there. But it’s not usually that easy.
06:33
And it could be more or less easy depending on the type of company that you are in. So just be aware of that, let me give you a little bit more detail on when it might be more or less easy to just try to construct your financial statement from the bank feeds.
06:48
So I’m going to open this back up with a carrot, I’m going to go into the homepage again. And let’s just think about different kinds of companies, I’m going to close the carrot up top.
06:58
And I’ll try to think about the easiest company it would be to just use bank feeds and then add some more complexity, when it might be more difficult to use the bank feeds or you need to have a better understanding before you could just enter the data into the bank feeds.
07:12
So the bank feeds would be easiest to use. If you have a system where you’re not where you’re not using inventory, it’s a service based business.
07:20
And possibly when you are getting paid, you’re just entering that directly as into the system as revenue, meaning you don’t need to collect through accounts receivable, you don’t need to have an accounts payable, this would basically be a cash based system.
07:35
But it would even be a step easier than a normal full service cash based bookkeeping system, because we could set up the system so that we are completely dependent on the bank data to create the financial transactions rather than using the bank data as kind of a double check of the data that we entered into the system,
07:55
which could work well for certain types of businesses possibly like gig work. So to imagine that you can imagine the two kinds of transactions that go into the bank account either there’s an increase deposit of some kind or a decrease, which we would typically categorize it as an expense of some kind.
08:11
If you have a separate bank account, from say, your personal account, it’s a business account.
08:16
And we were able to categorize everything that’s an increase as income and everything that’s going to be a decrease as an expense. And we don’t need really a whole lot more details such as the customers and vendor more detailed kind of information.
08:31
We don’t need accrual accounts like accounts receivable or accounts payable, those would be the easiest type of businesses to try to be just completely reliant on the bank data and use the bank feeds and be able to get things set up to be automated fairly easily. So again, that might be something like gig work,
08:48
if you’re getting paid through like a YouTube or some other platform, whenever you get the money, whenever you get the money is just going to be an increase and you’re going to record that as income on the income side of things, then that will be a pretty easy transaction for the bank feeds to basically enter into the system.
09:05
But note, it’s still not a full service, bookkeeping kind of system. In that usually, you would still be entering the data into the system on your end, even if it was a cash based system entering the data on your end.
09:18
And then you would usually check it to the bank to double check and then reconcile do a bank reconciliation to compare your books to the bank’s books. If you’re making your books directly from the bank data, then you don’t have that kind of comparison, the bank reconciliation while still necessary.
09:36
Still something you should do isn’t giving you as much of a double check. Because now you do not have to two separate entities doing the bookkeeping yourself and the bank that you’re comparing to get an outside check.
09:48
You just have one entity doing the bookkeeping or entering the transaction the bank and you’re just copying, you know the bank transactions or being dependent on the bank transaction. So it’s a little it’s a little bit Different.
10:00
Also note that if you enter transactions that are deposits on the, on the revenue side of things, if you enter a deposit as as something that’s going to go to income,
10:13
that’s not what QuickBooks is usually designed to do, because usually, it’s designed to create an invoice, and then a receive payment or create a sales receipt, and then record the deposit. So you’ll lose a little bit of information.
10:28
Because when you create these sales documents, which are usually the tools used to increase revenue, these will give you a little bit more detail in terms of the customer who gave you the money so that you could sort by customer. But again, you might not need that detail, you might just say, I’m just going to deposit it in here.
10:46
And I’m just going to call it an income account. And I might have a little bit more detail in the big feeds. Because the bank feeds if they’re electronic data transfers, give us a little bit more detail usually about who they came from.
10:58
So I can at least I can at least record it that way. Even though it’s being recorded with a with a deposit form and not using the the sales receipts forms. If you’re getting deposits that are not coming through an electronic transfer, like you’re getting cash money, and you wait for it to clear the bank,
11:17
then the bank feeds not going to have much data for you, right, it’s just going to say, hey, there’s a deposit. So you might not know who it came from, or anything like that.
11:24
But again, if it’s just revenue, and all you want to record is the fact that it’s an increase, then you could you could use the bank feeds, even though you might not have as much detail in in the records by doing that.
11:36
Now, of course, if you have an accrual system, which an accrual system is going to be necessary, not just because like you could pick one or the other, I want to be on a cash based system because it’s easier.
11:47
No, it’s the type of industry you’re in. So if you do like bookkeeping, or something like that, then usually you have to do the work first and invoice somebody. So if you invoice somebody, here, now you’re billing them for work that has been done, but you have not yet received the money.
12:03
So usually within QuickBooks, it’ll track that accounts receivable so that you can send out another invoice and so on. But notice that that will complicate your bank feeds. Because when I enter an invoice, there’s no cash affected, accounts receivable is affected, as we’ll talk about in the future.
12:20
And revenue is affected. No cash is affected. So when you when you deal with the bank feeds, and you have to track accounts receivable, you got to think Well, how am I going to fit in the bank feeds to the fact that I’m tracking accounts receivable, I can’t just rely on it, clearing the bank, because I have to track the fact that people owe me money through accounts receivable.
12:41
So that accrual concept will complicate the bank feeds a bit. Same thing on the expense side of things. If your all of your expenses are electronic in nature, meaning you use electronic transfers instead of paying people with cash, for example, then it’ll be easier to see that data in the bank feeds and assign it to the proper expense accounts.
13:03
So that can be a fairly easy, easy process more on a cash basis to automate over time. But if you’re in a situation where you have to track the accounts payable that you owe, so if you’re tracking the accounts payable that you owe,
13:16
and then you pay them at a later point in time, you have a similar accrual problem. Just note that most small businesses usually have this issue with the receivables more than the payables oftentimes, meaning you might be in a situation where you have to track the accounts receivable, and you’re more on accrual on accrual basis here.
13:34
Whereas on the vendor side of things, maybe you can be more on a cash basis, on on the vendors side of things. So so when we think about this cash and accrual concept, it kind of depends on the industry that you’re in, and what your particular needs are.
13:50
The other thing that really complicates the bank feeds is if you’re tracking inventory, so if you’re tracking inventory, then you got to think do I want to track inventory within the QuickBooks system on a perpetual inventory system?
14:06
Or do I want to track inventory, say outside of the QuickBooks system. And again, because there’s an accrual component, typically to inventory, meaning some financial transactions that aren’t impacting the bank directly,
14:20
for example, then it kind of complicates the bank feeds a little bit. So the general rule then is, we will look at bank feeds and we’ll talk about all these issues when we get to the bank feeds.
14:31
But first, we’re going to go over the normal bookkeeping process to basically learn the bookkeeping forms because that will help us to understand how to implement the bank feeds when we’re using the bank feeds. If you have an easy kind of bank feed setup,
14:46
you’re in a cash based system and you just want to connect to the bank you could jump forward to the bank feeds directly and go through that section there.
14:56
But I highly recommend if you want to fully understand things And you don’t have a full grasp on how everything works that you first think about the forms and the reports and so on and you’ll have a much better grasp it’ll be a lot easier to then enter the bank feeds