Free Course Coupon Logo
Tax & Adjusting Entry Year-End Accounting Excel Worksheet
114$
0.00$
16 February 2025

[100 % OFF] Tax & Adjusting Entry Year-End Accounting Excel Worksheet

Instructors:

Robert (Bob) Steele
Robert (Bob) Steele

Language:

English

Ratings:

4.5

What you'll learn:

Course content:

Introduction8min
  • Introduction07:32
Why Use An Adjusting Entry & Tax Entry Worksheet22min
  • 2 Why Use An Adjusting Entry & Tax Entry Worksheet00:28
  • 310 Why Use Adjusting & Tax Entries Worksheet In Excel09:42
  • 315 Excel Adjusting & Tax Worksheet Format11:42
  • Accounting Comic Break00:15
Create Adjusting Entry & Tax Entry Worksheet In Excel1hr 20min
  • 3 Create Adjusting Entry & Tax Entry Worksheet In Excel00:49
  • Download Backup Files01:50
  • 510 Trial Balance Generate Report QuickBooks Export To Excel04:37
  • 511 Make Trial Balance From Balance Sheet & Income Statement Excel16:20
  • 512 Format Exported Excel Workbook06:25
  • 515 Format Debits & Credits to One Column07:12
  • 517 Conditional Formatting To Check If In Balance06:42
  • 519 Calculate Net Income On Trial Balance Excel06:30
  • 522 Format Header of Unadjusted Trial Balance Excel05:55
  • 524 Add Grid Lines Or Borders To Trial Balance Excel02:06
  • 526 Add Adjusting Trial Balance Column Excel06:45
  • 528 Add Tax Trial Balance Column Excel05:05
  • 530 Add Journal Entry Columns Excel09:25
  • Accounting Comic Break00:15
Adjusting Entry For Accounting Error9min
  • 4 Adjusting Entry For Accounting Error00:49
  • 550 Adjusting Entry Correct Error Excel07:51
  • Accounting Comic Break00:15
Tax Entry For Nondeductible Expenses30min
  • 5 Tax Entries For Nondeductible Expenses00:41
  • 560 Tax Entry Meals & Entertainment Excel11:32
  • 565 Tax Entry Charity, Penalties, & Political Contributions Excel17:25
  • Accounting Comic Break00:15
Adjusting & Tax Entries For Insurance18min
  • 6 Adjusting & Tax Entries For Insurance00:50
  • Adjusting & Tax Entries For Insurance09:09
  • 574 Tax Entry Prepaid Insurance Excel07:27
  • Accounting Comic Break00:16
Adjusting & Tax Entries For Depreciation15min
  • 7 Adjusting & Tax Entries For Depreciation00:33
  • 582 Adjusting Entry Depreciation Excel07:05
  • 584 Tax Entry Depreciation Excel07:26
  • Accounting Comic Break00:15
Add Columns to Adjusting & Tax Entry Worksheet6min
  • 8 Add Columns to Adjusting & Tax Entry Worksheet00:24
  • 592 Add Columns To Worksheet Excel05:19
  • Accounting Comic Break00:15
Enter Adjusting & Tax Entries For Sale of Fixed Asset26min
  • 9 Enter Adjusting & Tax Entries For Sale of Fixed Asset00:39
  • 602 Adjusting Entry Sale of Fixed Asset Excel13:29
  • 604 Tax Entry Sale of Fixed Asset Excel11:20
  • Accounting Comic Break00:15
Tax Entry For Tax Exempt Interest Income6min
  • 10 Tax Entry For Tax Exempt Interest Income00:14
  • 612 Tax Entry Tax Exempt Interest Excel05:21
  • Accounting Comic Break00:16
Adjusting & Tax Entry For Personal Expenses10min
  • 11 Adjusting & Tax Entry For Personal Expenses00:57
  • 622 Adjusting Entry Personal Expense Excel04:11
  • 624 Tax Entry Adjust Meals & Entertainment Excel04:11
  • Accounting Comic Break00:16
Alternative Format Of Adjusting & Tax Worksheet17min
  • 12 Alternative Format Of Adjusting & Tax Worksheet00:37
  • 630 Alternative Worksheet With Debit & Credit Columns Excel15:39
  • Accounting Comic Break00:15
Manually Enter A Trial Balance Into An Existing Excel Worksheet16min
  • 13 Manually Enter A Trial Balance Into An Existing Excel Worksheet00:40
  • 640 Enter Trial Balance Into Existing Excel Worksheet15:17
Adjusting Entry For Equity Section23min
  • 14 Adjusting Entry For Equity01:03
  • 645 Retained Earning or Equity Adjusting Entry Excel Worksheet21:13
  • Accounting Comic Break00:15
Discuss Options For Entering Adjusting Entries To Accounting Software8min
  • 15 Discuss Options For Entering Adjusting Entries To Accounting Software01:11
  • Download Backup Files00:05
  • 655 Options For Entering Adjusting Entries To QuickBooks06:32
  • Accounting Comic Break00:15
Enter Adjusting Entries In Accounting Software19min
  • 16 Enter Adjusting Entries In Accounting Software00:40
  • Download Backup Files00:05
  • 660 Enter Adjusting Entries From Excel Worksheet To QuickBooks06:26
  • 665 Compare Trail Balance In QuickBooks To Adjusted Trial Balance In Excel11:52
  • Accounting Comic Break00:15

Description

Build Excel worksheet for adjusting adjusting & tax entries, reconciling net income calculated on a book and tax basis

Reviews:

4.5