Little Square

There's more on
this topic at:

Types of Reports

QuickBooks lets you choose from dozens of different preset reports. To access reports, choose Reports > Report Center. The reports are organized on the left of the center in categories.

Company & Financial
  • Profit & Loss Standard. Summarizes your income and expenses, subtotaled by income or expense account, so you can tell whether you're operating at a profit or a loss. Some people call this type of report an income statement.
  • Profit & Loss Detail. Shows year to date transactions (instead of totals only) for each income and expense account.
  • Profit & Loss YTD Comparison. Like the standard profit and loss statement, but with columns for this year to date, $ change, and % change.
  • Profit & Loss Previous Year Comparison. Like the standard profit and loss statement, but with one column for this month to date and a second column for this year to date.
  • Profit & Loss by Job. Like the standard profit and loss statement, but with columns for each job. Amounts are for this year to date.
  • Profit & Loss by Class. Like the standard profit and loss statement, but with columns for each class. Amounts are for this year to date.
  • Income by Customer Summary. Summarizes year to date sales income by customer and job.
  • Income by Customer Detail. Lists year to date sales (or return) transactions, grouped and subtotaled by customer and job.
  • Expenses by Vendor Summary. Summarizes year to date net expenses by vendor.
  • Expenses by Vendor Detail. Lists year to date expense (or credit) transactions, grouped and subtotaled by vendor.
  • Income and Expense Graph. Compares your income and expenses for the specified time period by account, customer or class; the pie chart at the bottom shows a breakdown of income or expenses (you can choose which you want to see).
  • Balance Sheet Standard. Shows, as of today, the balance in each balance sheet account, with subtotals for assets, liabilities, and equity.
  • Balance Sheet Detail. Shows balances as of last month and today, and shows transactions for each account for this month.
  • Balance Sheet Summary. Shows amounts for each account type but not for individual accounts.
  • Balance Sheet Previous Year Comparison. Has columns for today, a year ago, $ change, and % change.
  • Net Worth Graph. Shows changes in your company's net worth. Total assets (positive amounts) appear as bars above the zero line, total liabilities (negative amounts) appear as bars below the zero line, and net worth (equity) is the difference between your assets and liabilities for each month. The net worth data points are connected to form a line graph. Each small square shows the net worth for that month. You can double-click the assets or liabilities section of a bar to display more detail.
  • Statement of Cash Flows. Shows how your cash flow position changed over a period of time. It shows the amount of cash earned from profit, where you received additional cash, and where your cash was spent.
  • Cash Flow Forecast. Shows expected cash inflows, expected cash disbursements, and expected bank account balances, so you can forecast how much cash you'll have.
Customers & Receivables
  • Accounts Receivable (A/R) Aging Summary. Shows when invoice payments are or were due, subtotaled by customer.
  • Accounts Receivable (A/R) Aging Detail. Lists each unpaid invoice, and open credit memo, grouped and subtotaled by days overdue (aging period). Tells how many days an invoice is overdue.
  • Customer Balance Summary. Shows balances for customers with unpaid balances, as of the ending date.
  • Customer Balance Detail. Lists each invoice, credit memo, payment, cash sale, and general journal entry, subtotaled by customer. Total for customer equals customer's unpaid balance.
  • Open Invoices. Lists each unpaid invoice, grouped and subtotaled by customer.
  • Collections Report. When you specify a number of days, this report displays which invoices are overdue by that number of days, along with customer names and phone numbers so you can contact delinquent customers.
  • Accounts Receivable Graph. Shows how much your customers currently owe you, and how much is overdue by up to 30, 60, 90, and over 90 days. The pie chart at the bottom shows a breakdown of unpaid balances by customer.
  • Unbilled Costs by Job. Shows job-related expenses that have not yet been charged to customers.
  • Transaction List by Customer. Lists all the customer-related transactions (invoices, customer payments, etc.) that occurred within a particular time period. Customer Phone List. Shows each customer's name and phone number. The information comes from your Customer:Jobs list.
  • Customer Phone List. Shows each customer's name and phone number. The information comes from your Customer list.
  • Customer Contact List. Shows your customer's name, contact person, billing address, phone number, and the customer's open balance.
  • Item Price List. Shows the sales price, name, description, and preferred vendor of each item on your Item list.
Sales
  • By Customer Summary. Summarizes your sales income (for parts, services, discounts, or other charges) by customer for this month.
  • By Customer Detail. Like the customer summary report, but with sales transactions listed for each customer.
  • By Item Summary. Summarizes your month to date unit and dollar sales, subtotaled by invoice item (for parts, services, discounts, or other charges).
  • By Item Detail. Like the item summary report, but with sales transactions listed for each line item for this month.
  • By Rep Summary. Summarizes your sales income (for parts, services, discounts, or other charges) by employee for this month.
  • By Rep Detail. Like the employee summary report, but with sales transactions listed for each employee.
  • Sales Graph. Shows sales income for the period of time that you specify. The bar graph at the top shows your company's sales income for each month from invoices, credit memos, and sales receipts. The pie chart at the bottom shows a summary of your sales broken down by item, customer, or sales rep.
  • Pending Sales. Lists all invoices, cash sales, and credit memos that are marked as pending. Shows the account that is affected when the sale is marked as final.
Jobs & Time
  • Job Profitability Summary. Compares the actual cost to the actual revenue for all customers and jobs. The report subtotals the data first by customer and then by job.
  • Job Profitability Detail. For a particular customer or job, compares actual costs to actual revenues and shows the difference between the two amounts. The report subtotals the data first by item type and then by item.
  • Job Estimates vs. Actuals Summary. Compares estimated cost to actual cost and estimated revenue to actual revenue for all customers and jobs showing, in each case, the difference between the two amounts. The report subtotals the data first by customer and then by job.
  • Job Estimates vs. Actuals Detail. For a particular customer or job, compares estimated costs to actual costs and estimated revenues to actual revenues showing, in each case, the difference between the two amounts. The report subtotals the data first by item type and then by item.
  • Item Profitability. Summarizes how much money your company has made to date from each item that you sell. The report shows the Actual Cost, Actual Revenue, and Difference. A positive number in the Difference column manes you made money.
  • Item Estimates vs. Actuals. For each item, compares estimated cost to actual cost and estimated revenue to actual revenue showing, in each case, the difference between the two amounts. The report subtotals the data first by item type and then by item.
  • Profit & Loss by Job. Like the standard profit and loss statement, but with columns for each job. Amounts are for this year to date.
  • Time by Job Summary. Shows hours worked subtotaled first by customer or job and then by service item.
  • Time by Job Detail. Lists each time activity (that is, work done by one person for a particular customer or job on a specific date) and shows whether the work is billed, unbilled, or not billable. The report groups and subtotals the activities first by customer and job and then by service item.
  • Time by Name. Shows hours worked (or tracked as sick or vacation time) subtotaled first by the name of the person who performed the work and then by the customer or job the person performed the work for.
  • Time by Item. Shows hours worked subtotaled first by service item and then by customer or job.
  • Estimates by job. Lists all active estimates assigned to a customer or job. You can see at a glance how many estimates exist for each customer or job.
  • Unbilled Costs by Job. Lists the costs you assigned to a specific customer or job but have not yet billed as reimbursable expenses.
Vendors & Payables
  • Accounts Payable (A/P) Aging Summary. Shows the aging status of your unpaid bills in your accounts payable account, subtotaled by vendor.
  • Accounts Payable (A/P) Aging Detail. Lists each unpaid bill, subtotaled by aging period. Tells how many days a bill is overdue.
  • Vendor Balance Summary. Shows balances for vendors with unpaid balances, as of the report's ending date.
  • Vendor Balance Detail. Lists all vendor-related transactions, subtotaled by vendor. The total for a vendor equals the vendor's unpaid balance.
  • Unpaid Bills Detail. Lists each unpaid bill, subtotaled by vendor.
  • Accounts Payable Graph. Shows how much you owe your vendors. The bar graph at the top shows how much you currently owe your vendors, and how much is overdue by 30, 60, 90, and over 90 days. The pie chart at the bottom shows a breakdown of your unpaid bills by vendor.
  • Transaction List by Vendor. Lists all vendor-related transactions (bills, bill payments, etc.) that occurred within a period of time.
  • 1099 Summary. Summarizes your cash outflows by vendor for a calendar year. Useful in collecting data for U.S. tax forms 1099-MISC and 1096. You can specify that the report shows only 1099 vendors or 1099 accounts. You can also specify whether the report shows 1099 categories whose amounts fall below IRS threshold requirements.
  • 1099 Detail. Like the 1099 report, but with lists the cash outflow transactions that contribute to each vendor's total. You can specify that the report shows only 1099 vendors or 1099 accounts.
  • Sales Tax Liability Report. Summarizes how much sales tax you billed (or collected) on behalf of each sales tax agency, for the date range you specify. You can specify whether this report is on a cash or accrual basis (choose QuickBooks > Preferences and click Reporting).
  • Pay PST Liability.(Canada) Shows how much you owe each Provincial Sales Tax (PST) agency. Details
  • GST Collected.(Canada) Shows all your increases to your GST Payable account; the GST you charged on invoices, credit memos, cash sales, and any adjustments for the specified date range. The total for the reporting period is the total GST collected or collectible. Details
  • GST Paid.(Canada) Lists all the decreases to your GST Payable account from the tax you paid to vendors and others, as well as any adjustments like the GST included in a bad debt. The total is your input tax credit for the reporting period. The amount from this report is used to fill in field 108 (Total ITC's and Adjustments) on your Goods and Services Tax Return. Details
  • Vendor Phone List. Shows each vendor's name and phone number. The information comes from your Vendor list.
  • Vendor Contact List. Shows each vendor's name, account number, address, phone number, primary contact, and balance total. The information comes from your Vendor list.
Purchases
  • Purchase by Vendor Summary. Summarizes your purchasing expenses by vendor for this month.
  • Purchase by Vendor Detail. Like the previous report, but with credit card charges, bills, vendor credits, and checks listed for each vendor.
  • Purchase by Item Summary. Summarizes your unit and dollar purchases for this month, subtotaled by item.
  • Purchase by Item Detail. Like the previous report, but with credit card charges, bills, vendor credits, and checks listed for each item.
  • Open Purchase Orders. Shows all open purchase orders, including the vendor, PO number, and expected receipt date.

Inventory
  • Inventory Valuation Summary. For each inventory item, shows the quantity on hand, average cost, asset value, sales price, retail value, % of total asset value, and % of retail value. Period of time covered is this month to date.
  • Inventory Valuation Detail. For each inventory item, shows all transactions for this month to date that affect the value of the item. This report has the same columns as the valuation summary report.
  • Inventory Stock Status by Item. For each inventory item, shows quantity on hand, quantity on order, date of next order receipt, and average quantity sold per week. Period of time covered is this month to date.
  • Inventory Stock Status by Vendor. For each inventory item, shows quantity on hand, quantity on order, date of next order receipt, and average sales per week. This report is designed to help you in reordering items.
  • Physical Inventory Worksheet. For each inventory item, shows the preferred vendor and quantity on hand. An empty column lets you write in the actual quantity as you make a physical count of your inventory.
  • Inventory Price List. For each item, shows the item description, preferred vendor, and sales price.
Banking
  • Deposit Detail. Shows detailed information for each bank deposit, including which customers contributed to the deposit (in the Name column) and how you allocated payments from customers (in the Amount column).
  • Check Detail. Shows detailed information for each check, including which expense accounts the check affected (in the Account column) and how you allocated bill payments (in the Paid Amount column).
  • Missing Checks. Lists checks in a bank account by check number, invoices in a receivables account by invoice number, or payments in a current asset account by number. Points out both missing and duplicate numbers.
Accountants & Taxes
  • Trial Balance. Summarizes your debits and credits, subtotaled by each account on your chart of accounts, for people familiar with double-entry accounting.
  • General Ledger. Lists month to date transactions, grouped and subtotaled by each account on your chart of accounts. This report is similar to the transactions by account report.
  • Journal. Breaks down every transaction into debits and credits, showing how QuickBooks does double-entry accounting automatically.
  • Audit Trail. For a date range that you specify, shows any transactions modified during that period and what the modifications were. Can also show deleted transactions. To create this report, you must first select “Use audit trail” (choose QuickBooks > Preferences and click Transactions).
  • Transaction List by Date. Lists all individual transactions for this month by date.
  • Transaction Detail by Date. Lists individual the details of transactions for this month to date. Each account involved in a transaction appears on a separate line. Displays the open balance and the original amount of each transaction.
  • Transaction Detail by Account. Lists the details of individual transactions for this month to date, subtotaled by each account on your chart of accounts.
  • Account Listing. Shows information about the accounts in your chart of accounts, including the account type, balance, and tax code line.
  • Income Tax Summary. Shows the amount associated with each tax line for the tax form you specified in the Company Information window. You choose which account is associated with each tax line.
  • Income Tax Detail. Shows the transactions associated with each tax line for the tax form you specified in the Company Information window. You choose which account is associated with each tax line.
Budgets
  • Profit & Loss Budget Overview. Shows budgeted amounts by month for each income and expense account for which you have set up a budget.
  • Profit & Loss Budget vs. Actual. Compares budgeted amounts for income and expense accounts with actual income and expenses. Shows the difference in dollars and as a percentage of budgeted amount.
  • Profit & Loss Budget by Job Overview.
  • Shows budgeted amounts by month and by job for each income and expense account for which you have set up a budget for a job.
  • Profit & Loss Budget vs. Actual by Job. Compares budgeted amounts for income and expense accounts for each job with actual income and expenses. Shows difference in dollars and as a percentage of budgeted amount.
  • Budget vs. Actual Graph. Shows the difference between your budgeted amounts and the actual amounts you earned or spent. The upper bar graph shows your company's actual net income less budgeted net income for each month. A monthly amount is favorable when the actual net income exceeds the budgeted net income. The lower bar graph shows the income or expense accounts that are the furthest from budget (either over or under).
  • Balance Sheet Budget Overview. Shows annual income and expense budgeted amounts by job. The period of time covered is the fiscal year to date.
  • Balance Sheet Budget vs. Actual. Compares budgeted balances for balance sheet accounts with actual balances. Shows the difference in dollars and as a percentage of budgeted balance.
List
  • Account Listing. Lists each account's name, type, balance, description, and tax line.
  • Item Price List. Lists the name, description, price, and preferred vendor for each item and service you sell.
  • Item Listing. Lists the name, description, type, quantity on hand, price, cost, quantity on purchase order, reorder point, and preferred vendor for each item and service you sell.
  • Customer Phone List. Lists each customer's name and phone number.
  • Customer Contact List. Lists each customer's name, current balance, phone number, fax number, primary contact, and billing address.
  • Vendor Phone List. Lists each vendor's name and phone number.
  • Vendor Contact List. Lists each vendor's name, current balance, phone number, fax number, primary contact, address, and account number.
  • Employee Contact List. Lists each employee's phone number, Social Security number, and address.
  • Other Names Phone List. Lists each other name's name and phone number.
  • Other Names Contact List. Lists each other name's name, address, phone number, fax number, and primary contact.
  • Terms Listing. Lists each term's name, type, discount, net due days, discount days, and day of month due.
  • To Do Notes. Lists each to do note's description, status, and date.
  • Memorized Transaction Listing. Lists each memorized transaction's description, type, source account, amount, frequency, automatic status, and next date.