#1 TikTok Ads Spy Tool

A Better Way to Make TikTok Ads Dropshipping & TikTok For Business

  • Find TikTok winning products & TikTok dropshipping ads.
  • Analyze TikTok advertisers
  • Get the Latest TikTok Shop Data.
Try It Free

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]

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