MS Access Small Business Accounting Template

Murray Brown
Murray Brown used Ask the Experts™
on
Hi

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.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015
Commented:
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.
http://www.msaccessgurus.com/Contacts.htm

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,
crystal
Most Valuable Expert 2012
Top Expert 2014
Commented:
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: https://www.microsoftaccessexpert.com/Microsoft-Access-Basic-Business-Accounting-Database.aspx. 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: https://access-templates.com/tutorial/ms-access-templates-for-small-business-accounting-software.html. 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.
Murray BrownASP.net/VSTO Developer

Author

Commented:
Thanks very much for the advice
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
you're welcome ~ happy to help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial