I gang

Automatically updating monthly sales data form - repost

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: update monthly sales automatically, updating monthly sales, 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

Om arbejdsgiveren:
( 0 bedømmelser ) Ratmalana, Sri Lanka

Projekt-ID: #4038483

6 freelancere byder i gennemsnit £128 for dette job


I am an avid excel modeller and user. I like to automate my tasks too. I would like to have a look at your file and format before finalising the bid. Pls see PMB

£125 GBP in 5 dage
(14 bedømmelser)

Hi. I interested in your project.

£150 GBP in 5 dage
(8 bedømmelser)

Good day - will deliver work with highest quality-- bidding on this

£220 GBP in 10 dage
(0 bedømmelser)

Customer Delight is our motto...!!

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

Sir, we are teams of seasoned software engineers, and have completed several projects of similar requirements, where data from text/pdf/excel/csv files are incorporated into managed and maintained database, we assure y Mere

£150 GBP in 3 dage
(0 bedømmelser)

I can do this project. Thanking You Jai Sai Ram, Jai Varahi Matha

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