QB Winery Solutions

2020 California AB5 and Independent Contractors

by

Update 10/21/20

On September 8th, California AB2257 was  passed that expanded the list of workers that are excluded from some aspect of the bill. The “weekend warriors” still do not qualify as Independent Contractors, however these folks will have an easier time qualifying under the new rules. These rules are retroactive to January 1st.

  • Photographers no longer  have a submission limit
  • Content writers no longer have a submission limit
  • Musicians

A summary of AB2257

The bill from the California legislature website

Original Post 1/20/20

On January 1st, 2020 California AB5 or the “gig worker bill” went into effect. This means that your weekend warriors can no longer qualify as independent contractors because IC’s must be a bona fide business. You should have a contract with these folks — and they should have a business license and other clients. Before AB5, it was easier to give a 1099 to these folks, but with the new rules it will be easier to pay them with a paycheck.

For wineries and businesses in California: As you prepare your 2019 1099s, have a close look at the list to see if anyone should be paid as an employee beginning in 2020. And for any new workers, decide up front if they will be an employee or an independent contractor.

For more details, download our guidelines:

CA AB5 Guidelines

 

Office Hours 3-26-20

by

Here is the recording for Office Hours today. You can find the following wine accounting & QuickBooks topics in this month’s recording:

  1. Review of Quickbooks Desktop vs Online (1 minute mark)
  2. Entering Transaction Manually (3 minute mark)
  3. The Push-in Method and Square (4 minute mark)
  4. Commerce Sync (9 minute mark)
  5. When do you run in to ‘Tax Included’? (12 minute mark)
  6. Vino Shipper, State Taxes & reimbursements (15 minute mark)
  7. Wholesale Sales to Shops – Charging Sales to a Company Card (22 minute mark)
  8. QuickBooks and the concept of price level list (39 minute mark)
  9. The Summary Method vs the Push-in Method (43 minute mark)

 

Silver Club members, please log in to view the recording

Office Hours 3-24-20

by

Here is the recording for Office Hours today. You can find the following wine accounting & QuickBooks topics in this month’s recording:

  1. Square Sales Summary Procedure (3 minute mark)
  2. Sales Summary Procedure – Sales Tax  (7 minute mark)
  3. Sales Tax Item for your Local Sales Tax Rate (16 minute mark)
  4. Sales Shipped out of California –  Tax rules (20 minute mark)
  5. Automations synced to Square (25 minute mark)
  6. Tracking Exclusions on a spreadsheet (27 minute mark)
  7. Custom Summary Report to filter depletions (33 minute mark)
  8. Budgets and Forecasts (35 minute mark)
  9. Virtual Tastings (43 minute mark)

 

Silver Club members, please log in to view the recording

Questions for your Tax Preparer

by

If you ask your tax preparer to explain the difference between your True Income and your Taxable Income they should be able to easily answer this question. However, what if you asked your tax preparer to explain the difference between True Cost and Taxable Cost? If this question made you (or them) say “huh?”, then read on!

It’s tax season, therefore the term Adjusted Gross Income (AGI) should have crept back into your brain. AGI is the amount of money that you use to calculate the income tax which you owe. In plain English, AGI is also called Taxable Income. How is it calculated?

Take your True Income, which is the amount of money that you earned before deductions and taxes. You will find this in box 1 on your W-2 form. You may also have interest and dividend income. The loose change found in your sofa doesn’t count.

Subtract as many deductions as possible – this should be easy for everyone. If you have a good tax preparer, they will find as many legal deductions (aka, loopholes) as legally allowable (some unscrupulous preparers will find a few more). You know the concept…the more deductions the better.

Next, let’s talk about your Taxable Income – the amount used to base the income tax that you will owe. The lower the number the better.

Your Taxable Income will vary depending on the tax rules in place each year. For instance, let’s say you made the same True Income, before and after any of the “tax reform” bills of the last 30 years. In most circumstances, your Taxable Income will be different. Sometimes “tax reform” changes the tax table. However, most of the time Congress fiddles with the deductions. If you were on Congress’s good side, your Taxable Income went down. If Congress thought you were not important (or not paying attention), your Taxable Income went up.

Your True Income is always bigger than your Taxable Income. And your True Income doesn’t change depending on which party is running Congress, or whether a “tax reform” bill was recently passed. You base your most important decisions, such as “Can I afford to buy this house?”, on your True Income. In fact, lenders look at your True Income, not your Taxable Income to decide if you are able to pay the mortgage on that new house.

The cost of your wine also has a True Cost and a Taxable Cost. There are other similarities:

  • True Cost is higher than Taxable Cost (except for very large wineries who are not using QuickBooks and are not reading this article)
  • The lower the Taxable Cost the better
  • True Cost does not change when Congress passes new tax legislation
  • You need to make your most important decisions based on True Cost

I work with a winery that initially made less than $1 million dollars in revenue. Within a few years, thanks to their awesome wine (and an excellent CFO…Yours Truly!), their sales grew to over $1 million dollars. At that point, their taxable cost more than doubled because they passed the $1M threshold, which was where the tax rules changed. Then, in 2018, Congress changed the threshold to $25M. This means that this winery (and all the others making between $1M and $25M) saw their taxable cost go down significantly.

Thus, in the course of five years, this winery’s Taxable Cost changed three times, and each change was significant. I cannot share their actual numbers. However, let’s revisit the ‘Three Muskateers’ from our How to Calculate The True Cost of Your Wine course or Discover QuickBooks for Wineries. Remember the True Cost for each of the wineries is the same. The first phase is similar to ‘Athos’ where the taxable cost was $36/case. The second phase was similar to ‘Aramis’ at $114/case because they had passed the $1M threshold. And in the third phase, it was back to ‘Athos’ at $36/case. (For purchased grapes the change is $90 to $197 and back to $90). If we had been managing the business using taxable cost, it would have been chaotic; possibly disastrous. Of course, we were using True Cost to manage the business, so the business continued to grow, and they could enjoy the tax windfall that first year.

The point is this: just as you have a True Income and a Taxable Income, your wine has a True Cost and a Taxable Cost. At your next appointment with your tax preparer, your accountant or CPA, ask them to explain the difference.

If your tax preparer’s response is “huh?”, then you have a big problem!

Office Hours 1-28-20

by

Here is the recording for Office Hours today. You can find the following wine accounting & QuickBooks topics in this month’s recording:

  1. Units of Measure, getting started (1 minute mark) **I solved George’s problem and added a comment to the Units of Measure procedure
  2. Details on a new course – The Costing Book Checklist (5 minute mark)
  3. AMS and Vintrace to QB  – Converting from those programs to QB (7 minute mark)
  4. What POS programs do you recommend? Vinespring (11 minute mark)
  5. We’re donating all bottle proceeds to a special cause – How do I record it? (12 minute mark)
  6. 1099 review of new CA law (13 minute mark)
  7. Should I use Vinespring as a POS or Square? – It depends on the size of your winery (15 minute mark)
  8. VinoShipper – A discussion of workflows in VinoShipper (20 minute mark)
  9. Data dump for the Push-in Method – What does a transaction report look like? (24 minute mark)
  10. Bottle runs – How do I track 1st off and last off? (26 minute mark)
  11. Let’s chat about Kegging Wine (28 minute mark)

Silver Club members, please log in to view the recording

Cash Basis vs Accrual

by

In honor of tax season, I am unlocking a lesson in the How To Calculate the True Cost of Your Wine so that everyone can hear this information.

This lesson explains the difference between Book Cost and Tax Cost and how the recent tax changes have affected this issue.

The critical points are:

  • You must use True cost/Accrual in your QuickBooks file so that you have accurate numbers to manage the business.
  • The tax preparer can convert from True cost/Accrual to Tax cost/Cash basis in their work-papers (but you cannot convert in the other direction)

For the non-accountants, in this context these terms mean the same thing:

Book cost = True cost = Accrual

Tax cost = Cash basis

We have an on-demand lesson for the tax preparers on how to convert from Accrual cost to Cash basis costing GO HERE .

We also offer live seminars with CPE on this very topic, led by Tyler Willis, CPA . For the schedule GO HERE.

An Easy Way to File CA Sales Tax (without Ship Compliant)

by

If you have more than $500,000 in revenue in California (excluding distribution and wholesale sales), you are subject to the sales tax filing rules that were effective April 1, 2019. Many small wineries now meet this requirement and filing the California Sales Tax return is much more complicated than in the past. You can thank South Dakota vs Wayfair for this new complication. In the past, the district tax only applied to companies that had a “physical presence” in that district, but it now applies to any winery (or business) that exceeds $500,000 in retail sales in California.

This is not as simple as looking up the zip code because it might cross different districts. For example, the zip code for Healdsburg, 95448, includes addresses in the City of Healdsburg which are taxed at 8.75% whereas an address in Dry Creek Valley which is outside the city has the rate of 8.25%

The State of California has a nice webpage where you can plug in an address and it will lookup the sales tax rate. Click Here. But it is not realistic to lookup up every address.

You could signup for a service like ShipCompliant or Compli, which are programs designed for the wine industry, but these are expensive, and you may not justify the fee just to file your California Sales Tax Return.

Here is the outline for a process that will cost about $210 per year. I will record a complete video to show the steps, but in the meantime, these are the basic steps

  1. Sign up for a Basic plan at Taxjar.com. This is a sales tax program that will look up the sales tax rate. It is not an alcohol compliance program, so you will have to keep an eye out for those details with whatever procedure you are currently using.
  2. Find a report from your POS program that includes the shipping address and the taxable sales.
  3. Edit that report to fit the format required by Taxjar.
  4. Upload the report to Taxjar.
  5. Print the California report and use those details to enter the sales in the various districts.

This process is super fast. The most complicated part is formatting the report to match Taxjar’s required format, but once you do it the first time, it will be easier the next time.

Note: TaxJar could file the California return for you, but there is additional information that must be included, so you still have to file the return yourself using the CDTFA portal. But, having TaxJar summarize the sales for each district is a huge time saver.

If you already have ShipCompliant: You need to turn on the reporting module, and then turn on the California state form. Make sure your settings have been revised for the new rules.  As with TaxJar, you will use ShipCompliant to calculate the sales by district, but you will still need to manually enter the details into the CDTFA sales tax portal.

If you are interested in the full mini-course on how to file the California sales tax return, fill out the form below and we will notify you as soon as it is ready.

California Sales Tax MAJOR CHANGE

by

The CDTFA (California Department of Tax and Fee Administration) made a significant change in the sales tax rules effective April 1st.  Click Here for the ShipCompliant article on this change.

Here is a summary of the changes.

  • Applicable for wineries with over $500,000 DTC revenue in California
  • Sales tax is now based on the district that the wine is shipped to, regardless if you have a physical presence in that district.
  • Retroactive to April 1st

The hardest hit by this rule change are the micro wineries, because the larger ones are already using ShipCompliant (or something similar)

Note: I called the CDTFA to clarify some of the details, but if you have any questions call them directly at 1-800-400-7115. I am only sharing the guidelines

Applicable for wineries with over $500,000 DTC revenue in California

  • If you are not close to this threshold, go back to your racking project. Just keep this number in the back of your head.
  • Only DTC revenue shipped in California (yes, pickup at the tasting room counts at “shipped in California”). So distribution and wholesale sales are excluded. Also the rules states “tangible personal property” so that would exclude things like event fees, but again…check with your compliance consultant to determine what other exclusions would apply to your situation.
  • First, calculate your DTC revenue in 2018. If you were under $500k, you are excluded for now. When you cross that threshold, even if it is in the middle of the year, the rule will begin to apply.
  • If you include in “California taxable sales” the sales you make to states that you are not licenced in, then you will need to know that total for this threshold. (See below if you this is not clear)
  • If you are not in California, the rule applies if you ship $500k of personal property into California

Sales tax is based on the district it was shipped to

This is the crux of the rule change. In the past you only paid for districts where you had a physical presence. I know that many of you have been doing this all along, especially folks who worked in a large winery and then transferred to a smaller one, but it was actually not correct.

The solutions to this are:
  1. Use ShipCompliant
    • This is fine if you feel you are can justify the fee, because the program works well.
    • File the CA return through ShipCompliant, because there will be a lot more boxes to fill in.
    • If you currently have ShipCompliant, double check your settings to make sure they will meet this new rule
  2. Do it manually
    • Only for the wineries with minimal shipments
    • You will need to run a report that lists the shipments by zipcode, then match the zip code to the district. Check with your POS program to see if this report exists. If you push in your sales, you can run this report in QuickBooks. Pop a question in the forum for the checklist to make sure you are pushing in all the details.  (I asked the VineSpring team to add this column to their Sales Tax Reconciliation report…let’s see if they come through)
    • Download the CDTFA report with the districts and tax rate. What is useful are the district names. Click Here
    • I am still googling for a report the lists the CA zipcodes and the district it is in.
    • Remember, you are only liable to pay for what you should have collected, not what you actually collected, unless you collected too much. So charge your customers for the CA Statewide rate (currently 7.25%). When you file your return, you will end up paying a little more than what you collected, but consider that a savings over using expensive software.
  3. Do a semi manual method
    • Upload your shipment report (described above) to a Sales Tax reporting program that is not winery specific. There are a few out there, and I am testing one right now. That’s it.
    • However, you will not have live updates to the district rate changes, so hopefully your POS program will have that.
Notes for everyone
  • Make sure your POS program is properly setup. If the winery is in a district with a high rate, you don’t want to be charging all of your shipments that rate. The best would be to have an on-site rate (your home district) and a shipment rate (the CA Statewide)
  • I would strongly recommend NOT setting up a QuickBooks sales tax item for every district. This is too time consuming to manage. I don’t think the difference between what you collect from your customers and what you pay when you file your sales tax return warrants the giant mess you will have with all of these sales tax codes.
  • Frankly, I recommend that you shut off the QB sales tax feature and let your POS program handle that calculation
  • Double check your ShipCompliant settings

Retroactive to April 1st

This was signed on April 25th and made retroactive to April 1st. So if you already ran your April club run, you are SOL. Sorry.

One final note

Just to clarify what are “California taxable sales”… let’s discuss the 3 ways I have seen wineries handle out-of-state sales

Out-of-State Options

  1. If licensed in that state, charge that state’s rate. Report and pay to them.
  2. If not licensed in a state
    1. Charge CA rate. Report and pay to CA
    2. Charge zero. Since the wine was shipped out-of-state, CA cannot say it was a CA sale so it is excluded. Since you are not licenced, do not report, and do not pay that state, and include with the Out-of-State exclusion on your sales tax return.
    3. Use a third party shipper like Vinoshipper. Their system will charge the tax, collect it, report it, and pay it.

Discuss with your Compliance specialist or legal team which option you are comfortable with.

Stay tuned for that mini-course on Sales Tax I have been promising for over 3 years now….

Cheers!

Jeanette

 

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

The Crush

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