Excel table for inventory accounting in the warehouse
An Excel table is needed for inventory accounting in the warehouse. A warehouse accounting template. I am not strong in macros, so it would be better if someone else could do this. At a minimum
Serial number
Article
Barcode
Product Name
Quantity
Purchase Price (calculated based on the average if there were different purchases at different times. For example, there is 1 item available for 1 dollar. Purchased 2 more items for 2 dollars. In total, the average purchase price of the product in stock is 5 dollars divided by 3 items
Receiving Date / Shipping Date (Automatically)
Document number of receipt (if there are multiple documents, there should be an option to add each)
And the balances accordingly with highlighting of certain cells depending on their value
Products are entered manually, then using a barcode scanner, products are added to the balance and removed from the balance with automatic issuance of the date of addition and removal from the balance, so that it can later be checked on what date and which product was removed and added to the balance.
Something like that... I look forward to proposals on price and production timelines
-
1 day16 USD
127 1 day16 USD
Hello!
I will set up an inventory management system for you in Excel + Make.com — automations that work on their own and allow for quick warehouse control.
What I will do:
• Receiving/writing off goods by barcode
• Automatic calculation of balances and average price
• Notifications of low stock
• Log of operations and history of movements
… • Complete setup of structure and formulas
-
3 days22 USD
631 5 0 3 days22 USD
Good day
I am ready to help you solve your task
I will do it quickly and efficiently, write to me, we will discuss
-
2 days16 USD
117 2 days16 USD
Ready to help with this task. I have extensive experience in preparing tables for various requests.
-
2 days16 USD
300 2 0 2 days16 USD
Ready to develop an Excel file with the necessary templates and macros.
-
1 day16 USD
280 1 day16 USD
Good day, I can do it today and for a minimal payment, I have experience with tables and databases.
-
7 days45 USD
637 17 1 7 days45 USD
Good day! Open to collaboration. I will develop forms for warehouse accounting according to your tasks.
-
1 day18 USD
964 17 0 1 day18 USD
Good day!
I suggest keeping records not in Excel, but in Google Sheets. We gain the ability to:
1. Store data in the cloud
2. Work from both a computer and a mobile phone/tablet
3. Allow multiple users to work with the database simultaneously.
Feel free to reach out, and we will discuss the task in more detail)
-
1 day16 USD
465 24 7 1 day16 USD
Good evening. Feel free to reach out. I will be happy to help. Sincerely, Oksana. The price and deadline are current.
-
2 days33 USD
986 12 1 2 days33 USD
I am ready to promptly and qualitatively complete your order. I have experience working with similar projects, always adhere to deadlines and technical specifications. I will be happy to collaborate!
-
1 day22 USD
536 33 0 2 1 day22 USD
Ready to help and complete the project. Details in private message. Final deadlines and price after discussion.
-
1 day16 USD
194 1 0 1 day16 USD
I am ready to help you create a convenient and simple Excel template for inventory accounting without unnecessary macros — everything will work automatically with formulas and built-in Excel tools.
-
Доброго вечора, обирайте готові рішення BAS
-
Current freelance projects in the category Enterprise Resource Planning (ERP)
Searching for B2B clients for the sale of premium fitness equipment in UkraineProject Title: Automation of B2B Client Search for Selling Premium Panatta Fitness Equipment in Ukraine Task Description: Our company is the official representative of the Italian brand Panatta in Ukraine. Panatta offers premium professional fitness equipment for gyms, hotels,… Enterprise Resource Planning (ERP), Information Gathering ∙ 3 days 5 hours back ∙ 19 proposals |
GoHighLevel Specialist
111 USD
Looking for a specialist in setting up GoHighLevel - must have a thorough understanding of all nuances and details - must quickly and efficiently prepare the draft of the site - must configure additional modules and monitor the stability of the system Online Stores & E-commerce, Enterprise Resource Planning (ERP) ∙ 3 days 6 hours back ∙ 10 proposals |
Automatic payment generation module for BASIt is necessary to implement an enhancement based on the extension (without configuration changes), an additional module that would integrate into the BAS menu regarding the automatic generation of payment orders based on received invoices and deferrals specified in the… Enterprise Resource Planning (ERP) ∙ 4 days 1 hour back ∙ 7 proposals |
Processing for payment unloading from PrivatBank for BAS Accounting Corporation1. Add the given processing as an extension in the configuration (without changing the configuration) so that it appears as an additional menu item. 2. Provide a separate type of rights for configuring access rights to work with the module. 3. Ensure that all subsections of the… Enterprise Resource Planning (ERP) ∙ 6 days back ∙ 7 proposals |
Looking for a specialist in WordPress / WooCommerce automation
142 USD
Looking for a specialist who can help set up automation for filling product cards in WooCommerce using Make.com, N8N, Zapier, or similar services.Task We have an online store on WordPress + WooCommerce in different languages. It is necessary to automate the creation and filling… Enterprise Resource Planning (ERP), Online Stores & E-commerce ∙ 7 days back ∙ 57 proposals |
Ukraine