This time of the year many of you are selling barrels to make room for new barrels. So what is the best way to handle this?

First, make an Other Charge type item and point it to a Misc Income account:

On your invoice, fill in the number of barrels and the cost per barrel. For the description, enter enough detail so that the barrels can be identified on the depreciation schedule. For example, “3-year-old barrels” or “2016 barrels”:

Here’s where things get tricky: if the barrels are sold to a winery they are not taxable because they are “ingredients” and are part of the thing they are selling. Or if they are sold to a woodworker who is fashioning it into something awesome so that the barrels are eventually sold (albeit in a different form), they are not taxable. In both these cases, your buyer has a resale number which you should collect for your records. (You are collecting these forms from all of your distributor and wholesale customers, right?)

However, if the barrels are sold to an individual to be used as a planter or something for themselves then it is taxable and needs to be counted as taxable sales on your sales tax return. It’s fine to sell the barrel as “tax included”. Just remember to not include the sale in your “sale to reseller” amount on your sales tax return.

Another detail is that the barrels need to be removed from the depreciation schedule. So be sure to let your CFO (or whoever calculates your costing) before the year-end is closed so that the right amount of depreciation is included in the costing. And, of course, let your tax preparer know so that the depreciation on the tax return is correct.

Coming Soon: How to pull the list of new fixed assets so you (or your tax preparer or CFO) can update the depreciation schedule.

This is a companion video to the Year End Preliminary Checklist. Go here to find that post Year End Prelim Checklist.

In this video I show how to clear out transactions that keep showing up, month after month in your Accounts Payable Aging Report. These must be cleared so that you have a realistic value for total Accounts Payable that you owe. Often they are duplicate bills which means that you have reported too many expenses.

This step could be done at any time, not just at the end of the year. If you make a regular habit of reviewing these lingering transactions, your file will stay tidy, clean, and accurate.

This video (must be a Silver Club member to view) will walk you through the steps. If you would like assistance, come to Office Hours or use this link to set up a coaching session https://QBWinerySolutions.as.me/Coaching  

DOWNLOADS

Year End Preliminary Checklist

 

This is a companion video to the Year End Preliminary Checklist. Go here to find that post Year End Prelim Checklist.

In this video, I show how to clear out transactions that keep showing up, month after month. These must be cleared so that you have a realistic value for your bank balance. Often they are duplicate transactions, so that, for example, if you have a duplicate payment for some corks, that will make the cost of your wine too high.

This step could be done at any time, not just at the end of the year. If you make a regular habit of reviewing these lingering transactions, your file will stay tidy, clean, and accurate.

This video (must be a Silver Club member to view) will walk you through the steps. If you would like assistance, come to Office Hours or use this link to set up a coaching session https://QBWinerySolutions.as.me/Coaching  

DOWNLOADS

Year End Preliminary Checklist

 

This is a companion video to the Year End Preliminary Checklist. Go here to find that post Year End Prelim Checklist.

In this video I show how to clear out transactions that keep showing up, month after month in your Accounts Receivable Aging Report. These must be cleared so that you have a realistic value for total Accounts Receivable due to you. Often they are leftover short pays or credits that have not been applied. Sometimes they are invoices that you have, sadly, decided you will never collect.

This step could be done at any time, not just at the end of the year. If you make a regular habit of reviewing these lingering transactions, your file will stay tidy, clean, and accurate.

This video (must be a Silver Club member to view) will walk you through the steps. If you would like assistance, come to Office Hours or use this link to set up a coaching session https://QBWinerySolutions.as.me/Coaching  

DOWNLOADS

Year End Preliminary Checklist

 

The winemaking team is preoccupied with the crush, and the accounting team is just twiddling their thumbs (Ha, we never get to do that…). Rob McMillan at Silicon Valley Bank is preparing his annual Wine Report and he needs your input. Each year, 20 percent of the wineries in the US participate in this survey. Of course most of these are the large wineries. Let’s make sure that the boutique and family wineries are represented. If you want to know some benchmarks that are useful for you, the small winery, this is how they are generated.

From October 1 to October 19, the survey will be open. If you participated last year, you will receive an email. But if this is your first time, look for the announcement in industry publications or check back here for the link to the official survey.

In the meantime, here is the list of questions so you can prepare your answers.

SVB Annual Survey Questions

 

Cheers!

Jeanette

Harvest has begun, that means that the year end is right around the corner. While you are waiting for the grapes to ferment, this is a great time to review your file to make sure that you are caught up with the bookkeeping tasks. If you do these now, you won’t have to scramble next year when you need to send the file to the tax preparer.

We call it the Preliminary Checklist because this gets the file ready for the year-end. There are additional tasks to be completed to officially close out the year.

One key task is completing what we call The Costing Book. We  can start to lay this out, but it cannot be completed until several of the tasks on this list are completed. Please note that if you would like our assistance in completing The Costing Book, this Year End Preliminary Checklist must be completed before we will begin that step.

This video is an overview of each step. For some companion videos check out these quickies.

• How to clear old banking transactions
• How to clear old accounts receivable transactions
• How to clear old accounts payable transactions

This video (must be a Silver Club member to view) will show you how to find all the information. I will add more videos to show you how to do all of the steps. If you would like assistance, use this link to set up a coaching session https://QBWinerySolutions.as.me/Coaching  

DOWNLOADS

Year End Preliminary Checklist

 

Do you offer bundles such as a vertical of your award winning wine, or packs like Summer Picnic Pack or Holiday Gift Trio?

Or do you run your wine club straight out of QuickBooks (and not through your POS or eCommerce program)?

If so, this webinar is for you. There are 2 tools in QuickBooks that will save you time. These are Assemblies and Groups, but when is the best time to use each one and how do you use them?

This video (must be a Silver Club member to view) will walk you through the steps.

Bundles and Packs Worksheet

 

Bundles and Packs

 

 

Square is one of the most common credit card processing services that is used by startup wineries. I actually recommend the program because the fees are reasonable and the reports are very useful.

This procedure shows how to enter the sales detail into QuickBooks Desktop. I recommend the Sales Summary procedure, but there is one variation on the usual procedure, and I show you all the steps. I also show you how to pull the reports that you need.

This procedure is only for QB Desktop (either PC or MAC), because Square has an automatic sync for QB Online. This means that the each sale in Square is automatically “pushed” into QB Online. The sync is similar to the Push-In method, but there are some time-savings steps included in the sync. I cover these steps in another procedure.

This video walks you through the steps. First, download the procedure so you can follow along. There are 2 versions of the procedure: one with screen shots so you can see the steps, the other is without the screen shots so you can use it for a checklist.

This video (must be a Silver Club member to view) will walk you through the steps.

Entering Square Sales into QB PC with Screen Shots

 

Entering Square Sales into QB PC