Advanced QuickBooks Online Plus Training

Topic 1: Working with Multicurrency

Turning on Multicurrency setting

Setting up Home Currency

Transacting in multicurrency

Realized/unrealized Exchange Loss or Gain

QBO Currencies and Exchange Rates

Over-riding exchange rates per transaction

Currency Revaluation

Report customization with multi-currency

Topic 2: Project Management

Setting up Projects

Sub customers or Projects

Locations, Class - Workaround

Items Setup for Job Costing – 2 Sided (Sales and Purchases)

Estimates, Purchase Orders, Invoices, Bills relating to Project

Billable Items and Expenses

Project Budgets & Reports

Topic 3: Working with Budgets

Setting up Budgets - Yearly, Quarterly, Monthly

Prefilling budgets from previous year actual numbers

Subdivision by Customers

Budget Vs Actual Reports & Review

Topic 4 Bank Reconciliation & Locating Discrepancies

Connecting Banks (Only an overview due to sensitivity to show real-time connection to a corporate account)

Uploading Bank Statements Manually

Verifying, adding and posting bank transactions from statements

Bank Reconciliation

Closing accounting periods and managing secured passwords

Changing entries in the closed period

Locating discrepancies in previous reconciled periods

Audit Log

Topic 5 Payroll Management

Setting up Payroll and Employees

Timesheets – Weekly/Daily

Integration with Payroll Apps

Topic 6 Fixed Assets and Depreciation

Creating Fixed Assets Account – at Cost

Creating Accumulated Depreciation Accounts

Categorizing assets

Creating opening balances

Posting Depreciation entries

Hire Purchase agreements and treatment

Transfer and Disposal of fixed assets

Balance Sheet Reports and Review – Fixed Assets

Topic 7 Advanced QuickBooks Reports Customizations

Running Management Reports from the wizard – P&L, Balance Sheet, Ageing Schedule, Supporting Schedules for Income Statement and Balance Sheet

Customizing Reports

Customizing Columns and fields

Saving Customizations

Scheduled Reports

Sharing Reports

Topic 8: GST Tax Return

Handling GST Tax Return

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

Minimum Entry Requirement

Knowledge and Skills

• Able to operate using computer functions
• Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

• Positive Learning Attitude
• Enthusiastic Learner

Experience

• Minimum of 1 year of working experience.

Target Age Group: 18-65 years old

Minimum Software/Hardware Requirement

Software:

Quickbooks Online account (https://quickbooks.intuit.com/sg/pricing/)

Hardware: Window or Mac Laptops

• Accountant
• Bookkeeper
• Financial Controller
• Business Owner
• Finance Manager
• Accounts Payable Specialist
• Accounts Receivable Specialist
• Financial Analyst
• Small Business Consultant
• Office Manager
• Payroll Administrator
• Budgeting Specialist
• Tax Preparer
• Accounting Clerk
• Finance Coordinator

Gary Chan: Gary Chan is a ACTA certified trainer. Gary Chan is a Chartered Accountant (ACCA, UK) and a member of the Institute of Singapore Chartered Accountants (ISCA). He has a MBA in International Business from Henley University (UK) and a Master degree in Strategic Marketing (Ireland). He is an ACTA certified trainer.

Gary has more than 20 years in business and financial management responsibilities in multinationals and local SMEs and more than 10 years’ experience of teaching/training/consulting in financial, business management & development, sales and marketing and leadership.

Bell Ang Chai Huat: Bell Ang is a ACTA certified trainer. Bell Ang is a Certified Practicing Accountant, member of CPA Australia. Approved mentor of Singapore Accountancy Commission. She is an ACTA Certified trainer and Xero Certified Advisor.

With more than 40 years working experience, Bell has held positions both in the Accounting/Finance and IT consultancy positions in various industries.
As an IT consultant, Bell specialises in the financial systems for example, Oracle financial, Scala. She has successfully led and handled more than 20 projects with full implementation and conducted several in-house and clients' trainings.

Malcolm Soo: Malcolm Soo is a ACTA certified trainer. He is a chartered Accountant. Have more than 20 years Accounting/Tax Experience. Currently, a freelance accountant and trainer for the following: LCCI 1 & 2,  Accounting for Non-Financial Professional and QuickBook.

Grace Saw: Grace Saw is an ACTA certified trainer and a Fellow member of ACCA with more than ten years of accounting experience including auditing, financial and management accounting, reporting, consolidation, budgeting, forecasting, taxation as well as financial planning and analysis in diverse industries such as manufacturing, technology, retail, services and hospitality. I am familiar with the FRS framework for Singapore and Malaysia. Besides, I hold a Master of Science in Professional Accountancy from the University of London, and can fluently read and write English, Chinese and Malay. I am an excellent team player and have good project management, problem-solving, multitasking, and interpersonal skills.