 and try to put that into our system with a journal entry. So let's see what this, it gets a little bit more complex. Let's see what this will look like in Excel and then we'll do the same thing in a QuickBooks. So what I'm going to do is I'm going to copy this part from F to M. I'm going to right click and I mean I'm just going to, well you could right click and copy. And then I'm going to put that right here and right click and paste it. And then I'm going to hide this stuff because I want to see my data on the left hand side. I'm going to put my cursor on F, the skinny, and go on over to M, right click and hide all of that stuff. And so now we've got a nice little worksheet that we can work on. I'm going to just delete everything that's in it. I'm going to make that red thing go away by putting my cursor up here and going to the home tab, font. I mean format painter and paint brush that away. And then let's make this get rid of that data. All right so now we've got our nice little system that we can put in here in a journal entry type of format. So now what I want to do is think about a journal entry that's going to help me to grab all of the detail from these reports. So we'll make and you can start to format just a generic journal entry when we do this in QuickBooks. And this again is similar to what some apps are doing when they're trying to integrate and pull in data into the system. It's a similar kind of process here. So we'll start off with the Shopify sales. I'm not going to worry about debits being on top. I'm going to pull it in as I'm thinking about it. So I'm going to say well I know that I have Shopify sales. So let's just call that Shopify sales. I'm going to say equals that one. And the Shopify sales are the gross sales from our report. I'm going to put the sales as a negative. So I'm going to say negative of this number because revenue from a debit and credit standpoint is a credit and I'm representing credits with negative numbers. I know that's a little bothersome to people but we have to deal with debits and credits when we do the journal entry. So that's what we'll do. And I'm dealing with one column because that's the most efficient way to deal with it and negative numbers in Excel. So I highly recommend if you're an accountant thinking about formatting like that because it really saves space. And then we've got the Shopify discount. So Shopify discount and we said that one is going to be a debit. So I have it as a negative number over here. So I need to flip the sign. I'm going to say negative of that number. I'm just pulling in the data with formulas which is my habit of doing when I'm working a practice problem to have the data over here and then pull the information in with formulas. Okay. So this was the sales and then we had discounts which lower it's going to be kind of like lowering the sales. So we could record that separately as like a contrast sales line. So here's my sales and then the discounts. We could group them together. Here's my sales after the discounts. But the whole point is here we're breaking out some of the detail of these line items. And then if we had if we had Shopify returns we didn't have any Shopify returns but just for the sake of keeping our journal entry with all the different components that could be in here we'll put that in there and then Shopify shipping income. So now we're going to say hey look this is what we our sales number was but then we had shipping income meaning we charged the client you know for the for the shipping. So that's so we had to collect another 46 and that should be negative because it's going to be an income amount. So it's going to be a revenue amount. And then we had sales tax payable. So let's say we had sales tax payable. And so this is an amount that we charged the client for the sales tax but we're going to owe it to the government. So we should in theory put it in the books on as a payable it shouldn't hit the income statement. So we collected that from the client but it's going to go into our books as not revenue but rather a payable. And then I'm going to say we have the Shopify clearing account Shopify Shopify clearing account. Now the clearing account is people question like why why do we need the clearing account because we're going to try to not put it directly into the checking account because notice that I'm getting this information from reports and the Shopify clearing is going to eventually clear out into the checking account. But we're not there yet. And before I do the clearing basically hold on I'll get into the clearing in a second before I do the clearing let's do the Shopify let's do the Shopify PayPal clearing account first. So the PayPal clearing why do we need a PayPal clearing same kind of thing that we're looking at these reports which show that there was a payment that went through the payment portal of PayPal. So we someone got on our Shopify store they didn't use the Shopify payments they used the third party integration of PayPal so we expect then the deposit to come in through PayPal into our bank feeds although there could be fees related to that amount which we'll have to deal with on the PayPal level of things. So instead of putting this directly into the PayPal checking account we could do that because then we can try to match the PayPal checking account to this report but it might not match exactly because of the fees on the PayPal level. So what we're going to do is we're going to put this into a clearing account and then when the payment comes through the deposit comes through on the checking account we'll net out the clearing accounts the clearing account goes back to zero. This is one of the most confusing components not only with this manual entry process but with a lot of the apps that people kind of recommend so you're going to have to deal with this concept and so it's useful to see it in Excel so you can kind of see what's going on here. So then we have Shopify fees so let's pick up the fees down here. These are the fees you'll recall that happened on the payout report. The fees from Shopify because these are the sales that were paid out with the Shopify pay not with the third-party PayPal integration and Shopify charged us the fees then which we're going to see come through before we get the payment that comes out. So this payment should tie out exactly to what we get in our checking account whereas this payment to the PayPal most likely will not because PayPal is still going to hit us with some fees before it hits our bank account. So we're going to say all right this one is going to be this 354 actually hold on a sec this is the 15 and I need to flip the sign so there it is okay and then I'm going to have the Shopify clearing account Shopify payments clearing account so this is the other one that eventually and that's going to be let's pull the number in that's going to be this number this is the other one that will eventually go into the checking account and we could put this one directly into the checking account probably because because this is the amount that exactly should hit our checking account because there shouldn't be any other fees because we're getting this information directly from Shopify not a third-party payment app like PayPal where the PayPal is going to hit us with fees so if I put this directly into the checking account then I probably once the deposit clears the checking account could use the matching mechanism in QuickBooks and that would probably work okay but this idea of using these these clearing accounts is usually a good practice because then if there is any discrepancies then we can deal with it on the clearing account level so we'll see what these clearing accounts do now if there was anything that was