Xero Accounting Software 2023

Xero Accounting Software

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

Buy $150.00

Course curriculum

1. 1012 30 Day Free Trial & Purchase Options
2. 1080 Dashboard
3. 1100 Bank Feedsbf275d.autosave
1. Data Files to Download
2. 1140 Vendor, Expense, or Payments Cycle
3. 1160 Bills To Pay and Suppliers
4. 1180 Bill Form42dfb0.autosave3bcfe3.autosave
5. 1200 Payment Form to Pay Bill
6. 1220 Purchase Order Form P.O.
7. 1222 Bill With Inventory Connected to P.O.
8. 1227 Inventory Adjustment1457f64.autosave
9. 1260 Check Form or Spend Money Form14d16512.autosave
1. 1300 Customer, Revenue, or Account Receivable Cycle
2. 1320 Invoice Center & Customer Information
3. 1340 Invoice Form
4. 1360 Receive Payment on Invoice
5. 1380 Receive Money or Deposit Form
6. 1400 Receive Money Form – Cash Basis Sale6d7ea3.autosave
7. 1405 Barter Sale Transaction10cfef9.autosave
8. 1433 Quote or Estimate
1. 1480 Payroll Overview
1. 1580 Chart of Accounts
2. 1600 Products & services
1. 1640 Reports Overview
1. 2020 Balance Sheet Report Overview
2. 2040 Report Formatting Basics
3. 2100 Comparative Balance Sheet Creation977fff.autosave990508.autosave
4. 2120 Balance Sheet Vertical Analyses
5. 2180 Reports - Print, Save as PDF, & Organize
6. 2181 Export Balance Sheet to Excel
1. 3020 Profit & Loss, P&L, Income Statement Overview
2. 3040 Comparative Profit & Loss, P&L, Income Statement
3. 3060 Vertical Analysis Profit Loss, P&L, Income Statement
4. 3100 Print, Save as PDF, & Organize Profit & Loss or Income Statement Reports
5. 3105 Export to Excel Profit & Loss or Income Statement Reports
1. 4020 Statement of Cash Flows
2. 4040 Accounts Receivable Aging Reports
3. 4060 Accounts Payable Aging Reports.
4. 4065 1099 Reports
5. 4080 Sales by Customer & Sales by Item
6. 4140 Inventory Reports
7. 4160 Payroll & Employee Reportsf766c7.autosave
8. 4180 Reconciliation Reports1f8b65c.autosave
9. 4200 Transaction Reports
10. 4225 Trial Balance
11. 4240 Budget & Financial Performance Reports.tscproj
12. 4300 Accounts Payable Graphs
13. 4320 Sales by Customer, Account, & Item Graphs
1. Data Files to Download
2. 6010 Comprehensive Practice Problem Introduction
3. 6040 Free 30 Day Trail
4. 6060 Navigation Overview & Company Settings
1. 6080 Settings - Profile & General
2. 6100 Organization Settings - Features
1. 6240 Entering Beginning Balances, Customers, Vendors, & Items Overview
2. 6280 Inventory Tracking Options
3. 6260 Enter Service Items
4. 6300 Set Up Inventory Items
1. 6320 Sales Tax Set Up
2. 6340 New Customers Setup & Accounts Receivable Beginning Balances
3. 6360 New Vendors Setup & Accounts Payable Beginning Balances
1. Data Files to Download
2. 6380 Add New Accounts & Opening Balances
3. 6400 Adjust Opening Balances
4. 6420 Payroll Set up
5. 6440 Generate Reports After Entering Beginning Balances_backup59f9b9c.autosave
1. Data Files to Download
2. 7020 Deposits - Owner Investment & Loan
3. 7040 Record Investment
4. 7043 Purchase of Fixes Assets
1. 7060 Enter Purchase Order P.O.
2. 7080 Payment for Inventory Linked to Purchase Order P.O.
3. 7083 Transaction Correction
1. 7100 Invoice Selling Inventory
2. 7120 Receive Payment Or Deposit From Invoice
3. 7140 Receive Money Form Payment Received at Point of Sale (1)
4. 7160 Deposits From Cash Clearing Account
1. 7180 Invoice Created from a Spend Money Form with Assigned Expenses to Customer (1)
2. 7200 Receive Payment From Invoice & Make Deposit
3. 7220 Write Checks for Expenses & Prepaid Assets
4. 7240 Bill Pay
1. 7260 Projects Set Up
2. 7280 Pay Employees
3. 7300 Enter Billable Time to Projects & Invoice
4. 7310 Assign Expenses to a Customer or Project
1. 7320 Month One Reports
2. 7325 Bundle Month One reports for a Client
1. Data Files to Download
2. 8020 Make Amortization Table
3. 8022 Make Loan Payments
4. 8040 Short Term Investment Sales & Gains
5. 8060 Change Account Categorization to Other Expense
1. 8080 Purchase Order Adding New Items
2. 8120 Receive Money Sales Receipt & Deposit
3. 8122 Record Receipt of Inventory with Bill Linked to P.O.
1. 8130 Populate Invoice Using Information From Purchase Order P.O.
2. 8140 Advanced Customer Payment or Unearned Revenue
3. 8160 Apply Customer Deposit (Credit) to Invoice
4. 8200 Quote or Estimate & Advanced Customer Payment or Unearned Revenue
1. 8320 Bill for Hourly Services of Staff, Set up Items, & Enter Billable Time
2. 8322 Create Invoices for Projects Using Billable Time
1. 8340 Rental Income Set Up Items
2. 8342 Rental Estimate & Customer Deposit
3. 8344 Rental Income Invoice from Estimate or Quote & Customer Credit Applied
1. 8360 Purchase & Finance Equipment & Organize Multiple Loan Accounts
2. 8362 Organize Fixed Asset Account Categories
1. 8365 Bills - Enter, Sort, & Pay
2. 8370 Pay Sales Tax
1. 8380 Enter Payroll For Second Month
2. 8385 Pay Payroll Taxes
1. 8420 Create Reports After Second Month of Data Input
1. Data Files to Download
2. 9020 Bank Reconciliation Myth Busting
3. 9040 Bank Reconciliation Month One Overview
4. 9060 Bank Reconciliation Month #1 Deposits
5. 9065 Manually Import Bank Data
6. 9080 Bank Reconciliation Month #1 Checks (1)
7. 9100 Bank Reconciliation Opening Balance Problem
8. 9120 Bank Reconciliation Reports Month # 1 (1)
9. 9140 Bank Reconciliation Month #2 Deposits
10. 9145 Bank Reconciliation Month #2 Checks & Account Decreases
11. 9160 Bank Reconciliation
1. Data Files to Download
2. 10120 Adjusting Entries & Reversing Entries Introduction
3. 10180 Adjusting Entry Accrued Interest
4. 10220 Reversing Entry Accrued Interest
5. 10260 Adjusting Entry Accounts Receivable Sales
6. 10300 Reversing Entry Accounts Receivable Sales
7. 10340 Adjusting Entry Prepaid Insurance
8. 10380 Adjusting Entry Depreciation
9. 10400 Adjusting Entry Unearned Revenue Customer Deposit
10. 10465 Adjusting Entry Loan Payable Short-Term and Long-Term Portions
11. 10467 Reversing Entry Loan Payable Short-Term and Long-Term Portions
12. 10480 Adjusting Entry & Reversing Entry Journal Reports
1. Data Files to Download
2. 11100 Budgeting Overview
3. 11120 Budgeted Income Statement Export to Excel & Modify Part 1
4. 11122 Budgeted Income Statement Export to Excel & Modify Part 2
5. 11140 Budgeted Income Statement Data Input
6. 11160 Budgeted Income Statement Reports
1. Data Files to Download
2. 305 Setup Bank Feed Test Company File With 30 Day Free Trial
3. 308 Delete Excess General Ledger Accounts
4. 315 How do Bank Feeds Fit Into My Accounting System
5. 320 Setting up Bank Feeds
6. 360 Download Bank Feed Transactions From Bank
7. 364 Import Bank Transactions Into Xero
8. 370 Add Normal Expenses To Books From Bank Feed Limbo & Make Rules
9. 380 Enter Transaction Purchas of Inventory Using Bank Feeds Overview
10. 382 Purchase of Inventory Using Bank Feeds Period Method & Perpetual Method
11. 385 Enter Transaction Purchasing Investments Using Bank Feeds
12. 390 Enter Transaction For Owner Withdrawal or Personal Payment Using Bank Feeds
13. 395 Income From Bank Feeds & Income Categories
14. 396 Income From Bank Feeds With Bank Rules One Customer But Two Income Accounts
15. 400 Enter Transaction for Owner Deposit or Loan Deposit Using Bank Feeds
16. 403 Payroll Transactions Using Bank Feeds
17. 405 Sales Tax & Bank Feeds
18. 440 Bank Feeds Matching Invoice to Deposit
19. 447 Bank Feeds Matching Deposit From Customer
20. 449 Bank Feeds Matching to Cash Based Sales Form
21. 460 Bank Feeds Credit Card Data Setup
22. 465 Credit Card Bank Feed Add Data
23. 467 Bank Feed to Bank Feed Transaction
24. 475 Credit Card Reconciliation Month One
25. 480 Credit Card Reconciliation Month Two
26. 505 PayPal Bank Feeds
27. 520 PayPal Bank Feeds Data Input & Transfers
28. 660 Bank Rules – Same Customer Different Income Accounts & Tracking Categories
29. 665 Bank Rules Same Vendor, Two Accounts, Filtered by Amount
30. 670 Bank Rules – Split Expense Into Two Accounts & Tracking Categories
31. 685 Bank Reconciliation Bank Feeds First Month
32. 690 Bank Reconciliation Bank Feeds After First Month
33. 695 Financial Reports Generated From Bank Feeds

About this course

$150.00
173 lessons
52 hours of video content

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.