 QuickBooks Desktop 2023 Bank fee transaction for income deposit for online cash basis business overview let's do it within two it's 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 u2 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 view drop down we got the hide icon bar open windows list checked off open windows open on the left reports drop down company and financial opening up the profit and loss the p and the l change in the range from 0 1 0 1 2 2 2 12 31 2 2 then customize in the report to change the fonts and numbers to 14 okay yes and okay reports drop down again company and financial this time the balance sheet report then i'm going to customize it and let's change the range here from 0 1 0 1 2 2 to 12 31 2 2 and fonts and numbers changing the font up to 14 okay yes and okay then i'm going to go to the banking drop down and into the bank feeds to go to the bank feed center which is only there if you got bank feed set up which we did in a prior presentation and so now we're going to start thinking about the deposit side of things for the increases to the checking accounts that are going through the bank feed so i'm going to go into the uncategorized i'm going to group it this way and note that when you're talking about increases in the checking account from a business type of activity we're hoping those come from customers so that when you would think that the other side would be a kind of revenue so before we start adding those let's first go back to the home page because this is where we often have more complexity on the revenue side of things with regards to how are the bank feeds going to fit into our accounting system oftentimes when you're talking about small businesses for example then on the vendor side or the expenses side the outflow of cash side of things for goods and services it becomes easier because you're usually going to use more of a cash based system in that you're paying for things either with transfers from a checking account or some kind of financial account or transfers from a credit card which can both use bank feeds so unless you have inventory that muddies up the waters or you are dealing with bills so that you're entering stuff that has an accrual component to it tracking accounts payable before you pay it then then the bank feeds are often going to be kind of easy in that case on a cash based system for the vendor side for the customer side however there becomes more complexity depending on the type of industry you're in so just a recap on that the easiest kind of industry to be in to try to create your financial statements directly from the bank feeds would be something like gig work meaning you're getting paid from like a platform you're just a you're just a content creator or something and you're getting paid by the youtube platform you don't have to deal with inventory or anything like that and you just wait till the platform pays you and then when it comes through as a bank feed you record it as a deposit then using the bank feeds but the bank feeds will create a deposit form now that is could be a great system in that case because you can automate the system very nice however the deposit form being used as the form to record income is not does lose some of the things that you would have if you use the forms that are designed to record income within quickbooks which even if on a cash based system is not the deposit form but would be the create sales receipt form and if you're on an accrual system you would then have the invoice forms these are the two forms designed to record income so if you record income by just depositing at the end of the day with a deposit form that could be a great system but you're going to lose some of the detail which could be the subsidiary reports which are supporting say the revenue line breaking out revenue for example by customer and breaking out revenue by item what it is you sold whether that be inventory items or service items that might be well enough you might say hey i'm willing to sacrifice that if i can just automate my accounting process in that case now note that if you're not in a system where you're in like a gig work situation but still in a cash based system say you have a register then it's going to become more complex because you don't typically want to say collect money add a register and then deposit the money physically but wait till the money clears the bank and then record the income as a bank feed when it comes through because you usually want the added internal control of counting the receipts as you record them and tying them out to the physical money that you have and then depositing that into the bank and recording it on your end and then double checking from your side to the bank side so usually in a register situation even if you're still on a cash based system you're going to want to use the create sales receipt that will also track what it is you're actually selling because you'll set up the sales item whether they be service or inventory which will allow you to break out your sales by item as well given your little bit more detail in that case so there you either are going to are going to create the sales receipt and then you could deposit it directly into the checking account from here or more likely you're going to put it into undeposited funds and then deposit it into the bank account grouping the sales together in the same format as they will appear on the bank statement making the bank reconciliation easier which you can kind of help the reconciliation process by using the bank feeds tying the bank feeds out the deposit that clears the bank to the deposit you made in the quickbook system and then if we had a full service accrual system which would depend on the industry we're in if we're a bookkeeper a landscaper or something we often have to do the work first and then invoice the client for the work done after we did the work and so that's an accrual concept we can't just rely on the bank feeds to do that and then we got to follow up and collect the money which is the receive payment item and then we've got to make the deposit so we have three potential areas we can tie the bank feed here we could make an invoice and then try to wait till something clears the bank and use the receive payment from the bank the deposit in the bank to try to tie the invoice or we can go to the receive the invoice and then record the receive payment on our side and then try to tie out the the payment from the bank feed to the receive payment or we can make the actual deposit and then just match the deposit which is probably the most common way that you would be doing this if you had a system that you had to track the invoices now we're first going to think about the easiest system which is that where you were just going you're just going to deposit I use the deposit form so we have gig work or we're going to just get paid from platforms and we're just going to wait till they clear the bank we're going to have the transaction detail in our system and then we're just going to add them to the profit and loss now as we do that just a couple things we're going to focus on the income statement now on the revenue side of things so when you create your income statement accounts normally the general rule would be that you want to have very fewer income statement accounts like if you sell stuff you may call it sales that would be inventory sales if you have service items you might just have one account called service items because you don't really want to put something there for every different thing that you do or sell because usually you'll have other reports such as the sales by customer and the sales by item reports to break out that other detail however if you're not if you're just using a deposit form to record revenue as opposed to an invoice or sales receipt you won't have those other reports and therefore it's more likely in gig work situation that you're going to actually name your income accounts kind of like by the vendor meaning normally I wouldn't name an account by the vendor even like a youtube revenue I wouldn't say I got a youtube revenue income account but rather I would say I've got I've got you know a course or content revenue because then because then I can have multiple people that are paying me that kind of revenue from content revenue or whatever and then I can break out the detail of who paid me by going to the other reports breaking it out by customer which would be youtube and the other customers but in this case I can't do that because I'm not using the the sales forms or the invoice forms which break out by service item I'm just using the deposit and therefore it's more likely in this scenario that you're going to be making income accounts that are just called whoever's paying you the income the platform that's paying you the income so again that's just keeping on that's not the normal thing you'd want to do if you were using the sales revenue and the invoices okay let's see how this might play out so I'm going to go back to the bank feeds let's just let's just kind of review because we do some gig work here so let's just kind of review let's look at the deposits and think about let's actually sort this I'm going to sort this by a deposit filter it by deposit and then we'll consider some different kinds of deposits and some issues you might have in a gig work type of scenario so it's sorted this way so so for example we've got amazon so if you get paid by like amazon if you're doing something at amazon where you're getting paid by just by by just uploading content to amazon then again it's pretty straightforward you can wait till something clears the bank and then you can just record it as income when it clears now obviously if you have inventory related to it then you've got the added complexity of do you need to and how are you going to track inventories are going to be within quickbooks or outside of quickbooks do you need the perpetual inventory system or periodic system how much detail do you need that of course is going to get more complex something like an audible so if you get paid by audible for again just content then again you could you can imagine setting up an account if it wasn't just a deposit for like content revenue or audiobook revenue but because we don't have that added detail we might make an account just called audible audible revenue and then again we could just wait till that clears the bank because it's gig work or like you know platform work and then just record it that'd be easy the easiest thing to do adsense google revenue youtube revenue so like the same kind of thing if you're getting paid by youtube then you could just wait till it clears bank right and then just record it and that's pretty straightforward interest payments are typically going to be similar so they're gonna they're gonna come through and when you get interest on your bank account or something you could just record that as income now where things get a little bit confusing on the gig work is stuff where you have an intermediary platform such as a paypal or like a stripe or something that is intermediary to be collecting the income so you might be working for some platform that doesn't just pay you directly to your checking account but they pay you through paypal so paypal used to be kind of like an intermediary type of thing meaning they pay you through paypal you take it out of paypal and you put it into your bank and that's how a lot of people kind of use it you didn't have a lot of stuff going on in paypal but now paypal more and more is being used as like a bank account so so now your question will be well do i want to use paypal as just an intermediary type of account meaning i'm just going to use it as a collection tool and then i'm going to take it out of paypal and just put it into into my account immediately if that's the case then you might just wait till it hits your checking account and record it as income you know when it gets to your checking account and also this could be an easy way to do it if you're only getting the same kind of income that goes through paypal so i don't need to distinguish different revenue sources going through paypal i'm just going to say hey it's all the same kind of revenue that's coming through paypal it's all coming from this one gig work platform or whatever so i'm just going to record it as income when i transfer it from paypal to my account however if you're using paypal to pay out other expenses which oftentimes more and more people are doing that these days with the online work then paypal is now being used as more as a bank account and what you would like to do then is set up another tag as paypal being a bank account and then these would be showing up as bank to bank transfers and the bank feeds now setting up paypal is a little bit more complex on the desktop version because it's not as easy to set up the direct link to paypal online version for some reason is is getting better at that so you can actually set it up but you could still download the transactions you got to download the transactions as a csv file and then you can import them you have to convert them to a quickbooks file and then import them so you could do that that you know that's one method that you can use to try to have another card up here for paypal so and you might also experiment with plugins i believe there's some plugins that claim that you can do that as well so we won't dive into that but that's another kind of option that you can look at it would be nice if you can pull in the paypal if you're using it as a bank account to just pull in the bank feeds so if you can have a plugin to do that or if you can download the csv file periodically and convert it to a qbo file which not not an online but a data file from and then just upload it like we did before that would be another option so the other one and then like a skill shares another platform that you might get paid from and like i say that would be pretty straightforward if they pay you directly then you can have that come and then stripe is another kind of intermediary payment platform and again the question would be do i need to set something up with stripe so i can pull all the detail in from stripe to the quickbooks file or can i just say all the stripe income is coming from the same source possibly so i don't need that added detail when it comes and hits my account i'm just going to record it as income would be would be your options with stripe those intermediaries are all often where the confusion comes into play and the question would be with paypal the question is are you using it as a checking account and then and then you might want to put it added as a bank feed oftentimes with stripe the question often is are you getting paid from multiple sources do you need to track things like the customer that paid you into stripe or something like that if so you might be able to look into two apps and whatnot they can pull that data into quickbooks or can you just have that data somewhere else and within quickbooks you're just going to record it as income when the income hits your checking account with the intermediary being stripe all right so those are some of the options now i'm going to let's pick one of these let's just pick like stripe here and imagine i'm just going to wait till that clears the bank i'm going to assume it's all coming from one source and so i'm just making this up right so i'm just assuming this with this data that it comes from one source and then i'm just going to pull it in to an income account so i might say okay the let's put in the payee i'm going to say the payee is stripe i'm just going to make up the payee as stripe here because the payee is actually the person that paid stripe but the person that paid stripe i'm going to imagine in my case maybe it comes from like a website so i've got like a website and and the stripe is the intermediary that people pay me through a website right so i don't instead of me setting up the stripe data so it all comes through to quickbooks so i have all the customer data of all the people that are on the website maybe i just say okay i'm going to track that somewhere else and i'm just going to record the income to get the financial statements correct within the within here so i'm not going to set up each customer that's paying me through the website i'm just going to call it stripe as the vendor even though stripe is really the intermediary platform i'm going to say quick add and i'm going to call it a vendor and then the account is going to be some kind of income accounts i'm going to add a new account note that no matter how you set up your income accounts if you set it up with a with uh by selecting an industry quickbooks isn't going to have the proper income accounts for you if you have a gig word platform kind of thing because you're probably going to do what i'm doing here and add income accounts named after the platforms that are paying you so and that's one reason why i set up this one without any accounts or a bare minimum of accounts so we can just set up the accounts as we go so i'm going to say add it's going to be an income account now i don't know why when you have income here quickbooks still kind of makes the default as an expense you got to remember if it's you would think the default would be an income account if it's a deposit and then i'm going to say the name of the account i'm going to assume that this is this is from a website so i'm going to say this is my website account like coming in from my my whatever my paid website that i have that i'm imagining they're paying me for whatever i'm selling on the website subscriptions or something so i'm going to say website account and then i won't make it a sub account i'll just keep it there and that looks good that's all i need so i'm going to save it and close it and so you could then make a rule on the deposit side as we did with the expense side same idea here being that this should make it more automated going forward so here's our data stripe account website that looks good and then i'm going to add a rule there's rules here and so this is going to be i'm just going to call it stripe rule and it's going to be a money in rule as opposed to money out this time and once again we could do any or all doesn't really matter if we only have one line item you've got similar options for money in as with money out the memo the amount and the description we're going to keep it at the description which is most common you can either match the description or i'm just going to say it needs to contain i don't need this whole thing if it just says stripe then i think i'm good right so even if they change their banking code it should be good if it says stripe in it if it contains that rename stripe and then category is the website sales that looks good let's save it let's save and add to register so now it added that one item here if i go into the profit and loss now we've got our website items and if i double click on that it uses a deposit form note if i double click on this i go to a deposit form not to the banking data just like when i enter a decrease it usually makes a check form this is the form used to increase a cash type of account a checking account the other side you can see going here to the income account so i'm going to close this back out close this back out the other side that is the profit and loss account the other side go into the bank account i usually go to the bank account first end of the bank account we then have the deposit there's the deposit right there boom and there's the deposit form closing this out closing this out let's just add the rest of those just to see how we will add some of these i'll try to go to the recognize i'm only going to rat add the income items so i'm going to say let's just add the deposits so i'm going to go from here down to here just to show and i'm holding down shift so i can select all the all those and then i can batch add them hitting this and since i'm just gonna i'm gonna add and confirm them at one time and then i'm going to keep the outflows because i might use those later for other examples if i run out of stuff that i have to to use them so i'm going to go back on over to the profit and loss and you can see all those all those pull over so that's how you can automate the process uh going forward which is nice and then on the banking side all those are now in the checking account we've got a positive number in the checking account that's that's good we still have that beginning balance issue that often is the case that we might talk about meaning the beginning balance in the checking account before we start entering the bank fee transactions so we might talk about that more in the future so let's just pull up the trial balance just to observe the trial balance how it can be useful from mode one oh one two two to twelve thirty one two two customizing it fonts and numbers changing it up to fourteen okay yes and okay now again as we get more data here as we get more accounts that the trial balances it slims everything down makes it a lot more condensed if you can see assets and then liabilities and then equity and then the income statement income and expenses even if you're not completely familiar with the debits and credits it could be a good tool to be entering the data with and then jumping over to just a trial balance being able to then find which accounts are affected more quickly drilling down on them making sure that what you thought should be happening is happening