[ale] OT - Billing software for small time web hosting company

James P. Kinney III jkinney at localnetsolutions.com
Thu Sep 2 15:29:34 EDT 2004


Cool! The billing/accounting app I use SQL-Ledger. It does loads of
stuff, but recurring billing is currently handled by outside scripting.

Post it up on Freshmeat (when they get back online --MySQL connection
error!) as there is bound to be a need for it.

On Thu, 2004-09-02 at 14:32, Nathan J. Underwood wrote:
> Ok, I was using a spreadsheet to track what domains we were hosting, who 
> the client (owner) was, what 'hosting package' they were using, when it 
> was due, etc., and it quickly got out of control.  If I didn't look at 
> the spreadsheet every day (we didn't think to setup billing cycles, so 
> we had customers that were due pretty much every day), I got behind.  I 
> went to freshmeat to try to find something that was free (we're in that 
> 'starving artist' phase of business right now), would keep track of who 
> we were hosting, when they signed up, when they were due, and how much 
> they owed up.  Also, I wanted it to email me when customers were $X days 
> out, so I could send them a net 30 invoice.  Long story short, couldn't 
> find anything, so I threw something together myself.  It's ugly, 
> undocumented, insecure, etc., but pretty straight forward.  If there's 
> anyone out there in a similar position (i.e. need something to track 
> billing, and remind you when to bill folks ahead of time), if you 
> promise not to laugh, I'll send it to you.  You pretty much just have to 
>   do the following to get it up and running:
>   - Create a database
>   - Add your user to the database
>   - add a 'use table;' statement to the top of the .sql file
>   - run mysql < file.sql -u -p
>   - unzip the files in a directory that your webserver can see
> 
> Again, I wouldn't use it anywhere that someone wearing a darker hat than 
> you could get to it, but it works, and is helping me to keep my sanity. 
>   If you're interested, shoot me an email and I can email it to you. 
> The whole thing (zipped) is only around 56k.
> 
> If this is the wrong place to stick this, my apologies.  I just know 
> that there are some other folks doing web hosting, and I wasn't sure if 
> they were having the same problem.
> --
> registered linux user # 73046
> 
> 
> !DSPAM:41376769207616452218072!
> 
> ______________________________________________________________________
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
> 
> !DSPAM:41376769207616452218072!
-- 
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
http://www.localnetsolutions.com

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jkinney at localnetsolutions.com>
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part




More information about the Ale mailing list