Construction of an automatic scheme for the movement of goods and monetary flows

Budget: 2250 UAH Deadline: 3 days

I will start right away: on the first working day, I will show the correspondence of the Excel columns to the entities of the schema and the first generated fragment. I will implement a Python tool for repeatedly reading the agreed structure of the exports and building the schema according to your template, with validation on a sample of data. I work with the automation of structured data and reports. Can you confirm that the direction of each stream is clearly indicated in Excel?

Budget: 2500 UAH Deadline: 3 days

Good evening! I will do this with a script: it reads your Excel exports and automatically draws the flow diagram of goods and money based on the template from your file. A new export appears — you upload the file, and within a couple of seconds, you have a fresh diagram, without manual redrawing.

Stack: Python (pandas for parsing exports + Graphviz for the diagram itself). The output will be PNG and PDF; if needed, I can add a clickable HTML where hovering over the arrows shows the amount and period. It runs in two clicks on your computer, without reliance on paid services and subscriptions.

Such tasks are my daily work: parsing exports from databases, reconciliations, automated reports, and visualizations.

Two clarifications to avoid guessing about the template:
1. Are the nodes in the diagram the counterparties/warehouses or movement items? And is there a column in the export that clearly indicates the direction (from whom — to whom)?
2. Is the diagram needed as a static image for printing, or interactive, with amounts on the arrows?

The price is 2500 UAH, and the deadline is 3 working days from the moment I receive the example export and template. I am currently gathering my first reviews on Freelancehunt, so I am taking it at a starting price.

I can first create a small fragment of the diagram based on your real file so you can see the result before making a decision.

Petro Pankov, BotCraft Group Expand

Budget: 2000 UAH Deadline: 1 day

Hello.

I can write a script for you in NodeJS. Write to me, and we will discuss.

Budget: 24000 UAH Deadline: 10 days

маємо майже готову основу для такої автоматизації фінансово-товарних потоків, можна швидко адаптувати під ваш шаблон і формат excel-вивантажень =)

орієнтовно перший робочий варіант - 10 днів і 24000 грн.

зробимо імпорт excel-файлів, нормалізацію даних, правила зіставлення операцій, автоматичну побудову схеми руху товарів і коштів, а також оновлення схеми після нових вивантажень.

смотрите, тут нюанс... важливо побачити прикріплений шаблон і 1-2 реальні приклади excel-файлів, бо від структури колонок залежить складність логіки.

питання - схема має бути у вигляді окремого файлу, веб-сторінки, інтерактивної панелі чи всередині excel?

ще питання - дані завжди мають однакову структуру вивантаження, чи формати можуть відрізнятися між базами?

схожі за логікою кейси ingello
https://business.ingello.com/forma-bpm - автоматизація бізнес-процесів і логіки руху даних
https://business.ingello.com/platforma - корпоративна платформа з обліком, ролями і керуванням процесами
https://business.ingello.com/iks - система для складної внутрішньої операційної логіки

головний профіль для freelancehunt
https://systems-fl.ingello.com/ua

на звʼязку, можемо обговорити деталі тут і швидко зібрати перший робочий прототип. Expand

Budget: 1700 UAH Deadline: 5 days

Ready to implement the automatic construction of this scheme.

I have reviewed the sample file. I will set up a script that will read your primary Excel export files, link the chains "Supplier - Company - Buyer" by EDRPOU codes and nomenclature, and automatically build a finished scheme with all blocks and amounts.

Solution format: By choice - either an automatic macro/template in Excel/Power BI itself, or a standalone script with export to PDF/Excel.

Budget: 5000 UAH Deadline: 3 days

Hello! I am ready to automate the construction of commodity-money flow diagrams for you. Instead of manual drawing or complex macros, I propose writing a simple Python script. It will automatically fetch your raw exports from Excel, process the data, and instantly generate ready-made visual flowcharts (for example, using Mermaid or Graphviz syntax for rendering graphs). The result can be obtained in PDF format, as an interactive HTML page, or as an image. I would be happy to review your export files in private messages and discuss the details of the logic!

Budget: 2000 UAH Deadline: 3 days

Hello!
I have experience with similar tasks. I suggest we discuss the details privately to assess the scope of work and the execution plan. The price and deadline I provided are approximate.

Budget: 1500 UAH Deadline: 7 days

Good day, Dmytro!

My name is Vladyslav Kushnarov. I specialize in business process automation and data optimization. Let's discuss how we can implement automatic visualization of the cash flow scheme.

A few case studies from my work:
➡️ Freelancehunt

I am currently working on projects in Ukraine and the EU, where I achieve significant efficiency improvements. I am ready to show results that confirm my approach.

Having reviewed your request, I see opportunities for process automation based on data exports from databases to Excel. What specific data do you plan to visualize in the scheme? This will help focus on the most important aspects.

The preparation and implementation of the project may take from 5 to 15 days, depending on the volume of data and the complexity of the scheme. The cost starts from $500.

I suggest continuing the conversation in private messages or holding a meeting to discuss the details.

Do I understand correctly that the main goal is to create an automated scheme for effective management of cash flows? Expand

Budget: 2500 UAH Deadline: 5 days

Hello, Dmytro! The main thing in automating such schemes is to ensure the flexibility of parsing so that changes in Excel do not break the visualization. I have already implemented similar synchronization of financial data.

Which specific databases generate the exports and how often are the files updated?

Let's discuss the logic of the connections in the chat, and I will suggest an optimal integration scheme.

Budget: 1200 UAH Deadline: 1 day

Good day! I will do it quickly and efficiently!!!!
Feel free to contact me!!!!!!!!!!

Budget: 2000 UAH Deadline: 1 day

Good day, I will help you do it, write to discuss the details, thank you.

Budget: 3000 UAH Deadline: 5 days

Dmytro, it is important for you to structure chaotic exports from Excel into a clear visual model that will update automatically. I will help transform this raw data into a clear flowchart, where each transaction corresponds to the actual movement of goods or funds.

I will set up the connection between your files and the automatic display so that you can see the current status of processes without manual work on the spreadsheets. This will ensure transparency at all stages, from receipt to closing deals.

What is the volume of data in your source files and how often do you plan to update the chart?