Double entry accounting

[CEH]

I have been searching the web for some examples of a double entry accounting systems made with MS Access. I havent found any that I can open... examine the tables, queries, relationships and everything else. Not that I am planning on spending a year or two building one But I want to know how to. So if anyone knows of any good examples please post the links for me. Thanks

 

[Pat Hartman]

Double entry accounting systems are fairly complex. I seriously doubt that you will find "example" applications. I know of two applications off hand that are Access and you can purchase them with source code so you can modify them if necessary.
Integral Accountin Enterprise - www.stfb.com
Business! Accounting - www.databasecreations.com

 

[CEH]

Let me rephrase........

Well, let me not get so complicated. I've worked with many accounting softwares so I know how complex they can get. What I'm looking for is something simple, so I can know the "prefered" method for reaching the end product. The one thing I notice with every Access project I look at is there are MANY methods to reach the same end result. So I am looking for something as simple as a check regester..... But using double entry. Is the prefered method a form with a subform? And how to require that the end result for every entry always is zero, (In balance). I can think of different ways to set this up... But I'm wondering if I am using the "Best" method.

 

[Pat Hartman]

A form with a subform is correct. There is no declarative RI that will enforce the double entry so you need to do it in code. You should also consider wrapping your updates inside transactions since they are not complete until BOTH sides are committed. The transaction will be automatically rolled back if it isn't complete.

If your back end is not Access (Jet) but some ODBC database, you will be able to create triggers to handle some RI rather than relying entirely on code behind your forms.

 

[nikitos]

I have made such an example database (see attachment) . It is fairly simple, but it works and you can understand the relationships easily.

 

[Geert_B]

I have made such an example database (see attachment) . It is fairly simple, but it works and you can understand the relationships easily.

Hi Nikitos,

Can you place the example in access 2003 or 2007.

My access can read this.


I am intrested and i looking to your example.

Thanks, Geert

 

[Geert_B]

I have made such an example database (see attachment) . It is fairly simple, but it works and you can understand the relationships easily.

Can somebody this example place in Access 2003.

Much thanks for that!

Regards, Geert

 

[Geert_B]

Can somebody the file database.accdb place in Access2003 for me.
Thanks very much.

 

[hunterfan48]

That sample database above works great. What if you run into more complex entries?

For example, there may be 2 credits needed and only one debit. How would you account for that in your journal table when one line only allows for one entry in the debit and credit fields?

 

[ypma]

Can somebody this example place in Access 2003.

Geert ,Unable to save the example in an earlier version as some of the features are not available in the earlier versions .

Regards