QB Winery Solutions

  • Home
  • Courses
    • Discover QuickBooks for Wineries Course
    • Fundamental Five Course
    • Costing Courses
    • Mini Courses
  • Memberships
  • Blog
  • Shop
    • Cart
    • Courses
    • SOPs
    • Memberships
    • Mini Courses
    • Service
  • My Stuff
    • My Courses
    • Silver Club Home Page
    • My Favorite Pages
    • My Account
  • Login

Paying vendors through PayPal, Venmo, Zelle, etc

January 18, 2022 by Jeanette

If you pay vendors through a third-party payor like PayPal, Venmo, Zelle, and more, you need to be aware of a significant change in the rules that went into effect on Jan 1st, 2022. If you miss this update, you will have a very difficult time when you prepare the 1099s in 2023.

What is a 1099-K?

A 1099-K is a form you could receive, so you don’t prepare these. If your customers pay you with credit cards or if they pay you through a third-party network such as PayPal, Zelle, Venmo, etc, then you will receive a 1099-K if the amount that is processed exceeds the threshold. For the calendar year of 2021, the threshold is transactions totaling at least $20,000 AND at least 200 transactions.

Similar to all 1099s, these forms are sent to recipients and to the IRS by January 31st following the year. Of course, the IRS uses these to confirm that folks have reported at least the amount of income shown on the form.

Your vendors might receive a 1099-K as well. This is why the IRS instructions say that you do not report payments made by credit cards or through third-party networks on the 1099-NEC and 1099-MISC that you file because it is possible for the vendor to have payments reported twice: once on the forms you sent and again on the 1099-K.

Because of this “loophole” many sole-proprietors and independent contractors did not receive any 1099s. As a result, accountants (including us) recommended that you report all payments to eligible vendors regardless of the method of payment. This was to prevent you from the potential liability of failure to file, even though the IRS rules created this loophole.

In practice, because the threshold was so high many independent contractors and smaller companies did not receive a 1099-K, thus the vendor was rarely faced with this duplicate reporting situation.

What is changing in 2022?

Beginning Jan 1, 2022 (which is for forms reported in 2023, the threshold has changed considerably.. The new threshold is payments that exceed $600 and any number of transactions.  This means that many more vendors will receive a 1099-K, specifically the ones who have benefited from the loophole.

Let’s say that you paid a vendor $1,000 through Venmo. If you continue to report all payments made through a credit card or third-party network, that $1,000 payment will now show up on both the 1099 that you send and the 1099-K that Venmo will send. The vendor will not be happy, and you will get a call to fix it.

At the end of the year (which is actually in January), when you pull your report of the payments to the vendors, it is easy to exclude the credit card payments. The tricky part is excluding the payments made through a third-party network. 

Most wineries don’t keep a balance in their PayPal, Venmo, Zelle, etc accounts, because they typically only use those networks when they need to pay a vendor immediately or if the vendor is not set up to receive credit card payments (or if the vendor is playing with the loophole). The wineries set up their accounts so that their bank account is debited the amount of the transaction. The transactions show up on the bank statement as a debit to PayPal/Venmo/Zelle/Other, but in QuickBooks, the entry is either a check (QB Desktop) or an expense (QBO) filled out to the vendor. Sometimes there is a comment in the memo saying that the payment was through a network.

The problem is that at the end of the year when you prepare your 1099s to send to your vendors, there is no way to identify those third-party payments so you have no choice but to include those amounts in the total amount paid to the vendor on the 1099s. You have some options on how to fix this:

  • Stop paying vendors through PayPal/Venmo/Zelle/Other third-party network
  • Take the time to review all the payments and hope that you put a note in the memo
  • Make some small changes to QuickBooks and record these payments slightly differently

We will be explaining our recommended procedure to the Silver Club members at the next office hours.

Learn more about the Silver Club – Click Here

We also have a mini-course on filing the 1099s. This course is updated every year to handle changes in the laws. The 2022 version includes a lesson on how to set up your QuickBooks file so that you are ready for the 2023 reporting season.

Learn more about the Happy 2022! Happy 1099! Mini-Course – Click Here

Filed Under: Uncategorized

Financial benefits of a virtual channel

September 20, 2021 by Jeanette

Most wineries dipped their toes into the world of virtual wine tastings in the spring of 2020. For some wineries, these tastings have stuck and continue to be a source of both revenue and new fans and club members. Check out what some Napa Valley wineries are doing.

From a business point of view, I think the virtual wine tasting channel is valuable for many reasons. First, you can isolate the costs of running the virtual channel very easily. The staff is scheduled only when you have guests to entertain, so no more waiting around or guessing how many staff to plan for a weekend. 

Second, you can isolate the advertising costs. Your goggle or facebooks ads have tracking codes so you can see the conversion rate and from that calculate the total revenue. There is a direct correlation between a specific ad and the revenue generated from that ad. Back in the 1800’s John Wanamaker said that half of his advertising was wasted, he just didn’t know which half. These tracking codes eliminate that blind spot. 

Third, once someone attends a virtual event, you now have their email address and so you can send them news another emails. With CRM tools built into most winery POS programs, you can track the lifetime value of each customer. You can also identify how they became customers of yours. The revenue from the tasting kits should cover the marketing cost, so the added value of future sales either as a fan or as a Club member means additional revenue down the road. 

Personally, I think the virtual tasting channel is an exciting opportunity to attract a huge number of wine lovers who just cannot make it to wine country. Those folks would love to be able to “visit” wine country from the safety and comfort of their homes. I also like virtual tastings because the best virtual tastings I have attended were a collaboration among several wineries or between a winery and a restaurant. The wine industry has a long history of being very generous and helpful with their neighbors even though they are technically competitors. The virtual channel keeps that spirit alive.

Filed Under: Uncategorized

When planning falls short

September 24, 2020 by Jeanette

One morning these rag-a-muffins decided to venture into the jungle (Maui’s north shore) to explore. They figured that they might get hungry so they tossed a muffin and a few bananas into a knapsack and headed out. Several hours later they returned home, muddy and starving (but otherwise safe and healthy). That was over 10 years ago, yet when they tell the story about that day what they remember is that they wished they had planned a little better. Apparently one muffin and a few bananas for 4 kids was just not enough food. They were not fazed by the “getting lost” part.

The quarantine, social distancing rules, and fires have created a new world that is more like a jungle than anything we are used to. You might need more than a muffin and a few bananas for the journey.

Now is the time to get your QuickBooks file set up with our Fundamental Five so that you can make a plan for next year. Stay tuned for more.

What are the Fundamental Five? Check out the Discover QuickBooks for Wineries course.

Filed Under: Uncategorized

2020 SVB State of the Wine Industry Recap

March 16, 2020 by Jeanette

As usual, the report is a good read. It’s also filled with charts and some wonderful photos, so be sure to print it in color! Go ahead and dive in anywhere, as you will undoubtedly land on something interesting. Here is a guide to what each section of the report entails.

  1. Introduction – Read these 2 pages for an overview of the main themes in the report.
  2. Executive Summary (3 pages) – This lists the 7 headwinds and 7 tailwinds.
  3. 2019 Predictions in Review (2 pages) – I love that Rob is willing to admit what they got wrong.
  4. 2020 US Wine Predictions and Observations (2 pages) – Key topics are Supply, Demand, and Price.
  5. Grape and Wine Supply (8 pages) – The is an oversupply, but you probably already noticed this.
  6. Wine Sales (20 pages) – Sales are flat everywhere. Rob has been discussing this issue for a while, therefore, this is not new, but still interesting.
  7. Demographics and Marketing (11 pages) – Rob feels that the wine industry has done a poor job of reacting to changing customer values in its key messaging.
  8. Land and M&A (2 pages) – If you were considering selling, now is not the time.
  9. Cumulative Negative Health Messaging (3 pages) – There is a strong neo-prohibition direction coming from government agencies. At the same time, the Millennials are very health-conscious, and they are picking up on this message.

Rob led two, one-hour discussions with a panel of experts to discuss the report. To be honest, I only listen for issues that I feel are useful for the family wineries. Much of the discussion is primarily focused on that other wine industry (the large, distribution focused wineries).

In the first session, my big takeaway was the neo-prohibition messaging that has quietly taken hold. The book “The French Paradox” and the report on “60 Minutes” all happened 30 years ago. (Remember when we all watched “60 Minutes?). It caused a surge in wine drinkers, particularly among the Boomers. Now those Boomers are “aging out” and the new generational cohorts are hearing a different message about wine. At the same time, several other alcoholic beverages have managed to find and spin a health benefit associated with their product (for example Vodka is gluten free!). Rob feels that the wine industry can do more to “bring balance to the conversation”.

In the second session, I was delighted to hear a shift away from last year’s statement that “the tasting room model is dead”. Instead, they suggested ways to continue the conversation with the visitors you initially meet in your tasting room. Continuing the conversation can be through emails, social media, or even a good old fashioned telephone call. These are suggestions that family wineries can easily implement. Large wineries simply cannot do this and will never have the genuine relationship with their customers that family wineries can develop.

Personally, wine has always been about connecting with my friends and family. Good wine always seems to stimulate conversation in a way that beer and cocktails simply don’t. With that being said, I encourage you to find new and different ways to connect with your visitors. I guarantee that both of you will enjoy the conversation!

Silicon Valley Bank webinar replay

 2020 SVB Annual Report

 

Filed Under: News, Uncategorized

How to Record Shiners You PURCHASED

October 16, 2019 by Jeanette

A winery owner asked me this question recently:

Jeanette –
I have a question of the proper way to make a new entry. We purchased 220 cases of Sparkling wine from Rack & Riddle to sell under our brand.
So, the initial entry into the system is for finished case goods 240 cases @ $108….given it’s not coming out of bulk…what is the proper entry?
Thanks – Mark

The way that shiners are entered is fairly straightforward, however it depends on the situation (doesn’t it always…)

Scenario #1 – The shiners were labeled and finished by the vendor – this is super simple
Scenario #2 – You bought shiners, labels, and foils from different vendors and hired a crew or bottling line to apply the lables – this has a few more steps

For scenario #1

  1. Create the item as usual
  2. Create a bill using the item tab to record the number of units and total cost. Remember to use the same units for this SKU as for all the others, so if you use “bottles” you will need to convert the number of cases to bottles. Also, ignore the cost that you were quoted. Enter the total cost of the actual bill. QuickBooks will calculate what your actual cost per bottle was.

That’s it…just 2 steps. Of course, you will need to pay the bill at some point.

For scenario #2

  1. Create current asset account called “Shiners” (or something like that)
  2. Create a sub-account for the specific SKU (I am assuming you might do this again in the future)
  3. As the bills (or checks and credit card charges) for the different components show up, record all of these to the SKU sub-account.
  4. If these were bottled during a regular bottle run so the labeling labor shows up on the bottler’s bill, calculate the portion of the cost for the shiner SKU and record that amount to the SKU Sub-account.
  5. After the labels have been applied and you are ready to bring them into inventory, create a Journal Entry check and enter the information on the item tab as usual. For the total cost of the wine, look at the total amount of the SKU sub-account.
  6. On the expenses tab, use the sub-account name and enter the amount as a negative number.
  7. When you save the journal entry check, the total for the sub account should be zero.

The tricky part of this procedure is that you will be recording the components with a different workflow than usual. This may be confusing, but trust me…it is much simpler than including these bottles on the Bottling worksheet in the costing book.

Cheers!

Filed Under: Uncategorized Tagged With: Accounts Payable, bookkeeping, Chart of Accounts, inventory, Winery Accounting

Courses for Winery Owners

October 6, 2018 by Jennifer Cummins

f

Recommended Courses for Winery Owners

Are You a Garagist?

Did your home winemaking hobby grow into something bigger? Our ‘Garagist Program’ will show you an easy, computer-free (that means no QuickBooks) method of tracking your income and costs. CLICK HERE

Discover Quickbooks for Wineries

Are you frustrated trying to understand how to use QuickBooks for your winery? The Discover QuickBooks for Wineries webinar gives an overview of the Fundamental Five, the 5 critical procedures that boutique wineries must have in place for an effective financial management system. CLICK HERE

Financial Strategies and Planning

Do you want to get your financial data under control? The ‘Strategies and Planning’ course will show you how to read and interpret all key financial reports (so you can impress your banker!). CLICK HERE

Winery Owners wear so MANY hats and we don’t assume to know exactly what hat you’re wearing at the moment, so here are other courses we recommend to the Owner that also may be the Bookkeeper and more:

The Basic Steps for Wineries

Want to discover a proven five-step system for running a boutique winery using QuickBooks? Our Discover QuickBooks mini-course shows you what a properly set-up QuickBooks file for a boutique winery looks like and see some common mistakes you should avoid.  CLICK HERE

How to Calculate Wine Costs

Trying to figure out the true cost of your wine, but scratching your head? Silver Club members can check out our ‘Using QuickBooks in the Wine Industry’ to see where the costs show up and our course ‘How to Calculate the True Cost of your Wine’ courses will show you the steps (best for excel nerds). Click Here

Maintaining a Healthy Cash Flow

In our flagship course ‘Using QuickBooks in the Wine Industry’ you will find an entire module devoted to The Cash Flow Quickie. These lessons will make a world of difference. This course is available exclusively to our Silver Club members CLICK HERE

For a Complete List of ALL our Courses, CLICK below:

OUR COURSES

Filed Under: Uncategorized

Courses for Office Managers

October 6, 2018 by Jennifer Cummins

Office Managers & Bookkeepers

Office managers at boutique wineries have it easy, right? Not so much. Sure the work is interesting and no two days are ever the same.

But, there are all sorts of processes that you probably didn’t sign up for. Winery bookkeeping and accounting are confusing and complex. But, we are here to help.

Recommended Courses for Winery Office Managers

New to QuickBooks?

Familiarize yourself with QuickBooks without getting lost. Understand the basics with our free ‘QuickBooks 101’ course.  GET STARTED

QuickBooks Basics for Wineries

The Discover QuickBooks for Wineries Webinar shows you what a correct file set up looks like. CLICK HERE

The Next Steps for Boutique Wineries

Know your way around QuickBooks but want to build on those skills? Scroll through all the lessons in the ‘Using QuickBooks in the Wine Industry’ course, pick a starting point, join the Silver Club, and dive in. CLICK HERE

No Accounting Experience?

Creating a QuickBooks file for a winery or trying to find out more about the basics? Visit ‘The Workshop’ version of our flagship ‘Using QuickBooks in the Wine Industry’ course, specifically designed for people with no accounting experience CLICK HERE

Want a Coach?

Looking for some personal attention while getting started? Upgrade your membership to ‘The Pro Workshop’ to and get matched with a coach and more. CLICK HERE

Calculating Wine Costs

Trying to figure out the true cost of your wine, but scratching your head? Check out the ‘Using QuickBooks in the Wine Industry’ and ‘How to Calculate the True Cost of your Wine’ courses. These are available exclusively to our Silver Club members CLICK HERE

Individual Consultation

Want to talk to the QB Wine Guru? Complete any version of our foundation course ‘Using QuickBooks in the Wine Industry’ first, then contact us for details. CLICK HERE

For a Complete List of ALL our Courses, CLICK below:

OUR COURSES

Filed Under: Uncategorized

Courses for Accounting Pros

October 6, 2018 by Jennifer Cummins

Accounting Professionals

With different business goals and financial practices, even accounting pros can need a little extra help when it comes to boutique wineries.

Figure out how best to support and advise clients in the wine industry by tapping into my experienced perspective through my specially adapted courses.

Recommended Courses for Accounting Pros

Support for your clients

Looking for an accessible yet informative QuickBooks class to recommend to clients? Help them master the basics with my free ‘QuickBooks 101’. Then, they’ll be all set to learn The Fundamental Five, or take my ‘How to Use QuickBooks in the Wine Industry’ course to get a handle on basic accounting processes. CLICK HERE

Messy File?

Want to see what a clean, well-organized file looks like? Through my ‘Discover QuickBooks for the Wine Industry’ course, you’ll:

  • Learn about the signs of an ineffective file
  • Find out about fatal costing mistakes
  • See the QuickBooks Fundamental Five in action. CLICK HERE

The Costing Book

Want to really get to grips with how to set out your costing book? My engaging live seminars and ‘How to Calculate the True Cost of Your Wine’ classes (available to Silver Club members) will tell you how to set it up, the details you’ll need, and the issues to watch out for. CLICK HERE

Book to Tax Difference

Trying to figure out the difference between tax costing and true (GAAP) costing?
The Book to Tax Adjustment mini-course – created in conjunction with a wine industry specialist CPA – will provide you with a seriously efficient way of calculating Book-Tax Differences. CLICK HERE

For A Complete List of ALL our Courses, CLICK the Link Below:

Our Courses

Filed Under: Uncategorized

Search Blog

Search the Blog

How much profit do you really make?

The Crush

Your first step to running a profitable winery and crushing your business goals.

  • Home
  • All Courses
  • Memberships
  • Login
  • My Courses
  • My Favorite Pages
  • My Account
  • Contact

© 2025 QB Winery Solutions - QuickBooks and Bookkeeping Assistance for Small Wineries