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.