Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Controller Academy Course [Learn How To Perform The Job Of A Corporate Controller]
Module 1 - The Accounting Equation (the basis for everything in Accounting)
M 1 - Why we need Accounting - HD 1080p (2:10)
M 1 - What Financial Statements I use in my business - HD 1080p (3:26)
M 1 - How transactions end up on the financial statements (flow of data) - HD 1080p (2:42)
M 1 - Example Journal Entries Recording - HD 1080p (5:45)
M 1 - DEALER Method vs. The Accounting Equation Method - HD 1080p (7:30)
M 1 - Intro to Journal Entries - HD 1080p (1:57)
M 1 - In one Phrase, the objective of the Accountant... - HD 1080p (4:40)
M 1 - 2 Methods to Understand Debits & Credits - HD 1080p (2:06)
M 1 - Example business; watch how transactions end up on the financial statements (33:12)
Quiz 1-1
Quiz 1-2
Refer a friend and get 20% credit!!
NOW..Watch lectures on mobile!
Module 2 - How to record transactions
M2 Lecture 1: Module II Overview (3:15)
M2 Lecture 2: Billing Intro and Revenue Streams (2:43)
M2 Lecture 3: Billing: Customer Setup (5:33)
M2 Lecture 4: Billing: Setup Products For Sale (4:16)
M2 Lecture 5: Setup Chart of Accounts (19:01)
M2 Lecture 6: Billing: Set up Sales Taxes (5:13)
M2 Lecture 7: Process To Configure Billing For New Customers (2:10)
M2 Lecture 8: Billing: Frequency & Source of Data (3:46)
M2 Lecture 9: Billing: Create Invoices (3:02)
M2 Lecture 10: Billing: Receive Cash and close out invoices (4:12)
M2 Lecture 11: Billing: Accounting Impact (3:03)
M2 Lecture 12: Cost of Sales (Software Company) (4:59)
M2 Lecture 13: Payroll Overview (2:52)
M2 Lecture 14: Payroll: How to process it (6:21)
M2 Lecture 15: Payroll: Accounting for payroll costs (4:59)
M2 Lecture 16: Payroll: Journal Entry Recording (13:25)
M2 Lecture 17: Server Cost with AWS & How to Record Vendor Bill (Cost of Sales) (7:31)
M2 Lecture 18: How To Pay/Close Vendor Bill (2:31)
M2 Lecture 19: Operating Expenses, Prepaid Expenses (11:54)
M2 Lecture 20: Employee Expenses (5:55)
M2 Lecture 21: Equity How To Create & Manage The Cap "Capitalization Table" (11:45)
M2 Lecture 22: Equity How to Record Investment From Founders (9:58)
M2 Lecture 23: Equity How To Calculate & Record Option Expense (10:53)
Quiz 2-1
Quiz 2-2
Help me? Write a Review
Quick Reminder - Short video (1:12)
Module 3 - Period end close
M3 Lecture 1 Intro to period end close (3:58)
M3 Lec 2 How to come up with close procedures (11:50)
M3 Lecture 3 Bank Reconciliation (8:20)
M3 Lecture 4 How to close Revenue (6:39)
M3 Lecture 5 Revenue Accrual Adjustments (8:58)
M3 Lecture 6 Expense Accrual Payroll Accruals (11:11)
M3 Lecture 7 Prepaid Expenses (6:05)
M3 Lecture 8 Deferred Rent (8:24)
M3 Lecture 9 Allowance for doubtful accounts (6:00)
M3 Lecture 10 Expense Accruals (9:34)
M3 Lecture 11 Sales Commission Capitalization (8:06)
M3 Lecture 12 AR Aging review, Depreciation, Equity Reconciliation etc (9:43)
M3 Lecture 13 Balance Sheet Reconciliation (11:54)
M3 Lecture 14 Year end close special considerations (2:15)
Download the Financial Statements before/after month close
Download period end reports here
Quiz 3-1
Quiz 3-2
Quiz 3-3
Module 4 - Financial Statement Analysis
M4 Lecture 1 Intro to Financial Statement Analysis (6:54)
M4 Lecture 2 Month-over-Month (Horizontal) Analysis (26:24)
M4 Lecture 3 Actual vs. Budget (16:24)
M4 Lecture 4 Vertical Analysis (3:32)
M4 Lecture 5 Ratio Analysis (7:00)
M4 Lecture 6 Recurring vs Non Recurring Costs Analysis (10:09)
Module 5 - Accounts Payable Operations
M5 Lecture 1 Accounts Payable Process Overview (3:21)
M5 Lecture 2 Procure-to-Pay System Selection (5:46)
M5 Lecture 3 TeamPay Overview and Rule Setting (5:40)
M5 Lecture 4 How to request a PO (2:49)
M5 Lecture 5 How a PO is approved (1:38)
M5 Lecture 6 How to match PO with vendor invoice (3:17)
M5 Lecture 7 Pay vendor invoices (1:10)
Quiz 5-1
Module 6 - How To Automate Period-End Close
Download all sample Excel files here
Lecture 1 Period Close Automation - Intro (7:10)
Lecture 2 Implementation of the close tool (4:30)
Lecture 3 Period Close Checklist Automation (7:47)
Lecture 4 Reconciliation of Accounts (10:11)
Lecture 5 Variance Analysis Automation (4:46)
Lecture 6 Materiality In Variance Analysis (2:57)
Lecture 7 Create New Reports In Floqast (7:50)
Lecture 8 How To Download Final Variance Analysis Report (2:26)
Excel For Accountants - Module 1: The Basics
Lecture 1 Introduction (1:13)
Lecture 2 How is Excel used in Finance (2:24)
Lecture 3 How much Excel should you know (2:14)
Lecture 4 Mac vs. PC when it comes to Excel (2:59)
Lecture 5 Use ready-templates to save time (2:36)
Lecture 6 Navigation bar breakdown (2:47)
Lecture 7 How to name your files and folders (3:08)
Lecture 8 Amazing Shortcuts (4:58)
Lecture 9 How to properly format an Excel Report (4:27)
Lecture 10 Proper Formatting Continued (5:11)
Lecture 11 Text to columns (3:05)
Lecture 12 Create drop down menu (1:36)
Lecture 13 Conditional formatting (3:51)
Excel For Accountants - Module 2: Data Cleaning & Mass Changes
Introduction & Download Practice File (1:32)
Lecture 1 Data Cleaning (6:06)
Lecture 2 Mass Data Modification (5:48)
Lecture 3 Statistical Functions (5:03)
Lecture 4 Conditional Functions (7:02)
Excel For Accountants - Module 3: Data Lookup
M3 Lecture 1 Introduction to Lookups - HD 1080p (5:17)
M3 Lecture 2 Vlookup, why it is helpful and why it-s has issues - HD 1080p (9:44)
M3 Lecture 3 Xlookup and its many benefits - HD 1080p (8:24)
M3 Lecture 4 Xlookup - Bring the last match, and why - HD 1080p (3:53)
M3 Lecture 5 Horizontal Xlookup - HD 1080p (1:51)
M3 Lecture 6 Wildcard - a type of Fuzzy lookup - HD 1080p (3:00)
M3 Lecture 7 Filter - when there are multiple results - HD 1080p (3:14)
M3 Lecture 8 Index Match - Another way to lookup data - HD 1080p (7:18)
M3 Lecture 9 Xlookup with multiple criteria - HD 1080p (3:00)
Excel For Accountants - Module 4: Pivot Tables and VBA Macros
Download the practice files
M4 Lecture 1 Pivot Tables Fundamentals (11:09)
M4 Lecture 2 How to add -Month- to a Pivot Table (2:40)
M4 Lecture 3 Slicer vs. Filter in Pivot Tables (4:22)
M4 Lecture 4 Pivot Charts (1:14)
M4 Lecture 5 VBA Macros (8:02)
Bonus: How To Build A KPI Dashboard Using Excel
Download Practice Files
Build A KPI Dashboard With Excel (28:12)
M3 Lecture 6 Expense Accrual Payroll Accruals
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock