Switch to English?
Yes
Переключитись на українську?
Так
Переключиться на русскую?
Да
Przełączyć się na polską?
Tak
Post your project for free and start receiving proposals from freelancers within minutes after publication!

Google Sheets

Translated67 USD

  1. 3982
     21  0
    Work example:
    Automated processing of the table using make.com
    2 days178 USD

    Hello! For a small warehouse, Google Sheets using QUERY or SUMIF formulas is best suited, allowing for the automation of inventory without unnecessary effort.
    Here’s how we will build your spreadsheet (3 pages):
    1. Page "Product Directory":
    • A list of all items/names.
    • Column "Current Balance" — the final figure will be automatically pulled here.
    2. Page "Incoming":
    • Date, Name (dropdown list), Quantity.
    • You simply enter what has arrived.
    3. Page "Outgoing":
    • Date, Name (dropdown list), Quantity.
    • You enter what has been issued from the warehouse.
    How automation works:
    I will set up a formula that takes the quantity of goods from "Incoming," subtracts the quantity from "Outgoing," and instantly shows the current result in the "Directory." You won’t need to calculate anything manually.
    Indicators:
    • Cost: $150 – $250 (for a fully ready architecture with dropdown lists and formula protection).
    • Deadline: 1–2 working days.
    • Additionally: We can connect a Telegram bot for $150, so you can simply write to the bot "Product A - 5 pcs," and the data will be automatically entered into the spreadsheet (very convenient when you are in the warehouse without a computer).
    Message me privately — I will send a sample structure. What do you say?

  2. 2221
     3  0

    2 days67 USD

    Good day.

    I can create a convenient table for you to manage a small warehouse with several tabs and automatic calculation of balances. The logic can be built so that there are separate sections for receipts, write-offs, or issuance, and a separate page with current balances that will be updated automatically.

    If needed, I can also add a convenient search, filtering, or highlighting of items that are running low. If you send me an example of products or briefly describe how you currently manage accounting, I will immediately suggest a proper structure for the table.

  3. 1198
     19  0

    3 days67 USD

    Good evening, I can create a Google Sheet with a beautiful and user-friendly visual interface for data entry, as well as for navigating the sheet itself. I am ready to discuss the technical specifications and wishes in private messages.

    Examples of similar projects in the profile.

  4. 2112
     15  0

    1 day67 USD

    Sergiy, I will create a table with 4 sheets: product reference, receipts, shipments, and balances — they will be updated automatically. I will set up drop-down lists to avoid errors in names, and conditional formatting for visual control. I will add a short instruction sheet.

  5. 1758
     4  0
    Work example:
    Clinic website support
    2 days67 USD

    Sergiy, I can quickly create a convenient Google spreadsheet for a small warehouse: separate pages for products, movement, stock, and a simple search without prices — just units and quantity. I will set up automatic pulling of stock with formulas so that the data updates without manual calculations. I have made similar spreadsheets for operational tasks, so I will do it neatly and without unnecessary complications. If you want, I can immediately suggest a structure for your processes.

    Similar completed project: Ищу веб-дизайнера / разработчика для создания сайта “под ключ” на конструкторе

  6. 691    5  0
    1 day67 USD

    Hello! I am interested in your project. I have extensive experience in:

    📊 Data processing: working with databases, structuring and analyzing information, automating the processing of large volumes of data, import/export and validation;
    🤖 Automation and emulation of user actions, development of bots of varying complexity;
    ⚡️ Asynchronous and multithreaded parsing: collecting and processing data with performance optimization;
    🔍 OCR and text search: recognition and structuring of information;
    🖼 Media processing: working with images and multimedia;
    🖥 Software development, desktop applications, system services and utilities;
    📱 Mobile development: native and cross-platform applications;
    🌐 Working with APIs and third-party services: integration, automation, and data exchange;
    🗣 Translation and text processing: automation of translation, working with language models and text analytics;
    🤖 AI/LLM solutions: integration and use of artificial intelligence, working with language models and automating intelligent processes.

    I will complete the work quickly and efficiently. Contact me to discuss the details and deadlines of the project!

  7. 188  
    2 days67 USD

    Contact me, I will help automate the accounting of goods :) Have a nice day

  8. 647    11  1
    5 days67 USD

    Good day.
    I am ready to create a system for inventory management for you.

    There are 2 options:
    1) development using formulas in Google Sheets
    2) development of an interface based on Google App Script, where the tables will function as a database. All data for input will work through a visual interface (to avoid errors, standardizing data to a single format)

    I have created a table for managing inventory balances + conducting inventory checks.
    I propose the following tabs:
    - Products
    - Incoming goods
    - Write-offs
    - Sales

    The system will be scalable; in the future, a notification system, inventory management, or other features can be added.

  9. 153  
    2 days67 USD

    Good day!
    I will develop a convenient and well-thought-out inventory tracking table for you with automatic calculations and the ability to pull balances between pages.
    I will structure it in a way that makes it easy for you to work daily: without unnecessary actions, with a clear logic of product movement (incoming / outgoing / balance), taking into account only units without prices — specifically for your task.
    As a result, you will receive a neat, understandable, and fully automated file that will not require any further adjustments.

  10. 303  
    2 days67 USD

    Good evening! I am interested in your project. I can create a convenient table for inventory accounting (Excel/Google Sheets) with automatic calculation of balances and distribution across pages. I will make a simple and clear structure. I am ready to discuss the details.

  11. 326  
    2 days67 USD

    Hello!

    I can create a table for inventory accounting with multiple pages and automatic calculation of balances. I will make a convenient structure so that the data updates without unnecessary actions, focusing specifically on the quantity of goods without prices.

  12. 93799    1268  1   10
    1 day67 USD

    Hello. I am ready to create a table. Please contact me. I will be happy to collaborate.

  13. 115  
    2 days67 USD

    Hello. I can create a Google spreadsheet for inventory tracking with automatic stock calculation.

    I will implement:

    a convenient table structure on multiple pages
    automatic stock updates
    formulas and scripts for automation if necessary

    I will make it so that the spreadsheet is easy to use and does not require manual calculations.

    I would like to clarify:

    What specific data will be entered (incoming/outgoing)?
    Are reports or filtering needed?

    I am ready to start immediately.

  14. 417    2  0
    2 days67 USD

    Hello.
    What do you think about the option of Odoo self-hosted or ERPNext? These are all open-source (free) projects that can be easily deployed for any field of activity.

    If you are interested, write to me privately.

    I will deploy it quickly.
    The price is reasonable.

  15. 3273    52  0
    1 day67 USD

    Good day, Sergey.
    Write, we will discuss.
    There are questions.
    ............................

  16. 991    12  1
    3 days67 USD

    I have extensive experience in the development and automation of sales reports and inventory control. Tobacco products and battles - stock control, inventory less than 3 days, etc. I have developed both in Excel and in Google Sheets. High level of proficiency in formulas.

  17. 1120    6  0
    3 days67 USD

    Hello! I have made similar tables for inventory accounting in Google Sheets.

    I will create several sheets: product directory, incoming, outgoing, and balances - which will be automatically updated without manual recalculation.

    A couple of clarifications before starting:
    1. How many product items are approximately in stock?
    2. Who will be entering the data - one person or several?
    3. Is a history of operations needed (who, when, how much came/left) or is it enough to just have the current balances?
    4. Is there any example or template of how it should look - or are we starting from scratch?

  18. 981    17  0
    2 days67 USD

    Hello, Sergey!
    I am ready to complete the project and subsequently provide support for the database on technical issues. I can also offer a solution for convenient work in Google Sheets from a phone/tablet if access to data "on the go" is needed. Additionally - SMS in TG about any important events in the table)

    Please reach out - I can show an example of the mobile interface.

  19. 337    1  0
    1 day67 USD

    Hello. I can offer a web application based on Google Sheets for inventory management, which I have in my portfolio. The application has a much more convenient interface and makes it easier to manage inventory.

  20. 1786    19  0   1
    2 days67 USD

    Hello, Sergey!

    Our IT company creates and improves websites that operate stably, quickly, and solve specific business tasks for clients. We are engaged in developing websites "from scratch" as well as enhancing existing solutions, increasing their performance and user experience for your users.

    We have experience in:
    - developing responsive and fast websites on various platforms (WordPress, OpenCart, Shopify, WIX);
    - integrations with payment systems, CRM systems, external services, and internal systems;
    - optimizing the performance and security of websites;
    - setting up analytics and basic SEO tools;
    - software development and automation of business processes: customer base management, resource accounting, automation of repetitive tasks, integrations with third-party systems;

    After completing the project, we provide 14 days of technical support, during which we help adapt the system to your final business processes and consult on any questions regarding the completed work. Thanks to the free support of the completed project, this allows you to be confident that the developed solution operates stably from the moment of launch and does not require any additional adjustments.

    We work in a structured, responsible manner - focused on results that meet your business goals.

  21. 1855    129  0
    1 day67 USD

    Good day, Serhiy.

    I am ready to complete the task of creating a stock accounting table in Excel or Google Sheets.

    I have experience working with tables and data accounting: I set up the structure according to the tasks, ensure convenient data entry, and automatic calculation of balances.

    I will create the table taking into account your accounting logic, so that it is easy to use in daily work.

    I will do it now after the task is approved.

  22. 225  
    2 days67 USD

    Good day! I can create a simple and convenient inventory tracking table for you that spans several pages with automatic calculation of balances (without prices, only units of goods). If needed, I can also add extensions (Google Sheets version, multiple warehouses, error control in data entry). I am ready to start immediately after agreement.

  23. 3012    73  4   2
    1 day67 USD

    Hello! I am ready to successfully complete the task you have set!!! Feel free to contact me, I have a lot of experience!!!

  24. 10123    117  0
    1 day67 USD

    Hello.

    I have experience with Google Sheets. I am ready to take it on. Write to me, we will discuss.

  25. 522    2  1
    3 days67 USD

    Good day, I can help with solving this issue. I have experience working with programming languages PHP, JS, Go, Rust.

  26. 1490    28  0
    3 days67 USD

    Ready to complete, write for discussion of details..................

  27. 2581    283  2   5
    2 days67 USD

    Good day! I have extensive experience working with Google Sheets and have an understanding of inventory management.
    Feel free to reach out, we can clarify the details and I can get started!

  28. 726    9  1
    3 days67 USD

    Hello! Having reviewed your project, I am ready to start working on it. Let's discuss the details for the best result.

  29. 414  
    1 day67 USD

    Good day!
    I understood the task.
    I propose the following solution:

    I will develop a web application using Python + Streamlit (a very fast and convenient tool specifically for such tasks).
    Several pages/sections: "Incoming", "Outgoing", "Balances", "Transaction History", "Product Directory".
    Automatic real-time updating of balances after each addition/removal.
    Search, filters, sorting.
    Ability to export to Excel.
    A simple and understandable admin panel (can be operated even from a phone).

    The solution will be as simple as possible, without unnecessary complexity, but convenient and reliable.
    I am ready to deliver it turnkey.
    Let's discuss the details (approximately how many products, what specific operations are needed, whether access is required for several people, etc.), timelines, and cost.
    Please write when it is convenient for you to communicate.

  30. 242  
    1 day67 USD

    Hello!
    I will complete your task within the agreed deadlines and payment!

  31. 1045    7  0
    1 day67 USD

    Hello, Serhiy!

    I have extensive experience in automating business processes through Google Sheets. I will implement a convenient "turnkey" system for your warehouse:

    What will be in the sheet:

    Page "Reference": a list of products and units of measurement.

    Page "Incoming/Outgoing": simple data entry with drop-down lists (to avoid errors in names).

    Page "Balances": automatic calculation of balances based on formulas (Query/Sumif). You will always see the current quantity of products in real time.

    I will make the interface clean and understandable, so the work takes minimal time. I am ready to start today.

  32. 910    10  0
    3 days67 USD

    Good day. I am interested in your project. I can create a convenient table for inventory management across multiple pages with a logical structure and automatic calculation of balances. To ensure the table is truly convenient to work with, it is important to understand at the start what specific data you plan to input and how the accounting should look.

  33. 328  
    2 days67 USD

    Good day!
    I am ready to help with the development of a table for inventory accounting.

    I can implement:
    keeping records across several pages (for example: incoming, outgoing, balances);
    automatic pulling of balances for each item;
    a convenient structure without considering prices (only quantitative accounting);
    formulas and logic so that the table works stably without manual intervention.

    If needed, I can also create a short user guide.
    I am ready to discuss the details and suggest an optimal structure for your tasks.

  34. 357  
    2 days64 USD

    Hello!
    I am ready to start working immediately. In general, the task is understood, and if there are any additional clarifications, we will communicate through private messages :)

  35. 3270    10  0
    2 days74 USD

    I will develop a table for inventory management with automatic data retrieval of stock levels. I will create a structure with several pages and implement automatic data retrieval for products without prices. I will use Google Sheets functions to automate the tracking of stock levels. I am ready to complete the task within the specified timeframe.

    Portfolio - Freelancehunt
    There are video examples.

  36. 871    10  0
    2 days67 USD

    Good day!

    I can create an inventory tracking table for you in Google Sheets / Excel with automatic balance calculations.

    I will make a structure with several pages (incoming, outgoing, stock), where all data will be automatically pulled and calculated without the need for manual input. The table will be user-friendly and adapted to your products and units of measurement.

    We can clarify:
    — the approximate number of items
    — which specific units of measurement are used (pcs, kg, m, etc.)
    — whether additional features are needed (filters, lists)

  37. Another 10 proposals concealed
  • Profile blocked
    30 March, 17:37 |

    Добрый день, таблица на сколько позиций?

  • Serhii Bytsiura
    30 March, 17:44 |

    Добрий!

    Поки десь на 30, потім буде і збільшуватись і зменшуватись, треба щоб Я це вручну робив і нові позиції підтягувались в основну ( основний склад) я це так бачу, але я не дуже в цьому розуміюсь, тому і шукаю майстра.

  • Profile blocked
    30 March, 17:47 |
    deleted by moderator
  • Stanislav O.
    30 March, 20:15 |

    для кого це написано? 🤨

  • Profile blocked
    30 March, 20:23 |

    Для вас

Current freelance projects in the category Web Programming

Fix issues with Facebook API in the OpenCart module

In OpenCart, there is a module for integrating Facebook and Instagram via API, OAuth, and Webhook. After opening the module page in the browser, the number of API requests to Facebook starts to increase, and the number of errors gr:get:InvalidID also rises. It is necessary to…

PHPWeb Programming ∙ 19 minutes back ∙ 12 proposals

Updating the PrestaShop online store and integrating an AI assistant for wholesale

445 USD

An experienced PrestaShop developer is required to upgrade the online store LMAR.COM.UA Project information: LMAR.COM.UA is a wholesale online store for tools, household goods, plumbing, electronics, and home and garden accessories. The store has over 3000 products and more than…

Web ProgrammingWeb Design ∙ 2 hours 37 minutes back ∙ 20 proposals

Create a WordPress plugin for a survey (quiz)

222 USD

A WordPress plugin needs to be developed that will be able to - store a bank of questions, all in the same format - a question and 4 answers, 1 correct - display 12 questions in random order, track the timing - collect user data - show the final result with the option to share…

PHPWeb Programming ∙ 7 hours 47 minutes back ∙ 60 proposals

Online shoe store

In connection with the expansion of the assortment and the involvement of partners in the dropshipping system, we are looking for a specialist or team to create a modern online shoe store. IMPORTANT: an automated inventory management system needs to be created with the…

Online Stores & E-commerceWeb Programming ∙ 18 hours 36 minutes back ∙ 96 proposals

Development of the AM Mobility platform (car service, parking, insurance, car rental)

5768 USD

We are looking for a team or an experienced Full Stack developer to create the MVP of the AM Mobility platform. AM Mobility is a unified digital ecosystem for motorists, combining in one application and web platform: parking; car service; tire fitting; car wash; car rental;…

Javascript and TypescriptWeb Programming ∙ 22 hours 54 minutes back ∙ 90 proposals

Client
Serhii Bytsiura
Ukraine Kyiv  2  0
Project published
2 months 12 days back
414 views
Tags
  • Excel
  • Google Sheets