 QuickBooks Online 2022. How do bank feeds fit into your accounting system? Get ready because it's go time with QuickBooks Online 2022. Here we are in our bank feed practice file. We set up with a 30-day free trial holding down control, scrolling up a bit to get to that one to five percent currently in the home page. 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 accounting view down below, we will be toggling back between the two views either here or by jumping over to the sample company file currently in the accounting view. Back to the bank feed practice file. So how do bank feeds fit into your accounting system? That is an important question you want to think about before setting up bank feeds or at least before adding those transactions into your accounting system. If you don't think about that in advance, it's quite possible that you're going to set up the bank feeds. You're going to pull in a bunch of information into your system, which will be stuck in what I call bank feed limbo, meaning it got pulled in from the bank, but it doesn't have the necessary information to completely pull it into your accounting system to be used to create the end product of the accounting system. That being the financial statements, the balance sheet and the income statement. It's quite easy to get overwhelmed if that is the case or if that's the route that you take. And I can understand if that's the route you take because if you look at the advertising around bank feeds and just the name of QuickBooks, it sounds like it's going to be very quick and almost entirely automated. You'll just set up the books. You'll connect to the bank. The bank will then transfer the data into your system, which will just create your financial statements, balance sheet and income statement for you. That's not necessarily the case, although there are instances where you can make it a lot more automated and instances where you're going to have a lot more kind of still work that's going to be needing to be done within the accounting system, which will be dependent on things like are you on an accrual basis? Are you on a cash basis? What type of industry are you in? What kind of level of internal controls do you want over your accounting system? These are questions you want to consider, questions you might want to talk to your accountant about your CPA firm. If you have one about, and so we'll take a look at some general ideas about it here. So to look at this further, let's jump on over to a flow chart. Now this is the desktop flow chart, but it's a good flow chart that just shows us the general cycles of the accounting system broken out by the purchases cycle or expenses cycle or vendor cycle, the customer cycle or accounts receivable cycle or sales cycle, revenue cycle, and the payroll cycle or the employee's cycle. So the basic idea with cash flows, let's go from the easiest kind of scenario to the most difficult type of scenario, and that will typically be dependent on the type of industry you're in, the size of the company that you're in, and whether you're on an accrual basis or not, or a cash basis, which again will often depend on the type of industry that you're in. So obviously smaller companies are more likely to have a more simplified kind of accounting system and more likely to just be able to depend on the bank feeds. So the most simple system would be a cash flow type of system and one in which it's not just a cash flow, but you're going to step further in simplification in that you're going to be reliant simply on the bank transactions in order to record the information into your system. So let's look at that first on the revenue side of things, which I think could be one of the more confusing side of things, and then we'll take a look at like basically the payable side of things. Note that it's quite possible for you in essence to be on a cash basis system on one or the other, on the basically purchases or expense side, but not on the revenue side, on the revenue side, but not on the expense side, depending on your particular needs for your particular industry and of course the regulations involved as well, including tax codes and any kind of reporting regulations that you're trying to make the financial statements to comply with in addition to having the financial statements for your internal reporting needs. Now as we think about these just note that you can think about the bank feeds as in essence simply being what's on your bank statement. So your bank statement usually has like a summary, beginning balances, additions and then subtractions. This is just a mock bank statement and then it's got the data which at its least at the least amount of data that you would have on the deposits and withdrawals. Let's look at the deposits. You usually have a date and then you have an amount. That's what you're going to be inputting into the system at the minimum. You might have some more data that you can use. The system can try to use to try to figure out how to record things. If it was an electronic transfer, for example, then you might have something like the memo, the bank memo kind of information, which could include stuff that helps you to determine what the vendor is. However, the memo itself is not the vendor. It possibly includes information that you can create the vendor from and know who it was from, but the system can't just take that information at this point and just create or in this case the customer that you got the money from. If you're looking at the withdrawals, the minimum information would be the date and the amount and then if it was an electronic transfer, you would have then the same kind of memo line which could help you to determine who you paid, but it's not going to be something that the QuickBooks can automatically kind of put into place and it will not have the information for which account will be impacted, especially on the expense side. On the income side, we can kind of think, maybe it's going to be an income account if it was on a very simplified method, maybe I only have one income account. On the expense side, we've got a whole bunch of different expenses, even if it could determine the name from the memo, which you can't do without your help at least to start off with, then it still needs to assign that name to an account like utilities expense, telephone expense, and so on and you're going to need your assistance on that as well. Now if you have the checks that are involved, then you're going to have the the date which will not be as relevant because it's going to take longer for the check to clear, you'll have the check number, and then the amount. Again, that's not a lot of information just in terms of a raw bank feed to basically record everything that needs to be recorded, which would include the account that you're trying to record something to. So knowing that, let's go back into our flow chart and say, okay well what kind of system would be easiest that I can just automate as much as possible and just basically make our financial statements off of the bank feeds? That would be not only a cash basis, but one where we're reliant on the bank transactions. So in other words, even if you're on a cash basis, QuickBooks is designed for you to record on the revenue cycle, sales or revenue or income using one of these two forms, the invoice if you're using an accrual basis, the create sales receipt if you're on a cash basis. So even if on a cash basis, you can imagine a situation where you're at a register for example, then you would still be using the sales receipt if you were using the full service of the QuickBooks service. That allows QuickBooks to use things like items that allows you to determine and track the sales that you make by items, the services you provide or the inventory items that you provide. If you skip that step and you just say, I'm just going to go right to the deposit line here, you're using a form that you can then record directly to a revenue line, but it's not natural for QuickBooks to do that and you will not be using items. The items are the typical thing that drive and sort and give the more added detail behind the sub ledgers for the revenue type of line item. For example, they're also used to track things like inventory. So that's a little bit of added detail that you would lose if you're just completely reliant just on the banking information and not entering basically the create sales receipt. So if we jump just to the deposit, what kind of industry might that fit in? Well, if you're doing something like online type of stuff, if you get paid from advertising, like you do you do sales for other people or something like that and you do advertising, you get paid by platforms, if you do courses or something, if you get paid royalties, if you get paid from YouTube channels, if you get paid from the channels for courses online or something like that, then it's likely that you just want to get paid once it comes into your account. You're just going to assign it as revenue at that point in time. You're going to get paid with an electronic transfer so that you can probably see who it came from and you can easily assign it out to a revenue account. On the revenue side of things, that would be the type of industry that would be as easy as possible to automate the system as much as possible, going from not only a cash basis to a basis on which you're dependent on the bank and just basically putting your information in the system as it clears the bank. Now, if you if you have to have a cash register type of situation, then you're going to have a bit more difficult of a situation. If you're working at a cash register, like a restaurant, a food truck kind of area or anything like that, then you're probably going to get paid during the point in time of course like a register situation during the day, possibly recording with a create sales receipt as you go. And then you're going to have to take those multiple payments that you have received and deposit them into the bank, physically going to the bank, depositing multiple transactions in one lump sum amount in the bank. So in that case, you probably don't want to wait till it clears the bank before you before you actually record it in your system. What you would like to do is have an internal control that would be a control against making errors that you enter it into the system first with the create sales receipts, put it into the to the clearing account, which is called undeposited funds or in the newest system, they called it like deposit or amounts or cash to be deposited or something like that. And then you go into the deposit side over here, put it into the actual bank in that grouped fund both in your system and as it will be seen on the bank statement so that you can reconcile the two things. So that what that does is it allows you to record the individual sales transactions and gives you more detail because it allows you to basically record the transactions by customer. If you want that added detail, and it gives you that kind of double check that you can run the tape on what you actually recorded in your register compared to what you deposited into the system. And it gives you that double check that you can then have your deposit that you recorded into the system that you can match out to to what the bank has on their side in the bank reconciliation process. So in that system notice if you're making the sales receipts then you're going to have to still enter the data into the system on the deposit side of things. And then when they clear it when the deposits go through the bank and we'll show examples of this as we go through our practice problem but as they go through the bank you're going to match the deposit which helps you with the reconciliation process but it doesn't help you really to record anything new because you would have already recorded the deposit on your end in your normal accounting cycle. So that would be a more full service accounting cycle which happens to be on a cash basis because your industry is a cash basis type of industry but you're using a full service cash basis entering the sales receipts not being dependent on the bank. So it's a little bit more difficult in that it takes a couple more steps. It's not as automated you can't really automate the system as easily because you want to be able to record the sales receipts. Now then if you're in a situation where you're on an accrual basis system meaning you're in the type of industry where you have to give out an invoice it's going to be more complex you can't just rely on the bank to record your books if for example you're a bookkeeping or you're a law firm even if you just do service items and don't sell inventory for example you still are in a situation where you have to create an invoice for work that was done in the past possibly making billable hours entering those into the system sending out your invoice to the customer receiving every payment later that means when you create the invoice that's when the sale or revenue is increased and that is when you're you're going to record an accounts receivable and then track the accounts receivable hoping to get paid by the customer in the future then recording the received payment at that point in time and then you have that same kind of situation that you could have multiple payments that you receive so instead of putting it into the bank at this point you might then you might then group multiple payments together and deposit them all at one point in time so there's multiple areas where we can kind of we could theoretically fit the bank feed deposits in here we couldn't make an invoice wait till it clears the bank and then and then connect kind of the deposit to the invoice or we could create a sales receipt after we have the invoice and then basically get the deposit to kind of match up to the received payment or we can go through this full process in the accounting side of things and then match up the deposit that comes through the bank feeds to what we already recorded in our system helping us out with the bank reconciliation process so those are those and then if you had inventory that's another accrual kind of component so if you're tracking inventory then that's another area where you're usually going to be pulling away from a standard cash basis system if you're having to track the inventory so we'll talk more about inventory as well if we go on to the purchases the vendor side of thing that means this is the expense cycle and note it's it's possible to be on like a cash basis on the revenue and not on the vendor cycle or more likely for small businesses vice versa you might be more in a cash basis on the vendor cycle or expensive cycle a cruel basis depending on the type of industry that you are in on the revenue cycle in other words small businesses if they have the cash flow might find it easiest to just basically electronically pay the expenses as they become due so if you do that if that would be the easiest system to use on the expenses side of things to be reliant just on the bank feeds so in other words when something becomes due a bill becomes due you just pay it with an electronic transfer that comes right out of your account even if you use a credit card because it is possible to use credit cards and have bank feeds on the credit cards as well if you're paying for it electronically right when it comes due then that would be the easiest thing to say i'm not going to record it on my side at all i'm instead just going to wait till it clears the bank and then record the the related expense when it clears the bank either in the form of a credit card payment or in the form of a cash payment so that would be the easiest kind of thing to do once again you're stepping away from a from a cash basis method to go into a method where you're not recording it at all on your end you're depending on the bank to record it now if you were on a full cash basis system you would do something like record it on your end and then check that it clears the bank and that's still really important if you write physical checks because if i write a physical check then the the problem is the physical check takes a while to clear and if someone calls me and says they haven't been paid i want to be able to check to see if i actually wrote the check in the system and it hasn't cleared or if it's a system where i never wrote the check and that's a question that i can't resolve if i don't write the check and put it into my system as i write the check that problem is not as big if you have electronic transfers because you can confirm the like electronic transfer quite quickly at this point in time but it's still an internal control to if you were to enter it if you have a full service system you enter it into your system as you make the payment and then double check possibly with the bank feed helping you out with the reconciliation that it had cleared the bank now if you're in a larger company or if you have more stringent like cash flow requirements especially and this happens more when you have a whole lot of transactions because cash management becomes a lot more important in other words if i pay the bill at the end of the due date the end of the 30 day period as opposed to the beginning it's not a big deal for small companies which one i do because it's just a short time frame but if you're like a large company that has a whole lot of transactions like a credit card transaction it starts to add up to be able to pay your bills as late as possible cash management becomes more important so bigger companies tend to then want to go on an accrual basis entering the bills into the system which increases accounts payable the other side goes into the expense for example and then sort the bills to pay them at the end of the time period as late as they can without angering their vendor or without foregoing any kind of discounts they can get to pay it earlier so that's when you're going to use the accrual basis which that adds complexity for the bank feeds because then most likely you're going to enter the bills and then possibly pay the bills decrease in the checking account yourself and then double checking that to the bank or you could enter the bills and then pay the bills electronically wait till they clear the bank and then match the bank feed up to the bill so we're going to go over many different examples on on this in our practice problem we'll basically create a practice problem initially or primarily as if we're on the easiest system that we can just automate our system and make our books based on the bank feeds but we'll deviate from that on each of these steps showing an accrual basis where we have an invoice or a create sales receipt situation and showing situations where we have bills and how the bank feeds would kind of fit in or how they could fit in in multiple different types of ways as we think about those processes also note that if you're tracking inventory that's going to be another kind of issue because if you track inventory you have a couple questions do i want to track inventory within the accounting system or do i want to track inventory outside of it so if you track inventory in QuickBooks you're going to be using a what's called a perpetual inventory system and to use that you have to enter a sales receipt or a invoice when you make the sales because those are the items that are going to help you to track the decrease on this side of the inventory if on the other hand you want to use a perpetual a periodic inventory system you might track your inventory on a sub ledger outside on like an excel worksheet and then just enter it into the system and make periodic adjustments periodically at the end of the day the week or the month so we'll we'll talk a little bit about you know those methods with regards to inventory a bit more in future presentations as well so you want to keep these things in mind when you set up the bank feed if you set just setting up the bank feeds easy you just go into the bank feeds you connect it to your bank you've got some difficulties with regards to basically you know what your bank wants for security measures and whatnot but pretty simple to get those bank feeds in that's not the difficult part making sure you're setting them up properly in your accounting system is the is the thing that you want to consider the other thing you want to basically make sure of is uh how far back on the bank feeds do i need to get the transactions is it a new company where i just started this year or something like that and i want to go back say to january you you generally want an entire year of bank feeds in one system if possible rather than basically having you know half of your information in the prior accounting system for one year and half in the current year and then the then so the question is if it's at the end of the year for example at december and i need to reconstruct my entire year of bookkeeping for which is fairly common uh can i go far enough back to get that much data with the bank feeds and for that you also need to consider if i just connect directly to the bank they might not be able to go a whole year back or multiple years back uh so but you can sometimes go further back if you actually physically download the data from the bank so how much data do you need in the system what's the cutoff date of the data that you're pulling into your bank feeds have you already been doing accounting before and now you're implementing bank feeds how can i stop from duplicating data that has already been entered that cutoff date is also something that you want to keep in mind so we'll talk more about these as we go into practice problem