QuickBooks Online vs. Excel 2022 [2024]

QuickBooks and Excel accounting cycle, reporting the financial transactions to both QuickBooks and Excel compare and contrast

Table of Contents

This course includes:

116.5 hours of on-demand video
79 downloadable resources
Full lifetime access
Access on mobile and TV
Certificate of completion

4.5

(104 ratings)

12,556 students

Created by Robert (Bob) Steele

What you’ll learn

Enter normal business transactions in QuickBooks
Enter normal business transactions in Excel using debits and credits
Reconcile bank accounts in QuickBooks
Reconcile bank accounts in Excel
Generate Reports in QuickBooks
Make Reports in Excel
Analyze Reports

Requirements

QuickBooks and Excel software would be best.

Description

Would we like to run our business better using accounting software?

Would we like to better understand accounting concepts, how they apply to account software, and work accounting problems MUCH faster?

Would we like to advance our careers by increasing our skills with business software?

This comprehensive QuickBooks Online & Excel course can help to achieve these goals

Why choose this course?

Current video content means all QuickBooks lectures are done recently as of this post rather than adding a few new videos to content from prior years.

This course also includes:

Excel worksheets that are formatted so that we can concentrate on the accounting relationships and on using the fundamentals of Excel.

Who will we be learning from?

You will be learning from somebody who has technical experience in accounting concepts and in accounting software like QuickBooks, as well as experience teaching and putting together the curriculum.

You will be learning from somebody who is a:

CPA – Certified Public Accountant
CGMA – Chartered Global Management Accountant
Master of Science in Taxation
CPS – Certifies Post-Secondary Instructor
Curriculum Development Export

As a practicing CPA, the instructor has worked with many technical accounting issues and helped work through them and discuss them with clients of all levels.

As a CPS professor, the instructor has taught many accounting classes and worked with many students in the fields of accounting, business, and business applications.

The instructor also has a lot of experience designing courses and learning how students learn best and how to help students achieve their objectives. Experience designing technical courses has also helped in being able to design a course in a logical fashion and deal with problems related to technical topics and the use of software like QuickBooks Pro.

How will we be Taught?

We will learn by doing, by providing a presentation, and by providing the tools to work through the processes presented. Learning QuickBooks and Excel is something best learned by doing, by applying skills to the QuickBooks application.

A partial list of topics covered is below.

Start a New Company File
Accounting Methods
Enter Data for the First Month of Operations
Enter Data for the Second Month of Operation
Bank Reconciliations
Adjusting Entries and Reversing Entries

Please Join Us for QuickBooks Desktop 2018 vs. Excel Course. It will be Great

Who this course is for:

Business Owners
Accounting Professionals
Accounting Students
Anybody who wants to learn accounting software
Anybody who wants to learn accounting theory
Anybody who wants to learn Excel basics

Show less

Course content

65 sections • 460 lectures • 116h 34m total lengthCollapse all sections

OneNote-Getting Started 202210 lectures • 47min

1005 Getting Access to Software For FreePreview03:51
1007 30–Day Free Trial08:34
1009 Free Test Drive02:58
1011 QuickBooks Online vs QuickBooks Desktop06:55
1012 QuickBooks Online Software Options04:35
1013 Increase Screen Size and Toggle03:35
1015 Navigation Overview04:49
1017 Bank Feeds05:26
1018 Preferences – Account and Settings02:52
1080 Accounting Process and Forms Overview03:40

2022- Getting Started10 lectures • 2hr 25min

1005 Getting Access to Software For FreePreview08:36
1007 30–Day Free Trial20:11
1009 Free Test Drive08:12
1011 QuickBooks Online vs QuickBooks Desktop24:08
1012 QuickBooks Online Software Options16:50
1013 Increase Screen Size and Toggle12:13
1015 Navigation Overview19:38
1017 Bank Feeds12:22
1018 Preferences Account & Settings08:05
1080 Accounting Process & Forms Overview14:40

Excel – Setup Worksheet11 lectures • 2hr 55min

1025 Create Accounting Worksheet Part 119:13
1028 Create Accounting Worksheet Part 211:04
1031 Create Accounting Worksheet Part 313:20
1034 Create Accounting Worksheet Part 407:50
1037 Create Accounting Worksheet Part 517:14
1040 Create Accounting Worksheet Part 615:58
1043 Create Accounting Worksheet Part 708:28
1046 Create Accounting Worksheet Part 815:58
1049 Create Accounting Worksheet Part 927:54
1052 Create Accounting Worksheet Part 1018:39
1055 Create Accounting Worksheet Part 1119:31

OneNote-Vendor, Accounts Payable, Expenses, or Purchases Cycle 20224 lectures • 30min

1155 Vendor, Expense, Purchases, Pay, or AP Cycle03:52
1160 Vendor, Expense, Purchases, or Pay Center04:15
1180 Bill Form12:54
1200 Pay Bills08:57

Vendor, Accounts Payable, Expenses, or Purchases Cycle 20228 lectures • 2hr 10min

1155 Vendor, Expense, Purchases, Pay, or AP Cycle19:24
1160 Vendor, Expense, Purchases, or Pay Center19:09
1180 Bill Form16:23
1200 Pay Bills Form Check16:15
1220 Purchase Order Form – P.O.13:09
1240 Manage Sales Tax Form14:15
1260 Check & Expense Form14:10
1280 Void Check Prior Period Adjustment17:29

Excel-Vendor Cycle, Purchases Cycle, or Accounts Payable Cycle Transactions4 lectures • 1hr 37min

1180 Bill Form27:09
1200 Pay Bills Form Check21:38
1260 Check Form22:14
1280 Void Check Prior Period Adjustment25:57

Customer Cycle, Sales Cycle, or Accounts Receivable Cycle 202212 lectures • 3hr 40min

1300 Customer, Accounts Receivable, or Get Paid Cycle10:59
1320 Customer, Accounts Receivable, or Get Paid Center10:16
1340 Invoice Form18:05
1360 Receive Payment Form15:02
1380 Deposit Form16:39
1400 Sales Receipts Form16:03
1405 Barter or Trade Transaction23:02
1420 Credit Memo Bad Debt Sales Returns32:22
1422 Refund Receipt Form27:10
1425 Delayed Charge13:46
1425 Delayed Credit & Credit Memo26:10
1427 Estimate09:57

Excel-Customer Cycle, Sales Cycle, or Accounts Receivable Cycle Transactions6 lectures • 2hr 59min

1340 Invoice Form28:09
1360 Receive Payment Form27:59
1380 Deposit Form33:18
1400 Sales Receipts Form26:30
1420 Credit Memo Refund Form & Bad Debt Expense Service Item29:55
1488 Credit Memo with Inventory33:13

Other Important Forms & Functions, Shortcuts, & Employee Cycle 202216 lectures • 4hr 22min

1400 Sales Receipts Form16:03
1405 Barter or Trade Transaction23:02
1420 Credit Memo Bad Debt Sales Returns32:22
1422 Refund Receipt Form27:10
1425 Delayed Charge26:10
1425 Delayed Credit & Credit Memo26:10
1427 Estimate09:57
1440 Other Section, Banking, or Company Section08:46
1442 Transfer Form09:51
1444 Journal Entry14:40
1446 Statement Form12:24
1448 Inventory Qty Adjustment08:11
1450 Pay Down Credit Card Form12:19
1460 Keyboard Shortcuts10:21
1480 Employee Section Payroll Process13:14
1500 Payroll Center & Cycle11:06

Excel-Employee Cycle – Payroll Cycle Transactions2 lectures • 45min

1520 Pay Employees Form18:24
1522 Pay Employees Form Part 226:18

Lists-Chart of Accounts & Products & Services Lists 20223 lectures • 54min

1560 Lists09:44
1580 Chart of Accounts25:06
1600 Products and Services List19:09

Help/Support & Reports Overview 20222 lectures • 35min

1620 Help and Support11:29
1640 Reports23:23

Balance Sheet Report 202212 lectures • 3hr 7min

2020 Balance Sheet Report26:25
2040 Report Formatting Basics22:13
2045 Report Customization General Category08:27
2060 Report Header and Footer Formatting11:28
2080 Report Customization10:06
2100 Comparative Balance Sheet Creation14:41
2120 Balance Sheet Vertical Analyses12:18
2125 Summery Balance Sheet09:54
2140 Save Customization or Memorize Report16:06
2160 Management Reports Customization17:47
2180 Print, E-mail, and Create a PDF of Reports17:26
2181 Export Balance Sheet Reports19:55

Profit & Loss / Income Statement 20226 lectures • 1hr 35min

3020 Profit and Loss, P and L, Income Statement Overview21:02
3040 Comparative Profit and Loss, P and L, Income Statement16:08
3060 Vertical Analysis Profit Loss, P, and L, Income Statement10:38
3080 Save Customization or Memorize Profit and Loss Reports14:45
3100 Profit and Loss Print, Save as PDF, and Create Management Report14:41
3105 Profit and Loss17:42

Statement of Cash Flows & Supplemental Reports 202211 lectures • 2hr 40min

4020 Statement of Cash Flows21:48
4040 Accounts Receivable Aging Reports14:31
4060 Accounts Payable Aging Reports16:22
4080 Sales by Customer and Income by Customer Reports14:29
4120 Expense and Vendors Reports15:09
4200 Transaction List by Date Report09:40
4220 Journal Report10:38
4240 Budget Reports13:00
4320 Sales by Customer Graphs14:59
4360 Sales by Product and Service Graph15:20
4380 Internal and External Reports14:18

Start a New Company File in QuickBooks 20223 lectures • 38min

6010 Comprehensive Problem Introduction07:06
6040 Free 30-Day Trial Set Up19:13
6060 Account and Settings Company Tab11:48

Company Preferences4 lectures • 58min

6080 Account and Settings Billing and Subscription, Usage, and Sales Tabs20:26
6100 Account and Settings Expenses, Payments, Time, and Advanced Tabs19:42
6120 Manage Users14:21
6140 QuickBooks Labs Dark Mode03:59

Excel-Create Worksheet for New Company Accounting Transactions4 lectures • 49min

6010 Set Up Excel Worksheet10:15
6012 Set Up Excel Worksheet #215:17
6014 Set Up Excel Worksheet #310:15
6016 Set Up Excel Worksheet #412:57

Adding Service Items & Inventory Items4 lectures • 1hr 12min

6240 Entering Beginning Balances, Customers, Vendors, and Items Overview14:34
6260 Enter Service Items19:49
6280 Inventory Tracking Options11:05
6300 Set Up Inventory26:16

Excel-Adding Inventory Items & Related Inventory Account Balances1 lecture • 25min

6300 Inventory & Inventory Subsidiary Ledger25:17

Sales tax Setup, Add Customers & Add Vendors3 lectures • 1hr 3min

6320 Sales Tax23:24
6340 New Customers Setup and Accounts Receivable Beginning Balances27:40
6360 New Vendors Setup and Accounts Payable Beginning Balances12:25

Excel-Add Customers, Add Vendors, & Accounts Receivable & Accounts Payable Balan3 lectures • 40min

6340 Accounts Receivable & Subsidiary Ledger12:11
6360 Accounts Payable & Subsidiary Ledger09:02
6362 Financial Statements19:06

Opening Balances, Adjustments to Equity, & Manual Payroll Setup4 lectures • 1hr 34min

6380 Add New Accounts and Opening Balances31:07
6400 Adjust Opening Balances17:40
6420 Payroll Set up23:20
6440 Generate Reports After Entering Beginning Balances21:58

Excel-Add Opening Account Balances2 lectures • 31min

6380 Add New Accounts & Opening Balances20:42
6383 Adjust Beginning Balances in Worksheet for Current Period Data Input10:28

Month 1- Record Owner Investment, Purchase of Fix Asset & Investment 20222 lectures • 40min

7020 Deposits Owner Investment and Loan17:43
7040 Purchase of Furniture and Investment Transactions22:43

Excel-Month 1-Record Owner Investment, Purchase of Fixed Assets & Inventory2 lectures • 28min

7020 Record Deposits from Owner and Loan11:20
7040 Purchase of Furniture & Investment Transactions16:28

Month 1- Enter Purchase Order & Enter Check or Expense Form from PO 20222 lectures • 44min

7060 Enter Purchase Order P.O.21:12
7080 Cash Payment for Inventory Linked to Purchase Order P.O.22:18

Excel-Month 1-Enter Transactions for Purchase of Inventory1 lecture • 23min

7080 Cash Payment for Inventory Linked to Purchase Order P.O.23:04

QBO- Month 1- Enter Invoice, Sales Receipt, & Deposits 20224 lectures • 1hr 28min

7100 Invoice Selling Inventory26:34
7120 Receive Payment Transaction and Form24:40
7140 Sales Receipt Payment Received at Point of Sale20:59
7160 Deposits From Payment to Deposit or Undeposited Funds15:30

Excel-Month 1-Enter Transactions for Sale of Inventory and Deposits4 lectures • 1hr 28min

7100 Invoice Selling Inventory31:47
7120 Receive Payment From Previous Invoice20:43
7140 Sales Receipt Payment Received at Point of Sale24:13
7160 Deposits From Undeposited Funds11:34

QBO- Month 1- Enter Invoice, Receive Payment Bill 20224 lectures • 1hr 22min

7180 Invoice Created From Check Created From Purchase Order27:12
7200 Receive Payment and Make18:55
7220 Write Checks for Expenses and Prepaid Assets24:12
7240 Bill Pay12:09

Excel-Month 1-Enter Transaction for Sale of Inventory, Receive Payment, & Bill4 lectures • 1hr 19min

7180 Invoice Created From Check Created From Purchase Order29:06
7200 Receive Payment & Make Deposit17:28
7220 Write Checks for Expenses & Prepaid Assets23:34
7240 Bill Pay09:07

QBO-Month 1- Create Customer Job, Pay Employees, & Create Sales Receipt for job4 lectures • 1hr 24min

7260 Jobs, Sub Customers, and Projects16:08
7280 Pay Employees28:22
7281 Payroll Adjustment12:45
7300 Enter Billable Time and Add to Invoice for Job26:26

Excel-Month 1-Transactions for Payroll & Create Sales Receipt4 lectures • 1hr 16min

7280 Pay Employees17:33
7281 Pay Employees Part 223:06
7300 Enter Billable Time & Add to Invoice13:47
7301 Enter Billable Expenses to Invoice21:07

QBO- Month One Reports1 lecture • 20min

7320 Month One Reports19:52

Excel-Month 1-Create Financial Statements1 lecture • 22min

7320 Month One Financial Statements22:10

QBO- Month 2- Enter Loan Payments, Create Amortization Tables, & Investment 2024 lectures • 1hr 18min

8020 Make Amortization Table25:43
8022 Make Loan Payments18:38
8040 Short-Term Investment Sales and Gains16:39
8060 Change Account Categorization to Other Expense16:59

Excel-Month 2-Enter Loan Transaction, Create Amortization Table, & Investment4 lectures • 58min

8005 Format Worksheet for New Month17:39
8020 Make Amortization Table11:41
8022 Make Loan Payments17:24
8040 Short-Term Investment Sales & Gains11:28

QBO-Month 2- Enter Purchase Order, Sales Receipt, Bill for Inventory3 lectures • 46min

8080 Purchase Order Adding New Items08:26
8120 Sales Receipt and Deposit22:10
8122 Record Receipt of Inventory with Bill Linked to P.O.15:50

Excel-Month 2-Enter Sale, Cash Received at Same Time & Bill for Inventory2 lectures • 39min

8120 Sales Receipt & Deposit28:28
8122 Record Receipt of Inventory with Bill Linked to P.O.10:24

QBO- Month 2- Invoice from Billable Item, Advanced Customer Deposit 20224 lectures • 1hr 29min

8130 Populate Invoice Using Billable Item That was Created From P.O.17:09
8140 Advanced Customer Payment or Unearned Revenue Method 126:17
8160 Apply Customer Deposit (Credit) to Invoice (New Title Intro)20:47
8200 Advanced Customer Payment or Unearned Revenue Method 225:09

Excel-Month 2-Invoices for Service Sales & Advanced Customer Deposit4 lectures • 1hr 18min

8130 Populate Invoice Using Billable Item That was Created From P.O.15:21
8140 Advanced Customer Payment or Unearned Revenue Method 120:48
8160 Apply Customer Deposit (Credit) to Invoice17:19
8200 Advanced Customer Payment or Unearned Revenue Method 224:22

QBO- Month 2- Invoicing for Hourly Service 20222 lectures • 30min

8320 Bill for Hourly Services of Staff Enter Billable Time09:23
8322 Create Invoices Using Billable Time Receive Payment and Make Deposit20:33

Excel-Months 2-Transaction for Billable Time2 lectures • 31min

8320 Bill for Hourly Services of Staff Set up Items & Enter Billable Time08:57
8322 Create Invoices Using Billable Time22:08

QBO- Month 2- Invoicing for Rental Income with Advanced Customer Deposit 20223 lectures • 47min

8340 Rental Income Set Up Service Items12:51
8342 Rental Income Customer Deposit16:38
8344 Rental Income Invoice, Receive Payment, and Deposit17:41

Excel-Month 2-Rental Income Transaction & Advanced Customer Deposit2 lectures • 35min

8342 Rental Income Customer Deposit14:25
8344 Rental Income Estimate & Invoice20:28

QBO- Month 2- Purchase & Finance Equipment & Recategorize Fixed Assets 20222 lectures • 44min

8360 Purchase and Finance Equipment20:13
8362 Subaccounts Categories For Fixed Assets24:11

Excel-Month 2-Purchase & Finance Equipment2 lectures • 28min

8360 Purchase & Finance Equipment10:39
8362 Subaccounts Categories For Fixed Assets16:57

QBO- Month 2- Enter & Pay Month End Bills & Pay Sales Tax 20222 lectures • 49min

8365 Bills – Enter, Sort, and Pay27:40
8370 Pay Sales Tax21:21

Excel-Month 2-Enter & Pay Month End Bills & Pay Sales Tax2 lectures • 36min

8365 Bills – Enter, Sort, & Pay27:00
8370 Pay Sales Tax09:20

QBO- Month 2- Enter Payroll & Pay Payroll Tax for Prior Period 20223 lectures • 57min

8380 Enter Payroll For Second Month22:41
8381 Enter Payroll For Second Month Adjustment15:57
8385 Pay Payroll Taxes18:50

Excel-Month 2-Enter Payroll & Pay Payroll Tax for Prior Period3 lectures • 52min

8380 Enter Payroll For Second Month Part 116:25
8381 Enter Payroll For Second Month Part 220:28
8385 Pay Payroll Taxes15:08

QBO- Month 2- Generate Month End Report & Review Work2 lectures • 50min

8420 Create Reports After Second Month of Data Input28:55
8421 Reports Month Two Save as PDF and Export to Excel21:05

Excel-Month 2 Financial Statements2 lectures • 42min

8420 Create Reports After Second Month of Data Input YTD21:57
8421 Create Reports After Second Month of Data Month of February Only19:51

QBO- Bank Reconciliations9 lectures • 2hr 47min

9020 Bank Reconciliation Myth Busting21:14
9040 Bank Reconciliation Month One Overview17:17
9060 Bank Reconciliation Month 1 Deposits13:42
9080 Bank Reconciliation Month 1 Checks22:10
9100 Bank Reconciliation Opening Balance Problem15:58
9120 Bank Reconciliation Reports Month 119:37
9140 Bank Reconciliation Month 2 Deposits16:47
9145 Bank Reconciliation Month 2 Checks and Account Decreases20:24
9160 Bank Reconciliation Month 2 Reports19:37

Excel-Bank Reconciliations6 lectures • 1hr 52min

9040 Bank Reconciliation Month One Part 122:45
9041 Bank Reconciliation Month One Part 217:44
9042 Bank Reconciliation Month One Part 321:02
9140 Bank Reconciliation Month Two Part 117:52
9141 Bank Reconciliation Month Two Part 215:11
9143 Bank Reconciliation Month Two Part 317:24

QBO- Adjusting & Reversing Entries 202212 lectures • 4hr 25min

10120 Adjusting Entries and Reversing Entries Introduction23:16
10180 Adjusting Entry Accrued Interest25:25
10220 Reversing Entry Accrued Interest20:23
10260 Adjusting Entry Accounts Receivable-Sales31:37
10300 Reversing Entry Accounts Receivable Sales29:54
10340 Adjusting Entry Prepaid Insurance17:15
10380 Adjusting Entry Depreciation26:16
10400 Adjusting Entry Unearned Revenue Customer Deposit21:52
10460 Reversing Entry Unearned Revenue Customer Deposit18:04
10465 Adjusting Entry Loan Payable Short-Term and Long-Term Portions21:30
10467 Reversing Entry Loan Payable Short-Term and Long-Term Portions12:10
10480 Adjusting Entry and Reversing Entry Journal Reports17:29

Excel-Adjusting Entries15 lectures • 4hr 18min

10175 Adjust Worksheet for Adjusting Entries17:23
10180 Adjusting Entry Accrued Interest Part 115:04
10182 Adjusting Entry Accrued Interest Part 215:58
10220 Reversing Entry Accrued Interest11:27
10260 Adjusting Entry Accounts Receivable Sales20:49
10300 Reversing Entry Accounts Receivable Sales14:11
10340 Adjusting Entry Prepaid Insurance15:36
10380 Adjusting Entry Depreciation24:05
10400 Adjusting Entry Unearned Revenue Customer Deposit16:46
10460 Reversing Entry Unearned Revenue Customer Deposit10:59
10465 Adjusting Entry Loan Payable Short Term & Long-Term Portion18:35
10467 Reversing Entry Loan Payable Short Term & Long-Term Portion08:23
10480 Financial Statements with Every Account18:53
10485 Balance Sheet Condensed Format22:12
10490 Income Statement Condensed Format27:43

Prior Year – Introduction1 lecture • 13min

IntroductionPreview13:22

Prior Year – Start a New Company File22 lectures • 4hr 7min

1 Start A New Business02:52
QuickBooks – 6.05 Set Up New Company & PreferencesPreview12:29
Excel Files 6.0500:14
Excel – 6.05 Set up New Company Worksheet14:22
QuickBooks – 6.10 Part 1 Item – Service Set UpPreview18:31
QuickBooks – 6.10 Part 2 Items Inventory Set Up28:55
Excel Files 6.1000:14
Excel 6.10 Set Up Inventory Items34:28
QuickBooks – 6.15 Customer Balance SetupPreview19:37
Excel Files 6.1500:14
Excel 6.15 Set Up Customer Balances13:52
QuickBooks – 6.20 Vendor – New Vendor & Opening BalancePreview07:28
Excel Files 6.2000:14
Excel 6.20 Set Up Vendors Beginning Balances12:44
QuickBooks – 6.25 Set up New Accounts & Export Trial Balance to Excel16:28
Excel Files 6.2500:14
Excel 6.25 Enter Opening Account Balances24:16
QuickBooks – 6.35 Payroll Options06:41
QuickBooks – 6.40 Set Up New Employees09:54
QuickBooks – 6.45 Transaction List by Date12:21
QuickBooks – 6.50 Adjusted Beginning Account Balances10:17
Accounting Comic Break00:14

Accounting Concepts3 lectures • 18min

Accounting Concepts01:27
Revenue Recognition Principle08:49
Financial Transaction Rules07:48

Enter Data for the first month of operations67 lectures • 12hr 44min

Enter Data for the First Month of Operations03:58
QuickBooks 7.05 Record Owner & Loan Deposit08:47
Excel Files 7.0500:14
Excel 7.05 Owner Deposit & Loan Deposit17:17
QuickBooks 7.10 Part 1 Record Purchase Furniture09:15
QuickBooks 7.10 Part 2 Record Short-Term Investment10:30
Excel Files 7.1000:14
Excel 7.10 Purchase Furniture & Record Investment19:59
QuickBooks 7.16 Sales Tax u12:08
QuickBooks 7.17 Part 1 Purchase Order09:34
QuickBooks 7.17 Part 2 Purchase Order Add Inventory Item08:10
QuickBooks 7.20 Part 1 Create Invoice with Inventory15:17
QuickBooks 7.20 Part 2 Invoice with Inventory13:13
Excel Files 7.2000:14
Excel 7.20 Part 1 Invoice Transaction30:00
Excel 7.20 Part Two Create on Invoice Transaction24:12
QuickBooks 7.23 Undeposited Funds Set Up03:29
QuickBooks 7.25 Part 1 Receive Payment f06:47
QuickBooks 7.25 Part 2 Receive Payment07:25
Excel Files 7.2500:14
Excel 7.25 Receive Payment Part 111:49
Excel 7.25 Receive Payment Part 210:12
Excel 7.25 Receive Payment Part 308:53
QuickBooks 7.30 Part 1 Sales Receipt f15:06
QuickBooks 7.30 Part 2 Sales Receipt11:00
Excel Files 7.3000:14
Excel 7.30 Cash Sales Transaction Part 123:45
Excel 7.30 Part 2 Cash Sales Service11:56
QuickBooks 7.32 Sales Receipt & Payment Correct10:40
QuickBooks 7.35 Deposit Record10:38
Excel Files 7.3500:14
Excel 7.35 Deposit Part 110:35
Excel 7.35 Deposit Part 212:53
QuickBooks 7.37 Expense Billable Setting Turn On03:11
Excel Files 7.4000:14
Excel 7.40 Part 1 Inventory Payment17:31
Excel 7.40 Part 2 Inventory Payment14:57
QuickBook 7.42 Correct Check Add Billable Customer09:15
QuickBooks 7.45 Part 1 Invoice Created by Billable Expense15:08
QuickBooks 7.45 Part 2 Invoice Populated By Billable Expense22:26
Excel Files 7.4500:14
Excel 7.45 Invoice for Preordered Item Part 125:24
Excel 7.45 Invoice for Preordered Item Part 223:02
QuickBooks 7.50 Receive Payment & Make Deposit11:29
Excel Files 7.5000:14
Excel 7.50 Receive Payment & Make Deposit19:59
QuickBooks 7.55 Write Checks for Expenses17:39
Excel Files 7.5500:14
Excel 7.55 Part 1 Write Check16:39
Excel 7.55 Part 2 Write Check Part 215:48
QuickBooks 7.60 Pay Bills09:08
Excel Files 7.6000:14
Excel 7.60 Pay Bills11:00
QuickBooks 7.65 Customer Jobs or Sub Customers04:40
Excel Files 7.6500:14
Excel 7.65 Customer Jobs05:19
QuickBooks 7.70 Pay Employees32:25
Excel Files 7.7000:14
Excel 7.70 Payroll33:28
QuickBooks 7.75 Job or Sub-Customer Sales Receipt09:14
Excel Files 7.7500:14
Excel 7.75 Job Sales Receipt09:39
QuickBooks 7.80 Generate Report & Export to Excel21:49
Excel Files 7.8000:14
Excel 7.80 Financial Statements & Reports40:44
Excel 7.90 Closing Process January27:04
Excel 7.92 Worksheet Month Two06:33

Enter Data for the second month of operation56 lectures • 11hr 42min

Enter Data for the Second Month of Operations03:42
QuickBooks 8.05 Loan Payments, Interest, Principle19:50
Excel Files 8.0500:14
Excel 8.05 Make Loan Payments29:16
QuickBooks 8.10 Short-Term Investment Deposit10:20
Excel Files 8.1000:14
Excel 8.10 Short Term Investment11:42
QuickBooks 8.15 Purchase Order New Item11:06
QuickBooks 8.20 Receive Inventory With Bill15:41
Excel Files 8.2000:14
Excel 8.20 Receive Inventory With Bill Part 115:39
Excel 8.20 Receive Inventory With Bill Part 215:41
QuickBooks 8.25 Sales Receipt & Deposit16:44
Excel Files 8.2500:14
Excel 8.25 Part 1 Sales Receipt & Deposit18:16
Excel 8.25 Part 2 Sales Receipt & Deposit06:53
QuickBooks 8.30 Advanced Payment From Customer10:40
Excel Files 8.3000:14
Excel 8.30 Advanced Payment From Customer12:03
QuickBooks 8.35 Apply Credit to Invoice16:48
Excel Files 8.3500:14
Excel 8.35 Apply Credit to Invoice21:39
QuickBooks 8.40 Record Sale on Account19:08
Excel Files 8.4000:14
Excel 8.40 Record Sales on Account32:33
QuickBooks 8.45 Advance Customer Payment09:11
QuickBooks 8.45 Bills – Track & Pay10:01
Excel Files 8.4500:14
Excel 8.45 Advance Customer Payment13:36
Excel Files 8.5000:14
Excel 8.50 Bills Track & Pay11:07
QuickBooks 8.55 Customer Payment On Account & Deposit14:09
Excel Files 8.5500:14
Excel 8.55 Customer Payment on Account19:14
QuickBooks 8.60 Sale Tax Payment14:07
Excel Files 8.6000:14
Excel 8.60 Pay Sales Tax10:16
QuickBooks 8.65 Payroll Tax Payments17:41
Excel Files 8.6500:14
Excel 8.65 Pay Payroll Tax10:21
QuickBooks 8.70 Enter Bills & Pay Bills24:56
Excel Files 8.7000:14
Excel 8.70 Enter Bills & Pay Bills31:43
QuickBooks 8.75 Enter Service Items & Invoice28:05
Excel Files 8.7500:14
Excel 8.75 Service Item & Invoices46:46
QuickBooks 8.77 Purchase Equipment with Debt11:21
Excel 8.77 Purchase Equipment with Debt10:36
QuickBooks 8.80 Payroll31:18
Excel Files 8.8000:14
Excel 8.80 Payroll35:31
QuickBooks 8.90 Rental Income Recorded16:05
Excel Files 8.9000:14
Excel 8.90 Rental Income08:16
QuickBooks 8.95 Comparative Financial Statements Feb29:51
Excel 8.95 Financial Statements06:40

Bank Reconciliations8 lectures • 2hr 38min

Adjusting Entries, Financial Statements, and Reversing Entries05:26
Bank Reconciliations03:28
QuickBooks 9.10 Bank Reconciliation First Month39:39
Excel 9.10 Bank Reconciliation January23:29
Excel 9.12 Bank Reconciliation Adjusting Entries January17:48
QuickBooks 9.15 Bank Reconciliation Second Month33:18
Excel 9.15 Bank Reconciliation February21:01
Excel 9.20 Bank Reconciliation Feb. Adjusting Entries14:16

Adjusting Entries, Financial Statements, Closing Entries, and Reversing Entries35 lectures • 6hr 34min

Adjusting Entries, Financial Statements, Closing Entries, and Reversing Entries05:26
QuickBooks 10.10 Short-term loan Adjusting Entry27:59
Excel Files 10.1000:14
Excel 10.10 Loan Payable Adjusting Entry Part 121:01
QuickBooks 10.15 Short-term portion of loan Adjusting Entry23:38
Excel Files 10.1500:14
Excel 10.15 Loan Payable Adjusting Entry Part 214:33
QuickBooks 10.20 Accrued Interest Adjusting entry14:18
Excel Files 10.2000:14
Excel 10.20 Accrued Interest Adjusting Entry09:25
QuickBooks 10.25 Invoice Adjusting Entry25:54
Excel Files 10.2500:14
Excel 10.25 Invoice Adjusting Entry13:57
QuickBooks 10.40 Prepaid Insurance Adjusting Entry13:37
Excel Files 10.4000:14
Excel 10.40 Prepaid Insurance Adjusting Journal Entry08:39
QuickBooks 10.45 Depreciation Adjusting Journal Entry18:35
Excel Files 10.4500:14
Excel Files 10.4510:53
QuickBooks 10.50 Unearned Revenue Adjusting Entry19:10
Excel Files 10.5000:14
Excel 10.50 Unearned Revenue Adjusting Entry10:43
QuickBooks 10.30 Reversing Entry Accrued Interest13:54
Excel Files 10.30000:14
Excel 10.300 Accrued Interest Reversing Entry10:20
QuickBooks 10.35 Reversing Entry Accounts Receivable20:34
Excel Files 10.35000:14
Excel 10.350 Accounts Receivable Reversing Entry13:21
QuickBooks 10.55 Reverse Unearned Revenue Adjusting Entry11:51
Excel Files 10.55000:14
Excel 10.550 Unearned Revenue Reversing Entry09:21
Excel Files 10.6000:14
Excel 10.60 Financial Statements45:31
Excel Files 10.6500:14
Excel 10.65 Closing Process February28:13

👇👇👇👇 Click Below to Enroll in Free Udemy Course Limited Enrolls 👇👇👇👇

Go to Course