Advanced Excel Template or Access Database

Cancelled Posted 7 years ago Paid on delivery
Cancelled Paid on delivery

I have an excel sheet in which in 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 sheet or Access database - where i could just download the above excel sheets and upload ( or Copy paste) and it can collate all information that I need.

Accounting Excel Finance Financial Analysis Microsoft Access

Project ID: #12526657

About the project

42 proposals Remote project Active 7 years ago

42 freelancers are bidding on average $200 for this job

P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$250 AUD in 3 days
(495 Reviews)
8.0
someka

Hi there. If your data doesn't exceed million records I recommend we stay in Excel and make a "backend" & "Frontend" structure. I have prepared many similar studies and clients were quite happy. Let me tell you how we More

$315 AUD in 3 days
(146 Reviews)
7.3
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More

$250 AUD in 3 days
(329 Reviews)
7.5
shikhamehta

Hey, i am an expert in excel and have done almost similar projects for some of my clients. i can create an automated system that will allow you to import the files and create the necessary reports on click of a button. More

$277 AUD in 10 days
(116 Reviews)
6.7
KavTan

I am an Expert in MS Office, can be a useful asset to your kind of project with faster resolution and Complete satisfaction.

$300 AUD in 10 days
(59 Reviews)
6.4
zu02

Hi there, if you'd really like to have a professional Ms Access(from your Excel sheets) software for your project , here is my introduction: I’m an Access/VBA programmer, a mathematician and a full time developer w More

$555 AUD in 7 days
(76 Reviews)
6.5
haibg2111

Dear the client, I read your job posts very carefully, You want to keep track of your profit and expenses by category, suppliers... My name is Hai. I'm an expert in both excel VBA and financial analysis 1. FOR EXC More

$300 AUD in 5 days
(50 Reviews)
6.0
mail2vimalarora

Hi, I have gone through your project details and would like to take an opportunity to work on it. Being experienced in Excel and Access both, I can provide you efficient solution for your manual editing excel sheet. More

$144 AUD in 7 days
(158 Reviews)
6.2
kevivu

Dear Sir, I am based out of Jersey City, NJ, USA. Completed numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. You can refer my freelancer profile for reviews More

$250 AUD in 3 days
(83 Reviews)
6.1
fuentro

A proposal has not yet been provided

$277 AUD in 10 days
(29 Reviews)
6.0
ashoksharma1

A proposal has not yet been provided

$555 AUD in 5 days
(21 Reviews)
5.5
sunmoon25

Hi My expert team is ready for the project. They can handle advanced Excel Template or Access Database. Please contact with me. Thanks.

$250 AUD in 4 days
(34 Reviews)
5.4
inspireplatinum

Am suitable to help for the automation as am an accountant myself, and have done such automations using excel all the way to P/L B/S many times for new companies. Hence, I have high confidence of meeting your requirem More

$100 AUD in 3 days
(12 Reviews)
5.0
crypthne

I have a bachelor degree in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and More

$111 AUD in 2 days
(30 Reviews)
4.5
insidenetsoft

Hey, I see what automation you want to implement. You want just to update the input tabs and the rest to be calculated automatically. I've done that before using VBA script, advanced formulas and dynamic pivot tabl More

$70 AUD in 3 days
(27 Reviews)
4.4
rajafaizan

Hi, I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I read through the job details extremely More

$238 AUD in 10 days
(30 Reviews)
4.5
cukaegbu

Hello there. I'll develop your solution using an Access database. This is my approach: 1) I'll develop the relevant tables, relationships and queries that link the different reports you have listed 2) I'll write code More

$110 AUD in 6 days
(3 Reviews)
3.6
ENRICOJ

hi. I have extended ms excel and ms access experience. In addition I also have much vba programming experience. please let me know ,how I may assist.

$70 AUD in 3 days
(10 Reviews)
3.7
manan215

I have done similar projects in past in which I created a tool which maintains excel sheets for a broker. I can both automate excel sheets or write a Java code to maintain your sheets. Thanks for going through my propo More

$222 AUD in 7 days
(5 Reviews)
2.8
meeshusoft1

I will create an access database with the templates based on your excel sheet. Create necessary formula and links. Then whenever you want, you can download your excel files from the web and and run a macro in Access. T More

$200 AUD in 3 days
(3 Reviews)
2.6