QBO - Certified QuickBooks ProAdvisor Advanced Accounting Tools Questions and Answers 1 — Questions and Answers
Question 1: A ProAdvisor is cleaning up a new client's books and discovers that dozens of transactions for a specific supplier, 'Creative Consultants,' were incorrectly categorized to the 'Office Supplies' expense account instead of 'Professional Fees.' What is the most efficient tool within QuickBooks Online Accountant to correct these miscategorized transactions in bulk?
- Create a journal entry to move the total amount between the accounts.
- Manually open and edit each individual transaction.
- The Reclassify Transactions tool. (Correct answer)
- Use the 'Write off invoices' tool to clear the incorrect entries.
Correct answer: The Reclassify Transactions tool.
The Reclassify Transactions tool is specifically designed for accountants to find and move multiple transactions between different accounts, classes, or locations at once. This is far more efficient than editing each transaction individually or creating a journal entry, which would not correct the underlying transaction details.
Question 2: A company wants to track its financial performance against a predefined plan. They need to set monthly targets for both income and expenses and then run a report to see how their actual results compare to these targets. Which QuickBooks Online feature is designed for this purpose?
- Projects
- Budgets (Correct answer)
- Management Reports
- Class Tracking
Correct answer: Budgets
The Budgets feature in QuickBooks Online allows users to create financial plans by setting targets for income and expense accounts. QuickBooks can then generate a 'Budgets vs. Actuals' report, which directly compares the budgeted amounts to the actual financial data for a given period, highlighting any variances.
Question 3: An accountant is using the 'Bookkeeping review' tool in QuickBooks Online Accountant to prepare for month-end close. The 'Transaction review' tab flags several expense transactions for having a missing payee. What is the primary accounting reason this is a critical issue to resolve?
- It prevents the bank feed from automatically matching future transactions.
- It can lead to inaccurate vendor expense tracking and incomplete 1099 reporting. (Correct answer)
- It causes the bank reconciliation to be out of balance.
- It violates Generally Accepted Accounting Principles (GAAP) for cash-basis accounting.
Correct answer: It can lead to inaccurate vendor expense tracking and incomplete 1099 reporting.
The 'Bookkeeping review' tool flags transactions without payees because this information is essential for accurate financial reporting and tax compliance. Without a payee, it's impossible to track total expenses by vendor or accurately prepare 1099-NEC forms for qualifying contractors, which is a major compliance risk.
Question 4: A business operates a coffee shop and a separate bookstore, and wants to generate a Profit & Loss statement for each business segment to assess individual profitability. Which feature must be enabled and consistently used on all sales and expense transactions to achieve this?
- Projects
- Sub-customers
- Location Tracking (Correct answer)
- Bank Accounts
Correct answer: Location Tracking
Location Tracking is the feature designed to track income and expenses for different business segments, departments, or physical locations. By assigning a location to each transaction, the business can run a 'Profit & Loss by Location' report to see a side-by-side comparison of each segment's performance.
Question 5: Which of the following is a primary function of the 'Prep for Taxes' tool within QuickBooks Online Accountant?
- To calculate and pay estimated quarterly taxes directly to the IRS.
- To automatically find and reclassify all transactions in 'Uncategorized Expense'.
- To provide a workspace for reviewing accounts and mapping them to lines on a tax form. (Correct answer)
- To create a new company file specifically for tax-related adjustments.
Correct answer: To provide a workspace for reviewing accounts and mapping them to lines on a tax form.
The 'Prep for Taxes' tool is an accountant-specific feature that provides a trial balance view where accountants can review account totals, make adjusting journal entries, and map the Chart of Accounts to the corresponding lines on tax forms like the 1120S or 1065. This streamlines the process of preparing information for tax filing software.
Question 6: A client plans to start invoicing customers in Euros (EUR) in addition to US Dollars (USD). Before their ProAdvisor enables the Multicurrency feature in QuickBooks Online, what is the most critical implication they must explain to the client?
- All existing transactions will be automatically converted to the new primary currency.
- The feature requires an additional monthly subscription fee.
- It significantly slows down the bank feed connection for foreign accounts.
- Once turned on, the Multicurrency feature cannot be turned off. (Correct answer)
Correct answer: Once turned on, the Multicurrency feature cannot be turned off.
Enabling Multicurrency is a permanent change to a QuickBooks Online company file. Once it is activated, it cannot be disabled. This is a crucial piece of information for clients, as it introduces permanent complexity to their accounting, such as tracking realized and unrealized gains and losses on foreign exchange.
A ProAdvisor is cleaning up a new client's books and discovers that dozens of transactions for a specific supplier, 'Creative Consultants,' were incorrectly categorized to the 'Office Supplies' expense account instead of 'Professional Fees.' What is the most efficient tool within QuickBooks Online Accountant to correct these miscategorized transactions in bulk?