Loading your account...

Chapter 7

Communicating Business Performance

Introduction

Management is informed of their company’s business performance by analyzing QuickBooks reports. QuickBooks reports organize and communicate timely, relevant, and reliable financial information to company management to assist them in making better business decisions.

This chapter provides step-by-step guidance for organizing and communicating business performance.

The guidance in the chapter is useful to bookkeepers as well as personnel involved in report activities.

Accounting Process Automation

Accounting process automation automates report organization and communication processes. Automation improves the speed, accuracy, and reliability of business performance communication.

This chapter uses accounting process automation to create, customize, view, and distribute QuickBooks reports.

QuickBooks Reports Tools

QuickBooks is needed to organize and communicate business performance.

Bookkeeper Tasks

Your reporting tasks include:

  1. Generate and review daily, weekly, monthly, quarterly, and annual (year-end) reports
  2. Email daily, weekly, monthly, quarterly, and annual QuickBooks Management Reports

Accountant Tasks

Your accountant’s reporting tasks include:

  1. Customize, group, and schedule your daily, weekly, monthly, quarterly, and annual reports
  2. Provide QuickBooks reports training
  3. Support QuickBooks reports questions and problems
  4. Review your monthly QuickBooks reports

Why Use QuickBooks Reports?

QuickBooks reports is a tool used to convey information regarding your company’s activities or results. QuickBooks reports provide management a snapshot in time to easily analyze their company’s business processes such as sales and receipts, purchases and payments, and overall business performance.

What Are My Responsibilities Regarding Reports?

Your responsibility is to perform the day-to-day bookkeeping and generate and communicate timely, relevant, and reliable financial information to internal (owner, manager, and employee) and external (bank, vendor, and tax agency) users.

Navigating Your QuickBooks Report

Categories and Navigating Reports

The Reports page in QuickBooks organizes the various reports available into different categories. This helps you navigate the page more easily and locate the reports you want to run. You also use the search feature (Find report by name) to search for specific reports by name.

On the reports page, there are three tabs: Standard, Custom reports, and Management reports.

When viewing reports, QuickBooks offers a feature that allows you to “drill down” or access individual transactions and activities that make up your company’s reports. When viewing a report, select any transaction or activity to open it for viewing or editing.

Standard Reports

The Standard reports tab contains the majority of the reports available in QuickBooks. Standard reports are grouped into the following sections:

  • Favorites
  • Business Overview
  • Who Owes You
  • Sales and Customers
  • What You Owe
  • Expenses and Vendors
  • Employees
  • For My Accountant
  • Payroll

To view Standard reports:

  1. From the left menu, select Reports
  2. Select the Standard tab

If the report you’re looking for has been copied to the Favorites section or listed in the Business Overview section, select the name of the report in that section.

If the report has not been copied to the Favorites section or listed in the Business overview section, enter the name of the report in the Search field and select the report name.

Favorites

The Favorites section displays a list of reports that you mark as “favorite”. You mark a report as “favorite” by selecting the Star icon next to any report listed on the Standard tab. The Favorites section saves time by organizing your company’s most used reports in alphabetical order at the top of the page. A green star indicates the report has been copied to the Favorites section.

Note: As part of your QuickBooks setup, your accountant will copy the reports to the Favorites section based on what he or she believes is the most relevant financial information for your company’s specific type of business. The most useful reports are found in the Favorites and Business overview sections.

Business Overview

The Business Overview section contains reports concerning your company’s general finances, activities, and transactions, including account balances, profit and loss, and cash flow statements.

Business Overview reports include:

Audit Log

  1. Accounts involved: No specific accounts are applicable
  2. Description: Displays all your company’s activity chronologically, allowing you to see which individuals have been in your QuickBooks and what they have done

Balance Sheet Comparison

  1. Accounts involved: Assets, Liabilities and Equity
  2. Description: This report communicates your company’s assets, liabilities, and equity compared to the prior year (PY)

Balance Sheet Detail

  1. Accounts involved: Assets, Liabilities and Equity
  2. Description: This report communicates your company’s assets, liabilities, and equity with all related transactions and accounts

Balance Sheet Summary

  1. Accounts involved: Assets, Liabilities and Equity
  2. Description: This report communicates your company’s assets, liabilities, and equity with only main accounts (No detail from sub-accounts/transactions)

Balance Sheet

  1. Accounts involved: Assets, Liabilities and Equity
  2. Description: This report communicates your company’s assets, liabilities, and equity without detailed transactions

Business Snapshot

  1. Accounts involved: All accounts
  2. Description: This report communicates your company’s income and expenses over time using pie charts and bar graphs. Determine the information shown by selecting the dropdown menu at the top of each chart/graph. See more later in this chapter

Profit and Loss as % of total income

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income and expenses as percentages of your company’s total income

Profit and Loss Comparison

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income compared to last year

Profit and Loss Detail

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income with individual transactions

Profit and Loss year-to-date comparison

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income compared to the current year so far

Profit and Loss by Customer

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income by customer

Profit and Loss by Month

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income by month

Profit and Loss

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income. This is also known as an income statement

Quarterly Profit and Loss Summary

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income by quarter

Statement of Cash Flows

  1. Accounts involved: All accounts
  2. Description: This report communicates the cash generated by your company’s business, cash spent, and cash in or out from operating, financing, and investment activities

Who Owes You

The Who Owes You section contains reports concerning accounts receivable, customer balances, open invoices and more. These reports communicate who owes you cash and helps you implement your company’s sales and receipts policies.

The Who Owes You reports include:

Accounts receivable aging detail

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates all unpaid invoices for the current period, the last 30 days, the last 60 days, and 90+ days. The outstanding invoices are grouped by the number of days past due

Accounts receivable aging summary

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates only customers with unpaid invoices for the current period, the last 30 days, the last 60 days, and 90+ days. This report doesn’t show individual invoices

Collections Report

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates overdue invoices with their due dates, number of days past due, and totals for each customer

Customer Balance Detail

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates each customer’s total open balances and their unpaid invoices, including the invoice date, number, due date, total, and open balance

Customer Balance Summary

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates each customer’s total open balances

Invoice list

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates a chronological list of all your company’s invoices for a specified date range

Invoices and Received Payments

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates the payments that you have received and their related invoices. This report can be used to troubleshoot unexpected A/R balances or audit how payments were applied to ensure it matches the customer’s record

Open Invoices

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates unpaid invoices and statement charges with totals for each customer

Statement List

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates a list of statements that you sent to customers during a specific period of time

Terms List

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of your company’s terms, which determine due dates for payments from customers or to vendors. This report can also be used to view discounts you offer for early payment, as this can be indicated by terms

Uninvoiced charges

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of customer transactions that you haven’t invoiced yet (meaning the transaction was saved, but not sent or billed to the customer as an invoice)

Uninvoiced time

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of time activities provided by employees that haven’t yet been invoiced

Sales and Customers

The Sales and Customers reports communicate your company’s customers and their information, general sales, estimates and progress invoicing, and more. These reports help management view your company’s total sales and customer information.

The Sales and Customers reports include:

Customer Contact List

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of your company’s customers and their contact information, including phone number, email, and billing address

Deposit Detail

  1. Accounts involved: Asset (including Bank)
  2. Description: This report communicates your company’s deposits and their information, including date, customer or vendor, and amount

Estimates & Progress Invoicing Summary by Customer

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates your company’s estimates by customer, invoiced amounts, and remaining amounts to invoice

Estimates by Customer

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of your company’s estimates by customer and whether estimates were invoiced

Income by Customer Summary

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s net income for each customer (income after expenses)

Inventory Valuation Detail

  1. Accounts involved: Inventory Asset, Income, Expense, and Cost of Goods Sold
  2. Description: This report communicates your company’s inventory item information, including the quantity on hand, value, and average cost, as well as individual transactions that each item is linked to

Inventory Valuation Summary

  1. Accounts involved: Inventory Asset, Income, Expense, and Cost of Goods Sold
  2. Description: This report communicates your company’s inventory item information, including the quantity on hand, value, and average cost

Payment Method List

  1. Accounts involved: Bank and Credit Card
  2. Description: This report communicates a list of the payment options you accept from customers

Physical Inventory Worksheet

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates the total physical quantity on hand for each inventory item. This report includes a space where you add the actual amount, making it a great tool to print and use when doing a physical inventory

Product/Service List

  1. Accounts involved: Income, Expense, Inventory Asset, and Cost of Goods Sold
  2. Description: This report communicates a list of your company’s products and services that you sell, including information such as sales price, name, description, purchase cost (if applicable), and quantity on hand (if applicable)

Sales by Customer Detail

  1. Accounts involved: Accounts Receivable and Income
  2. Description: This report communicates your company’s sales information and transactions for each customer, including dates, types, amounts, and totals. This is a great tool for determining which customers generate the most revenue

Sales by Customer Summary

  1. Accounts involved: Accounts Receivable and Income
  2. Description: This report communicates your company’s total sales for each customer. This is a great tool for determining which customers generate the most revenue

Sales by Customer Type Detail

  1. Accounts involved: Accounts Receivable and Income
  2. Description: This report communicates your company’s total sales for each customer organized by type, including transactions that contribute to each total

Sales by Product/Service Detail

  1. Accounts involved: Income, Inventory Asset, and Cost of Goods Sold
  2. Description: This report communicates your company’s sales and transactions for each item on your company’s Product/Service list, including the date, transaction type, quantity, rate, amount, and total

Sales by Product/Service Summary

  1. Accounts involved: Income, Inventory Asset, and Cost of Goods Sold
  2. Description: This report communicates your company’s sales for each item on your company’s Product/Service list, including quantity, amount, % of sales, and average price

Time Activities by Customer Detail

  1. Accounts involved: Income
  2. Description: This report communicates the time activities your company’s employees provided to each customer

Transaction List by Customer

  1. Accounts involved: Income
  2. Description: This report communicates transactions grouped by customer name. This allows you to see all activity related to each customer

What You Owe

The What You Owe section contains reports concerning accounts payable, vendor and contractor balances, and bills. These reports help management see what money is owed and still unpaid.

The What You Owe reports include:

1099 Contractor Balance Detail

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates a list of all the bills that total the amount your company owes each contractor

1099 Contractor Balance Summary

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates the total amount that your company owes each contractor

Accounts payable aging detail

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates all unpaid bills for the current period, the last 30 days, the last 60 days, and 90+ days. The outstanding invoices are grouped by number of days past due

Accounts payable aging summary

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates the totals of unpaid bills for the current period, the last 30 days, the last 60 days, and 90+ days. It doesn’t show individual bills

Bill Payment List

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates a list of the bills you paid during the specified date range

Bills and Applied Payments

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates the payments that you have made and their related bills. This report can be used to troubleshoot unexpected A/P balances or audit how payments were applied to ensure it matches the vendor’s record

Unpaid Bills

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates your company’s unpaid bills, including due dates and days past due. This can be a great tool for assisting you in paying bills on time

Vendor Balance Detail

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates the total amount that your company owes each vendor, including all applicable bills that make up each total. This can help you identify unapplied payments

Vendor Balance Summary

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates the total amount that your company owes each vendor

Expenses and Vendors

The Expenses and Vendors section contains reports concerning your company’s vendors and their information, general purchases and expenses, purchase orders, and more. These reports help management view your company’s total expenses and vendor information.

The Expenses and Vendors reports include:

1099 Transaction Detail Report

  1. Accounts involved: Income and Expense
  2. Description: This report communicates the transactions and total for each contractor, as well as their account number and tax ID. This report is useful when preparing and filing 1099 forms

Check Detail

  1. Accounts involved: Expense
  2. Description: This report communicates information regarding each check that is been issued, including date, payee, and amount

Expenses by Vendor Summary

  1. Accounts involved: Expense
  2. Description: This report communicates your company’s total expenses for each vendor.

Open Purchase Order List

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of your company’s open purchase orders by vendor, including the original amount of each purchase order

Open Purchase Order Detail

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates your company’s open purchase orders by item and/or account, including the total, received, and balance quantities and amounts

Purchases by Product/Service Detail

  1. Accounts involved: Expenses, Inventory Asset, and Cost of Goods Sold
  2. Description: This report communicates your company’s purchases grouped by Product or service

Purchases by Vendor Detail

  1. Accounts involved: Expenses, Inventory Asset, and Cost of Goods Sold
  2. Description: This report communicates your company’s individual purchases and totals for each vendor

Transaction List by Vendor

  1. Accounts involved: Expenses, Accounts Payable
  2. Description: This report communicates your company’s transactions grouped by Vendor

Vendor Contact List

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of your company’s vendors and their contact information, including company name, phone number, email, mailing address, and account number

Sales Tax

The Sales Tax section contains reports concerning sales tax and sales tax liabilities.

The Sales Tax reports include:

Sales Tax Liability Report

  1. Accounts involved: Liabilities
  2. Description: This report communicates the sales tax you have collected and what you currently owe your company’s tax agencies

Taxable Sales Detail

  1. Accounts involved: Liabilities
  2. Description: Your total sales of products and services that are taxable, including the date, transaction type, customer, quantity, rate, amount, and balance

Taxable Sales Summary

  1. Accounts involved: Liabilities
  2. Description: Your total sales of products and services that are taxable

Employees

The Employees section contains reports concerning your company’s employees and their time.

The Employees reports include:

Employee Contact List

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of employees and their contact information, including phone number and email

Recent/Edited Time Activities

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates anytime activities that your company’s employees have entered or edited recently

Time Activities by Employee Detail

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates the time activities each employee entered, including hourly rate and duration

For My Accountant

The For My Accountant section contains reports that are most relevant to aspects of accounting. This is where the General Ledger and Journal are located. Some of the reports in this category are also listed in previous categories.

The For My Accountant reports include:

Account List

  1. Accounts involved: All accounts
  2. Description: This report communicates the name, type, and balance for each account listed in your company’s Chart of Accounts

Balance Sheet Comparison

  1. Accounts involved: Assets, Liabilities and Equity
  2. Description: This report communicates your company’s assets, liabilities, and equity compared to last year

Balance Sheet

  1. Accounts involved: Assets, Liabilities and Equity
  2. Description: This report communicates your company’s assets, liabilities, and equity without detailed transactions

General Ledger

  1. Accounts involved: All accounts
  2. Description: This report communicates the beginning balance, transactions, and total for each account in your company’s Chart of Accounts

Journal

  1. Accounts involved: All accounts
  2. Description: This report communicates debits and credits for each transaction by date over a specified period of time

Profit and Loss Comparison

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income compared to last year

Profit and Loss

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income. This is also known as an income statement

Recent Automatic Transactions

  1. Accounts involved: All accounts
  2. Description: This report communicates any automatic transactions, such as recurring payments, from the last 4 days. While 4 days is the default date range, the date range can be changed

Recent Transactions

  1. Accounts involved: All accounts
  2. Description: This report communicates any transactions from the last 4 days. While 4 days is the default date range, the date range can be changed

Reconciliation Reports

  1. Accounts involved: Asset (including Bank), Liabilities (including Credit Card), and Equity
  2. Description: This report communicates a list of your company’s reconciliations, with links to reports for individual reconciliations

Recurring Template List

  1. Accounts involved: All accounts
  2. Description: This report communicates a list of your company’s recurring transaction templates by type (scheduled, reminder, and unscheduled)

Statement of Cash Flows

  1. Accounts involved: All accounts
  2. Description: This report communicates the cash generated by your company’s business, cash spent, and cash in or out from operating, financing, and investment activities

Transaction Detail by Account

  1. Accounts involved: All accounts
  2. Description: This report communicates your company’s transactions and totals for each account in your company’s Chart of Accounts

Transaction List by Date

  1. Accounts involved: All accounts
  2. Description: This report communicates a list of your company’s transactions by date

Transaction List with Splits

  1. Accounts involved: All accounts
  2. Description: This report communicates a list of your company’s transactions with split lines. This is the format for double-entry accounting

Trial Balance

  1. Accounts involved: All chart of accounts
  2. Description: This report communicates the debit and credit balances of each account from your company’s Chart of Accounts at a specific period of time

Payroll

The Payroll section contains reports that relate to payroll, such as employee information and time.

The Payroll reports include:

Employee Details

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report shows a snapshot of each employee, including pay rate, deductions, and tax withholding

Employee Directory

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of employees and their contact information, including phone number and email

Multiple Worksites

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report provides information you can use to complete your Multiple Worksites Report (if required by your state)

Paycheck List

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of your company’s paychecks and allows you to change check numbers, print pay stubs, and more

Payroll Billing Summary

  1. Accounts involved: Expense
  2. Description: This report shows charges for your QuickBooks Online Payroll subscription

Payroll Deductions/Contributions

  1. Accounts involved: Payroll Expense
  2. Description: This report communicates your total employee deductions and company contributions

Payroll Details

  1. Accounts involved: Payroll Expense and Liabilities
  2. Description: This report communicates the paychecks you have created, including the amount, taxes, and deductions

Payroll Summary by Employee

  1. Accounts involved: Payroll Expense and Liabilities
  2. Description: This report communicates employee wages, deductions, and tax info, totaled by employee or period

Payroll Summary

  1. Accounts involved: Payroll Expense and Liabilities
  2. Description: This report communicates the paychecks you have created, including total wages, taxes, and deductions

Payroll Tax Liability

  1. Accounts involved: Liabilities
  2. Description: This report communicates how much payroll tax you need to pay and how much you have already paid

Payroll Tax Payments

  1. Accounts involved: Expense and Liability
  2. Description: This report communicates the payroll tax payments you have made

Payroll Tax and Wage Summary

  1. Accounts involved: Liabilities
  2. Description: This report communicates total and taxable wages that are subject to federal and state withholding

Recent/Edited Time Activities

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates anytime activities that your company’s employees have entered or edited recently

Retirement Plans

  1. Accounts involved: Payroll Expense
  2. Description: This report communicates employee and company contributions to your retirement plans

Time Activities by Employee Detail

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates the time activities each employee entered, including hourly rate and duration

Total Pay

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates each employee’s total pay by type (salary, hourly, etc.)

Total Payroll Cost

  1. Accounts involved: Payroll Expense and Liabilities
  2. Description: This report communicates all costs associated with paying your employees, including total pay, net pay, deductions, and taxes

Vacation and Sick Leave

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates vacation time and sick leave your employees used so far and how much they have left

Workers’ Compensation

  1. Accounts involved: Payroll Expense
  2. Description: This report communicates wages paid for each Workers’ Compensation class, to be used to prepare forms for state agencies or insurance companies

Custom Reports

The Custom reports tab shows a list of customized reports. QuickBooks offers many customization options for reports; however, some reports have more customization options than others. Customization allows you to change the data shown in a report to display only what is most relevant to management.

To view Custom reports:

  1. From the left menu, select Reports
  2. Select the Custom reports tab

As stated, most reports have their own customization options, however, many options are shared.

Report Customization Categories

Report customization categories include:

  1. General customization options
  2. Rows/Columns customization options
  3. Filter customization options
  4. Header/Footer customization options

General Customization Options

The General customization options include:

Accounting method

  • Function: Accounting method allows you to select the accounting method between Cash or Accrual, which changes the way data is displayed. This doesn’t change your company’s QuickBooks accounting method but allows you to change how your company’s report is viewed

Negative number

  • Function: Negative number allows you to determine how negative numbers are displayed. Open the dropdown menu and select Show in red if desired

Number format

  • Function: Number format provides options for how numbers are displayed. Select the checkbox for the desired Number format options

Report period

  • Function: Report period allows you to specify the period of time for the data that will be displayed on the report. Open the dropdown menu to select various options, then specify the dates by entering them in the appropriate fields. You select All Dates to display data from the time you started your company’s QuickBooks company to date

Tax Agency

  • Function: Tax Agency allows you to select a specific tax agency to display on the report or display all tax agencies you work with. Open the dropdown menu and select a tax agency

Rows/Columns Customization Options

The Rows/Columns customization options include:

Columns

  • Function: Columns allow you to include additional information columns, as opposed to showing totals only. Open the dropdown menu and choose a selection

Group by

  • Function: Group by allows you to group data by specified criteria. This can be changed by opening the dropdown menu and making selection

Period Comparison

  • Function: Period comparison allows you to select which period to compare data to, and the format that the data is displayed. Using the checkboxes, select Previous period, Previous year, or Year-to-date, then select if you want to compare the $ change or % change. You also add a “% of” items to include by selecting the appropriate checkboxes

Select and reorder columns

  • Function: Select and reorder columns allows you to determine which rows or columns are displayed, as well as the order that they’re shown. Select the checkboxes next to the items you want to be displayed, then select and hold the Dotted box icon next to each item and drag it up or down to change the order. Any options that are not selected will be shown below the list. Select an item below to add or re-add it to the list

Show non-zero or active only

  • Function: Show non-zero or active only allows you to determine which rows and columns will be displayed. This lets you exclude rows/columns with zero amounts or only show active rows/columns

Aging Customization Options

The Aging customization options include:

Aging method

  • Function: Aging method allows you to select the data displayed between Current and Report date

Days per aging period

  • Function: Days per aging period allows you to dictate the number of days in each aging period. The default is 30, meaning it will show overdue balances for 1-30 days, 31-60 days, 61-90 days, and 91 and over

Min. Days Past Due

  • Function: Min. Days Past Due allows you to specify a minimum number of days past due. Enter in the appropriate field

Number of periods

  • Function: Number of periods allow you to change the number of periods displayed. The default is 4, meaning it will show overdue balances for four periods of time

Filter Customization Options

The Filter customization options include:

1099 Box

  • Function: 1099 Box allows you to display data only for different box items on the 1099 form. Select the checkbox next to 1099 Box, then open the dropdown menu to select which box number you want to be displayed

Account

  • Function: Account allows you to display data for different accounts. Select the checkbox next to Account, then open the dropdown menu to select “All” of a specific type of account or scroll down further to select the checkboxes next to the accounts to include

Amount

  • Function: Amount allows you to display data for a specific transaction based on the amount. Select the checkbox next to Amount, then enter the amount for the transaction that you want the data displayed for

A/R Paid or A/P Paid

  • Function: A/R Paid or A/P Paid allows you to change which accounts receivable or accounts payable data is displayed. Select the checkbox next to A/R Paid or A/P Paid, then open the dropdown menu and select All, Paid, or Unpaid

Billable

  • Function: Billable allows you to display data based on whether an activity was billable. Select the checkbox next to Billable, then open the dropdown menu and select All, Billable, or NonBillable

Check Printed

  • Function: Check Printed allows you to display data only for checks that are Printed or To be printed. Select the checkbox next to Check Printed, then open the dropdown menu and select Printed or To be printed

Cleared

  • Function: Cleared allows you to display data only for transactions that are Cleared, Uncleared, or Reconciled. Select the checkbox next to Cleared, then open the dropdown menu and select Cleared, Uncleared, or Reconciled

Created Date

  • Function: Created Date allows you to display data for a time period based on when the transaction was created. Select the checkbox next to Created Date, then open the dropdown menu and select the date range you want to show on the report

Crew #

  • Function: Crew # allows you to display data for a specific employee or crew member based on their Crew # if you use crew #s. Select the checkbox next to Crew #, then enter the crew # of the employee for that you want the data displayed for

Customer

  • Function: Customer allows you to display data for only specified customers. Select the checkbox next to Customer, then open the dropdown menu and select the customer(s) that you want to show on the report

Customer Taxable

  • Function: Customer taxable allows you to display data for only customers that are Taxable or Non-Taxable. Select the checkbox next to Customer Taxable, then open the dropdown menu and select Taxable or Non-Taxable

Deleted

  • Function: Deleted allows you to display data for items you have deleted. Select the checkbox next to Deleted, then open the dropdown menu and select all, Deleted, or Not Deleted

Distribution Account

  • Function: A distribution Account allows you to display data for different account types. Open the dropdown menu to select “All” of a specific type of account or scroll down further to select the checkboxes next to the accounts to include. The distribution account is typically the account(s) specified at the bottom of a form

Due Date

  • Function: Due Date allows you to display data to include only specific due dates. Select the checkbox next to Due Date, then open the dropdown menu and select which due dates you want to show on the report

Employee

  • Function: Employee allows you to display data for only specified employees. Select the checkbox next to Employee, then open the dropdown menu and select the employee(s) that you want to show on the report

End Date

  • Function: End Date allows you to display data for a time period based on when the recurring transaction’s end date was specified. Select the checkbox next to End Date, then open the dropdown menu and select the date range you want to show on the report

Estimate Status

  • Function: Allows you to display only estimates based on their status, such as Pending, Accepted, Rejected, etc. Select the checkbox next to Estimate Status, then open the dropdown menu and select Pending, Accepted, or Rejected

Expiration Date

  • Function: Estimate Status allows you to display data for a time period based on when the transaction (typically estimates) expired. Select the checkbox next to Expiration Date, then open the dropdown menu and select the date range you want to show on the report

Hired Date

  • Function: Hired Date allows you to display employee data for a time period based on when the employee was hired. Select the checkbox next to Hired Date, then open the dropdown menu and select the date range you want to show on the report

Last Modified Date

  • Function: Last Modified Date allows you to display data for a time period based on when the transaction was last modified. Select the checkbox next to Last Modified Date, then open the dropdown menu and select the date range you want to show on the report

Location

  • Function: Location allows you to display data for only specified locations. Select the checkbox next to Location, then open the dropdown menu and select the location(s) that you want to show on the report. This option is only available if Location tracking is enabled

Memo

  • Function: Memo allows you to display data for a specific transaction based on its memo information. Select the checkbox next to Memo, then enter the memo information from the transaction that you want the data displayed for

Name

  • Function: Name allows you to display data for only specified customers, vendors, and employees based on the name. Select the checkbox next to Name, then open the dropdown menu and select the names of those you want data displayed for

Num

  • Function: Num allows you to display data for a specific transaction based on the transaction number. Select the checkbox next to Num, then enter the transaction number for the transaction you want the data displayed for

Payment Method

  • Function: Payment Method allows you to display data for only specified payment methods. Select the checkbox next to Payment Method, then open the dropdown menu and select the payment method(s) that you want to show on the report

Product/Service

  • Function: Product/Service allows you to display data for only specified products/services. Select the checkbox next to Product/Service, then open the dropdown menu and select the product(s) or service(s) that you want to show on the report

Product/Service Taxable

  • Function: Product/Service Taxable allows you to display data for only products/services that are Taxable or Non-Taxable. Select the checkbox next to Product/Service Taxable, then open the dropdown menu and select Taxable or Non-Taxable

Released Date

  • Function: Released Date allows you to display employee data for a time period based on when the employee was released. Select the checkbox next to Released Date, then open the dropdown menu and select the date range you want to show on the report

Sales Printed

  • Function: Sales Printed allows you to display data only for sales that are Printed or To be printed. Select the checkbox next to Sales Printed, then open the dropdown menu and select Printed or To be printed

Sales Rep

  • Function: Sales Rep allows you to display data for a specific sales representative. Select the checkbox next to Sales Rep, then enter the name of the sales rep you want the data displayed for

Sent

  • Function: Sent allows you to display data only for transactions that are Sent or To be sent. Select the checkbox next to Sent, then open the dropdown menu and select Sent or To be sent

Ship Via

  • Function: Ship Via allows you to display data based on Ship Via information. Select the checkbox next to Ship Via, then enter the ship via information that you want the data displayed for

Template Name

  • Function: Template Name allows you to display data for a specific template based on the template name. Select the checkbox next to Template Name, then enter the name of the template that you want the data displayed for

Terms

  • Function: Terms allow you to display data for only specified terms. Select the checkbox next to Terms, then open the dropdown menu and select the terms that you want to show on the report

Transaction Type

  • Function: Type allows you to display data for only specified types of transactions. Select the checkbox next to Transaction Type, then open the dropdown menu and select the transaction type(s) that you want to show on the report

Type of Contractors

  • Function: Type of Contractors allow you to display data for only specific types of contractors. Select the checkbox next to Type of Contractors, then open the dropdown menu and select the contractor type that you want to show on the report

Vendor

  • Function: Vendor allows you to display data for only specified vendors. Select the checkbox next to Vendor, then open the dropdown menu and select the vendor(s) that you want to show on the report

Header/Footer Customization Options

The Header/Footer customization options include:

Alignment

  • Function: Alignment allows you to determine where the header and footer are positioned in the report. Open the drop-down menu and select Left, Center, or Right

Footer

  • Function: Footer allows you to change or edit the information displayed at the bottom of the report page. Select the checkbox next to the items you want to appear in the footer

Header

  • Function: The header allows you to change or edit the information displayed at the top of the report page. Select the checkbox next to the items you want to appear in the header, then edit the text if desired. This is where you change the name of the report by editing the Report title

Customizing Reports

When you customize a QuickBooks report, you make changes to the information displayed on an existing report using the features listed above. Customizing reports allows you to format a specific report to determine what data is displayed and how it’s displayed, based on the information management determines is relevant for that report.

Depending on which report you have open, several basic customization options will be available, such as the following:

  • Report period – Allows you to determine the date range of data displayed. Open the drop-down and make selections or enter dates in the appropriate fields
  • Display columns – Allows you to add or change display columns. Open the drop-down and make a selection
  • Show non-zero or active only – Allows you to display rows and columns by Active, All, or Nonzero. Open the dropdown and make a selection
  • Compare another period – Allows you to compare the Report period entered previously with another period or periods, as well as compare by percent of row or column. Select the checkboxes next to the desired options. Select Reorder columns to rearrange the order by which the columns are displayed
  • Accounting method – Allows you to display the results as Cash or Accrual
  • Aging method – Allows you to display results as current or as of the report date
  • Days per aging period – This allows you to determine the number of days per aging period, with the default being 30. You can change this by entering the desired number
  • Number of periods – Allows you to determine the number of periods, with the default being 4. You can change this by entering the desired number
  • Rows/Columns – Allows you to group rows and/or columns by a specified category. Open the dropdown and make a selection
  • Min. Days Past Due - Allows you to enter a minimum number of days past due to display

After making any changes, select Run report to display the customized report.

Certain reports also have in-report customization options, such as the following:

  • Sort – Allows you to sort the data (ex. ascending or descending)
  • Add notes – This allows you to enter notes, which are then displayed at the bottom of the report
  • Edit titles – This allows you to replace the default titles used in reports of that type. For example, you could replace the title Income with Revenue. After selecting Edit Titles, enter the desired label for each title, then select Save

To create a customized report:

  1. With a report open, select Customize
  2. The Customize report section will then appear
  3. Change the settings in the Customize Report section
  4. You expand customization categories by selecting them
  5. Select Run Report
  6. Select Save customization to save the customized report
  7. Enter a name for the custom report
  8. (Optional) Select a group you want to add the report to or select Add new group to create a new group
  9. Grouping reports will allow you to keep them organized on the Custom reports tab. Groups also allow you to email multiple reports at once. This is discussed in more detail in Preparing and Distributing Relevant Reports
  10. Select which users you would like to share the report with from the drop-down menu. When you share a report, it allows other users in your company to view the custom report from the Custom reports tab
  11. Select Save. The custom report will then show on the Custom reports tab

Management Reports

The Management reports tab contains compilation reports relevant to management personnel. These reports focus on the big picture standing of the company, including the Company Overview, Sales Performance, and Expenses Performance reports.

When you run one of these reports, it will be conveniently formatted as a professional report, ready to be printed or distributed accordingly. Before running a report, you select the Report Period by opening the drop-down menu on the table and selecting the available options. After you open a report, you print the report by selecting Print.

To view Management reports:

  1. From the left menu, select Reports
  2. Select the Management reports tab

Management Reports include:

  1. Company Overview
  2. Sales Performance
  3. Expenses Performance
  4. Editing and Customizing Management Reports

Company Overview

The Company Overview report includes two reports, the Profit and Loss and Balance Sheet reports. Combining these two reports provides management with an awareness of some aspects of the financial standing of your company.

Sales Performance

Sales Performance includes three reports, the Profit and Loss, A/R Aging Detail, and Sales by Customer Summary reports. Combining these reports provides management with an awareness of the sales performance of the company, including current sales and outstanding customer balances.

Expenses Performance

Expenses Performance includes three reports, the Profit and Loss, A/P Aging Detail, and Expenses by Vendor Summary report. Combining these reports provides the viewer with an awareness of the company’s expenses, including current expenses and money still owed.

Editing and Customizing Management Reports

Editing or customizing your company’s Management reports allows you to change how they’re displayed. You modify the style, report title, contents, and more.

We customize the Management Report based on what we believe is the most relevant financial information for the company’s specific type of business.

Preparing and Distributing Relevant Reports

Your responsibility is to generate and communicate timely, relevant, and reliable financial information to internal (owner, manager, and employee) and external (bank, vendor, and tax agency) users.

Preparing and communicating financial information enables internal users to make better business decisions and enables the company to comply with external user requirements and regulations.

The types of reports you run and who you distribute them to differ from company to company. However, the way you distribute QuickBooks reports is the same. You email or print your QuickBooks reports, but we recommend you distribute them through email.

Preparing and Distributing Relevant Reports includes:

  1. Emailing Reports
  2. Scheduled Reports
  3. Report Groups
  4. Sending Management Reports

Emailing Reports

The most efficient way to distribute reports is through email.

To email a report:

  1. Select Run report to generate the report
  2. Select the Email icon at the top right of the report page
  3. Review the report and select Email
  4. Enter the recipient’s email address (To), carbon copy (Cc) recipient’s email address, Subject, email contents (Body), and report title (Report)
  5. Select Send

Scheduled Reports

QuickBooks has a feature that allows you to run and email reports automatically on a recurring schedule. This feature is convenient for daily, weekly, monthly, quarterly, and annual reports. The feature can also be used for custom reports.

To set a report schedule:

  1. From the left menu Select Reports, then select Custom reports
  2. Locate the custom report and select Edit from the Action column
  3. The Custom Report edit page opens
  4. Select the Set email schedule toggle switch to On
  5. Complete the Set Recurrence window to determine the schedule
  6. Enter the recipient’s email address (To), carbon copy (Cc) recipient’s email address
  7. You edit the Subject and email contents (Body) and attach the report as an Excel file
  8. Select Save and close

Report Groups

Using groups is the best way to keep your company’s reports organized on the Custom reports tab. You also create schedules for your company’s groups, allowing you to send multiple reports to the same recipient. One option to add a custom report to a group is to do so when saving it as a customized report. Otherwise, you will group reports from the Custom reports tab.

To add a report to a group:

  1. Select Reports from the left menu, then Custom reports
  2. Locate the report you want to group and select Edit from the Action column
  3. Under Add this report to a group, open the drop-down menu and select an existing group or add a new one
  4. Select Save and close

Once a report is added to a group, you’ll note on the Custom reports page that it’s organized under that group. You then create a schedule for the group the same way you do for individual reports, allowing you to send a collection of reports together on a recurring basis.

Sending Management Reports

Another common way to send multiple reports together is by using Management Reports. A management report is a compilation of reports, organized with a cover page and areas for notes to the user, making it a great format for reporting information. Once you customize your company’s management reports you email them.

To email management reports:

  1. Select Reports from the left menu, then select Management reports.
  2. Locate the report and open the drop-down menu in the Action column and select Send.
  3. Enter the recipient’s email address (To), carbon copy (Cc) recipient’s email address
  4. You edit the Subject, email contents (Body), and Filename
  5. Select Send email

QuickBooks Report Email Schedule

Daily and weekly reports are generally for the bookkeeper or personnel who use a report’s information, such as accounts receivable or accounts payable personnel. These reports are usually not grouped or included in management reports but are generated and emailed individually.

Monthly, quarterly and annual reports are generally for the owners and managers who use a report’s information, such as the sales or purchases manager. Therefore, management reports should be emailed to the owners and Cc’d to the responsible manager.

The following daily, weekly, monthly, quarterly, and annual report schedules are used by most companies. However, the types of QuickBooks reports you generate and communicate may vary depending on the company.

QuickBooks Report Email Schedule includes:

  1. Daily Reports
  2. Weekly Reports
  3. Monthly Reports
  4. Quarterly Reports
  5. Annual Reports

Daily Reports

Daily reports should be generated each business day.

Note: As part of your QuickBooks setup, your accountant will customize, group, and schedule your daily reports.

The daily reports include the following three sections:

  1. Cash Flow
  2. Sales
  3. Expense

Cash Flow Reports

Cash Flow reports include one report:

  1. Statement of Cash Flows (Report period: Yesterday)

Sales Reports

Sales reports include four reports:

  1. Sales by Customer Detail (Report period: Yesterday)
  2. Sales by Product/Service Detail (Report period: Yesterday)
  3. Accounts Receivable Aging Detail (Report period: Yesterday)
  4. Collections (Report period: Yesterday)

Expense Reports

Expense reports include three reports:

  1. Purchases by Vendor Detail (Report period: Yesterday)
  2. Purchases by Product/Service Detail (Report period: Yesterday)
  3. Accounts Payable Aging Detail (Report period: Today)

Weekly Reports

The Weekly Management Report should be scheduled to be emailed to owners and managers on Monday or the first business day of each week.

Note: As part of your QuickBooks setup, your accountant will customize, group, and schedule your Weekly Management Report.

The Weekly Management Report includes the following five sections:

  1. Financial Position
  2. Profitability
  3. Cash Flow
  4. Sales
  5. Expense

Financial Condition Reports

Financial condition reports include three reports:

  1. Balance Sheet (Report period: Last Week; Compare another period: % of Column)
  2. Balance Sheet Comparison (Report period: Last Week; Compare another period: Previous Period, $ change and % change)
  3. Balance Sheet Comparison (Report period: Last Week; Compare another period: Previous Year, $ change and % change)

Profitability Reports

Profitability reports include three reports:

  1. Profit and Loss as % of total income (Report period: Last Week)
  2. Profit and Loss Comparison (Report period: Last Week; Compare another period: Previous Period, $ change and % change)
  3. Profit and Loss Comparison (Report period: Last Week; Compare another period: Previous Year, $ change and % change)

Cash Flow Reports

Cash Flow reports include one report:

  1. Statement of Cash Flows (Report period: Last Week)

Sales Reports

Sales reports include six reports:

  1. Sales by Customer Summary (Report period: Last Week; Compare another period: % of Column)
  2. Sales by Customer Summary (Report period: Last Week; Compare another period: Previous Period, $ change and % change)
  3. Sales by Customer Summary (Report period: Last Week; Compare another period: Previous Year, $ change and % change)
  4. Sales by Product/Service Summary (Report period: Last Week)
  5. Accounts Receivable Aging Summary (Report period: Last Week)
  6. Collections (Report period: Last Week)

Expense Reports

Expense reports include four reports:

  1. Expenses by Vendor Summary (Report period: Last Week; Compare another period: % of Column)
  2. Expenses by Vendor Summary (Report period: Last Week; Compare another period: Previous Period, $ change and % change)
  3. Expenses by Vendor Summary (Report period: Last Week; Compare another period: Previous Year, $ change and % change)
  4. Accounts Payable Aging Summary (Report period: Last Week)

Monthly Reports

The Monthly Management Report should be scheduled to be emailed to owners and managers each month after you reconcile your last month’s bank and credit card accounts.

Note: As part of your QuickBooks setup, your accountant will customize, group, and schedule your Monthly Management Report.

The Monthly Management Report includes the following five sections:

  1. Financial Position
  2. Profitability
  3. Cash Flow
  4. Sales
  5. Expense

Financial Condition Reports

Financial condition reports include three reports:

  1. Balance Sheet (Report period: Last Month; Compare another period: % of Column)
  2. Balance Sheet Comparison (Report period: Last Month; Compare another period: Previous Period, $ change and % change)
  3. Balance Sheet Comparison (Report period: Last Month; Compare another period: Previous Year, $ change and % change)

Profitability Reports

Profitability reports include six reports:

  1. Profit and Loss as % of total income (Report period: Last Month)
  2. Profit and Loss Comparison (Report period: Last Month; Compare another period: Previous Period, $ change and % change)
  3. Profit and Loss Comparison (Report period: Last Month; Compare another period: Previous Year, $ change and % change)
  4. Profit and Loss as % of total income (Report period: This Year-to-last-month)
  5. Profit and Loss Comparison (Report period: This Year-to-last-month; Compare another period: Previous Year, $ change and % change)
  6. Profit and Loss by Month (Report period: This Year-to-last-month; Compare another period: % of Income)

Cash Flow Reports

Cash Flow reports include two reports:

  1. Statement of Cash Flows (Report period: Last Month)
  2. Statement of Cash Flows (Report period: This Year-to-last-month)

Sales Reports

Sales reports include nine reports:

  1. Sales by Customer Summary (Report period: Last Month; Compare another period: % of Column)
  2. Sales by Customer Summary (Report period: Last Month; Compare another period: Previous Period, $ change and % change)
  3. Sales by Customer Summary (Report period: Last Month; Compare another period: Previous Year, $ change and % change)
  4. Sales by Customer Summary (Report period: This Year-to-last-month; Compare another period: % of Column)
  5. Sales by Customer Summary (Report period: This Year-to-last-month; Compare another period: Previous Year, $ change and % change)
  6. Sales by Product/Service Summary (Report period: Last Month)
  7. Sales by Product/Service Summary (Report period: This Year-to-last-month)
  8. Accounts Receivable Aging Summary (Report period: Last Month)
  9. Collections (Report period: Last Month)

Expense Reports

Expense reports include five reports:

  1. Expenses by Vendor Summary (Report period: Last Month; Compare another period: % of Column)
  2. Expenses by Vendor Summary (Report period: Last Month; Compare another period: Previous Period, $ change and % change)
  3. Expenses by Vendor Summary (Report period: This Year-to-last-month; Compare another period: Previous Year, $ change and % change)
  4. Expenses by Vendor Summary (Report period: This Year-to-last-month; Compare another period: % of Column)
  5. Accounts Payable Aging Summary (Report period: Last Month)

Quarterly Reports

The Quarterly Management Report should be scheduled to email to owners and managers each quarter after you reconcile your last month’s bank and credit card accounts. These reports are generated in April, July, October, and January if your company has a calendar year-end (December 31, 20XX).

Note: As part of your QuickBooks set up, your accountant will customize, group, and schedule your Quarterly Management Report.

The Quarterly Management Report includes the following six sections:

  1. Financial Position
  2. Profitability
  3. Cash Flow
  4. Sales
  5. Expense

Financial Position Reports

Financial condition reports include three reports:

  1. Balance Sheet (Report period: Last Quarter; Compare another period: % of Column)
  2. Balance Sheet Comparison (Report period: Last Quarter; Compare another period: Previous Period, $ change and % change)
  3. Balance Sheet Comparison (Report period: Last Quarter; Compare another period: Previous Year, $ change and % change)

Profitability Reports

Profitability reports include four reports:

  1. Profit and Loss as % of total income (Report period: Last Quarter)
  2. Profit and Loss Comparison (Report period: Last Quarter; Compare another period: Previous Period, $ change and % change)
  3. Profit and Loss Comparison (Report period: Last Quarter; Compare another period: Previous Year, $ change and % change)
  4. Quarterly Profit and Loss Summary (Report period: This Year-to-last-month; Compare another period: % of Income)

Cash Flow Reports

Cash Flow reports include two reports:

  1. Statement of Cash Flows (Report period: Last Quarter)
  2. Statement of Cash Flows (Report period: This Year-to-last-month).

Sales Reports

Sales reports include four reports:

  1. Sales by Customer Summary (Report period: Last Quarter; Compare another period: % of Column)
  2. Sales by Customer Summary (Report period: Last Quarter; Compare another period: Previous Period, $ change and % change)
  3. Sales by Customer Summary (Report period: Last Quarter; Compare another period: Previous Year, $ change and % change)
  4. Sales by Product/Service Summary (Report period: Last Quarter)

Expense Reports

Expense reports include three reports:

  1. Expenses by Vendor Summary (Report period: Last Quarter; Compare another period: % of Column)
  2. Expenses by Vendor Summary (Report period: Last Quarter; Compare another period: Previous Period, $ change and % change)
  3. Expenses by Vendor Summary (Report period: Last Quarter; Compare another period: Previous Year, $ change and % change)

Annual (Year-End) Reports

The Annual Management Report should be scheduled to email to owners and managers each year after you reconcile your last month’s bank and credit card accounts. This report is generated in January if your company has a calendar year-end (December 31, 20XX).

Note: As part of your QuickBooks set up, your accountant will customize, group, and schedule your Annual Management Report.

The Annual Management Report includes the following six sections:

  1. Financial Position
  2. Profitability
  3. Cash Flow
  4. SalesExpense

Financial Position Reports

Financial condition reports include two reports:

  1. Balance Sheet (Report period: Last Year; Compare another period: % of Column)
  2. Balance Sheet Comparison (Report period: Last Year; Compare another period: Previous Year, $ change and % change)

Profitability Reports

Profitability reports include two reports:

  1. Profit and Loss as % of total income (Report period: Last Year)
  2. Profit and Loss Comparison (Report period: Last Year; Compare another period: Previous Year, $ change and % change)

Cash Flow Reports

Cash Flow reports include one report:

  1. Statement of Cash Flows (Report period: Last Year)

Sales Reports

Sales reports include three reports:

  1. Sales by Customer Summary (Report period: Last Year; Compare another period: % of Column),
  2. Sales by Customer Summary (Report period: Last Year; Compare another period: Previous Year, $ change and % change)
  3. Sales by Product/Service Summary (Report period: Last Year)

Expense Reports

Expense reports include two reports:

  1. Expenses by Vendor Summary (Report period: Last Year; Compare another period: % of Column)
  2. Expenses by Vendor Summary (Report period: Last Year; Compare another period: Previous Year, $ change and % change)

Other Reporting Features

Other Reporting Features includes:

  1. Business Snapshot
  2. Dashboard
  3. Vendors Page
  4. Sales Overview page
  5. All Sales

Business Snapshot

The Business Snapshot contains tiles that display snapshots of your company’s income and expenses, income and expense comparisons, accounts receivable, and accounts payable using visual aids such as pie charts and bar graphs.

Due to the nature of the report, the report can’t be included in the management reports.

To view the Business Snapshot report:

  1. From the left menu, select Reports
  2. Select the Standard tab
  3. In the Business Overview section, select Business Snapshot

The My Income tile displays your company’s income for a given period. You change the reporting period by selecting the period down arrow and the period you want to display. The total income for the report period is in the upper right of the graph. To see the income percentages for that period, hover your cursor over the slices of the pie chart. To view the Profit and Loss statement for that period, select the Profit and Loss link.

The My Expenses tile displays your company’s expenses for a given period. You change the reporting period by selecting the period down arrow and the period you want to display. The total expenses for the report period are in the upper right of the graph. To see the expense percentages for that period, hover your cursor over the slices of the pie chart. To view the Profit and Loss statement for that period, select the Profit and Loss link.

The Previous Year Income Comparison displays your company’s previous year’s income in comparison to the current year. You change the reporting period and income accounts by selecting the period and accounts down arrows and the period and accounts you want to display. To see the income amount for that period, hover your cursor over the bars on the graph.

The Previous Year Expense Comparison displays your company’s previous year’s expense in comparison to the current year. You change the reporting period and expense accounts by selecting the period and accounts down arrows and the period and accounts you want to display. To see the expense amount for that period, hover your cursor over the bars on the graph.

The Who Owes Me tile displays a list of customers with outstanding balances in descending order by balance due. The total amount the company is owed for the report period is in the upper right of the tile.

The Whom I Owe tile displays a list of vendors with outstanding balances in descending order by balance due. The total amount the company owes for the report period is in the upper right of the tile.

Dashboard

The Business overview tab of the Dashboard contains tiles that display snapshots of your company’s operating performance. The tiles communicate information regarding your invoices, expenses, profit or loss, sales, and bank accounts.

To view the Business overview tab, select Dashboard from the left menu, then select Business overview.

The Invoices tile displays the amount of your company’s unpaid invoices and the amount overdue and not due yet. The tile also includes the amount paid in the last 30 days and how much of that amount is not deposited or deposited. When you select the tile, you’re directed to the Invoices page.

The Expenses tile displays your company’s total expenses over a given period categorized by the largest three expense account amounts and “Everything else” during the period. You change the reporting period by selecting the down arrow and the period you want to display. When you select Expenses, you’re directed to the Expenses page. When you select the tile, you’re directed to the expenses Transaction Report for the given period. If you select specific segments of the pie graph, you’re directed to the expenses Transaction Report for that expense.

The Profit and Loss tile displays your company’s net and total income and expenses over a given period. You change the reporting period by selecting the down arrow and the period you want to display. When you select the tile, you’re directed to the Profit and Loss report.

The Sales tile displays a point-to-point line graph to show your company’s sales over a given period. To change the report period, select the down arrow and the period you want to display. The total sales for the report period are in the upper left of the graph. To see the sales amount for that period, hover your cursor over any point on the graph.

The Bank accounts tile displays your company’s online connected bank and credit card accounts and shows their current balances and the number of transactions that need to be reviewed in your account. If you have Checking or Credit Cards parent accounts and checking and credit card subaccounts, the Checking and Credit Cards parent sections display the total balance of the subaccounts and the subaccount sections display the balance for the subaccount. When you select the Checking or Credit Cards parent account sections, you’re directed to the Checking or Credit Cards from the Bank Register page. When you select the subaccounts, you’re directed to the accounts For Review tab.

You connect online bank and credit card accounts by selecting Connect accounts. You view an account register for any connected account by selecting the Go to registers down arrow and account. You change the order of the accounts by selecting the Pencil icon and dragging each account.

The dashboard can also show a Cash Flow widget, which displays useful information regarding your cash balances and your money in/out.

To enable the Dashboard Cash Flow widget:

  1. Select the Gear icon at the top, then select QuickBooks Labs
  2. Under Cash Flow Dashboard Widget, select the radio button to On, then select Done
  3. Select Dashboard from the left menu, then select Business overview to view the Cash Flow widget

Vendors Page

The Vendors page displays a ribbon that shows unpaid and paid bills. If Purchase Orders is turned on in Account and Settings, the ribbon also displays unbilled purchase orders.

To view the Vendors page:

  1. From the left menu, select Expenses
  2. Select Vendors

Unbilled Purchase Orders displays the total amount and number of unbilled purchase orders over the last 365 days. When you select the tile, a list of open purchase orders displays.

Unpaid Bills displays the total amount and number of overdue and open bills unpaid in the last 365 days. When you select the Overdue (left) side of the tile, a list of overdue bills displays. When you select the Open Bill (right) side of the tile, a list of open bills displays.

Paid Bills displays the total amount and number of paid bills in the last 30 days. When you select the tile, a list of vendors displays.

Sales Overview Page

The Sales Overview page contains tiles that display snapshots of your company’s sales and receipts. The tiles communicate information regarding your income over time, invoices, and deposits.

To view the Sales Overview page:

  1. From the left menu, select Sales
  2. Select Overview

The Income Over Time tile displays a point-to-point line graph to show your company’s sales over a given period. To change the report period, select the down arrow and the period you want to display. The total income for the report period is in the upper left of the graph. To see the sales amount for that period, hover your cursor over any point on the graph.  

The Invoices tile displays the amount of your company’s unpaid invoices, the amount overdue and not due yet, and the amount not deposited and deposited. When you select the tile, you’re directed to the Invoices page.  

The Deposits tile displays the current day’s deposit, the expected deposit date, and the number of processed transactions. When you select the tile, you’re directed to the Deposits page.

All Sales

The All Sales page displays a ribbon that shows unbilled activity, unpaid invoices, and paid invoices.

To view the All Sales page:

  1. From the left menu, select Sales
  2. Select All Sales

The Unbilled Activity tile displays your company’s total estimate and unbilled (uninvoiced) activity amounts and number of estimates and unbilled activity over the last 365 days. When you select the Estimate (left) side of the tile, a list of open estimates displays. When you select the Unbilled Activity (right) side of the tile, a list of unsent invoices displays.  

The Unpaid Invoices tile displays the amount and number of your company’s overdue and open invoices. When you select the Overdue (left) side of the tile, a list of overdue invoices displays. When you select the Open Invoices (right) side of the tile, a list of open invoices displays.

The Paid Invoices tile displays the amount and number of your company’s invoices paid in the last 30 days. When you select the tile, a list of invoices paid in the last 30 days displays.

Introduction

Management is informed of their company’s business performance by analyzing QuickBooks reports. QuickBooks reports organize and communicate timely, relevant, and reliable financial information to company management to assist them in making better business decisions.

This chapter provides step-by-step guidance for organizing and communicating business performance.

The guidance in the chapter is useful to bookkeepers as well as personnel involved in report activities.

Accounting Process Automation

Accounting process automation automates report organization and communication processes. Automation improves the speed, accuracy, and reliability of business performance communication.

This chapter uses accounting process automation to create, customize, view, and distribute QuickBooks reports.

QuickBooks Reports Tools

QuickBooks is needed to organize and communicate business performance.

Bookkeeper Tasks

Your reporting tasks include:

  1. Generate and review daily, weekly, monthly, quarterly, and annual (year-end) reports
  2. Email daily, weekly, monthly, quarterly, and annual QuickBooks Management Reports

Accountant Tasks

Your accountant’s reporting tasks include:

  1. Customize, group, and schedule your daily, weekly, monthly, quarterly, and annual reports
  2. Provide QuickBooks reports training
  3. Support QuickBooks reports questions and problems
  4. Review your monthly QuickBooks reports

Why Use QuickBooks Reports?

QuickBooks reports is a tool used to convey information regarding your company’s activities or results. QuickBooks reports provide management a snapshot in time to easily analyze their company’s business processes such as sales and receipts, purchases and payments, and overall business performance.

What Are My Responsibilities Regarding Reports?

Your responsibility is to perform the day-to-day bookkeeping and generate and communicate timely, relevant, and reliable financial information to internal (owner, manager, and employee) and external (bank, vendor, and tax agency) users.

Navigating Your QuickBooks Report

Categories and Navigating Reports

The Reports page in QuickBooks organizes the various reports available into different categories. This helps you navigate the page more easily and locate the reports you want to run. You also use the search feature (Find report by name) to search for specific reports by name.

On the reports page, there are three tabs: Standard, Custom reports, and Management reports.

When viewing reports, QuickBooks offers a feature that allows you to “drill down” or access individual transactions and activities that make up your company’s reports. When viewing a report, select any transaction or activity to open it for viewing or editing.

Standard Reports

The Standard reports tab contains the majority of the reports available in QuickBooks. Standard reports are grouped into the following sections:

  • Favorites
  • Business Overview
  • Who Owes You
  • Sales and Customers
  • What You Owe
  • Expenses and Vendors
  • Employees
  • For My Accountant
  • Payroll

To view Standard reports:

  1. From the left menu, select Reports
  2. Select the Standard tab

If the report you’re looking for has been copied to the Favorites section or listed in the Business Overview section, select the name of the report in that section.

If the report has not been copied to the Favorites section or listed in the Business overview section, enter the name of the report in the Search field and select the report name.

Favorites

The Favorites section displays a list of reports that you mark as “favorite”. You mark a report as “favorite” by selecting the Star icon next to any report listed on the Standard tab. The Favorites section saves time by organizing your company’s most used reports in alphabetical order at the top of the page. A green star indicates the report has been copied to the Favorites section.

Note: As part of your QuickBooks setup, your accountant will copy the reports to the Favorites section based on what he or she believes is the most relevant financial information for your company’s specific type of business. The most useful reports are found in the Favorites and Business overview sections.

Business Overview

The Business Overview section contains reports concerning your company’s general finances, activities, and transactions, including account balances, profit and loss, and cash flow statements.

Business Overview reports include:

Audit Log

  1. Accounts involved: No specific accounts are applicable
  2. Description: Displays all your company’s activity chronologically, allowing you to see which individuals have been in your QuickBooks and what they have done

Balance Sheet Comparison

  1. Accounts involved: Assets, Liabilities and Equity
  2. Description: This report communicates your company’s assets, liabilities, and equity compared to the prior year (PY)

Balance Sheet Detail

  1. Accounts involved: Assets, Liabilities and Equity
  2. Description: This report communicates your company’s assets, liabilities, and equity with all related transactions and accounts

Balance Sheet Summary

  1. Accounts involved: Assets, Liabilities and Equity
  2. Description: This report communicates your company’s assets, liabilities, and equity with only main accounts (No detail from sub-accounts/transactions)

Balance Sheet

  1. Accounts involved: Assets, Liabilities and Equity
  2. Description: This report communicates your company’s assets, liabilities, and equity without detailed transactions

Business Snapshot

  1. Accounts involved: All accounts
  2. Description: This report communicates your company’s income and expenses over time using pie charts and bar graphs. Determine the information shown by selecting the dropdown menu at the top of each chart/graph. See more later in this chapter

Profit and Loss as % of total income

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income and expenses as percentages of your company’s total income

Profit and Loss Comparison

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income compared to last year

Profit and Loss Detail

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income with individual transactions

Profit and Loss year-to-date comparison

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income compared to the current year so far

Profit and Loss by Customer

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income by customer

Profit and Loss by Month

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income by month

Profit and Loss

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income. This is also known as an income statement

Quarterly Profit and Loss Summary

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income by quarter

Statement of Cash Flows

  1. Accounts involved: All accounts
  2. Description: This report communicates the cash generated by your company’s business, cash spent, and cash in or out from operating, financing, and investment activities

Who Owes You

The Who Owes You section contains reports concerning accounts receivable, customer balances, open invoices and more. These reports communicate who owes you cash and helps you implement your company’s sales and receipts policies.

The Who Owes You reports include:

Accounts receivable aging detail

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates all unpaid invoices for the current period, the last 30 days, the last 60 days, and 90+ days. The outstanding invoices are grouped by the number of days past due

Accounts receivable aging summary

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates only customers with unpaid invoices for the current period, the last 30 days, the last 60 days, and 90+ days. This report doesn’t show individual invoices

Collections Report

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates overdue invoices with their due dates, number of days past due, and totals for each customer

Customer Balance Detail

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates each customer’s total open balances and their unpaid invoices, including the invoice date, number, due date, total, and open balance

Customer Balance Summary

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates each customer’s total open balances

Invoice list

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates a chronological list of all your company’s invoices for a specified date range

Invoices and Received Payments

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates the payments that you have received and their related invoices. This report can be used to troubleshoot unexpected A/R balances or audit how payments were applied to ensure it matches the customer’s record

Open Invoices

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates unpaid invoices and statement charges with totals for each customer

Statement List

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates a list of statements that you sent to customers during a specific period of time

Terms List

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of your company’s terms, which determine due dates for payments from customers or to vendors. This report can also be used to view discounts you offer for early payment, as this can be indicated by terms

Uninvoiced charges

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of customer transactions that you haven’t invoiced yet (meaning the transaction was saved, but not sent or billed to the customer as an invoice)

Uninvoiced time

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of time activities provided by employees that haven’t yet been invoiced

Sales and Customers

The Sales and Customers reports communicate your company’s customers and their information, general sales, estimates and progress invoicing, and more. These reports help management view your company’s total sales and customer information.

The Sales and Customers reports include:

Customer Contact List

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of your company’s customers and their contact information, including phone number, email, and billing address

Deposit Detail

  1. Accounts involved: Asset (including Bank)
  2. Description: This report communicates your company’s deposits and their information, including date, customer or vendor, and amount

Estimates & Progress Invoicing Summary by Customer

  1. Accounts involved: Accounts Receivable
  2. Description: This report communicates your company’s estimates by customer, invoiced amounts, and remaining amounts to invoice

Estimates by Customer

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of your company’s estimates by customer and whether estimates were invoiced

Income by Customer Summary

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s net income for each customer (income after expenses)

Inventory Valuation Detail

  1. Accounts involved: Inventory Asset, Income, Expense, and Cost of Goods Sold
  2. Description: This report communicates your company’s inventory item information, including the quantity on hand, value, and average cost, as well as individual transactions that each item is linked to

Inventory Valuation Summary

  1. Accounts involved: Inventory Asset, Income, Expense, and Cost of Goods Sold
  2. Description: This report communicates your company’s inventory item information, including the quantity on hand, value, and average cost

Payment Method List

  1. Accounts involved: Bank and Credit Card
  2. Description: This report communicates a list of the payment options you accept from customers

Physical Inventory Worksheet

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates the total physical quantity on hand for each inventory item. This report includes a space where you add the actual amount, making it a great tool to print and use when doing a physical inventory

Product/Service List

  1. Accounts involved: Income, Expense, Inventory Asset, and Cost of Goods Sold
  2. Description: This report communicates a list of your company’s products and services that you sell, including information such as sales price, name, description, purchase cost (if applicable), and quantity on hand (if applicable)

Sales by Customer Detail

  1. Accounts involved: Accounts Receivable and Income
  2. Description: This report communicates your company’s sales information and transactions for each customer, including dates, types, amounts, and totals. This is a great tool for determining which customers generate the most revenue

Sales by Customer Summary

  1. Accounts involved: Accounts Receivable and Income
  2. Description: This report communicates your company’s total sales for each customer. This is a great tool for determining which customers generate the most revenue

Sales by Customer Type Detail

  1. Accounts involved: Accounts Receivable and Income
  2. Description: This report communicates your company’s total sales for each customer organized by type, including transactions that contribute to each total

Sales by Product/Service Detail

  1. Accounts involved: Income, Inventory Asset, and Cost of Goods Sold
  2. Description: This report communicates your company’s sales and transactions for each item on your company’s Product/Service list, including the date, transaction type, quantity, rate, amount, and total

Sales by Product/Service Summary

  1. Accounts involved: Income, Inventory Asset, and Cost of Goods Sold
  2. Description: This report communicates your company’s sales for each item on your company’s Product/Service list, including quantity, amount, % of sales, and average price

Time Activities by Customer Detail

  1. Accounts involved: Income
  2. Description: This report communicates the time activities your company’s employees provided to each customer

Transaction List by Customer

  1. Accounts involved: Income
  2. Description: This report communicates transactions grouped by customer name. This allows you to see all activity related to each customer

What You Owe

The What You Owe section contains reports concerning accounts payable, vendor and contractor balances, and bills. These reports help management see what money is owed and still unpaid.

The What You Owe reports include:

1099 Contractor Balance Detail

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates a list of all the bills that total the amount your company owes each contractor

1099 Contractor Balance Summary

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates the total amount that your company owes each contractor

Accounts payable aging detail

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates all unpaid bills for the current period, the last 30 days, the last 60 days, and 90+ days. The outstanding invoices are grouped by number of days past due

Accounts payable aging summary

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates the totals of unpaid bills for the current period, the last 30 days, the last 60 days, and 90+ days. It doesn’t show individual bills

Bill Payment List

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates a list of the bills you paid during the specified date range

Bills and Applied Payments

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates the payments that you have made and their related bills. This report can be used to troubleshoot unexpected A/P balances or audit how payments were applied to ensure it matches the vendor’s record

Unpaid Bills

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates your company’s unpaid bills, including due dates and days past due. This can be a great tool for assisting you in paying bills on time

Vendor Balance Detail

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates the total amount that your company owes each vendor, including all applicable bills that make up each total. This can help you identify unapplied payments

Vendor Balance Summary

  1. Accounts involved: Accounts Payable
  2. Description: This report communicates the total amount that your company owes each vendor

Expenses and Vendors

The Expenses and Vendors section contains reports concerning your company’s vendors and their information, general purchases and expenses, purchase orders, and more. These reports help management view your company’s total expenses and vendor information.

The Expenses and Vendors reports include:

1099 Transaction Detail Report

  1. Accounts involved: Income and Expense
  2. Description: This report communicates the transactions and total for each contractor, as well as their account number and tax ID. This report is useful when preparing and filing 1099 forms

Check Detail

  1. Accounts involved: Expense
  2. Description: This report communicates information regarding each check that is been issued, including date, payee, and amount

Expenses by Vendor Summary

  1. Accounts involved: Expense
  2. Description: This report communicates your company’s total expenses for each vendor.

Open Purchase Order List

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of your company’s open purchase orders by vendor, including the original amount of each purchase order

Open Purchase Order Detail

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates your company’s open purchase orders by item and/or account, including the total, received, and balance quantities and amounts

Purchases by Product/Service Detail

  1. Accounts involved: Expenses, Inventory Asset, and Cost of Goods Sold
  2. Description: This report communicates your company’s purchases grouped by Product or service

Purchases by Vendor Detail

  1. Accounts involved: Expenses, Inventory Asset, and Cost of Goods Sold
  2. Description: This report communicates your company’s individual purchases and totals for each vendor

Transaction List by Vendor

  1. Accounts involved: Expenses, Accounts Payable
  2. Description: This report communicates your company’s transactions grouped by Vendor

Vendor Contact List

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of your company’s vendors and their contact information, including company name, phone number, email, mailing address, and account number

Sales Tax

The Sales Tax section contains reports concerning sales tax and sales tax liabilities.

The Sales Tax reports include:

Sales Tax Liability Report

  1. Accounts involved: Liabilities
  2. Description: This report communicates the sales tax you have collected and what you currently owe your company’s tax agencies

Taxable Sales Detail

  1. Accounts involved: Liabilities
  2. Description: Your total sales of products and services that are taxable, including the date, transaction type, customer, quantity, rate, amount, and balance

Taxable Sales Summary

  1. Accounts involved: Liabilities
  2. Description: Your total sales of products and services that are taxable

Employees

The Employees section contains reports concerning your company’s employees and their time.

The Employees reports include:

Employee Contact List

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of employees and their contact information, including phone number and email

Recent/Edited Time Activities

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates anytime activities that your company’s employees have entered or edited recently

Time Activities by Employee Detail

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates the time activities each employee entered, including hourly rate and duration

For My Accountant

The For My Accountant section contains reports that are most relevant to aspects of accounting. This is where the General Ledger and Journal are located. Some of the reports in this category are also listed in previous categories.

The For My Accountant reports include:

Account List

  1. Accounts involved: All accounts
  2. Description: This report communicates the name, type, and balance for each account listed in your company’s Chart of Accounts

Balance Sheet Comparison

  1. Accounts involved: Assets, Liabilities and Equity
  2. Description: This report communicates your company’s assets, liabilities, and equity compared to last year

Balance Sheet

  1. Accounts involved: Assets, Liabilities and Equity
  2. Description: This report communicates your company’s assets, liabilities, and equity without detailed transactions

General Ledger

  1. Accounts involved: All accounts
  2. Description: This report communicates the beginning balance, transactions, and total for each account in your company’s Chart of Accounts

Journal

  1. Accounts involved: All accounts
  2. Description: This report communicates debits and credits for each transaction by date over a specified period of time

Profit and Loss Comparison

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income compared to last year

Profit and Loss

  1. Accounts involved: Income and Expense
  2. Description: This report communicates your company’s income, expenses, and net income. This is also known as an income statement

Recent Automatic Transactions

  1. Accounts involved: All accounts
  2. Description: This report communicates any automatic transactions, such as recurring payments, from the last 4 days. While 4 days is the default date range, the date range can be changed

Recent Transactions

  1. Accounts involved: All accounts
  2. Description: This report communicates any transactions from the last 4 days. While 4 days is the default date range, the date range can be changed

Reconciliation Reports

  1. Accounts involved: Asset (including Bank), Liabilities (including Credit Card), and Equity
  2. Description: This report communicates a list of your company’s reconciliations, with links to reports for individual reconciliations

Recurring Template List

  1. Accounts involved: All accounts
  2. Description: This report communicates a list of your company’s recurring transaction templates by type (scheduled, reminder, and unscheduled)

Statement of Cash Flows

  1. Accounts involved: All accounts
  2. Description: This report communicates the cash generated by your company’s business, cash spent, and cash in or out from operating, financing, and investment activities

Transaction Detail by Account

  1. Accounts involved: All accounts
  2. Description: This report communicates your company’s transactions and totals for each account in your company’s Chart of Accounts

Transaction List by Date

  1. Accounts involved: All accounts
  2. Description: This report communicates a list of your company’s transactions by date

Transaction List with Splits

  1. Accounts involved: All accounts
  2. Description: This report communicates a list of your company’s transactions with split lines. This is the format for double-entry accounting

Trial Balance

  1. Accounts involved: All chart of accounts
  2. Description: This report communicates the debit and credit balances of each account from your company’s Chart of Accounts at a specific period of time

Payroll

The Payroll section contains reports that relate to payroll, such as employee information and time.

The Payroll reports include:

Employee Details

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report shows a snapshot of each employee, including pay rate, deductions, and tax withholding

Employee Directory

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of employees and their contact information, including phone number and email

Multiple Worksites

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report provides information you can use to complete your Multiple Worksites Report (if required by your state)

Paycheck List

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates a list of your company’s paychecks and allows you to change check numbers, print pay stubs, and more

Payroll Billing Summary

  1. Accounts involved: Expense
  2. Description: This report shows charges for your QuickBooks Online Payroll subscription

Payroll Deductions/Contributions

  1. Accounts involved: Payroll Expense
  2. Description: This report communicates your total employee deductions and company contributions

Payroll Details

  1. Accounts involved: Payroll Expense and Liabilities
  2. Description: This report communicates the paychecks you have created, including the amount, taxes, and deductions

Payroll Summary by Employee

  1. Accounts involved: Payroll Expense and Liabilities
  2. Description: This report communicates employee wages, deductions, and tax info, totaled by employee or period

Payroll Summary

  1. Accounts involved: Payroll Expense and Liabilities
  2. Description: This report communicates the paychecks you have created, including total wages, taxes, and deductions

Payroll Tax Liability

  1. Accounts involved: Liabilities
  2. Description: This report communicates how much payroll tax you need to pay and how much you have already paid

Payroll Tax Payments

  1. Accounts involved: Expense and Liability
  2. Description: This report communicates the payroll tax payments you have made

Payroll Tax and Wage Summary

  1. Accounts involved: Liabilities
  2. Description: This report communicates total and taxable wages that are subject to federal and state withholding

Recent/Edited Time Activities

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates anytime activities that your company’s employees have entered or edited recently

Retirement Plans

  1. Accounts involved: Payroll Expense
  2. Description: This report communicates employee and company contributions to your retirement plans

Time Activities by Employee Detail

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates the time activities each employee entered, including hourly rate and duration

Total Pay

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates each employee’s total pay by type (salary, hourly, etc.)

Total Payroll Cost

  1. Accounts involved: Payroll Expense and Liabilities
  2. Description: This report communicates all costs associated with paying your employees, including total pay, net pay, deductions, and taxes

Vacation and Sick Leave

  1. Accounts involved: No specific accounts are applicable
  2. Description: This report communicates vacation time and sick leave your employees used so far and how much they have left

Workers’ Compensation

  1. Accounts involved: Payroll Expense
  2. Description: This report communicates wages paid for each Workers’ Compensation class, to be used to prepare forms for state agencies or insurance companies

Custom Reports

The Custom reports tab shows a list of customized reports. QuickBooks offers many customization options for reports; however, some reports have more customization options than others. Customization allows you to change the data shown in a report to display only what is most relevant to management.

To view Custom reports:

  1. From the left menu, select Reports
  2. Select the Custom reports tab

As stated, most reports have their own customization options, however, many options are shared.

Report Customization Categories

Report customization categories include:

  1. General customization options
  2. Rows/Columns customization options
  3. Filter customization options
  4. Header/Footer customization options

General Customization Options

The General customization options include:

Accounting method

  • Function: Accounting method allows you to select the accounting method between Cash or Accrual, which changes the way data is displayed. This doesn’t change your company’s QuickBooks accounting method but allows you to change how your company’s report is viewed

Negative number

  • Function: Negative number allows you to determine how negative numbers are displayed. Open the dropdown menu and select Show in red if desired

Number format

  • Function: Number format provides options for how numbers are displayed. Select the checkbox for the desired Number format options

Report period

  • Function: Report period allows you to specify the period of time for the data that will be displayed on the report. Open the dropdown menu to select various options, then specify the dates by entering them in the appropriate fields. You select All Dates to display data from the time you started your company’s QuickBooks company to date

Tax Agency

  • Function: Tax Agency allows you to select a specific tax agency to display on the report or display all tax agencies you work with. Open the dropdown menu and select a tax agency

Rows/Columns Customization Options

The Rows/Columns customization options include:

Columns

  • Function: Columns allow you to include additional information columns, as opposed to showing totals only. Open the dropdown menu and choose a selection

Group by

  • Function: Group by allows you to group data by specified criteria. This can be changed by opening the dropdown menu and making selection

Period Comparison

  • Function: Period comparison allows you to select which period to compare data to, and the format that the data is displayed. Using the checkboxes, select Previous period, Previous year, or Year-to-date, then select if you want to compare the $ change or % change. You also add a “% of” items to include by selecting the appropriate checkboxes

Select and reorder columns

  • Function: Select and reorder columns allows you to determine which rows or columns are displayed, as well as the order that they’re shown. Select the checkboxes next to the items you want to be displayed, then select and hold the Dotted box icon next to each item and drag it up or down to change the order. Any options that are not selected will be shown below the list. Select an item below to add or re-add it to the list

Show non-zero or active only

  • Function: Show non-zero or active only allows you to determine which rows and columns will be displayed. This lets you exclude rows/columns with zero amounts or only show active rows/columns

Aging Customization Options

The Aging customization options include:

Aging method

  • Function: Aging method allows you to select the data displayed between Current and Report date

Days per aging period

  • Function: Days per aging period allows you to dictate the number of days in each aging period. The default is 30, meaning it will show overdue balances for 1-30 days, 31-60 days, 61-90 days, and 91 and over

Min. Days Past Due

  • Function: Min. Days Past Due allows you to specify a minimum number of days past due. Enter in the appropriate field

Number of periods

  • Function: Number of periods allow you to change the number of periods displayed. The default is 4, meaning it will show overdue balances for four periods of time

Filter Customization Options

The Filter customization options include:

1099 Box

  • Function: 1099 Box allows you to display data only for different box items on the 1099 form. Select the checkbox next to 1099 Box, then open the dropdown menu to select which box number you want to be displayed

Account

  • Function: Account allows you to display data for different accounts. Select the checkbox next to Account, then open the dropdown menu to select “All” of a specific type of account or scroll down further to select the checkboxes next to the accounts to include

Amount

  • Function: Amount allows you to display data for a specific transaction based on the amount. Select the checkbox next to Amount, then enter the amount for the transaction that you want the data displayed for

A/R Paid or A/P Paid

  • Function: A/R Paid or A/P Paid allows you to change which accounts receivable or accounts payable data is displayed. Select the checkbox next to A/R Paid or A/P Paid, then open the dropdown menu and select All, Paid, or Unpaid

Billable

  • Function: Billable allows you to display data based on whether an activity was billable. Select the checkbox next to Billable, then open the dropdown menu and select All, Billable, or NonBillable

Check Printed

  • Function: Check Printed allows you to display data only for checks that are Printed or To be printed. Select the checkbox next to Check Printed, then open the dropdown menu and select Printed or To be printed

Cleared

  • Function: Cleared allows you to display data only for transactions that are Cleared, Uncleared, or Reconciled. Select the checkbox next to Cleared, then open the dropdown menu and select Cleared, Uncleared, or Reconciled

Created Date

  • Function: Created Date allows you to display data for a time period based on when the transaction was created. Select the checkbox next to Created Date, then open the dropdown menu and select the date range you want to show on the report

Crew #

  • Function: Crew # allows you to display data for a specific employee or crew member based on their Crew # if you use crew #s. Select the checkbox next to Crew #, then enter the crew # of the employee for that you want the data displayed for

Customer

  • Function: Customer allows you to display data for only specified customers. Select the checkbox next to Customer, then open the dropdown menu and select the customer(s) that you want to show on the report

Customer Taxable

  • Function: Customer taxable allows you to display data for only customers that are Taxable or Non-Taxable. Select the checkbox next to Customer Taxable, then open the dropdown menu and select Taxable or Non-Taxable

Deleted

  • Function: Deleted allows you to display data for items you have deleted. Select the checkbox next to Deleted, then open the dropdown menu and select all, Deleted, or Not Deleted

Distribution Account

  • Function: A distribution Account allows you to display data for different account types. Open the dropdown menu to select “All” of a specific type of account or scroll down further to select the checkboxes next to the accounts to include. The distribution account is typically the account(s) specified at the bottom of a form

Due Date

  • Function: Due Date allows you to display data to include only specific due dates. Select the checkbox next to Due Date, then open the dropdown menu and select which due dates you want to show on the report

Employee

  • Function: Employee allows you to display data for only specified employees. Select the checkbox next to Employee, then open the dropdown menu and select the employee(s) that you want to show on the report

End Date

  • Function: End Date allows you to display data for a time period based on when the recurring transaction’s end date was specified. Select the checkbox next to End Date, then open the dropdown menu and select the date range you want to show on the report

Estimate Status

  • Function: Allows you to display only estimates based on their status, such as Pending, Accepted, Rejected, etc. Select the checkbox next to Estimate Status, then open the dropdown menu and select Pending, Accepted, or Rejected

Expiration Date

  • Function: Estimate Status allows you to display data for a time period based on when the transaction (typically estimates) expired. Select the checkbox next to Expiration Date, then open the dropdown menu and select the date range you want to show on the report

Hired Date

  • Function: Hired Date allows you to display employee data for a time period based on when the employee was hired. Select the checkbox next to Hired Date, then open the dropdown menu and select the date range you want to show on the report

Last Modified Date

  • Function: Last Modified Date allows you to display data for a time period based on when the transaction was last modified. Select the checkbox next to Last Modified Date, then open the dropdown menu and select the date range you want to show on the report

Location

  • Function: Location allows you to display data for only specified locations. Select the checkbox next to Location, then open the dropdown menu and select the location(s) that you want to show on the report. This option is only available if Location tracking is enabled

Memo

  • Function: Memo allows you to display data for a specific transaction based on its memo information. Select the checkbox next to Memo, then enter the memo information from the transaction that you want the data displayed for

Name

  • Function: Name allows you to display data for only specified customers, vendors, and employees based on the name. Select the checkbox next to Name, then open the dropdown menu and select the names of those you want data displayed for

Num

  • Function: Num allows you to display data for a specific transaction based on the transaction number. Select the checkbox next to Num, then enter the transaction number for the transaction you want the data displayed for

Payment Method

  • Function: Payment Method allows you to display data for only specified payment methods. Select the checkbox next to Payment Method, then open the dropdown menu and select the payment method(s) that you want to show on the report

Product/Service

  • Function: Product/Service allows you to display data for only specified products/services. Select the checkbox next to Product/Service, then open the dropdown menu and select the product(s) or service(s) that you want to show on the report

Product/Service Taxable

  • Function: Product/Service Taxable allows you to display data for only products/services that are Taxable or Non-Taxable. Select the checkbox next to Product/Service Taxable, then open the dropdown menu and select Taxable or Non-Taxable

Released Date

  • Function: Released Date allows you to display employee data for a time period based on when the employee was released. Select the checkbox next to Released Date, then open the dropdown menu and select the date range you want to show on the report

Sales Printed

  • Function: Sales Printed allows you to display data only for sales that are Printed or To be printed. Select the checkbox next to Sales Printed, then open the dropdown menu and select Printed or To be printed

Sales Rep

  • Function: Sales Rep allows you to display data for a specific sales representative. Select the checkbox next to Sales Rep, then enter the name of the sales rep you want the data displayed for

Sent

  • Function: Sent allows you to display data only for transactions that are Sent or To be sent. Select the checkbox next to Sent, then open the dropdown menu and select Sent or To be sent

Ship Via

  • Function: Ship Via allows you to display data based on Ship Via information. Select the checkbox next to Ship Via, then enter the ship via information that you want the data displayed for

Template Name

  • Function: Template Name allows you to display data for a specific template based on the template name. Select the checkbox next to Template Name, then enter the name of the template that you want the data displayed for

Terms

  • Function: Terms allow you to display data for only specified terms. Select the checkbox next to Terms, then open the dropdown menu and select the terms that you want to show on the report

Transaction Type

  • Function: Type allows you to display data for only specified types of transactions. Select the checkbox next to Transaction Type, then open the dropdown menu and select the transaction type(s) that you want to show on the report

Type of Contractors

  • Function: Type of Contractors allow you to display data for only specific types of contractors. Select the checkbox next to Type of Contractors, then open the dropdown menu and select the contractor type that you want to show on the report

Vendor

  • Function: Vendor allows you to display data for only specified vendors. Select the checkbox next to Vendor, then open the dropdown menu and select the vendor(s) that you want to show on the report

Header/Footer Customization Options

The Header/Footer customization options include:

Alignment

  • Function: Alignment allows you to determine where the header and footer are positioned in the report. Open the drop-down menu and select Left, Center, or Right

Footer

  • Function: Footer allows you to change or edit the information displayed at the bottom of the report page. Select the checkbox next to the items you want to appear in the footer

Header

  • Function: The header allows you to change or edit the information displayed at the top of the report page. Select the checkbox next to the items you want to appear in the header, then edit the text if desired. This is where you change the name of the report by editing the Report title

Customizing Reports

When you customize a QuickBooks report, you make changes to the information displayed on an existing report using the features listed above. Customizing reports allows you to format a specific report to determine what data is displayed and how it’s displayed, based on the information management determines is relevant for that report.

Depending on which report you have open, several basic customization options will be available, such as the following:

  • Report period – Allows you to determine the date range of data displayed. Open the drop-down and make selections or enter dates in the appropriate fields
  • Display columns – Allows you to add or change display columns. Open the drop-down and make a selection
  • Show non-zero or active only – Allows you to display rows and columns by Active, All, or Nonzero. Open the dropdown and make a selection
  • Compare another period – Allows you to compare the Report period entered previously with another period or periods, as well as compare by percent of row or column. Select the checkboxes next to the desired options. Select Reorder columns to rearrange the order by which the columns are displayed
  • Accounting method – Allows you to display the results as Cash or Accrual
  • Aging method – Allows you to display results as current or as of the report date
  • Days per aging period – This allows you to determine the number of days per aging period, with the default being 30. You can change this by entering the desired number
  • Number of periods – Allows you to determine the number of periods, with the default being 4. You can change this by entering the desired number
  • Rows/Columns – Allows you to group rows and/or columns by a specified category. Open the dropdown and make a selection
  • Min. Days Past Due - Allows you to enter a minimum number of days past due to display

After making any changes, select Run report to display the customized report.

Certain reports also have in-report customization options, such as the following:

  • Sort – Allows you to sort the data (ex. ascending or descending)
  • Add notes – This allows you to enter notes, which are then displayed at the bottom of the report
  • Edit titles – This allows you to replace the default titles used in reports of that type. For example, you could replace the title Income with Revenue. After selecting Edit Titles, enter the desired label for each title, then select Save

To create a customized report:

  1. With a report open, select Customize
  2. The Customize report section will then appear
  3. Change the settings in the Customize Report section
  4. You expand customization categories by selecting them
  5. Select Run Report
  6. Select Save customization to save the customized report
  7. Enter a name for the custom report
  8. (Optional) Select a group you want to add the report to or select Add new group to create a new group
  9. Grouping reports will allow you to keep them organized on the Custom reports tab. Groups also allow you to email multiple reports at once. This is discussed in more detail in Preparing and Distributing Relevant Reports
  10. Select which users you would like to share the report with from the drop-down menu. When you share a report, it allows other users in your company to view the custom report from the Custom reports tab
  11. Select Save. The custom report will then show on the Custom reports tab

Management Reports

The Management reports tab contains compilation reports relevant to management personnel. These reports focus on the big picture standing of the company, including the Company Overview, Sales Performance, and Expenses Performance reports.

When you run one of these reports, it will be conveniently formatted as a professional report, ready to be printed or distributed accordingly. Before running a report, you select the Report Period by opening the drop-down menu on the table and selecting the available options. After you open a report, you print the report by selecting Print.

To view Management reports:

  1. From the left menu, select Reports
  2. Select the Management reports tab

Management Reports include:

  1. Company Overview
  2. Sales Performance
  3. Expenses Performance
  4. Editing and Customizing Management Reports

Company Overview

The Company Overview report includes two reports, the Profit and Loss and Balance Sheet reports. Combining these two reports provides management with an awareness of some aspects of the financial standing of your company.

Sales Performance

Sales Performance includes three reports, the Profit and Loss, A/R Aging Detail, and Sales by Customer Summary reports. Combining these reports provides management with an awareness of the sales performance of the company, including current sales and outstanding customer balances.

Expenses Performance

Expenses Performance includes three reports, the Profit and Loss, A/P Aging Detail, and Expenses by Vendor Summary report. Combining these reports provides the viewer with an awareness of the company’s expenses, including current expenses and money still owed.

Editing and Customizing Management Reports

Editing or customizing your company’s Management reports allows you to change how they’re displayed. You modify the style, report title, contents, and more.

We customize the Management Report based on what we believe is the most relevant financial information for the company’s specific type of business.

Preparing and Distributing Relevant Reports

Your responsibility is to generate and communicate timely, relevant, and reliable financial information to internal (owner, manager, and employee) and external (bank, vendor, and tax agency) users.

Preparing and communicating financial information enables internal users to make better business decisions and enables the company to comply with external user requirements and regulations.

The types of reports you run and who you distribute them to differ from company to company. However, the way you distribute QuickBooks reports is the same. You email or print your QuickBooks reports, but we recommend you distribute them through email.

Preparing and Distributing Relevant Reports includes:

  1. Emailing Reports
  2. Scheduled Reports
  3. Report Groups
  4. Sending Management Reports

Emailing Reports

The most efficient way to distribute reports is through email.

To email a report:

  1. Select Run report to generate the report
  2. Select the Email icon at the top right of the report page
  3. Review the report and select Email
  4. Enter the recipient’s email address (To), carbon copy (Cc) recipient’s email address, Subject, email contents (Body), and report title (Report)
  5. Select Send

Scheduled Reports

QuickBooks has a feature that allows you to run and email reports automatically on a recurring schedule. This feature is convenient for daily, weekly, monthly, quarterly, and annual reports. The feature can also be used for custom reports.

To set a report schedule:

  1. From the left menu Select Reports, then select Custom reports
  2. Locate the custom report and select Edit from the Action column
  3. The Custom Report edit page opens
  4. Select the Set email schedule toggle switch to On
  5. Complete the Set Recurrence window to determine the schedule
  6. Enter the recipient’s email address (To), carbon copy (Cc) recipient’s email address
  7. You edit the Subject and email contents (Body) and attach the report as an Excel file
  8. Select Save and close

Report Groups

Using groups is the best way to keep your company’s reports organized on the Custom reports tab. You also create schedules for your company’s groups, allowing you to send multiple reports to the same recipient. One option to add a custom report to a group is to do so when saving it as a customized report. Otherwise, you will group reports from the Custom reports tab.

To add a report to a group:

  1. Select Reports from the left menu, then Custom reports
  2. Locate the report you want to group and select Edit from the Action column
  3. Under Add this report to a group, open the drop-down menu and select an existing group or add a new one
  4. Select Save and close

Once a report is added to a group, you’ll note on the Custom reports page that it’s organized under that group. You then create a schedule for the group the same way you do for individual reports, allowing you to send a collection of reports together on a recurring basis.

Sending Management Reports

Another common way to send multiple reports together is by using Management Reports. A management report is a compilation of reports, organized with a cover page and areas for notes to the user, making it a great format for reporting information. Once you customize your company’s management reports you email them.

To email management reports:

  1. Select Reports from the left menu, then select Management reports.
  2. Locate the report and open the drop-down menu in the Action column and select Send.
  3. Enter the recipient’s email address (To), carbon copy (Cc) recipient’s email address
  4. You edit the Subject, email contents (Body), and Filename
  5. Select Send email

QuickBooks Report Email Schedule

Daily and weekly reports are generally for the bookkeeper or personnel who use a report’s information, such as accounts receivable or accounts payable personnel. These reports are usually not grouped or included in management reports but are generated and emailed individually.

Monthly, quarterly and annual reports are generally for the owners and managers who use a report’s information, such as the sales or purchases manager. Therefore, management reports should be emailed to the owners and Cc’d to the responsible manager.

The following daily, weekly, monthly, quarterly, and annual report schedules are used by most companies. However, the types of QuickBooks reports you generate and communicate may vary depending on the company.

QuickBooks Report Email Schedule includes:

  1. Daily Reports
  2. Weekly Reports
  3. Monthly Reports
  4. Quarterly Reports
  5. Annual Reports

Daily Reports

Daily reports should be generated each business day.

Note: As part of your QuickBooks setup, your accountant will customize, group, and schedule your daily reports.

The daily reports include the following three sections:

  1. Cash Flow
  2. Sales
  3. Expense

Cash Flow Reports

Cash Flow reports include one report:

  1. Statement of Cash Flows (Report period: Yesterday)

Sales Reports

Sales reports include four reports:

  1. Sales by Customer Detail (Report period: Yesterday)
  2. Sales by Product/Service Detail (Report period: Yesterday)
  3. Accounts Receivable Aging Detail (Report period: Yesterday)
  4. Collections (Report period: Yesterday)

Expense Reports

Expense reports include three reports:

  1. Purchases by Vendor Detail (Report period: Yesterday)
  2. Purchases by Product/Service Detail (Report period: Yesterday)
  3. Accounts Payable Aging Detail (Report period: Today)

Weekly Reports

The Weekly Management Report should be scheduled to be emailed to owners and managers on Monday or the first business day of each week.

Note: As part of your QuickBooks setup, your accountant will customize, group, and schedule your Weekly Management Report.

The Weekly Management Report includes the following five sections:

  1. Financial Position
  2. Profitability
  3. Cash Flow
  4. Sales
  5. Expense

Financial Condition Reports

Financial condition reports include three reports:

  1. Balance Sheet (Report period: Last Week; Compare another period: % of Column)
  2. Balance Sheet Comparison (Report period: Last Week; Compare another period: Previous Period, $ change and % change)
  3. Balance Sheet Comparison (Report period: Last Week; Compare another period: Previous Year, $ change and % change)

Profitability Reports

Profitability reports include three reports:

  1. Profit and Loss as % of total income (Report period: Last Week)
  2. Profit and Loss Comparison (Report period: Last Week; Compare another period: Previous Period, $ change and % change)
  3. Profit and Loss Comparison (Report period: Last Week; Compare another period: Previous Year, $ change and % change)

Cash Flow Reports

Cash Flow reports include one report:

  1. Statement of Cash Flows (Report period: Last Week)

Sales Reports

Sales reports include six reports:

  1. Sales by Customer Summary (Report period: Last Week; Compare another period: % of Column)
  2. Sales by Customer Summary (Report period: Last Week; Compare another period: Previous Period, $ change and % change)
  3. Sales by Customer Summary (Report period: Last Week; Compare another period: Previous Year, $ change and % change)
  4. Sales by Product/Service Summary (Report period: Last Week)
  5. Accounts Receivable Aging Summary (Report period: Last Week)
  6. Collections (Report period: Last Week)

Expense Reports

Expense reports include four reports:

  1. Expenses by Vendor Summary (Report period: Last Week; Compare another period: % of Column)
  2. Expenses by Vendor Summary (Report period: Last Week; Compare another period: Previous Period, $ change and % change)
  3. Expenses by Vendor Summary (Report period: Last Week; Compare another period: Previous Year, $ change and % change)
  4. Accounts Payable Aging Summary (Report period: Last Week)

Monthly Reports

The Monthly Management Report should be scheduled to be emailed to owners and managers each month after you reconcile your last month’s bank and credit card accounts.

Note: As part of your QuickBooks setup, your accountant will customize, group, and schedule your Monthly Management Report.

The Monthly Management Report includes the following five sections:

  1. Financial Position
  2. Profitability
  3. Cash Flow
  4. Sales
  5. Expense

Financial Condition Reports

Financial condition reports include three reports:

  1. Balance Sheet (Report period: Last Month; Compare another period: % of Column)
  2. Balance Sheet Comparison (Report period: Last Month; Compare another period: Previous Period, $ change and % change)
  3. Balance Sheet Comparison (Report period: Last Month; Compare another period: Previous Year, $ change and % change)

Profitability Reports

Profitability reports include six reports:

  1. Profit and Loss as % of total income (Report period: Last Month)
  2. Profit and Loss Comparison (Report period: Last Month; Compare another period: Previous Period, $ change and % change)
  3. Profit and Loss Comparison (Report period: Last Month; Compare another period: Previous Year, $ change and % change)
  4. Profit and Loss as % of total income (Report period: This Year-to-last-month)
  5. Profit and Loss Comparison (Report period: This Year-to-last-month; Compare another period: Previous Year, $ change and % change)
  6. Profit and Loss by Month (Report period: This Year-to-last-month; Compare another period: % of Income)

Cash Flow Reports

Cash Flow reports include two reports:

  1. Statement of Cash Flows (Report period: Last Month)
  2. Statement of Cash Flows (Report period: This Year-to-last-month)

Sales Reports

Sales reports include nine reports:

  1. Sales by Customer Summary (Report period: Last Month; Compare another period: % of Column)
  2. Sales by Customer Summary (Report period: Last Month; Compare another period: Previous Period, $ change and % change)
  3. Sales by Customer Summary (Report period: Last Month; Compare another period: Previous Year, $ change and % change)
  4. Sales by Customer Summary (Report period: This Year-to-last-month; Compare another period: % of Column)
  5. Sales by Customer Summary (Report period: This Year-to-last-month; Compare another period: Previous Year, $ change and % change)
  6. Sales by Product/Service Summary (Report period: Last Month)
  7. Sales by Product/Service Summary (Report period: This Year-to-last-month)
  8. Accounts Receivable Aging Summary (Report period: Last Month)
  9. Collections (Report period: Last Month)

Expense Reports

Expense reports include five reports:

  1. Expenses by Vendor Summary (Report period: Last Month; Compare another period: % of Column)
  2. Expenses by Vendor Summary (Report period: Last Month; Compare another period: Previous Period, $ change and % change)
  3. Expenses by Vendor Summary (Report period: This Year-to-last-month; Compare another period: Previous Year, $ change and % change)
  4. Expenses by Vendor Summary (Report period: This Year-to-last-month; Compare another period: % of Column)
  5. Accounts Payable Aging Summary (Report period: Last Month)

Quarterly Reports

The Quarterly Management Report should be scheduled to email to owners and managers each quarter after you reconcile your last month’s bank and credit card accounts. These reports are generated in April, July, October, and January if your company has a calendar year-end (December 31, 20XX).

Note: As part of your QuickBooks set up, your accountant will customize, group, and schedule your Quarterly Management Report.

The Quarterly Management Report includes the following six sections:

  1. Financial Position
  2. Profitability
  3. Cash Flow
  4. Sales
  5. Expense

Financial Position Reports

Financial condition reports include three reports:

  1. Balance Sheet (Report period: Last Quarter; Compare another period: % of Column)
  2. Balance Sheet Comparison (Report period: Last Quarter; Compare another period: Previous Period, $ change and % change)
  3. Balance Sheet Comparison (Report period: Last Quarter; Compare another period: Previous Year, $ change and % change)

Profitability Reports

Profitability reports include four reports:

  1. Profit and Loss as % of total income (Report period: Last Quarter)
  2. Profit and Loss Comparison (Report period: Last Quarter; Compare another period: Previous Period, $ change and % change)
  3. Profit and Loss Comparison (Report period: Last Quarter; Compare another period: Previous Year, $ change and % change)
  4. Quarterly Profit and Loss Summary (Report period: This Year-to-last-month; Compare another period: % of Income)

Cash Flow Reports

Cash Flow reports include two reports:

  1. Statement of Cash Flows (Report period: Last Quarter)
  2. Statement of Cash Flows (Report period: This Year-to-last-month).

Sales Reports

Sales reports include four reports:

  1. Sales by Customer Summary (Report period: Last Quarter; Compare another period: % of Column)
  2. Sales by Customer Summary (Report period: Last Quarter; Compare another period: Previous Period, $ change and % change)
  3. Sales by Customer Summary (Report period: Last Quarter; Compare another period: Previous Year, $ change and % change)
  4. Sales by Product/Service Summary (Report period: Last Quarter)

Expense Reports

Expense reports include three reports:

  1. Expenses by Vendor Summary (Report period: Last Quarter; Compare another period: % of Column)
  2. Expenses by Vendor Summary (Report period: Last Quarter; Compare another period: Previous Period, $ change and % change)
  3. Expenses by Vendor Summary (Report period: Last Quarter; Compare another period: Previous Year, $ change and % change)

Annual (Year-End) Reports

The Annual Management Report should be scheduled to email to owners and managers each year after you reconcile your last month’s bank and credit card accounts. This report is generated in January if your company has a calendar year-end (December 31, 20XX).

Note: As part of your QuickBooks set up, your accountant will customize, group, and schedule your Annual Management Report.

The Annual Management Report includes the following six sections:

  1. Financial Position
  2. Profitability
  3. Cash Flow
  4. SalesExpense

Financial Position Reports

Financial condition reports include two reports:

  1. Balance Sheet (Report period: Last Year; Compare another period: % of Column)
  2. Balance Sheet Comparison (Report period: Last Year; Compare another period: Previous Year, $ change and % change)

Profitability Reports

Profitability reports include two reports:

  1. Profit and Loss as % of total income (Report period: Last Year)
  2. Profit and Loss Comparison (Report period: Last Year; Compare another period: Previous Year, $ change and % change)

Cash Flow Reports

Cash Flow reports include one report:

  1. Statement of Cash Flows (Report period: Last Year)

Sales Reports

Sales reports include three reports:

  1. Sales by Customer Summary (Report period: Last Year; Compare another period: % of Column),
  2. Sales by Customer Summary (Report period: Last Year; Compare another period: Previous Year, $ change and % change)
  3. Sales by Product/Service Summary (Report period: Last Year)

Expense Reports

Expense reports include two reports:

  1. Expenses by Vendor Summary (Report period: Last Year; Compare another period: % of Column)
  2. Expenses by Vendor Summary (Report period: Last Year; Compare another period: Previous Year, $ change and % change)

Other Reporting Features

Other Reporting Features includes:

  1. Business Snapshot
  2. Dashboard
  3. Vendors Page
  4. Sales Overview page
  5. All Sales

Business Snapshot

The Business Snapshot contains tiles that display snapshots of your company’s income and expenses, income and expense comparisons, accounts receivable, and accounts payable using visual aids such as pie charts and bar graphs.

Due to the nature of the report, the report can’t be included in the management reports.

To view the Business Snapshot report:

  1. From the left menu, select Reports
  2. Select the Standard tab
  3. In the Business Overview section, select Business Snapshot

The My Income tile displays your company’s income for a given period. You change the reporting period by selecting the period down arrow and the period you want to display. The total income for the report period is in the upper right of the graph. To see the income percentages for that period, hover your cursor over the slices of the pie chart. To view the Profit and Loss statement for that period, select the Profit and Loss link.

The My Expenses tile displays your company’s expenses for a given period. You change the reporting period by selecting the period down arrow and the period you want to display. The total expenses for the report period are in the upper right of the graph. To see the expense percentages for that period, hover your cursor over the slices of the pie chart. To view the Profit and Loss statement for that period, select the Profit and Loss link.

The Previous Year Income Comparison displays your company’s previous year’s income in comparison to the current year. You change the reporting period and income accounts by selecting the period and accounts down arrows and the period and accounts you want to display. To see the income amount for that period, hover your cursor over the bars on the graph.

The Previous Year Expense Comparison displays your company’s previous year’s expense in comparison to the current year. You change the reporting period and expense accounts by selecting the period and accounts down arrows and the period and accounts you want to display. To see the expense amount for that period, hover your cursor over the bars on the graph.

The Who Owes Me tile displays a list of customers with outstanding balances in descending order by balance due. The total amount the company is owed for the report period is in the upper right of the tile.

The Whom I Owe tile displays a list of vendors with outstanding balances in descending order by balance due. The total amount the company owes for the report period is in the upper right of the tile.

Dashboard

The Business overview tab of the Dashboard contains tiles that display snapshots of your company’s operating performance. The tiles communicate information regarding your invoices, expenses, profit or loss, sales, and bank accounts.

To view the Business overview tab, select Dashboard from the left menu, then select Business overview.

The Invoices tile displays the amount of your company’s unpaid invoices and the amount overdue and not due yet. The tile also includes the amount paid in the last 30 days and how much of that amount is not deposited or deposited. When you select the tile, you’re directed to the Invoices page.

The Expenses tile displays your company’s total expenses over a given period categorized by the largest three expense account amounts and “Everything else” during the period. You change the reporting period by selecting the down arrow and the period you want to display. When you select Expenses, you’re directed to the Expenses page. When you select the tile, you’re directed to the expenses Transaction Report for the given period. If you select specific segments of the pie graph, you’re directed to the expenses Transaction Report for that expense.

The Profit and Loss tile displays your company’s net and total income and expenses over a given period. You change the reporting period by selecting the down arrow and the period you want to display. When you select the tile, you’re directed to the Profit and Loss report.

The Sales tile displays a point-to-point line graph to show your company’s sales over a given period. To change the report period, select the down arrow and the period you want to display. The total sales for the report period are in the upper left of the graph. To see the sales amount for that period, hover your cursor over any point on the graph.

The Bank accounts tile displays your company’s online connected bank and credit card accounts and shows their current balances and the number of transactions that need to be reviewed in your account. If you have Checking or Credit Cards parent accounts and checking and credit card subaccounts, the Checking and Credit Cards parent sections display the total balance of the subaccounts and the subaccount sections display the balance for the subaccount. When you select the Checking or Credit Cards parent account sections, you’re directed to the Checking or Credit Cards from the Bank Register page. When you select the subaccounts, you’re directed to the accounts For Review tab.

You connect online bank and credit card accounts by selecting Connect accounts. You view an account register for any connected account by selecting the Go to registers down arrow and account. You change the order of the accounts by selecting the Pencil icon and dragging each account.

The dashboard can also show a Cash Flow widget, which displays useful information regarding your cash balances and your money in/out.

To enable the Dashboard Cash Flow widget:

  1. Select the Gear icon at the top, then select QuickBooks Labs
  2. Under Cash Flow Dashboard Widget, select the radio button to On, then select Done
  3. Select Dashboard from the left menu, then select Business overview to view the Cash Flow widget

Vendors Page

The Vendors page displays a ribbon that shows unpaid and paid bills. If Purchase Orders is turned on in Account and Settings, the ribbon also displays unbilled purchase orders.

To view the Vendors page:

  1. From the left menu, select Expenses
  2. Select Vendors

Unbilled Purchase Orders displays the total amount and number of unbilled purchase orders over the last 365 days. When you select the tile, a list of open purchase orders displays.

Unpaid Bills displays the total amount and number of overdue and open bills unpaid in the last 365 days. When you select the Overdue (left) side of the tile, a list of overdue bills displays. When you select the Open Bill (right) side of the tile, a list of open bills displays.

Paid Bills displays the total amount and number of paid bills in the last 30 days. When you select the tile, a list of vendors displays.

Sales Overview Page

The Sales Overview page contains tiles that display snapshots of your company’s sales and receipts. The tiles communicate information regarding your income over time, invoices, and deposits.

To view the Sales Overview page:

  1. From the left menu, select Sales
  2. Select Overview

The Income Over Time tile displays a point-to-point line graph to show your company’s sales over a given period. To change the report period, select the down arrow and the period you want to display. The total income for the report period is in the upper left of the graph. To see the sales amount for that period, hover your cursor over any point on the graph.  

The Invoices tile displays the amount of your company’s unpaid invoices, the amount overdue and not due yet, and the amount not deposited and deposited. When you select the tile, you’re directed to the Invoices page.  

The Deposits tile displays the current day’s deposit, the expected deposit date, and the number of processed transactions. When you select the tile, you’re directed to the Deposits page.

All Sales

The All Sales page displays a ribbon that shows unbilled activity, unpaid invoices, and paid invoices.

To view the All Sales page:

  1. From the left menu, select Sales
  2. Select All Sales

The Unbilled Activity tile displays your company’s total estimate and unbilled (uninvoiced) activity amounts and number of estimates and unbilled activity over the last 365 days. When you select the Estimate (left) side of the tile, a list of open estimates displays. When you select the Unbilled Activity (right) side of the tile, a list of unsent invoices displays.  

The Unpaid Invoices tile displays the amount and number of your company’s overdue and open invoices. When you select the Overdue (left) side of the tile, a list of overdue invoices displays. When you select the Open Invoices (right) side of the tile, a list of open invoices displays.

The Paid Invoices tile displays the amount and number of your company’s invoices paid in the last 30 days. When you select the tile, a list of invoices paid in the last 30 days displays.