QB Winery Solutions

Office Hours 6-30-20

by

Here is the recording for Office Hours from June 30, 2020. You can find the following wine accounting & QuickBooks topics in this month’s recording:

1:00 – Processing transactions and payments divided between Square and Venmo in QuickBooks.
16:00 – Searching credits by customer in QuickBooks.
23:00 – Reporting via Weebly, Sqaure and QuickBooks, manual vs. automated reports and mapping via Transaction Pro.

Silver Club members, please log in to view the recording

Office Hours 4-16-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. One-step, Two-step Bottling (3 minute mark)
  2. Online bill pay – QuickBooks Online Vs QuickBooks Desktop (9 minute mark)
  3. QBox Plus – securing a file to specific people & sharing files (10 minute mark)
  4. Bill.com for bill pay (12 minute mark)
  5. Will the PPP be increased? (15 minute mark)
  6. Grapes bills – How do they come out of your checking account (21 minute mark)

 

Silver Club members, please log in to view the recording

Office Hours 4-14-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. Virtual tastings – How to turn your events to an online environment (3 minute mark)
  2. PPP & the black box (12 minute mark)
  3. Websites that allow you to submit your PPP application (16 minute mark)
  4. Verification phase of the PPP & medical payments (23 minute mark)
  5. Paypal as a payment processor in addition to Square (30 minute mark)
  6. Costing book & Bottle Runs (32 minute mark)
  7. Cash Flow projections, discounted wines & club runs (38 minute mark)

 

Silver Club members, please log in to view the recording

Office Hours 4-9-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. How to track giving a client a case of wine (2 minute mark)
  2. Final review of Sync with Commerce Review & Square (5 minute mark)
  3. Using Square for a data dump and getting net sales (13 minute mark)
  4. Transaction Pro Importer – push in the data into QuickBooks (15 minute mark)
  5. Quick review of the PPP (24 minute mark)

 

Silver Club members, please log in to view the recording

Office Hours 4-2-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 – How well does it sync? (6 minute mark)
  2. Shogo.io – Tracking transactions (11 minute mark)
  3. Square – Individual sales reports, transactions & batching (15 minute mark)
  4. Square & Quickbooks mapping – VineSpring (32 minute mark)
  5. Manually entering into Square – Less expensive than VineSpring (39 minute mark)

 

Silver Club members, please log in to view the recording

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

The Crush

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