Double Entry Accounting DB...

[CEH]

I'm looking for someone who knows a bit about this one... maybe done one before. I've started a DB for an accounting system, I've worked with MANY of these over the years, but from a user standpoint. Now I'm trying a shot at putting one together, just for a learning experience if nothing else. But I would like someone to take a look at the beginning structure of the DB and let me know if I am on the right track. Any input and suggestions would be helpful and appreciated. Keep in mind there is ALOT not here yet... and some loose tables for future expansion. I didn't want to get too deep into it and find out I need to make a major change. I'll post the DB.
Thanks
Curtis

 

[neileg]

Not sure what the distribution is for. Is that what I would call analysis? You have the DistributionID in tblTransaction and the TransactionID in tblDistribution. You only need one of these, not both.

You don’t need tblTransType twice in the Relationship diagram.

Your set up will only allow one job number per account. Is that right? I don’t understand the relationship between accounts and jobs.

You have miss spelled account in tblAcctType!

What is AccountAmount in tblAccount?

You have based your forms on tables. It is better to base them on queries even if, for now, the queries simply return all the records.

Although you talk about double entry, this is single entry! Do you intend to have corresponding +ve and –ve entries? The alternative is to have both a debit and credit code on each transaction.

 

[CEH]

Well..........

First I am unsure of how to set this up.... So the AccountAmount in tblacount would be the check amount. In the distribution would be the offset amount. This would be your debit and credit. The idea was to have the form coded so the AccountAmount and distribution amount had to equal zero. And "One job number per account". No. If you have an entry... Say 150. for a Check. In the distribution you can enter as many lines as you need to split the entry between expenses,assets, liabilities...(the debit to your "check" credit) whatever called for. You simply need a new line to apply to a different job Number. ie..... acct 6000, job 10101, $50. and next line acct 6000, job 10102, $100.
I don't understand your "+ve and -ve".
My problem is I have never been able to pull apart a double entry system to see the common and best ways to do it..... Any suggestion would be helpful.

Thanks

 

[MacFil]

Bank reconciliation

You will have to include a table for your bank reconciliation.
Will you be using your db to include payroll?
Will you be using your db to keep trak of your tax?

J.P.

 

[CEH]

Who knows

Bank rec's... I might get into...... Payroll and taxes I doubt it. But like I said... I'm using this project as a learning tool. I've dealt with accounting DB,s for many,many years, but from a user side. So I thought it was time to learn how to build one. But my first goal is just learning the best way to get it started. You might know alot of accounting systems are designed in modules... AR..AP...Payroll........... We'll see were it goes. Like I say.... Any suggestions would be helpful.
Thanks

AND......... If anyone knows of any good tutorials on Accounting systems in MS Access please post the links. THANKS!