Accountant Excel Toolkit - Trial Balance and General Ledger in Excel
Simon Sez IT via YouTube
-
18
-
- Write review
Learn the Skills Netflix, Meta, and Capital One Actually Hire For
AI, Data Science & Business Certificates from Google, IBM & Microsoft
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
This 57-minute tutorial teaches you how to build an Accountant Excel Toolkit with a focus on Trial Balance and General Ledger management. Learn to create and maintain a precise trial balance for verifying account balances before generating financial statements, and organize your general ledger to effectively track all transactions. The comprehensive guide covers General Ledger overview, recording transactions, linking with QuickBooks Online, balancing the Trial Balance, performing accuracy checks, making adjusting entries, and includes a practical exercise. Free downloadable course files are available to follow along with the instruction provided by Simon Sez IT.
Syllabus
00:00:00 - General Ledger Overview
00:06:07 - Recording Transactions in General Ledger
00:15:45 - Linking QuickBooks Online and General Ledger
00:26:22 - Balancing the Trial Balance
00:34:21 - Accuracy Check for Trial Balance and General Ledger
00:44:00 - Adjusting Entries
00:51:29 - Exercise
Taught by
Simon Sez IT