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

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: 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: 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: 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: 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: 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: 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: 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