QuickBooks ProAdvisor study materials
QuickBooks ProAdvisor study resources

QuickBooks ProAdvisor study plan

QuickBooks ProAdvisor · Give each week a clear focus.

8 weeks · About 7 hours per week

Week 1

Company Setup and Settings

  • Create a fresh sandbox company file and configure the company profile, fiscal year start, industry, and currency before entering any data.

  • Build a 40-account chart of accounts mapped to a fictional service-plus-retail business, assigning account numbers and correct account types.

  • Configure sales tax (one taxable, one non-taxable rate), payment terms, and invoice/payment defaults, then note how each default changes the entry screen.

  • Add three users with distinct role-based permissions and write down exactly what each role can view, create, and edit.

  • Compile a 15-item settings checklist across accounting, sales, expenses, and payments with the default value and the business reason for changing it.

Your checkpoint

A configured sandbox company file plus a 15-item written setup checklist showing default vs. chosen setting and the downstream transaction each setting affects.

Week 2

Company Setup and Settings & Banking and Transactions

  • Audit the sandbox file against the week-1 checklist and deliberately break then repair five settings to see the effect on existing transactions.

  • Import two months of CSV bank activity into one checking account and confirm opening balance and ending balance match the statement.

  • Categorize 30 downloaded transactions using batch actions and accept/match rules, leaving nothing in the For Review queue.

  • Reconcile the checking account to a zero difference and document the steps taken when the opening balance was locked.

  • Write a short comparison of For Review vs. Reviewed vs. Excluded transactions and how each affects reports.

Your checkpoint

One fully reconciled bank account at $0 difference plus a list of five auto-categorization rules with the exact conditions used.

Week 3

Banking and Transactions

  • Reconcile a second month for two accounts (checking and a credit card), including a mid-month transfer between them.

  • Record owner's equity contribution, owner's draw, and a bank-to-bank transfer, then verify balances move as expected.

  • Seed ten deliberate discrepancies (duplicate, missing check, edited amount, wrong date) and locate each using the reconciliation discrepancy tools.

  • Create five bank rules that combine payee, amount range, and memo conditions and confirm each fires correctly on new imports.

  • Attach source documents to three transactions and match a receipt to a downloaded expense.

Your checkpoint

An error log of all ten seeded discrepancies showing symptom, root cause, and the fix applied, with both accounts reconciled.

Week 4

Sales and Customers (Income)

  • Build a customer list of eight customers with three payment terms and two sales tax assignments, including one tax-exempt customer.

  • Create six invoices, two sales receipts, one credit memo, and one refund, then apply the credit memo and a customer credit to open invoices.

  • Record three customer prepayments/deposits and apply each to a later invoice, confirming the liability clears.

  • Process three customer payments covering a full payment, a partial payment, and an overpayment, and handle the unapplied balance.

  • Run A/R Aging Detail and a Customer Balance Detail report and tie the totals to a hand-built expected-balance schedule.

Your checkpoint

A/R Aging Detail report whose total equals a manually computed expected receivable balance, with every open item traced to its source transaction.

Week 5

Sales and Customers (Income) & Reports and Analysis

  • Set up six products and services across service, non-inventory, and bundle types and verify each posts to the intended income account.

  • Customize Sales by Customer Summary, Sales by Product/Service Summary, and Income by Customer reports with date and customer filters.

  • Build one custom report from scratch, export it to a spreadsheet, and schedule it to email weekly.

  • Run the Sales Tax Liability report, reconcile collected tax against taxable sales, and record the tax payment.

  • Write a two-sentence interpretation of what each of the three sales reports reveals about the fictional business.

Your checkpoint

Three customized sales reports plus one scheduled custom report, exported into a single spreadsheet with a written interpretation beside each.

Week 6

Expenses and Vendors

  • Set up six vendors with default expense accounts, terms, and 1099 tracking flags, including one vendor that must be excluded from 1099s.

  • Enter eight bills and two vendor credits, then apply the credits against the correct bills.

  • Pay six bills through bill payment and record five expenses paid directly at time of purchase, keeping the two workflows separate.

  • Convert a purchase order into a bill and verify the open purchase order report shows only the unconverted remainder.

  • Run A/P Aging Summary and Vendor Balance Detail and tie both to a hand-computed payables schedule.

Your checkpoint

A/P Aging Summary that balances to a hand-computed schedule, with bill payment, direct expense, and vendor credit activity each visible in the detail.

Week 7

Reports and Analysis

  • Generate and save six core reports: Profit & Loss, Balance Sheet, Statement of Cash Flows, A/R Aging, A/P Aging, and Trial Balance.

  • Run the Profit & Loss on both accrual and cash basis and list three accounts where the two versions diverge and why.

  • Customize reports with comparison columns, percent-of-income, collapsed subtotals, and a saved filter set for a fictional client.

  • Verify the Trial Balance nets to zero and the Balance Sheet balances, then trace one transaction from source document to report line.

  • Assemble a five-report client package with a one-page written variance analysis on three accounts.

Your checkpoint

A saved report package of six reports plus a one-page variance analysis explaining the movement in three chosen accounts.

Week 8

Company Setup and Settings & Sales and Customers (Income) & Expenses and Vendors & Banking and Transactions & Reports and Analysis

  • Re-work the 20 most-missed items logged from earlier weeks and re-test each one until correct twice in a row.

  • Complete two timed 60-question practice sets spanning all five domains and record the score for each domain separately.

  • Compress every settings path and report path used in weeks 1-7 into a single 25-line reference sheet.

  • Re-target any domain scoring under 80% with two hours of hands-on rework in the sandbox file and a re-test.

Your checkpoint

A score tracker showing both timed practice sets completed with domain-level results, plus a 25-line path reference sheet covering all five domains.

Milestones

Week 2: Sandbox company file is fully configured and at least one bank account is reconciled to $0 difference with no items left in the For Review queue.

Week 4: Score 80% or higher on a 30-question mixed quiz covering company setup and banking, and A/R Aging total matches the hand-computed expected balance.

Week 6: A/P Aging reconciles to the hand-computed schedule and a 30-question mixed quiz on sales and expenses scores 80% or higher.

Week 8: Both timed 60-question practice sets completed with an overall score of 85% or higher and no domain below 80%.