Description

 

Unrestricted Course Access

As a student you can move freely from any section of the course to any other section rather than locked into selected parts of the course.

This enables you to progress through the course in the logical order from beginning to more advanced but means that you can access a resource if you need to while you are at your job or if you need to learn something urgently.

Learn more about Unrestricted Course Access

Xero & MYOB Data Entry, A/R & A/P Training Course

Accounting Structure and Bank Accounts

• Xero & MYOB Daily Transactions Course – Create New Accounts – Creating Your Chart of Accounts
• Xero & MYOB Daily Transactions Course – Create New Accounts – Add Bank Account
• Xero & MYOB Daily Transactions Course – Create New Accounts – Add Credit Card
• Xero & MYOB Daily Transactions Course – Create New Accounts – Modifying Your Chart of Accounts

Customers & Suppliers (CRM)

• Xero & MYOB Daily Transactions Course – Set Up Contacts – Add New Contact
• Xero & MYOB Daily Transactions Course – Set Up Contacts – Edit Existing Contact
• Xero & MYOB Daily Transactions Course – Set Up Contacts – Merge Duplicate Contacts
• Xero & MYOB Daily Transactions Course – Set Up Contacts – Group Contacts

The Sales Dashboard: Quotes, Invoicing & Payments (Debtors)

• 

  Xero & MYOB Daily Transactions Course – Sales Dashboard – Create a Sales Invoice

• Xero & MYOB Daily Transactions Course – Sales Dashboard – Navigating the Sales Dashboard
• Xero & MYOB Daily Transactions Course – Sales Dashboard – Create a Draft Sales Invoice
• Xero & MYOB Daily Transactions Course – Sales Dashboard – Email or Print Invoices
• Xero & MYOB Daily Transactions Course – Sales Dashboard – Create a Branding Theme
• Xero & MYOB Daily Transactions Course – Sales Dashboard – Create a Quote
• Xero & MYOB Daily Transactions Course – Sales Dashboard – Accept and Create an Invoice for Quote
• Xero & MYOB Daily Transactions Course – Sales Dashboard – Copy an Invoice
• Xero & MYOB Daily Transactions Course – Sales Dashboard – Receive Customer Payment
• Xero & MYOB Daily Transactions Course – Sales Dashboard – Receive Payment for Multiple Invoices
• Xero & MYOB Daily Transactions Course – Sales Dashboard – Delete an Invoice
• Xero & MYOB Daily Transactions Course – Sales Dashboard – Void an Invoice
• Xero & MYOB Daily Transactions Course – Sales Dashboard – Void Invoice When Payment is Applied
• Xero & MYOB Daily Transactions Course – Sales Dashboard – Overpayments
• Xero & MYOB Daily Transactions Course – Sales Dashboard – Create and Allocate a Credit Note
• Xero & MYOB Daily Transactions Course – Sales Dashboard – Statements

The Purchases Dashboard: Supplier Invoices and Payments, Purchase Orders and Remittances (Creditors)

• Xero & MYOB Daily Transactions Course – Purchases Dashboard – Create a Supplier Invoice
• Xero & MYOB Daily Transactions Course – Purchases Dashboard – Create a Supplier Payment
• Xero & MYOB Daily Transactions Course – Purchases Dashboard – Create a Purchase Order
• Xero & MYOB Daily Transactions Course – Purchases Dashboard – Print and Send a Purchase Order
• Xero & MYOB Daily Transactions Course – Purchases Dashboard – Create a Bill from a Purchase Order
• Xero & MYOB Daily Transactions Course – Purchases Dashboard – Internal Bank Transfers
• Xero & MYOB Daily Transactions Course – Purchases Dashboard – Send a Remittance

Stock and Inventory

• Creating Items
• Purchasing inventory items
• holding stock assets

Other Transactions

• Xero & MYOB Daily Transactions Course – Other Transactions – Receive Money
• Xero & MYOB Daily Transactions Course – Other Transactions – Prepayments
• Xero & MYOB Daily Transactions Course – Other Transactions – Spend Money
• Xero & MYOB Daily Transactions Course – Other Transactions – Transfer Money
• Xero & MYOB Daily Transactions Course – Other Transactions – Process Contra Deal

Expense Claims

• Xero & MYOB Daily Transactions Course – Expense Claims – Add, Edit and Delete Receipts
• Xero & MYOB Daily Transactions Course – Expense Claims – Submit Claim for Approval
• Xero & MYOB Daily Transactions Course – Expense Claims – Authorise an Expense Claim
• Xero & MYOB Daily Transactions Course – Expense Claims – Pay an Expense Claim

Reports

• Xero & MYOB Daily Transactions Course – Reports – Balance Sheets
• Xero & MYOB Daily Transactions Course – Profit and Loss Statements

 

Industry Connect

Technical skills about how to use accounting software programs like MYOB and Xero are important and they will increase your confidence when speaking to employers and potential bookkeeping clients as a contract bookkeeper – but you can do better.

Industry Connect is a training and career support program which delves deeper into the accounting tasks performed by accounts staff and contract bookkeepers. We delve into the tricky transactions and tasks that make you stand out from other junior bookkeepers with less experience.

With Industry connect you not only get access to a structure training program but are connected with a practicing bookkeeper who has performed these tasks for many employers and clients – and you don’t have to impress your tutor because they’re here to help you, not test your skills as part of the hiring process.

Learn more about Industry Connect

 

Xero & MYOB Bank Reconciliation & Journal Entries Training Course

Loans from the business to owners and directors requires it’s own compliance checks, but in this section of the course we’ll include the transactions and code you need to enter to keep a record of funds loaned to the business, The purpose of this workbook is to take students through common entries that occur on a one-off basis and that are not normally part of the quoting, invoicing and payment entries that occur in the Xero and MYOB Beginners Courses. This course contains a bank statement where you’ll need to enter and code the transactions then run a bank reconciliation to discover that there are omissions and errors that you’ll need to fix – you’ll get to see what this looks like and then edit and enter the correct transactions and complete the reconciliation.

It is at this stage that you will enter:

• Direct debits that come out of your account automatically
• Interest charges or payments
• Capital purchases and payments
• Merchant and bank charges
• Find duplicates or omissions
• Correct existing data
• Locate and correct amounts that are a couple of cents or dollars out because they’ve been entered incorrectly

Technically the bank reconciliation stage is also where most strict accountants, bookkeepers or accounts managers will demand to see evidence of your purchases in the form of a receipt or tax invoice.

Bank Reconciliation — Loan Account

• Creating a loan account
• Transferring loan funds
• Transaction details and accounts payable
• Setting up accounts payable
• Linked accounts, and
• Editing or deleting a transaction entry

Bank Reconciliation — Entering Transactions

• Creating customer cards
• Creating inventory items
• Entering a sale and payment
• Spending money
• Receiving money from a client
• Reconciling your cheque account to your bank statement

Bank Reconciliation – International Credit Card Payments

Often the service in overseas countries is cheaper or better or there simply isn’t an available comparative product in Australia so we pay for overseas services. When we do this we don’t pay GST and we incur credit card charges. You’ll learn how to manage

• journal entries
• GST and tax coding, and
• reconciling

Handling Basic Payroll Transactions

If you are a small business you may pay yourself, your partners or even casual workers adhoc amounts each week or month. These transactions need to capture the right codes and also be included in your bank reconciliations. As long the correct amount of tax is paid and the employers’ obligations are met then the business owner is doing everything right. We’ll show you how some small companies manage these transactions.

Purchasing Assets – Company Vehicle

There will be times when larger equipment is purchased and it’s paid for from your operating cash flow. In this situation the asset isn’t written off as an immediate expense but depreciated every year for a certain number of years. You’ll learn how to code this type of transaction correctly.

 

INTEGRATIONS – Receipt Scanning & Data Extraction Course

*** NEW ***

As a bookkeeping professional there is a growing expectation that you’ll have a solid understanding of accounting software as well as some integrations which add value and compliment the accounting tasks you perform each day.

Receipt Capture is a feature that has been available for some time already but the features of these software programs are growing and becoming more powerful.

 

 

Xero and MYOB Accounting GST, Reporting & BAS Training Course

This Xero and MYOB Training Course builds on the Bank Reconciliation Course. It explores a full quarter worth of transactions using a case study which features a budding entrepreneur and we’ve chosen this case study because it enables us to include  transactions that make GST and BAS reporting tricky; including:

• purchases which are GST-free,
• those which have partial GST, or are
• international payments.
• varying GST Transactions

Course Inclusions

The course includes capital purchases (a vehicle) and includes the different costs of running a vehicle should be treated, as well as expenses like entertainment; when FBT applies and an introduction to Payroll where you’ll explore how various aspects of wages are treated in the BAS.

BAS Report and PAYG Introduction

After correctly coding all of these transactions, you’ll set up the Financial Settings of a Business in Xero and MYOB with regard to the GST registration (Cash vs Accrual and quarterly vs monthly). You’ll run a BAS report, which is combined with our specially-designed “Ad Hoc Payroll” Excel spreadsheet case study calculations in order to work out the final liabilities.

As you progress through this course you’ll see the results of the business owners ‘change of strategy’ and focus for the business. You’ll see what these results look like at the end of the quarter, as well as month-by-month comparisons of Profit and Loss and Balance Sheet reports.

Decisions Based on Financial Reports

At the end of the course you’ll explore how the business owner can use the information in the reports to change the direction of the business, as well as how he will be able to configure their software to obtain even better reports at the end of the next quarterly reporting period.

Apart from performing all of a businesses compliance requirements, decision making is one of the biggest reasons for business to maintain detailed records and use computerised accounting software.

 

Xero & MYOB Payroll Beginners Certificate Training Course

Cloud-based accounting software is always up-to-date so PAYG tables and other information like Superannuation percentages are included with the software with no need to go through an updating/upgrading process.

This course is ideal for:

• Job seekers
• Business owners & office admin staff
• Junior accounts staff who want career progression

Xero and MYOB Payroll Setup

• Xero and MYOB Payroll Course – Setting our user permissions
• Xero and MYOB Payroll Course – Payroll Settings – Linked Account Setup (r)
• Xero and MYOB Payroll Course – Payroll Settings – Payslips Setup
• Xero and MYOB Payroll Course – Payroll Settings – Pay Items Setup
• Xero and MYOB Payroll Course – Payroll Settings – Calendar Setup
• Xero and MYOB Payroll Course – Payroll Settings – Super Setup

Manage your Employees

• Xero and MYOB Payroll Course – Employees – Details
• Xero and MYOB Payroll Course – Employees – Employment
• Xero and MYOB Payroll Course – Employees – Tax Declaration
• Xero and MYOB Payroll Course – Employees – Leave
• Xero and MYOB Payroll Course – Employees – Bank Accounts
• Xero and MYOB Payroll Course – Employees – Pay Template
• Xero and MYOB Payroll Course – Employees – Opening Balances

Processing Payroll using Xero and MYOB

• Xero and MYOB Payroll Course – Timsheets – Entering Timesheet Information
• Xero and MYOB Payroll Course – Pay Runs – Posting a simple pay run
• Xero and MYOB Payroll Course – Pay Runs – Pay Run Options

• Xero and MYOB Payroll Course – Create a New Company File
• Xero and MYOB Payroll Course – Set up your Company Details
• Xero and MYOB Payroll Course – Add your Payroll Bank Account
• Xero and MYOB Payroll Course – Set up your Payroll Liability and Expense accounts
• Xero and MYOB Payroll Course – Create Pay Calendars
• Xero and MYOB Payroll Course – Create Employee Cards

Xero Payroll Course – Payroll Dashboard

• Xero and MYOB Payroll Course – Familiarise Yourself with the Pay Items
• Xero and MYOB Payroll Course – Allowances, Termination Payment, Ordinary Hours, Overtime hours and more
• Xero and MYOB Payroll Course – Deductions, Reimbursements and Leave Categories
• Xero and MYOB Payroll Course – FBT, Leave Payments, Post-Tax and Pre-Tax Deducations
• Xero and MYOB Payroll Course – Pay Templates
• Xero and MYOB Payroll Course – Information about the Superannuation Guarantee
• Xero and MYOB Payroll Course – Superannuation Types – Fixed, Percentage of Earnings or Statutory Rate
• Xero and MYOB Payroll Course – Setting Pay Periods
• Xero and MYOB Payroll Course – Perform a Pay Run
• Xero and MYOB Payroll Course – Print & Email Pay Slips to Employees
• Xero and MYOB Payroll Course – Pay Runs & Payroll Activity Reports
• Xero and MYOB Payroll Course – Suggestions/Recommendations
• Xero and MYOB Payroll Course – Create a Card for a New Company Employee
• Xero and MYOB Payroll Course – Create a New Account
• Xero and MYOB Payroll Course – Create a New Pay Item
• Xero and MYOB Payroll Course – Update Employee Payroll Details & Perform Pay Runs
• Xero and MYOB Payroll Course – Edit a Pay Run

Xero and MYOB Payroll Reporting Course

• Xero and MYOB Payroll Course – Print a Payroll Activity Summary Report
• Xero and MYOB Payroll Course – Print a Payroll Employee Summary
• Xero and MYOB Payroll Course – Reconcile Superannuation & Wages
• Xero and MYOB Payroll Course – Reconcile the PAYG Taxes
• Xero and MYOB Payroll Course – Reconcile Liabilities to Balance Sheet

EOY Xero and MYOB Payroll Procedures

• Xero and MYOB Payroll Course – Create EMPDUPE
• Xero and MYOB Payroll Course – Print out the Payment Summaries

Xero and MYOB Payroll Course – Employer Obligation Information

• Differences between full-time, part-time and casual employees
• Salary Sacrificing
• Employer Obligations relating to Super
• Employee Eligibility Criteria for Superannuation
• Pay Slip Requirements
• TFN Declaration Forms

 

Xero and MYOB Advanced Payroll Administration Training Course

• Xero and MYOB Payroll Administration Course – Set up Timesheet Preferences
• Xero and MYOB Payroll Administration Course – Edit an Existing Super Payroll Category
• Xero and MYOB Payroll Administration Course – Create a New Super Payroll Category
• Xero and MYOB Payroll Administration Course – Add a New Payroll Category
• Xero and MYOB Payroll Administration Course – Edit Employment Classifications to Suit the Business
• Xero and MYOB Payroll Administration Course – Create a Casual Employee in Xero
• Xero and MYOB Payroll Administration Course – Create Permanent Employees in Xero
• Xero and MYOB Payroll Administration Course – Enter Timesheets in Xero
• Xero and MYOB Payroll Administration Course – Process a Pay Run
• Xero and MYOB Payroll Administration Course – Import Timesheets
• Xero and MYOB Payroll Administration Course – Process Payroll with Personal Leave included
• Xero and MYOB Payroll Administration Course – Create a New Deduction Payroll Category
• Xero and MYOB Payroll Administration Course – View Employee Leave Accrued
• Xero and MYOB Payroll Administration Course – Process Pay including Annual Leave
• Xero and MYOB Payroll Administration Course – Run a Payroll Entitlements Report
• Xero and MYOB Payroll Administration Course – Run a Payroll Journal Report
• Xero and MYOB Payroll Administration Course – Produce a Balance Sheet
• Xero and MYOB Payroll Administration Course – Record your Bank Details
• Xero and MYOB Payroll Administration Course – Record Employee Bank Details
• Xero and MYOB Payroll Administration Course – Process a Pay Run
• Xero and MYOB Payroll Administration Course – Create an Electronic Payment File
• Xero and MYOB Payroll Administration Course – Process Final Pay
• Xero and MYOB Payroll Administration Course – Update Employee Card File

 

Xero Accounting Cashflow, Budgets & ROI Training Course

Xero Cashflow Reporting, Budgets & ROI Training Course follows the scenario and case study featured in our Xero GST, Reporting and BAS Course by expanding on the sample company scenario for an extra quarter for BAS and Reporting purposes.

What’s included

In this Xero Training Course you’ll learn how to import the bank transactions (rather than enter them manually that we teach in the Xero Daily Transactions “Essentials” Training Course) and manage the many and varied transactions that our typical entrepreneur, Jerry, enters into, for instance:

• getting a commercial building loan
• buying a commercial property
• completing a real estate agents’ course (because he’s changing business direction and running several enterprises at the same time).

Controlling spend

In this Xero course we explore the typical overspending that some new entrepreneurs go through and understand how these transactions affect the cashflow of a business.

You’ll learn about the financing, operational and investment aspects of a cashflow statement and about alternative strategies that a business can take regarding its spending and credit risk management.

You’ll go through other Credit Management reports like Aged Receivables and understand the tools available to small businesses for:

1. reigning in their accounts receivable
2. getting money into their bank accounts quicker
3. using their accounting software to help perform better marketing and operational management by budgeting and understanding their Return On Investment.

Accounting for real-world changes for start ups

You’ll explore some business opportunities that reveal how corporate employees can become small business owners and consultants in their local area with the use of cloud accounting software. These are some of the topics included:

• Changing a business name
• Subscribing to HiPages (HomeImprovementPages.com.au) and using it as a lead source for trades
• Real estate agents’ course and setting up a real estate agency
• How to earn money selling software training courses – including creating quotes, invoice and receiving payments
• Advertising on LinkedIn to find a real estate agent employee
• Setting up a professional WordPress website
• Exploring strategies to win regular work
• Using car trailers as an advertising medium
• Borrowing cost for Cubbyhole
• How to make a loan and purchase transaction for Cubbyhole commercial warehouse
• Deposit and loan for commercial property purchase
• Making changes to inventory
• Creating invoices for sales and marketing contract work
• Importing bank statements to save on data entry
• Creating bank rules
• Matching transactions for bank statements from a bank file
• Create transactions for BAS refund
• Accounting for motor vehicle depreciation
• Accounting for commercial premises depreciation
• PAYG & superannuation
• Cash flow statements
• Setting budgets
• Return on investment (ROI) analysis

Real life case study examples

Learn about the experiences as an entrepreneur traverses the leap from one business type to another; how he manages financials, marketing and work life balance.

 

Xero Accounting Projects Training Course

Measuring the true profitability of a small labourers building project

In this course you will learn the importance of keeping track of all product AND labour costs for every project. You’ll see how the erection of a small tin shed can actually cost the builder money once he start to have to use his truck and some extra men to collect the shed in it’s original packaging, lay down a concrete slab and require several trips to the hardware store for components that wasn’t planned for as well as the costs associated with being rained out on one of their days on site.

Here’s a summary of the activities that you’ll learn to track.

Key elements in this case study are:

1. Some products are in stock in the builders truck, others need to be bought to complete the job
2. Cost of labourers time to dig a plot for the rio and put aside on the site
3. Trips to the hardware shop for wood and nails for formwork
4. Time to build and assemble the formwork
5. Leave the project halfway through the day
6. Filling the formwork with concrete but needing to buy another 10 bags because they underestimated the volume needed
7. Fill and smooth the concrete then leave for the day
8. Collect and deliver the shed to the site (requires 2 people)
9. Cost of unknowns at the site like no power, negotiating with the neighbour and getting an extension cord
10. Calling over a third person who is working 25 minutes away because they need him to erect the shed

At the end you will see how much the estimator quoted, how much the whole exercise cost and whether that little project was even worth doing.

 

Ultimate Microsoft Office Excel Training Course Package

Certificate in Microsoft Excel

• Uses for and working with Microsoft Excel spreadsheets
• Microsoft Excel Structure: Columns, Rows and Cells
• Formulas, Functions and Formatting

Course Outline: Certificate in Microsoft Excel

Intermediate Certificate in Microsoft Excel

• Viewing and Printing
• Charts and Graphs
• Functions and Cell Referencing

Course Outline: Certificate in Intermediate Microsoft Excel

Advanced Certificate in Microsoft Excel

• Databases, Filter/Sort, Named Ranges
• Pivot tables, 3D Formulas, Advanced Formulas and Protection
• Financial Functions, Data Consolidation and Solver

Course Outline: Certificate in Advanced Microsoft Excel