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:
[ Ссылка ]
BECOME A MEMBER:
YouTube: [ Ссылка ]
or My Site: [ Ссылка ]
LEARN MORE:
[ Ссылка ]
PRE-REQUISITES:
Check Register: [ Ссылка ]
Relationships: [ Ссылка ]
Relational Combo: [ Ссылка ]
LINKS:
ISO Date Format: [ Ссылка ]
Filter Records: [ Ссылка ]
Self Join Relationships: [ Ссылка ]
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: [ Ссылка ]
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: [ Ссылка ]
Blank Template: [ Ссылка ]
Contact Management: [ Ссылка ]
Order Entry & Invoicing: [ Ссылка ]
More Access Templates: [ Ссылка ]
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
Donate to my Tip Jar: [ Ссылка ]
Get on my Mailing List: [ Ссылка ]
Contact Me: [ Ссылка ]
TechHelp: [ Ссылка ]
Consulting Help: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
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.
Double-Entry Accounting in Microsoft Access
Теги
access 2016access 2019access 2021access 365microsoft accessms accessms access tutorialmsaccessmicrosoftaccesshelphowtotutoriallearnlessontrainingdatabaseDouble Entry Accounting SystemGeneral Journal Accounting SystemAccounting DatabaseHow do you create a double entry accounting systemDouble entry accountingHow to work with double entry accounting records