Inventory & Sales Management For FBA eBay Etsy in MS Excel | Chris B. | Skillshare

Inventory & Sales Management For FBA eBay Etsy in MS Excel

Chris B., Instructor, MBA and CFO

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
17 Lessons (1h 50m) View My Notes
    • 1. 038ITIE Section 01a Course Introduction

      1:42
    • 2. 038ITIE Section 01b Instructor Introduction

      1:55
    • 3. 038ITIE Section 01c Introduction To Excel

      16:06
    • 4. 038ITIE Section 02a Introduction To Layout

      5:08
    • 5. 038ITIE Section 02b Labels Part 1

      7:33
    • 6. 038ITIE Section 02c Labels Part 2

      5:00
    • 7. 038ITIE Section 02d Labels Part 3

      5:28
    • 8. 038ITIE Section 02e Labels Part 4

      7:19
    • 9. 038ITIE Section 03a Data Entry Part 1

      6:38
    • 10. 038ITIE Section 03b Data Entry Part 2

      7:14
    • 11. 038ITIE Section 03c Data Review Part 1

      5:50
    • 12. 038ITIE Section 03c Data Review Part 2

      8:24
    • 13. 038ITIE Section 03d Data Review Part 3

      8:12
    • 14. 038ITIE Section 04a Summary Tab P&L

      7:46
    • 15. 038ITIE Section 04b Summary Tab Profit by Website

      9:40
    • 16. 038ITIE Section 04c Review of Summary Tab and Addl Ideas

      3:45
    • 17. 038ITIE Section 05a Course Conclusion

      2:48
18 students are watching this class

About This Class

Are You An Etsy, eBay or Fulfilled By Amazon FBA seller?

Do You Want One Central Way To Track Your Sales, Profitability, Inventory and More?

Do You Want To Take Your Reselling Business To The Next Level?

Do You Know There Is More You Could Be Doing?

Do You Want To Have an Eagle Eye View Of Your Results?

If You Answered "Yes" To Any Of The Above, Look No Further.  This Is The Course For You!

Start today and join the 100,000+ successful students I have taught as a Top Rated instructor!

Three reasons to TAKE THIS COURSE right now:

  1. You get lifetime access to lectures, including all new lectures, assignments, quizzes and downloads

  2. You can ask me questions and see me respond to every single one of them thoroughly! 

  3. You will are being taught by a professional with a proven track record of success!

  4. Bonus reason: Udemy has a 30 day 100% money back guarantee if for some reason you don't enjoy the course!

As a seller on Amazon, Etsy, Ebay or any other platform, you can certainly appreciate the difficulty in keeping track of everything.  What inventory do you have on hand, what is listed online for sale, what has sold and needs to ship, what is shipped, what are you waiting payment for, and much more.  Having run my own online business before, i can appreciate how complex it can be the busier you are.  

Take control of your online Amazon, Etsy, eBay or other business! Track your inventory, sales, costs and more!

At the end of the course, you will have an powerful tool and the knowledge to really take control of your business.  If you decide to not build your own, I provide the template we build in the course as well for you to download!

In this course you will learn how to take control of your inventory tracking issues and also knowing how much you are truly making.  We will build an entire inventory, cost and sales tracking spreadsheet from scratch.  Starting with a blank workbook, by the end of the course you will have a fully functioning inventory tracking spreadsheet and much more:

What We Do In The Course:  

  • Learn best practices for tracking your Amazon, Ebay, Etsy or other store results

  • Learn basic Microsoft Excel functions and formatting that we will then use in the course

  • Start with a blank workbook and structure a framework for our tracking spreadsheet

  • Determine what fields we need to include to successfully track our inventory, sales and costs

  • Create methods and tools to quickly sort and organize data for quick results and answers to questions such as

    • What items do we have listed currently

    • What do we need to ship

    • What has sold but hasn't been paid

    • How much did we spend this month/quarter/year on inventory

    • How much in sales did we do this month/quarter/year

  • And Much More!

After taking this course, you will feel empowered to successfully run your Ebay, Amazon, Etsy or other business much more successfully!

At any point if you have a question, please feel free to ask through the course forum, I'd be happy to answer any and all questions.  

***JOIN NOW AND LEARN HOW TO EFFECTIVELY TRACK YOUR SALES AND INVENTORY! ***

About The Instructor

Chris Benjamin, MBA & CFO is a seasoned professional with over 20 years experience in accounting, finance, and online sales on platforms such as Amazon, Etsy, Ebay and others  Having spent the first 10 years of my career in corporate settings with both large and small companies, I learned a lot about the accounting process, managing accounting departments, financial reporting, external reporting to board of directors and the Securities and Exchange Commission, and working with external auditors.  

The following 10+ years I decided to go into CFO Consulting, working with growing companies and bringing CFO level experience to companies.  I help implement proper best business practices in accounting and finance, consult on implementation of accounting systems, implementing accounting procedures, while also still fulfilling the CFO roll for many of my clients which includes financial reporting, auditing, working with investors, financial analysis and much more.  

Thank you for signing up for this course. I look forward to being your instructor for this course and many more!

Chris Benjamin, Instructor, CFO & MBA

Transcripts

1. 038ITIE Section 01a Course Introduction: Hello, everyone. Thank you so much for signing up for the course inventory and sales tracking in Excel for Amazon, eBay and Etsy Sellers. My name is Chris Benjamin. Um, n b a CFO. And most important, I'll be your instructor for this course. Now, in the next video, do a bit more of an introduction to myself in my background, but for this video wanted to make sleep, give you a road map of what we're gonna be doing in this course. We're actually doing quite a bit. So what we're going to start off doing is some basic excel. I'm just gonna teach you sort of the formatting, um, and sort of just addition, subtraction. Some of the very basic Excel functions you need to know in order properly build a spreadsheet that we're gonna build us. We'll go through that first. Then after that, we'll start with completely blank workbook. And by the end, we're gonna have a fully functioning inventory and sales tracking spreadsheet. And I'm talking everything you'll be able to do quick reports on what you have in inventory . What it sold, how much you paid for items, how much profit you've made You can pick different date ranges will be fully functional. Really, really dynamic. That's gonna take a bit of work. But once it's done, you're really gonna have a powerful tool to run your Amazon, eBay, etc. Or whatever another online or offline story you have. Once we're done as well, I'm gonna provide a download of the spreadsheet. So if you're not inclined to build your own and follow along, you're certainly welcome to just download the one at the end of the course. It'll be the exact same one that we build and use it to your own for your own purposes, and you'll probably to modify a few things to sort, customize it to fit your business. But aside from that, it will be fully functioning and ready to go. So I'm really excited about this course, and it's a really powerful tool that I think a lot of online sellers can use. So that said, let's go ahead and get started on this course 2. 038ITIE Section 01b Instructor Introduction: So before we dive in just a little bit more about my background, Um, again, my name is Chris Benjamin CFOs. I work as a chief financial officer. I spend a lot of time in excel. I'd consider myself an expert level Excel user. And that's why I love building really cool and dynamic spreadsheets like the one we're gonna build in this course. Um, I have an undergraduate degree in accounting and finance, and I have a master's degree in business from the University of Washington, where I really focused on entrepreneurship. So my skill set is really helping entrepreneurs from an accounting finance perspective. Another reason why, um, I really love building things like the spreadsheet cause it's giving you powerful tool to really run your business. Um, have over 20 years experience in large, publicly traded companies all the way down to small early stage companies as well. All the CF overrule the most recent 10 years. I've focused on working mainly on a part time interim basis. So I left the corporate world, went into consulting as a CFL work with basically entrepreneurs and early stage companies, and I help them grow. I joined the board I come aboard a CFO, etcetera. And a big part of that is implementing reporting tools as well. So again, you get the message on why You know, I really love building these cool spreadsheets like we're gonna build in this course. At this point, I've worked with over 100 companies in different capacities. Sometimes it's ongoing CFL. Sometimes it's one time projects like creating financial forecast valuations, etcetera. And then, lastly, I've worked with companies all the way from early stage toe AIPO and have been with them through that entire process. So is very cool to work with a an entrepreneur and then, four years later, take the company public. So I definitely have an extensive background in excel and financial modelling and just building different things in Excel for reporting tools. So, uh, definitely have a terrific plan ahead for you guys in terms of this inventory tracking spreadsheets. If it a point during the course you have any questions? Send me a message. The course website, happy to answer them for you. And that said, Let's go ahead and get started on. We'll start with some Excel basics 3. 038ITIE Section 01c Introduction To Excel: All right, everyone. Before we get started on actually building our inventory tracking worksheets, I want to give you a little introduction to excel. So if you're already familiar with excel, you know, basically everything on this home tab. If you're kind of feeling or copy pasting the formatting now centering that it for formats and numbers inserting the leading you pretty much know everything you need to know. So you can You can skip this video on. Certainly if there's anything that you come across later in the course I tried at least explain a little bit what I'm doing if we didn't cover it in this video, so But if you're not familiar with Excel, whether you're a beginner, just, you know, not completely familiar. Want refresher? Let's do a few things here. So, basically, I'm just gonna teach you, um, some skills that directly apply to what we're gonna be doing in the course, and almost all of it will be just on this home tab. We're not gonna go one by one. We're just going to kind of do sort of a mock, you know, start building something, and I'll talk about the different formats. Uh, and sort of formulas that we're going to use. And luckily, nothing's too to advanced or too crazy. First of all, if you're completely unfamiliar with Excel, it's basically a spreadsheet program. So it's made up of columns and rows, and then each of these is a cell. So we can, you know, enter data and formulas and numbers and you'll see it all come together. Eso Each of these is a column, and all the columns are lettered. Each of these is Roe, and they're numbered. So any given cell has a cross reference. This is C six, you know F nine. So as we write our formulas, we might say something like Take what? The number that's and see for and added to the number that's in C five. And that's how Excel is ableto to know what you're referencing. Um, let's go ahead and put in some random data just to start us off. It's it's we're gonna be making inventory spreadsheet. You know, we're probably gonna have labels across the top on. Maybe some numbers air data down the side. So and then they'll be different. You know, things across up. So maybe we'll have and again. This isn't the start of the course. We're just kind of doing a quick little intro to excel, so we might have ah, you know, item number. And then we might have an idol name and explain this. Vendors. This is where you bought it from, uh, maybe description description, you know, cost. Uh, you know, maybe over here, we also have, you know, date purchased over here. I have date sold and no sold amount. Now, certainly, we're gonna actually do a lot more with in our spread sheet. But again, we're just trying to put together a little little introduction. Don't. So as he saw it, we could go to any salad to start typing, and you can type directly here and it also up here so you can click up here and type, or here either one doesn't matter. Um, their several ways to do things in excel. So always try to tell you what I'm doing. A lot of times I use this keyboard shortcuts so you won't see it on the screen. But I'll try to tell you what impressing if I'm not actually appear clicking buttons. So when across the inter things that you see, this is kind of a bit of a mess. I mean, like, this cell is partially hidden by this one now, etcetera. So let's do a little bit of formatting first bomb. So to make a column wider, let's just start with that. You have a couple choices. If you put your mouths between the column letters, you see the cursor changes to that sort of vertical line. If you left, click and hold and now move your mouse, you'll see that you can drag it and resize it so we could just drag it over here. And then when we let go of the click, there we go, Um, so perfect. We actually did a pretty good job there. Here's another one, though, So another way to do that automatically is if you go between and you just double click, it resize itself automatically, and it goes to the largest. If we do it here. Ah, the largest text across off the next line was way across. That would re size to the largest cell. So we also like the center things a little bit. So you know, when we do things, I don't get to look nice. So, um, if you want to highlight a range of cells to say, we want to center all of these no. Within each column, we want things to be centered. If you left, click on the cell and hold your click down and then drag your mouse. You'll highlight cells, and I'm just scrolling around. I'm still holding down that left click button. Anything I cover gets highlighted some good cover to here. I'm gonna let go Now, up here, you'll see in this little box here, there's a different sort of alignments. If you hover over any box, it'll bring up a text of what it does. So line left a line center in line, right. And we want a line centers. Let's just click that and it will apply to everything that is highlighted. Okay, so I often like to save to I I don't personally have the auto save on its because I saved to an online drive. It won't let me. Um, so you should auto save if you don't just make sure you save Often I've read I've named this inventory tracking workbook, and this is the actual workbook Will use all this clear it out when we actually start the course. Okay, so let's just put in a, like a line or two. Just again. This is more so I can show you formatting than anything. Um so date purchase. Let's just put a one a 1 2018 and then maybe, Ah, two of 1 2018 And then 03 of 1 2018 will put in three items. We'll give her items. You know, like in this. I mean, you might not use all these things, but I don't number 645 And I'm just typing random numbers. Honestly, let's assume that I'll be four digit codes. Item name. Um, so this is just gonna be widget a Would you be? Would you see? And if you don't, enough Unless the term widget widgets a generic term used for whatever it is that you sell . So widgets represents whatever it is you sell, whether these air books or, you know, pillows, it doesn't matter. Vendors. This would be where you purchased it from. So say you bought these, um, at ah, flea market. You about this one at Let's see on Amazon, I'm not totally sure you'd be buying on Amazon, then reselling online, but nonetheless. And you bought this one at a garage sale. Okay, so let's use our trick again to resize this column. So I'm gonna double click here loops, double click, and you'll see it resized description. I already know the descriptions gonna be long, so I'm just gonna, like, resize this one bigger already. And we'll just put, you know, widget A is a, uh whatever. Pillow below. This is a shirt. This is a Beanie Baby for lack of a better idea. Ah, this cost of $10.5 dollars, $2. Okay, um, date. So let's say this sold on 105 18. It sold quick and sold first there. Or, let's say, $15. This and these two items haven't sold yet, so we're just gonna leave it like this. Okay, let's do a bit more form. A So So far, we have resize somewhere columns, and we kind of sort of things out. So I have a few things to do here. One. I really like the headers to kind of stand out. I want them to be to be bold it, so I'm gonna do my trick again. where I left. Click and hold cover everything. And then up here in this box, this is bold. That's a tallix. This is underlined. So we want a bold them. So you hit bold. And there we go a little bit nicer, you know, a little easier to see that. Is that a hetero? Okay, what else? Well, let's see these air dates and this will be dates. That's fine. If you're OK with this sort of date format, that works perfectly fine. If you want to change the format, though, you know, say the date and we are going to change the format of our dollars, you'll notice here it has sort of number like letter number formatting. So it's already recognized them as a date. Uh, certainly. If you want to change that, adults say these were dollar signs. It would click here. Or you can just drop this box down, say where you see a little arrow. Just drop it down. Uh, this is a date, and we're just getting a short date, and that's the date that it's already sort of in. You could choose a long date. You could also go to more number formats So, for example, you could choose date and will give you all kinds of options. So, you know, maybe you like 14 in March or whatever. Ah, probable block. I personally like the date format that's kind of defaulted to, So I'm gonna leave it. This is a number, and it perfect. It's just showing up was a number one I'm worried about. You're not worried about but the cost here. I really want to be that have dollar science, a few highlights cells. You can come up here. It could certainly drop this down and go to currency or accounting. Or it kind of has a shortcut for dollars because it's a popular one. You drop it down. There's two different types of dollars, but where it's going with English and perfect, this is what I like. I'm going to do it the same here, and you'll notice that kind of go down further than there is data. Just because if I enter the next few items, then they're already format it. School hit, Save again. All right, so let's see, let me think what else I'm if we want to color the cell so say we just want to really sort of make this stand out. You can fill. So right here you can change the font color, which I don't tend to do pretty much at all. But what I will do is I'll do fill so you'll fill the cells and maybe we fill them with, like, a color, and you'll see what happens. There we go. So now we have a nice color to kinda header on here. Perfect. And hit Save again. What else? So we're also gonna be, um, looking. We're gonna use some sort filters on this, if you will. So what we want to be able to do? Imagine, Now, this is super long. It's just, you know, months and months of data, and we want to pick out everything that was in March 2018. And there's just so much data. You know how we're gonna work on that? Well, if you click on any row and then go to so we're gonna venture off the home tab data and then you go to filter, you'll see it put in these little drop down boxes so much how we have our own drop down boxes appear. Remember, on the home tab and whatnot. Now we have drop down boxes on what those do is Now you can click on any of these columns and let you pick. So it'll basically list out the options That saying, Hey, you are so right now the default is saying, Hey, show me 2018 everything. I mean, if there was more dates, they would be here. But this is where you could clear everything. You could uncheck 2018 and say, Just show me January it. Okay, and then today it disappears. You'll see it row for then roast seven because the other ones air hidden. And so you can imagine for this purpose it wasn't that exciting. But when we have hundreds of lines, it's really gonna be important. Um, it even shows you with a little filter here. So you know which sort of column is being filtered If we go and click back on it, Um, and we go what? We can just use it a lot to select off and everything is back, and we could do that for anything. So this that will be really important when it comes to reporting on different things, and I will say We just want to see everything we bought at garage sales. Boom. We can do that. And then we can see, you know, our costs and whatnot. I'm trying to think if there's much else, let's just quickly look up here, so copy and paste are important. Um, you know, we might say copy of this description and say we bought 10 items that we're gonna enter him in our spreadsheet, and they're all from a garage sale. Well, it's and say they were all Beanie babies. We could click and hold these two cells. If you go up here, this is the copy cell, and then pay still light up once we copies. If we hit copy, you see the dotted green line, then we just go down there. We high as we say. I remember. We think we said Tad, but doesn't matter. Whatever. I'm so get clicking, holding, dragging. And now we can paste. Um, the keyboard shortcut for that. I'm just going to show you if you hold down, shift on your keyboard and use the arrow keys. You can highlight cells as well. If you hold down the control button and hit, see that copies And now if you hit control V So hold on control Presby. It pays. So say exact same things we did just we did with the mouse and the buttons before. Um, let's see, What else can we do? We can wrap tax weaken, merge Texas Say, one of these was really long. Um, you know, we might say this one we wanted toe keep this sort of rather than be one long description, I'll say item, name and sort of on top of each other if we come up here and save wrap text and then we make this just small enough. No, I didn't. Let's see, You know why we need to. There we go. So that resized trick works there as well. So yes, now it's like on top of each other, cause I'd wrapped rather than doing one big line. So we showed you fill. Sometimes I like a nice underlines to say, house, I want to underline all this. If you hit this underline, it just underlines the actual words or data on the cells. Let's just see what it looks like. I'm not a fan of that. I preferred the entire cell to be underlying, So we're gonna undo that. This is border, so this will actually do your entire cell, and there's all kinds of different borders. But for now, we just want the bottom border. And there we go. Now we have a nice, just nice bottom where we looked at the field. We can certainly change the font. We don't. We probably won't do too much of that. We talked about the alignment Textract Emergence center we probably most likely won't use. We have our formatting. If, for any reason you want to make a less decimal points, you can use these to expand. As you click it. You see the number groomed small. We won't lose conditional formatting inserting rose and deleting rows and columns. We might at some point, if you highlight several rows or one row, same thing with columns you can hit, insert and automatically insert some more rose. Another way of doing that is if you highlight any right click, so I press my right click on my mouth. One of the options it's insert another one is delete, so you could insert Rose Delete Rose. Let's just delete one and let's say we want to delete these two. We're gonna right click delete. And there we go. We're back to where we were. Okay. What's it? Save again? Um, filled. We probably won't use. Okay. One thing. We didn't use this formula, So we probably use that more on the reporting side. So, you know, say we wanted to total get rid of these, uh, being the baby. So we have a couple options here. We can right click and hit. Delete. Um, that will actually physically delete the rose and also just hit clear content. So that doesn't delete the rose. It just clears the contents. Let's do that. Okay. So say we want a total of this. Show you some of the formulas that will probably wrap this video up. It's getting a little bit long, but I think you pretty much at this point No, that know the basics. So, um, published, adding and subtracting are pretty much going to be the only sort of formulas that we use, Maybe averages. But if we get to that, we do some sort of analysis. We can just learn those at the time, um, adding and subtracting. So we have a couple options. There's this button cult auto? Some, um, it kind of guesses what you want to add. And so it'll look around. They'll say, Well, there's three numbers above here. You probably want to add those. Let's just see if that's what happens. Yep, that's exactly what happened to guest write. If we hit, enter and there's our total. Now take a look at this form that says equals So all for me. I'll start with the equal sign, equal some. So think some add these together brackets. So then within the bragger telling what to some some cells. H four. So we talked about references. H four is the sell through. Let's go back here through age seven. So saying just at everything in this range, um, you could add a block of sales to say, here your formula be equal Some J four through L, uh, eight. And it would take basically, it would just go across and at everything in those box will probably just be doing signal columns. There's no reason we would have multiple columns that would be adding together. We could do the same thing here, or if we need to write this formula. Certainly that This is exactly how we would write it. Say you wanted to calculate your profitability. Just put in a quick header profit. So it's gonna be and notice that automatically copied the format over. Didn't put on the filter, though, so it's gonna be sold him out less. Your cost amount is your profit, right? So we're going to write that there's no quick button for that service equals. And then I'm gonna click on this cell so that sell, subtract, just hit the subtract button. This so hit enter And there you go. There's your profit. Simple. Is that very simple formula? That's it, guys, I think we we've covered the main formulas that we can use in the course. So let's go ahead and actually get started on building our own inventory tracking, you know, profit loss calculator. Gonna do lots of cool things. Let's get started on it 4. 038ITIE Section 02a Introduction To Layout: All right, So now that you're up to speed on Excel, let's let's get started. And if, as we go through all point out, I'll say what I'm doing, especially from doing things on the keyboard, Um And then if there's something I didn't cover in the introductory video that we need to do I'll certainly explain You know how to go about doing it in in the chorus. So, um, the way typically like to go about this is I'm gonna give you just sort of a general idea of what I'm thinking. And then as we go, we're just gonna build it, and then we'll kind of be a bit of a free flow. I mean, we have a good idea of what we're gonna be building, but we might, you know, decide halfway through. We also want to add in an extra, you know, sort of reporting item that we want to track, and that won't be a problem. Um, the main thing is just getting started and start building. So essentially, what I'm picturing is across the top. Kind of like we didn't excel video. We have lots of different header. So we're gonna look at things like. Okay, what's the item we bought? What's the item number? What date did we purchase it On? What date did it sell or might have the sell date over here? I mean that those are things we can decide as we're going. How much do we pay? Ah, what did it sell for? Um, was there any, you know, shipping fees that we needed to cover? Um, others, I think camera. If I said I know ah, number and name where we got it, you know, and we kind of have to determine one of the categories we want to track. I mean, what do we want to be a very sort of broad list of just things. Like we bought it online or we bought it at a garage. So you want to be very specific, you know? Where do we buy it online? Such a, um, if it's something that we buy a lot off, So I'm kind of picturing, you know, business where you you buy unique individual items and maybe you do by, like, say, three or four of a specific item. But, you know, maybe you sell. I mean, I used example Beanie babies, which is very dated. Um, but say, you know, I've been watching some of the Amazon FDA videos. Nothing. I'm our Sorry. Yeah, FDA fulfilled by Amazon videos on YouTube and see people going out and buying all kinds of stuff. You know, sometimes they buy pallets of stuff where they're going, just a mixed bag of all kinds of different things. And I've seen people who I'm just go to discount stores. One person was going to sort of Ross and Marshall's and T. J. Maxx. If you're not familiar with those, they sell sort of clothing items that are sort of last season and beyond. So they're out of date. But they're finding items, looking them up, seeing what they sell for online and then buying them and then selling them. But so they might by four of the same type of shoe. I personally, I will attract those sort of individuals. I'm gonna kind of do this thing I would do if I was running a business. And certainly I've sold stuff on eBay before. Um, no, not to the level that probably you wear, but I love doing this stuff tracking, so we're gonna label each one and, um, given a number, some type of label. Ah, what else can we, uh, can we can we do three other? So we aside from that, would be put in a quantity. So say you do have one type of shoe at Nike air, whatever. Size nine, certain style. You couldn't include a quantity column. I'm not gonna do that for the reasons we just talked about, um and then that's about it. And then we might also I'm gonna clue, like a status column. So, you know, like in inventory, like, we'll come up with some some labels that we that we use. I'm kind of standardized label system like that. Inventory its list on Amazon flys on eBay. We will put the left state as well. See, you see, you get a sense that as we start to build this work and come up with more ideas, So that said, we've talked enough about it. So we have all these different labels across stopping. There was kind of a list of stuff. Basically, um, you saw in Excel video the basics of Excel, where we did filter so that we could run the little reports like we could run a filter on everything that has sold in the last month, and then we can check. And if it doesn't have a ship date than we owe, you know, we need to ship that, or it may be we did shipping. We forgot to ensure the data. So things like that, just another thing came to mind. You know, when we do ship it, we probably tracking them or like, how did we ship it? And what's the tracking? So lots of cool stuff. We contract here. All right, let's just get started on that. And then once we build it out, and maybe what we'll do is we'll fill it with SE 20 items, Um, and we'll have sort of different things. And then I'll show you how you can do some reporting on that, and that'll be later in the course. So first of all, let's just get started putting some stuff down a side note and actually will probably have ending this video that will actually start in the next video. I try to keep the videos to about five minutes or so, maybe four minutes, maybe six minutes, just so you can consume them and, you know, pause and take a break in between. So this video is almost a 4.5 minutes already. So before we get started, Um, let's just cut this video off that I have an idea of where we're going with this, and, uh, I'll use my last few seconds here just encourage you. If you have any questions during the course, send me a message sent me through the through the course website. Happy to answer any of your questions? Um, yeah, and that's it. And also keep in mind at the end. Of course, what we build, what you see on the screen you'll be able to download. So if you just want to follow along and kind of learn kind of the ins and outs of it but ultimately just want to use the spreadsheet that we build, that's totally fine. And you could go in and edit it and sort of change it to meet your needs or the other flip side. I encourage you to fall along and build your own as you're going. Just positive videos catch up. Do you know, do what it is we're doing in the lesson, and then we'll continue on that said, Let's end this video and we'll start actually putting labels in the next video. 5. 038ITIE Section 02b Labels Part 1: All right, everybody, slits. Let's get started. Now, As promised, let's actually do something. So I'm gonna start putting an information than what we might do is sort of reorganize it later on, Um, or even as we're going. But let's just get started. So first off, you know, we didn't item name. Um I also want an item number, which I probably want before the item Name, Item number. Now, just ah, kind of Cavite about that. And if you remember, I'm gonna just going point out something. If you double click between any two columns or it, Rose will resize. I'm seeing double click here, and you saw it expanded. Um, just another side note, and then I'll actually say what was going to We'll format this a little bit. Let's just get some header tonight. Names down. Then we'll worry about formatting everything and making it look pretty. One thing I do encourage you to do if you haven't saved your own spreadsheet yet, give it a name and save it and save it. Often. I last thing I'd do is lose your hard work. Um, I think when I was going to say is yet we're gonna have to say again. We said in our fictional kind of business were buying 20 items, but we're also gonna pretend some of those are the exact same item just there individually unique. So what we're gonna do is actually, um, pretend. And here's what I would actually do. And I'm gonna do this spreadsheet as if I would actually, you know, do this. In my real life, I would actually label each item. So say again. Say it's four different pairs of Nike shoes. They're all size 11. They're all the same style. But I have four different unique ones. I would actually physically, you know, print out some type of label or just at sticky label sticking on each one and given an item number. Just, you know, uh, whatever it is, Nike, Nike, air, Uh, whenever 123 and the next one B 1241 to 5. That way, I spent have specific items. And then that way to just later on when I'm shipping them and I say OK, you know this person Bob bought item Nike air 123 is OK. Then I make sure that my cares 123 go to Bob that I have the right tracking number, and it's all just associate it correctly with the specific item that said, Let's just keep going. Um, item, Name item. Uh, item number. Item name. I probably put the data about it. State purchased up where I purchased where purchased. And we might clean up some of these labels a swell later on. Just abbreviate them, if you will. You know, we don't want a big lump Wide column just for date. Um, okay, So date purchased where Purchased What else you want? How much we spent? Um, total cost. Now, you might want to track like the price, plus the tax. Plus. Say you paid shipping, lexie about it online. You had it shipped to you. I would. Me personally, Again. I'm doing this from my perspective. Would just put total cost. You know, if it costs. I don't imagine we're doing anything super expensive and say about 10 items online. I would, and they're worshiping. I just split the shipping cost over the total cost. So, you know, each item cost me 10 bucks and there's 10 of them. That's 100 say it cost me $10 have it shipped. I would just make each item $11 basically, you know, kind of allocate that the shipping cost. I don't care that much about how much I spent on the shipping ice window in total. How much I spent. Same thing with tax. Let's say you buy something at a store. You pay sales tax. Just include the total amount. Um, let's see what else we put. Our jeju were purchased. Total cost. Let's put Ah, we could put sale. Let's put aware listed were sold or where we're listed. So I'm gonna sumas. Well, we sell on Etsy, Amazon and eBay. Chances are you don't sell on all three, but, you know, if you did sell in multiple platforms, you know those air three examples of ones where you could sell Okay, So totally got us where we listed it. Date listed. Um, we could even something that would be interesting is sort of amount listed for I'm not listed for and then amount sold for I'd be really curious, and I'm gonna resize all these columns right now. I'm kind of annoyed, I guess, sir. A little If he when they're not correctly sized on a hit save. I'd be curious the same listing things on ebay, you know? What are they? What am I listening for when they're selling for their selling firm or they're being bit up or my having to drop the price? Um, so I'm not listed for not sold for, um, So I want to track shipping. I know that, you know, I'm gonna have to pay the shipping up front, most likely, but, you know, probably charging the people four shipping. So there's a couple ways to go about that. Say, you're charging a fixed shipping fee. You know, we could track that, you know, amount sold for amount. Charged for shipping, about paid for shipping. We're getting into a lot of data that way. I'm gonna put it in here, even though your other option would just be amount sold for and include the shipping amount in that. So say you sold something for $50 the person gives you $60 because there's $10 shipping. I might just put that Although that is misleading, because when we looked at our costs, you know, we're gonna think we made more on it than we really did. Um, I'm gonna say amount sold for, um um, shipping, um, fire, shipping paid, um, trying a better wording for this. Not sold for shipping. Ah, paid by buyer and then amount actual shipping costs. So we are gonna have, you know, some DoubleClick. These So we're going Kind of like a nice long spreadsheet here to, um, if you don't mind, I work. I'm gonna leave this the same. But if you want to resize things, you can go to view, you go to 100% you can change your zoom, maybe just want 75%. So everything fits a little bit nicer. But now the labels are obviously a lot smaller, and I don't do that to you. Oops. That's a little bit too big. Um, so I'm just gonna leave this as the normal size and we'll just have to scroll the cop across. So now we're going, You know, we're kind of getting a few different numbers here. Um, but one thing we can do, and we talked about formulas. Ultimately, I'm gonna put in here, eh? Let's put in a couple of totals. And this where we might start reorganizing few things. Um, so we're gonna put, um so we know how much? So let's say that total, um total costs, including shipping. That's how much it costs us to buy it and for us to pay for the shipping. And let's put total, um um total sold amount plus shipping. That way, if we want the detail at any point, say we want toe again, think of the future. You know, maybe you have thousands item sold. You think, Chris, you know, this is a lot of information attract? Sure, But say you say, you know what? I want to see how much I'm charging people for shipping versus how much of actually paying men. Make sure I'm at least breaking even. So would be important to have this level of detail, the actual shipping and the shipping paid by buyer. So, um, these columns, though we'll just be total. So we're gonna be adding up numbers from over here. So, um, when we put in our formulas, you want this will be quite easy for you, because then all these numbers will just be calculated and what we're gonna do, You know what another So just thinking of these comes like total cost, including shipping. It's gonna be a number, right? And it's only gonna take up this much space. Let's just put in, like 15.25. The number itself is pretty small. So what we need to do And if you remember from the Excel Basics class is do some rap formatting on this so it can make this more narrow and save us some space across. But I see this video is up to 7/2 minutes. Got a little long. Let's stop cut it off here and they will pick it up in the next one. 6. 038ITIE Section 02c Labels Part 2: all right. So picking up where we left off, you know, I want to kind of just do a little bit of formatting on this before we add in anymore headers just cause it's getting so far across. So what we're gonna do is we're gonna highlight this entire row and then if you remember, if we go back to our home screen, there is this wrap text button. So what it does, is it? So you see, in the example here that dropped down, I can't move my mouth, But it takes the cell that has, like, a bunch of tax and it wraps it. So it's just a nice that's kind of stacked. Then we're gonna wrap our text now. Looks like nothing changed. But what will happen then? I'm just gonna choose this one as an example. If we truncate this, it'll wrap it, but it automatically doesn't resize the cells. So we need to do one of these. And there we go. So now we can do that for all these. Now, if we use our double click trick, it won't do it automatically. Just does it across that we have to manually kind of make each of these. Ah, little bit more narrow. Let's just do this and then we're going to do another little bit of formatting. But let's first of all, just get these, like, uh, cutter scroll across here. Where? Listen, so some of these two, though you can think about, like, where listed. You know, there's no sense of making this one narrow, because probably the data we have in here is actually gonna be long. So, like, Amazon or eBay. So probably longer than that anyways. And we can leave it somewhere there. We can fix it later. Total cost. That's not too bad. Where purchased. I figure that's gonna be actually probably longer. Some is gonna make them, and even a bit longer date purchased. I'm gonna narrow that up. And you see, if you make it too narrow, it'll start cutting off the words. So I don't want that. I just want to make it like their item name. I'm guessing that one's probably need a bit space item number. We're gonna try to keep him fairly concise. Um, you noticed I left a few blank rows on top and on the side. I do that just in case, I want to add something in, like maybe I wanna edit header, like, you know, uh, Chris's eBay tracking spreadsheet, you know, in nice, big, bold letters. But I won't do that now, but that's why I leave different blank things. We can certainly the resize this and we can probably just get rid of one row off header. So I've right clicked there. I'm gonna hit the late. Okay, let's do a few more formatting things and then let's think about there's anything else we want to track in our spreadsheets. So, first of all, I want to center these. I don't like it when they're kind of line to the left. So I'm gonna click this whole row and just hit center Perfect already. Like it better. Now, if you remember in the Excel Thing as well, we kind of like, put a bit of color on it. We bowled it. I want to do that now to I just want to go and take care. It's I'm gonna do this whole row because if we add extra items here, we might as well just, you know, have them automatically be formatted. So let's sit there Bold button. I'm also gonna hit this under remembers. Remember our bottom border. So there's a nice, like, underline under everything, and then, you know, we can certainly at a color. I don't tend to go for anything too drastic. Nothing like this. And you see the color changing as I scroll around. Probably just something very muted. I tend to go with blues are green sometimes. Um, let's see if we can find one that I actually favor. Let's just go with, uh, there we go. Something like that. Okay, It saved yet again. Okay, so take this number out. Now that we have are nice cell truncated. We can actually probably this will even a little bit more narrow. Yep. Looks like Okay, let's delete this. Let's see what we've got here. Let's just go across again. I think if there's anything else we want to include, So we have our item number. Okay, So we're gonna sign things a number. We're gonna give it a name. We're going on a date. Purchased. I like that. Where? Purchase Perfect. Total costs now say the only thing I don't like about this is that pretty much the rest of our numbers air over here, so I kind of want to move this column somewhere over here will have, like, basically, like a whole section of columns that is numbers related actual dollars. Um, let's do that. So if you highlight entire column or an entire entire row, you have a color options you can cut up here or you can right click up here and you'll see what the options is. Cuts. I tend to use this one a bit more if you hit cut. And now we want to insert that, though we want it over here right before amount listed. Um, so what kind of have it, how much we spend, How much we lest it. So let's just insert here. So if we highlight this and then right click, you'll see Paste is one of the options swinging paste. And there it goes. And actually, that did not go correctly, and it did not. So you know what? We're going to redo this. Let me think this through. If we had cut, I know what we need to do. We do this, but instead we hit insert cut cells. So what's gonna do is insert it to the left of the column that I have highlighted. So let's do that. Okay, so you'll see it removed it from here, and it's stuck in over here. That's what I was trying to accomplish. Okay, so we've done that. You know what? This video is already in close to five minutes already, guys. So I'm gonna cut it off. Then let's continue going across and just making sure it kind of flows. It's in the right order. We want if there's anything else we want to track suspected maybe one or two other things that don't add in here. 7. 038ITIE Section 02d Labels Part 3: Okay, so I came up with a few ideas and other things I want to do. So first of all, let's just go across all kind of mentioned as we get there. So we have the item number. Item name? Perfect. Um, I kind of want to add in another column already. So this this is coming? Name? This might be like Nike, you know, size seven, Air Jordans. Whatever it is, I don't know, I kind of wanted, but I want this to be fairly brief. I don't want this to be super long. I kind of want to include additional column that maybe has a bit more information. Um, let's just put it Let's put it in there. If we had in abusing a great if not no problem. So I just right click there and hit insert, But I put, you know, item description. So this will just be try to keep this to a brief name. Um, and something that, you know, if we bought another one of them, we could use the exact same name. This will be a bit more like, So this might be, you know, Nike, Air Jordans. This will be size 11. Blue, blue and white, blah blah, blah, blah. Okay, So what next? Let's see, It's a day purchase. Where? Purchase things. That Almost one our dates to be together as well. Um, you notice that it's, you know, we have day purchase date listed. I want the date sold as well. That's one thing we forgot to put in here. So, um, I'm going to switch this. I won't wear purchase just over here, So I'm gonna cut this. I'm gonna insert it right here in circuit cells. Okay. So what do we got? I don't item description. Where? Purchase. Okay. Day purchased. Um, I'm gonna put where list Over here, then we have more information, so we're kind of moving things over to the left a little bit. This has put this here. Okay, so where list? It would make that a bit bigger. Okay, day purchase date listed. And I want dates. Olds, I'm gonna insert a new column. Okay, so this is kind of all over Date related information, if you will, Then we get to our dollar related information. So the total cost, maybe it will put in that total purchase cost. Just re label it. Let's see. I'm gonna Let's see, I kind of want to put in OK? No, that's good. Total purchase cost. Let's leave it at that. So now we have our item. We spent five bucks, 10 bucks on it. Whatever we spent. OK. Amount listed for amount sold for the shipping paid by the buyer. The actual shipping costs the total cost, including shipping. So these two will be totals of numbers over here. So these air kind of their own information. You know, this is kind of its own information, so we're actually gonna enter kind of box things off, but I don't want to do quite yet. I want to make sure we have everything that we need. So is there anything else that we would want to track? Um, there's nothing. Oh, there is absolutely, um, sort of some supplementary information, if you will. I want to know, uh, So let's see, dates sold. I want date shipped. So let's put it another date. Date shipped. I also want to put in um you know who did I sell it to on then? Also, we want to track the shipping information now. So now we have a decision. Do we want to put that in right Here is well, like here are doing when I just put it over here on the end. And I know this is a lot of information, guys, but I think to effectively manager eBay business. This is what you really should be doing. It it might seem overwhelming, but I think went to get the hang of using it. Once this has built, it's really just data interests. You got you by 10 things. You know, marshals. Like the YouTube video. I saw you come home. You just enter these really quick and then you're just updating it as you're going about your normal business. So, um, so let's see. So we have our dates here, Um, totals. I'm just gonna put that over here cause that's kind of supplementary information, if you will. Um, it's kind of like the last step. Like who bought it, you know? Yeah, who bought it? And what was the shipping information? Because he shouldn't need much more after that. So, um, so I have a date ship solder date shipped? Um, um, buyer's name. Um, And that might be their user names. Say it's on eBay or something, or might be their actual name. Um, the other thing you could technically track. Like you say, it's on eBay. You haven't auction number. So lot information what I'm gonna included in here. And then you guys can decide if you want to include that level of information, so it better you have it, and then you can delete it out rather than it's just not inherit. You don't think of it? Um, so buyers name. And you know what? With that in mind, let's just go a little bit a little crazy with the information buyers user name. I'm not conclude their shipping information here because I think that's something you could go look up after. The fact, if you ever need it, does seem like overkill. Uhm, but I definitely want the buyer's name and user names. So again, imagine that's 100 items on here and you need to go track something down. It's gonna be a lot easier. User name, um, shipping method and, uh, shipping reference, if you will. That would be like the tracking number. It's just call tracking number. Okay. You know what I think? I think we have it all now, guys. And if we think of something else is we're start entering data. So be it. We can add in more information, but I like I like this. You know, we already have quite a bit information we need to track. Um, but this could be really useful. Like I'm excited for our for the spreadsheets. Let's cut this video off and they will come back. And maybe we'll start to do a bit more formatting on this just to kind of clean it up kind of box things together. 8. 038ITIE Section 02e Labels Part 4: All right, So now, before we start putting any sort of data in here on creating, you know, Listen, we're gonna use I kind of want to look at it and say, uh, let's start boxing things up. So I'm gonna start on the other side, actually. So just to show you what I mean, so all of this, I kind of consider similar informations about the, you know, the supplementary. You know who bought it. And here's how we shipped it. I mean, you could box these two and say this is similar and this is similar. But for all intents and purposes, this and I say boxes. I mean, we're going to create some dividers just visually kind of separate this this a lot to look at here. So, um, so what I'm gonna do is I'm gonna highlight all four days, and I'm holding down the shift button and scrolling left and right that time highlighting, um, Now I'm gonna grab my mouse. And so what I'm gonna do is up here in this drop down next to the borders, so we put a bottom border on it. I'm gonna put one all the way around. So outside borders, and I'm not gonna use the thick. I just use the thin one. So outside borders. So now you see, this is kind of box together, so hopefully see what I mean. Everything date related, we're gonna border that. And now, since we chose the box last time, that's kind of already now, the defaults or it's gonna click here. Okay, Now, all this has to do with dollars. Now, we could break it into, you know, the shipping portion, etcetera. But I'm just gonna consider this everything to do with dollars. Although I do kind of like, I mean, these two will be formulas ultimately, and it'll just be the total cost on the total amount sold. So I'm think about this Will be, you know, we sold it for 10 plus the game US $5 for shipping. So we brought in 15 and this is like, Well, we spent $2 on it, and we had to spend $4 to ship it. So this is six. So these aren't grand total. So this is kind of a total area, so I'm gonna make it its own box. So even within the box, you could then re highlight, and it'll just box around. I'm gonna box this, okay? And I can't quite see if there's a page break in here. Um, I'm not sure we can make that go away. We'll probably change our view. Let me just take a quick look normal. I'm going to see if in between the videos, I'm going to see if there's a way I could make those those hashtags, uh, that dotted line disappeared it so we can see it better. Um, and then this, I mean item number, name description were purchased, were listed. So let's say I'm gonna say this. Let's go back to our home tab and then this where purchase were listed is kind of the wares of the situation. Um, that's pretty good. I think again, we can't see that separate. I'm gonna find out how to get rid of those. Some pretty happy with this. And now we have sort of the general sections. And what will happen is as we list stuff down here, we're also gonna put lines down here, so it'll kind of visually separate the different sections. The last thing Let's just I want to go through it one more time and take a look. Item number. We're gonna sign it. And you can use whatever numbering system you want. We'll talk more about it when we put more data and item Name, item description. Okay, I'll make sense. And then we have a list of what it iss Where did we buy it and where we're selling it? Perfect. Eso I would imagine So say we buy those Nike shoes. I'm probably gonna use that as an example, mainly cause one of the videos videos I watched about the fellow who goes around by stuff. That's what he was buying with Nike cleats, like football shoes and track and field shoes. And he would just by several different pairs. So we would give each item number the names, description Baeza, Matt Ross. You know, where's the list? Um, so I would assume, you know, if they haven't been listed yet, then this will be blink. So that would be kind of a visual way to see like Well, we haven't listed anything. Ah, the date purchase date listed. So we'll be popular with spreadsheet. Come on. Going as we run our business dates. Old days shipped. OK, I like that. So perfect. Purchase listed. Sold ship. That's a natural kind of flow of where the transaction would happen. Same with us, you know. Where do we buy it? Where we listed, You know, we would typically by then list we purchased, Bubba. Okay, so purchase cost amount listed for. That's one way. I think, um, you know, Mount listed for an amount sold for you could decide. I mean, if you don't really care about your listing price. See, I would be interested to see, like, one of my lists, the same listening things for $10 they're selling for 12. Okay. Should I just increase my listing price or say I'm listening? Thanks for 10. And then ultimately, I'm having that dropped the price down. Um, you know, somebody does I list them for, um, se by it now for 100 but you can bid on it and that their end up selling for 80. So I'd be curious about that sort of metrics. That's why I want to track this. Okay, so then they sell the shipping paid by the buyer. So how much did they give you? The actual shipping costs. How much you're spending on shipping. Total cost, including shipping and total sold amount. Ah, the one other thing that we could put on here I think we should is ah is profit. Now, this is meant to be more of a tracking red spreadsheet and what we're going to do after we build this entire cool thing, we're gonna add in a second tab. That's almost like a dashboard where we create monthly reports and we say how much you know , how many times do we sell? How much profit did we make? Um, so that's really where would be calculating profit, But at the same time, I'd be curious just to see it. I think, um, so by item, we could see it in that way to if we ever do filter. So we say, Well, how much are we making on those Nike shoes? We could just filter out Nike shoes and see what our profit is. So I do want include one more column here, and we're gonna do that in just a second. So then, lastly, we have the buyer's name, buyers, user name, ah, shipping method tracking number. And then I mean, I wouldn't bother put anything like when it's delivered, you could, um it's one of the things that I think that's overkill because it's 99% of time not gonna be an issue, so it's not worth tracking. So we wanted to get one more column here because I want to put the prophet I want the total product tell amount sold and incoming money versus the outgoing money. So because we put this line here, if we try to insert something, it's gonna put it to the right of this, I believe is Let's just try that. So that's gonna kind of eso what it Adam do, is putting it a double line. Um, I don't really want this line on the left because this is gonna be part of this sort of financial information. If anything, I'm gonna box of these three together. Since they're more like totals on, I might actually do that. I'm gonna show you, though, how to remove this line if you go to this drop down box. And at the very bottom it says more borders. That brings up where you could do a lot more with this. So you see, right here this represents what's highlighted right now. What's highlighted right now is that cell and there's a border of the whole way around. Well, if you click on this line, it disappears on that. Simple. Is that click? OK, And there you go. What's gone? Ah, so the one thing I said I did want to do was include a border around here, and maybe we did. We can't see it because the dotted line, but nonetheless, let's Ah, let's go to that. Ah, outside borders on there. So we're here. We're gonna put total profit. I mean, that's what total profit is. It's your total amount sold, plus all the other stuff less all your your costs. So total profit, that's it. And that'll actually be kind of an important column. Okay, guys, this video again, up to seven minutes, they go so fast. So I'm gonna cut this off. I'm gonna look up and see if I get rid of these dotted lines and I think what we'll start doing in the next video since I like what we've got here is start. You know, coming up with will come up with one or two dummy ideas, and then maybe we don't need to enter every single item yond video. I can enter it like 10 or 12 or maybe 20 off video just so that we have a fully populated spreadsheet once you have the hang of it and then we can do like that's cool reporting and I'll show you what we could do with it. 9. 038ITIE Section 03a Data Entry Part 1: All right, everybody. So, first off, if you remember the last video, I want to figure out how to get rid of these page brake lines. I didn't know off top of my head. Little trick for you. Any time you have a questioning, sell something like that. Google is your friend. So it's like I went googling you know how to remove page brake lines. Very first thing that popped up was the exact instructions. I checked them out already to make sure they worked. Then they do. But I want to show you just does extra sort of bonus information. If you stuff, you go to file, but go to options. Then you come down here to advanced, then you scroll down here and it's way near the bottom. And so it gets to display options, and there's lots of different ones. And eventually one of them says splay options for this worksheet show. Page breaks on. Check it hit. Okay. And there you go. Look at that. Simple is that it's all cleaned up. Let's hit. Save. Uh huh. Okay, so we have our headers. We're gonna stick with these unless we think it's something that we really, really want. We're not going to make it any more complicated. Now, When I originally format that, I just kind of did the entire row and I made it all blew. I'm I'm usually actually not a fan of doing that. I would prefer to just have the the cells colored that I want some actually gonna change this. I'm gonna highlight this room. I'm going to, um I'm gonna get rid of that bottom border because I don't want it all the way out here and get rid of the blue. So and then what we're gonna quickly do is just after putting no Phil here, it will get rid of the color. They were going quickly reformat things, groups that didn't, uh, didn't quite take our up. You know what? I'm having a border. Silly me. What's and sorry. I'm not explaining exactly what I'm doing because we kind of covered these things and I don't wanna know more. Everybody with re explain things we've done essentially I highly at the row, I changed it to know Phil, and then I also remove the bottom border. So now let's re highlight what we actually want to have colored and bordered. So we're gonna go to bottom border. And while we have anything highlighted, we're gonna go to that light blue color. And there we got C 10 seconds of time. It's all cleaned up now. Looks a lot nicer. Okay, so that's it. In terms of we have our, you know, kind of. You know what we're gonna be using a few will toe to track things now, so let's go ahead and track. You know, I'm gonna enter to three items than like I said. Well, maybe cut this video off, and then I'm gonna go ahead and populate it with maybe 20 items so that I can show you now what to do with all that data. So again, let's just say ah, you know, item number and again, for me, this would be the item number that I want. Oh, you know, I want to be unique. And I would actually physically, like, put a little sticker on each item so that I can easily find it so that I can and I could have things organized to like my physical inventory. Whatever it is I'm selling, you know, say it's those Nike shoes and say, That's all I sell is just Nike shoes. But I buy all kinds of different sizes. Different colors, different purposes. Some are cleats. Summer Air Jordans. Um, you know, I would number each one, and then I could sort of track them and keep wherever I keep my inventory. If it's in my spare bedroom or my garage in my office, try to keep things organized. Maybe in boxes like of 10 you know, items, ones her tanner in this box, etcetera. So that said, Let's Ah, let's stop numbering things. So another tip for you if you try toe, enter things and say you did zeros in front like 0015 It's just gonna put five if you want the cell to show exactly what you type type. The the apostrophe first is called possibly should be next to enter Key. And then whatever you type, let's just call this item 00001 It will do it exactly as you type it. Um, be creative. I mean, whatever you want to do this, maybe you call all your Nike shoes like Nike. 001002003 I would also give yourself plenty of space. Like, because Think long term. You know, maybe over the course of a year, you might sell hundreds of pairs of Nikes, so don't just call it Nike one. Call it Nike 00001 Then you have room to add 234 I like to have that kind of same formatting. Um, but nonetheless, I'm just gonna go with numbers for this case. Uh, we're gonna do 0002 Now. Here. What I could do to is copy this down. Something hit? Control C. I'm gonna shift an arrow down and hit control V. Now, if you go to any cell and hit F to press the f to button, it brings up the editor. So that's a handy way. So I just scroll down. I hit f to backspace a type three hit Enter. It goes down one, and then I just repeat f to backspace. Type four enter. You have to back to say it's five. Let's just do it for these and we'll stop there. We won't necessarily fill all these M um, so get I'm gonna say these are, um Nike and I did not familiar with all the different Nike, you know, item names and whatnot. That's got call these Nike cleats and let's pretend we have, ah, three pairs of those that we bought and someday we will. Actually, Phyllis and we also about some Nike Air Jordans. Um, about two pairs of those. And then we bought some. What else? Adidas. Adidas? I'm not familiar. All with Adidas name souls. Call them tractors. Okay. Okay. So item description. Maybe here's where we put size and color so we'll say Ah, you know, size 11 white and blue. I would encourage you to use the consistent sort of format. So if you're gonna type size 11 white and blue, do it the same here. Don't right the next one white and blue size 12. It just gets messy that way when you're looking. So if you use a consistent thing now, the other thing I would encourage you to do, um is if, say, all I sell the shoes. Maybe I have ah columnist devoted just to size. I probably would do that or and I would have a common just devoted to color. But if I still just a hodgepodge all kinds of different stuff. I'd probably stick to something like this. So that's for you to decide how many columns of data really need, Um, but for now, we're just going to do it this way. But honestly, if I was just telling shoes, I would have a column for size and a column for color, maybe even a column for a condition, you know, if that brand new or if they have a mark on them, etcetera. Ah, one thing I noticed here is this cell kind of goes or the text in the cell goes beyond. So if we double click here, well, just widen that a bit. So let's just do two of these and I'll fill in the rest off the video, since for up to six minutes already. Actually, let's go. Let's cut this off. They'll come back, will feel across, will just fill these two all the way across in the next video. Just give you an idea of what it would look like, and then I'll do the rest off line, and then we'll do some reporting 10. 038ITIE Section 03b Data Entry Part 2: Okay, so let's continue on with this. Um, let's just go across with one item that will replicate it. Kind of for this, Um, What we're gonna want to do is we're gonna ultimately will have some something of the same kind of like here we have, you know, some of similar items and some different ones will do that with sizes. Where? Purchase. So then, when we get to reporting, you can really see how to divvy up the data. Sorry to say these were purchased that Ross, if you're not really a frost itself the discounted sort of last year's fashions, Um, maybe for this one will say we bought the's at who knows, garage sale. But I wouldn't necessarily be buying use shoes at a garage to help. Um, okay, where and then for size, we might as well just filled all these in these air size. Ah, size eight. Red and black. Okay, we're listed. So say, I mean chances. Are you primarily selling one site you sell on eBay? Still on Amazon, etcetera? Um, I know the proper way to type BB is what the capital B in the middle. Um, will just say ebay But then we'll make some of these Amazon. When I fill in the rest they purchased. Um, oops. I hit something there in a sec. There we go. 01 let's say, 04 18 and to whatever. 03 18. It doesn't matter too much. Okay, date listed. Let's say we listed them the next day. Um, two for 18. Let's say these groups were getting need to make these just a touch bigger here. These sold they listen, the 5th 3 they sold on the seventh. I just want to be a feel for what this sheet looks like. So when you see this, that makes the means. The columns not wide enough will resize it here in the 2nd 024 let's say they sold right away. We pressure may be too low, and then we ship them the next day, and then we can't see her soul dated. Sorry for you. What? They are not, actually. But if we double clicker, it will resize that for us. And maybe we want a bit more space. So we even just give it a little buffer there. Um and then we shipped these Ah, day later. Two of 5 18 Okay, so total purchase cost. Um, again, These were shoes. They tend to sell for 10 to $15. That's a 9.99. And maybe these And then you see, I marry, actually it formatted based on the date. So we're going to do some formatting here on the numbers in a second. Um, what the's worse, a movement 12 99. Okay, so before we get too far, we know that all these air going to be dollar signs, right, Including the shipping clean, the prophet. Now, we don't need just these two. We need, like, the whole whole area to be, um, dollar signs. I tend not to like to do this move, though, because that is gonna format up in here is Well, that's what I might do is just go like this all the way across and then down. And I'm just gonna hold my shift key. And I'm just going to go down, say, like, several on down to row 1 93 That works for now. When we get to that point, we can continue for manning. All right, so there you see, it's a dollar signs um out listed for us and we sold these for 20 or we list them for 20 facilities are listed for 25. Say he's got bid up and sold for 23. He's ended up selling for 25. Somebody used to buy it now or what? Not shipping paid by buyer. We charged eight bucks for shipping on shoes, assuming it's like 8 to $10. And let's say just for point of the example, let's say that we actually shipped it only cost us 7 50 We made a little bit of money on that. You know what? One thing we don't have on Harris fees, Um, things like eBay fees or PayPal fees. So that is actually an idea. So let's go ahead and fill this in. And then let's talk about that and think about if we want include that here or what we want to do with those because then you know, then we're really getting into tracking like even more data, but nonetheless, so total cost, including shipping. So this is gonna be a formula. So, actually, maybe before we enter our formulas, we do want to think about the PayPal and eBay fees and Amazon fees, whatever. Because you know that's gonna factor into these costs as well. So certainly there's gonna be a papal fee. And I know that a lot of companies pay through PayPal. Or maybe you have a credit card process. They're going have to pay them a fee. So the other question is, Are you gonna be able to identify that by items specifically? So there's a couple ways to tackle this, and I think I think what I prefer to do in this case, since we sell a lot of stuff and it's it's adding an extra level burden. What I would do is when we get Toe month and reporting, we're just going to put in a gross number. Yeah, we spent, you know, $200 on eBay fees and $100 PayPal fees were not going to say which items it's on. It's kind of irrelevant as long as we know that as a whole. We spent those fees, Um, that that's what's more important, and that's what I want to do in this situation. Just cause I think it's gonna be when it's gonna be a bit of a hassle. It's a little bit more effort for you, which isn't so bad. But there might be situations where you don't see a feel like I'm not quite sure if Amazon shows the fee per item. So or if they do, show your overall monthly fee. So I'm gonna leave them out for now. But let's recognize that we do need to calculate that, and we're calculating our total profitability. Okay, so we're almost at the end. Here's let's fill this in before we end of video. So total cost, including shipping. Let's use our formula something hit the equals key. So the total cost Well, it's the purchase cost, and I'm just arrowing over, and then we hit. Plus, and it's gonna be the shipping. The actual shipping is what our total Costas. And then the amount sold, plus the shipping on, I mean, plus the shipping that they paid so that they sold for 23 and they gave us eight bucks towards shipping. Okay, Our total profit is just going to this number less. This number equals this. Subtract this and I'm just using the arrow keys guys to move around. So there we go. Um, gonna hit the save button real quick. Okay, Now, we're just gonna kind of charge ahead. We're actually talk about this stuff a little bit more, especially get to the analysis. I just I don't want the video to go on too long. Let's just get it filled in, and then we'll go from there. It's a buyer's name. This is surplus information again. You might not even include this was gonna call us. Ah, I was Come. John Doe. Very generic name. His name happens to be John Doe one. We shipped it by U. S. P. S. And the tracking number is again. I'm using my posture fee. Um, whatever. Let's just put a random number. There we go. Okay. So, scrolling over. We probably want the user name feel to be a bigger. That's fine. The tracking number plate is bigger. Perfect, son. Now, if there's ever a question about this particular sale, guess what? We've got all this information. Another thing actually might have want include here with the listing number. So again, I'm not going. Include it now. I think we have a lot of data. Um, but I would certainly consider putting in here, you know, I'm listening on eBay. Here is a listing number that we have a very direct link to the item itself. Okay, guys, let's, um Let's cut those video often. What I'll do between now and the next video. I'm gonna fill this in with data. I'm not sure if we'll stop here. Maybe I'll add a bit more, and then well, then we'll actually start going through and read across and start to see what we can actually do with us. 11. 038ITIE Section 03c Data Review Part 1: All right, everybody, I'm back. And as you can tell, our spreadsheet kind of grew. I entered some data, so I want to go over this and just point out a few things, actually, is a couple of things. Just that I was doing this, that I thought off. And I made a little list down here, actually, so we're gonna delete this. So, first of all, we need to include tax and total costs. Originally, I think I have these, like 10 99 whatever it was in 12 99. I mean, that would be the price before tax. The really This should be including tax. Unless you really want o track tax separately. But I wouldnt so total purchase costs. I mean, you can put including tax if you want to, you know, to note that it's no problem or just know that total purchase cost includes tax. So I just kind of chose some random now off numbers. If you if you will, just to kind of reiterate that so we can delete that item, I want to point that out. I'm sorry for bulk buys. Used average ConStor allocations. So, um, one of the sites. I So one of the places we purchased, you know, I chose a few different ones. And again, we're gonna go through these, Um, is both dot com there several where you could basically buy a palette of stuff. So you pay 500 bucks and you get, you know, 50 items and you say, You know, I only want new items that are in the box, and they have to be like kid toys, etcetera. But you're gonna get a bunch of random kid toys now. How do you allocate that? $500 to 50 different things. Do you disable each one? Then Rough was $10 but that I might not be fair because some items might only be worth two and others worth, you know, 50. You know, when you sell it. So, um, so my best advice would be that kind of your best choice. So if you get a obviously a pallet full of the same stuff, then you can just split the cost up and say, OK, each of these costs $10 or whatever, but otherwise I would try to Al can say, OK, I've got $500. Even if you group them say you kind of put your 50 items in, you know, kind of like cheap things that are worth about 0 to $10 things that are worth you know, 10 to 2020 to 30 and then try to allocate that $500 so that you can use that for your total purchase cost cause ultimately, you're gonna want to add up to $500. Now, you know, we're tracking by individual items, so you could, in theory, just go. You know, bulk palette. You know, that costs me $500. And how much did it sell for? And you could list out each item that you're gonna sell. Um, their story. You could keep track of that separately, and that is put in the total sales amount. I don't think most people would want to do that. I would really like personally, I would want to track each individual item, so you're gonna have to figure out a way to allocate that cost. My best advice is to try and, um, sort of manually do that and figure out what each item is roughly worth. Know that you might be off a little bit. But uhm And another, If you want just another idea, if you will, you could go based on sales price. Let's say you list out your 50 items that are in your crate and your listing Some items for 20 some for 30 some for 40. Allocate the cost exact same ways. You know, just you could run some percentages and so Okay, well, 20% of cost needs to go to the low ticket items, etcetera. Do it that way. So freezing pains. I'm just going to leave this right now. So third point. So you notice as we scroll around, we kind of lose visibility of this top, and that's not gonna be good. I mean, we only have No, it's not even 18 items here. We have 15 items, and we're already almost to the point where when we scroll down now, the other thing, too is only scrolled with right, cause they have a pretty big web Are, uh, read sheet. We lose with this sense, we don't know. Like what item this is. I mean, we have no idea. So what we're gonna do is something called freezing pains. We're gonna freeze it. So when we scroll down, this row stays on top. Always. So this only this parts girls. And also, we're gonna set it so that when we scroll to the right this I don't think information stays on the left. Um, maybe not the item description, just because the because it's a very limited area of data that's gonna move. So I want, you know, kind of bigger area, so I'll show you what we mean. So, first of all, I'm gonna put my cursor here Now. We kind of left a blank row. I'm gonna delete this blank row. I don't want my data to start right at the top, So we're gonna put our cursor here. So what? And the reason for that is I'm gonna tell Exelon. I'll show you how everything above the cell and everything to the left of the cell I want you to freeze. I don't want it to move as I scroll around. So what? The way we do that and we're going to venture off our home tab is to go to Italy with data It is not. It is view its views. Under the view tab. You'll see something here called freeze panes and he could read that frees a portion of the sheet to keep it visible while you scroll around. So if we drop it down, weaken, freeze. Just the top row, we can freeze. Just the first column, but we actually want is kind of both. And we don't just want the first row because, you know, it's we have our first run. Our first column are actually blank. So if we just click freeze panes the generic Lynn. So you didn't know if you noticed it, But now there's a light gray line here, and there's a light gray line across here. Unfortunately, kind of negates are solid black line. So now if we scroll down, I'm going to show you what happens that will just, uh as we scroll down, see that top road just stays and everything else see, it goes 12 15 and now will be 16 17. So it's just kind of moving back up behind. Now I'm going to go all the way to the top. Now let's go to the right and see what happens. Same thing you notice that we still have our description over here. I'm So as we scroll over here, you know, we can see everything and it's up to you. What information you want to see? Maybe you want to see that I am number. Or maybe you did want to see description. My only problem with that is you're gonna have a smaller area here. So that's that. I'm actually in a narrow this column just out of seeing this. Now that you know, we dont have big descriptions in here trying to get as much information on the screen as I possibly can. Okay, guys. So we're already up to five minutes. I'm gonna end this video and then the next video I want to go through some of these items, just give you a sense of what I put in here. I mean, you can read it, but I give you some of the logic of why I kind of set it up this way. And there's some blanks in here. 12. 038ITIE Section 03c Data Review Part 2: Okay, so let's let's take a look at this now. So we originally we had our Nike cleats. So what kind of went with this theory? Um, that way. Just sell random stuff. We find stuff, we find a good deal on it. We buy it and we sell it and we make a profit. And that's what we do for a living. So I put in some more shoes. Move. My cursor is not stopped popping up. Um, from Adidas track shoes. I put in some dog gates, random things, logic, tech speakers and desk fans. Honestly, I looked around my desk and this what I saw. So I I used those, um, I put in all different sizes of shoes and colors, noticed that I kept a consistent kind of naming policy, if you will. For the dog gates that put dog pros. I made up a name of a company Black Gate, and then this one said Dr Rose Black Gate. But it damaged box, so that'll factor into our pricing dog gates around so different brand. And I said this one had no box. Um, I don't I'm not familiar with law. Detects different numbers on their bottles. So I just went that the model Superbad Speakers 2000. We bought two of those and then we bought the modest noise speakers off Earth Out are thousands the model number. And then we bought two deaths. Fans say model Air Blaster 2000 places we buy we buy from Ross, which is that discount clothing store. Um, you'll notice that I have some speakers down here from Ross. Two marshals is actually the same kind of story, if you will. They actually do some more than just close. They do sell some electron ICS and stuff, so it's not surprising that would have things like this. Um, I assume the other place that we find deals is both dot com, which is a real site. Um, I don't personally use it. I mean, I'm not an Amazon or eBay seller, Um, but I have been in the past and so, But I do know that a lot of sort of the people that sell and you know, are active on their lot that buy stuff by the bulk, like pallets of stuff from both dot com. And that's where um, I kind of got that idea about how How do you spread your costs when you buy just a palette for, say, $500. How do you make headed? Cost these items out. Okay, so where listed? I'm assuming we're selling on eBay. Amazon. Craig, I put one craigslist on here. It's ah local. You know, this sort of ah marketplace If he wills like online site, um, so characterless Amazon ebays. And it's up. There you go. Date purchase. I just kind of put in some random dates. It doesn't. This isn't as, uh, pertinent date listed. Assume we listed everything about within a day or two. And now. So I did leave some blanks down here. So this is how it would look if you say bought something and it's not listed yet, it would just be blank. You wouldn't have any information. So that's a quick way to look through and see now, Another column we could have entered is, you know, statuses. It listed. Is it sold, etcetera? And actually speaking of that. So before we get too much for them here, I created a second tab. And on here I put additional category ideas. So if we think of more like through the course. So, like we just did. Um, so status sold. Um, list it not listed. Um, etcetera. I'm gonna list them out here. So I said you could put category like shoes, toys, dog toys, cell phones. You put the listing number, which we didn't like the eBay number. PayPal fees. So if you did wanna track those PayPal fees individually, um, Amazon, eBay selling fees, saying is kind of a papal fee. And just now, the status is it sold? Is it not listed? I'm gonna rename these tabs. Um, the way you do that is the double click on the name down here. She, too, was gonna call this additional category ideas. And the reason I'm putting that on here is because you're gonna be able to download the spreadsheet when we're done. And so I'm gonna leave this on here for you. So you can, you know, have that. So this is gonna be our inventory tracking sheet. Just call it that and probably dies. What will do when? Once we're all done just to give you a heads up, I'll leave them one with all the data and here. But I'll make a copy of it. That's just blank. So if you just want, start with a blank one. Not that it's that hard to delete stuff, But just so you have a fresh prince, let's go through the rest of us really quick. Just explained some of my logic. Um, so date listed dates sold so blank ones means they didn't sell yet. And that's where if we had a status thing, I could see you know, these being listed as listed in listed, and then maybe these have the check box sold. The only thing with that is that it's more work. You have to even be entering more and more information, so but it would give you the ability to run reports and see what sold what's not sold, etcetera. Date shipped. So I left one blank here, So this one sold. And this is where you could use the spreadsheet you're starting to see. Hopefully, some value. You purchased it, you listed it. You sold it five days later. But it's not ship. So what happened there? So this could be something where you make it purpose that going through every morning and going anything that sold should be shipped. And if it's not shipped, you know, then you need to look at it. And one would have to then look to and see like, Well, was there a tracking number entered? Because if there was that, it actually did ship. You just forgot. Update your spreadsheet. Okay, so, guys, that is that. So total purchase costs again. Random numbers. I tried to use numbers that are kind of relevant, You know, you buy shoes 10 to 12 bucks. You know, these were expensive. They were Jordan's got, you know, we paid a bit more for those speakers. Constants a bit more. You know, those those two thousands, whatever they were super bad speakers to thousands. Okay. Amount listed for again, just numbers put in relevant numbers. I try to put basically at least double the price, if not more amount sold for, for the most part of used the same amount listed. But for some, I put a little bit difference. Maybe on eBay, these sold for a little bit more. Um, what else? Went for a bit more? This one for a bit more on eBay. This on craigslist? That would actually be surprising, because usually what you listed for is what you sell it for. Actually, a lot times people bartered you down. So let's change the structure to 18. Um, let's see if there's any other ones that are different. These were listed on eBay and sold for a bit more. Its maybe list for 75 they got bid up. Uh, he's got beat up by dollars in this soul for a shipping kind of the same thing I put in generic shipping assume sometimes are actual shipping was a bit less this one, and being a little bit more little bit more here, you know? So we kind of, you know, blew it when we estimated our shipping costs and how much they had to pay. So that would be a good way to toe. Keep track of that. You could run a report unstable. What items of my paying more for shipping than they're paying me. And then those are items that you realize in the future you need to charge them enough. Um, and then we have our formalist, um, So again, if remembering and hit f two here and they'll show you, it's total purchase cost, plus the shipping costs, and then our total amount sold is gonna be amount sold for, plus airship, the shipping they give us, and then our profit is simply the amount sold for with all and the shipping less the costs in the shipping that we paid. So here's our profit that we made on each item. Now I put in formulas for each line item. So this one, even though they haven't sold its already calculating list, But, I mean, that's kind of true at this point, we did spend 13 85 and we haven't made any money yet. So right now we're in the whole 13 85 on those shoes. Um, I just put in generic names, obviously, and generic user names. This is just sort of filler, if you will. I'm just to show you how it would work. Um, And again, the item that we didn't ship yet is blank. And that's what I would expect. Um, again, if say, we had shipping information then and nothing here, we would have to go look that up. And I just put in tracking numbers again. Random numbers. And so they're just to give you an idea what the sheet should look like as you're kind of actively using it. So, um, we're up to seven minutes in this video, but just sort of final points, if you will. You know, I would encourage you as you're using it, and we're gonna do some more work in here. Obviously, we're gonna wish I had to run some cool reports on it. But you just be update. This would be your your lifeline. Like every day as you're buying stuff, you sword, that you do your thing, come in here and spend half hour update your spreadsheet. You know, updated every evening, Upton Every morning, whatever the case might be. And just know that you sort of those big events that you updated. I was 20 by stuff. You need to enter it in here. Um, when you listed, Okay, Now you have to interest some listing dates. Now it's old. Enter the listing. Tates shipped, etcetera. Sears constantly sort of managing everything in this spreadsheet. I hope you see the value in this already just for from an organization standpoint of knowing where you stand with each individual item. Because imagine these items were all listed on the same day and there's different. Everything's they're selling, you know, etcetera. Some aren't. And that's also where we talked about additional category of status. You know, maybe there's one. That's where it's sold, but the person hasn't paid you yet. So you need that kind of in between status up. Alright, guys, let's end this video when we come back, Um, I'm gonna show you a few more tricks on this sheet, and then from there, we're going to start building a separate report to really track profitability. 13. 038ITIE Section 03d Data Review Part 3: All right, everybody splits. I'm gonna show you how to do some filters on this. So just to give you an idea of where I'm coming from, I'm thinking of this is this is like, our active worksheet. This is what we do, all the all the work in. We're doing our track and keeping track of our, you know, our money where we shipped it, etcetera. So at times, we might want to be able to quickly access information. In here. We will build a second sort of taboo fuel that has actual, like, monthly reports where we're gonna look at things like, how profitable are we, Um, you know, how many items do we ship? You know, whatever. Whatever metrics we want to track. But for the day to day, um, this is where you want to be. Sort of active. Some. The one thing I'm gonna show you is filter. So we learned it in the introduction to excel. If if you watch that video at the very start. Of course. So if you highlight this entire row and actually it highlighted, both of those are not quite sure why. There we go. Okay. If we go back to our home tab. Um, we're actually going to then go to data, and we want to see, actually, it does not look like now I need to find it. Where did that go? Here we go. It is on data, So I just told you missed it. Um, filter. So you can do a couple things. So let's do filter. First, I'm gonna show you sort as well. It's a useful tool, but you gotta be careful with it in one way, and I'll show you Why. So, filter, we just highlight this whole row we hit filter. So what it do? So you saw it put these little drop down boxes on every single column. So what we can do now is we can filter this entire bulk data. Now, imagine to this is 102 rows down the road. Um, that's okay, because we'll be able to sort things out. So, um what me? What we might want to do is okay. Let's just there Several examples say we want to see everything that's, um listed but hasn't sold yet. So there's there's nothing here. We could click on this filter for sold, and then so it. See, it has check marks of the information. So 2018 January February These expandable since supplied by date. Then it is or blank. So we just want to see the blanks. Right? So I'm gonna take 2018. I'm gonna uncheck it. So now we're telling Excel, Just show us the blank cells. So not just the blank cells, but the rose where that sells blank. So there you go. So these air your items from your list where there's no date Soul. It's a quick way to access no specific items since to saving information and you'll notice to the little drop down box, has a filter on it and even tells you what the filter is applied. It's just a quick way to look across this list cause say you save this and 20 will get up and you forget, you know, where's all my data? Um and so you'd quickly look across. Got okay. I have a filter on here from toe unfiltered. Just go back and you can click. Select all. Now it has a black box that that means there's a partial selection. Click it again with the check marks. That's the full selection. There's everything again, so you don't lose it. It's just hiding everything else. So it's It's a quick way to do that. Um, one area. So we talked about additional categories sold, you know, listed, etcetera. I could see how that would actually really be a useful column, and I'm not gonna add it in here right now, but again, I don't want to kind of step backwards and start, you know, adding more columns, but you could then filter on things like sold or sold, not shipped. I mean, you could make yourself a category of that, and then you could easily filter your reports from what else might you want to filter by? You might want to filter by. Um, let's see. Say you had a super long name or a super actually. Now let's Ah, let's think of something else. Item name. Say you want to see only your logic speakers. So again, you know, we only have 15 items here. Pretend this is 1000 items long and you have slot attack here. Maybe further down you have large attacks. So we go here. Say okay, here's all our categories of stuff that we've sold I'm gonna uncheck everything and then I'm gonna scroll down. There's our logic tech speakers. Just show me those. And there you go. So you would have a full list of just logic text. And maybe you're doing this because you want to see which ones you haven't sold. You want to see you, like, how many of my buying and selling How long has it taken me to turn them around? Now you can just focus on the specific data points that you have. You could also look at your profitability and say, Am I making a profit on these? Let me see what I'm kind of making. Oh, wow. You know, they sell for a lot of should, really by more of these. So that would be just sort of two examples on why you might want to filter things out. So I'm gonna put us all back. So now we have everything again. Another thing you could do is sort. So say you don't feel comfortable. The filters, for whatever reason, you consort this date. I mean, we've kind of entered it in item number and sort of chronologically by date, when we purchased it, but say you want to sort it? You want it? Um I mean, we kind of have this already organized by item numbers. That doesn't really work. Say, we went to the group. Everything that was Ross, that we bought it. Ross, we just want to see things together, that sort of fashion. So what you could do is highlight all of these rows. He would just highlight all of your data. I tend to go one extra just for fun. And now we're gonna sort so the sort feature is also on the data tab, and it's right here next to Filter is gonna bring up a box. And it's going to say, OK, sort by and you get to choose item number, Adam name, item description, etcetera. We're gonna sort it by where purchased. You can leave the rest of this. Um, and there you go. See, now everything sorted, sorted by bulkheads, alphabetical marshals and then Ross, Now the key, that is when you sort highlight Onley this it automatically picks up the fact that these air, the height, the header rows, like you remember, we select it, sort by where purchased it figured out that these air kind of the main categories. So, um, don't include that in here. And your highlight. Just this, um, So there got so we sorted by, You know where Purchase. Now, you see, these numbers are out of order, You know, the items around order. But that's OK, because we can always just go source this, buy whatever we want. I mean, we kind of made the default that, you know, we, uh, the item numbers were in order, so we can always go back to just sort it by, uh, item number. We'll scroll up here. Oops. We did something wrong. Ah, see, I don't think I highlighted the very it looks like we did. Let's take a look here. So one thing it is doing wondering why let's try this again. That's is actually interesting that it's not picking it up. Right. Okay, So this check box, for whatever reason, was check. So my data has headers. Um, So if you do click this box, it assumes that the first row highlighted is the actual header, so you can and theory highlight the head in a row. You just have to make sure the right boxes were checked. Um, in this case. For some reason, it's really not picking things up. But we know that colony is where purchased. We know, column B is item number, and that's what we want to go back to. Let's just do that sort, uh, interesting sort. Numbers and numbers stories text separately. I'm not quite sure Went on there, guys, to be honest with you, but we got back to where we were, so I'm not gonna spin your wheels too much on that. So hopefully you have a good sense now, just had quickly kind of navigate this data filtered out. You know, this is a lot to look at. I could easily send again. I see this more is your day to day. You're working in here so I could see you just highlighting or filtering out things that you know you don't have list of sold yet because those are the ones that you're gonna be working on. Things that sold. You don't need to see them say, um, that's also where a category boxwood, um of status would be appropriate. And you could kind of permanently leave out items that are completely sold, sold ship delivered. Just leave them off this list. You still have the data there. You don't need to see them day to day, so that would be a good use of a filter as well. So hopefully that's useful to you. So in the next video, on the next section, we're gonna start building just a report that you would sort of fill in every month and I would recommend. I mean, you could stop here if this is all you need, uh, you're welcome to, but I'd like to then use this information now and kind of do some metrics to really figure out my sales and you know how much money and my makings. Let's do that in the next video. 14. 038ITIE Section 04a Summary Tab P&L: Alright, guys. So let's go ahead. Let's first of all, just create another tab. So, um, you can order these. If you click and drag, you can relocate these, um I usually, like I'm gonna put this one up front. You would like to have a nice summary of what did my sales would be then? I have the details, and then this was just sort of little worksheet of additional information. Stories can call this sheet summary. Um, you know, I like to make this look nice again. We're start with a blank thing. I'm actually gonna give this one a head or something, like summary of monthly sales. Okay, I am going to figure back to home. I'm gonna bold it. Oops. Wrong. So I'm gonna bold it. I'm actually gonna make the front bigger. And the way you do that, you can use the up there on the down arrows. Let me just see that number's going big. Or you could just drop this down and and choose. But there we go. That's a nice size. So now this is a little bit subjective. I'm going to do it the way I would look at the data But you could certainly build this to, you know, encompass the data. Anyway, you prefer to look at it. Maybe you'd like to look at your weekly sales or your sales by item, etcetera. Um, you know, maybe you have very specific items that you sell yourself five specific items and you want to track your sales by item each month or every week. You know, there's so many different ways to do this. I'm gonna build this just from Ah, I just want to know what my overall sales are. And then maybe I'll show you how I might lay out, you know, looking at a different metric as well. So, first of all, we're gonna ever months, probably under this by the year. And I'm just starting out here, we can relocate stuff later. Um, we kind of said this was our first items were in January here, if you recall, um, Willie at one. And then we kind of had a bunch of February stuff, so I'm just assume this is a year. So I'm just going to Jan, and maybe you dio you couldn't put January 18 if you want, and then you could go across that'll be now, I don't think it's gonna work to copy and try to fill it. So I'd have to manually type all these. Well, let's just do a few, I think. Especially since we don't even have data like beyond February a march I'll put in April for fun. But you get the idea so you could do this out the whole way. Um, I might put in a total, actually. Just do the quarters. That's just three months, and I have put total. So you know me. I like to center things like the bolting. So I'm gonna center this really quick. I wanna bold it. So what do we want to track? So, you know, the sky's the limit. Honestly, we could track just total sale. We're gonna say, What's our total? Um, you know are told amount sold, plus shipping less. The total cost equals profit. I want to start with that. You know, we can put all kinds of information on here, so I'm gonna put total sales total costs profit. Okay. Gonna make this a little bit bigger. I'm actually gonna move this stuff over here. Just I highlighted and hit control X is to cut. I'm gonna arrow over and hit control V to paste. It gives us more free space here to work with. If we want to do something cool, Double click here is to make those a bit bigger. All right, Um, first of all, I'm gonna This will be a total. So I'm just gonna put a little line here and the when I like to use for grand totals as the top and double bottom border. And then as well, this will be our total on the left. I'm gonna put a little vertical line in there just to separate it from. So there's the left border separated from the data. And then honestly, while we're at it, why not? Let's just put a bottom border on this. There we go. Have ourselves a nice little table. OK, so total sales. So how do we get that information now? There's several ways you could link this all up by formula and, like, complex, relatively complicated formulas and say, you know, if a sale happened in January, um, include that number here and added to all the other numbers that happened January, Um, those tend to break, especially start inserting different rows and change things. So I would Honestly, what I would do is at the end of January, I would run a little report. I would come over here, run my filter, only look at items that sold in January, and that's what you have to decide to its is based on. When you bought the item when you sold it, I would say when you sold it, not even ship, just the date it sold. So, um, for us, let's say we just want January's. Let's get rid of all this stuff in just January. There we go. One item so I'd be so I would just look at this. The end of January. I run my little report, I'd say. Okay, we sold for R. We sold $31. It costs us 18 31. Another trick. If you hold down control and press page up, page down, it moves between the tab, so I tend to do that a lot. It's a quick way. So we sold 31 then we had constant 18.31. Oops. Now so what's our profit? It's equals this. Subtract this 12 69 and we see that? Our inventory sheet, in this case, we only have one item, so I was fairly obvious. But let him know, let's do February, and then we're gonna form at this thing. So let's go back to where do we filter this? Well, let's go across. And if you remember, just look for the one that has a filter on it right here. Easy to see. Let's get rid of January. Let's to February. Okay, This is everything in February. Now, remember to say we had some things that we, you know, listed in set February sold in February, etcetera. Um, since we've filtered on February, it's only gonna have ones that actually have data in here. So this is exactly what we want. Now we have a lot of numbers. Now I'm gonna warranty of something. Um, if you were to run a formula down here and just said, you know, equals some of, you know, this entire column The problem is, there's some hidden rose on their um, so we don't want that. Especially if you had your data sorted in a weird way. You know, you have a bunch of hidden rose and is gonna grab those, though, for the total. What it won't do, though, give you another little trick. There's a couple ways you could do this. You could copy this data to an additional spreadsheet and just paste this data. Or if you highlight stuff. So like, here, if you look down here at the bottom, it will give you some data, average count and some. So there's your some right there. 3 27 Nice and easy. So we know our total sales was 3 27 it's gonna pop over here and take that in. Let's do the same for our cost. 1 1907 Perfect. Um, I will show you the other way. If you want to see you just want to work with this data really quickly. You could just copy this. So if you highlight it, hit, copy, create, like a blank workbook or blank tab. I mean, paste it here. There you go. It just pays those. And you already know that this was already filters. This is only the February items. There's are 1 90 there's are 3 27 So I'm gonna delete this tab s a couple different ways. T to go about that. I like just working within the sheet, Especially since it's fairly quick and easy. And you could just jot those numbers down to say you just write that number down 3 to 27. Highlight the next one, uh, 1 90 then come over here and answer them. Okay. We need our same formula. We knew that formula all the way across. Honestly. So what we're gonna do is copy this. Now, I'm gonna show you a trick. We don't want to lose our formatting because we can have a unique formatting here if you got a paste and click on the drop down box one of these options of paste formula. So it's only gonna pace the formula, not the formatting as well. And last thing we're gonna hear super quick for wind this video, we're gonna format this with dollar science. So let's do that. And I noticed, for some reason, did get rid of that line. Not quite sure why, but it's a quick fix. Let's just do that. Okay, so now we have our profit. That's in this video. Um Then let's create another charger to, um then really think about this. So what are we actually gonna do with all this data? 15. 038ITIE Section 04b Summary Tab Profit by Website: All right. So what's next for us? While you can imagine, First of all, you had entire years of data here. You can really track your profit by each each month. Um, you know, we cut it off at the quarter, but you could certainly have each year. So I think that's definitely in and of itself, useful information. So let's see, What else would I want to see? Let's just go back here and look, I'm going to get rid of that filter. Wherever it was, there it was right here, was gonna select all so you can see everything. So, you know, in our example, we sell quite a few different times, and we decided we just buy buy stuff. That's a good deal. So I don't really want to track my sales by item just because we it changes, You know, maybe next month we don't even find Nike cleats for sales. So, um, maybe though I want to track my profit based on, um, you know where I'm listing the items, so I think that be really useful information, so it's going to take a little bit of work, but I'm going to show you how to do it, and then you could apply it to anything. You could apply the same logic than to where you purchased it. Or you know, the category. We don't have it on here, but if you had category like shoes, electron, ICS, etcetera Um, let's I think there's a worthwhile exercise. So we're gonna track our sales, um, over time, based on where we sell it and just see what kind of profits we have. So I'm really curious about that, so let's just do it down here. So we're gonna go with the same three months. I'm actually just gonna copy these right here. Put it here. Now, I'm gonna put each of the sites. So we said we sell on eBay, Amazon Craigslist, and I forget where else? Let's see. That might be it, actually, yeah, it was just those three. Okay, so no problem. That's not a big deal. All right? So, again, we're gonna and so we just want our prophet. Um, actually, do we just want a profit or do we want to calculate already? I think we just want a profit. We want to see where the big profitable areas are, and then we want to see is Well, let's think about this. Is that what we want to dio? Let's do that. Um, and then you can kind of cut it up any way you like. So how about that? So let's just do that. Um, we're ultimately gonna go, ah, profit profit, profit by month, and then we can see. Okay, eBay. We get the bulk of our sales etcetera, or whatever. It ISS. Um, so it will be a total profit. Let's put in our our fancy line double line again, put in a vertical line, and I know I'm going through some of the stuff fast. Guys, I just, uh you know, I don't want to bore you with, you know, each every individual step. You know, if you're not, you could positivity on run back and quickly see what I'm doing. One thing we forgot to do up here is a total across. I'm just gonna do that really quick. I'm gonna write it out for you equal some open bracket. I'm gonna scroll over. Hold down shift highlight. Closed my bracket, and that's it. I'm going to copy this here. There you go. And then so that's total profit or total sales total cost profit. And that should also equal to some of these two, which it does, which we can see down here. All right, so we're gonna have a similar formulas here, So let's just put in formulas before you even bother putting in numbers, equal some thes three, and then we're gonna Oops. Copy that. Now, remember, we can't You can do this corner formula either up or down, or I mean upper across. Let's do this. Um, so, yeah, you can add up these three. Or you could just go this way. Um, let's just say you're gonna add up these coca. Ah, well, format this to be all dollar signs. We like those. And then we want this to be the profit this way. So quick. Quick. I just went equal. Some those and then copied across it automatically figured that out now. So this is where we have to, you know, again, do are sort of manual work, So we need a couple of things. Now. We remember we need sales by January. Then we have to break it out by you know, the different sites that we sell on now, there's something called pivot tables which would help you with this, but I don't want to confuse you with that. So, um, for now, I'm just gonna show you how to do it this way. It maybe it takes a little, like, slightly bit longer, but not too much. But it's a more simpler way than trying to work in a pivot. So first of all, we need dates sold. So we just want to see January 1st of all, let's get rid of all these hit January and then Then we would filter by wear listed. But in this case, there's only one. It was only eBay. So let's just copy this information over here. We sold things for 31. We paid 18. 31. It's that one sale we had. So, um, and actually, I keep forgetting we're only gonna track profit here. So profit Waas 12 69. Here it was zero hero. And hear what? You know what we need to do? We need to put in a fancy had, like a label, if you will. So summary of monthly sales. This one's gonna be, um, profit by website and months. I mean, we'll just save my website. All right. Perfect. And actually gonna drop this down just so that the labels air right above the tables. So now we know March. There's nothing yet. We haven't got it. You leave it blank or enter zeros. February will Really interesting once. Let's do this. Let's go back to our date filter. We want February, not January. Okay, so now we have all the different places we listed. So now we're just gonna have to apply a second filter. So let's just see what we sold on eBay first. Okay, Come across our total profits. All right, here we go. 79 62 79.62. Now, let's get that for Amazon again. That's a little bit of monkey work, guys. I know, but, um, it's not too too bad in the end, and I think it's worthwhile information. Honestly, I think once you really figure out you key in on what means the most for your business. Uh, this will really be valuable. Uh, 39 32 and just honestly, actually do very similar sort of exercise for my online courses. You know, I look at all my courses. I look at each month I look and see where they're where they're selling, how my students air signing up all of that. It's really great information. I love analyzing it. Okay. And then Craigslist is our last one. Yeah. These 2 17 99 was our prophet. Okay, so now we have a nice little report. Um, one thing we see, our totals air the same, Which is important if these were different. So 1 36 year, 1 36 There they were different. That would be a problem. We obviously did something wrong. Um, so now we get to see Okay. Hey, you know what? We're making a lot of our profit on eBay. Um, you know, a decent Amazon. Not so much on craigslist. So then you can start to make business decisions. Should, you know, do we bother to keep going? Craigslist, Maybe in your head. You realize you know what? Craigslist is actually a lot more work. I have to go meet the person. Um, you know, there's no shipping, or maybe I still shifted, and I think we put in shipping, but typically would just meet them locally. So you know what? That's too much work. Let's just focus on, you know, the online site. So that's how you use us to make business decisions. Another just some ideas and actually about list out some ideas here for you, and I'll leave them on here. Um, let's just put ideas. Um, you could do sale arm number of sales number, number of items sold by, um, sort of selling website location, you know. And you I'm gonna un bold that it decided because we format it. Let's see, we want un bold. That doesn't need to be in the town of hoops were on the wrong. Here we go, un bold it, and we're gonna just line it left. And actually, let's just put it here. Okay? So number of item sold. So then you get an idea you'd say, OK, you know. Hey, we sold one item here. Three here for here. Well, if we sold for here, we only made $17 then it definitely isn't worth that. We would need to focus on these other sites. Um, you could Certainly. What else would you want to see? I would want to maybe see my profit by where I'm buying it. I think I'm gonna take this filter off, since we're kind of done with that. Select our loops. And then we had our memory. We had our other filter on. That's why we've got to get them all. There we go. I would be curious to see my my profit by where I'm purchasing stuff so profit by where items are purchased, What else might we want to look at? Um, category, profit by category, Prompted by category Note. That category isn't a column in the current workbook, but could be so again, I didn't include a category that said, you know, shoes, um, dog supplies, electron ICS. But if you did that, then you could run your profitability by category. Um, certainly anything by month. That's typically, I wouldn't worry about a thing like by shipping place. Um, you know, I would also then maybe just do a quick analysis sometimes and go. Um, you know, maybe I would just copy all this data into a blank spreadsheet and go, you know, which I know is that I lose on shipping on then, you know, run an analysis that way as well. I think that's it. I mean, in terms I mean, we could certainly build on these, But I want I want to leave these to you to determine what's best for you. Um, I kind of want a railroad people into it. And really, Honestly, there's a 1,000,000 different ways we could look at the data. Um, but just to give you just again those highlights definitely look at profit Billy items. And and sometimes I do like to look at the number of items. Really Get a sense. Um, I'm gonna leave you. Actually, we're gonna cut this video offering and come back and do one more calculation for you just to show you profit percentages on then that will probably probably it for our summary tab. 16. 038ITIE Section 04c Review of Summary Tab and Addl Ideas: Alright, guys. So one other thing I just kind of want to look at. So, um, let's go. So we have this. I'm gonna actually, what I'm gonna do, I'm just gonna put it over here. So I'm gonna move this just over to the left a little bit, and then we put profit percentage, um, so profit percentage hoops, and then we're also gonna look at profit percent. I'm also gonna move this down one just toe Or maybe you in twos That kind of get it out of the way. Profit percentage. So what I want to see is how much like how profit. I really like this Divided by revenues. That's not as easy as this. But how profitable are we? Actually, at the end of the day, and then I'm gonna do it for the same thing. Um, over here is a grand total. Actually, here it would be, um, actually don't need it here on the right. Sorry, I messed that up. So it's a simple as our prophet, divided by which is a ford slash our sales. Now, this will be a percentage, but let's copy it across first and now I'm gonna make it a percentage which is here in our formatting toolbar. There we go. So this is zero because there's no number. So pay 41% profit emergence. 42% here, 42% overall for the quarter. Perfect. So I want to know, you know, for every dollar, you know that I'm make that I'm selling. How much of that? Um, I actually keeping at the end of the day. You know, after you subtract all your costs and the shipping that's out, etcetera. So we're keeping 40%. Why is that useful one? You know, the bigger the number the better. And two, it's really useful for forecasting. So then you could say so Stay down the road. You have a goal and you say, You know what? Hey, we sold $327 here. I really want to ramp this up. I want to be selling, you know, $2000 a month at a minimum. Well, what does that look like for in terms of how much money you get to keep well, apply your profit percentages. You have 42% or 41% of 2000. It's about 800 bucks. Right. So there you go. Um, so you could really cock it. And he could reverse math it, too. If you say, Hey, I want to make, um yeah, to I want to actually make in profit $2000 every month. How much stuff do I have to sell? Well, you know, just you could do a quick calculation. I'm giving give it to you right here. So let's say we want to make 2000 profit. Um, give it a little format. So we know that for that 2000 is after that represents 40 2% of our sales. So we could divide this by point for too. And that will give us the number. It's a simple is that equals that divided by point. For two, we wouldn't need to sell roughly $4800 in goods. We would then have $2000 in profit at the end of the month. So there you go, guys. That's a useful. Just quick. Wasn't difficult to calculate, but really useful metric on what you can do. Um, this is where to if you really want to get fancy with things, so I'm gonna delete this out, You know, say you. You You start counting some average. Probably say Okay, you know what? We made 79 bucks here, and we sold three items. So on average, we make x amount per item. Well, how many items do have to sell in order to make $2000? I mean, it could be a simple is that again it will be again. You're working with, like, average numbers, so it's not gonna be precise, but it gives you a pretty good ballpark on where you need to hit, um, in order to reach the target that you want. So really, you know, use this spreadsheet to track everything Run your business day to day. Um, I know it's a lot of work to enter all this information, but I hopefully you're seeing now the secondary step where you start slicing and dicing the data and putting that to use you can really now run your business and use this as intelligence into what you're supposed to be doing. Um, static guys, let's cut this video often and come back. What's just so final wrap up? If there's any final points, I think about this, um, and we'll go from there and then you'll be able to download the spreadsheet as well 17. 038ITIE Section 05a Course Conclusion: All right, everybody. I think that's the course. I don't know what more I could show you. I mean, certainly there's a lot we could build, Um, a couple points. So, first of all, if you have any questions during the course, I hope you message me already. If you haven't send me a message, you have a question about a formula idea. It's something I clicked. Um, just point me in the right direction. I could let you know. Um, if you're building the spreadsheet yourself, you know things are broken. Let me know what's happening. Maybe I can help you fix it. Um, definitely used these ideas. Um, I'm going. So I'm gonna upload this spreadsheet. I'm gonna leave it as it is. The only difference is I'm gonna Let's just do it right now. I'm gonna copy this spreadsheet or this tab story, so I'm gonna give you one, and I'm gonna call it blank groups. Ah, there's only so much space you can put every tracking put. Call this blank. Um, I'll put this as an example, if you will. Okay, So here's your blank one. Gonna put it right here. This is the example that has the data. So the blank one. I'm just gonna delete out. Well, actually, no. What? We don't want to delete everything. I do want to leave in those formulas. Um, so I'm going to just get rid of this. You'll see. Those are all zeros. I'm gonna get rid of this. Okay, so there you have a nice little template to use. Now, um, that's your example. There's some additional category ideas you can certainly include. And then over here, just gonna shorten. Let's see where to go. This, um over here, The summary tab. I'm gonna leave this how it is. And then certainly you know how to just clear this out and then, you know, run the reports over here and include stuff. So Okay, guys, I think that's it. Again. Heading questions. Send me a message. I really enjoyed treatment teaching this class. I hope you you understand that just based on how excited I was to and maybe how fast that was talking. So I love building this type of stuff. So if you ever have a question again, reach out to me. You need help building something, let me know. Maybe I can help you out in some fashion. Um, I hope you found this useful. You can use it. Really appreciate. I love hearing your feedback. So if you can leave a review for the course, anything I can do for you to get those five star reviews, let me know if there's something I didn't do for you, that it would be more useful. Last last point. Check out my other courses. I've got a lot of different courses relate to entrepreneurship, finance, accounting, small business. You might find something else of value there, so really encourage you to just sort of click on my profile. Look at all the other courses that I offer and hopefully there's something there. And I could be your instructor yet again. So that's it for me guys again. I'm Chris Benjamin really, really enjoyed teaching this course. Good luck on your businesses. I love seeing entrepreneurs succeed and hope to be instructor on a future course.