Build Music Publishing Royalties Excel Spreadsheets

Completed Posted Nov 1, 2015 Paid on delivery
Completed

We are a small music company which composes and produces music for television and film. Royalties from public performance (i.e. being broadcast) from all over the world are paid out quarterly from "PRS for Music" who provide us with PDF and .CSV files for each quarterly period. Each piece of music (called a 'work') will typically belong to an individual album and will be signed to a specific publisher, as we have relationships with a handful of different publishers. However on these statements, the works are just listed alphabetically.

We have these royalty statements going back to 2005. We currently have no way of analysing what each work has generated, in total, or per year. We have been working towards finding a way of tracking this data, so we can more accurately summarise the success of individual works, albums and publishers.

I have only a basic level of expertise in Excel and so am seeking someone who can help design the spreadsheet, enter the data, either manually or using a macro/formula from the .csv files. It is not a particularly large about of data, in that there are only a few hundred works in the catalogue, and we only need to bring in the total amount each work has generated per quarter into our master spreadsheet. Once we are happy with the layout and system for the very first statement, we can work towards entering the data for the subsequent periods up to the current day. This task could be performed by someone else as it requires well skill, or could be done by the same person. Moving forward into the future we would need to add each quarterly statement as it arrives.

Please get in touch if you think you can help. No knowledge of music publishing is really required, this is essentially a basic accountancy/number crunching task and could be handled by anyone with a good grasp of Excel and basic maths.

I have attached the PDF and the CSV for the most recent statement. Previous statements from earlier years generally have less works i.e. less lines and volume of data.

Please note that whilst applicants from all geographical areas will be considered, I am only interested in applicants who speak excellent English.

Accounting Data Entry Excel Finance

Project ID: #8811718

About the project

40 proposals Remote project Active Nov 2, 2015

Awarded to:

best4best

Hi, I am an Excel expert and can create an easy-to-use Excel template to fulfill your requirement. I can also input all the historical data from csv files with great care and accuracy in to the Excel sheet. I am hap More

£10 GBP / hour
(177 Reviews)
6.5

40 freelancers are bidding on average £13/hour for this job

zExcel

A proposal has not yet been provided

£40 GBP / hour
(250 Reviews)
7.6
prameswara

A proposal has not yet been provided

£10 GBP / hour
(312 Reviews)
6.9
caabdul

Greetings! I am Certified in Accounting and Finance from Institute of Chartered Accountants of my region. I am very skillful in bookkeeping/accounting in accordance with International Accounting Standards and various G More

£15 GBP / hour
(113 Reviews)
6.5
fabest

Dear, we are Team of French + US. 11 years experience on Access/Excel/VBA automations. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you c More

£15 GBP / hour
(50 Reviews)
6.9
gokulanand

Hello I am pretty good at excel VBA Programming and Macro development. I think, I can design a workbook that imports the data ( csv ) into the master sheet and generate the summary as per the requirement. I will be More

£12 GBP / hour
(95 Reviews)
5.9
titukhan13

Hello Sir, It is my great honour to apply for this job vacancy. I am very hard working and can work effectively as fast as I can. We are a team of 18 experienced web developers. Our team members are young ,energetic, h More

£13 GBP / hour
(150 Reviews)
5.8
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliv More

£11 GBP / hour
(72 Reviews)
5.8
prem4998

Hello there my beloved employer, I have gone through your project description and clearly understood what you need me to do. Let me show you my reliability, dedication, honesty, accuracy, attention to details, etc. I m More

£10 GBP / hour
(79 Reviews)
5.8
Abbadwajid

I am a CAT (Certified Accounting Technician) and ACCA (Association of Chartered Certified Accountant) qualified, pursuing CFA (Chartered Financial Analyst). Hence, I have extensive knowledge of finance, accounts, audit More

£13 GBP / hour
(41 Reviews)
5.2
fritzons

Good morning, Fritzons - Accounts, Bookkeeping & Payroll Services located in London offer a wide range of accounting & consulting services for businesses and individuals. We pride ourselves on our commitment to prov More

£22 GBP / hour
(10 Reviews)
4.8
serdaryalcin

Hi, What sort of reports do you want to be produced for each CSV file? If in the list there are items not in your catalogue or if a different format was used, I want to see it. What I get is that there are repor More

£16 GBP / hour
(21 Reviews)
4.5
backofficeworks

*** Do You Like Getting the Results You Want? *** Need to Stay on Budget?*** Hi, I think you just found the right candidate here! I will make sure to deliver the best as per your requirements. I am an experienced co More

£13 GBP / hour
(20 Reviews)
4.3
gsanggara

Hello, I am interesting to your project & placed bid for your consideration. with 3year+ experienced in excel coder & formulas I am very confident that i will deliver good template as per your requirement on time. More

£10 GBP / hour
(14 Reviews)
3.5
developerguru15

Sir/Madam, Good day! I'm a degree holder related in Information Technology and I'm a visual basic/macro programmer and I also teach math for 5 years. I'm also good in accounting/analytical skills. I'm a freelancer More

£10 GBP / hour
(3 Reviews)
3.3
shaifuluzzal

Sir, I am an excel expert with accounting background And have the maturity to manage your project. So I am interested to join with you. Regds, Shaiful

£13 GBP / hour
(0 Reviews)
0.0
dadisatish

A proposal has not yet been provided

£13 GBP / hour
(0 Reviews)
0.0
ashikislam43

Jannatul Ferdous Anannaddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd More

£13 GBP / hour
(0 Reviews)
0.0
Mushfiqulislam

I am Mushfiqul Islam. I have completed my Diploma in Graphics Design and Text Illusion from Shihab Technical Institute. For the past few years I have designed many logos, banners, Cartoons etc. Some samples have been p More

£13 GBP / hour
(0 Reviews)
0.0
mohsinmasood101

skill, experience and hard working made me a competitive candidate for this bidding/ work. beside this, I also worked for company as clerk where my job description was same as mentioned here.

£13 GBP / hour
(0 Reviews)
0.0
geraldabel

Good Day! Dear Sir/Madam, Upon reading the job description you have posted, I am certain I would be a perfect fit for the position at hand. I have an education background in managerial accounting that can be he More

£11 GBP / hour
(0 Reviews)
0.0