get app

    QuickBooks Desktop vs. Excel

    BY
    Udemy

    Learn to perform business transactions using QuickBooks and Excel through Udemy.

    Brochure Enquire
    Mode

    Online

    Fees

    ₹ 2299

    Quick Facts

    particular details
    Medium of instructions English
    Mode of learning Self study
    Mode of Delivery Video and Text Based

    Course overview

    QuickBooks Desktop vs. Excel course is an online training programme created by Robert (Bob) Steele to introduce the learners to various aspects of QuickBooks and to help them explore the Excel accounting cycle, reporting financial transactions to both QuickBooks and Excel etc. The curriculum of the course taught by various experienced professionals like Certified Public Accountant and Chartered Global Management Accountant will shed light on numerous topics connected to QuickBooks such as accounting, Revenue Recognition Principle, Financial Transaction Rules, Accounting Method and many more. 

    Administered by Udemy, QuickBooks Desktop vs. Excel online course will expose the candidates to the accounting and business software and how they are applied for the functioning of the enterprises. At the end of QuickBooks Desktop vs. Excel certification, the learners will be conferred with the certificate that will help them to boost their chances of getting hired. The interested candidates can enrol in the programme by making the payment of Rs 3,599 and the early birds can have the advantage of a fee reduction. 

    The highlights

    •  Complete online course
    • Downloadable resources
    • Full lifetime access
    • Access on mobile and TV
    • Certificate of completion
    • English videos
    • 30-Day Money-Back Guarantee

    Program offerings

    • Full lifetime access
    • Access on mobile and tv
    • Certificate of completion
    • English videos
    • High-quality
    • Professional video lectures
    • 128.5 hours on-demand video
    • 331 downloadable resources

    Course and certificate fees

    Fees information
    ₹ 2,299
    certificate availability

    Yes

    certificate providing authority

    Udemy

    What you will learn

    Accounting proficiency Knowledge of excel

    By the end of  QuickBooks Desktop vs. Excel online certification, the students will be able to make a detailed knowledge of performing normal business transactions in QuickBooks, report creating in QuickBooks and Excel, Microsoft Excel, bank accounts reconciliation in QuickBooks and Excel and many more. 

    The syllabus

    2022 QuickBooks Pro Desktop Overview

    • QuickBooks Pro Plus Desktop 2022 New Stuff
    • Introduction

    OneNote Intro - Getting Started - QuickBooks Desktop 2022

    • 1009 QuickBooks Desktop Options
    • 1012 30 Day Free Trial or Purchase Process & Download from Intuit Website
    • 1015 Install QuickBooks Pro Plus Desktop
    • 1017 Increase Display Size

    Getting Started - QuickBooks Desktop 2022

    • 1009 QuickBooks Desktop Options
    • 1012 30 Day Free Trial or Purchase Process & Download from Intuit Website
    • 1015 Install QuickBooks Pro Plus Desktop
    • 1017 Increase Display Size

    Excel - Setup Worksheet

    • 1025 Create Accounting Worksheet Part 1
    • 1028 Create Accounting Worksheet Part 2
    • 1031 Create Accounting Worksheet Part 3
    • 1034 Create Accounting Worksheet Part 4
    • 1037 Create Accounting Worksheet Part 5
    • 1040 Create Accounting Worksheet Part 6
    • 1043 Create Accounting Worksheet Part 7
    • 1046 Create Accounting Worksheet Part 8
    • 1049 Create Accounting Worksheet Part 9
    • 1052 Create Accounting Worksheet Part 10
    • 1055 Create Accounting Worksheet Part 11

    OneNote Intro - Open Practice File-Review Home Page & Accounting Cycles 2022

    • 1020 Download & Open Sample File
    • 1080 Home Page Overview
    • 1100 Bank Feeds
    • 1120 Preferences

    Open Practice File-Review Home Page & Accounting Cycles 2022

    • 1020 Download & Open Sample File
    • 1080 Home Page Overview
    • 1100 Bank Feeds
    • 1120 Preferences
    • 1140 Vendors Section
    • 1160 Vendor Center
    • 1180 Bill Form
    • 1200 Pay Bills Form Check

    OneNote Intro-Vendor Cycle, Purchases Cycle, or Accounts Payable Cycle 2022

    • 1140 Vendors Section
    • 1160 Vendor Center
    • 1180 Bill Form
    • 1200 Pay Bills Form Check
    • 1220 Purchase Order Form - P.O.
    • 1240 Manage Sales Tax Form
    • 1260 Check Form
    • 1280 Void Check & Make Adjustment

    Vendor Cycle, Purchases Cycle, or Accounts Payable Cycle 2022

    • 1140 Vendors Section
    • 1160 Vendor Center
    • 1180 Bill Form
    • 1200 Pay Bills Form Check
    • 1220 Purchase Order Form - P.O.
    • 1240 Manage Sales Tax Form
    • 1260 Check Form
    • 1280 Void Check Prior Period Adjustment

    Excel-Vendor Cycle, Purchases Cycle, or Accounts Payable Cycle Transactions

    • 1180 Bill Form
    • 1200 Pay Bills Form Check
    • 1260 Check Form
    • 1280 Void Check Prior Period Adjustment

    One Note-Customer Cycle, Sales Cycle, or Accounts Receivable Cycle 2022

    • 1300 Customer Section Customer Cycle
    • 1320 Customer Center
    • 1340 Invoice Form
    • 1360 Receive Payment Form
    • 1380 Deposit Form
    • 1400 Sales Receipts Form
    • 1420 Credit Memo Refund Form & Bad Debt Expense
    • 1422 Credit Memo Form With Inventory

    Customer Cycle, Sales Cycle, or Accounts Receivable Cycle 2022

    • 1300 Customer Section Customer Cycle
    • 1320 Customer Center
    • 1340 Invoice Form
    • 1360 Receive Payment Form
    • 1380 Deposit Form
    • 1400 Sales Receipts Form
    • 1405 Barter Sale Transaction
    • 1407 Barter Sale Transaction #2 Invoice & Bill
    • 1420 Credit Memo Refund Form & Bad Debt Expense

    Excel-Customer Cycle, Sales Cycle, or Accounts Receivable Cycle Transactions

    • 1340 Invoice Form
    • 1360 Receive Payment Form
    • 1380 Deposit Form
    • 1400 Sales Receipts Form
    • 1420 Credit Memo Refund Form & Bad Debt Expense Service Item
    • 1488 Credit Memo with Inventory

    OneNote Intro-Other Home Page Items, Shortcuts, & Customizing Shortcuts 2022

    • 1440 Banking Section, Company Section & Shortcuts
    • 1460 Customize Shortcuts & Home Page Icons

    Other Home Page Items, Shortcuts, & Customizing Shortcuts 2022

    • 1440 Banking Section, Company Section & Shortcuts
    • 1460 Customize Shortcuts & Home Page Icons

    OneNote Intro-Employee Cycle - Payroll Cycle 2022

    • 1480 Employee Section Payroll Process
    • 1500 Employee Center
    • 1520 Pay Employees Form
    • 1540 Pay Payroll Liabilities Form
    • 1545 Process Payroll Forms

    Employee Cycle - Payroll Cycle 2022

    • 1480 Employee Section Payroll Process
    • 1500 Employee Center
    • 1520 Pay Employees Form
    • 1540 Pay Payroll Liabilities Form
    • 1545 Process Payroll Forms

    Excel-Employee Cycle-Payroll Cycle Transactions

    • 1520 Pay Employees Form
    • 1522 Pay Employees Form Part 2

    OneNote - List - Chat of Accounts & Items List 2022

    • 1560 Lists
    • 1580 Chart of Accounts
    • 1600 Item Lists

    List - Chat of Accounts & Items List 2022

    • 1560 Lists
    • 1580 Chart of Accounts
    • 1600 Item Lists

    OneNote - Help/Support, Reports Overview, & Backing Up Data File 2022

    • 1620 Help & Support Options
    • 1640 Reports Overview
    • 1660 Backup File

    Help/Support, Reports Overview, & Backing Up Data File 2022

    • 1620 Help & Support Options
    • 1640 Reports Overview
    • 1660 Backup File

    OneNote Intro-Balance Sheet Reports 2022

    • 2020 Balance Sheet Report Overview
    • 2040 Report Formatting Basics
    • 2045 Report Filters
    • 2060 Report Header & Footer Formatting
    • 2080 Report Fonts & Numbers Formatting
    • 2100 Comparative Balance Sheet Creation
    • 2120 Balance Sheet Vertical Analyses
    • 2140 Memorize Report Group Setup
    • 2160 Memorize Reports
    • 2180 Reports - Print, Save as PDF, Export to Excel Part 1
    • 2181 Export Balance Sheet to Excel

    Balance Sheet Reports 2022

    • 2020 Balance Sheet Report Overview
    • 2040 Report Formatting Basics
    • 2045 Report Filters
    • 2060 Report Header & Footer Formatting
    • 2080 Report Fonts & Numbers Formatting
    • 2100 Comparative Balance Sheet Creation
    • 2120 Balance Sheet Vertical Analyses
    • 2140 Memorize Report Group Setup
    • 2160 Memorize Reports
    • 2180 Reports - Print, Save as PDF, Export to Excel Part 1
    • 2181 Export Balance Sheet to Excel

    OneNote Intro-Income Statemen - Profit & Loss Reports 2022

    • 3020 Profit & Loss, P&L, Income Statement Overview
    • 3040 Comparative Profit & Loss, P&L, Income Statement
    • 3060 Vertical Analysis Profit Loss, P&L, Income Statement
    • 3080 Memorize Profit & Loss, P&L, Income Statement Reports
    • 3100 Print, Save as PDF, & Export to Excel Profit & Loss or Income Statement Rep
    • 3105 Export to Excel Profit & Loss or Income Statement Reports Part 2

    Income Statement - Profit & Loss Reports 2022

    • 3020 Profit & Loss, P&L, Income Statement Overview
    • 3040 Comparative Profit & Loss, P&L, Income Statement
    • 3060 Vertical Analysis Profit Loss, P&L, Income Statement
    • 3080 Memorize Profit & Loss, P&L, Income Statement Reports
    • 3100 Print, Save as PDF, & Export to Excel Profit & Loss or Income Statement Rep
    • 3105 Export to Excel Profit & Loss or Income Statement Reports Part 2

    OneNote Intro-Statement of Cash Flows & Supplemental Reports 2022

    • 4020 Statement of Cash Flows
    • 4040 Accounts Receivable Aging Reports
    • 4060 Accounts Payable Aging Reports
    • 4080 Sales by Customer & Income by Customer Reports
    • 4120 Form 1099 Report
    • 4140 Inventory Reports
    • 4160 Payroll & Employee Reports
    • 4180 Banking Reports
    • 4200 Transaction List by Date Report
    • 4220 Journal Report
    • 4240 Budget Reports
    • 4260 Accounts Receivable Graphs
    • 4280 Accounts Receivable Graphs Excel
    • 4300 Accounts Payable Graphs
    • 4305 Accounts Payable Graphs in Excel
    • 4320 Sales by Customer, Account, & Item Graphs
    • 4360 Income & Expense by Month Graph
    • 4380 Internal or External Report

    Statement of Cash Flows & Supplemental Reports 2022

    • 4020 Statement of Cash Flows
    • 4040 Accounts Receivable Aging Reports
    • 4060 Accounts Payable Aging Reports
    • 4080 Sales by Customer & Income by Customer Reports
    • 4120 Form 1099 Report
    • 4140 Inventory Reports
    • 4160 Payroll & Employee Reports
    • 4180 Banking Reports
    • 4200 Transaction List by Date Report
    • 4220 Journal Report
    • 4240 Budget Reports
    • 4260 Accounts Receivable Graphs
    • 4280 Accounts Receivable Graphs Excel

    OneNote - Start a New Company File in QuickBooks Pro 2022

    • 6010 Restore & Backup Data Files
    • 6040 Create a New Company File
    • 6060 Increase Size of Icons

    Start a New Company File in QuickBooks Pro 2022

    • 6010 Restore & Backup Data Files
    • 6040 Create a New Company File
    • 6060 Increase Size of Icons

    Excel-Create Worksheet for New Company Accounting Transactions

    • 6010 Set Up Excel Worksheet
    • 6012 Set Up Excel Worksheet #2
    • 6014 Set Up Excel Worksheet #3
    • 6016 Set Up Excel Worksheet #4

    OneNote - Company Preferences

    • 6080 Company Preferences Accounting
    • 6100 Company Preferences Bills, Calendar, & Checking
    • 6120 Company Preferences Desktop View, Finance Charge, & General
    • 6140 Company Preferences Integrated Application & Items & Inventory
    • 6160 Jobs & Estimates, Multiple Currencies, Payments, & Payroll
    • 6180 Company Preferences Reminders & Reports & Graphs
    • 6200 Company Preferences - Sales & Customers & Sales Tax
    • 6220 Company Preferences Search, Send Forms, Service Connection, Spelling, Tax 1

    Company Preferences

    • 6080 Company Preferences Accounting
    • 6100 Company Preferences Bills, Calendar, & Checking
    • 6120 Company Preferences Desktop View, Finance Charge, & General
    • 6140 Company Preferences Integrated Application & Items & Inventory
    • 6160 Jobs & Estimates, Multiple Currencies, Payments, & Payroll
    • 6180 Company Preferences Reminders & Reports & Graphs
    • 6200 Company Preferences Sales & Customers & Sales Tax
    • 6220 Company Preferences Search, Send Forms, Service Connection, Spelling, Tax 1

    OneNote - Adding Service Items & Inventory Items

    • 6240 Options for Interring Items, Customers & Vendors
    • 6260 Enter Service Items
    • 6280 Inventory Tracking Options
    • 6300 Set Up Inventory Items

    Adding Service Items & Inventory Items

    • 6240 Options for Interring Items, Customers & Vendors
    • 6260 Enter Service Items
    • 6280 Inventory Tracking Options
    • 6300 Set Up Inventory Items

    Excel-Adding Inventory Items & Related Inventory Account Balances

    • 6300 Inventory & Inventory Subsidiary Ledger

    OneNote - Sales Tax Setup, Add Customers, & Add Vendors

    • 6320 Sales Tax Set Up
    • 6340 New Customers Setup & Accounts Receivable Beginning Balances
    • 6360 New Vendors Setup & Accounts Payable Beginning Balances

    Sales Tax Setup, Add Customers, & Add Vendors

    • 6320 Sales Tax Set Up
    • 6340 New Customers Setup & Accounts Receivable Beginning Balances
    • 6360 New Vendors Setup & Accounts Payable Beginning Balances

    Excel-Add Customers, Add Vendors, & AR & AP Beginning Balances

    • 6340 Accounts Receivable & Subsidiary Ledger
    • 6360 Accounts Payable & Subsidiary Ledger
    • 6362 Financial Statements

    OneNote - Opening Balances, Adjustments to Equity, & Manual Payroll Setup

    • 6380 Add New Accounts & Opening Balances
    • 6400 Adjust Opening Balances
    • 6420 Set Up Manual Payroll
    • 6440 Generate Reports After Entering Beginning Balances

    Opening Balances, Adjustments to Equity, & Manual Payroll Setup

    • 6380 Add New Accounts & Opening Balances
    • 6400 Adjust Opening Balances
    • 6420 Set Up Manual Payroll
    • 6440 Generate Reports After Entering Beginning Balances

    Excel-Add Opening Account Balances

    • 6380 Add New Accounts & Opening Balances
    • 6383 Adjust Beginning Balances in Worksheet for Current Period Data Input

    OneNote-Month 1-Record Owner Investment, Purchase of Fixed Asset & Investment

    • 7020 Deposits Owner Investment & Loan
    • 7040 Purchase of Furniture & Investment Transactions

    Month 1-Record Owner Investment, Purchase of Fixed Asset & Investment 2022

    • 7020 Deposits Owner Investment & Loan
    • 7040 Purchase of Furniture & Investment Transactions

    Excel-Month 1-Record Owner Investment, Purchase of Fixed Assets & Inventory

    • 7020 Record Deposits from Owner and Loan
    • 7040 Purchase of Furniture & Investment Transactions

    OneNote-Month 1-Enter Purchase Order & Enter Check or Expense Form from PO 2022

    • 7060 Enter Purchase Order P.O.
    • 7080 Cash Payment for Inventory Linked to Purchase Order P.O.

    Month 1-Enter Purchase Order & Enter Check or Expense Form from PO 2022

    • 7060 Enter Purchase Order P.O.
    • 7080 Cash Payment for Inventory Linked to Purchase Order P.O.

    Excel-Month 1-Enter Transactions for Purchase of Inventory

    • 7080 Cash Payment for Inventory Linked to Purchase Order P.O.

    OneNote-Month 1 - Enter Invoice, Sales Receipt, & Deposits 2022

    • 7100 Invoice Selling Inventory
    • 7120 Receive Payment Transaction & Form
    • 7140 Sales Receipt Payment Received at Point of Sale
    • 7160 Deposits From Undeposited Funds

    Month 1 - Enter Invoice, Sales Receipt, & Deposits 2022

    • 7100 Invoice Selling Inventory
    • 7120 Receive Payment Transaction & Form
    • 7140 Sales Receipt Payment Received at Point of Sale
    • 7160 Deposits From Undeposited Funds

    Excel-Month 1-Enter Transactions for Sale of Inventory & Deposits

    • 7100 Invoice Selling Inventory
    • 7120 Receive Payment From Previous Invoice
    • 7140 Sales Receipt Payment Received at Point of Sale
    • 7160 Deposits From Undeposited Funds

    OneNote-Month 1-Enter Invoice, Receive Payment, Bill 2022

    • 7180 Invoice Created From Check Created From Purchase Order
    • 7200 Receive Payment & Make Deposit
    • 7220 Write Checks for Expenses & Prepaid Assets
    • 7240 Bill Pay

    Month 1-Enter Invoice, Receive Payment, Bill 2022

    • 7180 Invoice Created From Check Created From Purchase Order
    • 7200 Receive Payment & Make Deposit
    • 7220 Write Checks for Expenses & Prepaid Assets
    • 7240 Bill Pay

    Excel-Month 1-Enter Transaction for Sale of Inventory, Receive Payments, & Bill

    • 7180 Invoice Created From Check Created From Purchase Order
    • 7200 Receive Payment & Make Deposit
    • 7220 Write Checks for Expenses & Prepaid Assets
    • 7240 Bill Pay

    OneNote-Month 1-Create Customer Job, Pay Employees, & Create Sales Receipt for j

    • 7260 Customer Jobs
    • 7280 Pay Employees
    • 7282 Change Payroll Item for Payroll Taxes
    • 7300 Enter Billable Time & Add to Invoice for Job

    Month 1 - Create Customer Job, Pay Employees, & Create Sales Receipt for job

    • 7260 Customer Jobs
    • 7280 Pay Employees
    • 7282 Change Payroll Item for Payroll Taxes
    • 7300 Enter Billable Time & Add to Invoice for Job

    Excel-Month 1-Transactions for Payroll & Create Sales Receipt

    • 7280 Pay Employees
    • 7281 Pay Employees Part 2
    • 7300 Enter Billable Time & Add to Invoice
    • 7301 Enter Billable Expenses to Invoice

    OneNote- Month One Reports

    • 7320 Month One Report

    Month One Reports

    • 7320 Month One Report

    Excel-Month 1-Create Financial Statements

    • 7320 Month One Financial Statements

    OneNote-Month 2–Enter Loan Payments, Create Amortization Tables, & Investment

    • 8020 Make Amortization Table
    • 8022 Make Loan Payments
    • 8040 Short Term Investment Sales & Gains
    • 8060 Change Account Categorization to Other Expense

    Month 2-Enter Loan Payments, Create Amortization Tables, & Investment 2022

    • 8020 Make Amortization Table
    • 8022 Make Loan Payments
    • 8040 Short Term Investment Sales & Gains
    • 8060 Change Account Categorization to Other Expense

    Excel-Month 2-Enter Loan Transaction, Create Amortization Table, & Investment

    • 8005 Format Worksheet for New Month
    • 8020 Make Amortization Table
    • 8022 Make Loan Payments
    • 8040 Short Term Investment Sales & Gains

    OneNote-Month 2 – Enter Purchase Order, Sales Receipt, Bill for Inventory 2022

    • 8080 Purchase Order Adding New Items
    • 8120 Sales Receipt & Deposit
    • 8122 Record Receipt of Inventory with Bill Linked to P.O.

    Month 2 – Enter Purchase Order, Sales Receipt, Bill for Inventory

    • 8080 Purchase Order Adding New Items
    • 8120 Sales Receipt & Deposit
    • 8122 Record Receipt of Inventory with Bill Linked to P.O.

    Excel-Month 2-Enter Sale, Cash Received at Same Time & Bills for Inventory

    • 8120 Sales Receipt & Deposit
    • 8122 Record Receipt of Inventory with Bill Linked to P.O.

    OneNote-Month 2 – Invoice from Billable Item, Advanced Customer Deposit 2022

    • 8130 Populate Invoice Using Billable Item That was Created From P.O.
    • 8140 Advanced Customer Payment or Unearned Revenue Method 1
    • 8160 Apply Customer Deposit (Credit) to Invoice
    • 8200 Advanced Customer Payment or Unearned Revenue Method 2

    Month 2 – Invoice from Billable Item, Advanced Customer Deposit 2022

    • 8130 Populate Invoice Using Billable Item That was Created From P.O.
    • 8140 Advanced Customer Payment or Unearned Revenue Method 1
    • 8160 Apply Customer Deposit (Credit) to Invoice
    • 8200 Advanced Customer Payment or Unearned Revenue Method 2

    Excel-Month 2-Invoices for Service Sales & Advanced Customer Deposit

    • 8130 Populate Invoice Using Billable Item That was Created From P.O.
    • 8140 Advanced Customer Payment or Unearned Revenue Method 1
    • 8160 Apply Customer Deposit (Credit) to Invoice
    • 8200 Advanced Customer Payment or Unearned Revenue Method 2

    OneNote-Month 2 – Invoicing for Hourly Service 2022

    • 8320 Bill for Hourly Services of Staff Set up Items & Enter Billable Time
    • 8322 Create Invoices Using Billable Time

    Month 2 – Invoicing for Hourly Service 2022

    • 8320 Bill for Hourly Services of Staff Set up Items & Enter Billable Time
    • 8322 Create Invoices Using Billable Time

    Excel-Month 2-Transaction for Billable Time

    • 8320 Bill for Hourly Services of Staff Set up Items & Enter Billable Time
    • 8322 Create Invoices Using Billable Time

    OneNote-Month 2 – Invoicing for Rental Income with Advanced Customer Deposit

    • 8340 Rental Income Set Up Items
    • 8342 Rental Income Customer Deposit
    • 8344 Rental Income Estimate & Invoice

    Month 2 – Invoicing for Rental Income with Advanced Customer Deposit 2022

    • 8340 Rental Income Set Up Items
    • 8342 Rental Income Customer Deposit
    • 8344 Rental Income Estimate & Invoice

    Excel-Month 2-Rental Income Transaction & Advanced Customer Deposit

    • 8342 Rental Income Customer Deposit
    • 8344 Rental Income Estimate & Invoice

    OneNote-Month 2 – Purchase & Finance Equipment & Recategorize Fixed Assets 2022

    • 8360 Purchase & Finance Equipment
    • 8362 Subaccounts Categories For Fixed Assets

    Month 2 – Purchase & Finance Equipment & Recategorize Fixed Assets 2022

    • 8360 Purchase & Finance Equipment
    • 8362 Subaccounts Categories For Fixed Assets

    Excel-Month 2-Purchase & Finance Equipment

    • 8360 Purchase & Finance Equipment
    • 8362 Subaccounts Categories For Fixed Assets

    OneNote-Month 2 – Enter & Pay Month End Pills & Pay Sales Tax 2022

    • 8365 Bills - Enter, Sort, & Pay
    • 8370 Pay Sales Tax

    Month 2 – Enter & Pay Month End Bills & Pay Sales Tax 2022

    • 8365 Bills - Enter, Sort, & Pay
    • 8370 Pay Sales Tax

    Excel-Month 2-Enter & Pay Month End Bills & Pay Sales Tax

    • 8365 Bills - Enter, Sort, & Pay
    • 8370 Pay Sales Tax

    OneNote-Month 2 – Enter Payroll & Pay Payroll Tax for Prior Period 2022

    • 8380 Enter Payroll For Second Month
    • 8385 Pay Payroll Taxes

    Month 2 – Enter Payroll & Pay Payroll Tax for Prior Period 2022

    • 8380 Enter Payroll For Second Month
    • 8385 Pay Payroll Taxes

    Enter-Month 2-Enter Payroll & Pay Payroll Tax for Prior Period

    • 8380 Enter Payroll For Second Month Part 1
    • 8381 Enter Payroll For Second Month Part 2
    • 8385 Pay Payroll Taxes

    OneNote-Month 2 – Generate Month End Report & Review Work

    • 8420 Create Reports After Second Month of Data Input

    Month 2 – Generate Month End Report & Review Work

    • 8420 Create Reports After Second Month of Data Input

    Excel-Month 2-Financial Statements

    • 8420 Create Reports After Second Month of Data Input YTD
    • 8421 Create Reports After Second Month of Data Month of February Only

    OneNote-Bank Reconciliations 2022

    • 9020 Bank Reconciliation Myth Busting
    • 9040 Bank Reconciliation Month One Overview
    • 9060 Bank Reconciliation Month #1 Deposits
    • 9080 Bank Reconciliation Month #1 Checks & Cash Decreases
    • 9100 Bank Reconciliation Opening Balance Problem
    • 9120 Bank Reconciliation Reports Month # 1
    • 9140 Bank Reconciliation Month #2 Deposits
    • 9145 Bank Reconciliation Month #2 Checks & Account Decreases
    • 9160 Bank Reconciliation Month #2 Reports

    Bank Reconciliations 2022

    • 9020 Bank Reconciliation Myth Busting
    • 9040 Bank Reconciliation Month One Overview
    • 9060 Bank Reconciliation Month #1 Deposits
    • 9080 Bank Reconciliation Month #1 Checks & Cash Decreases
    • 9100 Bank Reconciliation Opening Balance Problem
    • 9120 Bank Reconciliation Reports Month # 1
    • 9140 Bank Reconciliation Month #2 Deposits
    • 9145 Bank Reconciliation Month #2 Checks & Account Decreases
    • 9160 Bank Reconciliation Month #2 Reports

    Excel-Bank Reconciliation

    • 9040 Bank Reconciliation Month One Part 1
    • 9041 Bank Reconciliation Month One Part 2
    • 9042 Bank Reconciliation Month One Part 3
    • 9140 Bank Reconciliation Month Two Part 1
    • 9141 Bank Reconciliation Month Two Part 2
    • 9143 Bank Reconciliation Month Two Part 3

    Adjusting & Reversing Entries 2022

    • 10120 Adjusting Entries & Reversing Entries Introduction
    • 10180 Adjusting Entry Accrued Interest
    • 10220 Reversing Entry Accrued Interest
    • 10260 Adjusting Entry Accounts Receivable Sales
    • 10300 Reversing Entry Accounts Receivable Sales
    • 10340 Adjusting Entry Prepaid Insurance
    • 10380 Adjusting Entry Depreciation
    • 10400 Adjusting Entry Unearned Revenue Customer Deposit
    • 10460 Reversing Entry Unearned Revenue Customer Deposit
    • 10465 Adjusting Entry Loan Payable Short-Term and Long-Term Portions
    • 10467 Reversing Entry Loan Payable Short-Term and Long-Term Portions
    • 10480 Adjusting Entry & Reversing Entry Journal Reports

    Excel-Adjusting Entries

    • 10175 Adjust Worksheet for Adjusting Entries
    • 10180 Adjusting Entry Accrued Interest Part 1
    • 10182 Adjusting Entry Accrued Interest Part 2
    • 10220 Reversing Entry Accrued Interest
    • 10260 Adjusting Entry Accounts Receivable Sales
    • 10300 Reversing Entry Accounts Receivable Sales
    • 10340 Adjusting Entry Prepaid Insurance
    • 10380 Adjusting Entry Depreciation
    • 10400 Adjusting Entry Unearned Revenue Customer Deposit
    • 10460 Reversing Entry Unearned Revenue Customer Deposit
    • 10465 Adjusting Entry Loan Payable Short Term & Long-Term Portion
    • 10467 Reversing Entry Loan Payable Short Term & Long-Term Portion
    • 10480 Financial Statements with Every Account
    • 10485 Balance Sheet Condensed Format
    • 10490 Income Statement Condensed Format

    Introduction Prior Years

    • Introduction - Course Overview

    Start a New Company File

    • Start a New Company File Section Overview
    • PDF 6.05
    • QuickBooks 6.05 Set Up New Company & Preferences
    • Excel Files 6.05
    • Excel 6.05 Set up New Company Worksheet
    • PDF 6.10
    • QuickBooks Backup File
    • QuickBooks 6.10 Setting Up Items
    • Excel Files 6.10
    • Excel 6.10 Set Up Inventory Items
    • PDF 6.15
    • QuickBooks 6.15 Customer Setup
    • Excel Files 6.15
    • Excel 6.15 Set Up Customer Balances
    • PDF 6.20
    • QuickBooks 6.20 Set up Vendors and Beginning Balances
    • Excel Files 6.20
    • Excel 6.20 Set Up Vendors Beginning Balances
    • PDF 6.25
    • QuickBooks Backup File
    • QuickBooks 6.25 Set up new account & Enter Opening Balances
    • Excel Files 6.25
    • Excel 6.25 Enter Opening Account Balances
    • PDF 6.30
    • QuickBooks 6.30 Adjust New Account Balances
    • PDF 6.35
    • QuickBooks 6.35 Payroll Set Up
    • PDF 6.40
    • QuickBooks 6.40 New Employee Setup
    • QuickBooks 6.45 Export Transaction List By Date
    • Accounting Comic Break

    Accounting Concepts

    • Accounting Concepts Section Overview
    • Cash Method Vs Accrual Method
    • Revenue Recognition Principle
    • Financial Transaction Rules

    Enter Data for the First Month of Operations

    • Enter Data for the First Month of Operations Section Overview
    • PDF 7.05
    • QuickBooks Backup File
    • QuickBooks 7.05 Record Deposit from Owner & Loan
    • Excel 7.05 Owner Deposit & Loan Deposit
    • PDF 7.10
    • QuickBooks 7.10 Record Transactions In Register Investment & Furniture
    • Excel 7.10 Purchase Furniture & Record Investment
    • PDF 7.17
    • QuickBooks 7.17 Purchase Order
    • PDF 7.20
    • QuickBooks 7.20 Create an Invoice
    • Excel Files 7.20
    • Excel 7.20 Part 1 Invoice Transaction
    • Excel 7.20 Part Two Create on Invoice Transaction
    • PDF 7.25
    • QuickBooks 7.25 Record Receipt of Payment
    • Excel Files 7.25
    • Excel 7.25 Receive Payment Part 1
    • Excel 7.25 Receive Payment Part 2
    • Excel 7.25 Receive Payment Part 3
    • PDF 7.30
    • QuickBooks Backup File
    • QuickBooks 7.30 Sales Receipts Cash Sales Transaction
    • Excel Files 7.30
    • Excel 7.30 Cash Sales Transaction Part 1
    • Excel 7.30 Part 2 Cash Sales Service
    • PDF 7.35
    • QuickBooks 7.35 Deposit
    • Excel Files 7.35
    • Excel 7.35 Deposit Part 1
    • Excel 7.35 Deposit Part 2
    • PDF 7.40
    • QuickBooks 7.40 Write Check for Inventory from Purchase Order
    • Excel Files 7.40
    • Excel 7.40 Part 1 Inventory Payment
    • Excel 7.40 Part 2 Inventory Payment
    • PDF 7.45
    • QuickBooks 7.45 Invoice for Pre-Order Inventory P.O.
    • Excel Files 7.45
    • Excel 7.45 Invoice for Preordered Item Part 1
    • Excel 7.45 Invoice for Preordered Item Part 2
    • PDF 7.50
    • QuickBooks 7.50 Receive Payment & Make Deposit
    • Excel Files 7.50
    • Excel 7.50 Receive Payment & Make Deposit
    • PDF 7.55
    • QuickBooks 7.55 Write Check for Expenses
    • Excel Files 7.55
    • Excel 7.55 Part 1 Write Check
    • Excel 7.55 Part 2 Write Check Part 2
    • PDF 7.60
    • QuickBooks 7.60 Pay Bills
    • Excel Files 7.60
    • Excel 7.60 Pay Bills
    • PDF 7.65
    • QuickBooks 7.65 Set Up Customer Jobs
    • Excel Files 7.65
    • Excel 7.65 Customer Jobs
    • PDF 7.70
    • QuickBooks 7.70 Payroll Process Check
    • Excel Files 7.70
    • Excel 7.70 Payroll
    • PDF 7.75
    • QuickBooks Backup File
    • QuickBooks 7.75 Job Sales Receipt
    • Excel Files 7.75
    • Excel 7.75 Job Sales Receipt
    • PDF 7.80
    • QuickBooks 7.80 Review Reports & Export to Excel
    • Excel Files 7.80
    • Excel 7.80 Financial Statements & Reports
    • Excel Files 7.90
    • Excel 7.90 Closing Process January
    • Excel Files 7.92
    • Excel 7.92 Worksheet Month Two

    Enter Data for the Second Month of Operation

    • Enter Data for the Second Month of Operation Section Overview
    • PDF 8.05
    • QuickBooks Backup File
    • QuickBooks 8.05 Loan Payments, Interest, Principle
    • Excel Files 8.05
    • Excel 8.05 Make Loan Payments
    • PDF 8.10
    • QuickBooks 8.10 Deposit Investment & Interest
    • Excel Files 8.10
    • Excel 8.10 Short Term Investment
    • PDF 8.15
    • QuickBooks 8.15 Purchase Order New Item & Customer
    • PDF 8.20
    • QuickBooks 8.20 Receive Inventory with Bill
    • Excel Files 8.20
    • Excel 8.20 Receive Inventory With Bill Part 2
    • PDF 8.25
    • QuickBooks 8.25 Sales Receipt & Deposit
    • Excel Files 8.25
    • Excel 8.25 Sales Receipt & Deposit
    • Excel 8.25 Part 2 Sales Receipt & Deposit
    • PDF 8.30
    • QuickBooks 8.30 Advanced Payment From Customer
    • Excel Files 8.30
    • Excel 8.30 Advanced Payment From Customer
    • PDF 8.35
    • QuickBooks 8.35 Apply Credit to Invoice
    • Excel Files 8.35
    • Excel 8.35 Apply Credit to Invoice
    • PDF 8.40
    • QuickBooks 8.40 Record Sale on Account
    • Excel Files 8.40
    • Excel 8.40 Record Sales on Account
    • PDF 8.45
    • QuickBooks 8.45 Advance Customer Payment
    • Excel Files 8.45
    • Excel 8.45 Advance Customer Payment
    • PDF 8.50
    • QuickBooks 8.50 Bills Track & Pay
    • Excel Files 8.50
    • Excel 8.50 Bills Track & Pay
    • PDF 8.55
    • QuickBooks Backup File
    • QuickBooks 8.55 Customer Payment on Account & Deposit
    • Excel Files 8.55
    • Excel 8.55 Customer Payment on Account
    • PDF 8.60
    • QuickBooks 8.60 Pay Sales Tax
    • Excel Files 8.60
    • Excel 8.60 Pay Sales Tax
    • PDF 8.65
    • QuickBooks 8.65 Pay Payroll Taxes
    • Excel Files 8.65
    • Excel 8.65 Pay Payroll Tax
    • PDF 8.70
    • QuickBooks 8.70 Enter Bills & Pay Bills
    • Excel Files 8.70
    • Excel 8.70 Enter Bills & Pay Bills
    • PDF 8.75
    • QuickBooks 8.75 Enter Service Item & Invoices
    • Excel Files 8.75
    • Excel 8.75 Service Item & Invoices
    • PDF 8.77
    • QuickBooks 8.77 Purchase Equipment with Debt
    • Excel Files 8.77
    • Excel 8.77 Purchase Equipment with Debt
    • PDF 8.80
    • QuickBooks 8.80 Enter Payroll
    • Excel Files 8.80
    • Excel 8.80 Payroll
    • PDF 8.90
    • QuickBooks 8.90 Rental Income, New Account, New Item
    • Excel Files 8.90
    • Excel 8.90 Rental Income
    • PDF 8.95
    • QuickBooks 8.95 Comparative Balance Sheet & Income Statement
    • Excel Files 8.95
    • Excel 8.95 Financial Statements

    Bank Reconciliations

    • Bank Reconciliations Section Overview
    • PDF 9.10
    • QuickBooks 9.10 Bank Reconciliation First Bank Reconciliation
    • Excel Files 9.10
    • Excel 9.10 Bank Reconciliation January
    • Excel 9.12 Bank Reconciliation Adjusting Entries January
    • PDF 9.15
    • QuickBooks 9.15 Bank Reconciliation Second Bank Reconciliation
    • Excel Files 9.15
    • Excel 9.15 Bank Reconciliation February
    • Excel 9.20 Bank Reconciliation Feb. Adjusting Entries

    Adjusting Entries, Financial Statements, Closing Entries, and Reversing Entries

    • Adjusting Entries, Financial Statements, Closing Entries, and Reversing Entries
    • PDF 10.10
    • QuickBooks 10.10 Short term loan Adjusting Entry
    • Excel Files 10.10
    • Excel 10.10 Loan Payable Adjusting Entry Part 1
    • PDF 10.15
    • QuickBooks 10.15 Short term portion of loan Adjusting Entry
    • Excel Files 10.15
    • Excel 10.15 Loan Payable Adjusting Entry Part 2
    • PDF 10.20
    • QuickBooks 10.20 Accrued Interest Adjusting entry
    • Excel Files 10.20
    • Excel 10.20 Accrued Interest Adjusting Entry
    • PDF 10.25
    • QuickBooks 10.25 Invoice Adjusting Entry
    • Excel Files 10.25
    • Excel 10.25 Invoice Adjusting Entry
    • PDF 10.40
    • QuickBooks 10.40 Prepaid Insurance Adjusting Entry
    • Excel Files 10.40
    • Excel 10.40 Prepaid Insurance Adjusting Journal Entry
    • PDF 10.45
    • QuickBooks 10.45 Depreciation Adjusting Journal Entry
    • Excel Files 10.45
    • Excel 10.45 Depreciation Adjusting Entry
    • PDF 10.50
    • QuickBooks 10.50 Unearned Revenue Adjusting Entry
    • Excel Files 10.50
    • Excel 10.50 Unearned Revenue Adjusting Entry
    • QuickBooks 10.30 Reversing Entry Accrued Interest
    • Excel Files 10.300
    • Excel 10.300 Accrued Interest Reversing Entry
    • PDF 10.35
    • QuickBooks 10.35 Reversing Entry Accounts Receivable
    • Excel Files 10.350
    • Excel 10.350 Accounts Receivable Reversing Entry
    • PDF 10.55
    • QuickBooks 10.55 Reverse Unearned Revenue Adjusting Entry
    • Excel Files 10.550
    • Excel 10.550 Unearned Revenue Reversing Entry
    • PDF 10.60
    • QuickBooks 10.60 Journal Report & Financial Statements
    • Excel Files 10.60
    • Excel 10.60 Financial Statements
    • Excel Files 10.65
    • Excel 10.65 Closing Process February

    Instructors

    Mr Robert (Bob) Steele
    Instructor
    Freelancer

    Other Bachelors, M.S

    Trending Courses

    Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

    Popular Courses

    General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Data Science Courses Cyber Security Courses Programming Courses Digital Marketing Courses Law Courses Leadership Courses Explore all courses

    Popular Platforms

    upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses IIT Kharagpur Courses Emeritus Courses IIT Kanpur Courses NPTEL Courses Explore all platforms

    Learn more about the Courses

    10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management
    Providers
    Close

    Download the Careers360 App on your Android phone

    Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

    Careers360 App
    150M+ Students
    30,000+ Colleges
    500+ Exams
    1500+ E-books