Maksym Kamenchuk

Maksym Kamenchuk

Winning proposal
1 0
  • Projects -
  • Rating -
  • Rating 397

Budget: 1000 UAH Deadline: 2 days

Olexiy, the key here is to separate the movement of raw materials from the movement of finished products; otherwise, the calculated balances will quickly diverge from the actual ones. I will create a Google Sheet with directories of nomenclature and recipients, a journal of receipts and shipments, and an automatic summary of current balances. For the warehouse manager, I will leave simple input through drop-down lists, while I will protect formulas and named ranges from accidental changes. In my automation for WooCommerce, product entries from Google Drive undergo structured processing before publication — I will apply the same principle of unified directories and controlled data movement here. Before transfer, I will check the receipts, write-offs according to the specification, and shipments to specific recipients on test entries. The cost is 1000 UAH, the deadline is 2 days after receiving the specification. Should the finished product be accounted for as a separate balance first, or should the raw materials be written off immediately during shipment?

  • Projects -
  • Rating -
  • Rating 472

Budget: 1000 UAH Deadline: 2 days

Hello! I have extensive experience in creating automated accounting systems in Google Sheets. I will implement a convenient structure for you: separate tabs for incoming items, specifications, and shipments, as well as a summary table of balances that will update automatically. I will use formulas (QUERY, VLOOKUP) or, if necessary, a small script for automatic deduction of materials when shipping finished products. Everything will work quickly and be clear for your warehouse manager. I am ready to discuss the details, feel free to write!

  • Projects 20
  • Rating 5.0
  • Rating 2 467

Budget: 1000 UAH Deadline: 1 day

Good day, I am ready to complete your task quickly and efficiently. I have extensive experience in creating various bots. Please write to me in private messages to discuss the details. I would be happy to help :)

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