Sheet 1: Instructions

	
	

		
Instructions for Importing a Spreadsheet to TAP
		
	

		
Before importing a spreadsheet please make the following verifications
		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
- Our import process only accepts ".xls" and ".xlsx" files. Verify that your file is saved with one of these extensions.
		


	
	

		


		
- Enter all numbers as positive numbers.
		


	
	

		


		
- Do not rename or delete any tabs on the template.
		


	
	

		
PLEASE NOTE:  Any subsequent changes must be made using this worksheet.  Additional entries should be added to your original file.  Deletions
		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
should be deleted from your original file.  Once you import your file, or subsequent versions, only the information existing in this file
		


		


		


		


		


		


		


		


		


		


	
	

		


		
at the time you import it will populate your return.
		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
TAB: Brewer Sales
		
	

		
This worksheet reports the daily samples provided at brewery, on-premises sales, and off-premises sales for consumption.
		


		


		


		


		


		


		


		


		


		


		


	
	

		
Date
		
- Enter date of month of the sale.
		
	

		
Samples Given
		
- Enter amount of reported samples provided at brewery. (gallons)
		
	

		
On-Premise Sales
		
- Enter amount of daily on-premises sales for consumption. (gallons)
		
	

		
Off-Premise Sales
		


		


		
- Enter amount of daily off-premises sales for consumption. (gallons)
		
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
TAB: Branded Production
		
	

		
This worksheet reports current monthly branded product production.
		


		


		


		


		


		


		


		


		


		


		


	
	

		
Branded Product
		
- Enter name of Branded Product. (100 characters max)
		
	

		
Monthly Production
		
- Enter amount of monthly Branded Product production. (gallons)
		
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
TAB: Contracted Production
		
	

		
This worksheet reports current monthly contract-brewed product production.
		


		


		


		


		


		


		


		


		


		


		


	
	

		
Contract-Brewed Beer
		
- Enter name of Contract-Brewed Beer Product. (100 characters max)
		
	

		
Monthly Production
		
- Enter amount of monthly Contract-Brewed Beer Product production. (gallons)
		



Sheet 2: Brewer Sales

	
	
	

		
DATE
		
SAMPLES GIVEN (GALLONS)
		
ON-PREMISE SALES (GALLONS)
		
OFF-PREMISE SALES (GALLONS)
	



Sheet 3: Branded Production

	
	
	

		
BRANDED PRODUCT
		
MONTHLY PRODUCTION