• EfoSmart

    Providing smart solutions for Stock Data Inventory Management and related ICT challenges.

    SmartBizVentory User Mannual

    SmartBizVentory stands for Smart Business Inventory and it is a kind of Business Intelligent tool that helps in smart transactions/stocks/sales/services inventory analysis and reports.
    It is a free inventory management software in excel developed to provide inventory solutions for stock tracking needs in a convenient way.
    It requires the user to populate the database with the scope of goods/services with their details. This helps to ease transaction documentation as they are are being carried out.

    After setting StartTime and EndTime, it can can report per Product/Service:

    1. Quantity sold/Number of transactions
    2. Amount realized
    3. Profit
    4. Balance stock
    5. Balance stock worth at cost price
    6. Balance stock worth at selling price
    7. Balance stock expected profit
    8. Last date of stocking
    9. Minimum set stock quantity (for guide)
    10. All other Expenses outside Staff Cost
    11. etc

          Other functions are 
    1. Numbers of days for a product to expire.
    2. Balance quantity in stock
    3. Reorder point
    4. History of Products Purchases/Inflow (Products, Dates, Last Stock Quantity, Previous Stock quantity, Current Stock quantity, etc)
    5. Total amount realized
    6. Total Profit
    7. Monthly Staff Cost
    8. Net Profit

    1. It support Microsoft Excel (2013 and above). Download Excel from Store and sign in with your Microsoft account credentials to use the mobile version
    2. User friendly. Inputs are either automatically populated  or are selected from dropdown list
    3. It can work in Mobile  and PC Mode (with more capabilities)
    4. Can work on any Operating System that supports Microsoft Excel
    5. Under PC mode, it has Manual and Auto Mode for Unit Cost of Products/Services
    6. Dynamic search of products/services from the database.
    7. In app instructional videos for quick understanding
    8. Can generate receipt in PC Mode
    9. Print transformation (Can transform between tiny paper size (POS Type) and normal A4 format based on choice)
    10. Requires password for users to log in
    11. Different User privileges with ability to change the default password (the default Admin password is a). 
    12. Option for numbers of receipt copies to print.
    13. Variable VAT implementation
    14. Can be used alone or with multiple users for group transactions at same time
    15. Free to use. Has life cycle of first one year of usage. Need to download the latest version at year end or reach us for time extension if desired. All data of past years remain preserved and responsive
    16. Ability to monitor all deleted/Reversed transactions
    17. Can auto-restock returned/reversed transactions of very recent operations back to database.
    18. Can handle up to 5,000 products in the database
    19. Can handle up to 100,000 transactions/records
    20. Online capabilities for remote monitoring

    Applicable Fields
    1. Shops (Retail and Wholesale)
    2. Stores (Small and Industrial)
    3. Warehouses
    4. Hotels
    5. Saloons
    6. Any Business Organization
    Please note that it can only run on Excel 2013 and above.

    How To Use On A Mobile Platform

    1. You may create a Microsoft account if you do not have one yet.
    2. Download Microsoft Excel from Store.
    3. Click on it to run.
    4. Sign in with your Microsoft account details.
    5. Navigate through the directory in the Excel to locate SmartBizVentory file.
    6. Click on SmartBizVentory and run.

    How To Create a Microsoft Account          

          Click here to create one.

    ...More updates soon.

    Key Words


    1. Replies
      1. Thank you. Wait a minute, you are the first person to comment!
        As you know, this program is free, kindly encourage us by sharing our videos on youtube.
        Thanks once more.