QuickBooks ProAdvisor study plan
QuickBooks ProAdvisor · Give each week a clear focus.
8 weeks · About 7 hours per week
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.
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.
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.
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.
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.
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.
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.
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%.