Summary
The client tracks products, sales, purchases, and inventory in separate files, making updates and reporting repetitive.
The result was a controlled Excel workbook with VBA for inventory, orders, and reporting.
The software is designed to reduce manual inventory work and the time needed to prepare reliable business information.
Client story
The client is a wholesaler from Romania. They manage products, sales, purchases, suppliers, and inventory in Excel while also processing customer orders and invoices.
Keeping balances up to date takes the team time. Inventory movements, sales data, and purchase records must remain linked when products are received, shipped, issued, or returned.
The request was simple: automate inventory updates from transactions, provide a clear view of inventory and sales performance, generate reports, and import existing data from files already in use.
The solution was designed as a controlled workbook with transaction forms, protected tables, dashboards, reports, and import processes. Order processing, invoicing, and inventory alerts were delivered as connected modules.
The client requested
- Inventory updates based on sales, purchases, receipts, shipments, issues, and returns
- Dashboards, charts, KPIs, filters, and trend analysis
- Inventory, sales, purchasing, valuation, and daily report generation
- Import of existing data and report refreshes from source files
Why ready-made software did not fit
Warehouse automation products focus on robots, automated vehicles, and material handling, while this client needed inventory transactions, orders, invoices, imports, and reports in Excel. The custom workbook matched their existing way of managing inventory, sales, purchases, and supplier information.
Project overview
The solution was designed in Microsoft Excel with VBA automation, forms, dropdown lists, and protected tables. This gives the distributor one controlled place for inventory, order, and supplier information.
The transaction entry screen records sales, purchases, and inventory adjustments. Running balances are updated based on the recorded transactions.
The inventory dashboard shows current stock levels, reorder points, and low-stock alerts. Filters, slicers, and refresh functions keep the view focused on the required products or periods.
Reporting combines pivot tables, summary tables, and trend charts. It covers sales, purchases, and out-of-stock information with filtering options.
Special attention was paid to imports and business documents. The workbook can be populated from CSV and XML files, while invoices and summaries can be prepared for PDF export or email delivery.
Key features delivered
- Automatic inventory updates based on sales, purchases, receipts, shipments, issues, and returns
- Bulk product inventory updates
- Inventory record management
- Inventory dashboard with low-stock alerts and reorder points
- Sales, purchasing, inventory, and out-of-stock reports
- Charts, KPIs, filters, slicers, and trend analysis
- Customer order processing
- Invoice generation with product details
- CSV and XML data import