QB Winery Solutions

Office Hours 3-31-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. Commerce Sync – Researching automated transactions. Is it effective? (1 minute mark)
  2. How to track merchandise (12 minute mark)
  3. PPP – Paycheck Protection Plan (21 minute mark)
  4. Square POS – Tracking where sales occur (24 minute mark)
  5. Selling Gift Cards (31 minute mark)
  6. Label redesigns & the costs associated with it (35 minute mark)

 

Silver Club members, please log in to view the recording

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

Office Hours 2-25-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. Picking Bins – What Account should they be sold under? How is it invoiced and how’s it taken out of assets? (1 minute mark)
  2. VinoShipper – an option for small wineries looking to ship out of state (11 minute mark)
  3. Costing & Grapes – Growing your own grapes? What’s your yield of Farming VS Winery? (14 minute mark)
  4. Changing to cash basis for the tax return. (23 minute mark)
  5. Ready to sell wine? How to track bottle sales & sales by the glass (29 minute mark)
  6. Managing gratuities (33 minute mark)
  7. Traveling to events to sell your wine? Changing the tax rate using Square (35 minute mark)
  8. Preferred Class Lists – Keep them simple (43 minute mark)

Need help with creating classes and job flags? Watch “Using QB in the Wine Industry” for more information.

Silver Club members, please log in to view the recording

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

Office Hours 11-26-19

by

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

  1. Part 1: I purchased a barrel from my client. I also owe the same client a credit from a previous production contract -How do I record this transaction? – at the .41 min. mark
  2. Part 2: How do I convert my client’s bill into a credit- at the 1.25 min mark
  3. How do I create a statement? at the 7.55 mark
  4. I lost a barrel of wine. How do I track the cost of wine that was lost? – at the 15.42 min mark
  5. Grape Bills – How do I record the grapes that were over my contract amount?  I did not have to pay for them – at the 16.34 minute mark
  6. I did not order enough glass or corks – How do I account for the wine I did not bottle? – at the 17.49 minute mark
  7. How do I record use ONE bill to record my grape bill, but pay the bill per my installment agreement? – at the 19.50 minute mark
  8. I have 4 users who need to access our QB file – 2 users only have access to MacOS – Should I use QBO? – at the 27.02 minute mark

Silver Club members, please log in to view the recording

Office Hours 10-29-19

by

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

  1. Part 1: I watched the Grapes, Grapes Grapes course, but I am a VERY Small winery – Do I have to use the clearing account to record my grapes? – at the .51 min. mark
  2. Part 2: Why should I use Purchase Orders during harvest? – at the 3.11 min mark
  3. How do I find if the cost inventory is set up in the file? (We show how to find the report and how to use it) at the 22.18 mark
  4. What are the 5 Fundamentals of a winery QuickBooks File – at the 36.53 min mark
  5. Is there a more simple way to do the costing book? – at the 43.38 minute mark

Silver Club members, please log in to view the recording

Office Hours 09-24-19

by

Here is the recording for Office Hours. The topics that came up were:

  1. I am moving my accounting from spreadsheets to QuickBooks – Which QuickBooks type and version should I use? – at the 1 min. mark
  2. How to get a “jump start” on your costing book – at the 8 min mark
  3. Tips for recording bottling cost – At the 11 min mark
  4. Counting inventory to keep your cost accurate – including corks and foils! – at the 12 min mark
  5. How to record bottling expenses using the chart of accounts – at the 17 minute mark
  6. True up Bottle Pieces and where to put the inventory adjustment – at the 23 minute mark

Silver Club members, please log in to view the recording

Office Hours 08-27-19

by

Here is the recording for Office Hours. The topics that came up were:

  1. Creating an invoice for a client that includes reimbursable expenses. (How to enter a bill or check with the reimbursable expense and tag a client so you can add to their invoice.)
  2. Moving custom crush bulk wine to COGS; – at the 11.50 min. mark.

Silver Club members, please log in to view the recording

Office Hours 07-30-19

by

Here is the recording for Office Hours. The topics that came up were:

  1. After 10 years of business, how do you fix your QB file? at the 1:01 min. mark
  2. Converting QB Desktop to QB Online; things to consider – at the 18.40 min. mark.
  3. File Hosting in QB (alternatives to QB online) – at the 22:30 min. mark.
  4. Bottle Runs – recording case goods into inventory (hint: not when you sell them) – at the 32:00 min. mark
  5. How to record and track the purchase of grapes – at the 36:33 min. mark.
  6. How to record custom crush contract expense – at the 45:07 min. mark.

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.