Create logical tables in Excel for inventory management. There is a malfunctioning prototype.

Hello.

I am ready to help with Excel spreadsheets for inventory accounting: analyze your prototype, find errors in the logic, and bring the file to a normal working structure.

I have practical experience specifically with inventory accounting, product movement, stock levels, receipts, expenses, returns, inventories, and working with spreadsheets. Therefore, I understand well that in such tasks, not only formulas are important, but also the correct accounting logic: to ensure that stock levels are calculated correctly, data is not duplicated, operations do not break totals, and the user can work comfortably with the file.

What I will do:

— review the existing prototype;
… — find where the logic is working incorrectly;
— correct formulas, links between sheets, and calculations;
— set up correct stock level calculations;
— if necessary, add tables for receipts, expenses, write-offs, returns, or transfers;
— create a convenient structure for data entry;
— add checks to reduce the risk of errors during manual filling;
— if necessary, prepare simple reports on stock levels and product movement.

I would start with an audit of the current file: what is already there, what is being calculated incorrectly, what operations need to be conducted, and what the output should be. After that, I will either correct the current structure or suggest a more reliable option without unnecessary complications.

I am ready to start after receiving the prototype file and a brief description of what is currently working incorrectly.

Cost: 1500 UAH.
Deadline: up to 2 days.

Show original

Translate

Good day! I work with Excel and Google Sheets, have experience in creating and checking tables, formulas, reports, and working with large volumes of data. To assess the scope of work, I would like to review the current file and the description of the issues that need to be fixed.

Show original

Translate

Good afternoon.

I am ready to help with the task, but before we start, I would like to understand the scope of the accounting and the number of operations.

If we are talking about full warehouse accounting (incoming, outgoing, balances, inventory, movement history, reporting), then developing Excel spreadsheets usually leads to constant modifications, user errors, and scaling issues.

In most similar projects, it turns out to be more cost-effective to implement a specialized accounting system right away. For example, ERPNext — a modern ERP/WMS system with a web interface, inventory tracking, product movements, users, access rights, reports, and the ability to further develop the business without the need to rewrite dozens of Excel files.

ERPNext can be deployed on an inexpensive VPS in just a few hours, and the cost of ownership often turns out to be lower than the ongoing support of complex Excel spreadsheets.
…
However, if it is still necessary to stay in Excel, I am ready to conduct an audit of the existing prototype, correct the calculation logic, refine the spreadsheets, and automate the necessary processes.

I suggest we first take a look at the current file and discuss the ultimate goal of the accounting — perhaps we can propose a solution that will serve the business for several years, rather than until the next major revision.

Show original

Translate

We have a practically ready similar logic for warehouse accounting in Excel, which can be quickly adapted to your prototype, discussed here now, and launched; I am available.
The benchmark for the first stage is from 5000 UAH and 3 days, if it is necessary to correct formulas, movements, balances, and add basic reports.
Look, there is a nuance here... I will give an exact estimate after the prototype file because sometimes the problem is not in the formulas, but in the structure of the tables themselves.
Please let me know how many warehouses and types of movements need to be considered - incoming, sales, write-offs, transfers, reserves.
Another question - do you need only Excel tables or also semi-automated buttons for entering operations and checking errors?
For similar tasks with accounting and system logic, there are examples - https://business.ingello.com/forma-wms - warehouse logic and processes, https://business.ingello.com/forma-crm - accounting, roles, and operational scenarios.
If you want to enhance the solution with AI verification, hints about anomalies in balances and input errors can be added without complicating the first stage.
About us - https://systems-fl.ingello.com/ua

Show original

Translate

Hello. I am ready to take on your project. I work quickly and efficiently. I would be happy to collaborate with you.

Show original

Translate

I will complete your task. I have an idea on how to integrate a Telegram bot that will be your assistant in the table.

Show original

Translate

Good day, I am interested in the project. I have experience working with Excel, data processing and structuring, creating and optimizing spreadsheets. For an accurate assessment, I would like to familiarize myself with the current prototype and understand:
- What errors are currently occurring;
- How many sheets are being used;
- What processes need to be automated or refined;
- Whether macros/VBA are being used.

After reviewing the file, I will be able to assess the scope of work, timelines, and costs more accurately.

Show original

Translate

Hello. I have been working with spreadsheets for over 3 years, I know everything that can (and can't too 😁)
I will gladly help you find the error, fix what is not working properly, and correct it.
Or create a new spreadsheet.

I will provide recommendations based on my experience and more than a hundred spreadsheets created of various levels of complexity and for different purposes.

Message me privately. We will discuss the terms of reference, conditions, and deadlines in more detail 🫶

Show original

Translate

Ready to help with Excel spreadsheets for inventory management. I will sort out the prototype, fix incorrect logic, add necessary formulas, and adjust the structure to meet your needs.

Show original

Translate

Good day!

I have reviewed the task description. It seems you already have a prototype for inventory accounting, but the issue lies at the level of the logic of the tables, not just individual formulas.

I have experience in building accounting systems and automating business processes, where it is important to ensure the correct flow of data between different stages, automatic calculation of balances, and minimizing the risk of errors due to manual input. In similar projects, I first conduct an audit of the existing structure, identify bottlenecks, and then either correct the current system or propose a more reliable architecture without data loss.

To start, I would like to see the current file and understand what operations the warehouse should support: incoming, write-off, transfer, reservation, or additional analytics.

After the analysis, I will be able to propose an optimal solution and assess the scope of improvements.

Show original

Translate

Good day.

I can create or refine an Excel system for inventory management based on your prototype, correcting errors and implementing a user-friendly logic for working with data.

In my work, I use the analysis of the existing file, correction of formulas and relationships between tables, construction of product movement logic, automatic calculations of balances, input error control, and optimization of the structure for further scaling. If needed, I can add filters, pivot tables, dashboards, and automation of routine operations.

Tools: Microsoft Excel, complex formulas, pivot tables, conditional formatting, Power Query, business process automation, and building accounting systems based on Excel.

Show original

Translate

Hello, I have experience working with and creating similar tables in EXCEL, I will figure out why the prototype is not working correctly, and I will fix everything as needed. I would be happy to collaborate.

Show original

Translate

Good day! I have a lot of experience working with Excel, so I will complete the task you set quickly and efficiently!!!!!!

Show original

Translate

Hello. I can help with correcting and refining an Excel file for inventory accounting.

I have experience working with logical tables, formulas, relationships between sheets, tracking income/expenses/balances, automatic calculations, and data structuring.

Show original

Translate

Hello!

I can help with the refinement and setup of Excel spreadsheets for inventory accounting. I will analyze the existing prototype, identify the reasons for incorrect operation, and make the necessary changes for convenient and logical record-keeping.

I work with formulas, links between tables, automation of calculations, and optimization of file structure.

To assess the timelines and costs, I am ready to review the current file and your technical specifications.

Show original

Translate

Good day. I am interested in your task and ready to complete it, please reach out. I would be happy to collaborate.

Show original

Translate

I implemented new and corrected existing tables of various complexity. I will help with your inventory management table. I will suggest options for automation or useful additions that will make working with the table easier. I will be able to provide a cost estimate after reviewing the tables and determining the scope of work.

Show original

Translate

Good day.
Experience in writing macros and formulas for Microsoft Excel is available.
Let's discuss the details.

Deadline and price - after reviewing the task.

Show original

Translate

Good day.
I am ready to help with your project, however, for an accurate assessment of the cost and timelines, it is advisable to first familiarize myself with the current prototype and understand what specific issues need to be addressed and what result you want to achieve in the end.
For now, the indicated timelines are preliminary, as it is difficult to objectively assess the scope of work without analyzing the file. After reviewing the prototype, I will be able to propose an optimal solution and provide exact deadlines for completion.

Show original

Translate

Market research analyst. I am engaged in the development and maintenance of sales reports, inventory control, and accounts receivable management. I will correct the existing report or create a new inventory management report based on your prototype. If necessary, I will add calculations for days of inventory and other metrics for effective stock control.

Show original

Translate

Hello, I am ready to perform! I create add-ons, macros, dashboards in Excel, Google Sheets both as standard solutions and in VBA. Let's discuss all the details in private.

Show original

Translate

Good morning. I will gladly fulfill the order. I will analyze the structure of the tables, the work of the formulas, and correct the errors. I specialize in automation using Excel and Google Sheets.

Show original

Translate

Hello.
I have extensive experience working with Google Sheets and Excel.
I also create scripts for the aforementioned programs.

Check out my portfolio and reviews.
Freelancehunt

I have reviewed the project. I am ready to assist with the implementation.
Feel free to write - we will discuss the details.

Show original

Translate

Hello! I have been working with formulas since 2008 and with VBA-Excel (macros) since 2011. My priorities are optimizing calculations and user convenience.

Feel free to write, and we can discuss.
The result will be a user-friendly and fast program, with input data control and error handling.

The deadline and price will be determined after reviewing the task.

Show original

Translate

Oleg, greetings.
Feel free to reach out, I develop add-ons, macros, dashboards for Excel, Google Sheets both as standard solutions and using VBA, C#, AppScript.
I have cases from online/offline retail chains, Armed Forces where tables have over 10,000 rows.
We will discuss, I will show examples, we will agree, I will do it.
PS. The price and deadlines are approximate; I need to see what you have and what you want.

Show original

Translate