Đã Đóng

Update & Revise a Macro File ( Sales Report & Profit & Loss Statement)

( I posted this project few weeks back. a free lancer almost completed the first task 80% but then they disappeared and cannot get a response from them despite repeated reminders) , you will start from where they stopped and the last update they provided.

------------- original project details below--------------------- Note some part of first task are already completed - Read below sending your proposal----------

I have a MS excel Macro file, that is designed to use download from the selling and payment platform and calculate the profit for each item sold as well as accumulate the total sales and profit.

Due to some changes in the template of download file (source files ) from the selling plat from : the macros are not working as required. Hence I need someone with Advanced Excel and VBA skills to:

Part A:

1: fix the current file to match the changes ( with the source file) – 90% Complete

2. update formulas to match the Ebay Fee & Paypal fee rate changes ( My sales Record Tab & Inventory Tab)

3. add additional columns to match the changes ( Refund , promotions cost & Courier labels) ( My Sales Record Tab)

4. create new macros to add shipment cost from a new download files ( based on Courier Labels & dates) ( My sales Record tab & Dashboard)

5. update formulas in inventory sheet

6. Add Vendor performance ( New Sheet)

7. Ensure all formulas and macros are working perfectly ( e.g. when multiple items are sold in one transaction, macros can create separate record a single transaction to capture individual item cost, sale price , divided postage and

8 Dashboard is updated accurately

Part B:

Create a new summary report of

1. Overall financial statement : profit and loss & balance sheet ( i will provide the template as well as logic)

2. repeat buyers sheets

My current Macro file has no password and i want you to keep it like that.

Payment will be made in two part

1. 65% for completing Task 1 (100% satisfied and working)

2. 35% for completing Task 2(100% satisfied and working)

No milestone will be set.

Kĩ năng: Xử lí dữ liệu, Excel, Microsoft Office, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: profit loss statement freelance writer example, provide profit loss statement, profit loss statement word doc, quickbooks 2006 partner draws show profit loss statement, freelance graphic design profit loss statement, profit loss statement startup company, profit loss statement sample, simple profit loss statement freelaner, day profit loss statement, fake profit loss statement, freelance web design profit loss statement, accounting profit loss statement, can quarterly profit loss statement, excell format profit loss statement sample, word profit loss statement, profit loss statement report sample design

Về Bên Thuê:
( 3 nhận xét ) OAKHURST, Australia

ID dự án: #20419869

12 freelancer đang chào giá trung bình $58 cho công việc này

xinglong717

I have many experiences in Excel VBA. I can show you my projects via chatting. I can complete your project successfully. Thanks.

$200 AUD trong 7 ngày
(10 Nhận xét)
4.2
rashedkhanrubel

Hi, I have understand the project requirement & interested to update macro for this project. Please send a message so we can discuss more & start the project. Thanks.

$50 AUD trong 2 ngày
(8 Nhận xét)
3.3
vw64901vw

Hi there, I am a developer with over 20 years experience. I have written countless macros in excel and have always delivered for my clients. My rate is higher than most but that is due to my experience and ability. Thêm

$150 AUD trong 2 ngày
(6 Nhận xét)
2.8
ielucerotrad1

I can do the job, would need to check the excel file. I sorry for bidding over your project estimate but 30 AUS is about 3 hours of work. There's more than 3 hours work on this project. at least 10. I'm an engineer wit Thêm

$70 AUD trong 7 ngày
(6 Nhận xét)
2.4
diepkha

I am an expert in excel vba and google sheet. I have 6 years of experience in the field of reporting and data processing on Excel, google sheet. You can send that excel file to me, I will complete section 1 of Part A. Thêm

$20 AUD trong 3 ngày
(1 Nhận xét)
0.6
vk383808

Hi, I have understand the project requirement & interested to update macron for this project. Please send a message so we can discuss more & start the project. Thanks.

$20 AUD trong 2 ngày
(0 Nhận xét)
0.0
deeptisinghcs53

Efficient macro

$25 AUD trong 1 ngày
(0 Nhận xét)
0.0
ampactmedia

need to see the file first. need to see how the codes were setup in order for me to see my deliverables. i wont receive any payments until it’s done.

$35 AUD trong 1 ngày
(1 Nhận xét)
0.0
Technolinks

I am highly motivated internet marketing professional offering several years of experience in advertising on a multitude of digital platforms and social media networks. Creativity, the ability to generate new ideas w Thêm

$30 AUD trong 7 ngày
(0 Nhận xét)
2.9
tanuarya

Hi, I am financial analyst with expertise in excel. I have done similar projects like processing bank statments and preparing financial statements by automatic macro. I can complete your work, can you share your file a Thêm

$55 AUD trong 3 ngày
(0 Nhận xét)
0.0
Archpathsolution

I have Ready POS Application fully integrated with the inventory and accounting Point of Sale application its already running lots of retail store and supermarket in Saudi Arabia Market I have Online web version Offlin Thêm

$20 AUD trong 90 ngày
(0 Nhận xét)
0.0
NiharikaH

Am proficient with Excel VBA and macros and am good at understanding pre-written code and building on it. Relevant Skills and Experience MS Excel VBA, Macros, Programming skills

$25 AUD trong 10 ngày
(0 Nhận xét)
0.0