We are looking for a programmer to create a data-base generator, converting monthly territory iTunes Financial Reports (text files delimited by tabs) into custom royalty reports. We will supply detailed program specifications, sample files, table and report templates.
The Task: Apple delivers monthly financial reports as seven separate reports by territory; we need to tag the incoming data with extra information specific to our business reporting needs, add the monthly exchange rate per territory to calculate payments per territory per month, and calculate payments for quarterly royalty reports. We are working on a Mac and will need to import royalty reports into excel for Mac.
The job includes interations, testing and support for configuring reports.