 Hello everybody today. We are here again with near early from my profit about the full live Demonstration of how to calculate your profit on the right way in your ebay drop shipping business We will summarize here all of our previous videos together and we'll show you live How near we'll calculate all of his profits from his drop shipping business So enjoy the video under this video. You will have three links for our previous videos enjoy near and Hi guys, how are you? Great to be here again. Thank you Leo so before I will give the Full live demonstration. I would like to summarize the previous three videos So we talked about a Two major things the first one was a the green area I call it the positive flow of cash and we talked about the sources that money come from it was from PayPal The amounts from that we received from customers the second was from PayPal as well the return fees from PayPal and the third one was from credit card in cases of customer provide us When when the suppliers give us our money back in cases of refund after that we talk We talked about the red zone the red zone is the negative flow of cash negative flow of cash There were a five Major sources the first one was from credit card when we pay our Suppliers the second one was paper fees. The third one was eBay fees number four was a refund We saw it in PayPal and the five of the the five the last I called it The non-generic in ones the specific costs all the VA monitor software warehouse and things like that So now I will show you I created a very very Simple excel file. I will share it now and I will start the full demonstration So this is the excel files you can see The three green one is the positive flow of cash The the red one is the negative. So let's start with the first one. I will open my November 18 is the same example that we did in the previous videos and I will show you what data do We need to copy exactly from From the files to here. So I will share now and the PayPal Okay, this is the PayPal. I already marked the colors So I want to start with the first one the first one the first One is a column C the amount received a month received is the money that we got From our customers and the amount was I we can see it in green color in the green color 1560 euro. So we are going back Here and we will put one we write down one One hundred one thousand five hundred and sixty euro now we will go back to the excel file To the paper Okay, what do we see here? I want to continue with the green one in calling G It's the refounded fees from PayPal in case of refund from customer We see here five the number is 15 euro. We go back To the summary and we write down you see here PayPal return fees 15 euro Now let's go back to the PayPal Now let's go to the red ones. The first red one is fees. This is PayPal fees PayPal fees is 90 euro Let's write it down in the summary PayPal fees. Here it is PayPal fees 90 euro And the last data from the PayPal is Column F Column F is the amount refunded from customers. This is the total amount of 308 euro we go to the summary PayPal refund 308 euro Okay, now we have done. We have done working with the PayPal PayPal file now Let's go to the credit card file In the credit card file I will sort again the data as I explained in the previous videos and I will show you how to collect it right. So first let's Let's sort all the negative ones We will go to the filter in the amount and we will choose less than zero Less than zero if you remember the second step is to go to column C and A to Z it because we want to see if there's Nothing suspicious beside our suppliers. I will Try to find something that is not Aliexpress or Amazon Aliexpress or Amazon. I see that everything is okay Okay, so the sum of this amount of the refund is 594 euro. Let's go back to the summary to the green one 594 euro in this stage you can see we finished summarize all The positive one the positive one is the real The real a revenue of your month. It's 2169 euro now you can see we have three blanks missing after we will Finish adding them then we can get the total calculation So let's go back to the excel file of the credit card And now I want to see to sort all the positive one We will go to the amount and we will choose greater than zero and Again, we will A to Z column C. I See here again This one PayPal. This is the PayPal invoice. It's not one of my suppliers I delete it and then I see there's nothing else. It's suspicious. Okay, so after I Sum all the numbers together. I will write it down in the summary and the summary is Outcome cash. This is the net that I called it 950 euros This is a generic the in the generic. It's all the specific cost How much I pay my monitor VA and cetera if I have something like this I pay a sum of 95 euro and the last date Data that is missing is the eBay fees. I showed you in the previous one. I will show it again Just open. I will show one of my eBay Users we are going to account settings We just Choose the right invoice from the right side Let's see. Let's see where it is. Okay, November last November. It was 34 euro Let's write it down in the summary 34 you 34 so in this stage This step we can see we finish Marking and write down all the data in the red zone the negative one so the summary of the negative one is 1577 euro so all you have to do is take the green amount and To a minus the red one from it and the calculation is simple like that to 2169 euro less 1477 euro and the real total profit of this specific month eBay store is 692 euro, that's it You have to do it every first day of every month manually like this. There's no other way of doing it This is the only way that I know and Basically, that's it. Yo Well, I just want to let people know that we will add a link to this Excel file under this video So you will be able to download this Excel file to your computer and use it for the calculations Thank you very much for the explanations near. It was a great video. Thank you very much for being here with us every time and See on the next videos people don't forget to subscribe to our YouTube channel and leave a comment What do you think about this calculation method? If you want any other explanations or if you have any other questions Just lie down under this video and they promise that we will answer any of your questions See on the next videos. Bye. Bye. Thank you. Bye guys You