Stock-Pratique (Inventory Management)
Stock-Pratique is an Excel application for inventory management (items, in/out movements, customers/suppliers, inventories, exports, etc.) that is user-friendly and highly functional.
You can try it now: Download
The "Inventory" Tab
This tab allows you to display the list of your items or a selection of them using the 5 search fields (which you can use simultaneously).
It also allows you to:
- Know the current stock for each item (or the stock on a specific date using the "Inventory as of" field)
- Display the in/out movements of an item by clicking on the item
- Easily export the results using the export function (available by clicking on the arrow pointing downwards)
- Sort items by categories
- Assign a location (storage place) for each item (with the option to replace the "Location" field with a custom field if not needed)
- Specify the most appropriate unit for each item
- Set a minimum stock level (if stock falls below this number, the item's stock status will be "Item soon out of stock")
- Easily add, edit, and delete items
- Quickly take notes for each item using the "Notes for this item" field
- Obtain an inventory on a specific date with the stock value for each item
Note that most fields in the different tabs are optional, so you are not required to fill in fields that are not necessary for you.
The "Movements" Tab
This tab allows you to display the list of movements of your items or a selection using 5 search fields and the ability to set a date range.
You can also:
- Add up to 6 movements at once for a single order (for example, you can enter a 12-item order in two steps instead of entering all 12 movements one by one)
- For easier selection of the relevant item, a search field is available next to each dropdown list (simply enter a few characters of the item's reference, name, or category to update the dropdown list)
- Selecting the customer or supplier is also made easier with the search field located next to the dropdown list (simply enter a few characters of the company name, first or last name, or group to update the dropdown list)
- Easily add, edit, and delete movements
- Export the results using the export function (available by clicking on the arrow pointing downwards)
The "Customers & Suppliers" Tab
This tab allows you to display the list of your customers and suppliers or a selection using 6 search fields.
It also allows you to:
- Define new groups to add contacts other than customers and suppliers
- Add up to 3 custom fields (by clicking on the "Special 1", "Special 2", or "Special 3" fields)
- Easily add, edit, and delete contacts
- Export the results using the export function (available by clicking on the arrow pointing downwards)
The "Information" Tab
This secondary tab contains links to the web pages of this application and also allows advanced users to view the 3 Excel workbook sheets containing the list of items, movements, and contacts (customers and suppliers).
Key Features of this Stock Management Application
Easy to Use:
This application has been designed to be as simple and intuitive as possible while offering many features.
The 3 main tabs allow you to manage items, movements (in/out), and contacts (customers/suppliers), and each tab has useful features for adding, editing, deleting, searching, and exporting data.
Efficient and Fast Search:
All search fields display and update results instantly with each character entered.
Therefore, you don't need to enter a complete name to get results, a few characters are enough (tip: double-click on "Search" at the top right to clear the search field content).
Easy Export of Results:
To export the results based on your search, simply click on the arrow pointing downwards. You can then choose which data you want to export to a new Excel workbook.
Preview of the export function in the Inventory tab:
Compatibility:
The Stock-Pratique application is compatible with all versions of Excel for Windows (not compatible with Mac, LibreOffice/OpenOffice).
Try this Application Now
The free trial version of Stock-Pratique (limited to 20 entries per tab) allows you to test this software without risk.
You can then switch to the full version at any time without losing the data you have already entered.
A version with access to VBA code is also available for advanced users.