QB Winery Solutions

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 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

Office Hours 06-25-19

by

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

Note: The first question was not captured on video. The topic and answer can be found in our forum here

  1. Converting QB Desktop to QB Online; things to consider – at the .26 min. mark.
  2. Inventory Date when converting from QB Desktop to QB Online – at the 12:34 mark.
  3. CA Consumer Privacy Act – at the 14:00 mark.

Silver Club members, please log in to view the recording

Office Hours 04-30-19

by

Here is the recording for Office Hours. The topics that came up were (follow the links for additional information):
  1. Inventory Tracking In QB – at the 10:04 min. mark
  2. Intuit Help is more for tech support then winery support – at the 10:11 min. mark
  3. Entering 3 Liter Bottles into inventory – costing sheet – at the 10:12 min. mark
  4. Wine for Donations/ Depletions – at the 10:14 min. mark
  5. Merchandise – grouping, baskets, assemblies Inventory – at the 10:22 min. mark
  6. Back to Inventory – at the 10:30 min. mark
  7. Bottling – at the 10:33 min. mark
  8. Bottling Game Plan – at the 10:52 min. mark
  9. Labor Cost – at the 10:54 min. mark
  10. Barrel Cost Allocation – at the 10:56 min. mark
    1. Downloads for the Calculate the True Cost of Wine Course
    2. Module 2 – Allocation Math
    3. Example Depreciation Spreadsheet
      1. Note a lesson on this will be out soon!

Silver Club members, please log in to view the recording

Office Hours 03-29-19

by

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

  1. How to bookmark pages and posts to find them again
  2. Items names and how to merge them – making sure they are set up correctly – at the 5:40 min. mark
  3. Invoicing wine to yourself and how to receive the payment (using AR clearing and JE to transfer to owner loan account or check) – at the 9:42 min. mark
  4. QB Online – at the 12:46 min. mark
  5. Qbox and cloud sharing – at the 12:08 min. mark
  6. Sales Channels (classes) –
  7. Food Sales in Tasting Room/ Food Costing – at the 38:13 min. mark
  8. Key Reports for Month Use, Yearly Processes – at the 42:05 min. mark:

Silver Club members, please log in to view the recording

Office Hours 02-26-19

by

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

  1. JE for Transferring Inventory for the new year
  2. How to Memorize a JE
  3. Separating out Packing & Shipping cost for retail
  4. Closing Processes for the year-end <include link to year-end checklist
  5. Resetting Inventory Accounts
  6. The cost to Aquire an asset
  7. Fixed Assets/ deprecations
  8. Shipping through another winery and how to account for the cost
  9. Sales tax
  10. Square
  11. Discounts
  12. Direct and Indirect Costs

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.

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.