The Fundamental Five Course Is a Complete QuickBooks Training System for Small Wineries

Learn how to use QuickBooks to manage your business and make a profit!

We take the mystery out of QuickBooks so you always have the information you need to run your business at your fingertips.

QB Winery Solutions courses are the only programs designed specifically for owners and office managers of small wineries using QuickBooks. We show you step-by-step instructions so you can utilize the full power of QuickBooks to manage the business, make more money, reduce cost, release stress, and enjoy the business you love.

In our Fundamental Five Course, we’ll walk you through the exact process we use when we set up or clean up a file for a winery client.

The Core Program: The Fundamental Five Course

Includes five modules, as well as additional training and support.

Module 1 - Use an Effective Chart of Accounts

The chart of accounts is like a storage system for your home. If you have an effective system, all of your stuff has a place. You will know where to put stuff, and you can find things easily. Plus, your home will look nice and tidy. For bookkeeping, the stuff are your transactions. If you have an effective chart of accounts, you will know where to put your transactions, you can find them easily, and your reports will be nice and tidy.

Module 2 - Set up Inventory the Right Way

One of the first things people learn when they first start to use QuickBooks is how to set up items to create invoices. Since the items are not usually set up correctly; however, the only information the Profit & Loss report shows is the top-line revenue, which is good to know. But when you set up the inventory type items the right way, QuickBooks will do a bunch of calculations in the background so that without any extra effort on your part, you will instantly know your cost of goods sold (no more waiting for the accountant at the end of the year). You will also be able to use the Inventory Report, which you probably didn’t even know was there.

Module 3 - Track Sales by Channel

Wineries are unique because they sell to many different channels, and each wine will have a different sales price depending on the sales channel. However, unlike other businesses, they cannot increase sales by buying more inventory because small wineries have limited wine to sell. So, to increase the profit, the key is to manage the sales mix between the different sales channels. To do that, they need to know the gross profit for each sales channel.

Module 4 - Select a Method to Enter the POS Sales

When we say “POS sales,” we mean any sale made outside of QuickBooks. This could be a shopping cart or even a cash register. The old-school method of showing these sales in QuickBooks enter the total cash and credit card receipts for the day on a Make Deposit form and call that amount “Sales”. Unfortunately, you don’t know how much of this was wine, merchandise, tasting fees, shipping fees, or sales tax. Of course, you don’t know which wines were sold, so you cannot track your inventory. A small winery sells primarily through DTC, which means most of the sales are outside of QuickBooks. If they want useful information to help guide the business, they need to know those sales details. There are two main methods to bring that information into QuickBooks.

Module 5 - Enter the Samples, Pours, and Shrinkage

In the wine industry, giving out samples is a big deal. If you sold mattresses, samples would not be a big deal. So, wineries need a process to track and enter the samples and pours given to customers and guests. Unlike mattresses, wine bottles can easily go missing, which means that wineries also need to take regular inventory counts and enter the inventory shrinkage. When you create these procedures, your inventory reports will update and become accurate.