Price Variances

Price Variances can occur when goods are received into stock with estimated values. You may not know at the time of placing a Purchase Order exactly how much the extra costs such as transport, customs duties, port charges, taxes etc. will be: usually this will be when importing goods. In some cases, the exact costs of the goods themselves will not be known. You therefore need to estimate these costs when you issue the Purchase Order. When you receive the goods into stock, you still may not know how much they will be, so the goods will be signed into stock using the estimated figures taken from the Purchase Order. When the Purchase Invoice arrives, there may be differences between the actual prices (on the Invoice) and what you estimated (received into stock and posted to the various Accruals Accounts). Any such differences (Price Variances) between the Purchase Invoice and the Goods Receipt will be posted to Price Variance Accounts, from the Purchase Invoice or from the Goods Receipt, whichever arrives last. These differences will then be shown in the Profit & Loss report together with the cost of goods sold. This feature allows postings to the various Accruals Accounts from the Purchase Invoice and the Goods Receipt to balance, because the Variances are kept separate.

Follow these steps to configure the Price Variances feature:

  1. Switch on the Post Price Variance option on the 'Stock' card of the Account Usage Stock setting.

  2. On the 'Variances' card of the same setting, specify Variance Accounts for Purchase Accruals, Freight, Customs and each of the Extra Costs:

  3. You can define a separate Purchase Price Variance Account in an Item Group record, if the Item Group is not to use the default set in step 2 above. You must also check the Use Item Groups for Cost Accounts option in the Cost Accounting setting if you want to use the Variance Accounts in Item Groups.

  4. Switch on the Transfer Each Item Separately option in the Purchase Invoice Settings setting in the Purchase Ledger. Do not switch on the Always use Full Qty from Purch. Ord. option in the same setting.

  5. If you need to account for Variances in Customs, Freight and the other Extra Costs, switch on the Extra Costs Invoices from Different Suppliers option in the Purchase Order Settings setting. If you do not switch on this option, you will only be able to account for Variances in Item prices.

  6. If it is likely that you will need to enter Purchase Invoices before you have received any goods, switch on the Purchase Invoices before Goods Receipt option in the Stock Settings setting. This will cause the Invoice before Goods Receipt box to be checked by default in new Purchase Orders. If you are not using the Purchase Invoices before Goods Receipt option, you can switch on the Invoice before Goods Receipt option in individual Purchase Orders if necessary.
Having completed the configuration work described above, you can now use the Price Variances feature, as follows:
  1. Start by entering a Purchase Order in the normal way. If you do not know the costs of the Item, Freight, Customs and/or any of the Extra Costs, you will need to estimate them so that you can print and issue the Purchase Order. Note that the Freight, Customs and Extra Costs are not included in the Purchase Order total, because it is possible that these will not be paid to the Supplier quoted in the Purchase Order but to a transport company or government revenue department.

  1. When the goods arrive, open the Purchase Order and select 'Create Goods Receipt' from the Operations menu. All prices will be copied from the Purchase Order to the Goods Receipt, and this time they are included in the total. Usually, the documentation accompanying the goods will not contain any pricing information, and warehouse staff may only be able to enter quantities and not prices. However, if the pricing information is known, you can update the figures in the Goods Receipt if necessary.

  1. When you approve and save the Goods Receipt, a Nominal Ledger Transaction will be created, debiting the Stock Account and crediting the appropriate Accrual Accounts (in the example, the Purchase, Customs, Freight and Extra Cost 1 and 2 Accrual Accounts) as normal:

    The posting to the Stock Account includes the Extra Costs. When the Item is sold the value of the Cost of Sales posting will include the Extra Costs if your Cost Model is Weighted Average, FIFO or LIFO (or Cost Price, if that is being updated automatically to the Weighted Average or Last Purchase Cost).
  1. When the Purchase Invoice arrives, return to the Purchase Order and select 'Create Purchase Invoice' from the Operations menu. Because you are using the Extra Costs Invoices from Different Suppliers option in the Purchase Order Settings setting, the Purchase Invoice is not created immediately. Instead, the following dialogue box opens:

    Proceed as follows, depending on what has been included in the paper Purchase Invoice:

    • If the Purchase Invoice includes the Item(s) on the Purchase Order, leave the Supplier field empty (the Supplier will be taken from the Purchase Order). If the Invoice includes any of the Extra Costs as well, leave the Price box checked and check other boxes as appropriate. Then, click the [Run] button.

    • If the Purchase Invoice does not include the Item(s) on the Purchase Order (i.e. it is for one or more of the Extra Costs only), specify the Supplier using 'Paste Special', specify the Extra Costs boxes as appropriate, remove the check from the Price box and click the [Run] button.

    Since it is possible that you will receive separate Invoices for the Item(s) and the Extra Costs, you can return to the Purchase Order to create the various Invoices at any time. You will not be able to create more than one Invoice for the Item(s).

    The example illustrated below shows an Invoice for the Items and the Freight:

    The values of the Item and of the Freight are taken from the Purchase Order. The Purchase Accruals Account for the Item is chosen in the usual way for the Transfer Each Item Separately option (please refer to the description of the 'Create Purchase Invoice' function for details). The Freight Accruals Account is taken from the 'Account Usage Stock' setting.
  1. If the amounts on the printed Purchase Invoice are different