I recently finished compiling royalty statements for all the artists on Loöq Records, an activity I do twice a year.  Even with the custom database I designed specifically for the task, it's difficult and takes a long time.  We receive reports from our various distributors -- detailed spreadsheets with a row for every iTunes download, streaming music click, mobile ringtone, youtube view, etc.