 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 and prior presentations we've been thinking about a scenario where we look at our Shopify store we look at the reports in 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 five dollar and fifty five fee so the amount that's going to hit our checking account I'm going to say is this 1294 so I'll put that here so I'm going to say we're going to work in October 25th 2025 in the future 1294 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