When you are starting an eBay business, you will be acquiring a lot of inventory, and while you get this inventory, you should be keeping track of how much you paid for it and when you bought it. Then once your item sells, you should record what it sold for and the additional costs (shipping, fees, etc.).
But how should you keep track of that information? Pen and paper would definitely make it difficult, so I would recommend using software on either your computer or your mobile device. Luckily for you, I found a free solution for both, though I would highly recommend you keep track of it on a computer because not only is typing on a keyboard a lot easier, but computers also make organization a lot simpler and backing up your files way faster.
With that said, let’s get right into the first software, LibreOffice Suite.
Have you ever thought to yourself, “I would really love if Microsoft Office was free.”? Well it still isn’t, but this is the closest free software there is to it. LibreOffice is really awesome, especially taking into consideration its free price tag. It includes a lot of office software, but the one we will be looking into today is the Calc Spreadsheet.
Once you have LibreOffice installed, open it and you will see a sidebar and you just simply click Calc Spreadsheet, which will open up a blank spreadsheet. I have created a sample of what yours will look something like when it is done:
Enough messing around, let’s get going! First, you need to add the top bar (row 1). You can do this by clicking the A1 box and typing “Purchase”, clicking the B1 box and typing “Date of purchase”, and so on. Yours should look like this:
You may now be asking yourself, “Why isn’t all the text showing in the box?”, and the answer to that question is because you have to expand the row.
You can do this by clicking the border line between 2 of the letters and dragging it to the length of your liking. For instance, if you want to expand row A, you click the border line between row A and row B () and drag it where you want it. Once they are dragged to your desired length, your spreadsheet should look something like this:
This next step is optional, but it makes it way more efficient to enter dollar amounts. Click on the desired row, and it should highlight it, and then you click the little arrow next to the stack of coins ( ) and then click default. Repeat this for all the rows you want to add dollar amounts to (in this case, Cost, Sold for, Expenses, and Profit).
The final step is to enter all your inventory into it. This may take a lot of time, but it really helps you keep your business organized.
If you want to keep a database on your mobile device, I would recommend you to use the Microsoft Excel app.
Microsoft Excel Mobile App
If you were to use Microsoft Excel on your mobile device, it is absolutely free. Excel is one of the best ways to keep a database, and the mobile version is no exception. I won’t be going too much into detail about Excel, because I personally don’t use it, but here is a tutorial for those of you who want to.
I personally prefer using my computer to create my spreadsheets, but if you are always on the go, and you are pretty good at typing on your mobile device, then using Microsoft Excel is definitely the better choice for you.
Continue Your Database
If you followed through this post, you should have your spreadsheet all set up and you should be ready to continue to keep it up to date. One of the most important parts of having a business is definitely staying organized, and at times doing so can feel very tedious, but in the end, it will only help you and your business achieve success.
I am always here to help, and if you have any questions about anything explained in this article leave them in the comment section below.