Create a First-In-First-Out table for maintaining Accounting.
22 USD Hello. I need a professional in the field of accounting to create an Excel table for calculating the total monthly profit from transactions based on the First-in-First-out principle.
I need the calculation of realized profit considering the fee: for example, I purchased 100 units of material at 10, but I only sold 50 units at 15 + for both transactions I paid a fee of 1 UAH. In total, 50*15-50*10= 250 - 2(fee) = 248 net profit.
I need a table that will calculate based on this logic for 1000-2000 operations per month, and will also gather the necessary metrics for statistics based on the data.
Client's review of cooperation with Artem K.
Create a First-In-First-Out table for maintaining Accounting.Everything is great, I consulted, provided all the results, and helped with understanding. I recommend.
Freelancer's review of cooperation with Alex Atamanyuk
Create a First-In-First-Out table for maintaining Accounting.Responsible, communicative Client. The task is interesting in its own way. I recommend for collaboration.
-
1 day22 USD
375 1 day22 USD
Hello. Experience in finance is 8 years, of which 6 years are in digitalization and optimization. There is an opportunity to complete it today or tomorrow. Tools at your discretion: Excel / Google Sheets visualization Looker Studio / Power Bi. I will make it convenient to interact and analyze quickly.
-
5 days22 USD
613 7 1 5 days22 USD
Hello. I consider the FIFO method to be the best and simplest, compared to the weighted average.
Based on Excel, such a system can be built; I can show several options of ready-made solutions that I have developed.
I have a large number of positive reviews, I am a professional financier. I work as an individual entrepreneur in the 3rd group.
-
Winning proposal2 days22 USD
2247 35 0 Winning proposal2 days22 USD
Hello, I am ready to help with the task. I am well acquainted with financial logic, and my Excel skills are professional. I will propose an optimal solution. Feel free to contact me.
-
5 days22 USD
76 5 days22 USD
Good day!
I am interested in your vacancy, as I have experience in accounting financial transactions and creating automated spreadsheets in Excel. I can build a table for calculating realized profit based on the FIFO (First-In-First-Out) principle, taking into account fees, even for a large volume of data — 1000–2000 transactions per month.
The table will implement:
automatic profit calculation for each transaction;
consideration of fees for buying and selling;
…
summary metrics: total profit, average margin, turnover, number of transactions;
convenient filters and reports for analysis.
I can create a fully automated template (with formulas or VBA, if needed).
I would be happy to discuss the details — timelines, data format, and examples of transactions.
-
2 days22 USD
986 12 1 2 days22 USD
I am ready to promptly and qualitatively complete your order. I have experience working with similar projects, always adhere to deadlines and technical specifications. I will be happy to collaborate!
-
1 day22 USD
1312 37 0 1 day22 USD
Hello.
I have experience working with spreadsheets.
Let's discuss the details.
Current freelance projects in the category Data Processing
Building financial models (P&L + Cash Flow)We are looking for a qualified specialist who can help organize our business finances. We need to develop and implement two key reporting forms: P&L (profit and loss statement) and Cash Flow (cash flow statement). Please provide your work experience, what you have worked on,… Accounting Services, Data Processing ∙ 2 days 8 hours back ∙ 17 proposals |
Assistant to the manager for project work in the field of science and scientific publicationsLooking for a responsible assistant to work with personal social networks, a contact database, and current projects in the field of science and scientific publications. At the first stage, the collaboration is planned for one month. The main task is to assist with basic… Information Gathering, Data Processing ∙ 3 days back ∙ 10 proposals |
Contacts of the Northern European countries
28 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 4 days 23 hours back ∙ 21 proposals |
Search for contacts_Southern Europe (Greece, Italy, Spain, and France (south and north of the country))
22 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 5 days back ∙ 19 proposals |
Search for manufacturer / contract manufacturing Ukraine
22 USD
Need to find 3 contract manufacturers of dietary supplements in the form of gummy candies in Ukraine or nearby countries (Hungary, Poland), and inquire about the terms of cooperation: - minimum order (price) - price for increased volume - number of functions they can produce?… Marketing Research, Data Processing ∙ 7 days 9 hours back ∙ 14 proposals |
Kyiv