Build Music Publishing Royalties Excel Spreadsheets
£10-15 GBP / hour
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.
Project ID: #8811718
About the project
40 freelancers are bidding on average £13/hour for this job
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
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
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
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
*** 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
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
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
Jannatul Ferdous Anannaddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd More
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
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.
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