
Closed
Posted
Paid on delivery
I want a small utility that reads my purchase and sales transactions, applies strict FIFO logic, and spits out a neatly formatted stock balance just like the sample below: Date Voucher Qty Rate 01-Apr Purchase 001 10 100 05-Apr Purchase 002 5 110 10-Apr Purchase 003 8 120 Sales in the period: 12 Expected remaining-stock view: Voucher Remaining Qty Rate Purchase 002 3 110 Purchase 003 8 120 Key needs • FIFO calculation must be exact, even when sales span multiple purchase lots. • The finished report has to arrive as a plain tcp/txt file; if it’s easier to generate in Excel or CSV first and then export, that’s fine as long as the final deliverable is the txt version. • Layout and column order should mirror the sample so I can copy-paste straight into my existing workflow. You’ll receive the raw data as a simple table (date, voucher, qty, rate, and a type field indicating purchase or sale). Send me back either: 1. a lightweight script (Python, VBA, or similar) with clear instructions, or 2. the one-off processed report plus brief notes so I can rerun it later. I’ll test by feeding a fresh data set and checking that the remaining quantities and cost layers line up with manual calculations. Once those numbers match, the job is complete.
Project ID: 40543249
27 proposals
Remote project
Active 3 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
27 freelancers are bidding on average ₹1,924 INR for this job

Hi, I’m Md Shahid Ansari. I’ll build a small Python utility that reads your purchase and sale table, applies exact FIFO logic, and writes the remaining‑stock view to a plain .txt file. The script will parse the CSV/excel you provide, keep cost layers, handle sales that span multiple purchase lots, and output columns exactly as in your sample so you can copy‑paste directly. If the source is a Tally export (TDL), I’ll adjust the parser accordingly. I have 2+ years of full‑stack and AI work, including finance‑focused projects like a Finance LLM Translator that generates MongoDB queries from natural language, and a bidding assistant that automates data handling with FastAPI. Those experiences gave me solid data‑processing and reporting skills. I’ll deliver a clean Python script with a short read‑me, plus the first processed report for your verification. Looking forward to getting this done for you.
₹1,200 INR in 1 day
2.1
2.1

Hi, a FIFO stock balance utility with clean txt output — this is straightforward. I'll write a lightweight Python script that reads your purchase and sales data, applies exact FIFO logic across multiple purchase lots, and outputs a neatly formatted txt report matching your sample layout precisely. The script will handle edge cases — sales spanning multiple purchase lots, partial lot consumption, and remaining balance calculation per voucher. You'll get clear instructions so you can rerun it anytime with a fresh dataset, no technical knowledge required. One question: will your raw data come as a CSV file, Excel sheet, or plain text table? That determines the input parsing approach. Ready to deliver quickly.
₹600 INR in 2 days
0.6
0.6

Hey, I can build a clean Python script that reads your purchase and sales data, applies strict FIFO logic across multiple purchase lots, and outputs a formatted txt report matching your exact layout. You can review my work here: https://www.freelancer.pk/u/UmairBuildsAI My plan for your project: Write a Python script that takes your input table with date, voucher, qty, rate, and type fields, processes sales against purchase lots in strict FIFO order, and outputs the remaining stock view as a plain txt file with the exact column layout from your sample. Script will be simple to rerun with any new dataset, no dependencies beyond standard Python libraries. Clear instructions included so you can feed fresh data and get results immediately. Can you share a sample of your raw input data so I can match the format exactly and test the FIFO calculation before delivery? Happy to jump on a quick call if needed. Best Regards, Umair
₹600 INR in 7 days
0.0
0.0

As an experienced data scientist, I am confident in my abilities to deliver the perfect solution for your FIFO Stock Report Automation. I have a deep understanding of using Python to manipulate and analyze large data sets as well as utilizing advanced statistical techniques such as regression analysis and machine learning algorithms. With this skillset, I can ensure that your FIFO calculation will be exact even when sales span multiple purchase lots. Moreover, I am extremely comfortable working with different data formats and have extensive knowledge of exporting data in various file formats including excel and CSV. So, generating the text file you require will present no issues for me. Also, my detail-oriented approach combined with my expertise in your mentioned fields: media, banking, financial services and insurances, make me uniquely suited for this task. My work speaks for itself; it is all about enhancing performance while minimizing errors which aligns closely with what the task requires. You can confidently rely on me to transform your existing workflow into a more efficient one. Let's get started!
₹1,050 INR in 7 days
0.0
0.0

Hi there, I reviewed your project requirements for the FIFO stock calculation utility. Since you need a lightweight, exact, and well-formatted solution that mirrors your sample layout, I am confident I can deliver this quickly. Using Python, I will build a clean script in my environment that perfectly processes your transaction tables (purchases and sales), applies strict FIFO logic across multiple lots, and outputs the exact .txt layout you need for your workflow. What I will deliver: A lightweight, commented Python script that handles the logic accurately. The exact column ordering and formatting matching your sample for easy copy-pasting. Clear instructions so you can easily rerun it locally with any fresh dataset. I am ready to start immediately and ensure all your manual test calculations match perfectly. Best regards,
₹1,050 INR in 1 day
0.0
0.0

Hello, I have carefully read your requirements. I can develop a Python utility that accurately applies FIFO (First In, First Out) logic to your purchase and sales transactions and generates the stock balance report in the exact format you require. The solution will: Implement accurate FIFO calculations. Process purchase and sales data correctly, even across multiple purchase lots. Generate the report in TXT/CSV format matching your sample. Include clean, well-documented Python code for future use. I focus on writing clean, reliable, and easy-to-maintain code. I will test the solution with sample data before delivery to ensure accuracy. I look forward to working with you. Thank you.
₹600 INR in 2 days
0.0
0.0

Hello, We have experience with Tally TDL customization and inventory automation. We can develop a FIFO stock report solution that automates inventory calculations, generates accurate reports, integrates seamlessly with Tally, and delivers reliable, easy-to-use outputs. Ready to start immediately. Regards, Acute Tech Solutions.
₹25,800 INR in 7 days
0.0
0.0

I can build a lightweight FIFO utility that reads purchase and sales transactions, applies exact FIFO logic, and outputs a neatly formatted stock balance in plain text. I’ll ensure the layout mirrors your sample so you can copy-paste directly into your workflow. You’ll receive either a Python script with clear instructions or a one-off processed report with notes to rerun later. My focus will be accuracy, simplicity, and reliability so your manual checks match perfectly.
₹2,500 INR in 7 days
0.0
0.0

Hi, I’m Yuvraj Singh. I’ll build a small Python utility that reads your purchase and sale table, applies exact FIFO logic, and writes the remaining stock view to a plain .txt file. The script will parse the CSV/Excel you provide, maintain cost layers, handle sales spanning multiple purchase lots, and generate output columns exactly matching your sample so you can directly copy-paste it.
₹700 INR in 5 days
0.0
0.0

Hi, I have already built and tested the FIFO Python script for your exact requirements. What it does: - Reads purchase and sale transactions - Applies strict FIFO logic across multiple lots - Outputs a clean formatted .txt report - Matches your sample output exactly I can deliver immediately — today. Please share your data and I will send the completed report and script within hours.
₹1,200 INR in 1 day
0.0
0.0

Hi there, I can create a lightweight, robust Python script to handle your FIFO stock calculations perfectly. I understand that accuracy is critical, especially when a single sales transaction spans across multiple purchase lots. What I will deliver: Accurate FIFO Engine: A script that reads your raw transaction table (Date, Voucher, Qty, Rate, Type) and cleanly deducts quantities step-by-step from the oldest available batches. Exact Formatting: The final output will be exported as a plain .txt file, matching your required layout and column order (Voucher, Remaining Qty, Rate) so you can copy-paste it directly into your existing workflow without any adjustments. Clear Instructions: I will include a brief, easy-to-follow guide on how to run the script and feed it new data whenever you need it. I am ready to test the script against your sample dataset immediately to ensure the remaining quantities and cost layers align perfectly with your manual calculations. Looking forward to working with you! Best regards, FARHAN ALVIAN
₹600 INR in 1 day
0.0
0.0

Hello, My name is Bharghav, and I bring a decade of experience in software development, specializing in Python to build precise data-processing tools. I focus on creating highly accurate financial and inventory automation scripts that handle complex calculations seamlessly. I understand you need a Python utility to automate your FIFO stock reporting. My solution will process your raw transaction data, map out each purchase lot, and apply strict FIFO logic to deduct sales across multiple cost layers. For example, your 12-unit sale will correctly reduce your first purchase lot to zero and the second to 3 units, leaving the remaining stock exactly as specified. I will write a clean Python script that exports this final, remaining-stock view into a plain TXT file, perfectly mirroring your required column layout for easy copy-pasting. You will receive the lightweight script along with clear, simple instructions so you can easily run it with any fresh dataset and verify the cost layers. Please open the chat so we can discuss your raw data format and get this automation built for you. Best regards,
₹1,050 INR in 3 days
0.0
0.0

I am a strong candidate for this project because I have experience working with Python and data processing. I can implement accurate FIFO inventory logic, handle sales across multiple purchase lots correctly, and generate the output in the exact TXT format you require. I write clean, well-documented code with clear instructions, ensuring you can easily reuse it with future datasets. I also verify the results against manual calculations to ensure accuracy before delivery.
₹1,050 INR in 7 days
0.0
0.0

Hi, Straightforward Python script — I can have this done quickly. Here's exactly what I'll deliver: • FIFO Engine — Reads your transaction table (date, voucher, qty, rate, type), processes purchases and sales in strict FIFO order, handles sales spanning multiple lots cleanly. • TXT Report — Output formatted exactly like your sample: remaining vouchers, quantities, and rates aligned in columns, ready to copy-paste into your workflow. • Reusable — Clean, commented script with simple instructions so you can drop in a new data file and rerun anytime without touching the code. Share your sample data file and I'll get it back to you fast. Anurag Nagare
₹1,450 INR in 7 days
0.0
0.0

Hi, I reviewed your requirements and can build a lightweight Python utility that reads the transaction data, applies strict FIFO logic, and generates the required stock balance report in the exact format you specified. I have experience working with Python for data processing and automation tasks, and I can ensure that the FIFO calculations remain accurate even when sales span multiple purchase lots. The utility can generate the report in CSV/Excel format and export it to TXT as required. I will provide clean, well-documented code along with clear instructions so you can easily run it on new datasets in the future. I am available to start immediately. A quick question: Will the raw data be provided as CSV/Excel files, or in another format? Looking forward to working with you. Best regards, Ayesha
₹900 INR in 5 days
0.0
0.0

"I believe I am a strong candidate for this FIFO project because I am reliable, adaptable, and committed to maintaining high safety and work standards. I can work effectively in remote locations, adjust to roster-based schedules, and perform well under pressure. I am a quick learner, a team player, and always willing to take responsibility to complete tasks efficiently. My dedication, discipline, and positive attitude make me well suited for a FIFO work environment."
₹1,050 INR in 7 days
0.0
0.0

Hi, I read your requirements carefully, and I can build a lightweight FIFO stock utility that produces the exact remaining inventory layers after applying strict FIFO logic. The script will correctly consume purchase lots across multiple sales, ensuring the remaining quantities and rates match manual calculations. You'll receive: - A clean Python script with simple instructions to run on any new dataset. - Output in the exact column order and layout you specified. - TXT report (with optional CSV/Excel generation before export if needed). - Well-structured, reusable code that's easy to maintain. Before I begin, I have one quick question: will the input always be a CSV/Excel file, or do you sometimes receive the data as a plain text table? I can start immediately and will validate the output against your sample to ensure 100% FIFO accuracy.
₹1,000 INR in 4 days
0.0
0.0

Hi, I have reviewed your requirement and can deliver this with precise FIFO layer tracking and accurate stock balance reporting exactly as specified. With 5+ years of experience in TDL development, accounting automation, inventory controls, and custom reporting, I have worked extensively on complex stock logic, valuation methods, and transaction-level reporting where accuracy is critical. The FIFO logic will strictly follow chronological purchase consumption, ensuring the remaining stock quantities and rates align exactly with the expected cost layers, even when sales span across multiple purchase lots. The final report will be delivered in your required TXT format with the exact structure needed for your workflow, along with a reusable utility and clear execution notes. My focus is always on accuracy, reliability, and validation, ensuring the output matches manual verification before final delivery. Ready to begin once you share the sample data. Regards, Arjun TDL Developer | Accounting Automation Specialist
₹1,500 INR in 7 days
0.0
0.0

Hi, I can deliver this today. I will write a clean Python script that reads your purchase and sale transactions, applies exact FIFO logic across multiple lots, and outputs the remaining stock as a formatted txt file matching your sample layout exactly. The script will handle cases where a single sale spans multiple purchase lots and will calculate remaining quantities and cost layers correctly every time. You provide the data as a simple table, the script processes it and writes the txt report. To rerun it on a fresh dataset you just replace the input file and run one command. I can deliver the script with clear instructions within a few hours of being awarded.
₹600 INR in 1 day
0.0
0.0

Hi, I’m Armin Nikdel. I can build this as a small Python utility that reads your date/voucher/qty/rate/type table, sorts the transactions, applies strict FIFO lot reduction when sales span multiple purchase vouchers, and produces the remaining-stock view in the same column order as your sample. I’ll keep the final output as a plain tcp/txt-style report, with input validation for missing or invalid qty/rate/type values and a simple trace so the remaining quantities can be checked against manual calculations. My bid is INR 1500 with delivery around 10 days. One detail before starting: will the raw data include multiple stock items, or is each file/report for one item at a time?
₹1,500 INR in 10 days
0.0
0.0

Mumbai, India
Member since Jun 27, 2026
€18-36 EUR / hour
$8-15 CAD / hour
$2-8 USD / hour
₹37500-75000 INR
$250-750 CAD
₹1500-12500 INR
₹1500-12500 INR
₹750-1250 INR / hour
₹75000-150000 INR
$25-70 USD / hour
₹75000-150000 INR
₹37500-75000 INR
₹100-400 INR / hour
$8-15 USD / hour
$30-250 USD
$2-8 AUD / hour
₹1500-12500 INR
$30-250 USD
₹600-1500 INR
₹5000-7500 INR