 QuickBooks Online 2023, e-commerce sales, upload example bank feed data from excel slash csv file. Get ready to earn the skills needed to boost your bank books on up with QuickBooks Online 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 our QuickBooks Online test company file using the accountant view as opposed to the business view you can toggle between the two views by going to the cog up top switch in the view down below. We've been looking at e-commerce situations where we sell inventory not on ground not in a store but rather online in the cloud with the help and use of third party applications for example a Shopify or Amazon as examples. No matter which method that we are using we're typically going to have the bank feeds as part of our integration to pull the information into our QuickBooks system. So if I go into my banking here we've got our integrations of our checking account and our PayPal account if you haven't set these up in the past that's okay you can kind of upload the data in a practice problem situation as we go and set up the accounts as you do that if you want to follow along with the practice problem. In prior presentations we've been thinking about a scenario where we look at our Shopify store we look at the reports into the Shopify store we pull that information into our system with a journal entry and then we also are going to see the payout information which is in the finance the payout reports and you can have a similar process with other softwares like an Amazon we might do an Amazon example as well but we talked about how we can do that from an Excel standpoint in prior presentations and try to use a journal entry to break out more information rather than just waiting for the data to hit the bank because then we're not going to have the breakout of the more information. So as we think about this method then we had our data on the left hand side where this is mirroring what we get from the PayPal this is this is the data on the sales data and then these are the pay the payments that are going to come out through PayPal and through the Shopify payments that are going to ultimately hit our bank account. So now I'm just going to mirror the concept of these payments actually coming through and hitting our bank account by setting up our QuickBooks bank feeds and I'm just going to import the deposits that are going to hit the bank accounts just so we can kind of see them in our example problem from a QuickBooks standpoint. So we did this in a prior presentation if you've been following along with prior presentations here but to to upload data into QuickBooks from bank feed data we can just make an Excel file that looks like this date amount and you might want to put description here I'll keep it at bank memo this is what the bank feed data is it's just going to have increases or decreases from the bank the bank knows when the money went in or in out it knows the amount and it knows some memo data it'll have more memo data if there's electronic transfers. So this is this amount that we're going to tie out here is this is going to be I'm calling it the the bank feed for the this is for the PayPal account so I'm just mirroring in our practice problem what happened here in the payout and I'm going to assume the payout PayPal is going to hit us with a $5 and 55 fee so the amount that's going to hit our checking account I'm going to say is this $12.94 so I'll put that here so I'm going to say we're going to work in October 25th 2025 in the future $12.94 and that's the amount of that's going to be the Shopify pay. All right let's go ahead and save this I'm going to say file save as and I want to save it as a CSV file and so I'm going to change it from an Excel worksheet to a CSV comma slice and that's what I can upload then to QuickBooks I'm going to say this is going to be bank feed let's say number two and I'll say okay save it and then I'm going to close this one and then I'll go to the other one I'm going to do a same thing Excel file but this time it shouldn't be Shopify pay well Shopify pay okay we'll keep it there but this one is going to be going into our checking account this time instead of the PayPal account in our bank feeds we'll have two bank feeds so I'm going to save this one this is going to be the amount that tides into our practice problem over here there's the amount in our practice problem let's save that I'm going to say file save as and we'll make it a comma sliced one again boom and let's say this is number two number two and okay so let's close this one and then if I go into my information these ones are the comma sliced ones as opposed to the the CSV files versus the Excel files so now I'm just going to upload this information into our bank feeds and this is how you would set up bank feeds or import the information if you're importing as opposed to a link to the bank feed so I'm going to go to the banking section I'm going to go to the banking up top and then if you didn't have these tags in here already then you didn't have any bank accounts linked you can you can add the bank accounts as you go but I already have them in place so I'm going to say upload from a file upload from a file and let's say we're going to upload then locate that file let's make it large so we could see them and can I make it large there we go so this is going to be checking account bank feed two let's do that one first and just pulls in very nice I'm going to put this into the checking account now if you didn't have an account set up you can add the checking account as you go it's going to be a bank type of account that we're connecting the bank feeds to but we're uploading instead of connecting to the bank and then it has the first column is a header and column one column instead of two column what's the date m m d d y y y y is it date date description should tie out to the bank memo and then the amount ties out to the amount so that looks good so I'm going to say okay there's our one item I'm going to pull in and boom it did it and so we'll save it import completed looks good and so now if I scroll down into my data for the checking account I've got my Shopify has been added so that looks good so obviously when I when we do this practice problem in here we're going to do the same thing we'll enter the journal entry which will go into the clearing account and then we'll be able to match that out to the Shopify payment and once I enter the Shopify payment it will net out to the clearing account so let's add so this so let's do the same thing over here and add uh not a link but upload another one this time however it's going to be let's hit the drop down boom it's going to be for a checking account for the paypal paypal bank feed and continue and this is going to be for the paypal bank and continue and we're going to say drop down date month month day day year year date date description is going to go to the bank memo and then amount boom continue pick it off that's the one you want check it off pick it off check it off and we'll say okay picking it off is when you throw something at someone checking it off is checking it off there's there's a difference get it right okay so I'm going to say tab to the left and then so there's our Shopify pay so so now when we imagine our practice problem what we'll do in the future presentation is imagine we pull this in with a journal entry which will put it into the clearing accounts and then we'll see our items clear the bank feeds and when and when we see it clear the bank feeds we'll put the other side to the clearing account which will bring the clearing account back down to zero that's the idea that's what we'll do next time uh it'll it'll be great