Access Accounting System. Simplified double ebtry approach

Hi

I have asked previous questions about double vs single entry accounting systems. I am looking for the most simple way to gather
all the information required for double entry accounting in Access. If there is for instance a single Debit with more than one Credit has anyone come up with a simplistic approach for this?

Thanks
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
To add a bit, even with single vs double entry accounting, there is no real difference as far as the table.

 In both cases, you still have a GL posting.

 For double entry accounting, each debit and credit is an individual posting (one record), of which there may be one or more as part of a transaction,  and when summed debits = credits.   Also they are in balance in terms of the accounts they are posted to (Assets = Liabilities + owner equity).

Table would look something like this

PostingID
TransactionID
PostingDate
EntryDate
Source (AR, AP, PO, Inventory, etc)
ProgramRef (which program generated it)
Account
Amount
DebitCreditFlag

 Does that answer your question, or are you looking for something else?

Jim.
0
 
Gustav BrockConnect With a Mentor CIOCommented:
Check that the sum of credits matches the debit.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.