The following practice questions are from our Level 3 QuickBooks Training Course in South Florida. We use these questions as samples to the topics we cover in our live class. If these are the types of questions or topics you are interested in elarning please check out our Level 3 – Advanced QuickBooks Class.
How many types of Custom Reports can be created from scratch in QuickBooks?
- Only one Custom Report called “Detail Custom Report”
- There are 2 reports, one is called the Profit & Loss and the other The Balance Sheet
- There are 2 custom reports: “Summary” and “Detail”
- There are no Custom Reports in QuickBooks
- There are hundreds of custom reports built-in to quickbooks
How many different standard reports are there in QuickBooks?
- 17 Standard Reports
- There are 2 reports, one is called the Profit & Loss and the other The Balance Sheet
- There are only 2 reports: “Summary” and “Detail”
- There are over 100 of standard reports built-in to QuickBooks
- None of the Above
What are “Filters” when customizing a report?
- To remove all erroneous transactions
- To remove any profanity from the reports
- To show only the transactions that match within the filtered options
- Is used to choose which columns will display and which will not
- To choose which user can see the report being customized
Which is an example of what can be searched in the Advanced Find feature?
- Can only find advanced transactions such as journal entries and accounting adjustments
- Can search any transactions that match the filters you enter
- Can search checks and bills for a specific vendor
- Can search invoices that are over $1000
- Answers B, C, and D are correct.
What are the difference between the search features in Simple Find vs. Advanced Find?
- No feature difference… just the Simple Find is easier to use
- Simple Find is limited to a specific transaction type and Advanced Find can search all transactions types if desired.
- Are different, because Simple can only find 10 transactions at the time vs. advanced is unlimited
- You can access both these features by hitting F3 on the keyboard
- All the above are correct
Why use the “Search” feature in QuickBooks (by hitting F3) vs. the Find feature?
- Search is faster, because no filters need to be entered
- Search has many more filtering capabilities that Find
- Search will only search in the MEMO field
- Search allows you search classification types in Google
- All the above are correct
How can you build a custom report?
- Go to Reports, Custom Report (Choose Summary or Detail)
- Open a Standard Report and customize it by using filters and add/remove columns
- Go to Advanced Find, work with the filters, click on FIND… and then click on Report to display the found transactions as a report
- All the above are correct
- None of the Above
Which feature allows the user to add a custom text box to an invoice that is not built-in QuickBooks… and also the contents of that box can be searched via the Advanced Find?
- In the List Menu, User Boxes
- Use Custom Fields
- When customizing a form, click on Add New Text Box
- QuickBooks does not let you do this
- None of the above
What are “Classes” in QuickBooks?
- In the Classes Menu, these are videos that teach you how to use QuickBooks
- There are Departments or Cost Centers that allow the user to track income and expenses in multiple classes within one QuickBooks file
- These are the expense categories you need to choose when writing a check
- These are Inventory Categories
- All the above are correct
What are the challenges when using classes?
- Balance Sheet by Class tends to look messy, specially the bank accounts
- Creates more work for the user as they have to choose a class on EVERY transaction
- It’s tricky for single transactions that must be allocated to multiple classes. Specially overhead-type of transactions like Rent.
- All the above are correct
- None of the Above
What are the advantages of using classes?
- You get to see a Profit & Loss by class and determine with department or cost-center in the company is most profitable
- Allows you to filter those categories when doing custom reports
- It decreases the amount of data-entry work
- A and B only are Correct
- All of the Above
What is a Sales Order?
- Is a form to confirm an inventory purchase with your vendor
- Is a sales form for your customers to confirm an order, but the invoice will be created later when the inventory is shipped
- Is another name for an Invoice
- Is a way to create “backorders” for selling products that are not in stock
- B and D are Correct
Which versions of QuickBooks do NOT have the Sales Order Feature?
- QuickBooks Online
- QuickBooks Mac
- QuickBooks Pro
- QuickBooks Premier/Enterprise
- Answer A, B, and C
Generally, which reports does the CPA or Tax Preparer need at year-end?
- Profit & Loss, Balance Sheet, and General Ledger
- A/R Aging and A/P Aging
- Inventory Valuation Report
- Last month’s Bank Reconciliation Report
- All of the above
Assuming is a cash basis tax-payer, does not sell inventory, no invoices, no bills are ever created in QuickBooks… What report(s) does the CPA or Tax Preparer need at year-end?
- Profit & Loss, Balance Sheet, General Ledger, and Last month’s Bank Reconciliation Report.
- A/R Aging and A/P Aging
- Inventory Valuation Report
- Cash-Basis Tax Report
- All of the above
Which of these accounting principles help the QuickBooks user understand better the work inside QuickBooks they do and how it relates to Financial Statements?
- Revenue Recognition: Invoice dates match the date of the completed service and/or delivered product
- Expense Matching: the date of the expenses match the dates of the income in which the expenses most closely relate to income.
- Consistency: similar transactions are treated the same every time they appear
- Understanding difference between cash basis and accrual basis reports
- All of the Above
What is Negative Inventory?
- Is when you inventory looses value
- Is inventory you have in stock, but not available for sale
- Is an accounting error when invoices where created with sale inventory items, but the receipt of this items where never done in QuickBooks
- Answers A, B and C are correct
- Answers A and C are correct
What type of actions can cause a “Reconciliation Discrepancy” even after the account was reconciled correctly?
- Creating new bank accounts without the CPA’s permission
- Deleting or Changing the value of a previously reconciled transaction
- Deleting a transaction that was not previously reconciled
- Manually “unchecking” or “unclearing” a previously reconciled transaction
- Answers B and D are correct
What type of beginning balances should NOT be entered via journal entries?
- Inventory, because every item with its qty/cost should be entered separately
- Accounts Receivable, because every customer with its balance should be entered separately
- Accounts Payable, because every vendor with its balance should be entered separately
- All of the above are correct
- None of the above are correct, because EVERY balance should always be entered with a journal entry
Why use QuickBooks Desktop over QuickBooks Online?
- Online is simpler and has less features
- Desktop allows you to run unlimited company files without additional cost
- Desktop is better for inventory
- Desktop is faster because does not require an internet connection
- All of the Above
When using QuickBooks Desktop, why choose Premier over Pro?
- Premier has some industry specific functions and reports
- Premier can do Sales Orders, Pro cannot
- Premier has the Inventory Center, and Pro does not
- Premier allows you to create a Purchase order from an Estimate or Sales Order
- All of the Above
When using QuickBooks Desktop, why choose Enterprise Edition over Pro/Premier?
- Enterprise can handle up to 30 users
- Enterprise has better user-level permissions and restrictions
- Enterprise works better over a network environment with multiple users
- Enterprise does not have an item limitation
- All of the Above
If you notice that a customer deposit is posting to a sales account, and the invoice that was supposed to be paid by that particular deposit. How can you fix it?
- Delete the deposit, receive the payment (applying the payment to the open invoice), and finally go to Make Deposits to put the deposit back into the bank account register
- Change the account from income/sale to “Accounts Receivable” – Then go to the Invoice and apply the credit to close the invoice
- Go to the Invoice and click on “Mark as Paid”
- Answers A and B are Correct
- Answers A and C are correct
If you notice that a payment to a vendor made via Write Checks is posting to an expense or COGS account, and the Bill that was supposed to be paid by that particular check is still open. How can you fix it?
- Delete the Check, and go to Pay Bills to make the Bill paid.
- Go to the Bill and click on “Mark as Paid”
- Change the account from expense/cogs to “Accounts Payable” – Then go to Pay bills to apply the credit and close the bill
- Answers A, B, and C are Correct
- Answers A and C are correct
How does QuickBooks handle recurring transactions?
- Go to the Transactions Menu, and click Create Recurring Transaction
- You must first create the first transaction that you would like to make recurring and save it
- Go to the Edit Menu and Click on “Memorize…..” You can also right click inside the transaction to see the “Memorize” option
- Answers A, B and C are Correct
- Answers B and C are correct
How does a negative balance in Accounts Receivable mean?
- I means a customer owes you and is past due
- I means that you wrote off the customer balance because of their inability to pay
- I means that the customer as a credit in their favor and the customer probably paid more than the invoices created
- Answers A and C are correct
- Answers A, B, and C are correct
How do you handle prepayments to a Purchase Order?
- Go to write check, post the payment to a current asset called “Prepayments to Vendors” or “Prepaid expenses” – Put PO number in the memo for reference
- Before receiving the P.O., Go to Pay Purchase Orders in the Home page, and pay the Open P.O.
- Go to write check, post the payment to Accounts Payable, select the Vendor again in the “Customer:Job” dropdown – Put PO number in the memo for reference
- All of the above are correct
- Answers A and C are correct
How does QuickBooks and Excel work together?
- You can easily import excel lists such as customers, vendors, and items into QuickBooks
- You can easily export QuickBooks reports into Excel
- You can easily import/import transaction data from excel into QuickBooks and vice versa
- All of the above are correct
- Answers A and B are correct
We will not be posting the answers to these questions. We have designed these questions to be a sample of the topics we cover in our 3-day Certificate QuickBooks course