Sales Record - Analytics, Formalization, Linkage , Macros and Automations

$30 AUD

Completed

Posted

over 7 years ago

$30 AUD

Paid on delivery

I have an excel sheet in which i manually update 1. Store Sales 2. Inventory 3. Expenses 4. Supplier Analysis 5. Profit ( Overall and for each item) 6. Return. [login to view URL] & Loss Statement 8 Balance Statement All this data is taken from EBay Sales Record Sheets Ebay Fees and Rates Fee Paypal statement Manual Inventory Sheet I need an automated Excel sheet where I could just download the above Reports and Copy / paste it in the template and and it can collate and update following information Update inventory Records Run analytics to inform update me on non matching or non aligned records Update most sales record fields ( item cost, item number, item code. pay pal code , pay pal fee, Sale Price , Postage sale, Profit , Aggregate and organise fees as per their types and items. Update supplier analysis sheet based on sales record filed Update profit Statement Update balance Sheet all information that I need.

Excel

Project ID: 12578706

About the project

18 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

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:

@inspireplatinum

Using Excel and managing data is critical for my job, so am proficient with formulas and additionally can code. Will be able and happy to do this project. Looking forward to hearing from you! (Please msg me, as bidders cannot msg)

$30 AUD in 5 days

5.0

(9 reviews)

4.7

18 freelancers are bidding on average $39 AUD for this job

@someka

Hi there. Let me write the automation macros for your excel file so that you wont need to manually copy/paste anymore. Let me know. Thanks...

$84 AUD in 2 days

5.0

(141 reviews)

7.1

@citijayamala

Expert in Excel, Excel formulas, and all excel functions, macros, lookup concepts. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Can complete on time with good quality and on time. Expert in referencing and will deliver work with no plagiarism. Experienced MBA Finance as well.

$55 AUD in 1 day

4.8

(69 reviews)

5.7

@Diliphero

Greetings, I am professionally qualified Accountant from Sri Lanka with A degree in Management & Finance. I am a full-time freelancer. I have 13 years of experience in Audit & Financial Consultancy in the corporate sector. My duties included Unit costing, Cost departments, Selling price evaluation, Pricing for tenders, Audits, Budgeting, Variance Analysis, Financial Accounts, Management Accounts, Unit costing, Bookkeeping, Payroll, HR, cash flows, Project appraisals, Etc. I am familiar with web based accounting systems, Quick Books & MS office, especially with Excel. I have the experienced in handling logistics, Inventory, Etc. I have the experience in maintaining similar types of documents for my works as well, Hopefully, my skills meet your requirements. Look forward to discussing with you the opportunity further. Kind regards, Dilip.

$50 AUD in 1 day

4.8

(14 reviews)

4.8

@Goalaholic

I have been working on excel for the past 5 years. I have worked on automation on excel many times. Further assistance will be provided if required

$35 AUD in 1 day

5.0

(18 reviews)

3.8

@ujjwalconcepts

A proposal has not yet been provided

$35 AUD in 2 days

5.0

(2 reviews)

0.7

@hma195

Hello i want to inform that i have a full grip on excel . i assure you that you will get the quality work in time . your satisfaction and confidentiality is my priority . feel free to contact me

$30 AUD in 1 day

0.0

(0 reviews)

0.0

@niluka840429

Hi, I'm very interested to do your project. I have great knowledge on about your project. I have already read your description and I feel like I would be a great fit for the project. I can start your project right now. I have extensive data entry experience. I have huge knowledge Data entry advantage other task easily and having ability to give back to you fine result. So you can select me for a good result. # My objective is to provide 100% fast and accurate service to my client. # Organize data before inputting. # Attention to detail and accuracy when inputting information. # knowledgeable in microsoft office. I;m hard worker and my goal is client satisfaction to provide the best quality services. Thank You for your time and consideration. sincerely, Niluka

$30 AUD in 1 day