QB Winery Solutions

2019 Silicon Valley Bank State of the Wine Industry Report

by

Last Wednesday Rob McMillan from Silicon Valley Bank hosted a webcast to discuss the annual wine industry report that he and his team put together. The report is a good read, really. I recommend that you at least read the Executive Summary.

Rob has valuable insights for the wine industry, however many of his comments are aimed at the larger wineries because the small wineries do not bank at Silicon Valley Bank. Right at this moment I have to climb down off the ledge due to a few comments made by the panel during the webcast that, if taken out of context, the team at a small winery might take the wrong way. I will make some comments, but first I I am going to digest the report.

They will be doing a follow-up webcast on January 23rd. Check out Rob’s blog for information on how to join that webcast Rob’s Blog

Have a look for yourself:

2019 SVB Webcast Replay

2019 SVB Annual Wine Industry Report

 

Cheers!

Jeanette

Entering Balances into a New QuickBooks File

by

Starting a new QuickBooks file is pretty straightforward if your business is new. Unfortunately, most people have an existing company and then decide to move to QuickBooks. It is also pretty straightforward to create a Journal Entry to enter the beginning balances of each of the accounts. But, again, most people have transactions and other data like uncleared checks, open invoices, and unpaid bills that also need to be entered. I have seen lots of creative ways (and messy) ways to enter these.

Turns out, the steps are not that difficult. At least it’s not something that an evening with some good music (and a glass of wine) can’t fix. The key is…do not follow Intuit’s instructions, because they actually make a bigger mess.

In 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

Proc – Entering balances in a new QB file

 

Office Hours 12-18-18

by

Here is the recording for office hours. The topics that came up were:

  1. Year-end Quickbooks
  2. Costing Class Quick Rundown
  3. Juice Flow & Blending Math
  4. Custom Cash
  5. Journal Entry & AR List
  6. Write-off a customer + Credit Memo
  7. Expense vs Cost of Wine
  8. G&A Costs + GAAP
  9. Bottling

These are the links to places we discussed:
Juice Flow & Blending Math
Quickies
Bottle Runs

Silver Club members, please log in to view the recording

Office Hours 01-29-19

by

 

Here is the recording for the January Office Hours. The topics discussed were:

  1. Items for Hourly consulting and contract payments
  2. CPA referral
  3. Inventory adjustment
  4. Creating new inventory and duplicating an item
  5. Using cases in everything – intuit will track 3 decimal pts
  6. Backing up- talking about condensing a file – damage file
  7. Revel (POS) tracks in multiple location – QB’s only one location

These are the links to places we discussed:

Intuitive Accountant

(re) Introducing The Wine DTC Vendor Matrix

Silver Club members, please log in to view the recording.

Selling Used Barrels

by

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.

Clear Old Transactions in Accounts Payable

by

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

 

Clear Old Transactions on the Bank Reconciliation

by

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

 

Clear Old Transactions in Accounts Receivable

by

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

 

MY FAVORITES

Quick Access to the lessons and pages that you mark as “favorite”.

Blog/Quickies

CLICK HERE to view Quickies Blog items.