Enhanced interface

Item Profitability report

The Item Profitability report shows how much profit that you made on each item in every transaction. It contains detailed information about the profitability of items that you sell over a specific period of time.

You can use this report to:

See where your retail price is vs. your actual selling price, and then move the price up or down based on profit margins
Analyze profitability by item, product line, order, customer, customer type, sales representative, and territory
Analyze sales to determine whether any items should be discontinued
Analyze performance based on group, such as customer, sales rep, and territory, to further help you determine price or even forecast results

This report covers unit cost, quantity, unit retail price, actual selling price, and the difference between these prices.

When ONHAND Inventory totals for Value or Quantity & Value are configured in an Inventory Control transaction definition, the cost of the item purchased is maintained. The item cost can be used to compare item profitability to the selling price.

Who typically needs this report?

Finance employees who price products and services
Marketing staff who need to alter advertising campaigns
Sales managers who need to analyze the performance of sales representatives
Warehouse managers who need to delete unprofitable items or entire product lines

To access this report:

Go to Order Entry > All > Reports > Item profitability.

Subscription	Order Entry, Inventory Control
User type	Business, Employee, Warehouse, CRM
Permissions	Item profitability: Run

View a monthly report

On the report settings page, select View.
The report displays all results for the default reporting period.
To refine the report, select Customize.

Customize and run

Before running the report, you can select the time period and types of items to include and specify how you want the report to appear.

If you want to see every result for a particular category, do not make selections from any of the data entry boxes. You can run this report without entering any search information. If you do that, however, the report can take a long time to run and might return too many results to be useful.

Select the reporting period from the dropdown list, or enter the start and end dates you want the report to cover. If you do not specify a reporting period, the system generates a report for the current month to date.
- You can specify either the reporting period or the start and end dates, but not both.
Set the filters to get the specific data you want.
- Filters enable you to include or exclude specific types of data in the report, such as customer, item, UPC, value, or account. Generally, to get fewer and more precise results in your report, set more filters.
Format the report.
- Format options will vary from report to report. Generally, you can set the layout of the report and arrange how to group and display the data contained in the report.
Enter a title, subtitle, and footer text for your report.
To view, process, memorize, or export the report, select one of the following:

How to work with reports
To:	Select:
View the report now, in your browser.	View
Display the report in PDF format so you can print it or save it to your local drive.	Print
Generate the report and store it for later access. Available formats include HTML, printable (PDF), Excel, CSV (comma-separated value), and Text. Reports can be stored: In Intacct In the My stored reports list Delivered to a cloud storage location, such as Dropbox Learn more about processing and storing reports.	Process and store
Add the report to your dashboard.	Add to dashboard
Memorize (that is, save) the report in the Memorized reports list so that later you can refer back to it or modify and re-run it. You can schedule memorized reports to run on a recurring basis. Intacct can automatically email the reports or deliver them to a cloud storage location.	Memorize
Export the report to a separate file that you can then distribute or save to your local drive. Available file formats vary among reports.	Export

After you run a report, you can either email it to others or return to the Report Settings page to refine the results.

Share and refine reports
After running the report, to...	Select
Email the report to others.	Email
Return to the main report page and refine the report further.	Customize

You can use trial-and-error to get the precise results you want. Just fill in the desired fields, and select View to see the report. If the results aren't what you want, select Customize to return to the report setup page and refine the report further. Repeat this process until you're satisfied.

For complex financial reports that will be run regularly, save the report after you're done setting it up. The next time you're ready to run the report, you only have to change the As of date before running the report.

Time period

You can use one of the numerous pre-defined reporting periods available from the Reporting period and As of date fields, or create your own reporting period using the Start date and End date fields.

To set the time period:

In the Time period section, do one of the following:

Use the Reporting period dropdown list to select the reporting period. Either enter a date in the As of date field or use the calendar tool to select a date.
Enter a specific Start date, End date, or both. Alternatively, use the calendar tool to select the desired dates.

If you complete all the time period fields (that is, if you fill in the Reporting period, As of date, Start date, and End date fields), Sage Intacct generates your report based on the start and end dates. It ignores the As of date.

The following table describes the fields in the Time period section.

Field	Description
Reporting period	These periods are relative to the As of date. All periods begin on the first day of the period, such as the first day of the month, quarter, or year that you select.
As of date	The date that Intacct will use as a baseline for the reporting period you select. Defaults to today's date.
Start date	Leave the Start date blank to include all information from the earliest date of your Intacct data up to and including the end date.
End date	Leave the End date blank to include all information from the start date up to today.
Prompt on run	Select this checkbox to force Intacct to wait for you (or anyone using this report) to enter a location, department, and/or time period before it will run the report.

Report filters

Use the filters to focus the results of your report. In effect, filters enable you to isolate and assemble just the data you want. You can set any combination of filters.

To set the filters to fine-tune your report results:

To include results for a specific sales representative or range of sales representatives, use the From sales representative and To sales representative dropdown lists.
To include results for a specific territory or range of territories, use the From territory and To territory dropdown lists.
To include results for a specific customer or range of customers, use the From customer and To customer dropdown lists.
To include results for a specific customer type or range of customer types, use the From customer type and To customer type dropdown lists.
- Partners and direct are two examples of customer types.
To list the items by their item IDs, UPC codes, or product lines, use one of the following sets of fields:
- Item ID. In the Report on field, select Item ID. To include results for a specific item or set of items, use either the From item and To item dropdown lists or the Operator and Value fields.
- UPC code. In the Report on field, select UPC. To include results for a specific UPC code or set of UPC codes, use either the From UPC and To UPC dropdown lists or the Operator and Value fields.
- Product line. In the Report on field, select Product line. To include results for a specific product line or set of product lines, use either the From product line and To product line dropdown lists or the Operator and Value fields.
To only include results for a specific type of transaction, from the Transaction type dropdown list, select the transaction type you want. All is the default transaction type.
If you are a multi-currency company, you can filter transactions based on a specific currency. (This field is visible only in a multi-currency environment). From the Transaction currency dropdown list, select the currency you want the report to show. If you do not select a currency, the report includes transactions in your base currency.

Filter field	Notes	Limitations
From sales representative, To sales representative	Enables you to get data only for a specific sales representative or range of sales representatives.
From territory, To territory	Enables you to get data only for a specific territory or range of territories.
From customer, To customer	Enables you to get data only for a specific customer or range of customers.
From customer type, To customer type	Enables you to get data only for a specific customer type or range of customer types.
Report on	Enables you to tell the report whether to list items by their IDs, their UPC codes, or their product line.	All items have IDs, but not all items have UPC codes.
From item, To item	Enables you to get data only for a specific item or range of items, such as items from A to F, or item numbers 3100 to 5000.	You can enter data in these fields or the From UPC and To UPC fields or the From product line and To product line fields.
Operator, Value	From the dropdown list select the operator For alphabetical lists, "greater than" means later in the alphabet, and "less than" means earlier in the alphabet. To search for all items from T through Z, search for "Greater Than" "S." To search for all items beginning with "A," search for "Less Than" "B." Most of the operators are self-explanatory. Others: Contains: You're searching for all items that contain a particular string of letters and/or numbers. Does Not Contain: You're searching for all items except those that contain a particular string of letters and/or numbers. Includes: You're searching for all items that contain two or more particular strings of letters and/or numbers. Does Not Include: You're searching for all items except those that contain two or more particular strings of letters and/or numbers . Then enter the value in the Value field.	You can enter data in these fields or the From item and To item fields, but not both.
From UPC, To UPC	Enables you to get data only for a specific UPC code or range of UPC codes.	You can enter data in these fields or the From item and To item fields or the From product Line and To product line fields.
Operator, Value	From the dropdown list select the operator For alphabetical lists, "greater than" means later in the alphabet, and "less than" means earlier in the alphabet. To search for all items from T through Z, search for "Greater Than" "S." To search for all items beginning with "A," search for "Less Than" "B." Most of the operators are self-explanatory. Others: Contains: You're searching for all items that contain a particular string of letters and/or numbers. Does Not Contain: You're searching for all items except those that contain a particular string of letters and/or numbers. Includes: You're searching for all items that contain two or more particular strings of letters and/or numbers. Does Not Include: You're searching for all items except those that contain two or more particular strings of letters and/or numbers . Then enter the value in the Value field.	You can enter data in these fields or the From UPC to To UPC fields, but not both.
From product line, To product line	Enables you to get data only for a specific product line or range of product lines.	You can enter data in these fields or the From item and To item fields or the From UPC and To UPC fields.
Transaction type	Enables you to get data only for a specific transaction type. All is the default.
Transaction currency	Select the currency that you want the report to show. If you do not select a currency, the report includes transactions in your base currency. This field appears only in multi-entity companies with multiple currencies.

Location and department filters

To set location and department options:

To filter the report by geographic location, select the location from the Location dropdown list.
Enter or select a location to run this report at the top level. The system uses the location that you specify to determine the appropriate currency.
To filter the report by department, select the department from the Department dropdown list.
If you want the report to cover certain locations regardless of what you select in the Location dropdown list, use the Show for dropdown list to select the locations you want the report to cover:
1. All Locations: Include data for all locations regardless of the entity you're currently using.
2. This Location: Include data only for the entity that you're currently using.
3. Child Locations: Include data only for the locations that are child locations of your current entity. For example, if your current entity is California, and you have child locations for San Francisco and Los Angeles, use this option to have the report include data only for Los Angeles and California.

Filter options
Filter field	Descriptions
Location	Use to limit report results to a specific location.
Department	Use to limit report results to a specific department.
Prompt on run	Select this checkbox to force the system to wait for you (or anyone using this report) to enter a location or department before it runs the report.
Show for	Select to show different views of the data, based on the location or entity you choose: All locations: This option shows the data that's posted to the location or entity and its children. This location: This option shows only the data that's posted to the location or entity you select. The data posted to any child location is not shown. Child locations: This option shows only the data that's posted to the child locations of the location or entity that you select. Any data that's posted to the parent location or entity is not shown. Example: Suppose your location is United States > California > San Francisco. All locations would show transactions for United States, California, and San Francisco. This location would show transactions for United States. Child locations would show transactions for California and San Francisco only.

Formatting

Use the fields in this section to set how the report results display and to order the results.

To format this report:

Select the type of report that you want from the Report type dropdown list. By default you will get an order detailed report.
- A Summary report type condenses all account details to a single line.
- A Detail report type displays one line per customer per account. It also includes additional columns of information.
Select the category that you want the data sorted by from the Sort by dropdown list.

Format field	Notes
Report type	Order detailed is the default report type.
Sort by	How to sort the report.

Format field

Notes

Report type

Order detailed is the default report type.

Sort by

How to sort the report.

Titles and footer

Titles, subtitles, and footers apply only to the print versions of this report. Export to Excel or CSV, or select Print for a PDF version.