Profit Margin Reports

Profit Margin Reports

Profit Margin Reports

You can access profit margin reports by opening the Invoices Issued/Profit Margin Report window and clicking the Gross Margin tab.

Profit margin reports provide overviews of the difference between the sale price (from issue document lines) and the valuation price (also from issue document lines).

For reports of revenue received (reports 283 to 289), the documents that you would like to include in the report must already be posted and at least partially paid, because these reports provide information about revenue received in the specified account for receivables from customers.

For all other types of reports, the only requirement is that invoices exist that meet the selected criteria.

You can use a number of criteria to limit information in the report (if criteria are not selected, all issue invoices will be included in the report)

Report Types	Select the type of profit margin report that you would like to create: Profit Margin Report - Detailed Profit Margin Report - Summary Profit Margin Report - Analysis by Reps - Detailed (rep - the person who issued the order on which the issue invoice is based) Profit Margin Reports - Analysis by Reps - Summary Profit Margin Reports - Analysis by Reps and Items Profit Margin Report - Analysis by Items - Detailed Profit Margin Report - Summary Profit Margin Report - Analysis by Customers - Detailed Profit Margin Report - Analysis by Customers - Summary Profit Margin Report - Analysis by Reps - Detailed - Revenue Received Profit Margin Report - Analysis by Reps - Summary - Revenue Received Profit Margin Report - Analysis by Items - Detailed - Revenue Received Profit Margin Report - Analysis by Items - Summary - Revenue Received Profit Margin Report - Analysis by Subjects - Detailed - Revenue Received Profit Margin Report - Analysis by Subjects - Summary - Revenue Received
Item Types	Select Item types that you would like to include in the report. Item types must be selected.
Document Types	Select the issue document types for which you would like to report issued invoices. Document types must be selected. (Record only document types are not available to select!)
Packing Slip From	Select a packing slip date if you would like to limit the report using this criteria.
Packing Slip To	Select a packing slip date if you would like to limit the report using this criteria.
VAT From	Select a VAT date if you would like to limit the report using this criteria.
VAT To	Select a VAT date if you would like to limit the report using this criteria.
Invoice From	Select an issue invoice date if you would like to limit the report using this criteria.
Invoice To	Select an issue invoice date if you would like to limit the report using this criteria.
Paid From	Criteria is visible only when reports from Revenue Received are selected (285, 286, 283, 284, 296, 297). Select a Paid date From if you would like to limit the report using this criteria. Delivery Date criterion from-to takes into account the actual date of shipment.
Paid To	Criteria is visible only when reports from Revenue Received are selected (285, 286, 283, 284, 296, 297). Select a Paid date To if you would like to limit the report using this criteria. Delivery Date criterion from-to takes into account the actual date of shipment.
Item	Select an item if you would like to limit the report to a single item or some selection of items that you have entered in issue invoices.
ID in Spec	(Available only for profit margin reports) Select an item that appears as a component of an item, a compound service, or compound goods if you would like to limit the report to items containing this component. This criteria is useful if you would like an overview of the gross margin for a component that of items that you sell but that does not appear in invoices.
(Name)	Select one or more item names as entered in document lines, if you would like to limit the report to a single item or some selection. The name of an item that appears in documents is not necessarily the same as the name listed in the Items register (for more information, see Issue Document Lines)! The Item ID and Name fields are not linked, meaning that both fields will be used as report criteria if information has been entered! the program will take information about item names from the document lines, where it is possible for the same item to appear under different names. For this reason, report may differ depending on whether item ID or item name is used as a criteria.
Primary Category	Select a primary category if you would like to limit the report to ta single item category. If a category is entered here, only invoices with items of the selected category will be included in the report.
Sec. Category	Select a secondary category if you would like to limit the report to a single secondary category.
Customer	Select a customer if you would like to limit the report to a single customer from the document header.
CIS	Select a CIS ID if you would like to limit the report by customers' CIS ID (Classification of Institutional Sectors). A customers CIS ID is entered in the Subjects register.
Customer Type	Select a customer type if you would like to limit the report to a single customer type. This is useful if you would like to see how much you've sold to a certain segment of the market.
Consignee	Select a consignee if you would like to limit the report to a single consignee from the document header.
Consignee Type	Select a consignee type if you would like to limit the report to a single type of consignee.
Country	Select a country if you would like to limit the report to selected countries where your company sells goods. Information about a subject's country can be found in the Subjects register. Since version 1001300 more than one county can be selected with multiselection function
Supplier	Select a supplier if you would like to limit the report to a single  primary supplier of goods that you have sold.
Warehouse	Select a warehouse is you would like to limit the report to a single issuing warehouse from the header of issue documents.
Dept.	Select a department if you would like to limit the report to a single document entered in document lines.
Cost Ctr.	Select a cost center if you would like to limit the report to a single document entered in document lines.
Linked Doc. 1	Select a linked document if you would like to limit the report to a linked document 1 (order slip, for example).
From (Linked Doc. 1)	Select a date for linked document 1 if you would like to limit the report by linked document date.
To (Linked Doc. 1)	Select a date for linked document 1 if you would like to limit the report by linked document date.
Linked Doc. 2	Select a linked document if you would like to limit the report to a linked document 2 (order slip, for example).
From (Linked Doc. 2)	Select a date for linked document 2 if you would like to limit the report by linked document date.
To (Linked Doc. 2)	Select a date for linked document 2 if you would like to limit the report by linked document date.
Sell To	Select a sell to method if you to limit the report to a single sell to method from documents. You can limit the report to: All (Blank field) - all issue invoices, regardless of the sell to method. If you would like to include all sell to methods in the report, leave this field blank VAT registered - only invoices issued to VAT registered persons will be included in the report Export - only invoices for exports will be included in the report End customer - only invoices issued to end customers will be included in the report Private - only invoices issued for own use of the private type will be included in the report Non-business - only invoices issued for own use of the non-business type will be included in the report Own use - only invoices issued for own use of the own use type will be included in the report
Pmnt. Method	Select a payment method if you would like to limit the report to a single payment method from issue invoices.
Delivery Method	Select a delivery method if you would like to limit the report to a single delivery method from issue invoices.
Document Status	Select a status if you would like to limit the report to documents with a particular status: All/Blank field - all documents, regardless of their status. If this field is left blank, all document statuses will be included in the report. Confirmed - only documents that have been confirmed will be included in the report Unapproved - only documents that have not been approved will be included in the report
VAT Rate	Select a tax rate if you would like to limit the report to a single tax rate entered in the document lines.
Clerk	(Only available for profit margin reports) Select a clerk if you would like to limit the report to a single clerk (Clerk field) from issue documents.
Text	Select a text ID if you would like to limit the report to a single text ID from issue documents.
Terms	Select a delivery terms ID if you would like to limit the report to a single delivery terms ID from issue documents.
Place	Select a place of delivery if you would like to limit the report to a single place of delivery from issue documents.
For Currency	Select a currency if you would like to limit the report to a single currency that documents have been created in. Using this criteria you could, for example, limit the report to invoices issued in U.S Dollars.
Convert to Currency	Select the code of the currency in which you would like to show the information in the report. You can create an invoices issued report in any currency for which you keep updated information in the Banks register. You can, for example, convert all invoices issued in a given period into Euros, regardless of the currency used in the invoices (see Invoices Issued Report in a Foreign Currency).
Difference Type	(Only Available for profit margin reports) Select the type of profit margin that you would like to report. Choose from the following: All/Blank field - both positive and negative margins will appear in the report. This will also occur if this field is left blank Only Positive Difference - only positive differences in prices will appear in the report Only Negative Difference - only negative differences will appear in the report. Reports of this type are useful for making sure that sales representatives are adhering to your company's pricing policy.
Tax Type	(Only available for profit margin reports) Select the type of tax that you would like to report. Choose from the following: All/Blank field - all invoices will be included in the report, regardless of whether or not tax was calculated on them. This will also occur if this field is left blank. Excl. Tax - only issue invoices on which tax has NOT been calculated will be included in the report Incl. Tax - only issue invoices on which tax has NOT been calculated will be included in the report
Bank for FCY Docs.	Select which exchange rates will be used by the program to convert foreign currency documents. Exchange Rate for Price List – the bank for price list selected in the Program Parameters will be used Bank of Slovenia – the exchange rates of the Bank of Slovenia selected in the Program Parameters will be used If you would like to convert invoices to another currency (see Gross Margin Report - Convert to Currency field), the values and prices will be converted to the desire currency using the selected exchange rates (the Bank for FCY Docs. field). Exchange Rate for Price List (see Program Parameters | Company | General) Bank of Slovenia (see Program Parameters | Company | General) The date that will be used for the conversion will be determined the same way it is when entering issue invoices: the date for the exchange rates is usually the date of the invoice. You can specify a different date at Program Parameters | Goods | General.
Account	(Only available for profit margin reports of the Revenue Realized type) Enter the number of the account where you keep track of receivables from customers. By default, this is the first customer account from the parameters (Program Parameters | Financials | General).
Use Secondary Subject type	If this parameter is checked, program collected data for customer type defined by subject in general data of Subject. If parameter is not checked program collected data just for primary customer type defined by subject in general data of Subject
	This button will generate an invoices issued report using the selected criteria.
	Displays Ad-Hoc analyses

	Profit margin reports also take account of price differences for own goods and compound goods, that is, the valuation price determined in work orders is used.
	The program uses the actual price difference, which is expressed as follows: Difference = invoiced value of item - (minus) value of item at issuing warehouse on day of issue. The value of an item at the issuing warehouse depends on the stock tracking method used at that warehouse. For this reason, it usually differs from the most recent purchase price.
	The price difference or purchase value for items of the type S - Service is always 0.
	Before creating a profit margin report, it is recommended that you run the Refresh Stock function.

For general description of the task bar functions see Task Bar.

Shortcuts in the right-click menu can be used to make selecting item types and documents types in the Item Types and Document Types fields easier (see Basics - Multiple Selection Lists).

	Report criteria must be selected each time you create a report. Criteria can also be saved as a template.
	Like with all other modules where filtration criteria can be selected, a blank field means that documents with all possible values will be included in the report. If information is selected in a field, only documents and lines where the same information has been selected or entered will be included in the report. Filtration can be slightly expanded using wildcards (see Basics - Wildcards).