|
|
If your idea and code is the core of the product, accounting is the core of the business.
Its the only way that one can empirically evaluate the value of your work. If your total sales end up being less than the cost of your labour plus expenses plus taxes, then your business is unprofitable, and the time is better spent doing something else.
Its that simple.
Its simple math -- except there is human nature to contend with. There's a natural desire to not want to address all the little bits and pieces that don't fit our vision of a profitable company: we stop accounting for our time (first mistake) don't account for the extra hours doing all nighters, don't account for the computers, etc. Next thing you know, a completly self delusional person who wants to believe they are running a profitable company is marking down negative expenses, and calling sales profit.
Accounting packages keep people honest. They make it easier to plug in the numbers required to make informed analysis, and they make it harder to relabel expenses as anything else but expenses.
For that simple reason, I'm always looking around for an accounting package that will handle as many of the following features as possible:
Raw Basics:
- General Ledger: this is the core of accounting (accounts and moving around money from one to another)
- Accounts Payable: You need a way to track invoices from vendors, and payments due, when, so that you budget.
- Accounts Receivable: you need a way to track the invoices you've sent out: who owes you what, when, and who needs a reminder.
- Payroll: I know its a small startup, and you don't need a payroll system to pay your dog...but you need a system that can grow up to offer this when you get there.
- Inventory: Track stock and inventory levels (in the digital download era, ISV's have very little use for this, but worth knowing about).
- WhatIfs: When you start out, you have no rules cast in stone. Anything is possible. You have to think on your feet, and make whatifs (projections). There is no better tool than a spreadsheet for this (accounting systems are way too rigid). So you need to find a system that can export/import data to Excel (or other) quickly. It shouldn't be a chore.
Essential Features:
- Server based:
5 to 1 these days, you're working on a laptop. In this field, more like 10 to 1.
Do you really want to keep all your financials on it and risk the possibility of getting it left behind after a meeting with a prospective client, stolen from the back of your car, etc?
Didn't think so...
Whether hosted inhouse (freeAccounting.net), or by a service (eg: Xero.com), you want to have your data on a different computer.
Desired Features
- Database backend:
Its your accounting. Your money. The numbers should be in a backend storage system that is easily queryable so that you can generate webpages for your clients, etc. In other words, you want a DBMS backend rather than some quirky special in-mem file system (again: Quickbooks is a let down in this area).
- Import/Export to Excel easily:
Whatifs are essential decision making processes for startups. Some accounting packages provide budget analysis modules, but so far I've never seen one as flexible as Excel. Life only fits nice standard curves in fairy tales.
- Multiple Companies:
If entreneurship is in your blood, you probably won't stop at one creating one company. You'll try one or more different ones before you find the one best suited for you. And because you probably won't close one before you open the next one, they will overlap in time: wouldn't it be nice to be able to switch easily between companies to enter your daily expenses, without it taking a long time (hint to Quickbooks, grrr)
- Currency Settings:
Ten years ago, you could set up a software company in the US, and work with a market that was big enough by itself. Its a different world these days: you'll (hopefully) be selling to not only England (pounds) but Europe (Euros) and if you get a hang of designing interfaces that can be flipped left to right Asian and Arabic markets.
You may not be there yet, but it will happen faster than you think.
- Various Tax Systems:
If you are not an ISV, but more of a consultant, and you plan to travel around the world, offering your talents to the highest bidder, you will find that not all countries tax the same way...its helpful if your accounting system can handle such eventualities -- rather than having to pick up a secondary accounting system.
- Tax Modules:
Although NZ's tax system is just about the easiest in the world, some countries have a tax system that is a nightmare of complexity and ambiguity (cf: USA). A software that has settings that can be finessed for each country's tax structure is a bonus.
- Understandable by your Accountant:
Whatever system you use, if it isn't an online webservice, your accountant has to have the same software, and be proficient in it.
The more obscure your software choice, the less chance there is of you finding such an accountant.
If they don't have the software, you have to pay for them coming to your office. More time lost, more cost, etc.
- Web Access:
There was a time when the idea of saving your accounting data up in the cloud sounded dangerous. Not anymore: every time you check your bank balance online, you are trusting the current level of encryption -- so why not for the rest of your accounting?
If you can find a service with a good fast web interface...great.
- Easily Import/Export Time and Expenses:
My experience so far is that accounting software firms don't know how to make good time and expense collecting modules: they're concentrating so much on adding features to the main product, that they have a hard time remembering to be simple when it comes to a mobile app.
So you'll probably need a 3rd party application for these tasks, and therefore you'll need a very intutitive import and export features between the two apps, or your expenses will most often stay on your mobile phone, and your accounting will be incomplete.
- I'll be adding more to this list as I think of points, but in the meantime, any other essential ideas any of you can think of?
Some people say that they will never move their data out to the web, come hell or high water.
For these people, the following links could be useful.
Free Accounting Software
First of all, its not free. Its not expensive (about 30.00 per seat) but not free (
http://www.freeaccountingsoftware.net/qualifyinglinks.aspx) and I found that ...misleading.
Secondly, the installation package was expecting to work with MSDE rather than SQLServer Express(which in Aug2008 is now atleast 2 years out of date).
Third, the screen grabs look great -- but the installation needs some more work. I also wish it were generic SQL-92 based so that it could be ported to MySQL or other.
But the idea of server/client based architecture sure beats QuickBooks in that regard, so when they get that right, this could get interesting.
|
Microsoft Office Accounting
Pricing:199
As usual, probably less innovative than the market leaders, but better integrated with Office, and therefore Whatifs. This is not a negligeable point for a Startup.
"Microsoft Office Accounting Professional is recommended for small business users who demand tight integration with Microsoft Office applications such as Excel or Outlook's Business Contact Manager. Small businesses that process payroll in-house will find Peachtree or Quickbooks a better fit for their needs."
Review: http://taxes.about.com/od/businesstaxes/fr/MS_Accounting.htm
http://www.pcpro.co.uk/reviews/145206/microsoft-office-accounting-proexpress.html
Interesting:
http://cofes.com/Community/Blogs/tabid/272/EntryID/71/Default.aspx
|
MYOB
Review:http://www.pcpro.co.uk/reviews/107308/myob-accounting-16.html
|
PeachTree (Sage)
Price: about 259.
Definately a good comeback story (for a while there, they looked like they were going to fold in front of QuickBooks).
Pricing is better than QuickBooks, but there's the rub: in the US, most SBE accountants are used to working with Quickbooks...so to save 200 dollars, it may cost you much more to find an accountant that is comfortable on PeachTree.
In Europe or elsewhere, Sage is a venerable company, so it may be a lot easier (especially in the countries that Quickbooks pulled back out of due to no penetration, such as France).
|
QuickBooks Professional
Easily the easiest to use for an SBE...but their licensing system is so tight, its a real turn-off.
Secondly, I wish they would have a real DB backend and offer Client/Server architecture, rather than it all be proprietary.
They do have API's now, etc...but that doesn't help much when you are hosting your website.
|
QuickBooks Simple Start (free)
Finally they've made a free package...
Its sort of a light client, that strips out invoicing etc...and makes it only useful to add expenses, pay bills, etc. But it would work fine in some cases.
Still misses server/client functionality, and web site intergration...
|
Software that you can install on your own servers.
A lot of people are not yet comfortable hosting their financial data in the 'cloud'. (see note below on this), and/or want to keep their monthly expenses down.
For these people, the following links may lead to something useful.
NolaPro
PHP/MySQL solution.
I really wanted this one to work...but ran into too many glitches on their demo website to feel comfortable with investing more time.
Maybe you will have better luck. If so...let me know.
|
Online Accounting Services for a monthly fee.
Everytime you check your bank balance online, you're trusting SSL and other encryption technologies.
So it makes no sense to not trust these same secure encryption systems for your banking system, in return for ease.
Below the level of Accounting packages there's a whole category of bits and pieces...some are actually quite wonderfully designed.
For example, there are solutions for creating invoices on the fly, as well as recording expenses. The first (and possibly best in this category) that comes to mind is http://blinksale.com which does a wonderful job in this category.
But I don't recommend it: no matter how fast and easy it is to use. These types of solutions are wonderful at bringing in cash, especially if you havn't gotten around to choosing an accounting package and you already have a live client on the line, but because they don't have any means of analysing, reporting, etc. your income and your expenses, you are in essense making money, not making a business.
Another category of tools are the needed 3rd party Time and Expense applications.
Why its so hard to find a good easy solution that works well with any accounting system...beats me.
Personally, what I've been looking for is a solution that works on my mobile pc for freelance work
- imports client names from my accounting system
- imports item units (ie the types of Service times/units I sell)
- a one (1!!! with no popups) form, forward matching combo box driven input form with validators (ie impossible to log a task without a note)
- A timer...(or since PPC has funky threading issues a TimeStart, and TimeSinceStart)
For my expense, I want it even easier: a one form, forward matching combo driven form, with splits.
Is that so hard?!?
From the list below, it appears it is...
This category, the Billing/Invoicing Services excite me: they are generally well designed, with intuitive interfaces, and just are cool compared to their bigger brothers the old, stodgy desktop accounting packages.
But to stay lean and easy, they generally sacrifice analytics, categorization, etc.
In other words, just maybe this is ok for a Freelance Service provider, but (IMHO) these might be a little bit lite fore a mISV.
BlinkSale
Absolute Excellent hosted online Invoicing and Expense application.
Really well designed.
My only problem with it is that it is not a full accounting system...what do I do with the data I have entered?
|
CashBoard
Pricing: Free to 90/month.
What's good about this one is the Estimates package for sending out as many Estimates as needed to convert one into an Invoice.
Timer looks week, but ok.
Overall, looks pretty good for a freelancer.
|
FreshBooks
Pricing: Free then goes up to min #14/month.
- Easily create, send and manage invoices
- Track time and expenses (for you and staff)
- Send invoices by snail mail or email
- Accept payment with PayPal, Authorize.Net, & more
- Automatically send invoices & late payment notices
- Create robust reports and import/export your data
Looks great. But probably better suited for a Freelancer, rather than an ISV.
|
LessAccounting
Pricing: 19.95/month (as of Aug 08)
|
And then theres getting frustrated with everything out there and deciding to roll your own solution.
My first advice: its tempting, I know, but you should be going down this route -- atleast not when starting out on a new venture (use the energy to create your product, not your accounting system).
Active Data Online
Platform:.NET
Pricing: Unknown
This software's description (.NET 3.5, AJAX, etc.) looks interesting...but at the moment is marked "no longer for sale." Rats!
I'm keeping a link here in case it pops back on the radar.
|
Adapta Accounts
Language:Delphi
Pricing: Unknown
"AdaptAccounts client-side programming is implemented in CodeGear's Delphi -..."
|
Bravo Software
Language:Delphi
Pricing: None listed.
"Bravo was developed using Borland Delphi, the award winning 32-bit client/server application tool; the reports are written with Report Builder; and compatible database servers include Microsoft SQL, Oracle and open source Firebird."
So its not .NET, but if you like working in Delphi, its worth knowing about.
|
Cynics Software Accounting Source Code
Language:VB.Net
Pricing: $99 - $999.
"Award Winning". Rebrandable, etc.
Looks highly promising, except that it looks like it is geared towards the desktop only -- I would probably want to first rework the UI layer so that it is completely disconnected from Biz and Data layer, and then rebuild a web interface (see Composite Application Blocks or other solution). This is no quick task.
|
Integral Accounting Enterprise
Language: VB.NET (I think)
Pricing: $999 and $4999
"Integral Accounting Enterprise is multi-currency, multi-lingual, and supports various models of VAT Taxation that allow the software to be used globally!"
The pricing can get pretty steep for a startup, but maybe interesting way further down the line.
But they are web-based.
One interesting point is that they have spent time on the integration of web checkout sales with the accounting. (One less thing to spend time on...)
|
PC Skills (PCS Visual Basic Accounting System + Source Code)
Language: VB6
Pricing:US $2995.00
"PCS Accounting is sold with complete Visual Basic Source Code in one package. PCS Accounting was developed using Microsoft Visual Basic 6.0 Professional version, with minimal use of third party add-on components. The object-oriented, modular design and powerful transactions-based code makes modification and integration to other modules easier. "
Is it just me, or do you agree that spending time developing a new accounting system based on VB6 is a no-win situation?
Do as you wish. But worth knowing about.
|
TurboCash
Platform: Delphi
Cost: Free -- GPL
A very venerable package, but it doesn't look like its moving much...hopefully its still alive?
|
Finally, as I was looking around for these links, I came across this link:
http://www.vkinfotek.com/dnet.html
(Its a book to teach you C#...whose subtitle is:
'Secrets of Developing an Accounting Package using C#, Visual Basic 2005 revealed').....!
Seriously -- what I said above still counts: concentrate on your business, not writting a custom accounting package that will take you far away from your original business plan/goal.
http://www.time59.com/
$19.95 /year.
"Time and expense tracking, online invoicing, payment processing."
|
KeepTempo
By the same people who did BlinkSale so its really well designed.
I just wish I could see an EXPORT button...
|
SlimTimer
Excellent! And really free (for once).
|
TimeTrack Professional 3
Pricing:$49
A desktop app -- but with a twist.
"Timetrack automatically recorded how much time I used on Microsoft Word and Internet Explorer. It even able track the URL of the web-sites. With rules setup, it automatically categorize all these recorded time into categories that I have defined. It customizable view is even powerful, allow with to analyze my time in any hierarchical relationship I defined."
Hum. Big brother...but maybe useful.
|
XPert-Timer
Desktop app for offices -- with SqlServer backend. Wonderful interface.
Pricing: $99 - $2950
- well designed user interface
- networkable
- stopwatch
- export to excel and other formats
- etc...
|
Know of a great software that is not listed above? Know of one that is dead, dead, dead and should not be listed?
Have more tips on what to look for in an accounting package for an ISV, SMB/SME?
Then contact me so that I can add it to the page. I can be reached at:
comments at xact-solutions dot com.
|
|