Prepaid Subscription Amortization Schedule in Excel | Accrual Accounting
In this video, we show how to prepare a prepaid subscription amortization schedule in Excel and recognize prepaid expenses under accrual accounting. This video continues Part 1, where we explain when a prepaid subscription becomes an expense, and leads into Part 3, which covers journal entries and the full adjustment process.
Recommended Videos — Prepaid Expenses Series
▶Part 1: Prepaid Subscription – When Is It an Expense? The • Prepaid Subscription: When Is It an Expens...
▶Part 3: Prepaid Expenses: From Journal Entries to Amortization Schedule • Prepaid Subscription Accounting: Journal E...
Related Accounting Topics
Accounting Cycle: Accruals and Deferrals (Part 1 Deferrals) • Mastering DEFERRALS in Accounting Cycle in...
The Accounting Cycle: Accruals and Deferrals (Part 2 Accruals) • Mastering ACCRUALS in Accounting Cycle in ...
The Accounting Cycle: Capturing Economic Events (Intro to Debits & Credits) • Mastering Debits and Credits for Accountin...
The Accounting Cycle: Reporting Financial Results • Understand The Accounting Cycle & Reportin...
Owner vs. Shareholder. What is the difference? • Owner vs Shareholder vs Stakeholder | Acco...
The Adjustment Process • MASTER the Adjustment Process in Less than...
Preparing Financial Statements After Adjustments • Preparing Financial Statements After Adjus...
Basic Accrual Accounting Concepts • Dive Into the Must-Know Accrual Accounting...
How to Calculate Depreciation • Master DEPRECIATION Calculation in Just 15...
How to Prepare a Depreciation Schedule in Excel • Master Excel Depreciation Schedules in 5 M...
The Accounting Equation and the Rules of Debit and Credit • Mastering Debit and Credit Made Easy!
Timeline:
00:00 Introduction
01:01 Example
02:10 Schedule 1: 12-Month Prepaid Subscription Amortization
07:38 Schedule 2: Installment Payments and Expense Recognition
10:10 Updating the Amortization Schedule
11:17 Recommended playlists and videos
The textbooks used in this video: Financial Accounting, Jan R. Williams. Publisher: McGraw-Hill. Survey of Accounting, Carl S. Warren. Publisher: Cengage Learning.
Additional resources:
https://www.amsa-online.com/free-reso...
American Modern School of Accounting is a nonprofit online vocational school that offers several programs to help adult learners to start or advance their careers in bookkeeping and accounting.
We offer the following programs:
• Certificate in Computerized Accounting with QuickBooks
• Certificate in Computerized Bookkeeping with QuickBooks
• Certificate in Computerized Bookkeeping with QuickBooks (Budget Plan)
For more information, visit our website: https://www.amsa-online.com/
#Excel, #AmortizationSchedule, #FinancialAccounting, #PrepaidExpenses, #DeferredExpenses, #PrepaidSubscription, #AccountingConcepts, #GAAP, #Deferrals, #Accruals, #AccrualAccounting, #RulesOfDebitAndCredit, #Adjustments, #AccrualAccountingConcepts, #AdjustingEntriest, #AccountingCycle, #TheLedger, #LedgerAccounts, #AccountingRecords, #DoubleEntryAccounting, #AccountingEquation