MS Access Small Business Accounting Template


I am looking for a Microsoft Access accounting template for use by a small business.
I want a raw Access file that can be fully customized if needs be.
Does Microsoft have anything like this?
I want something that does more than just simple journal entries. I would like to have tables for invoicing etc.
I am already aware of the Northwind database so looking for something else.

Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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.

crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
hi Murray,

I created a template for tracking contacts since most every business has a need to track them.  I slide this into many databases that I help build.  To help others with the logic of this, I created many extra tables that are not used, and there are no forms or reports for them either ... but they are there.  It has about 100 tables, only about 20 of which are used. You can download, and watch videos about it here:

Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments, ... and many extra bsiness tables.

The code is sprinkled liberally with comments so others can understand better.

It allows for Orders that might turn into Invoices, so the names are weird. I would change the names now -- and you can do as you like since everything is available to see

have an awesome day,
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The Northwinds template is probably the closest thing you'd find. There are others, like the "Personal Accounts Ledger", which may work as well, but whatever you choose you're going to have a lot of mods to do.

There's some here: I've not reviewed them, so I don't know if they're appropriate, but you can download a demo.

Here's one that's free: Again, I've not reviewed it, but it might be worth a look.

There are quite a few others, of course. Those were just the first few I found.

That said: A full accounting database can be a beast to work with. I do a LOT of work for a large ERP solution, which includes a full accounting module, and it's quite complex with a ton of both accounting and business rules that must all work together. We don't know your skill level, of course, so you may be up to the task, but as a very experienced developer, I'd have second thoughts about trying to create a full accounting program in Access.

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
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ~ happy to help
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

From novice to tech pro — start learning today.