QuickBooks ProAdvisor study materials
QuickBooks ProAdvisor study resources

QuickBooks ProAdvisor common mistakes

QuickBooks ProAdvisor · Understand the traps and how to avoid them.

Mistake 1

Entering historical/opening balances as a journal entry against income, expense, or a self-created equity account instead of using each balance-sheet account's Opening Balance field with a proper book start date.

Candidates carry over desktop habits or treat QBO as a blank ledger, so they force a trial balance into a JE and lose the account-level linkage that reports rely on.

What to do instead

Set the start date in Gear > Account and Settings > Advanced > Accounting, then enter the opening balance in each Chart of Accounts balance-sheet account (Account > Edit > Opening Balance). Let QBO offset to Opening Balance Equity and only reclassify OBE to Retained Earnings after the opening Balance Sheet ties out.

Mistake 2

Enabling features such as Track Classes/Locations, Projects, Tags, Sales Tax, Inventory, or Multicurrency only after transactions have already been entered, then expecting existing transactions to carry the new dimension or new currency.

Candidates treat Account and Settings as cosmetic preferences rather than structural switches that change what fields and reports exist.

What to do instead

Turn on every required feature during setup (Gear > Account and Settings > Advanced / Sales / Expenses). Remember multicurrency cannot be switched off once a foreign-currency transaction exists, and class/location must be back-filled by editing each transaction individually.

Mistake 3

Recording a payment against an existing invoice as a Sales Receipt, a Bank Deposit, or a second invoice, leaving the original invoice open and income double-counted.

Candidates see cash arrive and reach for whichever form looks fastest, without checking whether a receivable already exists.

What to do instead

Use Receive Payment and apply it to the open invoice (or Match the bank feed line to the existing payment). Reserve Sales Receipt for sales paid in full at the point of sale where no invoice was ever created.

Mistake 4

Leaving customer payments sitting in Undeposited Funds and never building a Bank Deposit, so the invoice shows paid but the bank balance is short and the downloaded deposit later gets added as new income or left unmatched.

QBO turns on 'Use Undeposited Funds as a default deposit to account' by default, and candidates don't realise the payment has not yet hit the bank account.

What to do instead

Create a Bank Deposit (New > Bank Deposit) and select the payments in Undeposited Funds, then Match the single bank feed deposit to that deposit. Alternatively change the default in Account and Settings > Payments if deposits are always one-for-one.

Mistake 5

Paying a bill that was entered through Bills by using Expense or Cheque (or accepting a bank feed line as 'Add'), which leaves the bill open and records the cost twice.

Candidates think any outflow form is interchangeable and don't distinguish 'entered a bill' from 'paid a bill'.

What to do instead

For anything entered as a Bill, use Pay Bills / Bill Payment and match it to the bank feed line. Use Expense or Cheque only for costs paid immediately with no prior bill.

Mistake 6

Handling a supplier refund or credit by recording a Bank Deposit coded to income or by creating a negative bill, instead of a Vendor Credit.

The money arrives like a deposit, so candidates code it as one and miss that it should reduce an expense or an open payable.

What to do instead

Create a Vendor Credit, then either apply it to an open bill or record the refund against it, and Match the bank feed refund to that transaction. Never code a supplier refund to an income account.

Mistake 7

Accepting downloaded bank transactions with 'Add' when the same transaction was already entered manually (or letting an auto-add rule run unchecked), producing duplicate expenses and income.

Candidates work the For Review queue top-down without first checking whether a matching manual entry already exists.

What to do instead

Check the Match/Recognise tab before adding anything; QBO pre-suggests matches to existing entries. Match rather than Add, review Bank Rules for auto-add behaviour, and exclude transfers between your own accounts instead of recording them as income or expense.

Mistake 8

Forcing a reconciliation to balance by posting a journal entry for the 'difference', or editing/deleting a transaction that was already reconciled, in order to reach the statement ending balance.

Candidates chase the ending balance instead of the discrepancy and take the fastest route to a zero difference.

What to do instead

Work the reconciliation in order: confirm beginning balance equals the prior reconciled ending balance, confirm ending balance and date match the statement, then clear items one at a time. Use the Reconciliation Discrepancy report and Audit Log to find edits to reconciled items, and record genuine bank errors as small adjusting entries only after the cause is identified.

Mistake 9

Reading a Profit and Loss or other report without checking whether it is on an accrual or cash basis, then comparing accrual revenue to the cash in the bank or to a cash-basis figure.

Reports follow the company-level default in settings, and the basis selector on each report is easy to overlook.

What to do instead

Always confirm the Accounting method dropdown on the report toolbar and the default in Account and Settings > Reports. State the basis when interpreting numbers, and use A/R and A/P Aging to explain the gap between accrual profit and bank balance.

Mistake 10

Using the wrong report for the question (a P&L to find unpaid invoices, a Transaction List by Date to explain a control-account balance) or reading a period report as if it were a point-in-time snapshot, without tying totals back to the underlying transactions.

Candidates memorise report names without matching each report to the question being asked or to the correct date semantics.

What to do instead

Match report to question: A/R Aging for unpaid invoices, A/P Aging for unpaid bills, Balance Sheet as of a date for point-in-time balances, P&L over a period for performance. Drill into any total to the transaction detail to confirm the report reconciles before drawing a conclusion.