176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Excel music sales report using Bandcamp & Paypal data
Sign in to Add to Watch List

Finance & Management > Financial Reporting

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Feb 18, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Wed, Feb 13, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

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):
BAND
ALBUM TITLE (for each release, or other merch like t-...

Sign in or Register to see more

Job ID: 37862580
 
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Australia
Experienced business analyst/data analyst looking for extra freelance work, especially interested in creating excel reports/templates/dashboards...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37950831  |  Submitted: Feb 16, 2013 08:47 ET 
Proposal SEALED

Tasha Preisner      
Tasha Preisner's identity has been verified.  Learn More
 United States  |  
I am a freelance bookkeeper, Quickbooks expert, and tax preparer with nearly a decade of experience. I started my own practice in February of 2012...
3
  |  
 0.0   |  $7,214 Earnings   |  0 Jobs
Bid ID: 37920381  |  Submitted: Feb 15, 2013 10:10 ET 
Proposal SEALED

 United States
We are a team of Certified Public Accountants, Quickbooks ProAdvisors, bookkeepers, and payroll specialists.
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 37881360  |  Submitted: Feb 14, 2013 09:13 ET 
Proposal SEALED

Cezar Cardon      
Cezar Cardon's identity has been verified.  Learn More
 Romania
I am a young passionate in accounting and finance who want to gain financial independency by doing qualitative jobs for world wide clients. I am...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 37880987  |  Submitted: Feb 14, 2013 09:00 ET 
Proposal SEALED

 United States  |  
I am a CPA which of course means I understand hard rules of business; what sets me apart is an extraordinary ability to use the basic concepts and...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37870365  |  Submitted: Feb 14, 2013 02:55 ET 
Proposal SEALED

Charlie B.      
Charlie B.'s identity has been verified.  Learn More
 Cameroon  |  
ACCA affiliate and BSc holder in apllied accounting . Qualified chattered accountant with proven analytical and interpretaional skills. Can...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37869931  |  Submitted: Feb 14, 2013 02:40 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »