Difference between revisions of "How do I view unit profit?"
From Catalyst
(Created page with "{{Review}} == Summary == This article explains how to see the profit of an individual unit and how to generate a unit profit report. == More Information == Viewing the p...") |
(Bulk update) |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | == Summary == | |
| + | This article explains how to see the profit of an individual unit and how to generate a unit profit report. | ||
| − | + | == More Information == | |
| − | + | Viewing the profit or potential profit for a unit is a useful tool in managing your sales department. | |
| − | |||
| − | == More Information == | ||
| − | Viewing the profit or potential profit for a unit is a useful tool in managing your sales department. | ||
Within each unit is a {{Button|Profit}} button that will allow you to see the total projected profit of your unit sale, or total actual profit if the unit has been fully invoiced. | Within each unit is a {{Button|Profit}} button that will allow you to see the total projected profit of your unit sale, or total actual profit if the unit has been fully invoiced. | ||
| − | The pre-built system reports allow you to view the profit for all units sold within a period, split into sections such as New and Used units. You may also view the profit per document, which is a useful tool when selling multiple units on a single invoice. | + | The pre-built system reports allow you to view the profit for all units sold within a period, split into sections such as New and Used units. You may also view the profit per document, which is a useful tool when selling multiple units on a single invoice. |
| − | == Unit Profit == | + | == Unit Profit == |
Go to {{Menu|{{VS}}|Add or edit units}}. | Go to {{Menu|{{VS}}|Add or edit units}}. | ||
* Use {{DataPrompt|Search on}} to find the unit to view and click {{Button|Search}}. | * Use {{DataPrompt|Search on}} to find the unit to view and click {{Button|Search}}. | ||
* Select the unit record and click {{Button|Edit}}. | * Select the unit record and click {{Button|Edit}}. | ||
* At the top of the window you will see the {{Button|Profit details}} button. | * At the top of the window you will see the {{Button|Profit details}} button. | ||
| − | * Click the {{Button|Profit details}} button or press {{KeyPress|S-F7}}. | + | * Click the {{Button|Profit details}} button or press {{KeyPress|S-F7}}. |
| − | ** For sold units the {{Tab|Sale}} section will be auto populated with the price the unit was sold for and any accessories sold as part of the deal. | + | ** For sold units the {{Tab|Sale}} section will be auto populated with the price the unit was sold for and any accessories sold as part of the deal. |
| − | ** For unsold units the {{DataPrompt|Sales price}} for the unit will be populated with the target price. The accessories will not populate until the unit is invoiced. | + | ** For unsold units the {{DataPrompt|Sales price}} for the unit will be populated with the target price. The accessories will not populate until the unit is invoiced. |
{{Tip|text=You may adjust the {{DataPrompt|Sale Price}} in the {{Tab|Unit Profit Details}} window and click {{Button|Calculate}} to view your projected profit level at different target selling prices.}} | {{Tip|text=You may adjust the {{DataPrompt|Sale Price}} in the {{Tab|Unit Profit Details}} window and click {{Button|Calculate}} to view your projected profit level at different target selling prices.}} | ||
* The {{Tab|Cost}} section includes the cost of the unit plus any expenses recorded against the unit e.g. PDI charges, delivery fees and registration bonuses (these would be a negative expense). | * The {{Tab|Cost}} section includes the cost of the unit plus any expenses recorded against the unit e.g. PDI charges, delivery fees and registration bonuses (these would be a negative expense). | ||
| − | * The cost of accessories sold with a unit will be shown as expected costs until the workshop job they are allocated to is invoiced. At which point the actual cost is shown here. | + | * The cost of accessories sold with a unit will be shown as expected costs until the workshop job they are allocated to is invoiced. At which point the actual cost is shown here. |
| − | * The expenses against accessories would be labour charges for fitting accessories. | + | * The expenses against accessories would be labour charges for fitting accessories. |
{{Warning|text=The cost of accessories, and any expenses against the unit and accessories, will display actual expenses incurred plus any expected expenses not yet converted to actuals. This allows you to view the potential deal profit prior to any linked workshob jobs being invoiced and any actual final expenses posted.}} | {{Warning|text=The cost of accessories, and any expenses against the unit and accessories, will display actual expenses incurred plus any expected expenses not yet converted to actuals. This allows you to view the potential deal profit prior to any linked workshob jobs being invoiced and any actual final expenses posted.}} | ||
| Line 36: | Line 34: | ||
{{Tip|text=To view expenses against the unit click {{Button|Close}} to exit the profit screen and press {{KeyPress|F7}}.}} | {{Tip|text=To view expenses against the unit click {{Button|Close}} to exit the profit screen and press {{KeyPress|F7}}.}} | ||
| − | + | ||
| − | == Unit Profit Reports == | + | == Unit Profit Reports == |
| − | The standard {{Menu|{{VS}}|Wholegoods reports}} menu will contain two useful system reports - {{DataValue|V Sales Dept DOC}} and {{DataValue|Document Profit}}. | + | The standard {{Menu|{{VS}}|Wholegoods reports}} menu will contain two useful system reports - {{DataValue|V Sales Dept DOC}} and {{DataValue|Document Profit}}. |
If you do not have these options please {{SupportContact}}. | If you do not have these options please {{SupportContact}}. | ||
| Line 48: | Line 46: | ||
* At {{DataPrompt|Filter on}} enter {{DataValue|VC1}} and click {{Button|Search}}. | * At {{DataPrompt|Filter on}} enter {{DataValue|VC1}} and click {{Button|Search}}. | ||
* Select the report and click {{Button|Start}}. | * Select the report and click {{Button|Start}}. | ||
| − | * Enter any ranges e.g. the month to report on then click {{Button|Start}}. | + | * Enter any ranges e.g. the month to report on then click {{Button|Start}}. |
=== Document Profit === | === Document Profit === | ||
| Line 56: | Line 54: | ||
* At {{DataPrompt|Filter on}} enter {{DataValue|VC2}} and click {{Button|Search}}. | * At {{DataPrompt|Filter on}} enter {{DataValue|VC2}} and click {{Button|Search}}. | ||
* Select the report and click {{Button|Start}}. | * Select the report and click {{Button|Start}}. | ||
| − | * Enter any ranges e.g. the month to report on then click {{Button|Start}}. | + | * Enter any ranges e.g. the month to report on then click {{Button|Start}}. |
| − | Each of the above reports will be displayed on screen. | + | Each of the above reports will be displayed on screen. |
| − | * If you wish to output the results to Excel, click the drop down in the bottom left of your screen to change {{DataPrompt|Document}} to {{DataPrompt|Table}}. | + | * If you wish to output the results to Excel, click the drop down in the bottom left of your screen to change {{DataPrompt|Document}} to {{DataPrompt|Table}}. |
* Press {{KeyPress|C-P}} then select {{Button|Excel}}. | * Press {{KeyPress|C-P}} then select {{Button|Excel}}. | ||
| − | * Save the file in a location of your choice and it will auto open for you. | + | * Save the file in a location of your choice and it will auto open for you. |
* Once open you are advised to resave it as an Excel Workbook. | * Once open you are advised to resave it as an Excel Workbook. | ||
| − | |||
== See also == | == See also == | ||
| Line 71: | Line 68: | ||
* [[How do I log a purchase invoice as an expense against a unit?]] | * [[How do I log a purchase invoice as an expense against a unit?]] | ||
| − | {{KB_Tags|unit profit, deal profit, | + | {{KB_Tags|unit profit, deal profit, pdi, expenses, costs, target price}} |
{{FAQ}}{{How}}{{KB_VS}}{{ZN_Accounts}}{{ZN_Admin}} | {{FAQ}}{{How}}{{KB_VS}}{{ZN_Accounts}}{{ZN_Admin}} | ||
Latest revision as of 13:57, 8 July 2024
Contents
Summary
This article explains how to see the profit of an individual unit and how to generate a unit profit report.
More Information
Viewing the profit or potential profit for a unit is a useful tool in managing your sales department.
Within each unit is a [Profit] button that will allow you to see the total projected profit of your unit sale, or total actual profit if the unit has been fully invoiced.
The pre-built system reports allow you to view the profit for all units sold within a period, split into sections such as New and Used units. You may also view the profit per document, which is a useful tool when selling multiple units on a single invoice.
Unit Profit
Go to " Unit Sales Add or edit units".
- Use "Search on" to find the unit to view and click [Search].
- Select the unit record and click [Edit].
- At the top of the window you will see the [Profit details] button.
- Click the [Profit details] button or press <Shift+F7>.
- For sold units the [Sale] section will be auto populated with the price the unit was sold for and any accessories sold as part of the deal.
- For unsold units the "Sales price" for the unit will be populated with the target price. The accessories will not populate until the unit is invoiced.
 | You may adjust the "Sale Price" in the [Unit Profit Details] window and click [Calculate] to view your projected profit level at different target selling prices. |
- The [Cost] section includes the cost of the unit plus any expenses recorded against the unit e.g. PDI charges, delivery fees and registration bonuses (these would be a negative expense).
- The cost of accessories sold with a unit will be shown as expected costs until the workshop job they are allocated to is invoiced. At which point the actual cost is shown here.
- The expenses against accessories would be labour charges for fitting accessories.
 | The cost of accessories, and any expenses against the unit and accessories, will display actual expenses incurred plus any expected expenses not yet converted to actuals. This allows you to view the potential deal profit prior to any linked workshob jobs being invoiced and any actual final expenses posted. |
For guidance on processing PDI work, fitted accessories and expenses please refer to the below articles.
- PDI work and fitting accessories.
- Unit expenses.
- Posting manual expenses.
- Posting expenses via the Purchase Ledger.
| To view expenses against the unit click [Close] to exit the profit screen and press <F7>. |
Unit Profit Reports
The standard " Unit Sales Wholegoods reports" menu will contain two useful system reports - 'V Sales Dept DOC' and 'Document Profit'.
If you do not have these options please Contact your Platinum dealer or our support team on 0116 230 1500 or by using our website support contact page.
V Sales Dept DOC
 | This report displays units sold in a period split between New and Used. |
If you do not find the report on your menu go to " Unit Sales Unit Reports Unit Sales Report Generator".
- At "Filter on" enter 'VC1' and click [Search].
- Select the report and click [Start].
- Enter any ranges e.g. the month to report on then click [Start].
Document Profit
| This report is a summary report per invoice which is a useful report to view the overall deal profit per invoice. |
If you do not find the report on your menu go to " Unit Sales Unit Reports Unit Sales Report Generator".
- At "Filter on" enter 'VC2' and click [Search].
- Select the report and click [Start].
- Enter any ranges e.g. the month to report on then click [Start].
Each of the above reports will be displayed on screen.
- If you wish to output the results to Excel, click the drop down in the bottom left of your screen to change "Document" to "Table".
- Press <Ctrl+P> then select [Excel].
- Save the file in a location of your choice and it will auto open for you.
- Once open you are advised to resave it as an Excel Workbook.
See also
- How do I deal with unit preparation/PDI?
- Unit expenses explained
- How do I post expenses against a unit?
- How do I log a purchase invoice as an expense against a unit?
