Using a spreadsheet to create a show settlement sheet - basic Excel skills
Channel: Live Music Business
Date: 2015-12-03

The show or concert settlement is the process of counting the tickets sold for the show, how much money was made from the tickets and how much the promoter spent on making the show happen (‘promoters costs’). The band will usually have a contract that stipulates they will receive a ‘guarantee’ (a flat fee) or a percentage of the profits (total tickets sold minus the promoters costs), whichever is the greater. Part of the settlement process to work out if the band sold enough tickets to earn a higher percentage of the profits, rather than the straight guarantee.
This video will show you how to create your own settlement sheet, using a spreadsheet program. The video contains very basic spreadsheet (Excel) functions.

You can download a template based on this video from www.livemusicbusiness.com