Find Jobs
Hire Freelancers

I need a basic program to automate my accounts in excel

$30-250 USD

Completed
Posted almost 3 years ago

$30-250 USD

Paid on delivery
need a simple program that I can import three excel documents that will sort my accounts easier. At the moment I am manually doing it. There will be the main accounts document with all my business sales and calculations in excel Second document will show all the success fees in % and delivery fees in excel that need to be changed in the master excel doc ( you will find the success fee % and delivery fee based on the order number ) Third document will show the costs of the products in excel which need to link to the order number row and added into a specific cell. So the program will input each sold product's success fee % based on what the order number is, the delivery cost will be changed the same way as Keep note some orders could be any amount not just 1, I will have a field that says how many were sold. The program will put a value of 0 on all the orders that have been cancelled, returned ect. The program will then compile the data and at the end I will be able to open an excel doc that will show the correct profits.
Project ID: 29906662

About the project

35 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Lets do a meeting. Hi i am an Senior Excel VBA Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.
$73 USD in 1 day
4.8 (115 reviews)
5.4
5.4
User Avatar
Good morning sir, My name is siva kumar from vizag. I will complete your project as soon as possible. Please share any sample links. Also, i am offering my services for free of cost for one month to prove my talent. Please give a chance to get the project. Thank you, Siva kumar +91-9493863848
$30 USD in 4 days
0.0 (0 reviews)
0.0
0.0
35 freelancers are bidding on average $141 USD for this job
User Avatar
Dear Employer, I am an Excel expert and have delivered over 1000 projects since over a decade now. I have checked your project details and will ensure highly professional delivery. Kindly check my previous reviews here for your kind consideration: https://www.freelancer.com/u/asin1987 Hope to connect soon!! Thanks, Ashish
$250 USD in 3 days
5.0 (290 reviews)
8.3
8.3
User Avatar
Hello, This is sree, I'm a programmer. I have worked for many clients in this type of platforms. I write programs, that can read the data from websites or files and produce the exact output you want. I will write program you have to press a button and wait for the data.
$140 USD in 3 days
5.0 (210 reviews)
7.4
7.4
User Avatar
Hi, I am well versed with automation in Excel using VBA/macros and can help to automate the accounts in Excel. Please share the files you are having. Keen to work on this. Looking forward to your response. Thanks
$100 USD in 2 days
4.9 (219 reviews)
6.8
6.8
User Avatar
✅ Expert on Advanced Excel ✅ Hi there! I read your project description I can build a VBA script for combine 3 excel sheet and generate profit. I'm expert on finance & accounts, vba, macro, nested formula & fuction, power query, power pivot, graph, chart, dynamic dashboard, conditional formatting, dropdown, data validation and advanced excel automation related various task. Knock me over chat so, we can discuss further and start work. Regards Javed
$111 USD in 3 days
4.8 (79 reviews)
5.7
5.7
User Avatar
I have extensive amount of experience in Data Entry, Excel, Internet Research, Research, Web Search, Lead Generation, email listing, Data Mining Project Emails. I would like to work on this project and can complete with 100% accuracy within the time frame. Quality is assured. “Waiting for your reply”. Kind Regards, Batairy
$110 USD in 1 day
5.0 (72 reviews)
5.4
5.4
User Avatar
Hi, Greetings! ✅checked your project details. I can help with automate accounts data in excel I have completed the M.SC. (Statistics) . I Have 4 years of experience with Data entry, Data analysis, and MIS Management. I have strong analysis, and Excel/google sheet skills and am able to provide solutions to most Excel/google sheet problems, including VBA programming. If you work with me you will get good value for your money and a flexible approach to carrying out your work. I am great with deadlines and I will keep you updated throughout the process and the quality of my work is high. Please Ping me the chat box for further discussion. Thank you.
$180 USD in 3 days
5.0 (27 reviews)
4.5
4.5
User Avatar
Hi, this is just what I can do. I can do this in python. I will create a program for you in python that manages the excel files. I have very good skills in python excel modules, I will deliver perfect results very quickly. I will automate your manual work by doing some calculation on your excel files. Let's discuss in chat. Regards
$140 USD in 7 days
5.0 (12 reviews)
4.4
4.4
User Avatar
Hello, I am software developer more than 10 years. I have developed desktop apps with Vb.Net and MS SQL database in my first job. I have co worked with senior software developers of Microsoft. I was a member of team which have developed national vehicle registry software. I have hands on experience in object oriented programming, multi threading, web services, relational database design. As a freelancer, I have completed tasks about C#(Win32),VB.Net(API/JSON),Java(Optimization Software), Python-Script development-fix and Excel/VBA fix. I am ready for working on the explained excel task. Regards.
$60 USD in 3 days
5.0 (7 reviews)
4.0
4.0
User Avatar
Hi, there. I read your project details and I have many experiences in developing applications by using VB with excel files. I am sure to complete your project on time. please contact me and let's discuss about your project. I can start working right now. Thank you.
$140 USD in 2 days
5.0 (5 reviews)
2.5
2.5
User Avatar
Hello, you can use the POWER QUERY function of EXCEL to combine the three EXCEL files query, respectively, to obtain the amount of sales, sales costs, distribution costs, etc., set the calculation formula to get the profit data, and finally return the information needed to the EXCEL table. Later, just update the EXCEL file in the specified folder, and then refresh the data to get the profit data. Looking forward to working with you, thanks!
$35 USD in 1 day
5.0 (7 reviews)
2.6
2.6
User Avatar
Hi. I will create your accounts automation program. I have over 4 years of experience with Automated and Scraping Bots and have done a lot of stuff like yours. Just contact me and we will discuss the details further. Regards.
$100 USD in 1 day
5.0 (3 reviews)
2.3
2.3
User Avatar
Yes! In general Hello , i have read your instructions and ready to do your work! you can inbox me to see my portfolio , i will really appreciate if you have time to inbox me ::) im ready to help you waiting for your kind-response
$222 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hii guys but not use the freelance withdrawal problem anyway no problem with the whicher season 1 and refer to the same as last year and
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have experience in C# .net desktop application. I have fully understanded your requirements. I will make a application that will do your exel related work and make proper report.
$35 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi There, We are a team of CPAs’ with Big4 background starting a freelance start-up. We believe in customer satisfaction and meeting up the deadlines ensuring quality and consistency. I read the task description. We have a firm grip on this task. We have a team of professional financial controllers and CFO, providing services such as: • CFO Services • Accounting & Bookkeeping • Business Advisory • Financial Analysis • HR & Payroll We assure you, we will handle this task and achieve your best satisfaction level and you will get the best services on this platform. I'll send you the sample reports as per your demand to analyze the quality and detailed work we produce. We are looking forward to your response. Best Regards Team Analytica
$140 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I read your project details. I am expert in excel. I can help you making a automation your calculations in excel.
$133 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there! I'm Mircea, a data analyst, Excel, and Access developer. I use Excel daily with advanced formulas. I can help you to complete your job accurately. I have a financial/accounting background so I think this project suits me. Contact me for more details, I think is a easy job for me ;)
$200 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I can make the macro by using VBA and if you want can analyze your data by PivotTable. I can design for you dynamic dashboards for data. I can use a lot of functions to make our work is easy. I am an expert in Excel and all programs of Microsoft office. I am looking forward to working with you and I will start now. Regards, Hossam
$120 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have so much experience on Excel/Macros/VBA for more than 11 years. I am pretty sure I can help you to get a great result. We can chat to discuss details and be more assertive in what you want but I guess that some User Form and some Macros will solve your issue. Thank you!
$70 USD in 2 days
5.0 (1 review)
0.0
0.0
User Avatar
Supplier based in the UK. We would take the spreadsheets and combine them using Microsft Access. We can then create a variety of exports and reports as required. We completed a similar project for a large retail company to produce delivery information such as packaging labels, packing slips, delivery notes and csv exports.
$300 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SOUTH AFRICA
Johannesburg, South Africa
5.0
8
Payment method verified
Member since Mar 28, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.