{"id":2457,"date":"2019-06-12T14:02:08","date_gmt":"2019-06-12T18:02:08","guid":{"rendered":"http:\/\/199.250.223.35\/~craftbrewery\/?p=2457"},"modified":"2020-07-03T16:11:20","modified_gmt":"2020-07-03T20:11:20","slug":"3-hot-brewery-spreadsheets-for-summer","status":"publish","type":"post","link":"https:\/\/craftbreweryfinance.com\/oldversion\/3-hot-brewery-spreadsheets-for-summer\/","title":{"rendered":"3 Hot Brewery Spreadsheets for Summer"},"content":{"rendered":"<p>Hands down, summer is my favorite season. And it&#8217;s the best season for selling lots of beer.<\/p>\n<p>To help you sell more beer, check out these Sizzlin&#8217; Brewery Spreadsheets just in time for Summer:<\/p>\n<p><strong>Self-Distribution Chart of Accounts\u00a0&#8211;\u00a0<\/strong>The G\/L chart of accounts is the backbone of your financial reporting system. This template is designed for the self-distribution side of the brewery business. Set up the proper chart of accounts, monitor your financial results, and sit up straight!\u00a0<em> <a href=\"https:\/\/craftbreweryfinance.com\/oldversion\/wp-content\/uploads\/2016\/12\/CBF-Self-Distribution-Chart-of-Accounts.xlsx\">CBFT &#8211; Self-Distribution Chart of Accounts<\/a><\/em><\/p>\n<p><strong>Self-Distribution Route Building Template\u00a0&#8211;\u00a0<\/strong>The Route Building template will help you estimate the total number of drivers needed to support the self-distribution operation. Accounts are grouped by class. Drive time, sell time and service time are estimated. This won\u2019t answer all your questions, but it can be a helpful tool to estimate needed labor. <em><a href=\"https:\/\/craftbreweryfinance.com\/oldversion\/wp-content\/uploads\/2016\/12\/CBF-Self-Distribution-Route-Building-Template.xlsx\">CBFT &#8211; Self-Distribution Route Building Template<\/a><\/em><\/p>\n<p><strong>Self-Distribution Pro Forma Guide\u00a0&#8211;\u00a0<\/strong>If you want to self-distribute your beer, it helps to make a plan first. This guide will walk you through the steps to create a sales forecast, operating expense projection, and cash flow needs. Download the guide, and get a plan. <em><a href=\"https:\/\/craftbreweryfinance.com\/oldversion\/wp-content\/uploads\/2018\/06\/CBF-Self-Distribution-Pro-Forma-Guide.pdf\">CBFT &#8211; Self Distribution Pro Forma Guide<\/a><\/em><\/p>\n<p>Want more information on boosting Summer sales with Self-Distribution? Sign up as an\u00a0<a href=\"https:\/\/craftbreweryfinance.com\/oldversion\/downloads\/craft-brewery-finance-annual-subscription-plan\/\"><strong>annual subscriber<\/strong><\/a>\u00a0and get instant access to the Brewery Self-Distribution course.<\/p>\n<p>Already a subscriber? Head over to the Member Area and get the course today.<\/p>\n<p>Yours in Summer Spreadsheets,<\/p>\n<p>Kary<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hands down, summer is my favorite season. And it&#8217;s the best season for selling lots of beer. To help you sell more beer, check out these Sizzlin&#8217; Brewery Spreadsheets just in time for Summer: Self-Distribution Chart of Accounts\u00a0&#8211;\u00a0The G\/L chart of accounts is the backbone of your financial reporting system. This template is designed for [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2458,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pgc_meta":"","_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[100],"tags":[],"class_list":["post-2457","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tools-templates"],"_links":{"self":[{"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/posts\/2457"}],"collection":[{"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/comments?post=2457"}],"version-history":[{"count":0,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/posts\/2457\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/media\/2458"}],"wp:attachment":[{"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/media?parent=2457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/categories?post=2457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/tags?post=2457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}