QBO Wiki: The Complete QuickBooks Online Knowledge Base for ProAdvisor Certification

Master QBO with our complete wiki — features, workflows, reports & ProAdvisor exam prep tips. 📚 Everything you need in one guide.

QBO Wiki: The Complete QuickBooks Online Knowledge Base for ProAdvisor Certification

If you have ever searched for a reliable qbo wiki — a single, organized reference covering every major feature and workflow in QuickBooks Online — you already understand how scattered the official documentation can feel. QuickBooks Online is one of the most widely adopted cloud-based accounting platforms in the United States, serving millions of small businesses, freelancers, and accounting professionals. Its feature set grows with nearly every product update, making it essential for bookkeepers and ProAdvisors to have a structured knowledge base they can return to repeatedly.

This article is designed to serve that exact purpose. Think of it as your comprehensive QBO reference guide — organized by topic, grounded in real workflows, and optimized for both day-to-day practitioners and candidates preparing for the QuickBooks Online Certified ProAdvisor exam. Whether you are brand new to the platform or a seasoned professional brushing up on advanced tools, this guide covers the terminology, features, and processes you need to know.

QuickBooks Online differs significantly from its desktop counterpart, QuickBooks Desktop. The cloud architecture means automatic updates, multi-user access from any device, and seamless integration with hundreds of third-party apps through the QuickBooks App Store. Understanding these structural differences is not just useful context — it is tested knowledge on the ProAdvisor certification exam. Candidates who treat QBO as simply a web version of Desktop often struggle with questions about banking feeds, class tracking, and cloud-native reporting tools.

The platform currently offers four subscription tiers for small businesses: Simple Start, Essentials, Plus, and Advanced. Each tier unlocks progressively more features, and knowing which features belong to which tier is critical both for advising clients and for passing the certification exam. For example, inventory tracking and project profitability are exclusive to Plus and Advanced, while budgeting by class or location requires the Advanced tier.

Beyond the subscription tiers, QuickBooks Online Accountant (QBOA) serves as the free hub for accounting professionals. QBOA provides access to the ProAdvisor program, client management tools, a consolidated client dashboard, and the practice management suite. Every ProAdvisor candidate should be operating primarily through QBOA rather than logging into each client company file separately — it is more efficient and demonstrates the workflow Intuit expects certified advisors to follow.

The ProAdvisor certification itself is free and available through QBOA. It covers six major content domains: setting up QuickBooks Online, bookkeeping essentials, banking and reconciliation, payroll, advanced accounting tools, and reporting. This wiki-style guide maps closely to those domains so that readers can use it for both practical reference and targeted exam preparation. Each major section below dives deep into one or more of these knowledge areas.

Throughout this guide, you will find concrete examples drawn from real small-business scenarios — a retail shop tracking inventory, a service firm managing projects, a nonprofit reconciling bank feeds — because abstract definitions rarely stick as well as applied context. Bookmark this page and return to individual sections as you encounter those features in client work or exam practice questions.

QuickBooks Online by the Numbers

👥7M+Global QBO SubscribersAs of 2024
📚6Exam Content DomainsProAdvisor certification
🎓FreeProAdvisor Certification CostVia QBOA portal
💻4QBO Subscription TiersSimple Start to Advanced
🌐750+Third-Party App IntegrationsQuickBooks App Store
Qbo Wiki - QBO - Certified QuickBooks ProAdvisor certification study resource

QBO Subscription Tiers: Features at Each Level

🟢Simple Start

Designed for solopreneurs. Covers income and expense tracking, invoicing, mileage, receipt capture, and basic reporting. Supports only one user and does not include bill management or time tracking. Best for freelancers with uncomplicated books.

📋Essentials

Adds bill management, time tracking, and support for up to three users. Includes multi-currency support. Ideal for service businesses that pay vendors and need to track billable hours before sending invoices to clients.

📊Plus

Unlocks inventory tracking using FIFO costing, project profitability, class and location tracking, and budget creation. Supports up to five users. The most common tier for product-based businesses and those needing departmental cost tracking.

🏆Advanced

Includes everything in Plus, plus custom user roles, workflow automation, batch invoicing, revenue recognition, custom fields, and dedicated customer success manager access. Designed for larger small businesses with complex needs.

Banking is the operational backbone of QuickBooks Online, and mastering the bank feed workflow is one of the most important skills both for daily bookkeeping and for the ProAdvisor exam. When you connect a bank or credit card account to QBO, the platform automatically downloads transactions through a live feed. These downloaded transactions appear in the Banking Center and must be reviewed, categorized, matched to existing records, or added as new transactions before the books can be considered current. The matching logic QBO uses is worth understanding in detail.

QBO automatically attempts to match downloaded bank transactions to open invoices, recorded expenses, or previously created transactions. If a payment comes in and an outstanding invoice for the same amount and date exists, QBO suggests a match. Accepting that match marks the invoice as paid and clears the deposit simultaneously — a two-step process that QBO collapses into one click. When no match is found, you must either categorize the transaction manually or create a new record from the banking row itself. Mistakes here cascade into reconciliation problems later.

Bank rules are the power-user feature that dramatically speeds up the banking workflow. A bank rule tells QBO to automatically categorize any transaction meeting specific criteria — for example, any debit from a vendor named "Amazon Web Services" should always be coded to the Software Subscriptions expense account. Rules can apply to single amounts, amount ranges, descriptions that contain or start with specific text, and even specific bank accounts. Well-constructed rules can reduce manual categorization time by 60 to 80 percent for established businesses with predictable transaction patterns.

Reconciliation in QBO follows the same logic as paper-based bank reconciliation but is significantly faster when the bank feed is kept current. Navigate to Accounting, then Reconcile, select the account, enter the ending balance and statement date from your bank statement, and QBO displays all cleared and uncleared transactions. The goal is for the difference to reach zero — meaning every transaction on the bank statement is accounted for in QBO. Transactions that appear in QBO but not on the statement are outstanding items; transactions on the statement but missing from QBO indicate data entry errors.

A common reconciliation problem that exam candidates should understand is the duplicate transaction. Duplicates arise when a manually entered transaction and a downloaded bank feed transaction are not matched but are instead both added as separate records. The reconciliation difference will equal the duplicate amount, and the fix is to find and delete the extra record. Another frequent issue is recording a payment to the wrong bank account — for instance, posting a check drawn on the operating account to the payroll account. These errors cause one account's reconciliation to fail while the other shows an unexplained surplus.

Undoing a reconciliation in QBO Advanced is a feature worth knowing. Standard QBO tiers do not allow users to undo an entire reconciliation — they can only manually uncheck individual transactions. In Advanced, a dedicated Undo option resets the entire reconciliation period, which is useful when a prior-period error is discovered after the books were closed. This is a tier-differentiating feature that appears on the ProAdvisor exam and is an important data point when advising clients on whether to upgrade their subscription.

The reconciliation history report in QBO provides a record of every completed reconciliation, including the date it was performed, the user who performed it, the beginning and ending balances, and whether any transactions were modified after the reconciliation was finalized. This audit trail is invaluable for identifying who made post-reconciliation changes and when. For clients under audit or those who have had bookkeeping staff turnover, pulling the reconciliation history report is often the first diagnostic step when investigating unexplained discrepancies in prior periods.

QBO Advanced Accounting Tools 2

Test your knowledge of journal entries, budgets, and class tracking in QBO.

QBO Advanced Accounting Tools 3

Practice questions covering revenue recognition, custom fields, and workflow automation.

QBO Reporting: Core Reports Every ProAdvisor Must Know

The Profit and Loss report (also called the Income Statement) summarizes revenue, cost of goods sold, and operating expenses over a selected date range, resulting in net income or net loss. In QBO, the P&L can be customized to show data by class, location, customer, or product — enabling granular profitability analysis that goes far beyond a simple total. Comparing two periods side by side helps identify trend anomalies worth investigating.

ProAdvisor candidates should know how to run a Profit and Loss by Class report to evaluate departmental performance, and how to toggle between cash and accrual basis within the same report. Cash basis shows revenue when collected and expenses when paid; accrual basis recognizes revenue when earned and expenses when incurred regardless of cash movement. The ability to switch between both views without re-entering data is one of QBO's most practical cloud-native advantages over legacy systems.

Qbo Wiki - QBO - Certified QuickBooks ProAdvisor certification study resource

QuickBooks Online vs. QuickBooks Desktop: Which Is Right for Your Clients?

Pros
  • +Automatic software updates with no manual installation required — clients always use the current version
  • +Access from any device with a browser, enabling remote bookkeeping and multi-office teams
  • +Bank feed automation reduces manual data entry and accelerates month-end close
  • +Native integration with payroll, payments, and 750+ third-party apps in the ecosystem
  • +Real-time collaboration between the business owner and their accountant simultaneously
  • +Automatic data backup stored securely in Intuit's cloud infrastructure, eliminating local backup failure risk
Cons
  • Monthly subscription cost adds up over time compared to a one-time Desktop license purchase
  • Inventory management is less robust than Desktop Enterprise for complex manufacturing workflows
  • Internet dependency means a connectivity outage can halt bookkeeping work entirely
  • Some advanced job costing features available in Desktop Premier are not available in QBO Plus
  • Data migration from Desktop to QBO can lose historical transaction detail in some complex files
  • Customization of forms and reports is more limited than Desktop's advanced template builder

QBO Advanced Accounting Tools 4

Challenge questions on multicurrency, consolidations, and advanced QBO reporting tools.

QBO Advanced Accounting Tools 5

Practice advanced QBO scenarios including audit log review and user permission settings.

ProAdvisor Exam Prep Checklist: QBO Features You Must Know Cold

  • Identify which features belong to each QBO subscription tier (Simple Start, Essentials, Plus, Advanced).
  • Explain the bank feed matching workflow and how to resolve unmatched transactions correctly.
  • Create and apply bank rules to automate transaction categorization for recurring vendor payments.
  • Perform a month-end reconciliation and identify common causes of reconciliation differences.
  • Run and interpret the Profit and Loss, Balance Sheet, and Statement of Cash Flows reports.
  • Set up class and location tracking for departmental or multi-location cost reporting.
  • Configure the chart of accounts including account types, detail types, and opening balances.
  • Process payroll runs in QuickBooks Payroll and explain the payroll liability posting logic.
  • Record journal entries for accruals, prepaid expenses, and depreciation adjustments.
  • Use the Audit Log to investigate changes made to transactions in a client's QBO file.

The Audit Log Is the Examiner's Favorite Diagnostic Tool

The QBO Audit Log records every action taken in a company file — who made a change, what the original value was, and what the new value is. On the ProAdvisor exam, audit log questions appear regularly in the advanced accounting domain. In practice, pulling the audit log is the fastest way to identify whether a client or a staff member inadvertently modified a reconciled transaction, voided an invoice, or deleted a payment — all without ever asking the person directly.

Payroll is one of the most consequential areas of QuickBooks Online, both because payroll errors carry legal and tax compliance risk and because it represents a major revenue stream for ProAdvisors who offer full-service bookkeeping. QuickBooks Online Payroll integrates directly into the QBO company file, meaning payroll runs automatically post journal entries, update payroll liabilities, and sync with the P&L without any manual import or export steps. Understanding how this integration works is essential for both advising clients and answering payroll questions on the ProAdvisor certification exam.

There are three tiers of QuickBooks Payroll: Core, Premium, and Elite. Core handles automated payroll runs, tax calculations, and next-day direct deposit. Premium adds same-day direct deposit, an HR support center, expert review of payroll setup, and time tracking via QuickBooks Time (formerly TSheets). Elite adds tax penalty protection — meaning Intuit will pay penalties and interest if the platform calculates taxes incorrectly — plus a dedicated payroll expert and on-demand HR.

When advising a client on which payroll tier to choose, the size of the team, the complexity of benefit deductions, and the client's risk tolerance around payroll tax errors are the key factors to discuss.

Payroll setup in QBO requires collecting specific information before processing the first run. This includes each employee's federal and state W-4 withholding information, pay frequency (weekly, biweekly, semimonthly, monthly), compensation type (salary or hourly), benefit deductions (health insurance, 401k, HSA), garnishments, and direct deposit banking details. The setup wizard in QBO Payroll guides users through each field, but errors in W-4 data or deduction percentages will cause incorrect withholding that must be corrected with amended filings — a time-consuming and client-damaging outcome.

The payroll tax filing workflow is largely automated in QuickBooks Payroll Premium and Elite. Federal tax deposits are made electronically on the IRS-required schedule (semiweekly or monthly depending on deposit liability). State tax filings are handled by the platform in most states.

At year end, W-2 forms are generated automatically based on the year's payroll data, and the platform files them electronically with the Social Security Administration. For ProAdvisors managing payroll for multiple clients, the QBOA payroll dashboard provides a consolidated view of upcoming tax deposits and filing deadlines across all client files — a critical workflow management tool during the January year-end crunch.

Understanding payroll liabilities is a frequently tested area on the ProAdvisor exam. When payroll is processed, QBO records gross wages as an expense and creates liability entries for the employee's tax withholdings (federal income tax, state income tax, Social Security employee share, Medicare employee share) plus the employer's matching payroll taxes (Social Security employer share, Medicare employer share, FUTA, SUTA). These liabilities accumulate until the scheduled tax deposit date, at which point the payment reduces the liability balance to zero.

If a client is showing large, growing payroll liability balances in an older period, it is a red flag that tax deposits were missed.

Time tracking integration is a feature that bridges project management and payroll. When QuickBooks Time is connected to QBO Payroll, employee hours flow directly from the time tracking app into the payroll run, eliminating the need for manual hour entry and reducing the risk of transcription errors. For businesses billing clients by the hour, approved time entries in QuickBooks Time can also populate billable hours on customer invoices — creating a single source of truth that links employee time to both labor cost and revenue. This integration is exclusive to the Premium and Elite payroll tiers.

Contractor payments in QBO follow a different process than employee payroll. Contractors are set up as vendors rather than employees, and payments are recorded as vendor bills or direct checks. At year end, QBO tracks contractor payments and helps generate 1099-NEC forms for any contractor paid $600 or more during the tax year. The 1099 workflow in QBO requires that the vendor record be marked as a 1099 vendor and that the appropriate expense account be mapped to the correct 1099 box — a setup step that is easy to overlook but critical for accurate year-end compliance reporting.

Qbo Wiki - QBO - Certified QuickBooks ProAdvisor certification study resource

Preparing for the QuickBooks Online Certified ProAdvisor exam requires a structured study strategy rather than passive reading of help articles. The exam consists of approximately 80 questions covering six content domains, and passing requires a score of at least 80 percent. Candidates who treat the exam as a casual familiarity check consistently underperform; those who study systematically — working through each domain with practice questions and hands-on QBO exercises — pass on their first attempt at a much higher rate.

Intuit provides free training through the QuickBooks Online Accountant portal under the ProAdvisor tab. The training is organized by content domain and includes video lessons, knowledge checks, and study guides. However, many candidates find that the official training alone is insufficient for exam preparation because it emphasizes what features exist rather than testing the application of those features in scenario-based questions. Supplementing official training with third-party practice exams — which present realistic multiple-choice scenarios and explain the reasoning behind correct answers — significantly improves both confidence and scores.

The six exam domains and their approximate exam weights provide a roadmap for study prioritization. Setting up QuickBooks Online covers company setup, chart of accounts, and user permissions. Bookkeeping essentials covers the accounting cycle, journal entries, and accounts receivable and payable management. Banking and reconciliation covers the bank feed workflow, bank rules, and reconciliation procedures. Advanced accounting covers budgets, class tracking, multicurrency, and journal entries for adjustments. Payroll covers setup, processing, tax filing, and contractor payments. Reporting covers standard and custom reports, cash versus accrual basis, and management dashboards.

Hands-on practice in a sample company file is the most effective complement to video training and practice questions. QBO provides a sample company (Craig's Design and Landscaping Services) that candidates can explore freely without affecting real client data. Walking through the full accounting cycle in this sample company — entering invoices, recording payments, connecting a practice bank feed, reconciling the account, and running financial statements — builds muscle memory for the steps that exam questions test. Describing these workflows in writing after practicing them is an excellent retention technique.

Time management during the actual exam is worth planning deliberately. With 80 questions and a 90-minute window, you have slightly over one minute per question. Most questions can be answered in 30 to 45 seconds, which builds a buffer for the longer scenario questions that require reading a client situation and identifying the correct QBO procedure. Flag any question you are uncertain about and return to it after completing the rest of the exam — do not let a single difficult question consume disproportionate time at the expense of easier points elsewhere.

The exam can be retaken if you do not pass on the first attempt, with no waiting period or additional cost. However, the question bank rotates between attempts, so simply memorizing specific questions from a failed attempt is not an effective strategy. Instead, diagnose which content domains received the lowest scores (Intuit provides domain-level feedback after each attempt) and focus additional study on those areas before retaking. Most candidates who fail on the first attempt and study their weak domains systematically pass on the second attempt.

Once certified, the ProAdvisor badge can be displayed on your firm's website and profiles. More importantly, the ProAdvisor directory listing on the Find-a-ProAdvisor website generates warm client leads — business owners searching for QuickBooks help are directed to certified advisors by location and specialty. Maintaining certification requires annual recertification as Intuit releases a new exam each year reflecting updated QBO features. Treating recertification as a learning opportunity rather than a chore ensures your QBO knowledge stays current as the platform evolves.

Advanced accounting tools in QuickBooks Online extend the platform's capabilities well beyond basic bookkeeping, and these features receive significant coverage on the ProAdvisor certification exam. Budgeting is one such tool — QBO Plus and Advanced allow users to create annual budgets by account, and optionally by class or location. Once a budget is set, the Budget vs.

Actuals report compares real performance against projected performance for any period, making it an indispensable tool for business owners managing toward specific financial targets. Advisors who help clients build realistic budgets and review them monthly provide a measurably higher level of service than those who only handle compliance bookkeeping.

Multicurrency is a QBO feature that enables businesses transacting in foreign currencies to record and report in their home currency while automatically applying exchange rate conversions. When multicurrency is enabled on a QBO company file, each foreign-currency transaction is recorded at the exchange rate on the transaction date.

When the customer pays or the vendor is paid, the actual exchange rate at the time of payment may differ from the original rate, creating a realized gain or loss. QBO records this gain or loss automatically to an account called Exchange Gain or Loss, which appears on the P&L. Multicurrency cannot be turned off once enabled, which is an important advisory caution before activating it for a client.

Class tracking allows businesses to segment their P&L by internal divisions, product lines, service types, or any other meaningful grouping. Each transaction line item can be assigned to a class, and the Profit and Loss by Class report then shows revenue and expenses for each class side by side. A consulting firm might use classes to track profitability by service type (strategy, implementation, training); a nonprofit might use classes to track spending by program. Location tracking works similarly but is oriented toward geographic or physical locations — a retail chain might use locations to compare store-level performance across multiple branches.

Journal entries in QBO are used for adjustments that do not fit the standard transaction types — accruals, prepaid expense amortization, depreciation, reclassifications, and corrections. Unlike invoices or bills, journal entries require direct debit and credit entries and do not generate customer or vendor records. ProAdvisors should understand when a journal entry is the appropriate tool versus when a transaction type like a vendor credit or customer credit memo would accomplish the same result more cleanly. Overusing journal entries — particularly to correct categorization errors — bypasses the audit trail clarity that properly recorded transactions provide.

The chart of accounts in QBO is the foundation of accurate financial reporting. Every account has a type (asset, liability, equity, income, expense, cost of goods sold, other income, other expense) and a detail type that maps to the appropriate line on tax forms. When setting up a new client's QBO file, auditing the chart of accounts before entering any transactions prevents downstream reporting problems.

Common setup errors include using the wrong account type (recording a long-term loan as a current liability), creating duplicate accounts with slightly different names, or failing to mark accounts as sub-accounts when a parent-child hierarchy would improve report readability.

Custom fields in QBO Advanced extend the data model beyond the standard transaction fields. A construction company might add a custom field for project permit number; a law firm might add a custom field for matter ID. Custom fields appear on transactions and can be used as report filters, enabling highly targeted data analysis that would otherwise require exporting to Excel.

The availability of custom fields is one of the most compelling upgrade arguments for moving clients from QBO Plus to QBO Advanced, particularly for businesses that currently maintain parallel tracking systems outside of QBO to compensate for data model limitations.

Workflow automation in QBO Advanced allows the system to automatically send payment reminders, invoice follow-ups, or internal approval requests based on triggers and conditions. For example, a workflow can automatically email a customer a payment reminder three days before an invoice is due and again seven days after it becomes overdue — without any manual action from the bookkeeper.

For advisory firms managing QBO on behalf of clients, automation reduces the time spent on repetitive communication tasks and ensures consistent follow-through that improves client cash flow. Understanding how to configure and troubleshoot workflows is increasingly valuable as QBO Advanced adoption grows among larger small businesses.

QBO Banking and Reconciliation 2

Test your bank feed, matching, and reconciliation skills with realistic QBO scenarios.

QBO Banking and Reconciliation 3

Advanced reconciliation practice including bank rules and prior-period correction techniques.

QBO Questions and Answers

About the Author

Dr. Lisa Patel
Dr. Lisa PatelEdD, MA Education, Certified Test Prep Specialist

Educational Psychologist & Academic Test Preparation Expert

Columbia University Teachers College

Dr. Lisa Patel holds a Doctorate in Education from Columbia University Teachers College and has spent 17 years researching standardized test design and academic assessment. She has developed preparation programs for SAT, ACT, GRE, LSAT, UCAT, and numerous professional licensing exams, helping students of all backgrounds achieve their target scores.

Join the Discussion

Connect with other students preparing for this exam. Share tips, ask questions, and get advice from people who have been there.

View discussion (6 replies)