 Save it and then I'm gonna close this one and then I'll go to the other one I'm gonna do a same thing Excel file, but this time it shouldn't be Shopify pay will Shopify pay, okay? We'll keep it there, but this one is gonna be going into our checking account this time instead of the PayPal account in our bank fees We'll have two bank feeds, so I'm gonna save this one. This is gonna 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 gonna 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 gonna 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 gonna go to the banking section I'm gonna 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 gonna say upload from a file upload from a file and Let's say we're gonna upload then Locate that file. Let's make it large so we could see them and Can I make it large this way? There we go. So this is gonna be checking account bank feed to let's do that one first It just pulls in Very nice. I'm gonna 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 gonna 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? MMDD 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 gonna say, okay There's our one item. I'm gonna 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 when I when we do this practice problem and here We're gonna do the same thing will 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 Not a link but upload another one this time however It's gonna be let's hit the drop-down boom It's gonna be for checking account for the PayPal PayPal Bank feed and Continue and this is gonna be for the PayPal Bank and continue and We're gonna say drop-down date month month day day year year date date descriptions gonna 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 Thicken it off is when you throw something at some checking it off is checking it off. There's there's a difference get it right Okay, so I'm gonna 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 will 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 It'll it'll be great