Develop a simple system for accounting consumables in a small department.

Budget: 5000 UAH Deadline: 5 days

I can help with the development of an accounting template in Google Sheets. Please let me know:
1. Approximately how many names of medications and consumables will there be?
2. Is it necessary to set up different access levels for the head nurse and nurses, or will everyone work in the same file?
3. Is there a need for data import and export capabilities (Excel/PDF)?
4. Is implementation on Google Sheets sufficient, or are you also considering a web version if it would be more convenient?
5. What is the estimated timeline for implementing the template?

Budget: 4400 UAH Deadline: 6 days

Good day.
I am interested in your project. I have experience working with Google Sheets.
I would be happy to discuss the details and get started.

Budget: 4400 UAH Deadline: 3 days

Good day. I have studied the details regarding the accounting of medications for your department. I have previously implemented similar inventory systems in Google Sheets, so I clearly understand how to set up the logic for automatic deductions and stock control.

Technical solution:
I will build the database entirely in Google Sheets. The directories for patients and medications will be placed on separate sheets, from which nurses will select data through drop-down lists. The movement log will be a single table. Using the SUMIFS and QUERY formulas, I will set up automatic calculations of current stock levels, and conditional formatting will highlight positions where the critical minimum is reached or the expiration date is approaching. To avoid human error, I will block the possibility of deducting more medications than are available through data validation. I will also set up a separate dashboard sheet for generating reports by periods, patients, and staff.

Plan and timeline:
It will take 3 days to set up the structure, accounting formulas, conditional formatting, and to verify the operation of all reports.

Questions regarding the system:
Please advise if strict access rights division is needed for staff at the Google Drive level (for example, so that regular nurses technically do not have editing rights for incoming stock and directories), or will the work be conducted in a single shared table?

Budget: 5000 UAH Deadline: 4 days

Hello. I am ready to implement such a system on Google Sheets. I am open to collaboration.

Budget: 4400 UAH Deadline: 6 days

Good day! I have created such accounting databases — incoming and outgoing stock with auto-balances, control of minimum stock levels and expiration dates.

Straight to the point: would you prefer a web application with separate logins for the sisters (showing who exactly made the write-off), or is a Google Sheets table with formulas, lists, and conditional formatting that calculates the balances itself sufficient? This will affect the timeline. Approximately 5-6 days.

Budget: 4400 UAH Deadline: 4 days

Hello, Denys! I am ready to create this accounting system "turnkey" on Google Sheets + Apps Script — exactly the format you described: a ready-made template that your sisters can fill out immediately, without a separate server and subscription fees.

Here’s how I see the structure:
• Directories as separate sheets — Medications, Consumables, Patients, Employees — with the ability to add and delete rows.
• A single Movement Journal (incoming/write-off) with dropdown lists (date, patient, medication, quantity, full name) and manual correction.
• Automation on Apps Script: recalculation of balances, control of minimum stock and expiration dates, alerts for low stock, blocking write-offs greater than available, input validation, conditional formatting.
• Reports on separate sheets — current balances, usage over a period / by patient / by employee, history of movement for a specific medication.

I have experience with structured tables and automation on Apps Script — I have created similar accounting and reporting solutions.

The price is 4400 UAH, the deadline is 4 days with testing on your data. I am currently gathering initial reviews on Freelancehunt, so I will take this responsibly and will be in touch until the full result is achieved.

One clarification: is it sufficient to have alerts for low stock and expiration dates directly in the table (highlighting + a separate sheet "to order"), or would you like to also duplicate reminders via email or Telegram?

I can show you a live example of a similar template so you can see how it works in practice. Expand

Budget: 4400 UAH Deadline: 1 day

Hello! I can implement this in Google Sheets as a ready-made template with guides, a movement log, automatic balance deductions, expiration date and minimum stock control, drop-down lists, and necessary reports. I will make it easy for the staff to work without unnecessary manual calculations. The cost of such work is approximately $70–80; after clarifying the details, I will be able to provide the exact amount.

Budget: 12000 UAH Deadline: 5 days

I can create a working template in Google Sheets within 5 working days. The cost estimate is 12,000 UAH, as it's important not just to have a table, but a proper logic for balances, write-offs, expiration date control, and reports =)

$50 can only be considered for a very simplified first version without full error protection and without all reports. I wouldn't recommend cutting the task this way, as a mistake in balances in medical accounting can cost more than the table itself.

For implementation, I see it like this - separate directories, movement journal, automatic balance calculation, checking write-offs beyond the available quantity, drop-down lists, conditional formatting, reports by period, patient, employee, and medication. Access and filling in the databases will be on your side; I will handle the structure and formulas.

I need to clarify two points:
> Do you need different access levels for the nurse and the senior nurse?
> Should the same medication be tracked under different expiration dates as separate batches?

Similar logic cases from Ingello:
> https://business.ingello.com/lita - a medical system close in domain logic and process accounting
> https://business.ingello.com/forma-wms - accounting for balances, movements, and warehouse logic

The main page for system projects is - https://systems-fl.ingello.com/ua

!!If needed, I can offer two options - a basic template within Google Sheets or a more reliable option with a simple interface for entering write-offs.!! Expand

Budget: 4400 UAH Deadline: 5 days

Denis, your department needs a system that will not overload the staff with unnecessary actions during the daily inventory of medications. The essence of the task is to automate the write-off and timely signal the expiration of drugs, minimizing the manual work of the head nurse.

I propose to implement this through a simple tabular structure, where each movement of materials automatically updates the current balances and highlights positions with critical stock or approaching expiration dates. This will ensure transparency in the movement of medications and simplify inventory.

How do you plan to add new items to the directory - through a separate admin panel or directly in an Excel-like interface of the system?

Budget: 4400 UAH Deadline: 5 days

Good day!
I am ready to develop a simple and convenient system for tracking consumables for your department.
I can create a database in Excel or Google Sheets with the following sections:
— materials / medications directory;
— patients directory;
— materials intake;
— materials write-off for a specific patient;
— automatic balance calculation;
— reports by dates, patients, and materials.
The system will be easy to use on a daily basis: you will be able to quickly add new materials, patients, and record intake and write-off.
I have practical experience in creating spreadsheets, databases, formulas, and automation in Excel.
I am ready to clarify details and propose a convenient structure before starting work. Expand

Budget: 8000 UAH Deadline: 5 days

Hello. I have implemented similar solutions based on Google Sheets. I have over 8 years of experience in finance, I am knowledgeable in accounting, and I would be happy to help organize this area. The completion will take up to 5 days. I am indicating the maximum cost considering possible revisions during the process.

Budget: 5000 UAH Deadline: 7 days

Hello
This project can be realistically done in Google Sheets without programming. In fact, it will not be quite a "database," but rather a warehouse management system for a small medical department.
Regarding the budget:

* $50 (≈2100 UAH) is the lower limit for such a task.
* The actual market value of a similar template usually ranges from $80 to $200, depending on the level of automation and design.
* If only a template is needed without data filling and without complex Apps Script, then $50-$80 seems realistic.

Budget: 4444 UAH Deadline: 1 day

Ready to provide a specialized standard ready-made solution for your task and help you master it in practical work:
https://www.bas-soft.eu/soft/bas-sectoral/bas-medicine/
All your requirements and much more have already been implemented in this software product. If necessary, there is an option to quickly refine the database configuration to expand the data structure and working mechanisms, as well as to extend business processes. For further information, please write in private messages.

Budget: 27000 UAH Deadline: 14 days

Hello, Denys.
I offer you a ready-made solution for accounting - working in spreadsheets is not the best option for scaling a growing company. It will start with simple requirements, and then you will have to keep adding functionality, which will lead to difficulties in maintenance and high costs. We can discuss this. The stack is designed for 4-5 users.

Budget: 5000 UAH Deadline: 3 days

I understand the need of your department for a reliable template for medication accounting that will completely eliminate human errors in write-offs and inventory control. I have over 8 years of experience in designing data architecture and accounting systems, so I clearly know how to implement such logic without overloading the table. I will create a system with separate registers and a single movement log, where I will set up automatic balance recalculation, dynamic drop-down lists, and strict validation to protect against negative write-offs. Expiration date control and critical minimums will be implemented through conditional formatting, which will automatically highlight problematic items in bright colors. For automatic reports on patients, periods, and employees, I will prepare a separate interactive dashboard based on flexible QUERY formulas. Configuration, testing, and delivery of the ready-made template turnkey will take 3 days, and the cost will be $120. Let's discuss whether access for regular nurses should be restricted so they cannot accidentally change incoming data or delete history, and I am ready to start.

Budget: 4400 UAH Deadline: 3 days

Good day, Denis!
Google Sheets is the right tool for such volume, without a server and subscription fee.
All logic is based on a single movement journal: both receipts and write-offs are recorded there, and balances, reports, and history are calculated from it automatically. Directories (medications, materials, patients, employees) are on separate sheets, from where everything is pulled into drop-down lists so that the nurse doesn't have to type anything manually.

Two key points for reliable accounting:
- It's better to give nurses simple input forms rather than one large table—otherwise, formulas will eventually get messed up, and accounting will turn into guesswork.
- Expiration dates work correctly only when accounting by batches: one medication comes in different shipments with different dates, so write-offs should be made from the earliest (FIFO). This should be incorporated into the structure from the start.

Protection against negative write-offs: a simple formula will only highlight this, but a small script (Apps Script) can actually block saving—I'm using it for forms, warnings about low balances and expiration dates, and protecting directories from accidental edits. I say this honestly, as there is no strict blocking with just formulas.

Reports (balances, by period, by patient, by employee, medication history) are on separate sheets and update themselves.

Two questions to calculate accurately:
- Should the rights of the senior nurse (receipts) and the regular nurse (write-offs) be separated?
- Should write-offs be by batches with separate expiration dates, or is a general balance for the medication sufficient?

Approximately $50-100: a basic template is closer to $50, with forms and strict blocking via Apps Script closer to $100. I will provide the exact figure after your responses. Expand

Budget: 5000 UAH Deadline: 3 days

Good day, Denis!

I have reviewed your task. I can propose implementing the system not as a regular Google Sheet, but as a convenient workspace in Notion.

In the system, you can create related databases for medications and materials, batches, receipts, write-offs, employees, and patients. Balances, minimum stock, and expiration dates will be displayed automatically, and there will be separate convenient views for employees and the manager.

The advantage of Notion is that the team will not work with a large table and will not risk accidentally damaging formulas. Everyone will see only the necessary information, and the manager will have an overall dashboard with balances, critical items, and reports.

The cost of the service is $12 per month. At the same time, such a system will have the potential for further development: new modules, dashboards, automations, and integrations can be added without a complete overhaul.

I specialize in systematizing business processes in Notion and Coda and creating systems based on the real logic of the team's work. After completion, I will provide a video tutorial.

Are you ready to consider implementation in Notion instead of Google Sheets? Expand

Budget: 4399 UAH Deadline: 2 days

Hello!

I will do exactly what you need, without any extras. The main thing in such accounting is not the tables themselves, but that the nurse cannot break anything and that the inventory is always correct by itself — this is what I build on.

Everything revolves around one movement journal: when writing off, the nurse selects the date, patient, medication, quantity, and her full name from dropdown lists — and the inventory, reports, and history are calculated automatically from this journal, nothing needs to be maintained manually. There is protection against writing off more than is available, warnings about low stock and expiration dates, input validation, and conditional formatting — so that errors are visible immediately, and negative inventory does not appear at all.

Reports (current inventory, by period, by patient, by employee, medication history) — on separate tabs, updated automatically. Directories with the ability to add/remove, as you described. I work with Google Sheets and Apps Script, so I will make the automation reliable, not "on formulas that break at the first edit."

One clarification in private: approximately how many items are in the directories and how many write-offs per day — this affects whether to do it on pure formulas or to incorporate some Apps Script for speed. Write to me — we will discuss the project details.

Budget: 4400 UAH Deadline: 7 days

Hello! I have carefully reviewed the detailed technical specification. You described the classic architecture of a warehouse management system (WMS).

Since you prefer Google Sheets, implementing this solely with formulas (Excel standard) would be a mistake — formulas can easily be accidentally deleted, and implementing reliable "protection against over-issuing" with basic tools is impossible.

My technical solution:
I will develop a full-fledged application for you based on Google Sheets using Google Apps Script (Google's internal programming language) and the QUERY function.

Architecture: We will create separate protected sheets for Directories (Medications, Patients, Staff) and a single Movement Log (as you requested).

Safe input: Instead of nurses writing directly in the Movement Log, I will create an interface sheet called "Control Panel." There, they will select data from drop-down lists, enter quantities, and click the "Issue/Receive" button (the script will automatically transfer the data to the Log and block it from accidental editing).

Automation and Control:

I will write a validation script: if a nurse tries to issue 10 ampoules while there are only 5 in stock, the system will display an error and will not process the operation.

I will set up conditional formatting (red color) for medications that expire in less than 30 days and for those whose stock has fallen below the minimum.

Reports: I will implement this through the powerful QUERY function (SQL-like analytics in Google Sheets). Reports will be generated automatically for the selected period (by patient, medication, employee). Expand

Budget: 6000 UAH Deadline: 5 days

Good day, Denis!
I understand the task: accounting for consumables in the department — a materials directory, a log of incoming/outgoing (who, what, how much, when), control of stock with a warning about the minimum.
I see that most suggest implementation through Google Sheets + Apps Script — a workable option, but for daily use by nurses on-site, it may be inconvenient: they need to open the spreadsheet, search for the required row, and navigate the interface.
I propose an alternative — a Telegram bot for the same task:
— Material write-off — a few button presses (select material → quantity), without text input
— An automatic log of all operations linked to the employee (via Telegram account)
— Notifications to the responsible person when the material stock drops below the minimum
— Report on stocks/history — by command or schedule
Data is stored in SQLite/PostgreSQL — if needed, it can later be exported to Excel/Google Sheets for reporting. For medical staff, this is even faster and easier than a spreadsheet — no need to open anything separately, everything through familiar Telegram.
I have experience developing similar accounting Telegram bots with a database (portfolio on Freelancehunt).
Clarification: how many people approximately will be making write-offs daily, and is access needed from multiple points (different offices/employees)?

Rate: 6000 ₴, deadline: 5 days. Expand

Budget: 4400 UAH Deadline: 1 day

Hello! I can develop a convenient template for you in Google Sheets that fully automates accounting. It will include: directories, a goods movement journal, automatic write-offs of balances, as well as control of expiration dates and minimum stocks. The staff will find it very easy to work with thanks to drop-down lists — no manual calculations.

The cost of such a system is $50. If you are ready to discuss the details, write to me, and we will finalize the exact amount and deadlines!

Budget: 10000 UAH Deadline: 5 days

Good day, I am ready to complete your task turnkey, ready to discuss the details + further support, I have experience in executing such projects. Maximum simplicity for the convenience of the staff.

Budget: 4400 UAH Deadline: 2 days

Good day!

I propose to implement your system as a web application using PHP + MySQL. In my opinion, this will be the most reliable and convenient solution for such functionality.

Unlike Google Sheets, where delays may occur with an increase in data volume, the use of many formulas and scripts, a separate web system will ensure stable performance, convenient scalability, and comfortable user experience regardless of the number of records.

The system will include:

* directories of medications, consumables, patients, and staff;
* accounting for incoming and outgoing;
* automatic calculation of balances;
* control of minimum stock and expiration dates;
* protection against writing off beyond the available balance;
* a log of all operations;
* automatic reports on patients, staff, medications, and for the selected period.

The cost of the work is completely acceptable to me ($50).

Regarding the hosting of the system — I can host it for free on my own hosting so that you can test the functionality and use the system without additional costs. In the future, if needed, it can be easily transferred to your own hosting without data loss.

I will be happy to answer all questions and discuss the project details. Expand

Budget: 4400 UAH Deadline: 4 days

Hello!
I can implement such accounting in Google Sheets with separate directories, a single journal for incoming/outgoing transactions, and automatic calculation of balances.

I will add drop-down lists, data validation, protection against withdrawals exceeding the available balance, control of minimum stock levels, and expiration dates. I will also set up reports by period, patients, employees, and the history of movement for a specific medication. An important point is that it is necessary to keep records by separate batches, as one medication can have different expiration dates. The estimated cost of such a template is 2500 UAH.

Budget: 10000 UAH Deadline: 10 days

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

Budget: 4400 UAH Deadline: 4 days

Good day!

I see your task not as a full-fledged medical information system, but as a practical Google Sheets template for internal accounting of medications and consumables in a small department.

It is important to correctly gather the logic: directories → incoming → write-offs to the patient → balances → expiration dates → reports.

Within a budget of 3000 UAH, I can prepare a working template that will include:

— directories of medications, consumables, patients, and employees;
— a single movement journal: incoming, write-offs, corrections;
— write-off of a medication or material to a specific patient with the date, quantity, and employee specified;
— automatic calculation of balances;
— control of minimum balances;
— control of expiration dates;
— drop-down lists and data entry validation;
— conditional formatting for low balances and items nearing expiration;
— basic reports: current balances, usage over a period, by patient, by employee, history of movement of a specific medication.

Separately, batches with different expiration dates can be considered if one medication arrives on different dates. It is also advisable to use an internal ID or a minimal set of data for patients to avoid storing unnecessary sensitive information in the table.

The result will be a Google Sheets template and a brief instruction on how to use it and independently add new items, patients, and employees.

Important: this is specifically a template for internal accounting, not a full-fledged medical system with authorization, access roles, user action logs, and legal responsibility for medical data.

Deadline — up to 4 days after clarifying the details.

To start, it is necessary to understand: the approximate number of items, whether it is necessary to manage batches with different expiration dates, which reports are most important for daily work, and whether several people will be working simultaneously in one table. Expand

Budget: 4400 UAH Deadline: 3 days

Hello. I am an accountant by education and have a thorough understanding of the subject. I will complete your project according to your requirements and legislation.

Budget: 4400 UAH Deadline: 8 days

Hello
Is a web application being considered?

Option: web application instead of Google Sheets

I can offer not a spreadsheet, but a simple web application — more convenient for daily work, fewer input errors, clearer control of stocks and reports.

How it works

You open the site in a browser.
The head nurse enters the incoming stock; the nurse records the write-off for the patient.
The system automatically calculates the remaining stock, alerts about low inventory and expired items, and will not allow writing off more than what is in stock.
Reports — with one click for the period, by patient, by employee, by medication.
Server rental: approximately $3–5 per month (small VPS or cloud hosting).

Stack:

Frontend: React or Next.js — convenient forms, dropdown lists, tables.
Backend: Node.js (NestJS/Express) or Python (FastAPI).
Database: PostgreSQL.
Hosting: VPS (Hetzner, DigitalOcean, etc.) or Railway/Render.
Functionality

Directories: medications, consumables, patients, employees (adding/editing/deleting prescriptions).
Movement log: incoming stock, write-offs, manual corrections — all in one history.
Write-off: date, patient, item, quantity, nurse's full name → automatic reduction of stock.
Incoming stock: date, item, quantity, source, expiration date.
Automation: stock levels, minimum inventory, expiration dates, alerts, protection against over-writing.
Reports: current stock; usage over the period; by patient; by employee; history of medication movement.
Access: separate accounts (e.g., head nurse/nurse), basic data protection.
Compared to Google Sheets: more convenient to work with, less risk of "breaking" formulas, better access control and scalability if the department grows.

I can send a more detailed technical specification and an estimated cost of development based on your volume — let me know if you're interested. Expand

Budget: 4500 UAH Deadline: 4 days

Good day.
I specialize specifically in automation in Google Sheets.

There are two ways to implement it:
1) using Google Sheets, formulas, and conditional formatting (cost 4500 UAH)

2) Google Sheets purely as a database, and the visual part can be made in the form of a WebApp on Google App Script. This way, any visual can be created, which will be much more convenient to use, without formulas that someone might accidentally delete (cost approximately 6500 UAH), but it depends on the access levels.
As far as I understand, there are 3 access levels:
1) admin, who can add employees
2) regular nurses, who can select patients and medications
3) senior nurse, who adds new drugs or consumables to the system
Is everything correct?

I developed an accounting system for a warehouse with addition/sale and separately write-off (when for some reason the product should be in stock, but it is lost somewhere, or the product needs to be written off due to damage or it may expire).
We also developed an inventory functionality. Do you need inventory?

I really want to work with you on such an interesting project, I will do my best.

The last WebApp I developed was an accounting system for vehicles in a fleet.

https://ibb.co/PGjjh5QP
https://ibb.co/67fVpchD

This entire system is stored on Google Drive without any additional costs for a server or anything else. Expand

Budget: 6000 UAH Deadline: 5 days

Good night
I am a software and game developer
Together with my team, we can develop a full-fledged website or software of any complexity, with Google Sheets integration
If necessary, you will be able to view and edit data directly in Google Sheets or work with it through a convenient interface of the application or website
Write in private messages — we will discuss all the details, your wishes, and offer the optimal solution
The cost and deadlines are approximate and depend on the scope of work

Budget: 6000 UAH Deadline: 1 day

Hello!

The task is clear — medical accounting on Google Sheets with Apps Script for automation. I implement exactly such solutions: directories, movement logs, automatic balance calculations, protection against writing off more than available, expiration date control, and 5 types of reports.

Regarding the budget — $50 will be too little for the full functionality described; the actual cost starts from $150. We will discuss the details and exact price privately.

I hope for cooperation!

Budget: 4400 UAH Deadline: 4 days

Hello, I can implement such a system. I will set up directories, a movement log, automatic calculation of balances, write-offs for patients, control of minimum balances and expiration dates, data entry verification, dropdown lists, and necessary reports.

I have experience in developing automation and accounting systems.

As a result, you will receive a ready-made template that will not require programming on your part: it will be enough to fill in the directories and work through the prepared forms and tables.

If needed in the future, the system can be expanded with new functionality.

The estimated cost for such implementation is $100-150, depending on the details and the scope of automation.

Please let me know if multiple employees will have access to the table simultaneously, and if access rights need to be differentiated (for example, separately for the head nurse and nurses)? Expand

Budget: 4400 UAH Deadline: 5 days

Hello, Denys! The task is clear: a template for tracking expenses in Google Sheets — directories, a single movement journal with auto-balances, control of minimum stocks and expiration dates, protection against negative write-offs, and auto-reports. I create such solutions in Google Sheets (+ Apps Script where there are few formulas).

Two levels:
• Basic — 4400 UAH, 4 days: directories (medications / materials / patients / employees), movement journal, auto-balances with formulas, drop-down lists, input validation, conditional formatting, reports (current balances, usage over a period / by patient / by employee, medication history).
• Full — 6500 UAH, 6 days: everything from the basic + Apps Script: convenient forms for write-offs/incomings, strict protection against writing off more than what is available, auto-alerts for low balances and expiration dates, protection of directories from accidental edits.

I recommend the full level — it specifically addresses the control of balances and expiration dates that you described. But the basic level is also fully functional.

Two clarifications:

How many positions are approximately in the directories and movements per day — to tailor the report structure?
Is a color warning in the table sufficient for expiration/balances, or do you need an additional sheet/notification? Expand

Budget: 4500 UAH Deadline: 2 days

Good day!

I am interested in your project. I have experience in developing automated spreadsheets in Google Sheets for accounting, reporting, and working with large datasets. I can create a convenient template with directories, a movement log, automatic balance calculations, data validation, dropdown lists, conditional formatting, and reports according to your requirements.

I will also implement control of minimum balances, expiration dates, and protection against writing off more than what is available. The template will be easy to use, so you can independently enter data later without additional settings.

I look forward to collaborating!

Budget: 4400 UAH Deadline: 5 days

Good evening, Denis!

I am ready to develop a reliable accounting system for your department in Google Sheets. I understand the logic of database construction, so I will ensure that the table works stably and protects against human error.

Here’s how I will implement it:

We will create separate reference sheets (patients, medications, employees).

In the main journal, we will set up drop-down lists. Nurses will not need to print anything manually — this will completely eliminate typing errors.

We will set up strict protection: the table will simply not allow the system to deduct a medication if its quantity in stock is zero.

Reports, current balances, and stock alerts will be calculated automatically.

I have one important clarification: do we need to consider expiration dates for different batches? (For example, so that the system suggests deducting the package that expires sooner first).

I will take a little extra time — 5 days. This time is needed not just to assemble the table, but to thoroughly test all formulas and protections.

I would be happy to discuss the details and start working! Expand

Budget: 4300 UAH Deadline: 5 days

Hello!

I can develop a structured template in Google Sheets for tracking medications and consumables.

I will implement:
— directories (medications, materials, patients, employees);
— movement log (incoming / write-off / corrections);
— automatic calculation of balances;
— control of minimum stock levels and expiration dates;
— protection against erroneous write-offs;
— basic reports (balances, usage by patient/employee/period).

We can start with a basic version (MVP) and expand the functionality as needed. Expand

Budget: 5000 UAH Deadline: 30 days

I can do it in Borland Delphi
without Google shits,

automatic calculation, database

Budget: 4400 UAH Deadline: 3 days

I am engaged in report development and automation in Google Sheets and Excel. I am ready to promptly and qualitatively fulfill your order. I have experience working on similar projects, always adhere to deadlines and technical specifications. I would be happy to collaborate!

Budget: 4400 UAH Deadline: 10 days

Good day!
I am a surgeon and a full-stack developer, such a combination) I know the nuances of working in the department and can create an accounting system for you. Message me privately, I'm interested in doing this.

Budget: 4400 UAH Deadline: 14 days

I have developed similar accounting systems in Google Sheets. I will create it with dropdown lists, calculations, and maximum possible automation. I also suggest using an additional Telegram Bot for faster data entry. The nurse will step-by-step select the necessary options for each item, confirm the entered data, and it will be transferred to the table. The senior nurse can also add entries from the Telegram bot. This data can be viewed and edited in the table.

Budget: 20000 UAH Deadline: 10 days

Hello!
I can offer a custom solution in the form of an application that can be used on both a computer/laptop and a phone.
With a proper database.
Everything turnkey, with roles, directories, analytics, reports, and deployment on the server and support.
Feel free to message me, I'm ready to communicate if you need a stable and convenient solution.

Budget: 4400 UAH Deadline: 2 days

Hello, Denys! I am very interested in your project. I have thoroughly studied both parts of your specifications. The specifics of accounting are completely clear to me, so I have already developed a ready prototype of this system in Python with full integration into Google Sheets! The developed complex already fully implements: Movement Journal (Single Table) — automatic registration of each incoming and outgoing operation with the date, full name of the nurse, patient, and quantity. Automatic reports — instant snapshots according to your requirements: current balances, usage for the selected period, expenses for a specific patient, employee performance report, and complete history of movement for a specific medication. Directories — convenient forms for self-filling and editing lists of patients and medical staff. Synchronization with Google Sheets — staff works in a simple web interface, and the entire database is instantly updated in your cloud Google Sheets. I propose to implement this project completely "turnkey" with further support and training for the staff for 4400 UAH. I am ready to demonstrate the operation of this prototype to you live right now! I will configure the system for your department in 1-2 days. Let's discuss the details in the chat!

Budget: 4400 UAH Deadline: 1 day

Good day! 🧡
I am ready to start working and would be happy to help with minimal deadlines 😉
I have experience working on similar projects. 🌼 (I have reviews on this topic and work in my portfolio)
I will do it in the best way possible and will start now! 🚀🛸✈️

Feel free to write, and we will discuss. I respond instantly!

Budget: 4400 UAH Deadline: 2 days

Good day. I have implemented over 70 databases in various projects. I can do it without any problems. Write to me. We will agree. Deadline: 2 days.

Budget: 4400 UAH Deadline: 5 days

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

If you are considering such an option, feel free to write, and we can discuss it.

Budget: 4400 UAH Deadline: 2 days

Good day. I developed a whole CRM system for order tracking in Google Sheets. I can easily create a materials consumption system for you. I will do it quickly and efficiently! The price is $100. Message me to discuss.

Budget: 4400 UAH Deadline: 3 days

Ready to develop a program with a web interface or a desktop version. I have experience in developing similar programs. I guarantee the completed work. The calculation of the exact cost will be after discussing all the details.

Budget: 4400 UAH Deadline: 2 days

Good day.
I am developing my similar system. It partially has what you need.
I can show it.
If you have any questions, you can write to me in private messages.

Budget: 12000 UAH Deadline: 7 days

we already have almost ready logic for such accounting, it can be quickly adapted for your department and launched in Google Sheets
I am in touch, we can discuss here on the marketplace and select a reasonable scope for the first stage ))

regarding the price, I would orient myself not at $50, but closer to 12,000 UAH for a working template
the term - 5-7 days, if without unnecessary bureaucracy and with ready names of directories

what we will do
- directories of medications, consumables, patients, and employees
- journal of incoming and write-offs
- automatic balances, minimum stocks, expiration dates
- protection against writing off more than available
- reports on balances, period, patient, employee, and specific medication
- drop-down lists, input checks, conditional formatting

An important nuance - for nurses, it is better to create not one chaotic table, but simple input forms and separate reports
otherwise, the table will quickly turn into a small theater of the absurd, rather than accounting =)

I will clarify 2 questions
- should the rights of the senior nurse and the ordinary nurse be separated
- should write-offs go by batches with different expiration dates, or is a general balance for the medication sufficient

similar experience
https://business.ingello.com/lita - medical direction, accounting processes and working with data
https://business.ingello.com/forma-crm - logic of directories, roles, journals, and reporting
https://systems-fl.ingello.com/ua - briefly about our approach to automation systems

if desired, we can start with a template in Google Sheets, and then, if the department grows, transfer this to a simple web cabinet without losing logic Expand