IN & OUT Inventory System R2V2 – Perfect for Retail shops, Hardware stores, Electronics shops , War

System Overview

The IN & OUT Inventory System R2V2 is an Excel
VBA–powered solution designed for businesses that need a fast, reliable, and
user-friendly way to track product movement. Using barcode scanning, automated
userforms, and a structured database, the system records stock entries (IN),
releases (OUT), and real-time quantity updates—all without requiring advanced
technical skills.

Built entirely in Microsoft Excel with VBA automation, it
delivers the accuracy of a POS system while keeping the flexibility and
simplicity of Excel.

________________________________________

⚙️ Key Features

1. Smart Product Database

Based on your database structure, the system stores complete
item information, including:

•          Barcode

•          Item Name

•          Unit

•          Sale Price /
Purchase Price

•          Brand &
Model

•          Serial
Number

•          Category /
Section

•          Supplier

•          Location

•          Expiry Date
(if applicable)

•          Reorder
Level

•          Date Added

•          Current
Quantity

•          Series

•          Image
(Displays automatically when barcode is scanned)

Everything is organized in a clean table for easy updating
and reporting.

________________________________________

2. Barcode-Enabled Operations

•          Scan a
barcode and the system instantly pulls up all product details

•          Automatically
displays the linked product image

•          Reduces
typing errors and speeds up operations

________________________________________

3. Automated IN & OUT Transactions

•          Record Stock
IN (deliveries, purchases, returns)

•          Record Stock
OUT (sales, issuance, transfers)

•          System
automatically adjusts Qty based on your actions

•          Timestamping
for accurate activity logs

________________________________________

4. User-Friendly Interface (UserForm)

•          Add, update,
edit, or delete items easily

•          Search by
barcode, item name, category, or supplier

•          Clean layout
designed for fast operations

•          Built with
VBA to automate tasks and reduce manual work

________________________________________

5. Alerts & Data Protection

•          Low stock /
Reorder Level warnings

•          Expiry
reminders for perishable items

•          Error-handling
and input validation to prevent incorrect entries

•          Prevents
overwriting and duplicate records

________________________________________

6. Customizable Setup

•          Add or
rename categories, units, sections, or suppliers

•          Replace logo
and business name with your branding

•          Expand the
database with additional fields anytime

________________________________________

7. Reporting & Monitoring

•          View
real-time stock levels

•          Filter items
by category, section, supplier, or status

•          Quick-export
to Excel sheets for printing or reporting

________________________________________

💼 Perfect For

•          Retail shops

•          Hardware
stores

•          Pharmacy and
medical supply

•          Electronics
shops (model/serial tracking)

•          Warehouses

•          Small to
medium businesses

📞 CONTACT / ORDER
INFORMATION

Product Name: IN & OUT Inventory System R2V2

Developer: ELJ

Inclusions: System file, UserForm, Database Table, Basic
Support

Email: vbafan2000@gmaill.com

Contact: 09274741927

📄 END-USER VALUE

This system provides the reliability of a POS system, the
flexibility of Excel, and the power of VBA automation—making it the perfect
inventory solution for growing businesses that want simple, effective, and
affordable technology.