Freelance projects

Freelance projects

Automation of reports on balances and non-liquid assets from "MyWarehouse"

Desktop Apps — incorrectly specified categories?

50 USD

Project translated automatically. Log in or register, to view the original

Goal:

Automate the process of generating the final report on non-liquid assets based on several exports from the "MyWarehouse" system. Currently, the process is performed manually using VLOOKUP formulas in Google Sheets. It is necessary for the final report to be generated automatically after uploading the source files.

➡️What exists now:

1. 3–4 different reports are exported from "MyWarehouse" in .xlsx or .csv format (for example: balances, sales, purchases, turnovers).

2. These tables are manually combined in Google Sheets using VLOOKUP by product code.

3. After manual combination, a final table is created where indicators are calculated based on the exported combined data.

➡️What needs to be done:

Create a tool (Google Sheets + Apps Script or another approach) that allows:

1. Upload files (for example, 3–4 reports from MyWarehouse in Excel or CSV format).

2. Automatically combine them by product code (similar to the current VLOOKUP formulas).

3. Build a final report with the necessary columns and calculations.

4. Implement the ability to update the report when new exports are uploaded (without manual VLOOKUP).

5. Do everything in the Google Sheets environment (preferably without the need to install local software).

🙂Expected result:

A final table that is created automatically upon uploading the source files.

A button or clear instruction "upload new reports → get final report".

Ideally — the ability to update via Google Apps Script.

Proposals 6

Oleksandr Nazarov

15 0

Projects 16
Rating -
Rating 764

Budget: 65 USD Deadline: 3 days

I will do it, feel free to contact me.

Yevhen Naumenko

0 0

Projects -
Rating -
Rating 264

Budget: 500 USD Deadline: 5 days

Good day
I will write a script in PHP, working with CSV, XLSX, it can be done automatically through the API of Moysklad, I have extensive experience with this API.

Mihaylo Zubchenko

4 1

Projects 4
Rating -
Rating 336

Budget: 50 USD Deadline: 2 days

There is another option, I received information from Moisklad through the API. Therefore, you can receive information through the API in the same way, process it, and write it into Google Sheets in the format you need.

Giorgi Zenaishvili

5 1

Budget: 50 USD Deadline: 2 days

Hello! I have reviewed your assignment and believe that I can successfully complete it. I would be happy to collaborate, please write to me personally for further details.

Rostyslav Abramiv

12 1

Budget: 50 USD Deadline: 3 days

I am ready to promptly and qualitatively fulfill your order. I have experience working with similar projects, always adhere to deadlines and technical specifications. I will be happy to collaborate! Market research analyst, I am engaged in the development and automation of reports. Everything you described can be implemented through Google Apps Script.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Maria Afanasieva
Kishinev, Moldova

Projects -
Rating -
Rating 65

Automation of reports on balances and non-liquid assets from "MyWarehouse"

Oleksandr Nazarov

Yevhen Naumenko

Mihaylo Zubchenko

Giorgi Zenaishvili

Rostyslav Abramiv

Proposals are currently absent

Current freelance projects in the category Desktop Apps

App : Digital Marketplace for Skilled Trades in Morocco

Marketplace

Create a desktop module in C++, Firebird

Mobile application