QuickBooks for Mac 2014 User’s Guide 207
• Number—Choose transactions based on invoice or check number. To include all transactions within a range of
numbers, enter both a beginning number and ending number. To exclude all transactions EXCEPT for one, enter
the number of that one transaction in the first field, and leave the second field blank.
• Paid Status—Include only those invoices and bills that have a specific paid status (Closed, Open, or Either).
• Payroll Item—Limit the report to specific payroll items (like Vacation Salary, Health Insurance, and Federal
Withholding).
• Posting Status—Posting status of transactions to a register. Most transactions post to a register; for example,
when you create an invoice, QuickBooks records the amount in your accounts receivable register. A few types of
transactions—estimates, pending sales, and purchase orders—are non-posting in that they never appear in a
register.
• Received—Include open purchase orders, closed purchase orders, or both.
• Ship Date—Include only those invoices and cash sales receipts that have a specific shipping date.
• Source Account—Limit the report to transactions that originated from a particular balance sheet account — or
a group of balance sheet accounts. For example, a profit and loss report normally represents all your company's
balance sheet accounts. To show only the checking transactions that contributed to your company's profit, use
the Source Account field to select the checking accounts. Important: the Source list also shows all of your
income and expense accounts. Ignore these accounts when you select the balance sheet accounts. If you also
want to restrict the report to specific income and expense accounts, use the Account list to select those
accounts.
• To Be Printed—Restrict transactions based on whether they have been printed or not.
• Transaction Type—Choose the type of transactions (checks, payments, and so on) you want included in this
report.
• Vendor Type—Limit your report to transactions related to one of your vendor types.
Grouping and subtotaling data
• Choose column headings for subtotals. Some reports let you subtotal amounts in columns for time periods or
other factors. For example, you can show weekly subtotals on the Profit and Loss Detail report.
1 Create the report.
2 On the report buttonbar, click Options.
3 Choose an item from the Columns list. Make sure the dates and other options on the Options window
are correct.
4 Click OK. The column appears on the left side of the P&L Detail report.
• Choose row headings for groups. If none of the preset reports have the row headings you want, create a
custom report.
1 Choose Reports > Custom Summary Report.
2 On the report buttonbar, click Options.
3 Choose an item from the Row Axis list.
4 Click OK. The Custom Summary Report changes to show your choice by row.
To Next Page
Loading...