Automated warehouse accounting system in Google Sheets

System Capabilities

Product catalog with articles, categories, units of measurement, and minimum stock levels.

Directories of suppliers, carriers, and recipients with convenient dropdown lists.

Separate sheets for "Receipts" and "Shipments":

automatic pulling of name, category, and unit of measurement by article;

quick and error-free entry of operations.

Main sheet "Warehouse":

automatic creation of product upon first receipt or shipment;

automatic calculation of current stock levels;

weighted average cost and total value of the warehouse;

display of the last purchase price and supplier;

highlighting products below minimum stock levels.

Dashboard with key indicators and charts (customizable individually).

Filters on all sheets for quick search, sorting, and analysis of products and operations.

Protection of sheets and the ability to enter data via Google Form from a phone.

Business Advantages

fully automated accounting without manual recalculation;

instant detection of products that are running low;

detailed history of product movement and purchases;

suitable for both small warehouses and large assortments;

easily adaptable to any type of business: manufacturing, retail, wholesale, auto service, online store.

Demo: https://docs.google.com/spreadsheets/d/1kCceLmYmQPqKTFnawQMKCuQUUdB8EiV2lhPx_As2J88/edit?usp=sharing