Accountant Excel Toolkit - Trial Balance and General Ledger in Excel
Simon Sez IT via YouTube
-
19
-
- Write review
The Private Equity Associate Certification
Build GenAI Apps from Scratch — UCSB PaCE Certificate Program
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
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