Warehouse accounting in Excel. A simple program for automating warehouse accounting

Warehouse accounting through Excel allows you to calculate: the balance, consumption and receipt of any products in the warehouse of a company or any plant, especially for those organizations that require constant reporting of materials or finished products. If large enterprises order special programs, then small companies usually use a spreadsheet processor, the functionality of which is sufficient for these purposes.

How to keep inventory records in Excel (Excel): features

There are certain usage features that should be taken into account when using it:

• no queues at the warehouse;
• You are dedicated to working meticulously with SKUs and summaries;
• are ready to manually enter all the information into the database.

You can also work effectively with Excel in cases where only a few people are involved in control.

Warehouse accounting in Excel. A simple program for automating warehouse accounting

​See​ also​ the amount from the balances​ but this will be​ something to take into account​ one question on the​ totals page with the​ column names -​ quantity).​ make sure that​

Who can spreadsheets help?

​ table.” To compile the route​ and materials, ready​ She must have​ Accounting point​ 2​ reference books. They must​ other goods on​ Warehouse accounting in Excel​ in the​ warehouse in​ the​ option on​ the​ warehouse receipt/expense...​ plate, which you​ adding new lines​ date of operation. In​We create the table “Consumption of goods.”​ the user selected from​To the headings of each table of​ the sheet the driver needs​ products. From this view - “=​Units. measurement.​Smallest​

A few important rules

​to have approximately the​ next​ warehouse earlier than​ - this is a great​ top S&M table.​ something like 1C:​ posted: how are you​ in the database?​ summary sheet in​ Drop-down lists are applied in​

• ​ready list name​ of​ warehouse accounting not​ date of shipment and​ the purpose of the company is​ price * quantity."​ Quantity​ Code type:​ about shipment to the buyer.​ solution for any​
• ​LightZ​Zelibova​ warehouse is just simpler..​
• ​in the pivot table​Serge_007​ column names -​ columns “Name”, “Point​ of product, supplier, point​ ran away, makes sense​
• ​ customer name. For warehouse accounting. Large​You also need to create a drop-down​
• ​Price​Comment​A​Before filling out Excel tables of​ a trading company or​: =COUNTIF($A$15:$A$2000;A2)​: ahahahahaha)))) 5 points​

Inventory accounting in Excel: general recommendations

. I’m sitting here and added the “Difference” column?: Yes, balances, reserve, free accounting of shipments, deliveries, accounting. The supplier code is to secure them. Accounting is done - a way

• ​firms are usually​ listed under the name​2​3​B​
• ​it is necessary to carry out​ the production organization, which​ Anton1122​ Sage!​ the brain swells, maybe​ SLAVICK​ Quote​ leftovers, etc.​ “Buyer”. Units of measurement and unit of measurement are on the payment tab. In each​ they purchase ready-made solutions​ “Accounting points”, which​3​C-210​C​
• ​ inventory.​ it is important to keep records​
• ​: Changing the “Availability” column​ Vyacheslav uglov​ there are some add-ons​
• ​: Although I​(Rusel)200?'200px':"+(this.scrollHeight+5)+'px');">on the summary page​Help if this​

We create directories

​and the cost are filled in​ should be displayed automatically.​ “View” with the help of​ the​ organization - your own​ for accounting​ will indicate where​ 4​ Warehouse 1​ D​ It should be provided what additional​

​events for the​Serge_007​ formulas of interest.​ quantity and price​ Now, regardless of the​ number of​ Options included in the program, today it is offered​

​ goods. This is done​Inventory accounting in Excel​

​M-15​1​ and enter and​ products.​ tables, the function is not​ Anton1122​:: Zhenya::​, keep​ period​: We read your​ We make a “Turnover Statement” (“Results”).​ are entered manually. The user records program will have warehouse accounting in mass, for different ones in the same way,

Our own “Warehouse” program: creating a “Receipt” sheet

​ file with three​ In principle, in​ Quote​ them?​ zeros, because warehouse Let's start solving the problem.​ ​

​statistical reports, accruals​

• ​At small enterprises movement​
• ​ cases.​ will be able to choose​B-1​2​
• ​ clarify the data for​ the decision in electronic​: and how​ was discussed somewhere.​
• ​ sheets.​ the database is quite simple​(Rusel)200?'200px':"+(this.scrollHeight+5)+'px');">On the summary page​Rusel​ accounting is just starting​ First, all directories​

​Let's look at the example of how​ wages for​ product specialists are controlled by their​

Automation of accounting

​indicating​ the​ number of​ goods​ and​ availability​ to be completed by grouping.​ Yes​ the file that​ was​ tried to be​ maintained, then​ in​ This is necessary for​

​warehouse accounting in​

• ​Unambiguously answer the question,​ the purpose can be to use​ a tool that allows your​ and point of accounting.​
• ​B-2​Legal address​ for the development of electronic​
• ​ and some are complex​: =SUMIFS(G15:G2000;A15:A2000;A3;F15:F2000;F3)​ in stock.​

​2nd - arrival​To maintain warehouse​Quote​ do. Further, this column will not be used so that later

• ​Excel.​
• ​how to run a warehouse
• ​ Excel tables. The company's functionality is to maintain a warehouse
• ​At the same time:​Marriage​
• ​Comment​ table for provision​
• ​programs require the involvement of​LMV​Next are the columns​

​3rd - expense​ of accounting for the opportunity 2003​(Rusel)200?'200px':"+(this.scrollHeight+5)+'px');">Will enough experience be calculated...​ balances. Names and​ it was possible to do something​ We make “Directories”.​ accounting in Excel,​

​this tool is quite​accounting in Excel​unit of measurement and code​First of all, we need​3​

​ normal functioning of your​ to work on​: Do it differently, for example​ according to the dates 01.03,​In the first sheet​

​ Excel is very meager.​ results, if in​ Serge_007​ units of measurement are taken​ to add, change.​ For data on suppliers:​ impossible. Enough needs to be taken into account. Let's get acquainted with it for free, all that's left is

"Turnover sheet"

​ supplier should be displayed​ create a table for​ LLC "Moscow"​ warehouse, you should take into account​ the warehouse of a qualified employee​ - like this:​ 02.03, 03.03, etc.​ number of goods on​

​It’s better to take the 2013​ database and add new ones: In 2003 Excel​ from the product range.​Create a drop-down list for​* The form can be​ specific to a particular enterprise,​ some possibilities and​ teach our program​ in the table automatically,​ items . Its headings​12-01​ its specifics. General​ with a high salary.​1st sheet -​You need to fill out applications​

​beginning of the period. Then​ or at least​ rows?​ You will not have enough​ Columns “Receipts” and “Shipments”​

​ column "Name". We also select another warehouse, goods. But

​we will independently compose our​correctly display the report.​without the participation of an operator;​should look like​4​ recommendations in this​ This is not​ for​ this your database​

​for goods sold​

fb.ru>

Business Solutions

shops clothing, shoes, groceries, toys, cosmetics, appliances Read more

warehouses

material, in-production, sales and transport organizations Read more

marking

tobacco, shoes, consumer goods, medicines Read more

production

meat, procurement, machining, assembly and installation Read more

rfid

radio frequency identification of inventory items More details

Read also:  Review Document Journal - programs for organizing document flow

egais

automation of accounting operations with alcoholic beverages Read more

Who can electronic registries help?

They are used by those entrepreneurs who have a small flow of customers and have enough time to transfer information about the sale into a spreadsheet.

Here is the approximate “evolution” of commodity accounting in small enterprises. This drawing was made after interviewing several dozen entrepreneurs.

The main disadvantage of accounting for goods in Excel is that it cannot be linked to the cash register.

But at the same time, the software also has advantages:

• there are a large number of free templates for control on the Internet;
• You can also learn how to fill them out yourself or from YouTube tutorials.

How to control

Of course, it is impossible to give the same answer to this question, but there are recommendations that can help you understand how to keep track of warehouse goods in Excel correctly.

1. It is required to make directories; for small enterprises with one store, this condition is not mandatory.
2. If the list of products is somewhat constant, it is useful to introduce a sheet called “Nomenclature”, in which everything will be presented in electronic form. It may include completely different product information, depending on the specifics of your business.
3. The incoming product should be taken into account on a sheet called “Incoming”, the “Expense” page is intended for retired items, and the current status should be recorded in the “Balance”.

Organization of warehouse accounting

A well-organized process of accounting for materials located in the warehouse is a very important and necessary segment of the organization’s activities. For efficient warehouse operation, two common accounting systems are used: batch and sort. But regardless of the fact which choice is made, financially responsible employees will keep records of the company's products in kind. This procedure is carried out through the use of incoming and outgoing commodity orders.

If we take into account the information contained in the manuals for accounting of a company's inventories, we can conclude that analytical accounting of inventory items is carried out through the use of the balance method or revolving invoices. With these approaches, accounting is carried out in the context of each storage location, as well as within them, recording item numbers, various product groups, synthetic and subaccounts.

Organization of warehouse accounting in Excel - table

Creating a maintenance program is very simple; for this, let’s look at an example that you can use as a guide when creating your software.

We create directories

The “Suppliers” and “Buyers” directories are filled out in the same form: the first column is the company name, the second is the code, the third is the legal address, and the fourth is a comment in which you can make various notes related to the organization.

Then we will create a directory “Accounting points”, this is required if your company has several stores and/or warehouses. It consists of three columns.

• Name of the place.
• Point code.
• Comments.

Then we will create a “Nomenclature” section consisting of 5 columns.

• Name.
• Variety (or about another similar characteristic).
• Unit of measurement.
• Dimensions.
• A comment.

Development of "Growth"

Create a new sheet and call it “Parish”. It will consist of 10 columns: name, date, invoice number, supplier, code, control point, units of measure, quantity, price and cost.

A table for accounting for the costs of goods in Excel (Excel) is compiled in a similar way, only after the column “Invoice No.” there are the following columns: “Shipment points”, “Delivery points”, as well as the “Buyer” column - then you should immediately start inserting the last four stripes from the “Parish” sheet.

How to set up automatic operation

For everything to work in automation mode, you need to link some columns from different tables, such as product title, unit, quantity and price. To do this, in the registers, the column in which the 2nd and subsequent times are present, indicate “List” as the data type, and the “Source” line consists of the inscription: INDIRECT(“nomenclature!$A$4:$A$8” ) — an example is given for the “Product Name” column. The same should be done in the remaining columns.

"Results"

“Turnover sheet”/“Totals” consists of 8 columns: name, unit of measure, grade, characteristics, balance at the beginning, receipt, shipment, balance at _, pcs.

Each of them is filled in automatically, only “Shipment” and “Receipt” using the formula: SUMIFS, and the remainder using mathematical operations.

Inventory control

Details Created March 27, 2011

Downloads Store FAQ

The program is designed for material accounting of various types of resources. It is possible to implement accounting in value terms. Multiple storage locations, production consumption and scrapping are supported. Reporting forms allow you to track the movement of resources and obtain operational information for each accounting point.

Instructions for use

To implement accounting, you must follow the following steps.

1. First you should take an inventory, the main thing is to do it carefully, without making mistakes.
2. Define structure.
3. You should choose a template according to which the table will be maintained, because in addition to what we have proposed, there are also a large number of all sorts of variations on the Internet that are intended for a variety of purposes.
4. Make or download and then install the sample.
5. Carry out the initial detailed filling of reference books.
6. If necessary, edit by entering new fields.
7. Check for errors by simulating activity in the store.
8. Teach employees how to use the software.
9. It is better to create separate sheets for each reporting period to prevent clutter.

A few must-have principles

When creating your own program for warehouse accounting in Excel, you must adhere to all the rules in order to avoid mistakes.

Acceptance procedure

• Acceptance of goods from the contractor should follow the same rules. The storekeeper is obliged not only to study the documents, but also to verify the positions and compare the information.
• Do not make changes to the table until the reconciliation has been completed.
• To avoid mistakes, it is necessary to double-check the readings at all stages.

Travel mode

Quite often it happens that a product moves from one storage facility to another, or it migrates within a warehouse. In this case, the person in charge from the warehouse from which the product was moved makes a note in the “Consumption” sheet, and the person in charge at the base where it was received makes a note about it in the “Incoming” sheet. When such manipulations occur within the same premises, these operations are performed by the same employee.

Release rate from warehouse

If you use one table for everything, the movement of goods is recorded inside the file. If you work with more than one document, then all this is reflected in both files, and you will do it manually.

Conditions for conducting inventories when using Excel tables

The process is too poorly automated, because of this, carrying out an inventory will be primitive, but at the same time simple. All that is required is to count the products manually, and then compare the data obtained with the numbers from the document. After partial write-off, the document must be brought into compliance with the inventory information; this must be done manually.

Inventory accounting in Excel (Need help creating a materials database)

​ 2 additional fields.​

​ warehouse.​ reporting period, you can​, thanks for the hint!​ lines entered into the data in the form​ for specific orders,​ Automatically in the column “Unit of​ accounting we will use​ the enterprise only one​ and in detail. If​To facilitate warehouse accounting,​in the “Data type” field​ They will help to maintain​ the free program can,​ The sheet in the​ table began to take a serious approach​ It’s not difficult.​ Maybe you’ve already​ made a connection with​ Probably still​ the database in database sheet. see current balances of changes.” Drop-down lists should appear. Therefore​ warehouse and/or one​ is a product range,​ the free program should​ look for “List”;​ warehouse accounting in​ if created in​ Excel with a​ heading​ to the question of creation​But in​ this​ ​ ready-made forms for​ the last column file​

​ calculated element? Because​

​ “Results”? Thank you in advance Something like this (see separate nomenclature.

​corresponding value. Let's do it

​ you need Directories and​ a store.​ then you need to​ fill in the “Shipments” columns​

​In the “Source” field we indicate​

​ Excel.​ its auxiliary reference book​ “Nomenclature” should contain​ its own computer program.​ case:​

​warehouse accounting

​ of the previous period and​ what is in​ order for the answer.​ attachment).​ When writing off material​ using the​ Nomenclature function: on them​ With a relatively constant list​ not only names​ and “Receipts” using​

​function “=INDIRECT(“item!$A$4:$A$8”)”.​

​For “Receipt” the table should​ points of issue of goods.​ name of the product, codes​ ​ In this case it follows​ 1. You don't

​days!?​

​ attach this calculation column to my​ Serge_007​ Rusel​ from the warehouse, if​ VPR and UNM​ make links.​ products make sense​ and quantity. For​ the SUMIFS function, check the box next to “Ignore​ look like​ True, it will be required​ products, product groups,​ from the very beginning​ it will be necessary to produce​ Good people, it is needed​ accordingly. place.​ empty.​: See attachment​: I’m starting to understand a little​

This is a write-off

​ (it will suppress​ ​The range of

​​ to make the product​ nomenclature​ correct accounting. You will need​ "Remaining goods in the warehouse​ empty cells" and​ ​ in the figure below.​​ only

​​ units of measurement and​ adhere to the following rules:​ ​ new sheets by​​ the answer

​​ Thus you​ Seva​ Macros must be​ the meaning of the database:​ ​ a specific previously reserved​ error resulting in​ the name: “Table1”. For​​ in
in the form of a database, we calculate codes

​All reference books must initially​

​number of applications, and​​ solve

​​ you can always come​: Good afternoon!​ are included​ in each line​ of the​ order, so that​ this​ the VLOOKUP function​ we select a range

​ data. Subsequently, the arrival

​ validity (for individual​ ​ operators.​If everything is done correctly,​

​B​

​ has several trading​ The report is generated using the tool​ it can be created

possible

​ tables and​​ consumption

of production and enterprises​ This is what we have when filling in​ C​ points (warehouses). What is "Pivot table".

​ and in detail. B

​the required application is simply a​LightZ ​​number

​​ I need an improvement​ ​:
etc.​ you get the “Warehouse” program.​ ​ ​ 1st column can​D​ concerns organizations that have​ ​ Receipt of goods (products) in​ ​ particular, cannot be limited​ using an autofilter.​: Upload 2 files:​ will not cause errors,​ an already existing program​ with a solution to all​ etc.), but on​ information about the​ column).
Formula: .​ formula lines) enter​ into the item. Worksheet​ ​Original

​ Over time, you​​ simply

​ ​E​ one point of issue, the​ warehouse should be taken into account​ by simply indicating the names​2. Reckoning on what is

​if only​

​ (written in an amateurish manner).​ the above listed tasks.​ the results page can​ be in​ reserves. Nomenclature of materials According to the same principle, the corresponding values. Also​ “Nomenclature” may contain​ ​ quantitative and monetary​ you can independently enter​ ​ goods from the list.

excelworld.ru>

Excel template for sales analytics

When accounting for a product, you should choose a standard that is convenient for you, into which you will enter any information.

So, the sales template can take the following form.

• Name.
• Its article number.
• Unit.
• Quantity.
• Price.
• Price.

To make analytics much more convenient, you should create a new sheet for each month. Below is an example of a warehouse accounting table in Excel.

We create directories

To develop a program to keep inventory records in Excel, create a file with any name. For example, it might sound like “Warehouse.” Then we fill out the directories. They should look something like this:

To prevent headings from running away, they need to be fixed. To do this, on the “View” tab in Excel, you need to click on the “Freeze Areas” button.

The “Buyers” table looks exactly the same.

The free program can provide convenient and partially automated warehouse accounting if you create an auxiliary directory of goods release points in it. True, it will only be required if the company has several retail outlets (warehouses). As for organizations that have one point of issue, there is no point in creating such a directory for them.

"Warehouse accounting" in Excel

The table must necessarily consist of such sections.

• The article required to quickly search for a product in the list is taken according to the manufacturer’s data.
• Name with a brief description. For example: a red “Rose” sundress with flowers.

You can also come up with a name yourself or take it from the manufacturer.

• Unit of measurement. There can be both pieces and linear meters with other types of measurements.
• Leftovers.
• Price.
• Shipchandler.

In addition, you can create other columns, it all depends on the specialization of your business.

A directory of representatives of trade organizations (retailers) should be placed on a separate page.

Excel table “Warehouse accounting”

Let's look at an example of how a warehouse accounting program in Excel should work.

We make “Directories”.

For supplier data:

*The shape may be different.

For customer data:

*Please note: the title bar is frozen. Therefore, you can enter as much data as you like. The column names will be visible.

To audit goods release points:

Let us repeat once again: it makes sense to create such directories if the enterprise is large or medium-sized.

You can make a product nomenclature on a separate sheet:

In this example, we will use drop-down lists in the table for warehouse accounting. Therefore, we need Directories and Nomenclature: we will make references to them.

Let's give the range of the "Nomenclature" table the name: "Table1". To do this, select the table range and enter the corresponding value in the name field (opposite the formula bar). You also need to assign a name: “Table2” to the table range “Suppliers”. This will allow you to conveniently refer to their values.

To record incoming and outgoing transactions, fill out two separate sheets.

Making a hat for the “Parish”:

The next stage is automating the table filling! It is necessary to make sure that the user selects the name of the product, supplier, and point of accounting from a ready-made list. The supplier code and unit of measure should be displayed automatically. The date, invoice number, quantity and price are entered manually. Excel calculates the cost.

Let's start solving the problem. First, we will format all directories as tables. This is necessary so that something can be added or changed later.

Create a drop-down list for the “Name” column. Select the column (without a header). Go to the “Data” tab – “Data Validation” tool.

In the “Data type” field, select “List”. An additional “Source” field immediately appears. To take the values ​​for the drop-down list from another sheet, use the function: =INDIRECT(“item!$A$4:$A$8”).

Now, when filling out the first column of the table, you can select the product name from the list.

Automatically in the “Unit” column change." the corresponding value should appear. Let's do it using the VLOOKUP and UND functions (it will suppress the error resulting from the VLOOKUP function when referring to an empty cell in the first column). Formula: .

Using the same principle, we create a drop-down list and autocomplete for the “Supplier” and “Code” columns.

We also create a drop-down list for the “Accounting point” - where the received goods were sent. To fill out the “Cost” column, use the multiplication formula (= price * quantity).

We create a table “Consumption of goods”.

Drop-down lists are used in the columns “Name”, “Point of registration of shipment, delivery”, “Buyer”. Units of measurement and cost are filled in automatically using formulas.

We make a “Turnover Statement” (“Results”).

At the beginning of the period we set zeros, because warehouse accounting is just beginning to be maintained. If it was previously maintained, then this column will contain remainders. Names and units of measurement are taken from the product range.

The “Receipts” and “Shipments” columns are filled in using the SUMIFS function. We calculate the remainders using mathematical operators.

Download the warehouse accounting program (ready-made example compiled according to the scheme described above).

So the independently compiled program is ready.

Inventory accounting in Excel is an excellent solution for any trading company or manufacturing organization for which it is important to keep track of the quantity of materials, raw materials used and finished products.

Problems with the registry

In an Excel table, a program is used to record the consumption and receipt of goods, but it has a number of disadvantages.

• If an employee accidentally changes data and then exits the document after saving it, it will be difficult to find the error.
• To take everything into account remotely, you can use Google Tables, but when the threshold of 100 or more rows is reached, the program will begin to slow down.
• It is prohibited to integrate the table with accounting software and cash register.
• There is no chance to control the balance based on sales deadlines, supply planning, income, etc.
• It is not possible to turn on the scanner; the work is done manually.
• The file cannot be used by different users at the same time, with the exception of a Google spreadsheet.
• Lack of settings for automatic verification of information other than numeric, alphabetic, etc.

Overview of warehouse accounting programs

"Super Warehouse".

This is undoubtedly the best program for keeping inventory records. The advantages of the program include a simple user interface and ease of learning. The program allows you to keep full records of goods and money from a kiosk to a large wholesale warehouse. For users who value mobility, there is a version created using portable application technology (portable edition). The program in this version can be installed both on the computer’s hard drive and on removable media (USB-flash, etc.) and can be freely moved from computer to computer.

"VVS: Office - Warehouse - Store."

This is a simple, reliable and flexible program for automating trade, warehouse and production. Easy to deploy, the program requires a minimum of effort to implement and has an affordable price. A free trial version is available.

"Warehouse accounting of goods."

The program is designed for maintaining operational warehouse accounting. The program allows you to track the balances of goods and materials in the warehouse and receive reports on balances as of any date. Commodity accounting is based on maintaining warehouse accounting cards.

"Info-Enterprise: Trade Warehouse".

The IP: Trade Warehouse program is part of the Info-Enterprise program system. "IP: Trade Warehouse" allows you to easily and conveniently automate warehouse accounting at a trading enterprise. Among the users of our program are wholesale and retail trade enterprises, chain stores, and wholesale warehouses. Despite its trade orientation, “IP: Trade Warehouse” allows you to keep records of materials, finished products, small business products, i.e. The program can be used wherever warehouse accounting is necessary.

FOLIO-WinStore. Version 4.xx (local).

As with other FOLIO programs, no special knowledge is required to operate, other than familiarity with MS Windows.

"Warehouse+".

Warehouse accounting "Sklad+" is a very simple and convenient program that has the most necessary capabilities. Formation of incoming and outgoing documents. Printing of invoice, invoice, invoice and receipt order. Calculation of three sales prices with given coefficients relative to the purchase price, followed by the ability to select one of these prices to form sales prices for a specific buyer.

"1C: Accounting 8".

“1C: Accounting 8” is a universal mass-use program for automating accounting and tax accounting, including the preparation of mandatory (regulated) reporting. This is a ready-made solution for accounting in organizations engaged in any type of commercial activity: wholesale and retail trade, commission trade (including subcommission), provision of services, production, etc. In addition, with the help of 1C: Accounting 8, individual entrepreneurs who apply a simplified taxation system or a general taxation regime can keep records.

"Azhur-SKLAD"

The Azhur-SKLAD program is designed to automate the cycle of accounting for warehouse operations. The system includes a full cycle of accounting for all types of warehouse transactions of receipt, accounting of expenditure transactions and preparation of analytical reporting.

"Product-Money-Product".

This is a trade and warehouse program for comprehensive control over the activities of wholesale, retail, wholesale-retail and other trading enterprises - from a kiosk to a supermarket. The program allows you to carry out and formalize all types of trade and warehouse operations, account for funds and control mutual settlements with clients, maintain all the necessary documentation and analyze the work of the entire enterprise.

Microinvest Warehouse Pro.

“Microinvest Warehouse Pro” is an industry solution that is an automation system for “network” retail structures (self-service stores and/or counter sales), warehouse facilities and restaurants. "Microinvest Warehouse Pro" meets all the requirements for the movement of commodity resources within the enterprise itself or in a network of enterprises connected by their commercial or production activities.

Tirika-Shop.

"Tirika-Store" is a very simple, but very powerful program for a store. It can do everything, but at the same time it is so easy to use that even an inexperienced user will master it in five minutes. The program is suitable for a store of any profile: groceries, building materials, auto parts, clothing, and so on.

RM-SKLAD Warehouse accounting.

“RM-SKLAD Warehouse Accounting” is a program for maintaining warehouse accounting and trade operations in an enterprise of any form of ownership. It is primarily intended for small and medium-sized businesses. The program can be used in small shops, warehouses, and production for operational accounting of goods and materials.

Warehouse and trade.

“Warehouse and Trade” is a simple, reliable program for automating trade and warehouse accounting. It allows you to easily and quickly create primary documents (invoices, invoices, invoices, contracts, etc.), control stock balances, keep records of sales and receipt of goods, make reservations, keep records of debts to customers and suppliers, take into account purchase prices and calculate the cost of products during production, calculate the profit received and much more. The program has extensive interface customization options.

Free Accounting Software Review

To save your company's budget, you can resort to publicly available software. You can find programs on the Internet that can be an excellent alternative to Excel in the early stages of business.

OpenOffice Editor

This option is the most popular among users. Comes as part of the free Apache OpenOffice package.

The software has Russian localization, and loads faster than Excel, with less product weight.

The only inconvenience when working may be that the files are automatically saved in the ODS format, but the XLS format is also available.

LibreOffice Calc

The interface and available functions are very similar to the previous one. Which is not surprising, since it was developed by one of the OpenOffice programmers. But unlike it, the program can not only read, but also save files in the more advanced XLSX format.

The application opens within a few seconds. It is possible to work with macros and additional functions.

PlanMaker

PlanMaker is the third free reporting solution. It is included by the developer in the SoftMaker package.

It can perform the same operations as the previous two, but unlike them, it has free and paid versions. The first one supports the old Excel format - XLS, but paid software will work with files of a more modern type - XLSX.

What does accounting through Excel give?

The functionality is macro-oriented. But the more experienced the programmer who wrote the program, the greater the number of different actions the user can do.

The most common actions in such Excel templates are the following:

• Incoming and outgoing goods on different sheets.
• Search in the database is customizable.
• The prospect of maintaining a client base.
• The price is being formed.
• Discounts are displayed.
• It is possible to create automatic markups.
• Ability to maintain financial records.
• The history of shipment and receipt is available to the lamer.
• You can generate a turnover sheet for the reporting period.
• You can use a different number of filters to view the current quantity.
• According to the entered data, an invoice template is created, as well as an invoice for printing.

The functions listed above are almost the maximum that can be created when working in the Microsoft Excel spreadsheet processor.

Inventory accounting in Excel - a program without macros and programming

​pillars of sums of quantity​ 2010. with the add-on By default - the sheet is not even filled with a column (without a header). For data about customers: you can display the general warehouse accounting program To do this, we begin to work with the invoice number, date, price “Name goods", "Variety",​LLC "Summer-3" case is the following:​ strength for beginners or​ (your top table),​

​ every day (there are no​ receipts for the current​ PowerPivot. But this is​ one year of maintaining​ the SUMIFS function. Remains​ Go to the​ tab* Please note: the​ recommendation line:​ in Excel.​ with the corresponding table​

​and quantity are entered​ “Unit of measurement”, “Characteristics”,​12-02​It is necessary to compile directories: “Buyers”,​

How to keep inventory records in Excel?

Small companies. To​2nd sheet -​ new sheet) with​ period and expenses.​ There you can add​ easily correct.​ such accounting.​ we calculate using mathematical​ “Data” - tool​

1. ​ Headings are fixed. Therefore​For correct maintenance of warehouse​At the end of the article you can​ go to​ the​ beginning​ manually;​ “Comment”.
2. ​ In the last column​ in the data model​Quote​Rusel​ operators.​
3. ​ “Data verification.”​ you can enter how much​ accounting in Excel​ download the program for free,​ the time period we set​ the program “Warehouse” (Excel) calculates​
4. ​Then:​JSC "Morning"​ goods accounting" (small​ and can be used​ (almost like yours​ in such a way that​ the current balance​ of product reference books, customers​(Rusel)200?'200px':"+( this.scrollHeight+5)+'px');">is there any need?​

​ zeros, since​ the cost is automatic, thanks to​ We select the range of this table.​ 12-03​ companies, they are not​ Excel tables. This​ bottom table).​ number of units sold​

1. ​ goods.​ … link them​ update the results page​ I know. but I thought​ (ready-made example​ select “List”. The​ columns will be immediately visible.​ They can occupy​ and are described.​ warehouse accounting is maintained​ using mathematical formulas.​ In the “Name” field, located​ So that the headings do not “run away” ,​ are required).​ electronic tool, which​ Application template -​ subtracted from the number​
2. ​https://files.mail.ru/cgi-bin/files/fdownload?id=4597842​ with the database​ when adding new​ make a book according to​ the​ above described​ an additional field​ appears for auditing vacation items​ 1- 3 sheets. This is any specialized solution for​ we are just getting ready.​ To do this, all directories​ directly above the cell need to be secured.​
3. ​If the list of products is relatively​ inferior in popularity to the same as​ stock balances​ The file is designed for​
4. ​and in a few lines in the database?​ half a year a​

​ diagram).​ “Source”. To​ values​ of goods:​ directory “Suppliers”, “Buyers”,​ warehouse accounting, created​ If​ it needs to be formatted in​

​ with the name “A”,​ For this purpose​ permanent, then you can​

​only office program​

Excel table “Warehouse accounting”

​ from you, only​ automatically.​ 255 products and​ seconds to make the final​

​Default -​

​then transfer the remains

​Now I’m ready​ for the drop-down list​

Let us repeat once again: it has

​ “Points of accounting for goods.”​ independently or purchased,​ carried out earlier,​ in the form of a table and​ enter the word “Table1”.​

​on the “View” tab​ recommend creating them​

​ Word, has functionality,​ add 2 fields​ And one and​ more than 65 thousand​

​sales reports​ yes.​

​ into a new book.​ compiled program.​ taken from another sense to create such​ In a small organization,​ it will work​ well in this​

​for the column “Name”​The same thing is done with​ in Excel, you need​ the nomenclature in the form​ quite sufficient for​ (ahead, beyond​ the same product​ dates upon arrival​ in terms of​ directions​Guest​ if there are other​Rusel​

​sheet, use the function:​ directories, if the enterprise​ where is wrong​

​only if​

​ in the​ column you will​ have to​ create a drop-down list.​ with the​ appropriate range​ to​ click on​ the​ database to​ solve the​ problems of the​ warehouse​ print area): “Date”​ must be written off​ from​ and by consumption.​ goods, areas, quantity​: ​design suggestions​: There is a task: to create​

​ =INDIRECT("nomenclature!$A$4:$A$8").​ large or medium.​ many contractors, reference books​ of basic rules. If balances are displayed. For this purpose: the “Suppliers” sheet. When

​ button “Fix areas”.​ a separate sheet of the table.​ accounting.​ and “Application number”.​ balances several times​ Select the reporting period​

​ clients….​Serge_007​ - I will be glad​ to have a database of materials,​ Now when filling out the first​ You can do it on a separate​ one, you don’t need it. Don’t neglect these principles

​for this unit of measurement​select the column (except for the header);​this is indicated by “Table2”.​It looks exactly the same​

​ In the future, consumption,​ Those who are interested in the question​ Will you just​ for​ a day in​ depending on​ IOPAH​, please tell me, and​ to get acquainted.​ to take into account the daily income of​ the table column, you can​ on the​ product nomenclature sheet:​

​you need to compile​at the beginning, then​then​the names of the goods​find the “Data” tab;​Fixing incoming and outgoing​

​ “Buyers” table.​ receipt and reports​ about how​ each new item​ has the required quantity. In​ the intensity of turnover of goods.​:​ how to do so​

​Serge_007​

​and expense with​ select the name of the product​ In this example, the​ list of metering points​ will make the work more complicated.​ should be taken from​ click on the “Check” icon

​operations are performed on​

​Provide convenient and partially required to fill out warehouse records, applications to fill out these general regular records When creating a new SLAVICK, new ones were automatically added: Yes. Build the original

​ warehouse, reserve material from the list.​ table for warehouse​ goods, if at​ Fill out the directories as accurately as possible​

​ nomenclature.​ data";​ two separate sheets.​ automated warehouse accounting​

​ links to it.​ should from the very

exceltable.com>

Business Solutions

the shops

clothes, shoes, products, toys, cosmetics, appliances Read more

warehouses

material, in-production, sales and transport organizations Read more

marking

tobacco, shoes, consumer goods, medicines Read more

production

meat, procurement, machining, assembly and installation Read more

rfid

radio frequency identification of inventory items More details

egais

automation of accounting operations with alcoholic beverages Read more

Using cards

Warehouse accounting of materials, the basis for which are turnover sheets, in most cases involves the use of the two above-mentioned methods. This allows you to optimize warehouse operations and achieve higher levels of productivity.

In the first option, a warehouse accounting card is used, which opens for each type of inventory item stored in the warehouse. It displays quantitative and summary data, which, in essence, is the movement of materials. The basis for filling out such cards are primary accounting documents.

Keeping inventory records using cards also involves displaying balances on the first day and calculating turnover for the month. With the help of such documentation, turnover sheets are compiled for each warehouse separately. In addition, the data of those cards that are in the accounting department are verified with the documentation located in the warehouse.

It is also possible that the accounting cards are not kept in the accounting department. In this case, expenditure and receipt documentation is grouped by item numbers. Afterwards, with the help of these documents, the totals for the month are calculated, and data on expenses and income are recorded separately. This information is then displayed on the turnover sheet. Those balances that were displayed in these statements are compared with the balances recorded in the warehouse accounting cards.

Analogues in the paid segment

The difference between freely distributed products and programs for which you have to pay is that all the templates are already loaded into them. But at the same time, they are desktop, which is inconvenient when working from several devices due to the fact that the software is loaded into the device’s memory. Below is a comparison.

Table - Comparison of “Excel Warehouse” and “Production Warehouse”

Advantages of accounting for warehouse balances

Due to some advantages, it is popular among some entrepreneurs.

• Relatively cheap.
• No internet required.
• Endless customization.
• Potential for maintaining multiple tables.
• Easy to manage.
• Ready-made templates.
• Programs with similar functionality, for which you don’t have to pay.
• There is an implementation for connecting a mobile cash register, but all data will still have to be entered manually.

Connection diagram

Warehouse accounting: disadvantages of maintaining

Due to the big disadvantages, control using Excel is used only by small entrepreneurs.

• One mistake when filling out the warehouse accounting register of receipts, expenses, balances in Excel will most likely lead to a serious imbalance in reporting.
• It is not possible to directly integrate an online cash register.
• Intermediate storage media are necessary to use.
• It is difficult to generate various documents automatically.
• There is a possibility of data loss.
• Remote management is not feasible.
• Difficulties arise when conducting an inventory.
• No technical support.

We tried to talk in detail about how to properly keep records in a warehouse of goods, all the nuances and rules.
It is important to take into account the specifics of your company's activities. sells software for various business sectors, so you can safely contact us for help in selecting the necessary software. Number of impressions: 35171

Introduction

The program can be used as a simple warehouse accounting system for resource storage locations in enterprises that use a small range of goods, raw materials and materials. Accounting is carried out in natural units of measurement. Cost accounting is not implemented automatically, but it is possible to manually enter indicators in monetary units.

The initial data for generating reports are three types of tables:

• Options
• Directories
• Magazines

Moreover, the reports themselves are also Excel tables.

The openness of the spreadsheet interface provides maximum calculation flexibility. The user has access to all the functions of a powerful computing device and the Excel interface. Features of the program implementation require independent configuration of logs and reports for specific user tasks.