Xero Accounting Software
All LevelsFinance & AccountingXero

Xero Accounting Software

Become an Expert in Xero Accounting Software: From Basics to Comprehensive Data Analysis

Created by Robert (Bob) Steele
81.5 hours
Video Content
330
Lectures
49,361
Students
4.4
Rating
4.4
(49,361 students enrolled)

What you'll learn

Recall the basic functionalities of Xero accounting software and demonstrate proficiency in navigating its user interface.
Apply the steps involved in the purchasing, downloading, and installation process of Xero software.
Analyze the major components of Xero software, including customer, vendor, and employee sections, and understand their role in the accounting cycles.
Evaluate the impact of various forms and transactions within each accounting section on the financial statements.
Demonstrate the ability to enter and process standard types of transactions, such as invoices, bills, pay bills, purchase orders, and deposits.
Synthesize the learned concepts and techniques by working through a comprehensive problem that covers two months of data input.
Interpret the financial statements generated in Xero software and verify the accuracy of the data input by checking the impact of each transaction on them
Modify system settings in Xero to streamline data entry and enhance the efficiency of the accounting process.
Communicate effectively about the functionality and capabilities of Xero accounting software, demonstrating proficiency in explaining its benefits.

Course Content

63 sections • 330 lectures • 81:31:02 total length

2023-2022 Getting Started and Set Up

3 lectures • 37:45

1012 30 Day Free Trial & Purchase Options07:08
1080 Dashboard17:58
1100 Bank Feeds12:39

2023-2022 Vendor, Accounts Payable, Expenses, or Purchases Cycle

9 lectures • 02:28:41

Data Files00:00
1140 Vendor, Expense, or Payments Cycle15:18
1160 Bills To Pay and Suppliers25:46
1180 Bill Form18:18
1200 Payment Form to Pay Bill21:52
+4 more lectures

2023-2022 Customer Cycle , Sales Cycle, or Accounts Receivable Cycle

8 lectures • 02:21:36

1300 Customer, Revenue, or Account Receivable Cycle10:27
1320 Invoice Center & Customer Information16:36
1340 Invoice Form21:25
1360 Receive Payment on Invoice18:56
1380 Receive Money or Deposit Form18:40
+3 more lectures

2023 Employee Cycle Overview

1 lectures • 13:57

1480 Payroll Overview13:57

2023 Lists-Chart of Accounts & Products & Services Lists

2 lectures • 34:45

1580 Chart of Accounts16:54
1600 Products & services17:51

2023 Reports Overview

1 lectures • 33:21

1640 Reports Overview33:21

2023 Balance Sheet Reports

6 lectures • 01:35:57

2020 Balance Sheet Report Overview18:00
2040 Report Formatting Basics20:37
2100 Comparative Balance Sheet Creation14:39
2120 Balance Sheet Vertical Analyses09:48
2180 Reports - Print, Save as PDF, & Organize17:55
+1 more lectures

2023 Profit & Loss / Income Statement

5 lectures • 01:05:34

3020 Profit & Loss, P&L, Income Statement Overview17:15
3040 Comparative Profit & Loss, P&L, Income Statement11:09
3060 Vertical Analysis Profit Loss, P&L, Income Statement08:05
3100 Print, Save as PDF, & Organize Profit & Loss or Income Statement Reports13:37
3105 Export to Excel Profit & Loss or Income Statement Reports15:28

2023 Statement of Cash Flows & Supplemental Reports

14 lectures • 03:37:46

4020 Statement of Cash Flows18:05
4040 Accounts Receivable Aging Reports12:54
4060 Accounts Payable Aging Reports.10:38
4065 1099 Reports14:33
4080 Sales by Customer & Sales by Item14:40
+9 more lectures

2023 Start a New Company File

4 lectures • 24:15

Data Files to Download00:01
6010 Comprehensive Practice Problem Introduction04:49
6040 Free 30 Day Trial08:22
6060 Navigation Overview & Company Setting11:03

2023 Company Preferences & Settings

2 lectures • 34:31

6080 Settings - Profile & General17:05
6100 Organization Settings - Features17:26

2023 Adding Service Items & Inventory Items

4 lectures • 01:17:09

6240 Entering Beginning Balances, Customers, Vendors, & Items Overview14:56
6260 Enter Service Items19:39
6280 Inventory Tracking Options13:48
6300 Set Up Inventory Items28:46

2023 Sales Tax Setup, Add Customers, & Add Vendors

3 lectures • 57:54

6320 Sales Tax Set Up15:27
6340 New Customers Setup & Accounts Receivable Beginning Balances28:17
6360 New Vendors Setup & Accounts Payable Beginning Balances14:10

2023 Opening Balances, Adjustments to Equity, & Manual Payroll Setup

4 lectures • 01:19:20

6380 Add New Accounts & Opening Balances26:07
6400 Adjust Opening Balances17:28
6420 Payroll Set up15:12
6440 Generate Reports After Entering Beginning Balances20:33

2023 Month 1-Record Short-Term Investment & Purchase of Fixed Asset for Cash

4 lectures • 01:00:02

Data Files to Download00:01
7020 Deposits - Owner Investment & Loan20:50
7040 Record Investment19:31
7043 Purchase of Fixes Assets19:40

2023 Month 1-Enter Purchase Order & enter check or Expense Form from P.O.

3 lectures • 56:10

7060 Enter Purchase Order P.O.16:42
7080 Payment for Inventory Linked to Purchase Order P.O.28:41
7083 Transaction Correction10:47

2023 Month 1-Enter Invoice, Sales Receipt, & Deposit

4 lectures • 01:27:48

7100 Invoice Selling Inventory26:11
7120 Receive Payment Or Deposit From Invoice25:57
7140 Receive Money Form Payment Received at Point of Sale20:56
7160 Deposits From Cash Clearing Account14:44

2023 Month 1-Enter Invoice, Receive Payment, & Bill

4 lectures • 01:32:44

7180 Invoice Selling Inventory Created from a Spend Money Form with Assigned Exp28:34
7200 Receive Payment From Invoice & Make Deposit17:27
7220 Write Checks for Expenses & Prepaid Assets30:31
7240 Bill Pay16:12

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

4 lectures • 01:45:51

7260 Projects Set Up16:40
7280 Pay Employees34:58
7300 Enter Billable Time to Projects & Invoice29:32
7310 Assign Expenses to a Customer or Project24:41

2023-Month 1 Reports

2 lectures • 59:10

7320 Month One Reports30:15
7325 Bundle Month One reports for a Client28:55

2023 Month 2-Enter Loan Payments, Create Amortization Tables, & Investments

5 lectures • 01:14:47

Data Files to Download00:01
8020 Make Amortization Table25:21
8022 Make Loan Payments17:40
8040 Short Term Investment Sales & Gains18:27
8060 Change Account Categorization to Other Expense13:18

2023 Month 2-Enter Purchase Order, Sales Receipt, & Bill for Inventory

3 lectures • 49:21

8080 Purchase Order Adding New Items08:57
8120 Receive Money Sales Receipt & Deposit25:34
8122 Record Receipt of Inventory with Bill Linked to P.O.14:50

2023 Month 2-Invoice from Billable Item, Advanced Customer Deposit

4 lectures • 01:17:23

8130 Populate Invoice Using Information From Purchase Order P.O.13:08
8140 Advanced Customer Payment or Unearned Revenue20:28
8160 Apply Customer Deposit (Credit) to Invoice21:17
8200 Quote or Estimate & Advanced Customer Payment or Unearned Revenue22:30

2023 Month 2-Invoicing for Hourly Service

2 lectures • 46:35

8320 Bill for Hourly Services of Staff, Set up Items, & Enter Billable Time23:56
8322 Create Invoices for Projects Using Billable Time22:39

2023 Month 2-Invoicing for Rental Income with Advanced Customer Deposit

3 lectures • 51:46

8340 Rental Income Set Up Items15:10
8342 Rental Estimate & Customer Deposit16:52
8344 Rental Income Invoice from Estimate or Quote & Customer Credit Applied19:44

2023 Month 2-Purchase & Finance Equipment & Recategorize Fixed Assets

2 lectures • 42:18

8360 Purchase & Finance Equipment & Organize Multiple Loan Accounts24:08
8362 Organize Fixed Asset Account Categories18:10

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

2 lectures • 42:21

8365 Bills - Enter, Sort, & Pay25:22
8370 Pay Sales Tax16:59

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

2 lectures • 49:22

8380 Enter Payroll For Second Month28:19
8385 Pay Payroll Taxes21:03

2023 Month 2-Generate Month End Reports & Review Work

1 lectures • 32:45

8420 Create Reports After Second Month of Data Input32:45

2023 Bank Reconciliations

11 lectures • 03:20:13

Data Files to Download00:01
9020 Bank Reconciliation Myth Busting21:07
9040 Bank Reconciliation Month One Overview19:26
9060 Bank Reconciliation Month #1 Deposits23:00
9065 Manually Import Bank Data18:14
+6 more lectures

2023 Adjusting & Reversing Entries

12 lectures • 04:03:39

Data Files to Download00:01
10120 Adjusting Entries & Reversing Entries Introduction32:15
10180 Adjusting Entry Accrued Interest23:51
10220 Reversing Entry Accrued Interest23:19
10260 Adjusting Entry Accounts Receivable Sales29:12
+7 more lectures

2023 Budgeting

6 lectures • 01:20:13

Data Files to Download00:01
11100 Budgeting Overview11:17
11120 Budgeted Income Statement Export to Excel & Modify Part 110:22
11122 Budgeted Income Statement Export to Excel & Modify Part 224:28
11140 Budgeted Income Statement Data Input18:06
+1 more lectures

2023 Bank Feeds

34 lectures • 11:26:09

Data Files to Download00:01
305 Setup Bank Feed Test Company File With 30 Day Free Trial09:11
308 Delete Excess General Ledger Accounts18:26
315 How do Bank Feeds Fit Into My Accounting System?26:08
320 Setting up Bank Feeds13:57
+29 more lectures

Getting Started - Getting Setup - Xero 2020

3 lectures • 16:39

.10 Xero Free 30-Day Trial02:47
Data Files to Download00:01
1.05 Navigation Overview13:51

Customer Cycle , Cycle, or Accounts Receivable Cycle - Xero 2020

6 lectures • 01:08:24

Data Files to Download00:01
1.15 Customers Section Flow11:31
1.16 Customer Section Invoice20:51
1.17 Customers Section Receive Payment14:34
1.18 Customers Section Deposit from Clearing06:30
+1 more lectures

Vendor Cycle, Purchases Cycle, or Sales Cycle - Xero 2020

5 lectures • 37:49

Data Files to Download00:01
1.20 Vendors Section Bill Form10:24
1.22 Vendor Section Payable Payment09:26
1.23 Vendors Section Purchase Order09:50
1.24 Vendors Section Check08:08

Employee Cycle and Other Core Features - Xero 2020

6 lectures • 01:06:09

1.25 Employee Section12:25
1.28 Others Section12:08
1.30 Reports12:54
1.40 Help Options05:20
1.45 Print & Export Reports to Excel14:49
+1 more lectures

Balance Sheet Reports - Xero 2020

7 lectures • 01:26:25

Data Files to Download00:01
2.10 Balance Sheet15:52
2.15 Balance Sheet Report Settings10:00
2.20 Balance Sheet Edit Layout17:11
2.30 Comparative Balance Sheet14:08
+2 more lectures

Profit and Loss or Income Statement Reports - Xero 2020

4 lectures • 51:00

3.10 Income Statement15:17
3.20 Comparative Income Statement15:35
3.25 Vertical Analysis Income Statement10:33
3.30 % of Expense Income Statement09:35

Statement of Cash flows & Other Common Reports - Xero 2020

6 lectures • 01:09:37

4.10 Statement of Cash Flows13:25
4.20 Income By Contact Report10:19
4.30 Aged Receivables Report10:28
4.35 Aged Payables Reports10:56
4.40 Sales Graphs10:29
+1 more lectures

Course Project Start - Set Up New Company File, Preferences, & Users

6 lectures • 31:52

Data Files to Download00:01
6.01 Set Up Organization Details07:23
6.02 Users Add & Manage11:33
6.03 Add Apps, Currencies, & Subscriptions04:40
6.05 Payment Services, Invoicing, & Features05:09
+1 more lectures

Set Up Service & Inventory Items & Enter Inventory Beginning Balance

7 lectures • 55:56

Data Files to Download00:01
6.09 Objective07:18
6.10 Items - Service Set Up Part 108:48
6.11 Items - Service Set Up Part 211:51
6.13 Items – Inventory Set Up Part 110:03
+2 more lectures

Add Customers & Vendors - Enter AR and AP Beginning Balances

2 lectures • 33:17

6.15 Set Up Customers & Beginning Balances21:33
6.20 Set Up Vendors & Beginning Balances11:44

Add Accounts & Beginning Balances, Checking, Credit Card, Notes Payable, Equip.

4 lectures • 49:48

6.25 Add Bank Account10:41
6.26 Add Credit Card10:32
6.27 Add Notes Payable13:40
6.28 Add Equipment Account14:55

Adjust Equity, Payroll Options, & Reports

2 lectures • 29:58

6.35 Payroll Options06:07
6.55 Generate Transaction Detail Report23:51

Month 1 - Deposits from Owner & Loan, Purchase Furniture, Sales Tax Set Up

4 lectures • 45:03

7.05 Record Owner & Loan Deposit13:19
7.10 1 Record Purchase Furniture12:50
7.10 2 Record Short-Term Investment10:17
7.16 Sales Tax Set Up08:37

Month 1 - Purchase Orders & Invoices

4 lectures • 29:51

7.17 Purchase Order Part 106:31
7.18 Purchase Order & Add Inventory Item04:03
7.20 Part 1 Create an Invoice with Inventory Part 110:33
7.20 Part 2 Create an Invoice with Inventory08:44

Month 1 - Receive Payments Forms

2 lectures • 16:37

7.25 Part 1 Receive Payment07:30
7.25 Part 2 Receive Payment09:07

Month 1 - Sales Receipt & Deposit

3 lectures • 29:22

7.30 Part 1 Sales Receipt10:50
7.30 Part 2 Sales Receipt Service Item10:20
7.35 Deposit Records Group Deposits08:12

Month 1 - Receive Inventory & Link Expense Form to Purchase Order

2 lectures • 23:05

7.40 1 P.O. Billed & Paid Part 111:21
7.40 2 P.O. Billed & Paid Part 211:44

Create Invoice From Linked Billable Expense & Make Deposit

3 lectures • 26:30

7.45 Invoice Created From Purchase Order Part 108:09
7.46 Invoice Created From Purchase Order Part 208:02
7.50 Receive Payment & Make Deposit10:19

Month 1 – Enter Checks & Expenses & Pay Bills

2 lectures • 28:57

7.55 Enter Check & Expense Forms21:11
7.60 Pay Bills07:46

Month 1 – Customer Jobs & Sub Customers, Projects, & Payroll

4 lectures • 41:25

7.65 Projects02:08
7.70 Pay Employees Part 117:24
7.71 Pay Employees Part 215:56
7.75 Sales Receipt Service Item05:57

Month 1 – Reports & Review of Data Input

1 lectures • 19:51

7.80 Generate Report Export to Excel19:51

Month 2 - Loan Payments & Short Term Investment Sale

5 lectures • 40:55

Data Files to Download00:01
8.02 Consolidate Loans05:21
8.03 Loan Amortization Table13:48
8.05 Make Loan Payments13:20
8.10 Short Term Investment Deposit08:25

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

3 lectures • 27:37

8.15 Purchase Order With New Inventory Item06:45
8.20 Receive Inventory Requested With P.O. Enter Bill09:21
8.25 Sales Receipts & Deposit11:31

Month 2 – Advanced Payments & Apply Credit to Invoice

4 lectures • 36:45

8.30 Advanced Payment From Customer09:48
8.35 Apply Credit Or Advanced Payment to Invoice12:14
8.40 Record Sales on Account06:21
8.45 Advance Customer Payment or Deposit08:22

Month 2 – Enter Bills, Pay Bills, Customer Payment, Pay Sales & Payroll Tax

5 lectures • 50:22

8.50 Bills Track & Pay07:39
8.55 Customer Payment & Deposit09:27
8.60 Pay Sales Tax08:20
8.65 Pay Payroll Taxes09:42
8.70 Enter Bills & Pay Bills15:14

Month 2 – New Service Items to Invoice, Finance Equipment, & Payroll

4 lectures • 54:25

8.75 Enter Service Items & Invoices18:01
8.77 Purchase Equipment with Debt11:08
8.80 Payroll17:18
8.90 Rental Income New Service Item New Income Account07:58

Month 2 – Month End Reports

1 lectures • 18:33

8.95 Comparative Financial Statements18:33

Bank Reconciliations

5 lectures • 01:23:30

9.02 Bank Reconciliation Objective14:28
9.10 Bank Reconciliation First Month Part 1 Deposits14:05
9.11 Bank Reconciliation First Month Part 224:28
9.14 Bank Reconciliation Second Month Part 1 Deposits08:37
9.15 Bank Reconciliation Second Month Outflows21:52

Month End Adjusting Entries & Reversing Entries

11 lectures • 02:01:30

10.10 Short Term Loan Adjusting Entry08:27
10.11 Short Term Portion Of Loan Adjusting Entry10:30
10.15 Loan Payable Adjusting Entry #210:37
10.17 Reversing Entry Notes Payable07:35
10.25 Accrued Interest Reversing Entry11:07
+6 more lectures

Bank Feeds

35 lectures • 06:38:41

Data Files to Download00:01
315 How Do Bank Feeds Fit Into My Accounting System10:44
320 Project Outline05:28
325 Set Up Bank Feeds07:11
360 Download Transactions From Bank07:06
+30 more lectures

Description

Whether you are a beginner in accounting or new to the Xero software, this course provides a comprehensive foundation to navigate Xero and perform essential accounting tasks.

We start by assuming no prior knowledge of the software or accounting principles. We guide you through the purchasing, downloading, and installation process, utilizing Xero's free 30-day trial to facilitate hands-on practice.

The first half of the course focuses on navigating the software, acquainting you with its major components and the primary accounting cycles, including the customer section (revenue cycle), the vendor section (payments cycle), and the employee section (payroll cycle). By understanding these sections, you will grasp the fundamental elements that impact financial statements.

Within each accounting cycle, we delve into analyzing the various forms and transactions, such as invoices, bills, pay bills, purchase orders, and deposits. You will gain insights into how each transaction affects the financial statements and develop proficiency in recording them accurately.

The second half of the course takes the form of a comprehensive problem, immersing you in a two-month data input exercise. This practical approach enables you to enter diverse transactions and experience the accounting workflow firsthand. As we progress through the comprehensive problem, you will witness the direct impact of each transaction on the financial statements, allowing for immediate verification of your work.

Beyond simple data entry, the comprehensive problem format provides contextual understanding and empowers you to optimize the Xero system for efficient data input. By exploring the entire accounting process within a real-world scenario, you will enhance your problem-solving skills and gain a holistic view of the accounting workflow.

Join us on this exciting journey to master Xero accounting software. Enroll today and acquire the skills to navigate Xero with confidence, analyze financial transactions effectively, and ensure accurate financial reporting.

Who this course is for:

  • Beginners with no prior knowledge of accounting or experience with Xero software, who are interested in learning accounting principles and how to use Xero for their financial tasks.
  • Small business owners and entrepreneurs who want to manage their accounting processes efficiently using the Xero software platform.
  • Accounting and finance students who want to gain practical skills in using accounting software and understand how it applies to real-world scenarios.
  • Bookkeepers and accounting professionals who want to expand their knowledge and proficiency in using Xero software for client work and financial analysis.
  • Anyone interested in learning about Xero software and its capabilities for managing financial transactions, generating reports, and analyzing financial data.

This course includes:

  • 81.5 hours on-demand video
  • 16 articles
  • 142 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Instructor

Robert (Bob) Steele

Students also download

Explore related courses to expand your learning journey.