Intuit Intuit HomeIntuit Products
nav_top_golden_seal QuickBooks
Order Status My Account Shopping Cart
 

Quick Tips for Users of QuickBooks Premier, Pro and Basic 2002

How can I print a report with 12 months on one page?

How can I print a report with one line per invoice, and include missing and duplicate invoice numbers?



Q:  

How can I print a report with 12 months on one page?

A:  


Customize and memorize a QuickBooks summary report.

Customize and memorize 'Profit & Loss by Month' summary report:

  1. For users of QuickBooks 2000, 2001, 2002, and 2003: From the Reports menu, choose Company & Financial, then choose Profit & Loss Standard.

  2. After the report displays, choose Modify Report.

  3. On the Display tab, change the date range to 12 months (for example, select Last Fiscal Year in the Dates drop-down).

  4. Change the Columns drop-down from 'Total only' to 'Month.'

  5. Choose OK to close Modify Report.

  6. Choose Collapse on the reports buttonbar.

  7. Choose Print.

  8. Change the Orientation from Portrait to Landscape.

  9. Check the box "Fit report to 1 page(s) wide."

  10. Choose Preview.

  11. Choose Print.

  12. Choose Memorize and name the report Profit & Loss by Month.


Customize and memorize a Balance Sheet by Month summary report:
  1. For users of QuickBooks 2000, 2001, 2002, and 2003: From the Reports menu, choose Reports > Company & Financial > Balance Sheet Standard.

  2. Repeat steps 2 through 11 above.

  3. Choose Memorize and name the report 'Balance Sheet by Month.'


Summary reports that can be customized by Month:
  • Profit & Loss Standard
  • Profit & Loss Unclassified (2003)
  • Income by Customer Summary
  • Expenses by Vendor Summary
  • Balance Sheet Standard
  • Balance Sheet Summary
  • Customer Balance Summary
  • Sales by Customer Summary
  • Sales by Rep Summary
  • Time by Job Summary (Pro, Premier, and Enterprise)
  • Time by Name (Pro, Premier, and Enterprise)
  • Time by Item (Pro, Premier, and Enterprise)
  • Vendor Balance Summary
  • Sales Tax Revenue Summary (2002 and 2003)
  • Purchases by Vendor Summary
  • Payroll Liabilities
  • Profit & Loss Budget Overview
  • Forecast Overview (2003 Premier and Enterprise)
  • Custom Summary (on Modify Report's Display tab, use the 'Display rows by' option to create reports by Customer Type, Vendor Type, and so on).

Back to Top

Q:  

How can I print a report with one line per invoice, and include missing and duplicate invoice numbers?

A:  


Customize the QuickBooks Missing Checks report and memorize as Invoices by Number.

Customize and memorize an Invoice by Number detail report:

  1. For users of QuickBooks 2000, 2001, 2002, and 2003: From the Reports menu, choose Banking.

  2. Choose Missing Checks.

  3. Click the Specify Account drop-down, select Accounts Receivable and choose OK.

  4. After the report displays, choose Modify Report.

  5. Scroll down to the bottom of the Columns box.

  6. Select Balance to display a checkmark.

  7. Choose Header/Footer and change the Report Title from Missing Checks to Invoices by Number.

  8. Choose OK.

  9. On the report, place the mouse pointer over the diamond to the right of Split until the pointer turns to a 'plus' indicator.

  10. Hold the left mouse button and drag the right diamond to the left diamond.

  11. Release the left mouse button and the Split column is removed from the report.

  12. Repeat steps 9 through 11 to remove the Account column.

  13. Choose Print.

  14. Check the box "Fit report to 1 page(s) wide."

  15. Choose Preview.

  16. Choose Print.

  17. Choose Memorize and name the report Invoice by Number.


Adding and removing report columns without a mouse:
  • In step 5, press Tab three times to move to Columns window.

  • Press the Down Arrow once.

  • Press Page Down four times.

  • Press the Down Arrow to move to 'Balance.'

  • Press the Space Bar to place the checkmark on 'Balance.'

  • Press the Up Arrow eleven times to move to 'Split.'

  • Press the Space Bar to remove the checkmark on 'Split.'

  • Press the Up Arrow seven times to move to 'Account.'

  • Press the Space Bar to remove the checkmark on 'Account.'

  • Continue with step 7, skip steps 9-12, and complete steps 13-17.


Back to Top

Terms and conditions, features, support, pricing and service options subject to change without notice.
Privacy Statement