QBO - Certified QuickBooks ProAdvisor Banking and Reconciliation Questions and Answers

Question 1

A client has set up a bank rule for their monthly internet expense. They configured the rule to apply to transactions over $100 with 'ISP' in the bank description and to categorize it as 'Utilities'. However, they notice transactions matching this rule are still appearing in the 'For Review' tab instead of being automatically added. What is the most likely reason for this?

Accepted Answer

The 'Auto-add' option was not enabled in the rule's settings.

Answer

Bank rules have an option to 'Auto-add' transactions to the register if all conditions are met. If this option is not selected, QuickBooks will apply the rule by suggesting the categorization, but the transaction will remain in the 'For Review' tab for the user to manually confirm.

Question 2

When starting a bank reconciliation in QuickBooks Online, which two values must be manually entered from the bank statement to begin the process?

Accepted Answer

Statement ending balance and statement ending date.

Answer

To start a reconciliation, QuickBooks Online requires the user to input the 'Ending balance' and 'Ending date' directly from the physical or digital bank statement. The beginning balance is automatically carried over from the previous reconciliation.

Question 3

A client is reconciling their checking account for the first time and finds a significant discrepancy. They realize that they have been receiving customer payments into the 'Undeposited Funds' account but have been adding deposits from the bank feed as new income, rather than matching them to the payments. Which of the following describes the impact of this workflow error?

Accepted Answer

Income is overstated, and the Undeposited Funds account is overstated.

Answer

This workflow error results in double-counting income: once when the payment is received against the invoice (crediting income), and a second time when the deposit from the bank feed is categorized directly to an income account. Consequently, the payments remain in the Undeposited Funds account, causing its balance to be overstated.

Question 4

Which of the following actions is NOT a standard option for handling a transaction in the 'For Review' tab of the Banking Center?

Accepted Answer

Record as void

Answer

In the 'For Review' tab, QuickBooks Online allows you to 'Add' a new transaction, 'Find match' to link it to an existing transaction, or 'Record as transfer' between accounts. Voiding a transaction is typically done from the transaction register or the transaction form itself, not directly as a primary action from the bank feed review screen.

Question 5

During a reconciliation, the difference between the statement ending balance and the cleared balance is not zero. After confirming the ending balance and date are correct, what is an effective next step within the reconciliation window to find the discrepancy?

Accepted Answer

Use the filter tools to sort transactions by amount or type to locate a specific transaction or group of transactions causing the difference.

Answer

The reconciliation screen in QuickBooks Online provides filter and sort options. These tools allow the user to narrow down the list of transactions, for example, by searching for a specific amount that matches the discrepancy or by sorting to easily compare blocks of transactions against the bank statement. This is a primary troubleshooting step before taking more drastic measures like undoing a reconciliation or creating an adjustment.

(QBO) Certified QuickBooks ProAdvisor Practice Test

(QBO) Certified QuickBooks ProAdvisor Practice Test

QBO - Certified QuickBooks ProAdvisor Banking and Reconciliation Questions and Answers