How to Keep Track of Your Dropshipping Profit and Expenses [Free Auto Calculating Spreadsheet]
Published on: December 1 2022 by Bryan Guerra
How to Keep Track of Your Dropshipping Profit and Expenses [Free Auto Calculating Spreadsheet]
Table of Contents
How to Keep Track of Your Dropshipping Profit and Expenses [Free Auto Calculating Spreadsheet]
| startTime | durationTime | text |
| 00:00:00 | 00:00:03 | all right so i've been getting a lot of |
| 00:00:01 | 00:00:05 | questions recently on like how i set up |
| 00:00:03 | 00:00:07 | the spreadsheet to auto calculate for my |
| 00:00:05 | 00:00:08 | drop shipping so i can keep track my |
| 00:00:07 | 00:00:10 | profits |
| 00:00:08 | 00:00:12 | like how much i'm spending you know the |
| 00:00:10 | 00:00:13 | tracking numbers what the items actually |
| 00:00:12 | 00:00:14 | are selling you know where they're |
| 00:00:13 | 00:00:15 | actually selling what marketplace |
| 00:00:14 | 00:00:17 | because i'm not just doing it on |
| 00:00:15 | 00:00:19 | facebook marketplace |
| 00:00:17 | 00:00:20 | i'm also doing it on other marketplaces |
| 00:00:19 | 00:00:22 | so i'm going to show you that here in a |
| 00:00:20 | 00:00:22 | second but if you want to download this |
| 00:00:22 | 00:00:25 | spreadsheet |
| 00:00:22 | 00:00:26 | for free it's 100 free the first link in |
| 00:00:25 | 00:00:27 | the description you should be able to |
| 00:00:26 | 00:00:29 | click that |
| 00:00:27 | 00:00:31 | download the spreadsheet for free or |
| 00:00:29 | 00:00:32 | i'll show you also if you don't want to |
| 00:00:31 | 00:00:33 | just download the auto calculating |
| 00:00:32 | 00:00:35 | spreadsheet and you want to set it up |
| 00:00:33 | 00:00:36 | yourself that way you kind of learn it |
| 00:00:35 | 00:00:38 | you can set it up in the future |
| 00:00:36 | 00:00:40 | as many times as you want or modify it |
| 00:00:38 | 00:00:42 | or whatever i'll also teach you that |
| 00:00:40 | 00:00:44 | okay so let's head over to excel |
| 00:00:42 | 00:00:46 | and i've kind of pulled up an example |
| 00:00:44 | 00:00:48 | one and filled in some example kind of |
| 00:00:46 | 00:00:50 | suppliers here some example marketplaces |
| 00:00:48 | 00:00:51 | some examples sh |
| 00:00:50 | 00:00:53 | you know tracking numbers and stuff like |
| 00:00:51 | 00:00:56 | that as well as like some example |
| 00:00:53 | 00:00:59 | suppliers okay and this is literally |
| 00:00:56 | 00:01:00 | the exact template that i use with the |
| 00:00:59 | 00:01:01 | exact |
| 00:01:00 | 00:01:03 | like columns and the exact rows and the |
| 00:01:01 | 00:01:05 | exact auto calculations that i use |
| 00:01:03 | 00:01:08 | the only difference is i took all the |
| 00:01:05 | 00:01:09 | the data that i have out for april |
| 00:01:08 | 00:01:11 | and i just put test data in there to |
| 00:01:09 | 00:01:13 | show you different examples right |
| 00:01:11 | 00:01:14 | so if you want this it's fully |
| 00:01:13 | 00:01:15 | downloadable like i said first link in |
| 00:01:14 | 00:01:17 | the description |
| 00:01:15 | 00:01:19 | uh but basically what i do is i keep |
| 00:01:17 | 00:01:19 | track of the date right when the order |
| 00:01:19 | 00:01:21 | is placed |
| 00:01:19 | 00:01:23 | or when i fulfill the order i keep track |
| 00:01:21 | 00:01:25 | of the item title for you know obviously |
| 00:01:23 | 00:01:27 | all this is good data just |
| 00:01:25 | 00:01:28 | to have in case something goes wrong |
| 00:01:27 | 00:01:30 | with your order |
| 00:01:28 | 00:01:32 | but it's also good just to kind of see |
| 00:01:30 | 00:01:33 | like overall like as you start filling |
| 00:01:32 | 00:01:35 | out |
| 00:01:33 | 00:01:36 | this type of stuff and i do it monthly |
| 00:01:35 | 00:01:37 | right so right now i'm doing one for |
| 00:01:36 | 00:01:40 | april i did one last |
| 00:01:37 | 00:01:41 | month for march it's i'm a little slow |
| 00:01:40 | 00:01:42 | this morning i can't remember what comes |
| 00:01:41 | 00:01:44 | before april |
| 00:01:42 | 00:01:46 | uh but it's also good to kind of see |
| 00:01:44 | 00:01:47 | like as you go through the month like |
| 00:01:46 | 00:01:49 | all right where are you getting the |
| 00:01:47 | 00:01:50 | majority of your orders from |
| 00:01:49 | 00:01:52 | what types of products are you getting |
| 00:01:50 | 00:01:53 | the majority of your orders from |
| 00:01:52 | 00:01:55 | that way you can obviously focus on |
| 00:01:53 | 00:01:57 | listing more on those marketplaces as |
| 00:01:55 | 00:01:58 | opposed to the other marketplaces |
| 00:01:57 | 00:02:01 | that aren't really giving you the good |
| 00:01:58 | 00:02:03 | time roi uh as opposed to the other ones |
| 00:02:01 | 00:02:05 | and also like listing more types of |
| 00:02:03 | 00:02:06 | products and other variations of |
| 00:02:05 | 00:02:08 | products that are selling well for you |
| 00:02:06 | 00:02:09 | right because the data's not going to |
| 00:02:08 | 00:02:10 | lie to you the numbers aren't going to |
| 00:02:09 | 00:02:11 | lie |
| 00:02:10 | 00:02:13 | so that's why it's good to keep track of |
| 00:02:11 | 00:02:15 | this stuff and also if you ever run into |
| 00:02:13 | 00:02:16 | an issue with a buyer you can come back |
| 00:02:15 | 00:02:18 | look up the tracking number for that |
| 00:02:16 | 00:02:19 | specific order find the date right where |
| 00:02:18 | 00:02:21 | it was done |
| 00:02:19 | 00:02:23 | the supplier order number where you |
| 00:02:21 | 00:02:24 | ordered it from what you paid etc etc |
| 00:02:23 | 00:02:26 | all of that |
| 00:02:24 | 00:02:27 | that information you might not think is |
| 00:02:26 | 00:02:29 | valuable |
| 00:02:27 | 00:02:31 | now because if everything goes right |
| 00:02:29 | 00:02:32 | with your orders |
| 00:02:31 | 00:02:34 | then it won't matter right although if |
| 00:02:32 | 00:02:35 | something does go wrong god forbid it |
| 00:02:34 | 00:02:36 | does |
| 00:02:35 | 00:02:38 | then obviously you're going to want to |
| 00:02:36 | 00:02:40 | come back and look at this stuff okay so |
| 00:02:38 | 00:02:41 | like i said the first thing i put in is |
| 00:02:40 | 00:02:43 | the date so hypothetikally if somebody |
| 00:02:41 | 00:02:45 | were to order one right now |
| 00:02:43 | 00:02:46 | i'm going to go 4-6 21 because that's |
| 00:02:45 | 00:02:47 | the date today |
| 00:02:46 | 00:02:49 | maybe they ordered i've been toking |
| 00:02:47 | 00:02:51 | about wallpaper that was an example that |
| 00:02:49 | 00:02:52 | i used in the video uh last time so |
| 00:02:51 | 00:02:53 | let's just say like they ordered like |
| 00:02:52 | 00:02:56 | the |
| 00:02:53 | 00:02:58 | i don't know the sun kissed uh sky |
| 00:02:56 | 00:02:59 | wallpaper |
| 00:02:58 | 00:03:01 | and if you're listing multiple |
| 00:02:59 | 00:03:02 | variations what i basically do is i |
| 00:03:01 | 00:03:05 | literally just copy the title that i |
| 00:03:02 | 00:03:07 | listed it as and i paste it in here okay |
| 00:03:05 | 00:03:08 | where did it sell what marketplace so |
| 00:03:07 | 00:03:09 | maybe it's sold on poshmark |
| 00:03:08 | 00:03:11 | depending on if you're doing the |
| 00:03:09 | 00:03:12 | dropship arbitrage on poshmark or if |
| 00:03:11 | 00:03:13 | you're drop shipping and sending the |
| 00:03:12 | 00:03:15 | label |
| 00:03:13 | 00:03:16 | i've toked about this in the last video |
| 00:03:15 | 00:03:17 | if you want to tok about or you want to |
| 00:03:16 | 00:03:19 | see like different examples of how you |
| 00:03:17 | 00:03:20 | can drop ship obviously |
| 00:03:19 | 00:03:23 | not just on poshmark but many different |
| 00:03:20 | 00:03:24 | marketplaces i tok about 13 of them |
| 00:03:23 | 00:03:26 | that you know i'm not currently |
| 00:03:24 | 00:03:27 | necessarily dropping drop shipping on |
| 00:03:26 | 00:03:29 | but a lot of them i |
| 00:03:27 | 00:03:30 | am and testing out and a lot of them i |
| 00:03:29 | 00:03:32 | know that you can obviously so it |
| 00:03:30 | 00:03:34 | doesn't just have to be a facebook |
| 00:03:32 | 00:03:35 | marketplace although that's primarily |
| 00:03:34 | 00:03:36 | what the majority of you are probably |
| 00:03:35 | 00:03:37 | using |
| 00:03:36 | 00:03:39 | so this could be like facebook |
| 00:03:37 | 00:03:41 | marketplace and i just abbreviate there |
| 00:03:39 | 00:03:42 | it could be etsy i put a couple other |
| 00:03:41 | 00:03:44 | other examples in here |
| 00:03:42 | 00:03:45 | depending on where you're actually drop |
| 00:03:44 | 00:03:46 | shipping it could be any number of those |
| 00:03:45 | 00:03:47 | things |
| 00:03:46 | 00:03:48 | and if you're just doing facebook |
| 00:03:47 | 00:03:50 | marketplace then obviously you don't |
| 00:03:48 | 00:03:51 | really need this column and you can just |
| 00:03:50 | 00:03:53 | right click and delete the column okay |
| 00:03:51 | 00:03:55 | but i just put this in there in case you |
| 00:03:53 | 00:03:56 | branch out um you know |
| 00:03:55 | 00:03:58 | but like even if you don't like you just |
| 00:03:56 | 00:04:00 | want to keep it it should just |
| 00:03:58 | 00:04:02 | like any excel spreadsheet obviously |
| 00:04:00 | 00:04:03 | once you start typing like the f in for |
| 00:04:02 | 00:04:04 | facebook marketplace it'll just auto |
| 00:04:03 | 00:04:07 | populate that cell |
| 00:04:04 | 00:04:09 | knowing what you're about to type okay |
| 00:04:07 | 00:04:10 | now generally speaking this is going to |
| 00:04:09 | 00:04:12 | be blank so like i like keeping these |
| 00:04:10 | 00:04:14 | blank so like for example |
| 00:04:12 | 00:04:15 | all these are going to be blank until |
| 00:04:14 | 00:04:17 | you input the tracking number right so |
| 00:04:15 | 00:04:18 | that helps you keep track |
| 00:04:17 | 00:04:20 | as you're going through your your orders |
| 00:04:18 | 00:04:22 | of which uh items you've obviously |
| 00:04:20 | 00:04:24 | marked the tracking for and given the |
| 00:04:22 | 00:04:25 | buyer you know the tracking information |
| 00:04:24 | 00:04:26 | you're also going to be able to see that |
| 00:04:25 | 00:04:28 | for example |
| 00:04:26 | 00:04:29 | if it's on like a different uh platform |
| 00:04:28 | 00:04:30 | you'll be able to see that in your |
| 00:04:29 | 00:04:31 | orders if it's on facebook you'll be |
| 00:04:30 | 00:04:33 | able to see like which ones |
| 00:04:31 | 00:04:34 | uh the shipping orders haven't been |
| 00:04:33 | 00:04:35 | marked as shipping it's very easy to see |
| 00:04:34 | 00:04:36 | that |
| 00:04:35 | 00:04:38 | but obviously it just helps you keep |
| 00:04:36 | 00:04:39 | track of it on your ship on your |
| 00:04:38 | 00:04:41 | spreadsheet as well |
| 00:04:39 | 00:04:43 | then your supplier order id so like this |
| 00:04:41 | 00:04:44 | is good for example i know perfect like |
| 00:04:43 | 00:04:48 | perfect example this is like |
| 00:04:44 | 00:04:50 | on amazon and any really any marketplace |
| 00:04:48 | 00:04:51 | it's important to have for for like the |
| 00:04:50 | 00:04:53 | future in case something goes wrong |
| 00:04:51 | 00:04:54 | but your order id on amazon so you can |
| 00:04:53 | 00:04:56 | always look it up in your orders |
| 00:04:54 | 00:04:58 | on walmart it's also good so if you're |
| 00:04:56 | 00:04:58 | not like signed in with an actual |
| 00:04:58 | 00:05:00 | account |
| 00:04:58 | 00:05:02 | you can just use the email that you |
| 00:05:00 | 00:05:04 | ordered from the order id number and |
| 00:05:02 | 00:05:06 | then look up the tracking that way so |
| 00:05:04 | 00:05:07 | that's also important to have |
| 00:05:06 | 00:05:09 | and then obviously the supplier where |
| 00:05:07 | 00:05:11 | you got it from right so like i put an |
| 00:05:09 | 00:05:13 | example wholesale supplier for |
| 00:05:11 | 00:05:15 | here you know because there's so many |
| 00:05:13 | 00:05:16 | different wholesale suppliers out there |
| 00:05:15 | 00:05:18 | so it could be like a random wholesale |
| 00:05:16 | 00:05:20 | supplier it could be a retail website |
| 00:05:18 | 00:05:22 | like amazon or home depot or ebay or |
| 00:05:20 | 00:05:24 | costco or walmart or whatever |
| 00:05:22 | 00:05:25 | then obviously the estimated payment |
| 00:05:24 | 00:05:28 | what you actually |
| 00:05:25 | 00:05:29 | spent on it on the marketplace the |
| 00:05:28 | 00:05:31 | profit margin here's where the auto |
| 00:05:29 | 00:05:32 | calculations start coming in the profit |
| 00:05:31 | 00:05:34 | margin |
| 00:05:32 | 00:05:36 | uh the the actual margin percentage so |
| 00:05:34 | 00:05:37 | excuse me the profit that you made |
| 00:05:36 | 00:05:39 | the profit margin and then whether or |
| 00:05:37 | 00:05:41 | not you shipped it out was it a drop |
| 00:05:39 | 00:05:42 | shipping listing you don't have to do |
| 00:05:41 | 00:05:44 | this if you're just doing drop shipping |
| 00:05:42 | 00:05:45 | like you can take this out |
| 00:05:44 | 00:05:46 | um but i keep track of this because |
| 00:05:45 | 00:05:47 | every once in a while i'll do like a |
| 00:05:46 | 00:05:49 | drop ship arbitrage order |
| 00:05:47 | 00:05:50 | so i want to make sure that i'm shipping |
| 00:05:49 | 00:05:52 | these out and keeping track of them if |
| 00:05:50 | 00:05:53 | you were doing drop ship arbitrage as |
| 00:05:52 | 00:05:54 | well |
| 00:05:53 | 00:05:56 | and combining drop shipping then this |
| 00:05:54 | 00:05:57 | makes sense if not then again just right |
| 00:05:56 | 00:05:58 | click |
| 00:05:57 | 00:06:00 | or not right click select the column |
| 00:05:58 | 00:06:01 | then right click and just delete the |
| 00:06:00 | 00:06:02 | column |
| 00:06:01 | 00:06:04 | that way okay and then obviously when i |
| 00:06:02 | 00:06:05 | ship the drop ship arbitrage one out if |
| 00:06:04 | 00:06:07 | you've seen any of my other spreadsheet |
| 00:06:05 | 00:06:08 | videos i'll just mark this green and |
| 00:06:07 | 00:06:10 | i'll know that okay the drop ship |
| 00:06:08 | 00:06:13 | arbitrage one has also |
| 00:06:10 | 00:06:15 | been shipped out okay so let's fulfill |
| 00:06:13 | 00:06:16 | a test order here and i'll show you how |
| 00:06:15 | 00:06:18 | this actually works |
| 00:06:16 | 00:06:21 | now if you download this spreadsheet |
| 00:06:18 | 00:06:21 | right you can obviously start replacing |
| 00:06:21 | 00:06:24 | these here |
| 00:06:21 | 00:06:25 | and then it will just auto calculate for |
| 00:06:24 | 00:06:26 | you and you never have to change |
| 00:06:25 | 00:06:28 | anything here okay |
| 00:06:26 | 00:06:29 | if for whatever reason you don't want to |
| 00:06:28 | 00:06:31 | do that and you want to set it up i'll |
| 00:06:29 | 00:06:32 | show you how you can set up the auto |
| 00:06:31 | 00:06:34 | calculations because if you come down to |
| 00:06:32 | 00:06:36 | the bottom here it's going to calculate |
| 00:06:34 | 00:06:37 | automatikally what you've spent over the |
| 00:06:36 | 00:06:38 | month right so |
| 00:06:37 | 00:06:40 | in this spreadsheet it looks like you've |
| 00:06:38 | 00:06:42 | spent 233.62 |
| 00:06:40 | 00:06:44 | the total payouts that you've received |
| 00:06:42 | 00:06:48 | so far |
| 00:06:44 | 00:06:50 | are 162.55 and your profit |
| 00:06:48 | 00:06:51 | margin is that doesn't make any sense |
| 00:06:50 | 00:06:55 | because |
| 00:06:51 | 00:06:56 | estimated payment total spent so these |
| 00:06:55 | 00:06:58 | two columns i just mixed them up right |
| 00:06:56 | 00:07:00 | here so they should say total spent |
| 00:06:58 | 00:07:02 | i did this fast when i was fixing it so |
| 00:07:00 | 00:07:04 | like total |
| 00:07:02 | 00:07:05 | uh profit or total payout or something |
| 00:07:04 | 00:07:06 | like that so |
| 00:07:05 | 00:07:08 | this is gonna be your total profit |
| 00:07:06 | 00:07:09 | that's gonna be your total spent |
| 00:07:08 | 00:07:11 | obviously and that's gonna be your |
| 00:07:09 | 00:07:12 | profit with your average margin also |
| 00:07:11 | 00:07:13 | calculated because one of the questions |
| 00:07:12 | 00:07:15 | i got frequently was like |
| 00:07:13 | 00:07:16 | okay like i keep track my margin but |
| 00:07:15 | 00:07:18 | like how do i know on average what my |
| 00:07:16 | 00:07:20 | margin percentages are right |
| 00:07:18 | 00:07:21 | so i keep track obviously it auto |
| 00:07:20 | 00:07:23 | calculates in every single thing ignore |
| 00:07:21 | 00:07:24 | the dollar sign there that's like |
| 00:07:23 | 00:07:27 | percentage right so |
| 00:07:24 | 00:07:30 | if it says 0.43 that means 43 if it says |
| 00:07:27 | 00:07:32 | 1.29 that obviously means 129 |
| 00:07:30 | 00:07:33 | you get the picture here and then |
| 00:07:32 | 00:07:36 | obviously it's going to auto calculate |
| 00:07:33 | 00:07:38 | so my average margin on this spreadsheet |
| 00:07:36 | 00:07:39 | specifically is 77 right these numbers |
| 00:07:38 | 00:07:41 | are all going to change |
| 00:07:39 | 00:07:42 | these are random numbers that i just |
| 00:07:41 | 00:07:43 | input in there to kind of show you the |
| 00:07:42 | 00:07:44 | example |
| 00:07:43 | 00:07:46 | but let me show you a fulfillment like |
| 00:07:44 | 00:07:48 | let's pretend like we're fulfilling an |
| 00:07:46 | 00:07:50 | order right so somebody makes an order |
| 00:07:48 | 00:07:51 | right today it's gonna be four six |
| 00:07:50 | 00:07:51 | twenty one that's when they place the |
| 00:07:51 | 00:07:53 | order |
| 00:07:51 | 00:07:55 | maybe again we'll use the sunkist sky |
| 00:07:53 | 00:07:56 | wallpaper as the example just because |
| 00:07:55 | 00:07:57 | it's like the first thing that comes my |
| 00:07:56 | 00:07:59 | mind |
| 00:07:57 | 00:08:00 | um and then we'll say that they did it |
| 00:07:59 | 00:08:02 | on facebook marketplace because a lot of |
| 00:08:00 | 00:08:02 | you guys are going to be using facebook |
| 00:08:02 | 00:08:04 | marketplace |
| 00:08:02 | 00:08:05 | you're not going to have the tracking |
| 00:08:04 | 00:08:07 | number for the shipment yet that's |
| 00:08:05 | 00:08:08 | something you're going to put in a day |
| 00:08:07 | 00:08:10 | or two later when you obviously get that |
| 00:08:08 | 00:08:12 | tracking number from your supplier okay |
| 00:08:10 | 00:08:13 | that's also something that you're going |
| 00:08:12 | 00:08:15 | to want to put in facebook marketplace |
| 00:08:13 | 00:08:16 | as you already know or |
| 00:08:15 | 00:08:18 | any of the other marketplaces that |
| 00:08:16 | 00:08:20 | you're using so that your buyer knows |
| 00:08:18 | 00:08:22 | and also the marketplace knows that it's |
| 00:08:20 | 00:08:23 | actually been shipped and then the you |
| 00:08:22 | 00:08:24 | know track it so that they can pay you |
| 00:08:23 | 00:08:25 | right |
| 00:08:24 | 00:08:27 | now the order id you're obviously going |
| 00:08:25 | 00:08:28 | to have that from your your supplier |
| 00:08:27 | 00:08:30 | right so |
| 00:08:28 | 00:08:31 | whoever your supplier is you're probably |
| 00:08:30 | 00:08:33 | going to use z drop to find them right |
| 00:08:31 | 00:08:35 | so if you come up to like |
| 00:08:33 | 00:08:37 | right up here and you go into z drop |
| 00:08:35 | 00:08:38 | you're going to search for that actual |
| 00:08:37 | 00:08:40 | product and then you're going to find |
| 00:08:38 | 00:08:42 | that product on the actual uh you know |
| 00:08:40 | 00:08:43 | whatever your supplier is you're going |
| 00:08:42 | 00:08:44 | to order it and that's where you're |
| 00:08:43 | 00:08:45 | going to get all that data to input the |
| 00:08:44 | 00:08:47 | spreadsheet right so |
| 00:08:45 | 00:08:48 | pretty self-explanatory so let's say |
| 00:08:47 | 00:08:51 | that you ordered this one from walmart |
| 00:08:48 | 00:08:53 | we'll put in a fake order id number here |
| 00:08:51 | 00:08:55 | what was your estimated payment right so |
| 00:08:53 | 00:08:57 | like what do the actual buyer if it's |
| 00:08:55 | 00:08:58 | confusing obviously you can change these |
| 00:08:57 | 00:09:00 | titles but that's just what i use but |
| 00:08:58 | 00:09:01 | you'll get the gist of it so like what |
| 00:09:00 | 00:09:03 | is the buyer |
| 00:09:01 | 00:09:04 | actually paying you after the the |
| 00:09:03 | 00:09:05 | facebook fees or whatever marketplace |
| 00:09:04 | 00:09:06 | fees it is |
| 00:09:05 | 00:09:09 | uh and a lot of marketplaces will |
| 00:09:06 | 00:09:11 | literally tell you that uh as well as |
| 00:09:09 | 00:09:12 | after like the marketplace fees and |
| 00:09:11 | 00:09:14 | like the shipping if you're paying for |
| 00:09:12 | 00:09:15 | the shipping or anything like that right |
| 00:09:14 | 00:09:17 | so what is the actual |
| 00:09:15 | 00:09:18 | take-home profit from that item that |
| 00:09:17 | 00:09:21 | you're getting right so let's say for |
| 00:09:18 | 00:09:22 | the sunkist wallpaper it'll be like 43 |
| 00:09:21 | 00:09:25 | 43-20 |
| 00:09:22 | 00:09:27 | 43-21 right random example okay |
| 00:09:25 | 00:09:28 | and then but it only costs you on |
| 00:09:27 | 00:09:32 | walmart to order it |
| 00:09:28 | 00:09:33 | it costs you 28.50 right so then it's |
| 00:09:32 | 00:09:35 | gonna auto-calculate once you put those |
| 00:09:33 | 00:09:36 | two numbers in it's gonna |
| 00:09:35 | 00:09:38 | calculate and tell your pr tell you your |
| 00:09:36 | 00:09:39 | profit is fourteen dollars and seventy |
| 00:09:38 | 00:09:41 | one cents |
| 00:09:39 | 00:09:44 | and it's a about a fifty one or fifty |
| 00:09:41 | 00:09:45 | two percent profit margin on that okay |
| 00:09:44 | 00:09:47 | and again if you're using the shift |
| 00:09:45 | 00:09:49 | category you can go you know just copy |
| 00:09:47 | 00:09:51 | the bs or make like a green ds so that |
| 00:09:49 | 00:09:52 | you know it's you know obviously the |
| 00:09:51 | 00:09:54 | order has been received |
| 00:09:52 | 00:09:55 | it's a drop shipped item if you're doing |
| 00:09:54 | 00:09:56 | drop ship arbitrage then just mark it |
| 00:09:55 | 00:09:58 | with a d a |
| 00:09:56 | 00:10:00 | and a red until you ship it out you know |
| 00:09:58 | 00:10:02 | via yourself uh and then mark it green |
| 00:10:00 | 00:10:04 | but most of you probably won't be doing |
| 00:10:02 | 00:10:05 | this so let's just delete it uh so it |
| 00:10:04 | 00:10:07 | doesn't confuse you okay |
| 00:10:05 | 00:10:09 | but the template that you can download |
| 00:10:07 | 00:10:10 | as the first link in the description for |
| 00:10:09 | 00:10:12 | free will have that so it'll have the |
| 00:10:10 | 00:10:13 | marketplace column |
| 00:10:12 | 00:10:14 | in case you're doing multiple |
| 00:10:13 | 00:10:15 | marketplaces but i'll delete this just |
| 00:10:14 | 00:10:16 | you know |
| 00:10:15 | 00:10:19 | just in case it doesn't confuse you guys |
| 00:10:16 | 00:10:21 | right now and it will also have the uh |
| 00:10:19 | 00:10:23 | the ds column or the da for so like if |
| 00:10:21 | 00:10:25 | you're doing drop ship arbitrage |
| 00:10:23 | 00:10:26 | and also doing drop shipping you can |
| 00:10:25 | 00:10:28 | also use that if you want but again if |
| 00:10:26 | 00:10:30 | you're not just delete those columns |
| 00:10:28 | 00:10:32 | it's totally fine right so this is all |
| 00:10:30 | 00:10:33 | the important data that i think that |
| 00:10:32 | 00:10:35 | you should have that i literally use |
| 00:10:33 | 00:10:36 | myself right and then in a day or two |
| 00:10:35 | 00:10:37 | i'll come back i'll input the tracking |
| 00:10:36 | 00:10:40 | information here |
| 00:10:37 | 00:10:42 | uh whether you're using like for example |
| 00:10:40 | 00:10:42 | if it's a drop ship arbitrage item then |
| 00:10:42 | 00:10:44 | you're gonna be like |
| 00:10:42 | 00:10:46 | shipping it out with the label for offer |
| 00:10:44 | 00:10:48 | up or poshmark |
| 00:10:46 | 00:10:49 | or any of those or even facebook |
| 00:10:48 | 00:10:50 | marketplace if you're doing dropship |
| 00:10:49 | 00:10:52 | arbitrage on facebook marketplace |
| 00:10:50 | 00:10:52 | although the majority of you probably |
| 00:10:52 | 00:10:54 | won't |
| 00:10:52 | 00:10:55 | you'll probably just be drop shipping |
| 00:10:54 | 00:10:57 | and facilitating the sale from the |
| 00:10:55 | 00:10:58 | actual supplier to your customer |
| 00:10:57 | 00:11:00 | so that's where you're gonna put in your |
| 00:10:58 | 00:11:01 | tracking number right so for example if |
| 00:11:00 | 00:11:03 | they give you a fedex tracking number |
| 00:11:01 | 00:11:05 | then i would be like fedex |
| 00:11:03 | 00:11:06 | and i would say like uh and then i'd |
| 00:11:05 | 00:11:08 | literally copy and paste the tracking |
| 00:11:06 | 00:11:10 | number in here just so i had it right so |
| 00:11:08 | 00:11:11 | who's actually shipping it |
| 00:11:10 | 00:11:13 | uh what the carrier is and what the |
| 00:11:11 | 00:11:14 | actual number is now if it's tba |
| 00:11:13 | 00:11:15 | tracking number |
| 00:11:14 | 00:11:17 | and you're using amazon then that's why |
| 00:11:15 | 00:11:18 | i put the example oh a genius one in |
| 00:11:17 | 00:11:20 | here |
| 00:11:18 | 00:11:22 | because oa genius for this example is a |
| 00:11:20 | 00:11:23 | website where you can actually go and |
| 00:11:22 | 00:11:25 | order tracking numbers for i think |
| 00:11:23 | 00:11:27 | they're 25 cents a piece or something |
| 00:11:25 | 00:11:28 | like that it's very very cheap it might |
| 00:11:27 | 00:11:30 | even be cheaper than that you can pay |
| 00:11:28 | 00:11:31 | like 25 bucks for 100 of them |
| 00:11:30 | 00:11:33 | and then you can order a tracking number |
| 00:11:31 | 00:11:35 | specifically they'll scan |
| 00:11:33 | 00:11:37 | fedex's entire like system and find a |
| 00:11:35 | 00:11:38 | tracking number that's live right now |
| 00:11:37 | 00:11:41 | and active |
| 00:11:38 | 00:11:42 | going to that actual um town or whatever |
| 00:11:41 | 00:11:43 | where it's going |
| 00:11:42 | 00:11:45 | right in that state right so that's very |
| 00:11:43 | 00:11:47 | very valuable for drop shipping uh in a |
| 00:11:45 | 00:11:48 | nutshell like we're doing right |
| 00:11:47 | 00:11:49 | and then it's just going to auto |
| 00:11:48 | 00:11:51 | calculate okay so if you want this like |
| 00:11:49 | 00:11:52 | i said it's free to download but if you |
| 00:11:51 | 00:11:54 | just want to set it up yourself all i'm |
| 00:11:52 | 00:11:55 | really doing here is i'm inputting these |
| 00:11:54 | 00:11:58 | right here |
| 00:11:55 | 00:11:59 | so let's say hypothetikally we delete |
| 00:11:58 | 00:12:01 | all this information so it doesn't |
| 00:11:59 | 00:12:03 | auto-calculate |
| 00:12:01 | 00:12:05 | and then all this should go away and let |
| 00:12:03 | 00:12:08 | me just see if i fill this in |
| 00:12:05 | 00:12:09 | if it does it really fast let's say 20 |
| 00:12:08 | 00:12:11 | and okay so it's not |
| 00:12:09 | 00:12:12 | calculating anymore so all i'm doing |
| 00:12:11 | 00:12:13 | right if you want to set this up |
| 00:12:12 | 00:12:15 | yourself |
| 00:12:13 | 00:12:17 | is i'm setting up just formulas in excel |
| 00:12:15 | 00:12:18 | it's very very simple stuff so first |
| 00:12:17 | 00:12:19 | thing i'm going to do is the profit |
| 00:12:18 | 00:12:21 | margin i'm going to go |
| 00:12:19 | 00:12:23 | this column right the total estimated |
| 00:12:21 | 00:12:27 | payment minus this column okay so |
| 00:12:23 | 00:12:30 | f what is that f9 minus g9 so equals |
| 00:12:27 | 00:12:32 | f9 minus g9 and then enter |
| 00:12:30 | 00:12:34 | and it will auto calculate for you okay |
| 00:12:32 | 00:12:35 | and then with the margin all i'm doing |
| 00:12:34 | 00:12:38 | is i'm dividing the profit |
| 00:12:35 | 00:12:39 | by what i'm spending right so your your |
| 00:12:38 | 00:12:41 | margin percentage what your actual |
| 00:12:39 | 00:12:43 | profit margin is |
| 00:12:41 | 00:12:45 | minus or divided by what you're spending |
| 00:12:43 | 00:12:46 | so again same formula is going to be |
| 00:12:45 | 00:12:47 | equals and it's going to be this time |
| 00:12:46 | 00:12:50 | it's going to be |
| 00:12:47 | 00:12:53 | h9 so h9 divided by |
| 00:12:50 | 00:12:54 | uh g9 and then we're going to hit enter |
| 00:12:53 | 00:12:57 | and it's going to tell you that that's |
| 00:12:54 | 00:12:59 | 116 profit margin and then again these |
| 00:12:57 | 00:13:01 | will auto calculate down here |
| 00:12:59 | 00:13:04 | but if these are not auto calculating |
| 00:13:01 | 00:13:07 | all i'm doing on this columns down here |
| 00:13:04 | 00:13:08 | uh is for the profit so i'm auto summing |
| 00:13:07 | 00:13:10 | the profit so i'm just dragging all |
| 00:13:08 | 00:13:12 | these columns down |
| 00:13:10 | 00:13:13 | to this this uh one right here that's |
| 00:13:12 | 00:13:15 | highlighted and i'm going |
| 00:13:13 | 00:13:16 | auto sum and then it's just gonna auto |
| 00:13:15 | 00:13:18 | sum all the profits so if you add |
| 00:13:16 | 00:13:21 | another profit in here |
| 00:13:18 | 00:13:23 | like of like 23 or whatever then it's |
| 00:13:21 | 00:13:23 | just going to auto-sum all the profits |
| 00:13:23 | 00:13:25 | very very easy |
| 00:13:23 | 00:13:28 | same thing with margin i'm going to do |
| 00:13:25 | 00:13:30 | i'm going to drag all these down |
| 00:13:28 | 00:13:32 | to here and instead of auto summing i'm |
| 00:13:30 | 00:13:33 | going to click the down arrow and i'm |
| 00:13:32 | 00:13:34 | going to go average and then it's just |
| 00:13:33 | 00:13:36 | gonna average all the |
| 00:13:34 | 00:13:38 | the data points in there so for example |
| 00:13:36 | 00:13:40 | maybe you have like a twenty percent |
| 00:13:38 | 00:13:40 | profit margin here or i guess thirty |
| 00:13:40 | 00:13:42 | percent |
| 00:13:40 | 00:13:44 | and then like a twenty five percent it's |
| 00:13:42 | 00:13:45 | just going to take the average of all |
| 00:13:44 | 00:13:47 | those and then tell you what your |
| 00:13:45 | 00:13:48 | average profit margin is okay |
| 00:13:47 | 00:13:50 | and again with the total profit and |
| 00:13:48 | 00:13:52 | total spent that's just auto sum so all |
| 00:13:50 | 00:13:55 | i'm literally doing is i'm taking this |
| 00:13:52 | 00:13:56 | dragging it down and again auto summing |
| 00:13:55 | 00:13:57 | it |
| 00:13:56 | 00:13:58 | and it's just going to add up all those |
| 00:13:57 | 00:14:00 | totals in those columns so you're |
| 00:13:58 | 00:14:01 | getting all the data you know what |
| 00:14:00 | 00:14:02 | you're spending every single month so |
| 00:14:01 | 00:14:03 | you know how much |
| 00:14:02 | 00:14:05 | you know what your cash flow situation |
| 00:14:03 | 00:14:07 | is like because you're also going to see |
| 00:14:05 | 00:14:08 | what your total profit is as well as you |
| 00:14:07 | 00:14:11 | know how much you actually need |
| 00:14:08 | 00:14:14 | to have via credit or cash |
| 00:14:11 | 00:14:15 | in the bank to actually spend to make |
| 00:14:14 | 00:14:17 | those profits okay |
| 00:14:15 | 00:14:18 | so it's very very easy nothing |
| 00:14:17 | 00:14:20 | complicated here i think all this data |
| 00:14:18 | 00:14:21 | is important i really hope it helps if |
| 00:14:20 | 00:14:23 | you have any questions drop them in the |
| 00:14:21 | 00:14:25 | comments i'd love to answer them for you |
| 00:14:23 | 00:14:26 | remember you can get the spreadsheet 100 |
| 00:14:25 | 00:14:28 | free in the description |
| 00:14:26 | 00:14:30 | first link in the description hope it |
| 00:14:28 | 00:14:32 | helps and i'll see in the next |
| 00:14:30 | 00:14:32 | one |
