Course Program

Let’s take a quick look at what you are going to learn
when you study the Certificate IV in Accounting and Bookkeeping with Applied Education.

Our course trainers have recorded detailed tutorials to guide you through the course. Study along with them using your course manuals or even watch on the go, they are a great resource to further your understanding of the course.

Introduction

1. FNSACC323 Perform Financial Calculations

FNSACC323 Perform Financial Calculations describes the skills and knowledge required to use a range of routine calculation methods and techniques when performing routine financial calculations and checking calculation outcomes.

The following short videos are recorded by chapter, so you can easily follow while working through your learner guide.

Course Content - Online Tutorial Topics

Chapter 1-1 - Overview
Chapter 2-1 - Data, Tools and Resources
Chapter 2-2 - Computers and Financial services software
Chapter 2-3 - Spreadsheets
Chapter 3-1 - Basic calculations
Chapter 3-2 - Multiplication
Chapter 3-3 - Division
Chapter 3-4 - Addition
Chapter 3-5 - Subtraction
Chapter 3-6 -Order of Operations BIMDAS
Chapter 4-1 - Percentages
Chapter 4-2 - Fractions
Chapter 4-3 - Decimals Chapter 5-1 - Credit Interest
Chapter 5-2 - Simple Interest
Chapter 5-3 - Compound Interest
Chapter 5-4 - Loan repayment Calculations
Chapter 5-5 - GST Calculations
Chapter 5-6 - Income Tax
Chapter 5-7 - Business Records
Chapter 5-8 - Keeping Accurate Records
Chapter 6-1 - Straight Line Graphs
Chapter 6-2 - Mark-up and break even
Chapter 6-3 - Straight Line Depreciation
Chapter 6-4 - Recheck data
Chapter 7-1 - Checking for errors
Chapter 8-1 - Policies and Procedures
Chapter 9-1 - Practice activities Q1-27
Chapter 9-2 - Practice activities Q28-36

2. BSBTEC302 Design and produce spreadsheets & BSBTEC402 Design and produce complex spreadsheets

BSBTEC302: This unit describes the skills and knowledge required to develop spreadsheets through the use of spreadsheet applications.

It applies to individuals employed in a range of environments who tend to be personally responsible for designing and working with spreadsheets under minimal supervision. These individuals are generally required to have intermediate knowledge and understanding of a number of spreadsheet applications.

BSBTEC402: This unit describes the skills and knowledge required to use spreadsheet software to complete business tasks and produce complex documents.

The unit applies to individuals employed in a range of work environments who require skills in creation of complex spreadsheets to store and retrieve data. They may work as individuals providing administrative support within an enterprise, or may be independently responsible for designing and working with spreadsheets relevant to their own work roles.

Course Content - Online Tutorial Topics

Topic 1 - Understanding the Excel Screen and Navigation
Topic 2 - Basic Data Entry, Creating, Saving and Opening Workbooks
Topic 3 - Creating a Template Part 1: Working with Worksheets and Layout
Topic 4 - Creating a Template Part 2: Formatting Text and Titles
Topic 5 - Creating a Template Part 3: Formatting Numbers
Topic 6 - Creating a Template Part 4: Creating Totals Using Formulas and Functions
Topic 7 - Creating a Template Part 5: Working With Percentages and Absolute Cell References
Topic 8 - Creating a Template Part 6: Linking Cells and and Using the IF Function
Topic 9 - Finalising and Reviewing a Template - Applying Final Touches and Testing Formulas
Topic 10 - Using a Template
Topic 11 - Charts: Selecting Chart Types and Creating Charts
Topic 12 - Charts: Changing Chart Locations and Creating a PDF
Topic 13 - Importing Text Files into Excel
Topic 14 - Cleaning Up Imported Text Files, Adding Formatting and Formulas
Topic 15 - Creating a Macro and Saving a Macro Enabled Workbook

3. FNSACC426 Set up and Operate a Computerised Accounting System

FNSACC426 Set up and Operate a Computerised Accounting System describes the skills and knowledge required to establish, operate, and modify an integrated computerised accounting system.

The following short videos are recorded by chapter, so you can easily follow while working through your learner guide.

Course Content - Online Tutorial Topics

Chapter 1-1 Get Started
Chapter 2-1 Creating a Company File
Chapter 2-2 Accessing the Accounts List
Chapter 2-2 Deleting Accounts
Chapter 2-2 Accessing the Accounts List
Chapter 2-2 Deleting Accounts
Chapter 2-2 Editing Account Details
Chapter 2-2 Header and Detail Accounts
Chapter 2-2 Indenting Accounts
Chapter 2-3 Backup Company Files
Chapter 2-3 Exiting and Opening MYOB
Chapter 2-3 Restoring the Company File
Chapter 2-3 Setting Preferences
Chapter 3-1 Open Existing Data File
Chapter 3-2 Spend Money
Chapter 3-2 Receiving Money
Chapter 3-3 Bank Reconciliation
Chapter 4-1 Using the Transaction Journal
Chapter 4-2 Establishing Petty Cash
Chapter 4-2 Raising the Float
Chapter 4-3 Purchases from Petty Cash
Chapter 4-3 Chapter Reconciliation and Reports
Chapter 5-1 Credit Sales
Chapter 5-2 Cash Sales
Chapter 5-3 Depositing Cash
Chapter 5-4 Cash Refunds
Chapter 5-5 Receive Payments
Chapter 5-6 Issue Credit Notes
Chapter 5-7 Chapter Reconciliation and Reports
Chapter 6-1 Cash Sales of Stock
Chapter 6-2 Credit Sales of Stock
Chapter 6-3 Receive Payments
Chapter 6-4 Prepare Bank Deposit
Chapter 6-5 Chapter Reconciliation and Reports
Chapter 7-1 Reviewing Purchase Transactions
Chapter 7-2 Checking Invoices Received
Chapter 7-3 Recording Purchase Transactions
Chapter 7-4 Adding a New Supplier
Chapter 7-5 Inventory Returns
Chapter 7-6 Modifying transactions
Chapter 7-7 Common Supplier Reports
Chapter 7-8 Paying Suppliers
Chapter 7-9 Adding New Inventory
Chapter 8-1 New Company File Assistant
Chapter 8-2 Accounts Easy Setup Assistant
Chapter 8-3 Customise Easy Setup Assistant
Chapter 8-4 Sales Setup Assistant
Chapter 8-5 Purchases Setup Assistant
Chapter 8-6 Accounting for Opening Stock
Chapter 9-1 Month End Adjustment for Depreciation
Chapter 10-1 Customising Forms
Chapter 10-2 Printing and emailing forms
Chapter 10-3 Debtor Management
Chapter 10-4 Bad and Doubtful Debts
Chapter 11 - has not been recorded, as the information in this chapter has already been covered in earlier chapters, and the higher level of understanding Inventory is not required by the criteria of this unit. You will look at inventory much closer in a future unit FNSACC405 Maintain Inventory Records.
Chapter 12-1 Introduction to Final Chapter
Chapter 12-2 Adjusting Entries
Chapter 12-3 Closing Financial Year
Chapter 12-4 Reversing Entries

4. FNSACC321 Process financial transactions and extract interim reports

FNSACC321 Process financial transactions and extract interim reports describes the skills and knowledge required to prepare and process routine financial documents, prepare journal entries, post journal entries to ledgers, prepare banking and reconcile financial receipts, and extract a trial balance and interim reports.

The following short videos are recorded by chapter, so you can easily follow while working through your learner guide.

Course Content - Online Tutorial Topics

1-1 - Case Study Introduction
2-1 - The fundamentals of accounting - part 1
2-2 - The fundamentals of accounting - part 2
3-1 - Credit transactions and customer and supplier invoices
3-2 - Raising client invoices in MYOB 3-2 - Raising client invoices in MYOB
3-3 - Checking invoice accuracy and creating a PDF
3-4 - Entering supplier tax invoices
3-5 - Checking the purchases transaction journal
4-1 - Identifying and resolving discrepancies and errors
4-2 - Processing customer credits and adjustments
4-3 - Processing supplier credits and adjustments
5-1 - Financial record keeping concepts
6-1 - Data integrity and accuracy concepts
6-2 - Running journal reports to check data accuracy
6-3 - Running general ledger reports to check data accuracy
7-1 - Processing customer payments
7-2 - Processing bank deposits
8-1 - Making a single payment to a creditor
8-2 - Grouping payments to creditors or suppliers
8-3 - Creating the bank file and generating an electronic payment report
9-1 - Bank reconciliation concepts
9-2 - Performing a bank reconciliation
9-3 - Creating a bank reconciliation report
10-1 - Reporting concepts
10-2 - Creating a trial balance report
10-3 - Creating a balance sheet report
10-4 - Creating a profit and loss report
11-1 - Petty cash concepts
11-2 - Setting up a petty cash float
11-3 - Entering petty cash transactions
11-4 - Reimbursing petty cash
11-5 - Reconciling and reporting on petty cash
12-1 - General journal entry concepts
12-2 - Creating a general journal entry

5. FNSACC418 Work Effectively in the Accounting and Bookkeeping Industry

FNSACC418 Work Effectively in the Accounting and Bookkeeping Industry describes the skills and knowledge required to work autonomously and in teams to complete work activities relating to the provision of accounting and bookkeeping services.

The following short videos are recorded by chapter, so you can easily follow while working through your learner guide.

Course Content - Online Tutorial Topics

6. FNSACC405 Maintain inventory records

FNSACC405 Maintain Inventory Records describes the skills and knowledge required to comply with organisational inventory procedures, reconcile inventory records to general ledgers, record inventory flows, prepare schedules and produce ad-hoc reports.

The following short videos are recorded by chapter, so you can easily follow while working through your learner guide.

Course Content - Online Tutorial Topics

Topic 1- Inventory Overview
Topic 2 - Inventory Valuation
Topic 3 - Accounting for Inventory
Topic 4 - Inventory Management
Topic 5 - MYOB Setup and Purchasing
Topic 5 - MYOB Sales and Sales Returns
Topic 5 - MYOB Customer Receipts and Supplier Payments
Topic 5 - MYOB Inventory Reconciliation and Reporting

7. FNSTPB412 Establish and maintain payroll systems

FNSTPB412 Establish and Maintain Payroll Systems describes the skills and knowledge required to record and prepare payroll documentation, respond to enquiries, and process payroll data for manual and computerised systems.

The following short videos are recorded by chapter, so you can easily follow while working through your learner guide.

Course Content - Online Tutorial Topics

1. Online Tutorials Part 1 - Payroll Administration in Australia

2. Online Tutorials Part 2 - Payroll Using MYOB

1-1 - Case Study Introduction - Marks Music
2-1 - Loading tax tables and general payroll information
2-2 - Setting up payroll categories - wages
2-3 - Setting up payroll categories for taxes, superannuation and linked accounts
2-4 - Setting up annual leave for part time and full time employees
2-5 - Setting up personal leave for part time and full time employees
3-1 - Creating a full time employee
3-2 - Creating a part time employee
4-1 - Setting up Single Touch Payroll
5-1 - Processing a pay run
5-2 - Review payroll journal and generate payroll reports
6-1 - Setting up separately identified allowances
6-2 - Processing a pay run with allowances
6-3 - Setting up gross payment and recurring allowances
7-1 - Setting up bonuses
7-2 - Processing a pay run with bonuses
8-1 - Creating after tax deductions
8-2 - Processing a pay run with after tax deductions
8-3 - Paying amounts withheld for liabilities
9-1 - Processing annual and personal leave
9-2 - Producing leave reports
10-1 - Setting up salary sacrificed superannuation for an employee
10-2 - Processing a pay run with salary sacrificed superannuation
10-3 - Setting up employee superannuation contributions after tax
10-4 - Reconciling and producing reports for superannuation
10-5 - Paying superannuation
11-1 - Reconciling payroll using reports
12-1 - Processing the instalment activity statement
12-2 - Paying the instalment activity statement
13-1 - Processing pay runs for employee terminations
13-2 - Updating the employee card file after termination
14-1 - Setting up and reporting on payroll tax
15-1 - Creating a casual employee without a TFN declaration
15-2 - Setting up and entering timesheets
15-3 - Processing a pay run with timesheet hours
15-4 - Setting up and entering a timesheet with overtime
15-5 - Processing a pay run with timesheet hours and overtime
17-1 - End of year reporting

3. Online Tutorials Part 2 - Payroll Using Xero

8. FNSTPB411 Complete business activity and instalment activity statements

FNSTPB411 Complete Business Activity and Instalment Activity Statements describes the skills and knowledge required to process and complete business activity statements (BAS), instalment activity statements (IAS), and other required reports according to compliance requirements.

The following short videos are recorded by chapter, so you can easily follow while working through your learner guide.

Course Content - Online Tutorial Topics

Chapter 1-1 Creating a Business
Chapter 1-2 Operating a Business
Chapter 1-3 Introduction to Actvity Statements
Chapter 1-4 Providing BAS Services
Chapter 1-5 Providing income tax
Chapter 2-1 What is PAYG
Chapter 2-2 PAYG Withhholding
Chapter 2-3 PAYGW and Activity Statements
Chapter 2-4 PAYG Instalments
Chapter 2-5 PAYGI and Activity Statements Pt1
Chapter 2-5 PAYGI and Activity Statements Pt2
Chapter 3-1 The Mechanics of GST - Coming soon
Chapter 3-2 Types of Supply
Chapter 3-3 Methods of calculating GST liability
Chapter 3-4 GST calculation worksheet - GST on purchases
Chapter 3-4 GST calculation worksheet - GST on sales
Chapter 4-1 Luxury Car Tax
Chapter 4-2 Fuel Tax Credits
Chapter 4-3 Wine Equalization Tax
Chapter 4-4 Fringe Benefits Tax
Chapter 5-1 and 5-2 GST payment and recording
Chapter 5-3 BAS Reporting Forms
Chapter 5-4 Completing a BAS Pt1
Chapter 5-4 Completing a BAS Pt2
Chapter 6-1 Cash and Accrual Accounting
Chapter 6-2 The Accounts Method
Chapter 6-3 Interacting with the ATO
Chapter 6-4 Lodgement of accounting records
Chapter 6-5 Payment and refunds
Chapter 6-6 Errors and adjustments
Chapter 6-7 Cash Flow for Tax Liabilities
Chapter 7-1 Tax Codes
Chapter 7-2 Processing transactions in MYOB Pt1
Chapter 7-2 Processing transactions in MYOB Pt2
Chapter 7-2 Processing transactions in MYOB Pt3
Chapter 7-2 Processing transactions in MYOB Pt4
Chapter 7-3 MYOB Baslink Pt1
Chapter 7-3 MYOB Baslink Pt2

9. FNSACC421 Prepare financial reports

FNSACC421 Prepare Financial Reports describes skills and knowledge required to record general journal adjustment entries and to prepare end of period financial reports.

The following short videos are recorded by chapter, so you can easily follow while working through your learner guide.

Course Content - Online Tutorial Topics

Chapter 1
Chapter 2 Part 1
Chapter 2 Part 2
Chapter 5 Part 1
Chapter 5 Part 2
Chapter 8 Part 1
Chapter 8 Part 2
Chapter 9
Chapter 12
Chapter 14 Part 1
Chapter 14 Part 2
Chapter 14 Part 3
Chapter 15
Chapter 17

10. FNSACC414 Prepare financial statements for non-reporting entities

FNSACC414 Prepare Financial Statements for Non-Reporting Entities describes the skills and knowledge required to prepare financial statements for entities that do not have a statutory duty to file financial reports with government agencies and regulators.

The following short videos are recorded by chapter, so you can easily follow while working through your learner guide.

Course Content - Online Tutorial Topics

Chapter 1 - Financial Regulations
Chapter 2 - Business Structures
Chapter 3 - Lesson 1 - Revision of Accounting Concepts
Chapter 3 - Lesson 2 - Balance Day Adjustments
Chapter 3 - Lesson 3 - Depreciation
Chapter 4 - Entering Transactions in MYOB
Chapter 5 - Lesson 1 - Financial Statements
Chapter 5 - Lesson 2 - Statement of Cashflow
Chapter 6 - Reporting using MYOB
Chapter 7 - Lesson 1 - Financial Statement Analysis
Chapter 8 - Lesson 1 - Partnerships
Chapter 8 - Lesson 2 - Partnerships in MYOB
Chapter 9 - Not for Profits

11. FNSACC412 Prepare Operational Budgets

FNSACC412 Prepare Operational Budgets describes the skills and knowledge required to prepare and document operational budgets for a variety of organisations.

The following short videos are recorded by chapter, so you can easily follow while working through your learner guide.

Course Content - Online Tutorial Topics

Chapter 1-1 - Budget outline
Chapter 2-1 - Accounting Concepts
Chapter 3-1 - Financial Plan
Chapter 4-1 - Forecasting overview
Chapter 4-2 - Forecasting Techniques
Chapter 4-3 - Forecasting Example
Chapter 5-1 - Budgetary Control
Chapter 5-2 Performance Indicators
Chapter 6-1 - Budgeting
Chapter 7-1 - Budgets Overview
Chapter 8-1 - Master Budgets
Chapter 9-1 Operating Budgets
Chapter 9-2 - Sales Budgets
Chapter 10-1 - Fixed and Flexible budgets
Chapter 11-1 - Cash Budgets
Chapter 12-1 - Budgeting behaviour
Chapter 13-1 - Variance Analysis
Chapter 13-2 - Variance Calculations
Chapter 14-1 - House of Hats - Case Study
Chapter 15-1 - Budget Visualisations

12. FNSACC322 Administer Subsidiary Accounts and Ledgers

FNSACC322 Administer Subsidiary Accounts and Ledgers describes the skills and knowledge required to reconcile and monitor subsidiary accounts and ledgers in financial accounts receivable and accounts payable systems. This includes identifying bad and doubtful debts, communicating with identified clients, and planning a recovery action, recording creditor invoices, and remitting payments to sundry creditors.

The following short videos are recorded by chapter, so you can easily follow while working through your learner guide.

Course Content - Online Tutorial Topics

Chapter 1 - Basic Accounting concepts
Chapter 2 -1 Set Up a Free Trial
Chapter 2 -2 Navigating Xero
Chapter 2 -3 Set up a Bank Account
Chapter 2 -4 Understanding Bank feeds
Chapter 2 -5 Find your Bank Account Transactions
Chapter 2 -6 Bank Reconciliations
Chapter 3 - Accounts Receivable
Chapter 4 - Accounts Payable
Chapter 4 -1 Xero Updated Batch Payments Feature
Chapter 5 - Generating Key Reports

Get the Course Guide

Course Program

Home

Courses

Students

Contact

Student Login

Get a detailed Certificate IV in Accounting & Bookkeeping course guide