Excel v. Quickbooks and my thoughts for SMB accounting

If you’re just starting off and you are just a sole proprietor, that does not have an LLC, S-Corp, or Corp (a business entity), then you probably don’t really need to use QuickBooks.  Stick with Excel.  You probably don’t have that much to deal with in expenses, accounts receivables, accounts payables, and most importantly payroll.  You can probably just track everything with one spreadsheet with multiple tabs.

However, once you start entering a stage where you need payroll, (where you pay yourself or other ppl), your totally and utterly fubar’d.  All of a sudden you need to constantly check your bank account balance and make sure you have the funds necessary to pay your taxes.  Scheduling the payments that you need to make for state and local taxes is an utter nightmare as well.  I tried doing this with excel for about 6 months, and ended up being late on payments, and never knowing how much I really had in my account.  QuickBooks helps with managing this chaos.   With its payroll features, it tells you when payments are due, what taxes you will owe and whens the best time to pay them.  In addition, with the payroll feature I can direct deposit my checks to myself and schedule out my payments.

The best feature I think, (which has been a life saver for me in this down economy) is tracking partial payments.  Several of my clients haven’t been able to pay full payments and i’ve been having to figure out what is owed to me.  With an excel spreadsheet, you need to be able to track your Net Accounts Receivables and what’s still owed.  This is no small feat for an excel spreadshee.  With QuickBooks, this is handled for you and you can also see all the receivables that have been over due for a month.

Finally, QuickBooks allows you to track time and create invoices.  Tracking time has been a great help to me to track my work on specific projects and determining whether or not I under bid or over bid my project.  I can run a report that shows me the extact time allocation per project for a specific period of time.  QuickBooks also allows this time to be added to an invoice, which you can print out as a pdf.  It even allows you to customize what the pdf looks like!

All in all, looking back I wish I used QuickBooks much earlier when I started my business.  It would have saved me a lot of heartache and pain.  I strongly recommend purchasing it, if you have a business entity.

Load Balancing using Amazon Webservices – Elastic Load Balancing

It’s really pretty simple to setup, i thought it’d be more of a challenge, but it wasn’t hard at all.  The major thing I had to change was setting up my sessions on jenniebot to be stored in the database rather than on the webserver.  This is pretty much the biggest thing you need to worry about.  It will add a greater strain on your database due to processing sessions via the db rather than the web server.

Ok, onto the technical stuff:

My resources for this are the tech docs located at:  http://docs.amazonwebservices.com/ElasticLoadBalancing/latest/DeveloperGuide/

I pretty much just followed the example line by line.

elb-create-lb jenniebotloadbalancer  –headers –listener “lb-port=80,instance-port=80,protocol=HTTP” –availability-zones us-east-1a

elb-configure-healthcheck  jenniebotloadbalancer  –headers –target “HTTP:80/ping” –interval 30 –timeout 3 –unhealthy-threshold 2 –healthy-threshold 2

elb-register-instances-with-lb jenniebotloadbalancer –headers –instances i-xxxxxx,i-xxxxxx

One thing to note that the documentation doesn’t tell you, is that you need to go do your dns provider and change your site’s www.xxxx.com and xxxx.com to reference the public loadbalancer name that amazon provides you when you startup your load balancer.

This could be really helpful when combined with the AutoScaling feature that Amazon offers.  I’d recommend building an Amazon Image after every deployment so that you can spawn that image and add it to the load balancing pool when necessary.  It’d be even better if you had a statically generated site with flat html that you could push using lighthttpd or some sort of setup like that.  Ok, enuff talking.. email me or drop a line in the comments if you have questions!

Have fun load balancing!

-d

truncate sql server logs

Been having a grand ol’ time with SQL Server 2005 lately.  We were making backup and backups off of a dev database and noticed all of our space was getting eaten up.  Took a look today and realized our transaction logs were 10GB. not good.  We change the restore type to simple and cleared out the transaction log with some help from the link below.

http://stackoverflow.com/questions/40402/what-is-the-command-to-truncate-a-sql-server-log-fil e

make sure to encapsulate the servername in brackets [ ] .

Google Comic-Con logo, and new iGoogle Comic themes

Maybe it’s the geek in me, actually, it definitely is the geek in me, but aren’t these new isn’t the google comic-con logo really cool???  And it’s done by my favorite Comic book artist of all time, Jim Lee!!!

Also, check out these igoogle themes too!

http://www.google.com/help/ig/comicsthemes/

They’ve got some really cool dc themes:  world of krypton (superman) , women of dc comics, blackest night (green lantern) and batman reborn!

iPhone development resources that i'm using

So I decided to start learning how to program iPhone applications and join in on the gold-rush.  First off, I have to say that learning iPhone development in your spare time is quite challenging.  I’m having a really hard time grasping the objective-c nomenclature, and since i’m not working with it for several hours a day, I forget the syntax and am disheartened when I pick it up again.  For some reason, brackets and the ‘sending messages’ concept isn’t sinking in.  Regardless, I decided to post some of the resources i’ve been tinkering with while learning.

- Appsamuck - a site that goes through 31 days of applications that feature different aspects of iPhone development

- O’reilly’s Iphone SDK Application Development – I’ve been using this more as my main resource, while doing the appsamuck stuff as ‘homework’.

- Developer.apple.com – duh.  You definitely need this site.

- The objective c programming reference – (google objective c reference) – This has been a great help, especially for me, not knowing anything about obj-c.  (Especially since i haven’t done c or c++ since college!)

- WordPress Iphone Application – a great way to just tinker with something that’s been already built and in use, especially if you’re looking for more of processing application than a game/visual app.

Well, that’s about all i’ve been doing for the last couple of days.  Hopefully, when I have some more time in august, i’ll start really sitting down and figuring out this iPhone stuff!

Update: http://cocoadevcentral.com/d/learn_objectivec/ – a Great objective-c primer