When importing new items using the file importer, you can either give all pricing components (such as the purchase price, markup, and selling price) to the importer or only some specific information (such as the selling price) and let the importer calculate the missing ones.
This article provides an overview of the automatic calculation rules that Provet Cloud applies. The results of the calculations are shown in the importer's preview step. To access the file importer, go to Settings > Import & Export > Import from file.
VAT (Sales Tax) Calculations
Importing New Items
The following rules apply to all prices that have VAT and non-VAT versions.
|Case||Price excluding VAT||VAT%||Price including VAT|
|All components given||10||10%||12|
|Excl. VAT given||10||10%||calculated (12)|
|Incl. VAT given||calculated (10)||calculated (10%)||12|
|No prices given||assumed zero (0)||assumed zero (0%)||assumed zero (0)|
The following pricing options are affected by the VAT calculation rules:
- Purchase price
- Selling price
- Net purchase price
- Minimum price
- Minimum charge
- Handling fee
- Partial package handling fee
- Injection fee
Updating Items Using Import
When updating existing items, any given values take precedence, and the corresponding old values are recalculated.
|Example||VAT%||Old price excl. VAT||Old price incl. VAT||New price excl. VAT||New price incl. VAT|
|Incl. VAT updated||20%||10||12||recalculated (20)||updated (24)|
|Excl. VAT updated||20%||10||12||updated (20)||recalculated (20)|
|Both updated||20%||10||12||updated (20)||updated (24)|
Purchase Price, Markup, Selling Price, and the Option to Disable Automatic Selling Price Calculation
Importing New Items (except Procedures)
Previously, all of these components had to be given when importing new items (except for procedures, which do not have purchase prices). Now the system can calculate the missing components based on the following rules.
Note: As shown in the VAT (sales tax) calculations section, purchase and selling prices also have VAT-exclusive and VAT-inclusive values. These are calculated accordingly.
|Case||Purchase price||Markup%||Selling price|
|All components given||10||50%||15|
|Selling price missing||10||50%||calculated (15)|
|Markup missing||10||calculated (50%)||15|
|Purchase price missing||calculated (10)||50%||15|
|Only purchase price||10||assumed zero (0%)||calculated (10)|
|Only markup||assumed zero (0)||50%||assumed zero (0)|
|Only selling price||assumed zero (0)||assumed zero (0%)||15|
|Nothing given||assumed zero (0)||assumed zero (0%)||assumed zero (0)|
Updating Items (except Procedures) with Import
The importer also includes the option to import the state of the item card option Disable automatic selling price calculation. It will have effect when items are updated using the importer and the purchase price is updated. It does not matter if the state of the option is changed with the update import or if it is inherited from the existing item.
When all or at least two of the three core pricing components (purchase price, markup, and selling price) are given for an item update, the disabling option does not have any effect, and the update import behaves similarly to a new item import.
The following table describes various cases in relation to the disabling option. Compared to the new import table above, we are updating the purchase price to 20, the markup to 25%, and the selling price to 30 for the cases. "Inherited" means that the data is inherited from the existing item we are updating.
|Case||Disable automatic selling price calculation||Purchase price||Markup%|
|Purchase given||NO||20||inherited (50%)||calculated (30)|
|Purchase given||YES||20||calculated (-25%)||inherited (15)|
|Markup given||NO||inherited (10)||25%||calculated (12,5)|
|Markup given||YES||inherited (10)||25%||calculated (12,5)|
|Selling given||NO||inherited (10)||calculated (150%)||30|
|Selling given||YES||inherited (10)||calculated (150%)||30|