Double-Entry Accounting in Microsoft Access

In this Microsoft Access tutorial I'm going to teach you how to track double-entry accounting records in your database. We'll talk about what double-entry accounting is, why you use it, and I'll show you how to properly store this information in your Microsoft Access database.

Ethan from Boulder, Colorado (a Platinum Member) asks: I enter in all of my daily transactions in my Access database using the Check Register template that you created in a previous video. It's very helpful. Thank you. How would I track transactions using double-entry accounting in multiple accounts? For example if I pay my Discover Card can I put a credit on that account and have a debit show up for my checking account?

Silver Members and up get access to an Extended Cut of this video. Members will learn how to create a form where we can specify the credit account, which will then automatically select the debit account based on our defaults. Then we can type in the amount, click a button, and have both transactions entered into the register for us automatically with a little VBA and a little SQL.

MEMBERS VIDEO:
https://youtu.be/6xktRTM5avA

BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/DoubleEntry

PRE-REQUISITES:
Check Register: https://599cd.com/CheckRegTH
Relationships: https://599cd.com/Relationships
Relational Combo: https://599cd.com/Relational

LINKS:
ISO Date Format: https://599cd.com/ISO
Filter Records: https://599cd.com/Filter
Self Join Relationships: https://599cd.com/SelfJoin

UPDATE:
Yes, this is a reposted video. In my original, I erroneously said that if you purchase $1000 worth of inventory with cash that you would CREDIT the inventory account and DEBIT the cash account. This is backwards. Lots of you pointed out my mistake. I appreciate that. I edited and reposted the video to prevent anyone else from being confused in the future.

RECOMMENDED COURSES:
Check Register Seminar: https://599cd.com/CheckRegister

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/

KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Double Entry Accounting System, General Journal Accounting System, Accounting Database, How do you create a double entry accounting system, Double entry accounting, How to work with double entry accounting records

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.