QuickBooks Online
Advanced Certification
Exam Prep Training
Module 2:
Advanced Features
Intuit Confidential and Proprietary
Agenda
MODULE 1: Advanced Categorization
MODULE 2: Advanced Features
MODULE 3: Advanced Banking
MODULE 4: Advanced Reports
MODULE 5: Inventory Management
MODULE 6: Sales Tax
MODULE 7: Special Transactions
MODULE 8: Multicurrency
MODULE 9: End-of-period activities
MODULE 10: Complex Conversions
Intuit Confidential and Proprietary 3
Additional Resources
QuickBooks Accountant Training: Firm Of The Future Blog: Intuit Marketing Hub:
[Link] [Link] [Link]
Intuit Confidential and Proprietary 4
CPE Process
In order to receive CPE credit in each training session, you must:
• Be present for a minimum of 50 minutes to earn 1 CPE credit.
• Respond to 75% of the checkpoints during each session
• Answer 1 polling question per hour during each session
• If all requirements are met, your CPE appears in your USER PROFILE in the virtual conference
within 24 hours. And, you will receive an email with your CPE attached from:
intuit@[Link] (please add to your approved contacts)
• If you only meet the above requirements in part, your CPE will be processed manually. Your
certificate will be emailed to you within 2 weeks following the close of the event.
• Example, 2-hour training session, you only attend 1-hour and meet all other requirements
during that hour. You will receive partial credit.
Intuit Confidential and Proprietary 5
Exam Prerequisites
Member of QuickBooks ProAdvisor Program
QuickBooks Online Certified
Proficient with accounting principles
Have hands-on experience using QuickBooks Online Accountant and supporting
QuickBooks Online clients.
Have deep product knowledge and/or experience with client engagements using
QuickBooks Online
Intuit Confidential and Proprietary 6
Exam Candidate Expectations and Things to Know
Understand advanced topics
Comprehend training material
Ability to work through scenario-based questions
Draw on your expertise and trusted advisor role
No CPE for exam itself. However, live training is eligible for CPE.
Exam may be completed in any order
Multiple-choice questions may contain one or more correct answer(s)
Intuit Confidential and Proprietary 7
How to Access Training & Exam
Intuit Confidential and Proprietary 8
QuickBooks Online Advanced Certification
5 Sections
Multiple choice, submit each section, then submit
all sections for grading; 80% or better each section
to pass
Only need to re-take sections not passed
3 Attempts to pass; 60-day lockout after 3
successive not pass attempts
Intuit Confidential and Proprietary 9
Recertification and Leveling Up
Once certified, you can also continue your journey with a range of additional courses
that will add to your knowledge and impress clients.
– ProAdvisor additional courses: Visit [Link]
– ProAdvisor certification badges:
Recertify every year between April to June 30 on what’s new in QuickBooks Online to
maintain core and advanced certification status for another year.
Gain Advanced Certification between 11/1/20 to 10/31/21 – recertify by June 30, 2022
Intuit Confidential and Proprietary 10
QuickBooks Online
Advanced Certification
Exam Prep Training
MODULE 2: Advanced Features
Intuit Confidential and Proprietary
Module 2: Advanced Features
LEARNING OBJECTIVES
In this module, you’ll learn how to:
Define a billable expense and the features
of QuickBooks Online that facilitate their
management and tracking
Identify best practices when working with
billable expenses in QuickBooks Online
Recognize when and how to utilize
QuickBooks Online to set up, record and
invoice billable time
Identify how to run reports showing billable
time
Intuit Confidential and Proprietary 13
Module 2: Advanced Features
LEARNING OBJECTIVES
In this module, you’ll learn how to:
Recognize when and how to utilize delayed
charges and credits
Identify process for identifying unbilled
charges
Recognize how to manually batch-create
and send invoices for unbilled charges
Identify why and how to utilize progress
invoicing
Intuit Confidential and Proprietary 14
Module 2: Advanced Features
LEARNING OBJECTIVES
In this module, you’ll learn how to:
Identify how to utilize Price Rules
Recognize how to turn on and configure the
Tips functionality
Recognize the benefits of setting up
budgets
Identify how budgets and budget reports
work in QuickBooks Online
Intuit Confidential and Proprietary 15
Module 2: Advanced features
Lesson 1: Billable Expenses
Lesson 2: Billable Time
Lesson 3: Delayed Charges
Lesson 4: Batch Create and Send Invoices
Lesson 5: Progress Invoicing
Lesson 6: Price Rules
Lesson 7: Tips
Lesson 8: Budgeting
Intuit Confidential and Proprietary 16
Introduction to Billable Charges
Non-posting transactions
Billable expenses
Billable time
Delayed Charges
Intuit Confidential and Proprietary 17
QuickBooks Online
Advanced Certification
Exam Prep Training
MODULE 2: Advanced Features
LESSON 1: Billable Expenses
Intuit Confidential and Proprietary
Billable Expenses: Setup
Intuit Confidential and Proprietary 19
Billable Expenses – Account Limitations
You can use the following account types when marking an expense billable:
• Expense
• Other expense
• Other current liabilities
• Other current assets
• Other assets
• Fixed assets
• Cost of Goods Sold
Intuit Confidential and Proprietary 20
Create a Billable Expense
Intuit Confidential and Proprietary 21
Add a Billable Expense to an Invoice
Intuit Confidential and Proprietary 22
Billable Expenses: Setup – Markup
Intuit Confidential and Proprietary 23
Billable Expenses: Using Markup
Intuit Confidential and Proprietary 24
Billable Expenses: Using Markup
Intuit Confidential and Proprietary 25
Billable Expenses: Using Markup
Intuit Confidential and Proprietary 26
Billable Expenses: Setup – Track as Income – Single
Intuit Confidential and Proprietary 27
Billable Expenses: Setup – Track as Income – Single
Intuit Confidential and Proprietary 28
Billable Expenses: Setup – Track as Income – Single
Intuit Confidential and Proprietary 29
Billable Expenses: Setup – Track as Income – Multiple
Intuit Confidential and Proprietary 30
Billable Expenses: Setup – Track as Income – Multiple
Intuit Confidential and Proprietary 31
Billable Expenses via Item
Intuit Confidential and Proprietary 32
Billable Expenses via Item
QuickBooks will
use the income
account
mapped the
item when the
billable expense
is added to an
invoice
Intuit Confidential and Proprietary 33
QuickBooks Online
Advanced Certification
Exam Prep Training
MODULE 2: Advanced Features
LESSON 2: Billable Time
Intuit Confidential and Proprietary
Billable Time
Non-posting transactions
Can enter for employee or vendor
If using QuickBooks Online Payroll, time can flow to the paycheck
Can set up Time-tracking only users in Essentials, Plus, and Advanced
Intuit Confidential and Proprietary 35
Billable Time: Setup
Intuit Confidential and Proprietary 36
Billable Time
Optionally enter billable rate and taxable status on time activity
You can enter more than 24 hours in a day
QuickBooks shows hours and minutes whether you enter as decimal or enter
start and end time
Intuit Confidential and Proprietary 37
Billable Time: Using
Intuit Confidential and Proprietary 38
Time Tracking Reports
• Recent/Edited Time Activities
• Time Activities by Customer Detail
• Time Activities by Employee Detail
• Unbilled Time
Intuit Confidential and Proprietary 39
QuickBooks Online
Advanced Certification
Exam Prep Training
MODULE 2: Advanced Features
LESSON 3: Delayed Charges
Intuit Confidential and Proprietary
Delayed Charges
Non-posting transactions
Not prompted by time or purchase
Can be made recurring
No setup required
You can also create delayed credit
Intuit Confidential and Proprietary 42
Delayed Charge
Intuit Confidential and Proprietary 43
Tracking Billable Charges
Intuit Confidential and Proprietary 44
Tracking Billable Charges
Intuit Confidential and Proprietary 45
Tracking Billable Charges
Intuit Confidential and Proprietary 46
Tracking Billable Charges
Intuit Confidential and Proprietary 47
QuickBooks Online
Advanced Certification
Exam Prep Training
MODULE 2: Advanced Features
LESSON 4: Batch Create and Send Invoices
Intuit Confidential and Proprietary
Batch Create Invoices
Intuit Confidential and Proprietary 49
Batch Create Invoices
Intuit Confidential and Proprietary 50
Batch Send Invoices
Intuit Confidential and Proprietary 51
Batch Send Invoices
Intuit Confidential and Proprietary 52
Batch Send Invoices – Report on Sent Invoices
Intuit Confidential and Proprietary 53
QuickBooks Online
Advanced Certification
Exam Prep Training
MODULE 2: Advanced Features
LESSON 5: Progress Invoicing
Intuit Confidential and Proprietary
Progress Invoicing – Setup
Progress invoicing is in all levels of QuickBooks
Intuit Confidential and Proprietary 55
Progress Invoicing – Create Estimate
Intuit Confidential and Proprietary 56
Progress Invoicing – Create Invoice
Intuit Confidential and Proprietary 57
Progress Invoicing – Invoicing
A total of all estimate lines: All the lines are
invoiced at 100% of the estimate
A percentage of each line: All the lines are
invoiced at a percent of the estimate, but you can
edit the line amounts or percent
A custom amount for each line: All lines on the
invoice are shown at 0% but you can edit each line
either by percentage or amount
Intuit Confidential and Proprietary 58
Progress Invoicing – Invoice
Intuit Confidential and Proprietary 59
Progress Invoicing – Estimate After Invoice
Intuit Confidential and Proprietary 60
Other options
• Increase/decrease line amounts
• Increase/decrease the total price
• Add or delete a line
Intuit Confidential and Proprietary 61
Add Estimate Summary and Due Info to Emailed Invoice
Intuit Confidential and Proprietary 62
Estimates & Progress Invoicing Summary by Customer Report
Intuit Confidential and Proprietary 63
QuickBooks Online
Advanced Certification
Exam Prep Training
MODULE 2: Advanced Features
LESSON 6: Price Rules
Intuit Confidential and Proprietary
When to recommend Price rules
Percentage – increase or decrease the price by a fixed percentage Gold Tier
Ex. VIP membership or a 25% off sale Member
Fixed discount – increase or decrease by a fixed amount
Ex. Promotional offer $100 off for a limited time!
Custom price per item – specific pricing per item LIMITED TIME
Ex. Negotiated pricing SALE!
Intuit Confidential and Proprietary 65
Intuit Confidential and Proprietary 66
Turn on Price Rules
Intuit Confidential and Proprietary 67
Customer types
Intuit Confidential and Proprietary 68
Assign Customer types to your customers
Intuit Confidential and Proprietary 69
Create a price rule
Intuit Confidential and Proprietary 70
Create a price rule
Intuit Confidential and Proprietary 71
Create a price rule - options
Intuit Confidential and Proprietary 72
Create a price rule - options
Intuit Confidential and Proprietary 73
Price rules in sales transactions
Intuit Confidential and Proprietary 74
QuickBooks Online
Advanced Certification
Exam Prep Training
MODULE 2: Advanced Features
LESSON 7: Tips
Intuit Confidential and Proprietary
Tips - Setup
Intuit Confidential and Proprietary 76
Tips – Changing Tip Account
Intuit Confidential and Proprietary 77
Tips – Adding to a Sales Receipt
Intuit Confidential and Proprietary 78
Tips – Adding to a Sales Receipt
Intuit Confidential and Proprietary 79
QuickBooks Online
Advanced Certification
Exam Prep Training
MODULE 2: Advanced Features
LESSON 8: Budgeting
Intuit Confidential and Proprietary
Budgeting
Intuit Confidential and Proprietary 81
Budgeting – Add
Intuit Confidential and Proprietary 82
Budgeting – Add
Intuit Confidential and Proprietary 83
Budgeting – Add
Intuit Confidential and Proprietary 84
Budgeting – Add
Intuit Confidential and Proprietary 85
Budgeting – Reporting
Budget Overview
Filtered for one customer
Intuit Confidential and Proprietary 86
Budgeting – Reporting
Budget vs Actual
Intuit Confidential and Proprietary 87
Next Steps
Intuit Confidential and Proprietary
How to Access Training & Exam
Intuit Confidential and Proprietary 90
QuickBooks Online Advanced Certification
5 Sections
Multiple choice, submit each section, then submit
all sections for grading; 80% or better each section
to pass
Only need to re-take sections not passed
3 Attempts to pass; 60-day lockout after 3
successive not pass attempts
Intuit Confidential and Proprietary 91