Access templates: Business Account Ledger but double entry

Hi

I  found the business account ledger Access template database in Access 2016.
It works on single entry accounting.
Would it be easy to modify it to use double entry accounting?
If not is there a similar Access template for double entry accounting?

Thanks
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
This won't be a trivial change since you will need to modify most of the database objects given that you will be changing the schema.  

I am not aware of any double entry templates but that doesn't mean there are none.  There are very few Access templates that I would use for anything.   Where did you get this one?

Here is a link to a fully functional accounting system written in Access.  The source code is available and I would recommend buying it so you have control of the app should you ever want to modify it.  One of my clients used it years ago and was very happy with it but I don't have any current citations.  I'm not even sure the product is still for sale.  It was a few thousand dollars if you bought the source code.

https://softwareconnect.com/accounting/database-creations-business/

old link
http://www.accountingsuccess.com/customizable_accounting_software_low_le.htm

And then there's QuickBooks.  It is a pretty comprehensive product and can interface with other applications if you buy the ODBC driver.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much for the advice. I found that Access template in Access 2016 inn the templates there
0
PatHartmanCommented:
You're welcome.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

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.