Tildelt

Automatically updating monthly sales data form

I am looking for someone to create a sales income spreadsheet that can automatically input new monthly sales data from a text file or pdf.

I am a photographer and my photographs are sold by an image library. Every month I am sent a sales statement that lists which of my photos have sold, and how much for. The sales statement is sent to me as a pdf and a text file. It lists a unique photo identification number and how much that photo has sold for (as well as other information).

I want a spreadsheet that lists this sales data and that I can update each month with the new sales statement. It also needs to be able to have photos, to give a visual representation of the photos.

So left to columns would be:

1. A photo (the image that is for sale)

2. The total amount that photo has sold for over all time.

3. The image number.

4, 5, 6, 7 and onwards. A new column for each month, with the sales data for that month.

The top row would list the months/year

The second row would list the total sales for that month in dollars. (this figure is supplied on the sales statement)

the third row would list the total sales for that month in pounds. (this figure is supplied on the sales statement)

The rest of the rows would be the photos that are for sale.

Each month I would want to be able to easily and automatically import my new data.

If you agree to this job, I will be able to send you a months sales report, so you can see the formatting.

Please let me know how much you would charge to do this work. Also let me know which software you would use. I have a Mac and at the moment have Microsoft Excel X for mac, but I might be able to get different software if needed.

There is no rush on this.

Thanks!

Tim

Færdigheder: Dataindførsel, Databehandling, Excel, PDF

Se mere: unique photo, top sales job, the job of a photographer, photographer looking for job, photographer looking for a job, photographer job information, looking for photographer job, looking for a photographer job, looking for a job as a photographer, job of photographer, job of a photographer, job in photographer, job for a photographer, job as photographer, job as a photographer, i want a photographer job, how to get work as a photographer, how to get photographer job, how to get a sales job, how to get a job in sales, how to get a job as a photographer, how to get a data entry job easily, how to create data entry form in excel, how to create a data entry form in excel, how to create a data entry form

Om arbejdsgiveren:
( 0 bedømmelser ) United Kingdom

Projekt-ID: #4038116

8 freelancere byder i gennemsnit £96 for dette job

deepali111

Hi Robberts please check P.M

£100 GBP in 7 dage
(91 bedømmelser)
5.0
noxtras

Hello, I don't know how you want this done, but I could create an application that either outputs an xls, or better, shows the data directly from within the application. If you want, it can also sort, filter columns.. Mere

£120 GBP in 5 dage
(1 bedømmelse)
1.4
DanWesthill

Good day. I will build a process to feed your docsheet and interact with it. See PMB. Thanks.

£70 GBP in 2 dage
(1 bedømmelse)
1.0
rajagkp

I had done this type of job earlier.

£50 GBP på 1 dag
(0 bedømmelser)
0.0
simeonready4work

I am ready for the job if offered to me.

£200 GBP in 5 dage
(0 bedømmelser)
0.0
Tylerhutchinson

I have done hundreds of these. Please see PM for additional info.

£75 GBP in 2 dage
(0 bedømmelser)
0.0
friofary

This is ;better and effective than others. Guyz i found a free online money making [url removed, login to view] cost nothing but this website pays as just you need to view there adds and there are also very simple tasks to do worth Mere

£32 GBP på 1 dag
(0 bedømmelser)
0.0
PPPsolution

Eager to help.

£120 GBP in 14 dage
(0 bedømmelser)
0.0