 your financial statements until you pull it in from that feeds transaction and so you probably want to double check it on a manual system and then pull it over. So this one says check each payout in for review then confirm and this will automatically confirm. Connect after so this would be the disconnect if you wanted to disconnect here. If we go into the items they have the sales items which is going to be pointing to the default in QuickBooks sales Shopify item shipping Shopify shipping item and then discount Shopify discount you can edit these items here and then change change them here and so I'll cancel that these are going to be the defaults and then you've got the customers and vendors. Now note we're not pulling in all the customers all the customer data is going to be over here in your Shopify store and that's probably where you want it because you're usually going to be a bulk seller you're trying to sell a bunch of stuff unlike a Shopify or an Amazon you don't really need to know all the information about the customers other than put their email on your email list most of the time right so they're not so they need to have a customer so they're just going to put it into a generic customer meaning this is going to be one customer for all transactions that are going through your Shopify store if you need to have more detail about a particular transaction then you're not going to go to it in QuickBooks because we didn't pull in all that data but rather you're going to go to the Shopify right and then on the advanced these are the mapping accounts so these are kind of like the defaults that it sets up basically automatically so you've got a clearing account this holds Shopify payouts before they're reconciled with your bank account so just like we did in the manual method we still have to deal with this clearing account which means when the money is coming in it's not going to deposit directly into the checking account it's going to put it into the clearing account and then we can match it to the deposit that's going to clear the checking account which will bring the clearing account back down same concept as we looked at with the manual method it's just trying to automate it now then you've got the sales Shopify item sales is QuickBooks categorization Shopify sales income account shipping income this are the charges that you're going to have for the shipping it's going to go to the to the Shopify shipping income account and then you have the discounts promotions applied to sale Shopify discounts it's going to break that one out and then selling fees commissions and fees related to sales it's going to go into the Shopify selling fees if you want to adjust these accounts then you can map it differently right I can go into here here's my list of accounts I can add new accounts if I so choose so I'm going to close that but but I'm going to keep the defaults here so if you if you've been doing your system prior to this and you already have mapped out accounts then you might want to use those accounts and you can change the mapping here to the accounts that you have set up and then you've got subscription fees what you pay for your Shopify subscription Shopify subscription fees is is dick is where it's going to go and then adjustments channel adjustments and miscellaneous Shopify other adjustments and then you've got the sales tax based on your region Shopify sales tax and then we've got the reserve balance payout balance reserved by channel Shopify reserve balance so that's the general mapping so if I close this back out and I open up my chart of accounts for example if I go down to my accounting down here and I look at my chart of accounts when I set up the Shopify it set up those accounts for me right so here's a clearing account here's the Shopify item here and it set up some of those those accounts Shopify sales tax could have set that up but it's good those those accounts that are mapped out are now over here in the the chart of accounts I've added a bunch of other accounts as well when we've been doing the practice problems so it's getting a little muddled at this point notice if I go in the sales tab and I look at the customers then we've got our customers here and it set up the Shopify customer so it's not going to add all the customers of course again it's just made one customer that's going to be our lump sum customer now also remember there's the same kind of issue with this system as we had with the manual system which is that Shopify is now kind of connecting to QuickBooks so that QuickBooks can pull in the detailed information breaking out the deposit but if you're dealing with other payment processors like a PayPal or a strike for example meaning customers are paying you through PayPal or strike something other than Shopify pay like not using just our credit card for example on Shopify pay or something then you might have other items that are going to be on the PayPal level that you're gonna have to deal with for fees on that level so so this is going to be a common problem with many different kinds of integrations that we that we saw so that's something that you've got to be mindful of as well so just you know so keep in do you have so the question would be do you have PayPal turned on can they pay you through PayPal or can they only pay you through the Shopify pay if you have the PayPal turned on you want to make sure that you have a system that's going to be dealing with the PayPal component of the payment similar process or problem that we talked about with the manual system all right so then if we were going to approve these let's go back on up top into the banking and say let's go ahead and add this one so this one came through we analyzed it and we didn't auto add it we said we want to add it manually so let's go ahead and add it boom the 715 is is in place now I should be able to map that in the future I'll be able I would be able to see in the checking account that 715 and I can map I can match it out but let's see what happens over here let's let's run this for for 010123 to 1231 23 23 this time on the balance sheet so note that it's got its clearing account here but it actually puts the transaction in and out of the clearing account and does put it into the checking account ultimately so if I go into the checking account there's our 7.15 note however if I go back on over here and exit out