I am either going to have my Excel spreadsheet rebuilt or build an "inventory tracking" system myself. How I have it now, it's just not the
best solution. I have been looking into accounting/inventory software such as Sage 50, which can accomplish much more (that can also be helpful with taxes).
I want to track each item differently with pretty much how
@ealfert has it in one spreadsheet and multiple sheets. But, with so many platforms and copy/pasting into let's say Parking A, Parking B, Parking C, etc. each month or year isn't a good solution since they differ in formatting.
Multiple entries are also needed with 1 domain name as I renew it and multiple entries for 1 domain name each month for parking revenue. It's getting to the point where Excel is not a viable solution anymore.
I want a final page that shows me everything summed up: owned, sold, purchased, revenue, profit in graphs and whatnot. I'm sure it's doable in Excel, but each parking platform has its own way to export a domain's earnings, so it's harder to keep on 1 sheet and add it up for the passive revenue stream.
Also locating that domain and knowing exactly how much I paid for it, where I got it, who I got it from, how much I paid in a transfer, how much I paid in a renewal, etc. would be nice for many reasons (even as far as tracking which coupon code I used). Right now, I can get most of the data I want, but it takes a little more time as I add in new fields I want to track and they are spread out.
As you show the logo, I want to track the creator as well as price and a roundabout time vested in it to calculate how much time I spent dealing with the creator for revisions, etc. to factor my self-value into the entire picture. This would show me how much I paid for the logo. If the logo so happened to be IP of someone else, now I know who not to order from, how much to write off as a loss and then order a new logo to replace it from someone else.
If you're not doing this for an entire column, you're wasting valuable time typing in TLD's:
Code:
=RIGHT(CELL,LEN(CELL)-SEARCH(".",CELL,1))
Excel is powerful, but I want more details for each domain with a click.
I believe you're on the right track with how you're tracking your purchases/sales. There will be no surprises like, "What's this [PAYPAL *SOMEUSER] purchase in the amount of $842.48 for in my bank?". Being able to pull that exact amount up and reference the transaction IDs would alleviate if my credit/check cards were compromised (it's happened due to a skimmer before, not a nightmare, but the more proof you give them up front... the quicker the case is "resolved" [even though I get my 'money back' in 24 hours, it's still not mine until the case is closed and won, which has been pretty much every time... more of an interest free loan]).
Nice setup you got going on, but I need to factor in parking revenue across multiple platforms to take that into consideration as well as my time put in transferring it, etc. to know how much of an ROI I got on the name to almost the penny.
I've got it down pretty good, but need a little more.
