Business management

How to keep a procurement register

How to keep a procurement register

Video: EXCEL TUTORIAL !! PURCHASE DATA REPORTS IN MS EXCEL || How to Entry Purchase in ms excel || 2024, July

Video: EXCEL TUTORIAL !! PURCHASE DATA REPORTS IN MS EXCEL || How to Entry Purchase in ms excel || 2024, July
Anonim

The procurement register is a special document that organizes the totality of the necessary information and information about the purchased products, customers, consumers and suppliers of products for the needs of an enterprise. The maintenance of the procurement register in accordance with the Budget Code of the Russian Federation is mandatory on all budgetary institutions available in the country, public authorities and its individual entities, local governments and other municipal organizations.

Image

Instruction manual

1

Open Article 73 of the Budget Code and read it carefully. You should be aware that the legislation does not provide for a clear established form of maintaining the procurement register, which is why it can be carried out both in a special book (procurement register) and on a computer, for example, in Excel.

2

Start the computer and open the appropriate program or open the book version of the magazine, where the data on purchases will be displayed. Create eight columns: 1) Date of purchase. 2) The method of procurement, the number and date of the protocol of the decision of the commission. 3) The number and date of the contract or agreement. 4) The name of the product (work, service, product). 5) Information on the purchase of products. It is necessary to include several subparagraphs in this paragraph, in particular 5.1 - units of measure, 5.2 - quantity, 5.3 - unit price and 5.4 - total purchase amount. 6) Name of supplier, TIN, legal address. 7) Settlement document. This item also needs to be divided into several. 7.1 - number, 7.2 - date, 7.3 - amount. 8) Cash flow on an accrual basis from the beginning of the year.

3

Start filling out your document properly in accordance with the points created in it. Indicate the date of purchase, for example, 01.01.2012. At the same time, you should be aware that the date of purchase will be the date indicated in the contract for the provision of relevant delivery, contracting or generally gratuitous services.

4

Indicate the method of procurement, for example, request for proposal, number and date of the decision protocol. Write down the name of the product, for example, tables, books, repairs, etc., as well as information about the purchase in accordance with the columns.

5

Insert the name of the supplier of goods or services. In this paragraph, it is necessary to record who delivers (IP, OJSC, etc.), the legal address of the supplier (in the case of IP - the place of residence) and TIN in accordance with the certificate or constituent documents.

6

Indicate the name of the settlement document, for example, a cashier's check.

Useful advice

Complete the procurement register for each individual supplier of goods or services.

procurement register form

Recommended