tags:

views:

549

answers:

1
Q: 

Database schema design for a double entry accounting system??

Does anybody know or have any links to websites describing details of how to design a database schema for a double entry accounting system ??.

I did find a bunch of articles but non were very explanatory enough. Would appreciate it if someone could help me on this.

+1  A: 

Here's one link that you may find helpful:

http://homepages.tcp.co.uk/~m-wigley/gc_wp_ded.html

Leslie  2010-03-22 17:31:28
i did read this one. but didnt actually know how to use it. Some sql examples would be icing on the cake :). thnx by the way
soden  2010-03-22 17:40:46
do you have an accounting background? I spent 10+ years in accounting and would hesitate to create an accounting package from scratch...the article linked above is a very good example of table setup and accounting processes. What kind of SQL examples would you like?
Leslie  2010-03-22 18:56:27
http://www.cuppadev.co.uk/dev/double-entry-accounting-in-rails/ this link does explain the same stuff. but im now sure how i am supposed to start building the database schema. i am well versed in RDBMS and some basic accounting which i learnt thorugh self study in the past few weeks. im just confused .id be nice if you could help me on this.
soden  2010-03-25 05:48:33

related questions

Good online resources for Microsoft Dynamics SL?
Average pricing implementation in a POS application?
Financial Account pattern implementation in Clojure: ref or agent?
Year end budget - what development software should be considered?
Calculate fiscal year in SQL Server
Informix: Fifo valuation with SQL/Stored procedures
How to integrate Java with Tally application
Sample Database Design for Financial Accounting
How to design a simple database for charitable donations in MS-Access?
4-4-5 Accounting Periods are the Bane of my Existence
Anyone got a nifty credit expiry algorithm?
Writing a web application in excel? Why not?
Financial tracking for software projects
How do people create re-usable databases?
What kind of database do product based accounting packages use?
How to record transactions for money flowing into an acounting system?
Rehash: Accounting Software Design Patterns
Building a rudimentary accounting app
Which open source database is the best option for an accounting-related system?
What technology should I use to create a distributed Accounting Software?
Accounting Software Design Patterns
PHP + Quickbooks integration (API)
Recommend open source accounting / erp?
Use Float or Decimal for Accounting Application Dollar Amount?
Integrating QuickBooks with your e-commerce site