We manage the licensing and royalties for sporting clubs. We receive sales reports from 5 licensees each financial quarter. Each report is in a different format. We need each report entered and logged into a central spreadsheet with final sales totals entered in. This requires manually totalling up line items.
1. Each licensee reports differently
2. Names of clubs may differ slightly in spelling that that what is in the central sheet so will manually need to be searched (reference sheet will be provided)
3. Each licensee reports per sale, per club, whereas central sheet is per club in total for the financial quarter (so each line item reported for that club will need to be added up and manually entered into central sheet)
PDF Instructional with 2 examples
All Q1, Q2, Q3, Q4 Data- total $ for each club not consolidated (every order provided as a line item and must be added up to get final total)
Central Review Sheet- Set up with club names and fields for entry
Central Review Sheet- Completed for Q1, Q2, Q3 and Q4 including all totalled sales data against reported Licensees.
Around 2000-2500 line items to be entered- cross checking between multiple sheets
To be completed within 4 weeks