Jump to content

Record keeping


Spirits by DZine

Recommended Posts

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...