DESKTOP EDITION CLOUD EDITION SERVER EDITION GUIDES FORUM

Creating Retail Calculation


#1

Hello for the managers of this software …

I have one request regarding the entry of articles into the warehouse?

It is obligatory for us to calculate the prices of goods based on the invoice of the supplier.
It serves as a material proof of the way in which the prices of articles in the warehouse are determined and kept by the state authorities. Which means that on the basis of this calculation we are doing the entry of goods into the warehouse. At the same calculation it must be seen:
Supplier’s invoice number;
The date of issue of the invoice;
Supplier;
Like all purchased items from suppliers, for which we are pricing the pricing as attached (picture).
Without these calculations we can do input items in the warehouse, nor the same legally sell.
We are talking about Europe, namely about Balkan.



#2

I imagine this is most unlikely to be a feature of the software any time soon. The main purpose of the software is to provide a double-entry accounting service


#3

This almost has everything in the invoice, you just need to add some elements, as an optional one (example box discount).

Each item should have these calculations individually, and finally in total.
In retail this would not be called “Input Account”, but “Calculation price”.


#4

These two fields should be calculated reciprocally, if you enter%, then the absolute amount of the margin is calculated, and if you enter the absolute amount, then the% margin should be calculated.


#5

Manager already does most of this. The Average cost is calculated from all prior purchases, whether by payment voucher or purchase invoice. The drill-down history on the inventory item will show you the transactions involved.

The Purchase price field in the inventory item description is only an optional convenience. You can leave it blank, and Average cost will still be calculated correctly. If you buy the same item from different suppliers at different prices, you probably should leave it blank. If you buy the item at the same price all the time, filling in this field means less manual typing when entering purchase orders or purchase invoices.

The Sales price field is also optional, a time saver. Manager allows you to sell an item at any price you like.

It is not realistic to calculate your sales price based on a single purchase invoice. What if you have inventory on hand from several purchases, all with different prices? I doubt that your local law requires you to price each individual unit of an inventory item based on its specific purchase price. And Manager would not support that, because it does not distinguish among quantities of an inventory item. But if you are required to adjust sales prices based on cost, you can do that by checking the current average cost before entering a price.


#6

Yes, I agree with you but all this has to be seen on the Invoice or Calculation Price.
Like it is presented in the following picture.
These elements should be printed on paper.


#7

If we have one hundred Invoice Accounts, no matter how many items per account are, for each individual account we need to make a Cost Calculation. What is the purchase price per item and the selling price per item must be known on this Calculation Price.


#8


#9

For this reason I would have to buy an additional driver for the Calculation Price.


#10

So you seem to be saying that you must provide a trace back to the original purchase invoice for every individual item sold, not just a calculation of average cost of an item and average margin. Is that correct?

If so, can you provide a link to official documentation (in English) describing this requirement? I have never heard of such a requirement anywhere in the world. Manager provides no such capability, nor does any other accounting package I know about. There are other users in your country, but no one has ever asked for such a feature.


#11

Hello Tut, I apologize for the delay.

Yes, you have understood well.
So, for each input invoice, no matter how many items there are, we need to make the Calculation Price in this way. This same Calculation price must be printed and physically connected with the input invoice from the Supplier and entered into the folder with these invoices.
This is only relevant for purchase accounts, and for sales accounts it is not necessary, in the Menager software they are well placed.
The calculated Price Calculations, if they can not be realized for technical reasons, don’t have to have any reflection on the quantitative or financial situation in Menager.
It is important that you can choose items from the Warehouse Stock that exist there as sales items as well as that the Supplier of these items can be selected in our Menager business base.

Customers from my country didn’t ask for this because they use other software for calculation of the Price Calculation.

I was looking for an English version of this law, but unfortunately I didn’t find it.


#12

@Dado, if what you say is true, you would be required to maintain separate inventory items for each purchase of everything you sell. This might be workable for automobiles (to use one example from your illustrations). Sales volume is relatively low and cars are easily distinguishable from one another.

But what happens when you purchase 200 identical oil filters from three different distributors at six different prices over the span of a year? You would need to track each individual oil filter through your inventory system from receipt to sale and be able to know which exact one you sold to a customer so you can trace the sale back to the specific purchase invoice. The only way to do that, in Manager or any other accounting system, is to treat each purchase as a new inventory item.

After just a few years, the exact same oil filter will exist in your records under dozens of different inventory item numbers.

Now suppose that you sell 5,000 different automotive parts and have to do the same thing for each one. There would be no way you could find and manage inventory.

You say in your most recent post that this only applies to purchases. But your illustrations show both purchase and sales prices. And that is the only way you could calculate margin. So this entire scheme does not make sense to me.

If you cannot find a link to English-language regulations about this, can you at least find a summary of how it is supposed to work and translate it with translate.google.com? Post the translation.


#13
                                       **Article 10**

(1) For the goods purchased, a price calculation shall be made
for retail trade - Form KLM, which contains at least
will mock data:

  1. the name and seat of the trader,
  2. the name and the head office of the sales facility or other point of sale (departments, divisions, floors, etc.)
  3. the number of calculations,
  4. the date of making the calculation,
  5. the name and address of the supplier, ie the information that it is
    goods delivered from their own warehouse,
  6. name, number and date of the document under which the procurement is made
    the name, the number and the date of the internal document,
  7. Ordinary number,
  8. trade name of goods,
  9. unit of measure,
  10. quantity,
  11. factual price per unit of measure without VAT,
  12. factual value without VAT,
  13. dependent costs without VAT,
  14. purchase price per unit of measure without VAT,
  15. purchase, or own wholesale value without VAT,
  16. rate of difference in price,
  17. the amount of the difference in price,
  18. sales value of goods without VAT,
  19. VAT rate,
  20. the amount of VAT,
  21. retail value with VAT and
  22. retail price with VAT.


#14
                                                        **Article 15**

(1) For the purchase of goods, a price calculation shall be made
for wholesale - Form KLV, which contains at least one
The data will be:

  1. the name and seat of the trader,
  2. the name and head office of the selling facility or other point of sale,
  3. the number of calculations,
  4. the date of making the calculation,
  5. the name and address of the supplier,
  6. name, number and date of the document on the basis of which the procurement was performed,
  7. Ordinary number,
  8. trade name of goods,
  9. unit of measure,
  10. quantity,
  11. invoice price per unit of measure without VAT,
  12. invoice value of goods without VAT,
  13. dependent costs excluding VAT,
  14. purchase price per unit of measure without VAT,
  15. purchase price without VAT,
  16. rate of difference in price,
  17. the outcome of the difference in price,
  18. the selling value of a product or goods without VAT,
  19. Sales price without VAT.

(2) The responsible person is the accuracy of the calculation of prices
authenticates with signature.
(3) Price calculation shall be made prior to placing
goods in circulation.


#15

@Dado, this seems to have nothing to do with actual sales. This looks like a report listing purchase costs and planned sales prices. It also isn’t the same report you have been showing in your screen shots. So I am more confused than ever.

The translation you posted explains what is on form KLM. But it does not explain what the form is used for. Is there documentation explaining how this fits in your overall taxation or regulation scheme? In other words, who does this form go to and what happens as a result?


#16
                                           RULE BOOK

ABOUT THE FORM AND WAY OF RETURN OF THE TRADE BOOK CHAPTER I
BASIC PROVISIONS

                                                 Article 1.

This policy governs the form and methods of guiding
trade in trade: trading book for
Retail Trade (TKM), Trade Book for Trade
Services (TKU), Trade Book of Independent Entrepreneurs
for sale to registered persons (TKP), Commercial book
for commission services (TKK), Receiving - registration list
commodity goods - KP Form, Wholesale Price Calculation (KLV) and Retail Price Calculation (KLM) and the type of goods that can not be taken from a natural person in commission sales.

                                              Article 2

(1) A commercial book is a book in which records are kept
procurement and sale of goods and products (hereinafter referred to as: goods)
and records of trade services performed.

This is literally transmitted by the rulebook


#17

We are getting closer. But so far, Article 1 just says the policy applies to form KLM. It does say what the form is used for. Somewhere, that information must exist.


#18

Tut, these are prescribed forms of entry for goods in a warehouse purchased from suppliers, for retail and wholesale facilities.
Each input invoice delivered by the supplier must be processed in this way, through these forms, which have the name Calculation Price.


#19

(2) The trading book for retail trade is run at
The TKM Form, which is in Annex 1 of this Rulebook
and makes it an integral part.
(3) A trading book for commercial services is run on
Form TKU, and for commission services on the TKK Form, which
are contained in annexes 2 and 3 of this Regulation and constitute his
component.
(4) Traders who do not keep business records in compliance
with accounting regulations, recording of turnover
goods and products of sole entrepreneurs, when they do
sold to registered persons, carried out on the TKP Form,
which is contained in Attachment 4 of this Rulebook and is made by him
component.
(5) The trading book for commercial services shall be
separately for each type of commercial service.
(6) The price calculation for the wholemeal lot is made up
on the Form KLV, which is contained in Attachment 5 of this
and makes it an integral part.
(7) Price calculation for retail trade is made
on the KLM Form, which is found in Annex 6 of this
and makes it an integral part.
(8) Companies and entrepreneurs registered for
performing commercial and non-production activities (further
text: trader), when they perform the trade in goods and products
In short, they are obliged to lead the Commercial Book of Commerce on
a bit.
(9) The records referred to in paragraph 8 of this Article shall contain the data
on the purchase and sale of goods, or data on debt for
Owners produce and retail them.
(10) Independent entrepreneurs registered for performance
wholesale trade, manufacturing and handicraft
when they perform wholesale and retail sales
products to registered persons, if the business records are
which do not comply with the accounting regulations, are obligated
have been led by the Trade Book of Independent Social Workers for iro-
to the registered persons - Form TKP.
(11) The records referred to in paragraph 10 of this Article shall contain data
on the purchase and sale of goods, or data on debt for
own products and their sale to registered li-
cima.
(12) Receipt - registration sheet of commissions -
The KP template is contained in Annex 7 of this Rulebook and makes
its integral part.


#20
                     **Article 3**

(1) Dealers keep relevant trading books and others
Business records for each sales object, business
unit and other sales point.
(2) A trader who sells or sells within a retail store
The sales point has more departments or outlets
The trade book is conducted separately for each department or sales point.