Help Required for accounting like database design

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

Help Required for accounting like database design

Author

Topic

muzaffar_ali99
Starting Member

33 Posts

Posted - 2011-06-06 : 04:04:39

HI
I need help regarding designing a database i need to make a system in which "customer store their money with us for transferring to Pakistan or whenever they need it they draw out or some time they again added with us ,so in each client record in and out are continuing like a bank"
some type of accounting database is involved in it below given is general entry they do against each user please help

Date Day Time Description OR Detail Debit Credit Amount
May 7 sunday 2/23 Total ammount with us 19222 19222
May 10 Tuesday 1/33 added 11255 11255 30477
May 17 sunday 1/44 -15050 -15050aed 15427

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-06-06 : 06:41:13

If it's real money we're talking about and you have no clue then you should really give the task to someone else. Or is this a homework question?

- Lumbago
My blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/

muzaffar_ali99
Starting Member

33 Posts

Posted - 2011-06-06 : 07:51:40

ok sorry for too short description.

Here is my idea please modify it if needed.

Account table
Account ID Name
1 Cash
2 ABC
3 XYZ

AccountType
ID Type
1 Dr
2 Cr

Transactions
TrID Date Description
1 6/6/2011 Cash Deposit

CashEntries
CashID AccountID AccountTypeID TRID Amount Description
1 1 1 1 400 Money taken from abc
2 2 2 2 -400 ABC deposited money

Here is my look to that system please guide me if possible

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-06-06 : 08:06:37

Add a "Balance"-column to the account table and merge the cashentries and the transactions table stogether and simply name it transactions. You'll also need timetsmp-columns on all tables to keep track of then things happened.

- Lumbago
My blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/

muzaffar_ali99
Starting Member

33 Posts

Posted - 2011-06-06 : 08:24:36

@Lumbago

thanks for your prompt reply and help i got the idea of flow and will modify tables accordingly.

SQL TEAM has always been helpful.
thanks
Muzaffar Ali

fdtoo
Starting Member

28 Posts

Posted - 2011-06-07 : 08:30:47

Try downloading ebook accounting database design, it gives you some ideas on the banking modules and table design

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2011-06-07 : 11:54:12

How about Customer - Address..., AccountID

Or Customer/Company can have several accounts is better:

CustomerAccounts - CustomerID, AccountID

muzaffar_ali99
Starting Member

33 Posts

Posted - 2011-06-09 : 02:55:16

@fdtoo

From where i can download e book?

thanks

muzaffar_ali99
Starting Member

33 Posts

Posted - 2011-06-09 : 02:55:56

@denis_the_thief

hmm thanks for the idea.

fdtoo
Starting Member

28 Posts

Posted - 2011-06-09 : 08:49:02

There are many books that touches on accounting information system, you just need to pick one and try understanding the concepts. One particular book i came across, is being hosted from a site called accountingdes.com and it seems to have some chapters that touches on customer and banking modules design. Try it out.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources