Items marked with an asterisk (*) are available in Microsoft Office Accounting Professional 2009 only.
The Sales by Item Detail report contains detailed information about item sales over a selected time period. You can use this information to determine which marketing actions have been successful or unsuccessful. If items are not performing well, you can promptly adjust your marketing efforts to prevent long-term damage to your business profits, or you can decide to focus on more profitable areas.
Note: This is the cash basis version of this report. For the accrual basis version, see the link under Related topics.
Open the report
On the Reports menu, point to Cash Basis, and then click Sales by Item Detail.
Default information in this report includes transaction types and numbers, dates, customer names, quantities sold, and sales prices.
To view other information, such as item groups, sales order numbers relating to an invoice, and shipping dates, do the following:
On the toolbar, click Modify Report, and then in the Modify Report pane, select the appropriate Columns options.
For detailed information about how to view individual transaction details, or modify, display, save, print, or export the report data, see Working with reports. For detailed information about how to filter report data, see Filter reports.
Change report basis or date range
To change the report basis for this report, do the following:
On the toolbar, click the arrow next to Report Basis, and then select Cash or Accrual.
To change the date range for this report, do the following:
On the toolbar, click the arrow next to Date Range, From, or To.
Sort by report groups
You can sort the groups within the report in addition to sorting the rows within the groups:
To sort the groups within the report, on the toolbar, click the arrow next to Sort Report Groups by, and then select an option.
To switch between ascending and descending order, click the sort by ascending or sort by descending buttons on the toolbar.
When Microsoft Office Accounting 2009 is set to use foreign currency, this report displays the unit prices and amounts in the customer currencies. In addition, the report changes to include columns that show the three-letter codes for the customer currencies, the exchange rates between the customer currencies and U.S. dollars (USD), and the amounts in USD.
For more information about using foreign currency in Office Accounting 2009, see Use foreign currency.