Xero Accounting Software
Learn Xero accounting software in a comprehensive online course taught by a practicing CPA, CGMA, CPI, with BS tax
What you will learn
Set up Xero Account
Navigate Xero Software
Enter normal business transaction into Xero accounting software
Reconcile bank accounts using Xero accounting software
Generate and analyze reports including a balance sheet, an income statement, and supporting reports
Export Reports to Excel
This course will start at the basics, assuming you know nothing about the software or accounting.
We will then go through the purchasing process, the downloading process, and the installation process. Xero often offers a free 30 day trial which is a perfect tool to practice with.
The first half of the course will be dedicated to navigating the software, getting a feel for the major components of the software, and the primary accounting cycles such as the customer section or revenue cycle, the vendor section or payments cycle, and the employee section or payroll cycle.
Once we learn the primary sections or accounting cycles we will analyze the forms and transactions within each section, considering the impact each has on the financial statements. major accounting forms will include invoice, bills, pay bills, purchase orders, deposits, and more.
The second half of the course will be in the format of a comprehensive problem, working through two months of data impute.
We will enter every standard type of transaction as we work through the comprehensive problem. The comprehensive problem format will provide context to the data entry process, so we understand how the data impute fits into the accounting workflow.
A comprehensive problem also allows us to do more than simple data entry, data entry generally being the easiest part of the accounting process. We will be able to see how to set up the system to make the data entry as easy as possible.
We will also be able to see the impact on the financial statements of every transaction we make and be able to check our work after each transaction.
Getting Started - Getting Setup - Xero 2020
Customer Cycle , Cycle, or Accounts Receivable Cycle - Xero 2020
Vendor Cycle, Purchases Cycle, or Sales Cycle - Xero 2020
Employee Cycle and Other Core Features - Xero 2020
Balance Sheet Reports - Xero 2020
Profit and Loss or Income Statement Reports - Xero 2020
Statement of Cash flows & Other Common Reports - Xero 2020
Course Project Start - Set Up New Company File, Preferences, & Users
Set Up Service & Inventory Items & Enter Inventory Beginning Balance
Add Customers & Vendors - Enter AR and AP Beginning Balances
Add Accounts & Beginning Balances, Checking, Credit Card, Notes Payable, Equip.
Adjust Equity, Payroll Options, & Reports
Month 1 - Deposits from Owner & Loan, Purchase Furniture, Sales Tax Set Up
Month 1 - Purchase Orders & Invoices
Month 1 - Receive Payments Forms
Month 1 - Sales Receipt & Deposit
Month 1 - Receive Inventory & Link Expense Form to Purchase Order
Create Invoice From Linked Billable Expense & Make Deposit
Month 1 – Enter Checks & Expenses & Pay Bills
Month 1 – Customer Jobs & Sub Customers, Projects, & Payroll
Month 1 – Reports & Review of Data Input
Month 2 - Loan Payments & Short Term Investment Sale
Month 2–Purchase Order, Enter Bill for Inventory, Sales Receipt, & Deposit
Month 2 – Advanced Payments & Apply Credit to Invoice
Month 2 – Enter Bills, Pay Bills, Customer Payment, Pay Sales & Payroll Tax
Month 2 – New Service Items to Invoice, Finance Equipment, & Payroll
Month 2 – Month End Reports
Month End Adjusting Entries & Reversing Entries
|Submit by||Date||Coupon Code||Discount||Emitted/Used||Status|
|Lee Jia Cheng||2/1/2020||BED298BEFE9AFF221D8F||100% OFF|
|Lee Jia Cheng||2/20/2020||560EFDBB31BA4C62E9DF||100% OFF|
|Lee Jia Cheng||2/24/2020||F6507CFF0CBB251BCE25||100% OFF|
|Angelcrc Seven||5/26/2020||9D8374BDAFC890E41D46||100% OFF||40000/782|
|Angelcrc Seven||12/27/2020||5FB5B0CF46C465B23098||100% OFF||40000/3952|
|Ignacio Castro||11/21/2021||7B35B06460278422B52F||100% OFF||1000/978|
|Ignacio Castro||1/15/2022||04AAF17A3255A41EA47D||100% OFF||1000/944|
|Angelcrc Seven||1/27/2022||AAAF4CBF00CE7D2E746C||100% OFF||1000/620|
|Angelcrc Seven||2/2/2022||728CC600C8F7785BFE25||100% OFF||1000/987|
|Angelcrc Seven||3/10/2022||AC2354B2993878C28946||100% OFF||1000/396|
|Angelcrc Seven||3/17/2022||5535BB48C2FEB147954F||100% OFF||1000/389|
|Angelcrc Seven||5/4/2022||F1595C4B8032FDC3D19D||100% OFF||1000/470|