Xero Course 514 – BAS & Financial Reporting Training Course Workbook BUNDLE

Enrol now for current price & start when you are ready

Original price was: $89.00.Current price is: $44.50. inc GST

This Training Manual and Workbook contains step-by-step tasks using Xero for training case studies based on real world business scenarios for Business Activity Statement reporting to the ATO and Financial Reporting.

This course workbook includes tasks relating to collecting all the business transaction data for a full quarterly reporting season, ensuring all transactions are coded correctly and reconciled and submitting the information to the ATO.

It includes an introduction to payroll and financial reporting.

  • Instant download 
  • PDF format (42 pages)
  • Based on the real-world Messy Startup case study
  • Resources for Xero Advanced Course Certificate
  • Includes:
    • Historical data entry workbook
    • Ad hoc payroll spreadsheet 
    • ATO Weekly pay tables
    • Customising reports and exporting to Excel
    • Intro to Financial Reporting Workbook

This Xero Course training workbook is included when you enrol into the Xero BAS, GST and Financial Reporting Course and Certificate.


Advanced Certificate in Xero Course Case Study: Jerry and the Messy Startup

Jerry Lame Messy Small Business needs Bookkeeping Help - Learn QuickBooks, MYOB and Xero with online courses

We’ve created a real-life start up case study centred around someone who has left the corporate world because they want to start working closer to home and choose their own work hours.

We’ve included factors that are inherent to startups, like director’s loans, wage payments, asset purchases and other activities less common in an established business.

This case study was created to provide students with experience in creating journal entries and understanding what to look for when it comes to asset purchases, depreciation and transactions that contain different components of GST.

At the end of your studies you’ll be able to turn 3 months of messy transactions into accurate financial records. You’ll also learn how to lodge this information using a Business Activity Statement to the ATO.

Learn more about the practical case study included in this course.

Course Contents

  • GST treatment for capital purchases (a vehicle)
  • How different costs of running a vehicle are treated
  • When FBT applies to expenses like entertainment
  • Introduction to Payroll & how wages are treated in the BAS
  • Financial Settings with regard to the GST registration (Cash vs Accrual and quarterly vs monthly)
  • 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
  • See the financial results of the business owners ‘change of strategy’ and focus
  • 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
  • How the business owner can use the information in the reports to change the direction of the business and
  • Configure their software to obtain even better reports at the end of the next quarterly reporting period.

We’ve chosen this case study because it enables us to include a bunch of 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

It includes capital purchases (a vehicle) and how 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.

Ad Hoc PAYG Payroll for Xero & MYOB GST, Reporting & BAS Training CourseBAS Report and PAYG Introduction

After correctly coding the transactions, you will customise the Financial Settings of a Business in Xero 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.

For Micro & Small Businesses you can use other tools like Excel Spreadsheets to perform calculations of obligations like PAYG and then enter the transaction into your accounting software.

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 learn how to analyse financial reports and interpret the data to provide information to the business owner to help him improve the business, as well as how to configure the 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.

BONUS: Customising Financial Reports using Xero

This BAS Course workbook package also includes an introduction guide to customising financial reports using Xero. You’ll export the financial data from Xero to Excel to customise it as you please and learn how to customise the financial report layouts generated by Xero and save them as Custom Reports.

Practical Step-by-step exercises

We believe in learning how to perform payroll tasks by using Xero to perform the tasks you’ll be performing in the workplace.

Learn more about this Messy Startup training case study