Skip to main content

QuickBooks

Starting your own business makes you learn how to play many roles: project manager, consultant, marketing department, technical support, “executive”, and – worst of all – accountant.

I say that because I really, really, really hate accounting. Maybe I just had a bad experience in college, and could never really appreciate it. Perhaps I’m even a bit ignorant about it. In any case, there’s software out there to help someone like me. Right?

I bought QuickBooks based on several recommendations from co-workers. The folks at Intuit have done a tremendous job! That is, if their job was to create the most un-user friendly, non-intuitive, archaic piece of software.

I don’t even know where to start. They tried way too hard to over-engineer the UI. Everything is “cute”, with arrows, icons, and more reminders than I care to mention. In an attempt to account for every possible “use case”, they have created something that is far less usable than intended. All I need to do is send out invoices, write checks to myself and receive payments. And no matter how hard I try, it takes me longer to execute this process each time.

A lot can be learned from this when writing your own applications. Give the user what they typically expect, not what they may possibly want on a rainy Tuesday morning. Exceptions are just that: exceptions. Since they happen less frequently, they will warrant a little extra effort. But if the exception becomes the rule, then its time to re-design.

Steve Johnson from Pragmatic Marketing summed it up in a class which I took with him months back: “But what if the cat jumps on the keyboard? We have to account for that in the code!” You do not and should not.

Maybe there is room in the market for an HTML DB accounting package…

Comments

John Scott said…
I can certainly sympathise with your experiences, I've never been able to find an accounting package/system that suits my needs (and I've been looking for about the last 8 years!). Some of them come close, but seem horrendously complex and seem to rely on people using them "day in day out" rather than "every so often when I need to".

Ahhhh well, one day I'll also write an HTMLDB app to simplify my (accounting) life ;)
Scott said…
After about 1 hour, I finally ended up figuring out how to back out a payment. Of course, I had to restart Quicken for come reason in order for this to work.

I guess I now know how an beginner to Oracle feels... :)

- Scott -
John Scott said…
The situation is furthur complicated for me since I took the decision to Mac'ify (that should be a word!) myself after buying an Apple Powerbook a few months ago.

I can run about 95% of the applications that I need to under OSX but unfortunately the last 5% (such as a decent payroll application) I can't find good OSX versions for, so I'm forced to suffer the misery of using Microsoft Virtual PC (it's horrendously slow for me when compared to VMWare).
Colin Sheppard said…
Your experience is identical to mine. I have quickbooks and thought about making a HTML DB application too. What should I/we do?
Scott said…
Maybe read the QuickBooks manual. :)
Colin Sheppard said…
I thought you wanted to use HTML DB to make a 'simpler' interface than the one provided by Quickbooks? And that: "Maybe there is room in the market for an HTML DB accounting package…"
Scott said…
It's all about (lack of) time...

Sure, I'd love to build it in HTML DB, but I just don't have the time right now...

- Scott -
Colin Sheppard said…
I have noticed (based on a very brief search) this as a good discussion thread on the topic of Open Source Accounting Software:

http://www.jimohalloran.com/2004/04/22/open-source-accounting-apps/

What is interesting, is that some of the posters/users are looking beyond accounting and thinking about integration or features that lead into ERP, CRM, SCM, etc.

Would it be good to suggest to Oracle that they sponsor an Open Source project, using HTML DB, for this purpose? I think it would do wonders to get HTML DB beyond the Spreadsheet, MS Access conversion, Web enablement of a Oracle Database scope. I feel that HTML DB is too much 'vanilla' in its current form mand needs some good applications ('content' to use the term loosely) to compliment its Oracle XE and Raptor initiatives.
Scott said…
Would it be good to suggest to Oracle that they sponsor an Open Source project, using HTML DB, for this purpose?

Good luck with that.

I think it would do wonders to get HTML DB beyond the Spreadsheet, MS Access conversion, Web enablement of a Oracle Database scope. I feel that HTML DB is too much 'vanilla' in its current form mand needs some good applications ('content' to use the term loosely) to compliment its Oracle XE and Raptor initiatives.

I think if you take a look at what people are doing with HTML DB, it's not all MS Access & Excel conversions. I've seen a tremendously wide range of applications out there - from the very simple to the extremely complex.

Sure, it would help if there was some sort of COTS-type application built in HTML DB, but I don't believe that this is a requirement for the overall success of the product. It was designed to make web development easier - and thus far, has been tremendously successful in doing so.

Thanks,

- Scott -
Scott Horowitz said…
Hey Scott, I designed some HTMLDB Accounting stuff. I've been looking at integrating it with quickbooks, since my company has been using quickbooks before we designed the database, but alas, have had little luck. We do both accounts payable, and accounts receivable in HTMLDB, print up invoices and billing statements, and then enter them into quickbooks, and print the checks from quickbooks.

-Scott
Scott said…
Scott,

Interesting...

I imagine that if you own the code, you can adapt it to your processes, chart of accounts, etc.

Making it more generic may be a challenge, don't you think?

Thanks,

- Scott -
John Scott said…
I agree, making something like that application generic enough (for example) to handle the UK VAT laws would be extremely challenging. You would have to either put in all the localization logic yourself, or rely on the end-user entering all the parameters themselves (tax year end dates, tax rates etc), which also puts the burden onto them to "get it right".

Don't get me wrong however, I'd love to be using an HTMLDB based accounting package.
Doug Gault said…
On the topic of good UI Design, check out the books:

User Interface Design for Programmers
by Joel Spolsky

Don't Make Me Think
by Steve Krug

BOTH applicable to HTML-DB applications!
Scott Horowitz said…
I actually just found out that the latest version of Quickbooks has a native ODBC driver, which should allow Oracle connectivity. Once we get our hands on the upgrade, I'm going to work on getting it set up so my database can write directly to quickbooks for invoicing and billing.
Scott said…
I actually just found out that the latest version of Quickbooks has a native ODBC driver, which should allow Oracle connectivity.

Very interesting. I'm finding that I need to track time differently for each client (not a surprise), and this points more and more to an ApEx solution. Also, for Requirements tracking, I am in the process of building something as well.

Unfortunately, QuickBooks is still a necessary evil, as it still makes a good repository for invoices & tax data.

- Scott -
Scott Horowitz said…
All of our AR and AP is order based, and the DB tracks it. The check writing and tax info is done through QB (though I think Oracle has some software similar to QB, not 100% sure). So, When bills (for payable) or invoices (for receivable) are generated, we should be able to populate the amounts right into quickbooks. I need to play around with it before I'm 100% sure though.
Scott said…
Please keep me posted as to your progress, and I'd be interested to hear if you can make it all work. Best of luck!

- Scott -
Anonymous said…
So what ever came of this? I need to do some time acounting and billing.
Dashboards said…
Hi,
Would it be possible to review the Quickbooks Dashboard and share your opinion

I think this would be a very useful tool for Quickbook users and can save them lot of time from running various reports

Thanks and Regards
Nilesh
http://www.infocaptor.com
(PS: I am also an ex-oracle :) )
Scott said…
Nilesh,

Unfortunately for you, I run Quickbooks on a Mac, so I cannot install your product. It does look interesting, and should you ever release a Mac version, please keep me posted.

Thanks,

- Scott -

Popular posts from this blog

Thanks, ODC (Oracle Developer Community)!

I owe a lot of thanks to the ODC - which stands for Oracle Developer Community.  What is ODC?  You may remember it as OTN, or the Oracle Technology Network.  Same people, different name.  Why they changed it I can't say.  People just liked it better that way... (love that song)

In any case, what am I thankful for?  A lot.  To start, the tools that I use day in and day out: SQL Developer, ORDS, Oracle Data Modeler, SQLcl and - of course - APEX.  Without these tools, I'm likely on a completely different career path, perhaps even one that aligns more closely with my degree in television management.

While the tools are great, it's really the people that make up the community that make ODC stand out. From the folks who run ODC and the Oracle ACE program to the developers and product managers who are behind the awesome tools, the ODC community is one of, if not the greatest asset of being involved with Oracle's products.

If you have yet to get more involved with this communi…

Spaced Out

A while back, I wrote about how to give the Universal Theme a face lift.  If you follow the steps in that post, the base font for an APEX application with the Universal Theme can easily be changed.

While that's all well and good, sometimes you only want to change the font for a report, not the entire page.  One of the applications that I'm building contains a number of IRs based mostly on log data.  Thus, having that data in a monospaced font would make it a whole lot easier to read.

You can search Google Fonts for monospaced fonts by selecting only that option on the right-side menubar.  You can also opt for the standard yet kinda boring Courier and achieve the same thing.

To implement this in your application, follow the steps in my other post, but stop shy of the final step.  Instead of pasting in the text that I specify, paste in the following to the Custom CSS field in Theme Roller, using the name of the font you selected for the font-family:

.a-IRR-table tr td { font-fam…

Whose Deck is it Anyways?

This year at KScope, we're going to try something new.  And fun.  And funny to watch - we hope.  It's called "Whose Deck is it Anyways?", and will occur on Sunday at 8:30pm.  It's only 30 minutes, but it will likely be the best 30 minutes of the conference.  Or at least the most embarrassing.

Here's what we're going to do: the will be four 5-minute presentations - one on each of the following: BI, EPM, Database & APEX.

Sound interesting?  Probably not.  We get that, too.  So here's what we did.

Each 5-minute session will be presented by a non-expert.  For example, it's highly likely that I'll be presenting on BI or EPM.

To make it even better, each slide deck will be prepared by the corresponding expert.  So again, it's highly likely that my slide deck's creator will be either Stewart Bryson or Edward Roske.  If nothing else, this session will be a crash course in how not to make cohesive, easy to read slides.

Interested now?  Ya,…