 QuickBooks Desktop 2023. Bank feeds, matching receive payment form. Let's do it within 2-its. QuickBooks Desktop 2023. 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. Here we are in QuickBooks Desktop Bank feed practice file we started up in a prior presentation going through the setup process we do every time in the view drop down we've got the hide icon bar the open windows list checked off open windows they're open on the left reports drop down company and financial let's open up P and L profit and loss change in the range in 010122 to 123122 and then we'll customize it to go to the fonts and numbers changing the font we want it to be 14 okay yes okay reports again company and financial this time the balance sheet will customize the report change that range from 010122 to 123122 and then fonts and numbers need to be changed to 14 okay yes and okay then we'll open up the bank feeds go into the banking drop down we're in the bank feeds bank feed center which will only be there if you got bank feeds turned on which we've done in a prior presentation so within the bank feeds i'm going to go into the unrecognized items we're focused in on the deposits now let's just take a look at our home page and prior presentations we've been focusing in on the deposit side which is the end process of our customer cycle typically we started out with the easiest kind of business that being like gig work for example getting paid by like youtube or something in which case you can wait till something clears the bank record it in the bank feeds or with the use of bank feeds as a deposit using that deposit form although we're not using the natural form to record revenue which is typically even on a cash based system the sales receipt form or on a cruel based system the invoice form now we're taking a step back and saying well what if we're in a more complex accounting structure such as a system where we have to invoice someone first and then we get paid like a bookkeeping firm a landscaping firm we do the work and then we invoice the client and then we're going to get paid in the future with the received payment where does the bank feed fit in normally you would think you would do the full process enter the invoice increase in accounts receivable other side go into sales receive a payment from the customer decrease in accounts receivable usually putting it into undeposited funds that being the default for quickbooks then taking it out of undeposited funds putting it into the bank in our system that is into the checking account and then use the bank feed to match out to what we have already entered the bank feed then not recording anything new just reconciling the bank deposit to our deposit however we saw last time that it is possible for us to enter an invoice and then connect the bank feed directly to the invoice which then records automatically the received payment and the record deposit we also could imagine a system which will do this time where we create an invoice then we receive the payment and then we wait till the bank feed clears and we match out the payment that we receive to the receive payment taking it out of undeposited funds and putting it into the to the checking account recording the deposit let's see how that would work with the bank feeds first let's pick a deposit that we're going to use so i'm going to go on over to the bank feeds and let's just say that we have a deposit i'm just going to pick this one google adsense so let's say we're going to use that one that's for the one three seven eight oh five i'm going to go back to the home page and make up an invoice so i'll make up an invoice that's the first starting point we'll say customer one again and let's say when did this deposit happen let's just make it before let's make it oh seven oh one two two and then we'll say that the invoice was for service item number one so we're just going to use a service item and the amount what was the amount again uh one three seven eight oh five one three seven eight point oh five there we have it we're going to say it's it's non taxable subject to sales tax but even if it was subject to sales tax the same system would still apply we're focused here on where do the bank feeds fit in this would increase accounts receivable by the one thousand three seventy eight oh five the other side going to say let's actually make another one let's make another service item to say i'm going to say this is going to be a new service item and let's imagine it's going to a different income account let's say this is this was for amazon uh income wasn't it no this is for google google income and then i can take it to non taxable and we'll take it to that google we think we set up a google account didn't we we set up a youtube account was it let's take it to youtube income and so we'll do that non taxable so there's the item and so now it washed out the number so now it's going to be one three seven eight oh five so one three seven eight point oh five okay so there we have it let's save it and close it and then in the balance sheet we should have accounts receivable double clicking on it it goes up by that uh invoice right there on seven one double clicking on it there's the invoice it's passed due in bright red there okay so then we're going to close that back out the other side went to the sales and we now put it using the item into into the youtube thing because it was google i think so it went in here so we use the invoice there it is with the invoice as opposed to last time when we entered it in with a deposit which is unnatural to see a deposit in the income items which would only be done if you're in a special kind of system where you're using the deposits to record income otherwise you would expect in the income accounts to see invoices or sales receipts but we're going to close that back out going back to the to the to the balance sheet we're also going to have the sub account tracking the accounts receivable by going to the reports drop down we're going to go into the customers and receivables we got the customer balance detail so there's the one three seven eight here the total ties out to 143808 that should always match what's on the balance sheet and if we go into our customer center we can track the invoice by customer here as well so here's the the latest invoice was this one we can also look at just the open invoices for example i could filter this down to just looking at invoices and maybe then i just want to look at the open invoices so we can filter it that way we can also use this tab by the way to go to invoices and maybe we want to look at just the open invoices and then the next step we would want in the process is to make the payment so now homepage we saw last time that it's possible for us to connect and wait so the payment clears the bank and then record the receive payment and deposit with the bank feed so we saw that's what we did last time if i go to the to the bank feeds we could then go in here and match going to the mat i won't do it this time but just so you could see it you can match it here and that's what would happen match it to that invoice but instead we're going to say i'm going to receive the payment and record record the second step myself this time so i could do it by going in here and then i could select the customer and select the invoice oftentimes people might actually do that second step closing this out by going to the customer center and finding the invoice through the customer or through this area and say okay there's the invoice then i'm going to record the receive payment connecting it to it and there it is now it checks off the receive payment and so there's the amount seven one so i'll go ahead and keep that the same date and then this would put it what's this going to do it's going to decrease the accounts receivable the other side's going to go into undeposited funds by default now if i double click on this you can see the invoice it's connected to note that you could also deposit this directly into the checking account with the receive payment let me just show you how that would have to be done because it's not available by default that option we could go to the preferences we could go then to the payments and the company preferences we'd have to uncheck this box and it's going to close all the windows and i'm going to have to open them all back up but let's go ahead and do it we're going to say okay and then quickbooks is going to close all the windows you have not recorded the newt do you want i'm not going to record it yet i'm going to say no don't record it and then i'm going to open everything back up home page let's just open the home page for now go back into the receive payment and then if i type in customer one now i can get back to where i was if you do not enter amount received okay so now i have the option of undeposited funds this little option wasn't there before you don't remember now it's there so we've got undeposited funds but we could also deposit it directly into the checking account now that's useful like if you're going to get paid by check or electronic transfer and you know you're going to be able to match that out in the same format as well what will go into the checking account that's nice to be able to do that i still kind of like that it goes through undeposited funds and then depositing it with a deposit form because if you use this method to deposit directly into the checking account when you sort your checking account you're going to have two types of main forms that are increases to the checking account you're going to have deposits and then receive payments which could increase the checking account whereas if you go through undeposited funds you're only going to have basically deposits that are going to increase the checking account which can make sorting a little bit easier you might also have transfers as well but so in any case we're going to keep it at undeposited funds and record it as the default save it and close it you can see this little red dot here is indicating that something is tied to undeposited funds when i click on this you'll get that pop up and there's the item that's assigned to undeposited funds normally i would finish this process make the actual deposit grouping the deposit in the format that i expect to clear the bank in and then using the bank feeds to just match to the deposit form and note that if i had multiple received payments and sales receipts that were say cash for example and then i group them together when i make the deposit into the checking account i would have to use that system because what's going to show up on the bank feed and on the bank statement is going to be a lump sum of multiple received payments and sales receipts therefore i have to use the undeposited funds and deposit it in order for for the matching of what's on our books to match the bank statements that also happens with credit cards possibly where the credit card company will group your deposits in some format that you'll have to reconcile with in some way so that you can deposit in our system in the same format so that you can tie out to the bank feeds and or the bank reconciliation but if you're if you're getting like a check that you know is going to tie out exactly to the to the invoice or an electronic transfer that you know is going to tie out then then you could deposit it right here or it should be pretty easy to match out the deposits so i can let's open up the balance sheet in the income statement so i'm going to open these back up because they made me close it i won't make you watch it but i'm opening back up here so then i'm going to go back into the balance sheet and now we can see if i go into the accounts receivable that's going to be decreased because with a payment form double clicking that we could see that has the payment form there closing this back out closing this back out the other side went to undeposited funds which which is right here double clicking on it and so there's the undeposited funds it did not yet go into the checking account again the next step then would be to take it from here into the checking account and when we deposit it into the checking account we can also see if i go to the customer center for customer number one and i go to customer number one and i look at all transactions again now we've got the invoice and we've got the the sales we've got the invoice and the payment that should tie out that's the wrong invoice here's the payment there's the invoice if i go to the transactions over here and just look at the open invoices you could see that that one we had before has now disappeared from the open invoices okay so now we're going to go to the bank feeds and use the bank fees to take it out of undeposited funds and make the deposit form which is in essence the same as clicking this item and checking this off we're going to move it from undeposited funds we're going to record the deposit so let's do that with a match on the bank feeds so i'm going to go over here and all the system has to to match this out is really just the amount and the fact that it's a deposit and possibly the closeness of the date and but we have the added detail if it's an electronic transfer of this information to kind of be able to determine that these two things should be connected out and if it was a check you might have to cancel check that could help so i'm going to then say drop down match it and then this is the one we want right here and it looks like i miss keyed it by by three cents off so that's not that's not good so you don't really want to force it to reconcile here because it should match up but i'm not going to go and adjust it i'm going to say let's go ahead and resolve it and say that the adjustment is going to go to customer one account i'm going to say what was it youtube i think and then it was for the point oh three adjustment so save hold on a set the total does not match to say it's got to be negative negative boom okay so that does it so save it so i'll make that adjustment and then i can go back on over and say which you wouldn't really generally need to make the adjustment like that but that's the last component so if i go into the checking account then i'm going to customize it and let's see if we could then filter and look at just the transactions that are the transaction type of a deposit and then say okay see if we could find this deposit so i believe that's the one right is that the one we just did let's double click on it and so yeah i split those two out so there we go so then i'm going to go okay closing this back out closing this back out the other side comes out of undeposited funds which is gone now you could find it by going to the customize and then advanced and i want to see everything that has been active even if it has a zero balance okay okay and then you should we should have then the undeposited funds i could double click on that and then it removes it from undeposited funds and puts it deposits it into the checking account so there we have that double clicking on it there's the transaction so the dates are a little little wonky here because we're working in a practice problem but that's the general idea so if i go back to the home page it's possible then for us to enter an invoice and then connect to the bank feeds to record this and this or to enter an invoice and then a receipt payment and then connect the the uh the bank feed to the receipt payment to take it out of undeposited funds and record the deposit and then we could also if i was to deposit it directly into the checking account with this form then it would show up in the checking account as a receipt payment just let me show you what i mean by that if i close this out bank feeds checking account most of the time the increases are deposits right so if i was to sort by deposits as we filtered up here and i went filters and sort by deposits we would then get for most companies all the increases although some companies might have transfers as well that you'd have to pick up but if you if you entered the stuff in here with a sales receipt then you'd have a receipt form that you'd also have to kind of make sure that you pick up when you're trying to look at the increases that's why it's a little bit confusing for the sorting of it but you could then make it this go directly into the checking account and then you can use of course the bank feed to tie out to the deposit which you made with the sales receipt form which wouldn't record anything new because you already put it into the checking account at this point and then the third method would be that we take it out of undeposited funds and we deposit it in our books on our side and then tie it out to the bank which with the bank feeds which is the method you would have to use if you're going to receive multiple deposits either from cash payments or like credit card groupings which are then going to be grouped on the bank on the bank statement which are going to come through the bank feeds as well as one lump sum then you're going to have to record this on our side in the same matching lump sum so that we can properly match everything out using the bank feeds and or the the bank reconciliation so we'll talk about that next time and then we'll go into the sales receipt same kind of issue with the sales receipt this being the form that you would use if you're like at a cash register kind of situation so let's just open up our trial balance see where we stand right now and just to get familiar with it 010122 to 123122 customize i'm going to bring it up to 14 or 16 let's say and again it's just useful to try to visualize your assets liabilities equity and then your income statement accounts income and expenses on a trial balance if we were to do that it gets a lot faster for us to go from the data input forms whether that be from the the bank feeds or from us putting the data in from the home page or other forms to seeing what happens to the end result financial statements balance sheet income statement basically being represented one on top of the other with the trial balance