Excel file for inventory accounting

Budget: 1000 UAH Deadline: 2 days

Good evening
I would suggest using Google Sheets for inventory accounting.
In the future, any automations can be added through the API.

For example, exchange rates from the NBU or any bank, price monitoring, automatic email generation and sending to clients, or anything else.
I can send you a private mockup (without functions) with the structure you provided, but specifically in Google Sheets.

Budget: 4000 UAH Deadline: 3 days

Good day, I can create a mini website with an admin panel where the manager will work, I can also create an Excel file with formulas.

Budget: 7000 UAH Deadline: 4 days

Let me create a convenient functionality through the website and host it. It will take a bit longer in terms of time and costs, but it will be more user-friendly and allow for more features.

Budget: 4000 UAH Deadline: 3 days

Good day!

I have reviewed the specifications — the task is clear.

I will create a file with 7 sheets: Reference, Purchases, Sales, Reservations, Balances, Reports, Dashboard. All formulas are locked, dropdowns from the reference, and balances are updated automatically.

Regarding FIFO: I will implement it through a supplementary batch table — each purchase with its own price, and the write-off will come from the oldest batch. The cost of sales is pulled automatically.

Regarding protection: formulas are locked, only input fields can be edited. Error highlighting through conditional formatting (for example, sales exceeding available balance).

I will attach a short instruction in a separate sheet to the file.

Deadline: 3 working days.
Cost: 4,000 UAH. Expand

Budget: 700 UAH Deadline: 1 day

Hello! Ready to collaborate. I have experience working with Excel. I offer quality and fast work. Write to me.

Budget: 7000 UAH Deadline: 14 days

Hello, Yuriy! I can help. Experience with Excel in the Portfolio. Deadline and cost are approximate. Sincerely, Yevheniy.

Budget: 4000 UAH Deadline: 3 days

Hello!

I have created similar Excel/Google Sheets systems for inventory and sales tracking with automatic stock levels, reservations, and financial calculations, including FIFO logic.

I can assemble a structured file with references, purchases/sales/reservations, automatic stock levels, profit, and a dashboard, with input validation and formula protection, so that the manager can work without the risk of "breaking" the calculations.

Budget: 3800 UAH Deadline: 5 days

Hello.

I can develop an Excel file as a simple accounting system for one manager: separate tables for inventory movement, automatic balances, reservations, a financial block, and a dashboard.

It is technically important to correctly establish the inventory movement from the start: purchases add a batch, sales deduct the available balance, reservations reduce the free quantity, and formulas and auxiliary columns are protected from accidental editing.

Separately, we should agree on the cost calculation method. For Excel, the most stable option at the start is the weighted average cost. If FIFO with batches and partial deductions is required, it is better to handle that as a separate, more complex block.

I have experience in similar tasks related to automating spreadsheets, working logic, reports, and protecting data from manual errors.

Before starting work, I need to clarify:

FIFO or weighted average cost;
whether macros/VBA are needed or just formulas;
a sample of 5-10 real products;
whether the file needs to be transferred to Google Sheets in the future.

We can discuss the details in private messages. Expand

Budget: 4400 UAH Deadline: 7 days

Good day! I suggest implementing it directly in Google Sheets — it will be more convenient and functional:

Access from any device, auto-save Easy integration with CRM/other tools (you specified this requirement)
Apps Script — can automate routine tasks: auto-notifications, document generation, mailings, event triggers

I have worked with similar projects before:
— Inventory management for a goods business: separate tables for the manager and owner, mini-CRM, integration with Checkbox and Nova Poshta for automatic invoice creation
— CRM for the BDM of an international company: funnel, dashboards, reports

I will implement everything according to the specifications: purchases, sales, reservations, FIFO, dashboard, reports, formula protection, drop-down lists.

Write to me — we will discuss the details. Expand

Budget: 1999 UAH Deadline: 2 days

Hello! I have significant experience in developing similar Excel files. I will do it quickly, accurately following the specifications. Even a beginner will be able to work with the spreadsheet. Feel free to reach out!

Budget: 4250 UAH Deadline: 14 days

I have familiarized myself with the task. I will create a system of interconnected tables, in which balances, product movement, and necessary indicators will be updated automatically without manual calculations.

I am considering the structure with future scalability in mind, so that new accounting directions, reports, and automation can be easily added in the future.

I have experience in creating accounting systems from scratch, as well as optimizing and refining existing solutions. I will be able to not only implement the assigned task but also suggest practical improvements for more convenient and efficient work.

Budget: 2000 UAH Deadline: 5 days

Good day! I have experience in developing similar Excel/VBA programs and can demonstrate it. Of course, I have questions and need to discuss. The amount is approximate, I will do it quickly. Write to me.

Budget: 3000 UAH Deadline: 4 days

Yura, good afternoon.
I have a few questions about how cross-platform you need it (Win/Mac/Linux).
I have developed add-ons for Excel/Google Sheets for the Armed Forces of Ukraine.
I can develop with an interface (programming in C#) or standard automation + VBA - Visual Basic Applications.
Feel free to reach out, we will discuss, I will show you the details, we will agree, I will execute.
P.S. The cost and timelines are approximate, depending on the implementation option.

Budget: 4000 UAH Deadline: 3 days

Good day. I have extensive experience working with Excel, and I can create the required file for you according to the specifications.

Budget: 4000 UAH Deadline: 2 days

Good day.
I have reviewed your specifications. I have experience working with Excel, automating accounting, and building reports.
I am ready to develop a warehouse accounting file for solar equipment with:
a product directory;
a record of purchases, sales, and reservations;
automatic calculation of balances;
cost and profit calculations;
control of available balances;
a dashboard with key indicators;
reports on products and clients;
drop-down lists and formula protection.
Before starting work, we will agree on the method of cost accounting (FIFO or weighted average) and other details for the most convenient use of the file.
I am ready to discuss the details and start working. Expand

Budget: 10000 UAH Deadline: 10 days

Hello! I work with Excel and Google Sheets. I am ready to help with formulas or macros (scripts). Communication via Telegram bot and e-mail with Google Sheets. I would be happy to collaborate.

Budget: 2000 UAH Deadline: 3 days

Hello! Having studied your project with great interest, I am ready to start working on it. Let's discuss the details to achieve the best result.

Budget: 6000 UAH Deadline: 5 days

We have an almost ready warehouse accounting model that can be quickly adapted for solar equipment and put into operation. The estimate for the first version is 6000 UAH and 5 working days.

We will create a structure with a product directory, purchases, reservations, sales, automatic balances, cost price, inventory value, and profit. Essentially, this will not just be a table, but a small accounting system in Excel, without unnecessary complications =)

Please clarify whether the cost price should be calculated using the weighted average price or FIFO. Also, it's important - should the reservation simply reduce the available balance, or is a separate status with a reservation date needed?

Similar projects in logic:
https://business.ingello.com/forma-wms - warehouse accounting, balances, and movement of goods
https://business.ingello.com/forma-crm - workflows, sales, and data management
https://systems-fl.ingello.com/ua - a brief overview of our approach to systems, automation, and AI

To start, we need a list of product types, an example of 5-10 real items, the accounting currency, sales rules, and an example of how the manager currently handles purchases and sales. After that, we can keep it simple - first, we create a stable Excel, and if the volume increases, it can be easily transferred to CRM or a web cabinet. Expand