Accountant Excel Toolkit - Trial Balance and General Ledger in Excel
Simon Sez IT via YouTube
-
15
-
- Write review
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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