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.



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

Se mere: unique photo, top sales job, photographer looking job, photographer job information, looking photographer job, want photographer job, get work photographer, get photographer job, get sales job, get job sales, data entry software mac, month spreadsheet, work photographer, top photographer, sales excel, monthly, image identification, excel rush, data formatting, automatically, form update excel, image processing library, excel sales monthly report, spreadsheet sales, input data excel photo

Om arbejdsgiveren:
( 0 bedømmelser ) United Kingdom

Projekt-ID: #4038116

9 freelancere byder i gennemsnit £94 for dette job


Hi Robberts please check P.M

£100 GBP in 7 dage
(35 bedømmelser)

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)

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)

I had done this type of job earlier.

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

I am ready for the job if offered to me.

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

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

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

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)

Eager to help.

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

Created excel spreadsheet template for hospital lab for QA/QC/QI. Reliable [url removed, login to view] to negotiate bid.

£80 GBP in 4 dage
(0 bedømmelser)