QBO Reporting & Reconciliation 1 — Questions and Answers

Question 1: Which QuickBooks report shows a company’s profitability over a specific time period?

Balance Sheet
Trial Balance
Profit and Loss (Correct answer)
Transaction Detail

Correct answer: Profit and Loss

The Profit and Loss (P&L) report, also known as an Income Statement, summarizes a company's revenues, costs, and expenses over a specific time period. It clearly shows whether the business made a profit or incurred a loss, providing a comprehensive view of its financial performance. This report is essential for understanding a company's profitability.

Question 2: Which report would help identify overdue customer payments?

Cash Flow Statement
Sales by Product
Customer Balance Detail
Accounts Receivable Aging Summary (Correct answer)

Correct answer: Accounts Receivable Aging Summary

The Accounts Receivable Aging Summary report categorizes outstanding customer invoices by how long they have been overdue. This report is essential for identifying which customers owe money and for how long, helping businesses prioritize collection efforts. It provides a clear overview of the health of a company's receivables.

Question 3: What is the purpose of reconciling a bank account in QuickBooks?

To create journal entries
To close the accounting period
To match records with bank statement (Correct answer)
To add vendor payments

Correct answer: To match records with bank statement

Reconciling a bank account in QuickBooks involves comparing the transactions recorded in your QuickBooks account with those on your actual bank statement. The purpose is to ensure that both sets of records match, identify any discrepancies, and verify the accuracy of your cash balance. This process helps detect errors, fraud, and ensures your books are accurate.

Question 4: Which report provides a snapshot of company assets and liabilities?

Expense Report
General Ledger
Statement of Cash Flows
Balance Sheet (Correct answer)

Correct answer: Balance Sheet

The Balance Sheet is a fundamental financial statement that provides a snapshot of a company's financial position at a specific point in time. It details the company's assets (what it owns), liabilities (what it owes), and equity (the owner's stake). This report adheres to the accounting equation: Assets = Liabilities + Equity, offering a comprehensive view of financial health.

Question 5: How often should bank reconciliations be performed?

Once per quarter
Monthly (Correct answer)
Only at year-end
Weekly

Correct answer: Monthly

Bank reconciliations should ideally be performed monthly, shortly after receiving your bank statement. Regular monthly reconciliation helps to quickly identify and correct errors, detect fraudulent activity, and ensure the accuracy of your financial records. This consistent practice is crucial for maintaining reliable financial data.

Question 6: Where do you go to start a bank reconciliation in QuickBooks Online?

Banking Tab
Reports Center
Accounting Tab
Gear Icon > Reconcile (Correct answer)

Correct answer: Gear Icon > Reconcile

In QuickBooks Online, to start a bank reconciliation, you typically click on the 'Gear Icon' (Settings) in the top right corner of the screen. From the dropdown menu that appears, you then select 'Reconcile' under the 'Tools' section. This action leads you to the reconciliation screen where you can begin the process.

Question 7: What might cause a reconciliation discrepancy in QuickBooks?

Printing the balance sheet
Changing transaction dates
Deleting reconciled transactions (Correct answer)
Viewing reports in accrual mode

Correct answer: Deleting reconciled transactions

Deleting or altering transactions that have already been reconciled in QuickBooks is a common cause of reconciliation discrepancies. Once a transaction is reconciled, it should not be changed, as this will cause your QuickBooks balance to no longer match the bank statement balance for that period. This disrupts the integrity of your financial records.

Question 8: Which feature in QuickBooks helps customize how reports display data?

Reports Snapshot
Audit Log
Customize Report (Correct answer)
Transaction Detail

Correct answer: Customize Report

In QuickBooks, the 'Customize Report' feature provides users with extensive options to modify how data is displayed. This includes filtering, sorting, adding/removing columns, changing date ranges, and grouping information to meet specific analytical needs. It allows for tailoring reports beyond their default settings, making them more relevant and insightful for business analysis.

Question 9: Which report helps review all financial transactions by account and date?

Vendor Balance Summary
Statement of Cash Flows
General Ledger (Correct answer)
A/R Aging Detail

Correct answer: General Ledger

The General Ledger is a fundamental accounting report that provides a complete record of all financial transactions within an organization. It details every debit and credit for each account, organized by date, offering a comprehensive view of financial activity. This report is crucial for auditing, financial analysis, and ensuring the accuracy of financial statements.

QBO Reporting & Reconciliation 1

Which QuickBooks report shows a company’s profitability over a specific time period?