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.
24 freelancers are bidding on average $190 for this job
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.
Vast experience in excel and it's utilities. Have developed numerous macros using vba Relevant Skills and Experience Excel, Data processing, Data analytics, Macro