Tour Budgeting for Excel keeps touring finances systematically organized for anyone to understand. The Tour Budgeting Excel template is designed and targeted specifically towards the entertainment industry.
Tour Budgeting for Excel is an ideal and simple way of organizing a tour's finances while on the road. Simply enter the calendar information for the city, state or country, venue, and day-type in the Tour Dates sheet. A chart tallies how many of each day-type there are. The Salaries, Per-Diem paid, and Meals (buyouts) paid sheets automatically send their totals to the Daily Budget. Totals from the Flights calculation sheet get added to the Misc. sheet.
The Misc. sheet accounts for all the miscellaneous expenses such as fuel, tolls, bus and truck leases. Per-Diem amounts or attendances are sent to the M&IE sheet for taxes (Meals & Incidental Expenses). All that is required is to enter the city's federal CONUS rate, where a link is already provided.
There is also an Astral Projection Budget, which is identical to the Daily Budget except that no figures are automatically transferred so custom projections can be analyzed. When names are entered into the Salaries sheet, they automatically fill-in names in the Personnel sheet.
Key Features of the Tour Budgeting for Excel include:
Embedded with Help comments and tips.
Error free calculations and percentage conversions.
Customizable drop down menus.
Many Auto populated fields.
Easily displays amounts of Salary, Deposits, Bonuses, Buyouts, etc. by the Week or Month.
Combined with the 'M&IE Printout', the Budget organizes the entire staff's rates for their taxes with little effort.
19 custom fields for miscellaneous expenses.
21 fields for names in salaries and personnel.
Add 3 custom categories for Day-Types on the Tour Schedule.
Weekly totals every 7 days in the Daily Budget.
Monthly, Quarterly, Bi-Annual, and Annual totals for each sheet.
Printable Tour Schedules (2 months per page).
Tracks number of Day-Types by the Month on a 'Year at a Glance' Chart.