QB Winery Solutions

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

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 05-28-19

by

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

  1. Tagging Reimbursable Expenses – at the 19 min. mark.
  2. Tracking custom crush client invoices – at the 32 min. 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 01-29-19

by Leave a Comment

 

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 Leave a Comment

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

MY FAVORITES

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

Blog/Quickies

CLICK HERE to view Quickies Blog items.