Closed

Hire an Excel Expert

I sell an a magazine through around 240 outlets each week (this will increase to 2/3 products shortly).

I want to create a new system of managing all of our data. Sales data (Magazine Sales & Advertising Sales), I want the system to produce Invoices automatically when the sales are keyed in and manage payments received and outstanding. All expenses to be put into the same system and all of the data used to produce a P & L Account. From all of this data I want to produce a number of reports (Year on Year sales and Waste by Outlet, Delivery Driver & Company Total). Outstanding Debtors.

We also produce a delivery document for our drivers so I would want the last weeks sales data to populate next weeks delivery paperwork with the ability to change the route of the delivery driver.

I want an outlet control sheet where we enter all details for new outlets, the opening date and if they close the closing date, which delivery driver they are allocated to and the ability to decide whee they appear on the delivery drivers order sheet easily. I want a simple way to move the outlets between Delivery Drivers so that all of the existing data goes with the the change of driver.

I will need the flexibility to change IVA Tax percentages.

This should be enough to give you an idea of what I require.

Thank You

Brian

Skills: Excel, Excel Macros, Excel VBA, Visual Basic

See more: how to hire excel expert, hire excel expert tel aviv, hire excel expert for 2 hours, excel expert for hire melbourne, excel expert for hire las vegas, excel expert for hire in delhi, excel expert for hire, where can i hire excel expert, i want to hire an excel expert in the leesburg va area, hire excel expert, Hire an excel expert, excel expert sg hire, excel expert services for hire, excel expert on hire, excel expert hire

About the Employer:
( 17 reviews ) faridabad, India

Project ID: #15865289

24 freelancers are bidding on average $190 for this job

Joni058

Dear i 'll be greatful to you if you give me a chance to prove myself. Please please please Thank you

$30 AUD in 1 day
(2 Reviews)
0.0
manneabhinay5

Quality & Efficenby of the report are gauranteed, don't have to pay single penny if you either of quality & Efficiency are not upto the satisfaction levels. Relevant Skills and Experience Expert in Excel with extensiv More

$133 AUD in 5 days
(0 Reviews)
0.0
sardaaditya28

I have more than 3 years of expertise in this , creating database and turning excel workbook into an automated model, i work in a US Based consultancy where model development from scratch is my job Relevant Skills and More

$133 AUD in 3 days
(1 Review)
0.0
AnilTitusJacob

Hi Brian, You have described the requirements well. We would need you to guide us reg the exact data fields to be stored, calculations and reports to be created. We will use VB logic and automate. Relevant Skills and More

$222 AUD in 10 days
(4 Reviews)
0.0
abhisheaknagar

I can do this quite easily and I can even do it for very small amount because I want good review and feedback after completing this project. Relevant Skills and Experience Excel Macro and VBA Proposed Milestones $1 A More

$30 AUD in 3 days
(0 Reviews)
0.0
abhayk007

I have created similar system for Buy, Sale which provide invoice generation, Report generation, Demo can be provided. Most of the code can reuse and can deliver suggested functionality quickly Relevant Skills and Ex More

$155 AUD in 3 days
(0 Reviews)
0.0
Ashisjena2015

I am a chartered accountant having experience of more than ten years in accounting and finance. please check my profile for review and trust as I did similar work on past. I am also an advanced excel expert.

$150 AUD in 3 days
(15 Reviews)
0.0
Edula123

I have 5+years of experience in working with excel macros

$155 AUD in 3 days
(0 Reviews)
0.0
chintuag

I am an expert in excel and have worked on various automation projects Relevant Skills and Experience My skills includes: Macros, Web Scraping, User Forms, Reports, Dashboards, Customized Ribbon Buttons, Interaction w More

$223 AUD in 5 days
(12 Reviews)
0.0
zu02

Hi, I viewed your requirements. In my view the best way to build Ms access software. I'll build that , it will be fully functional on your need, with very simple and friendly interface. Relevant Skills and Experience More

$833 AUD in 11 days
(29 Reviews)
0.0
$55 AUD in 3 days
(0 Reviews)
0.0
tarun9450

Vast experience in excel and it's utilities. Have developed numerous macros using vba Relevant Skills and Experience Excel, Data processing, Data analytics, Macro

$155 AUD in 3 days
(0 Reviews)
0.0
JackieXu

hello. how are you? i am expert of Microsoft Excel, excel VBA and data analyst. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best regard. Relevant Skills an More

$133 AUD in 3 days
(20 Reviews)
0.0
sathishKumarmcom

I know, All the functionality of Excel. Relevant Skills and Experience I have 5 years Experience in Account field. Have deep knowledge in P&L and Tax system. Proposed Milestones $144 AUD - Complete work on time as pe More

$144 AUD in 3 days
(0 Reviews)
0.0
abhinovpankaj

I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Relevant Skills and Experience -- VBA and Excel,Word,Office Applications -- Expert on C# More

$155 AUD in 3 days
(50 Reviews)
0.0
engamrashraf1

i have worked on similar projects and sure can create a new one customized on your specific needs. looking forward to cooperate with you. Relevant Skills and Experience Engineering background, Excel Expert, Business D More

$200 AUD in 5 days
(0 Reviews)
0.0
joshkindy

It Sounds like you Need a Database. I Built something Similar for another Business, Monarch Welding & Engineering. I Built a System to Track their Timekeeping on Many different Jobs. Relevant Skills and Experience Exc More

$170 AUD in 3 days
(0 Reviews)
0.0
zeeshanabrar

I am a Certified Microsoft professional and have handled projects with similar requirements in the past. I would love to have a chance to help you on this project. Relevant Skills and Experience - Ability to write qui More

$250 AUD in 3 days
(0 Reviews)
0.0
iftikharahmed321

Hi Hiring manager I’m ready to complete this task for you [url removed, login to view] contact me for farther discussion. I hope I’ll hear a good from you

$30 AUD in 1 day
(1 Review)
0.0
infotechjpm

Hello, We have put a glance to your job details and we are quite interested to do this job. Let us tell about our experience. Since last 6 years we are in Data Entry profession. Relevant Skills and Experience Excel, More

$250 AUD in 3 days
(0 Reviews)
0.0