The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
Using 2 related CSV files of transactions, I need an Excel report of music sales by item (physical and download) with revenue, online fees and shipping costs per item in a date range. One data file will be from Paypal, the other from our online sales vendor. Those tie together by Paypal transaction IDs.
I need this set up so that it can be run with different data sets for future date ranges.
Oddities of the project:
The Bandcamp report includes physical merch, downloads and package deals.
The Paypal report includes postage expense that needs to be tallied, as well as occasional transactions from other vendors not to be included.
Some Bandcamp transactions do not appear in Paypal due to the method by which BC collects its revenue share.
It's a straight sales report with no graphics needed.
The report needs to be completed and tested by the end of February.
We'll be looking for the following info (subject to change):
ALBUM TITLE (for each release, or other merch like t-...
Sign in or Register to see more