Spirits by DZine Posted January 13, 2009 Share Posted January 13, 2009 Has anyone developed easy spread sheets that can be used for daily record keeping requirements? I'm going through the regulations for record keeping for production, storage and processing but thought that someone probably already has some Excel spread sheets already setup to make those tasks easy to track. Link to comment Share on other sites More sharing options...
JBWagoner Posted January 13, 2009 Share Posted January 13, 2009 Has anyone developed easy spread sheets that can be used for daily record keeping requirements? I'm going through the regulations for record keeping for production, storage and processing but thought that someone probably already has some Excel spread sheets already setup to make those tasks easy to track. If you're producing, bottling and shipping all within a month, here's a simple sheet for 100 proof spirits ($13.50 per gallon). Keep it simple. Keep track of bottles. Pay for what you sell. Transfer these numbers to Pay.gov by the 4th of the month, print the completed .pdf's and pay Your Uncle for the privilege of being a distiller! EXAMPLE Month/Year October 2005 750 ml bottles Mililiters Gallons Tax Liability Invoice # ST Penalty St Taxes 10/1/2005 12 9000 2.377548 $32.10 1501 10/2/2005 12 9000 2.377548 $32.10 1502 10/3/2005 12 9000 2.377548 $32.10 1503 ... Total 36 27000 7.132644 0 $96.29 State Taxes Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now