Warehouse accounting in Excel is an excellent solution for any trading company or production organization for whom it is important to keep records of the amount of materials, raw materials used and finished products.
Who can help spreadsheets?
Large companies acquire turnkey solutions for this purpose in electronic format. However, they are quite expensive, and some complex programs require the involvement of a qualified employee with high salaries in the warehouse. This is beyond the reach of start-ups or small companies. Fortunately, there is a way out, and you can use Excel spreadsheets. This electronic tool, which is inferior in popularity only to the Word office program, has functionality that is quite sufficient for solving warehouse accounting problems.
Some important rules
, , , . :
- . , , , ( ) .
- .
- , .
- Excel .
- , , , .
Excel:
, . :
- : «», «» « » ( ).
- , . , . Excel «» , , , ..
- « ».
- () «».
- «» «» .
, Excel, . , , «». . :
| A | B | C | D | E |
1 | | | | | 4 |
2 | | | | | |
3 | «» | 12-01 | | | |
4 | «-3» | 12-02 | | | |
5 | «» | 12-03 | | | |
«», . «» Excel « ».
«».
, . , , (). , , .
| A | B | C | D | E |
1 | | | | | 4 |
2 | | | | | |
3 | -210 | | 1 | | |
4 | -15 | | 1 | | |
5 | -1 | | | | |
6 | -2 | | | | |
«»: «»
, . « », «», « », «», «».
:
- .
- «», «», «1».
- «». «2».
- . Excel.
«» , .
Excel , , .
:
«» . :
- ( );
- «»;
- « »;
- « » «»;
- «» «=("!$A$4:$A$8")».
- « » « ».
, 1- . «. .» .
«» «», .
«» . — «= * ».
« », , . , .
« »
, , Excel , .
, . , . .
, «» «» .
, .
«». , ( ) .