Skip to Content
QuickBooks 2005: The Missing Manual
book

QuickBooks 2005: The Missing Manual

by Bonnie Biafore
February 2005
Beginner to intermediate
608 pages
22h 4m
English
O'Reilly Media, Inc.
Content preview from QuickBooks 2005: The Missing Manual

Sorting Reports

QuickBooks'built-in reports come sorted, but the order is rarely obvious. When you first generate a report, the Sort By box is set to Default, which means different things for different reports. For example, if you create a Sales by Customer Detail report, QuickBooks groups the transactions by customer, but it sorts the transactions for each customer from earliest to most recent. (Unlike Excel, QuickBooks sorts by only one field at a time.)

The fields you can use to sort depend on the report. For the Sales by Customer Summary report, you can sort by two columns only. The Sort By box includes Default and Total. Default sorts the report by customer name in alphabetical order. Total sorts the report by the total sales for each customer. On the other hand, the Sales By Customer Detail report includes several columns of information, and you can sort by any of them.

Top: For a detail report, the Display tab in the Modify Report dialog box includes a list of fields you can choose to include as columns in the report. If a field is preceded by a checkmark, click the field to remove it from the report. If no checkmark appears, click the field to add it. Bottom: When you create a report that makes comparisons, the Display tab on the Modify Report dialog box includes checkboxes for showing dollar and percentage comparisons. For example, if you want to focus on the percentage difference between budget and actual values, turn off the $ Difference checkbox.

Figure 19-13. Top: For a detail report, the Display tab in the Modify Report dialog box includes a list of fields you can choose to include as columns in the report. If a field is preceded by a checkmark, click the field to remove it from the report. If no checkmark appears, click the field to add it. Bottom: When you create a report that makes comparisons, the Display tab on the Modify Report dialog box includes checkboxes for showing dollar and percentage comparisons. For example, if you want to focus on the ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

QuickBooks 2010: The Missing Manual

QuickBooks 2010: The Missing Manual

Bonnie Biafore

Publisher Resources

ISBN: 0596009011Errata Page