Keeping track of transactions

[col]

How do you keep track of the domains you buy/sell?
I've been using an Excel sheet since I started buying/selling domains. I've noted how much I've paid, parking/affiliate income and how much I've sold it for. At the start it was really smooth, but now the sheet is getting quite long...
I've planned to code my own little "bookkeeping" site in php/mysql, but before I start I though I'd just ask if there's already something like this out there?

 

[The Stealthy One]

You could setup an Access database to do this - that's what I've done.

 

[col]

You could setup an Access database to do this - that's what I've done.

Hmm.. yeah perhaps that's a good idea. I'm not that fond of Access, but it would take a lot less time. Thanks for the idea!

 

[The Stealthy One]

Of course, you could do the same thing with MySQL and PHP - it'd just be more work. At least with Access, you can set things up a little bit more quickly than with "command-line" SQL.

 

[mirrorcube]

Yeah I have gotten pretty creative with Excel, but thats my low tech preference.

 

[col]

Of course, you could do the same thing with MySQL and PHP - it'd just be more work. At least with Access, you can set things up a little bit more quickly than with "command-line" SQL.

I'm using a nice program called Navicat. Makes handling of the sql database really simple, but as you said... it'll take much more time to do it in php/mysql

Yeah I have gotten pretty creative with Excel, but thats my low tech preference.

Yeah, but it would be possible to get much better stats if you have it all in a database. Well, that is if you make a nice database design. My excel sheet is getting too wide and too long

 

[bobbarato]

I'm still at the spreadsheet stage. I started doing this when Regfly started getting flakey and domain names would not appear in my listings.

I back up the spreadsheet often and run it on a computer that is not on the network.

bb

 

[NewYorkBum]

How many of you here have MS Access installed ?
As far as i know that is not a part of Office Standard.

 

[col]

How many of you here have MS Access installed ?
As far as i know that is not a part of Office Standard.

It's in the professional version

 

[NewYorkBum]

The reason i asked that question is, MS Office Pro is not cheap. In any case, did you get my PM?

 

[col]

The reason i asked that question is, MS Office Pro is not cheap. In any case, did you get my PM?

I know, but you can get it a lot cheaper by buying a license for an older version on the 2nd hand market and then buy an upgrade. Or you could simply use an older version of Access. The one in Office 2k should be good enough.

I've replied to your PM.

 

[col]

After spending some hours with MS Access I remember why I haven't been using it for years... it's a big piece of crap! I'm usually a quite calm person, but after spending hours trying to get Access to do as I want it to I just feel the rage bubbling up inside me. I hate Access!
I think I'll spend some time on doing it with Ruby on Rails instead.

 

[Malaysia]

i just use excel simple n easy for me

 

[yandig]

I use Excel. I set up one tab for registrations, one tab for expirations, etc...
It works pretty well if you use the 'filter' and 'sort' commands.

 

[-Adam-]

I use excel as well. I keep track of names that are regged and where and names I would consider regging in the future.

 

[col]

I use Excel. I set up one tab for registrations, one tab for expirations, etc...
It works pretty well if you use the 'filter' and 'sort' commands.

Ok. At the moment I have all on the same tab, so it's just a long list of registrations, dropped and sold domains. I guess my options are to either structure it up a little, like you've done, or code a system that handles it for me.

 

[fonzie_007]

I use Excel.

 

[AzN]

I use excel but I'm still very unorganized.

 

[col]

I use excel but I'm still very unorganized.

I try to keep it all organized so I know what I'm doing. I like the feeling when you're in total control of what you're doing and feel that you have a complete view of it all.