Vadym P.
Offer Vadym work on your next project.
Private message 
Offer work 
Kharkiv,
Ukraine
4 months 27 days back
available for hire
on the service 7 months
Rating
Successful projects
Average rating
Language proficiency level
Українська: fluent
Skills and abilities
Programming
Services
-
Data Processing
from 11 USD for project
-
Enterprise Resource Planning (ERP)
from 11 USD for project
Portfolio
-
Automated warehouse accounting system in Google Sheets
Enterprise Resource Planning (ERP)
System Capabilities
Product catalog with articles, categories, units of measurement, and minimum stock levels.
… Directories of suppliers, carriers, and recipients with convenient dropdown lists.
Separate sheets for "Receipts" and "Shipments":
automatic pulling of name, category, and unit of measurement by article;
quick and error-free entry of operations.
Main sheet "Warehouse":
automatic creation of product upon first receipt or shipment;
automatic calculation of current stock levels;
weighted average cost and total value of the warehouse;
display of the last purchase price and supplier;
highlighting products below minimum stock levels.
Dashboard with key indicators and charts (customizable individually).
Filters on all sheets for quick search, sorting, and analysis of products and operations.
Protection of sheets and the ability to enter data via Google Form from a phone.
Business Advantages
fully automated accounting without manual recalculation;
instant detection of products that are running low;
detailed history of product movement and purchases;
suitable for both small warehouses and large assortments;
easily adaptable to any type of business: manufacturing, retail, wholesale, auto service, online store.
Demo: https://docs.google.com/spreadsheets/d/1kCceLmYmQPqKTFnawQMKCuQUUdB8EiV2lhPx_As2J88/edit?usp=sharing
-
Automated payroll accounting system in Google Sheets
Data Processing
This project is a modern alternative to traditional Excel spreadsheets for payroll accounting in a small company (manufacturing/warehouse). I have developed a structure in Google Sheets that allows for the automation of calculations for accruals, deductions, payments, and debts for employees. The system consists of several sheets linked by formulas and scripts for convenient data entry and report generation.
Key features:
System sheets:
… "Employees": A directory with names, positions, phone numbers, salaries, and notes (with drop-down lists to avoid errors).
"Accruals": Accounting for worked days/hours, bonuses, and accruals for the period (formulas for automatic calculation).
"Deductions and Payments": Accounting for deductions (products, fines), cash payments, and debts (with automatic transfer of debt from the previous period).
"Piece Rate Payment": Accounting for piece rate payment by nomenclature (with price pulling from "Nomenclature Directory").
"Nomenclature Directory": A catalog of goods/services with prices for piece rate payment.
"Salaries" and "Positions": Additional directories for rates and positions.
"Payroll": Generation of a payroll report for printing (with a button on the script) — pulls data for the selected period, showing only active employees.
Automation:
Formulas (VLOOKUP, SUMIFS, INDEX/MATCH) for pulling data and calculations.
Google Apps Script for generating the payroll report: the accountant enters a date range, the script sums the accruals (from "Accruals" + "Piece Rate Payment"), deductions/payments (from "Deductions and Payments"), and forms a table for printing with columns: No., Name, Position, Hours Worked, Accruals, Deductions, Payments, Total to Pay, Signature, Debt at End.
Error handling: If there is no data — message "No data for the period."
Advantages:
Scalability: Easy to add employees/periods.
Convenience: Filters, drop-down lists, shared access.
Integration: Ability to add Google Forms for entering attendance/deductions.
This project optimizes accounting, reduces errors, and saves time. Developed based on real data from an Excel file, transitioning to an automated system in Google Sheets.
-
Mini-CRM system for sales management in Google Sheets
Data Processing
This project is a simple and effective mini-CRM system developed in Google Sheets for small businesses. It allows for tracking orders, customers, and products, as well as analyzing data through dashboards. The system consists of 4 sheets linked by formulas to automate processes.
Key sheets:
Orders: Entering new orders, changing statuses (for example, "New," "Paid," "Shipped"), calculating amounts. VLOOKUP formulas are used to pull data from other sheets.
… Customers: A list of customers with contact details, purchase history, and notes. Drop-down lists for quick input.
Products: A product catalog with prices, descriptions, and stock levels. Automatic profit calculation.
Dashboards: Data visualization — total sales, top products by sales, top customers by profit. Charts, SUMIFS formulas, and conditional formatting are used to highlight key metrics.
Features:
Automation: Drop-down lists for statuses, customers, and products; VLOOKUP/SUMIFS formulas for calculating amounts, profits, and analysis.
Conditional formatting: Color highlighting (for example, red for overdue orders, green for top products).
Scalability: Easy to add new entries, the system updates automatically.
Integration: Ability to import data from other sources (for example, Google Forms for new orders).
This project helps optimize sales management, reduces errors, and saves time. Designed for quick implementation without additional software, focusing on convenience for small businesses.
Activity
| Latest proposals 5 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
Data entry into the database
77 USD
|
|||||
|
Google Sheets and DASHBOARD Setup - Business ANALYTICS
23 USD
|
|||||
|
Editing the database in Excel
16 USD
|
|||||
|
Excel document for calculating the cost of 3D printing
16 USD
|
|||||
|
Tables for online school
226 USD
|
