Overview
Sellercloud allows you to add Extra Costs to Purchase Orders along with common overhead costs which usually include expenses on purchased components (PO Subtotal), Shipping Costs, Taxes, and Other Total expenses.
Overhead PO Costs
- To correct PO costs on each component price, refer to the PO’s Items toolbox, and make the appropriate changes.
- To add Shipping Costs, Tax Amount, or Other Total expenses over the Purchase Order, refer to the respective PO’s home page, the Total panel.
- In the upper right, click Edit.
- Enter the respective values, and click Save.
Extra PO Costs
You can add an Extra Cost Per Unit to purchased items either manually or via a file import. This method allows you to apply a unique extra cost value to each PO item.
Add an Extra Cost Manually
- Go to Purchasing > Manage POs.
- Select the Purchase Order you want to add extra costs to.
- In the upper right, click Edit.
- Click the Toolbox, and select Extra Costs.
- On the Extra Costs panel, click the plus icon.
- In the Add New Extra Cost dialog box, specify a brief explanation of the extra cost added, the Cost value, and the type of cost distribution to be applied to PO items.
- Click Save.
- Save the changes.
Add an Extra Cost via a File Import
- Go to the Items panel that is on the Extra Costs PO’s page.
- In the upper right, click Edit.
- Click the Upload Products icon.
- Select the appropriate file from your computer, and click Save.
- Alternatively, to save a template prior to file upload, click Download Template. Populate the respective columns. Upload the saved file.
- Once processed, the Extra Cost Per Unit column is automatically completed.
Divide Extra Cost Automatically
PO shipping, taxes, and other third-party costs can be averaged and divided into an item’s cost automatically as long as they are entered on a PO level (and not per unit). This method allows you to apply a PO based extra cost value which will be divided between the items on the PO.
Example: If a product costs $50.00 and shipping costs $5.00, the average cost on the product’s Purchasing page (Product > Toolbox > Purchasing) will be $55.00. If you ordered 2 units with a total PO shipping cost of $5.00, the average cost will be divided between the units ordered, producing an average cost of $52.50.
Product cost(x) + Shipping cost / Number of units
There are four distribution-type methods when adding extra costs to a PO. Refer to the table below for a detailed description of each one.
DISTRIBUTION TYPE | DEFINITION |
Normal | The extra cost will be equally divided among the units ordered |
Item Cost Based | The extra cost will be distributed in proportion to the items’ costs, and then divided per unit of each item |
Weight Based | The extra cost will be distributed in proportion to the items’ weights, and then divided per unit of each item. Note: All items on the PO must have their product weight entered, else the calculation will revert back to dividing the cost equally. |
Volume Based | The values from the Product Length/Width/Height fields are used for this calculation. Volume = L * W * H. Note: All items on the PO must have their product Length/Width/Height fields populated, else the calculation will revert back to dividing the cost equally. |
Convert PO Cost into Different Currency
When you purchase from international companies, you may need to purchase in the local currency. Sellercloud POs support international currency and let you define the rate of conversion on the PO. Learn more about selling on international marketplaces.
- Go to Purchasing > Manage POs.
- Select the appropriate Purchase Order.
- Go to the General panel that is on the PO’s home page.
- In the upper right, click Edit.
- Click the Currency field, and select the appropriate monetary unit.
- In the Rate To US$ field, enter the requested conversion rate in respect to the US dollar.
- Save the changes.
- The product’s cost will be entered in the selected international currency, but upon receipt it will be converted based on the conversion rate set here.
Add Free-Cost Items to PO
If a Vendor offers you to purchase the n-th item for free, you are ought to add that item to a PO as follows.
- Open the appropriate Purchase Order. Alternatively, create a new one.
- Add all requested items with the relevant cost indicated per each product.
- Add a free-cost product to the PO scope as a separate line with a zero cost indicated.
Related Client Settings
CLIENT SETTING | DEFINITION |
Allow free PO Items to affect product cost | Enable to include zero-cost PO items into the calculation for all product cost fields. |
Enable currency symbol for PO | Allows converting PO’s items cost from a different currency into US dollars. |
Enable PO Custom Extra Cost per Unit | Allows adding an extra cost to each PO unit. |
Consider PO Extra Costs When Calculating Product Costs | Averages extra PO cost into product’s cost in order to give an accurate Profit & Loss Report. Once enabled, the Extra Cost Per Unit column will appear per each line item in a PO. |
Do Not Include Third Party Shipping In PO Grand Total | Excludes Extra Costs in the PO Grand Total. |
Divide PO Item Extra Cost using: | Shipping and other costs are averaged and divided into the item’s cost automatically. The method of distributing PO extra costs per unit is based on the value chosen in this setting. |
Understanding PO extra costs
You can add extra costs to a purchase order. Extra costs include shipping or third-party costs that are not included in the price of the item. These costs are often not billed to a third party or the vendor.
Enabling Consider PO Extra Costs when Calculating Product Costs in the Client Settings will average these costs into the product’s cost to give an accurate profit and loss report. An extra column will display next to each line item in the PO: Extra Cost Per Unit.
Custom extra costs
Small order item fee
Shipping and other costs
- Equally— If the product cost is $50.00 and shipping cost is $5.00, the average cost on the product’s Purchasing page will be $55.00. If you ordered 2 units with a total PO shipping cost of $5.00, the average cost will be divided among the units ordered, resulting in an average cost of $52.50
- Cost Based— If there are different products in the PO with varying costs, the extra costs will be distributed in proportion to the items’ cost, and then divided per unit of each item
- Weight Based— If there are different products in the PO with varying weights, the extra costs will be distributed in proportion to the items’ weight, and then divided per unit of each item. Note: All items on the PO must have their product weight entered, else the calculation will revert back to diving the cost equally.
- Volume Based— If there are different products in the PO with varying volume, the extra costs will be distributed in proportion to that, and then divided per unit of each item. Note: The values from the Product Length/Width/Height fields are used for this calculation and must be populated. Volume = L * W * H.
You have the option to exclude shipping costs in the PO Grand Total. This is helpful if you are paying a third party for shipping. This is controlled by enabling Do not include Third party shipping in PO Grand Total in the Client Settings.
Converting currency rates on POs
When purchasing from international companies, you may need to purchase in the local currency. Sellercloud POs support international currency and let you define the rate of conversion on the PO. Learn more about selling on international marketplaces.
- Go to Client Settings > Enable currency symbol for PO.
- Open a PO > Choose the Currency > Enter the Rate to US$ and Rate From US$.
Managing free items in a PO
Vendors may offer a deal for free items, such as buy 10 get 2 free. When the purchaser sends the PO to the vendor, they create two different lines for the same item – one at full price and one free.
By default, Sellercloud will not factor items priced at zero dollars into its Cost calculations, but you can enable Allow Free PO Items to affect product cost in Client Settings to include these items.