Xero Accounting Software by Udemy
Become an Expert in Xero Accounting Software: From Basics to Comprehensive Data Analysis
Course Highlights
- 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.
Skills you will learn!
Curriculum
3 Topics
1012 30 Day Free Trial & Purchase Options
1080 Dashboard
1100 Bank Feeds
9 Topics
Data Files
1140 Vendor Expense or Payments Cycle
1160 Bills To Pay and Suppliers
1180 Bill Form
1200 Payment Form to Pay Bill
1220 Purchase Order Form P.O.
1222 Bill With Inventory Connected to P.O.
1227 Inventory Adjustment
1260 Check Form or Spend Money Form
8 Topics
1300 Customer Revenue or Account Receivable Cycle
1320 Invoice Center & Customer Information
1340 Invoice Form
1360 Receive Payment on Invoice
1380 Receive Money or Deposit Form
1400 Receive Money Form – Cash Basis Sale
1405 Barter Sale Transaction
1433 Quote or Estimate
1 Topic
1480 Payroll Overview
2 Topics
1580 Chart of Accounts
1600 Products & services
1 Topic
1640 Reports Overview
6 Topics
2020 Balance Sheet Report Overview
2040 Report Formatting Basics
2100 Comparative Balance Sheet Creation
2120 Balance Sheet Vertical Analyses
2180 Reports - Print Save as PDF & Organize
2181 Export Balance Sheet to Excel
5 Topics
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
3100 Print Save as PDF & Organize Profit & Loss or Income Statement Reports
3105 Export to Excel Profit & Loss or Income Statement Reports
14 Topics
4020 Statement of Cash Flows
4040 Accounts Receivable Aging Reports
4060 Accounts Payable Aging Reports.
4065 1099 Reports
4080 Sales by Customer & Sales by Item
4140 Inventory Reports
4160 Payroll & Employee Reports
4180 Reconciliation Reports
4200 Transaction Reports
4225 Trial Balance
4240 Budget & Financial Performance Reports.tscproj
4260 Accounts Receivable Graphs
4300 Accounts Payable Graphs
4320 Sales by Customer Account & Item Graphs
4 Topics
Data Files to Download
6010 Comprehensive Practice Problem Introduction
6040 Free 30 Day Trial
6060 Navigation Overview & Company Setting
2 Topics
6080 Settings - Profile & General
6100 Organization Settings - Features
4 Topics
6240 Entering Beginning Balances Customers Vendors & Items Overview
6260 Enter Service Items
6280 Inventory Tracking Options
6300 Set Up Inventory Items
3 Topics
6320 Sales Tax Set Up
6340 New Customers Setup & Accounts Receivable Beginning Balances
6360 New Vendors Setup & Accounts Payable Beginning Balances
4 Topics
6380 Add New Accounts & Opening Balances
6400 Adjust Opening Balances
6420 Payroll Set up
6440 Generate Reports After Entering Beginning Balances
4 Topics
Data Files to Download
7020 Deposits - Owner Investment & Loan
7040 Record Investment
7043 Purchase of Fixes Assets
3 Topics
7060 Enter Purchase Order P.O.
7080 Payment for Inventory Linked to Purchase Order P.O.
7083 Transaction Correction
4 Topics
7100 Invoice Selling Inventory
7120 Receive Payment Or Deposit From Invoice
7140 Receive Money Form Payment Received at Point of Sale
7160 Deposits From Cash Clearing Account
4 Topics
7180 Invoice Selling Inventory Created from a Spend Money Form with Assigned Exp
7200 Receive Payment From Invoice & Make Deposit
7220 Write Checks for Expenses & Prepaid Assets
7240 Bill Pay
4 Topics
7260 Projects Set Up
7280 Pay Employees
7300 Enter Billable Time to Projects & Invoice
7310 Assign Expenses to a Customer or Project
2 Topics
7320 Month One Reports
7325 Bundle Month One reports for a Client
5 Topics
Data Files to Download
8020 Make Amortization Table
8022 Make Loan Payments
8040 Short Term Investment Sales & Gains
8060 Change Account Categorization to Other Expense
3 Topics
8080 Purchase Order Adding New Items
8120 Receive Money Sales Receipt & Deposit
8122 Record Receipt of Inventory with Bill Linked to P.O.
4 Topics
8130 Populate Invoice Using Information From Purchase Order P.O.
8140 Advanced Customer Payment or Unearned Revenue
8160 Apply Customer Deposit (Credit) to Invoice
8200 Quote or Estimate & Advanced Customer Payment or Unearned Revenue
2 Topics
8320 Bill for Hourly Services of Staff Set up Items & Enter Billable Time
8322 Create Invoices for Projects Using Billable Time
3 Topics
8340 Rental Income Set Up Items
8342 Rental Estimate & Customer Deposit
8344 Rental Income Invoice from Estimate or Quote & Customer Credit Applied
2 Topics
8360 Purchase & Finance Equipment & Organize Multiple Loan Accounts
8362 Organize Fixed Asset Account Categories
2 Topics
8365 Bills - Enter Sort & Pay
8370 Pay Sales Tax
2 Topics
8380 Enter Payroll For Second Month
8385 Pay Payroll Taxes
1 Topic
8420 Create Reports After Second Month of Data Input
11 Topics
Data Files to Download
9020 Bank Reconciliation Myth Busting
9040 Bank Reconciliation Month One Overview
9060 Bank Reconciliation Month #1 Deposits
9065 Manually Import Bank Data
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
12 Topics
Data Files to Download
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
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
6 Topics
Data Files to Download
11100 Budgeting Overview
11120 Budgeted Income Statement Export to Excel & Modify Part 1
11122 Budgeted Income Statement Export to Excel & Modify Part 2
11140 Budgeted Income Statement Data Input
11160 Budgeted Income Statement Reports
34 Topics
Data Files to Download
305 Setup Bank Feed Test Company File With 30 Day Free Trial
308 Delete Excess General Ledger Accounts
315 How do Bank Feeds Fit Into My Accounting System?
320 Setting up Bank Feeds
360 Download Bank Feed Transactions From Bank
364 Import Bank Transactions Into Xero
370 Add Normal Expenses To Books From Bank Feed Limbo & Make Rules
375 Enter Transaction Purchasing Equipment Using Bank Feeds
380 Enter Transaction Purchas of Inventory Using Bank Feeds Overview
382 Purchase of Inventory Using Bank Feeds Period Method & Perpetual Method
385 Enter Transaction Purchasing Investments Using Bank Feeds
390 Enter Transaction For Owner Withdrawal or Personal Payment Using Bank Feeds
395 Income From Bank Feeds & Income Categories
396 Income From Bank Feeds With Bank Rules One Customer But Two Income Accounts
400 Enter Transaction for Owner Deposit or Loan Deposit Using Bank Feeds
403 Payroll Transactions Using Bank Feeds
405 Sales Tax & Bank Feeds
440 Bank Feeds Matching Invoice to Deposit
447 Bank Feeds Matching Deposit From Customer
449 Bank Feeds Matching to Cash Based Sales Form
460 Bank Feeds Credit Card Data Setup
465 Credit Card Bank Feed Add Data
467 Bank Feed to Bank Feed Transaction
475 Credit Card Reconciliation Month One
480 Credit Card Reconciliation Month Two
505 PayPal Bank Feeds
520 PayPal Bank Feeds Data Input & Transfers
660 Bank Rules – Same Customer Different Income Accounts & Tracking Categories
665 Bank Rules Same Vendor Two Accounts Filtered by Amount
670 Bank Rules – Split Expense Into Two Accounts & Tracking Categories
685 Bank Reconciliation Bank Feeds First Month
690 Bank Reconciliation Bank Feeds After First Month
695 Financial Reports Generated From Bank Feeds
3 Topics
.10 Xero Free 30-Day Trial
Data Files to Download
1.05 Navigation Overview
6 Topics
Data Files to Download
1.15 Customers Section Flow
1.16 Customer Section Invoice
1.17 Customers Section Receive Payment
1.18 Customers Section Deposit from Clearing
1.19 Customers Section Sales Receipts
5 Topics
Data Files to Download
1.20 Vendors Section Bill Form
1.22 Vendor Section Payable Payment
1.23 Vendors Section Purchase Order
1.24 Vendors Section Check
6 Topics
1.25 Employee Section
1.28 Others Section
1.30 Reports
1.40 Help Options
1.45 Print & Export Reports to Excel
1.50 Backup Options
7 Topics
Data Files to Download
2.10 Balance Sheet
2.15 Balance Sheet Report Settings
2.20 Balance Sheet Edit Layout
2.30 Comparative Balance Sheet
2.40 Summary Balance Sheet
2.50 Memorize Custom Report Group
4 Topics
3.10 Income Statement
3.20 Comparative Income Statement
3.25 Vertical Analysis Income Statement
3.30 % of Expense Income Statement
6 Topics
4.10 Statement of Cash Flows
4.20 Income By Contact Report
4.30 Aged Receivables Report
4.35 Aged Payables Reports
4.40 Sales Graphs
4.45 AR & AP Graphs
6 Topics
Data Files to Download
6.01 Set Up Organization Details
6.02 Users Add & Manage
6.03 Add Apps Currencies & Subscriptions
6.05 Payment Services Invoicing & Features
6.06 Projects Files & Other Settings
7 Topics
Data Files to Download
6.09 Objective
6.10 Items - Service Set Up Part 1
6.11 Items - Service Set Up Part 2
6.13 Items – Inventory Set Up Part 1
6.14 Items – Inventory Set Up Part 2
6.14 Items – Inventory Set Up Part 3
2 Topics
6.15 Set Up Customers & Beginning Balances
6.20 Set Up Vendors & Beginning Balances
4 Topics
6.25 Add Bank Account
6.26 Add Credit Card
6.27 Add Notes Payable
6.28 Add Equipment Account
2 Topics
6.35 Payroll Options
6.55 Generate Transaction Detail Report
4 Topics
7.05 Record Owner & Loan Deposit
7.10 1 Record Purchase Furniture
7.10 2 Record Short-Term Investment
7.16 Sales Tax Set Up
4 Topics
7.17 Purchase Order Part 1
7.18 Purchase Order & Add Inventory Item
7.20 Part 1 Create an Invoice with Inventory Part 1
7.20 Part 2 Create an Invoice with Inventory
2 Topics
7.25 Part 1 Receive Payment
7.25 Part 2 Receive Payment
3 Topics
7.30 Part 1 Sales Receipt
7.30 Part 2 Sales Receipt Service Item
7.35 Deposit Records Group Deposits
2 Topics
7.40 1 P.O. Billed & Paid Part 1
7.40 2 P.O. Billed & Paid Part 2
3 Topics
7.45 Invoice Created From Purchase Order Part 1
7.46 Invoice Created From Purchase Order Part 2
7.50 Receive Payment & Make Deposit
2 Topics
7.55 Enter Check & Expense Forms
7.60 Pay Bills
4 Topics
7.65 Projects
7.70 Pay Employees Part 1
7.71 Pay Employees Part 2
7.75 Sales Receipt Service Item
1 Topic
7.80 Generate Report Export to Excel
5 Topics
Data Files to Download
8.02 Consolidate Loans
8.03 Loan Amortization Table
8.05 Make Loan Payments
8.10 Short Term Investment Deposit
3 Topics
8.15 Purchase Order With New Inventory Item
8.20 Receive Inventory Requested With P.O. Enter Bill
8.25 Sales Receipts & Deposit
4 Topics
8.30 Advanced Payment From Customer
8.35 Apply Credit Or Advanced Payment to Invoice
8.40 Record Sales on Account
8.45 Advance Customer Payment or Deposit
5 Topics
8.50 Bills Track & Pay
8.55 Customer Payment & Deposit
8.60 Pay Sales Tax
8.65 Pay Payroll Taxes
8.70 Enter Bills & Pay Bills
4 Topics
8.75 Enter Service Items & Invoices
8.77 Purchase Equipment with Debt
8.80 Payroll
8.90 Rental Income New Service Item New Income Account
1 Topic
8.95 Comparative Financial Statements
5 Topics
9.02 Bank Reconciliation Objective
9.10 Bank Reconciliation First Month Part 1 Deposits
9.11 Bank Reconciliation First Month Part 2
9.14 Bank Reconciliation Second Month Part 1 Deposits
9.15 Bank Reconciliation Second Month Outflows
11 Topics
10.10 Short Term Loan Adjusting Entry
10.11 Short Term Portion Of Loan Adjusting Entry
10.15 Loan Payable Adjusting Entry #2
10.17 Reversing Entry Notes Payable
10.25 Accrued Interest Reversing Entry
10.25 Invoice & AR Adjusting Entry
10.26 Invoice & AR Adjusting Entry Part 2 Solution
10.35 Accounts Receivable Reversing Entry
10.40 Prepaid Insurance Adjusting Entry
10.45 Depreciation Adjusting Entry
10.57 Journal Report & Financial Statements
35 Topics
Data Files to Download
315 How Do Bank Feeds Fit Into My Accounting System
320 Project Outline
325 Set Up Bank Feeds
360 Download Transactions From Bank
365 Import Bank Data
370 Add Expense transactions
375 Add Capital Expenditures
376 Add Capital Expenditures Part 2
380 Add Inventory Purchase
385 Add Amount Paid for Investment
395 Add Bank Charge
400 Sales Tax Calculation
400 Sales Tax Set Up
405 Deposit Loan
405 Deposit Owner
406 Bank Beginning Balance
415 1 Upload Bank Transactions
415 2 Add Expenses
420 Add Insurance
425 Add Payroll Checks
430 2 Add Loan Payment
435 Add Draw
440 1 Receive Payments On Invoice
440 2 One Deposit Two Invoices
445 Sales Receipt & Bank Feeds
450 Bank Reconciliation
460 Credit Card Bank Feeds Upload
465 2 Add Credit Card Data to Financial Stmts
470 1 Reconcile Credit Card
475 Bank Rules Deposit Same Customer Different Account
480 Bank Rules Amount Limit
485 Bank Rules Split Into Two Accounts
490 Bank Rules One Vendor Two Expense Accounts
495 Bank Rules More Rules
Xero Accounting Software
Thank You!
Your review has been submitted successfully.