Exactly.
I have no background in accounting, but it seems to me that the fact
that the "journal entries" can be stored along with the original
document makes it incredibly easy to audit and track the books.
This in turn is enabled by the schema-less nature of CouchDB and by
the fact that it makes it so easy to record data and images (the
original document as an _attachment for instance) together.
Happy to see that someone else is thinking along the same line.
Regards.
On 13/apr/09, at 18:29, Nicholas Orr wrote:
I've looked into doing my own accounting app as well. Sitting with an
accountant the main thing she had an issue with, in regard to all the
products currently available, is tracking what the amount is for on
each
side of the transaction.
Example, say I as an individual transfer $10K into a company I'm a
director
of. On the individual side (withdraw) of the transaction info needs
to be
recorded as one thing, then on the other side (deposit) different
information needs to be recorded. This whole transaction needs to
exist in
both places so come tax time the account doing the work for tax can
follow
everything simply.
The concept of schema-less documents now starts to shine as ideal. I
have a
few other projects on the go right now and will not be getting to
this one
anytime soon. Interested in what you guys come up with :)
Nick
On Tue, Apr 14, 2009 at 1:02 AM, Bruno Ronchetti <[email protected]
>wrote:
Hi Zhengji,
I am in fact working on something similar (think of it as a GnuCash
on
Couch).
So far I have tested the following concepts:
- storing the "accounting entries" as an array alongside the original
source document
- storing the "chart of accounts" in the same database as the source
documents (with a special _id)
- building a view that combines "chart of accounts" and "accounting
entries" together in order to obtain the "general ledger".
So far so good.
I am an absolute beginner (both with couch and the web) and I
haven't done
volume testing, but at the conceptual level CouchDB looks like a
very clean
and powerful solution for this class of problems, IMHO.
Regards.
On 13/apr/09, at 08:15, 厉正吉 wrote:
Hi all,
I wonder if I could make a browser based persional finance manager
with CouchDB as back-end database.
Is CouchDB suitable for this application?
