QB Point of Sale Handbook for Wineries Excerpt

Submitted by Will on October 04, 2011

Excerpt from the QuickBooks Point of Sale Handbook for Wineries:

QuickBooks Point of Sale is an inventory control and customer facing sales tool that works well in winery settings.  While it has numerous strengths that make it good fit for the winery that need up to 20 workstations and (given the version) can manage 20 different locations (each with 20 workstations), one of its great benefits is the strong integration with QuickBooks Financial products that you may already be using.  QBPOS will update QBFS with all of the inventory values, sales, sales tax, inventory value adjustments, etc that originate in QBPOS so that you do not have to manually reenter transactions in your accounting.   

Contact us for more details and to purchase your copy or Order Online.

(858) 467-0400 Local
(877) 467-0451 Toll-Free Outside of San Diego
info@englishmgmt.com

 

Creating Inventory Items in QB Point of Sale

Submitted by Will on September 21, 2011

Excerpt from the QuickBooks Point of Sale Store Operations Handbook:

Since one of the primary purposes of any Point of Sale system is to track inventory, it is important that you receive, sell and adjust the inventory correctly.  This will ensure that you have accurate margin reports as well as accurate financial reporting. Our example assumes that we have no prior inventory and are receiving items from a purchase order.  We will show you later how to receive items without a purchase.  By creating a purchase order, you obtain several advantages such as knowing what you ordered and the cash that you have committed.  Also, by using the purchase order, you can create items on the fly and input order quantities.  That will save time by combining two steps into one process. 

QuickBooks POS on Sale Now

Submitted by Will on August 16, 2011

Don't forget about the August promotions that expire on August, 31st!

QuickBooks Point of Sale (POS) + Payments: Intuit QuickBooks Point of Sale customers get a package of savings worth over $660 when they apply for a merchant account!

QuickBooks Enterprise Solutions: Businesses who are currently using QuickBooks and updgrading to QuickBooks Enterprise Solutions will receive 20% off of the QBES list price on the 5 and 10 user SKUs. 

Intuit QuickBooks financial customers save BIG with Intuit Payment Solutions!

Intuit Credit Card Readers: Approved Intuit GoPayment accounts will receive a Free Intuit Credit Card Reader!

Enhanced Payroll will be paid as a one-time bounty of $25.

Read all of the details!
Contact us for a complimentary consultation to learn more about which product will best serve your business needs and for an all inclusive price quote.

QB & QB POS in Business with Both Retail and Restaurant

Submitted by Will on August 15, 2011

QuickBooks Point of Sale: Basic 8.0
A business owner who uses QBPOS v8 recently asked: My business has both a retail shop and a restaurant in one location. We purchase wine and food, some of which is sold to customers in the retail shop and some of which is regularly taken back to the restaurant. For retail sales and inventory vouchering, we use QB POS. For restaurant sales, we use Dinerware.

My issue is how to track inventory when it is getting "taken" from the retail into the restaurant? Do a physical inventory adjustment? A sales receipt with a 100% discount or something else?
Basic flow is: 1) items are ordered and received in retail shop (vouchers created in QB POS); 2) some items are sold through QB POS, which adjusts inventory and COGS properly; 3) some items are "taken" to the kitchen and bar for sales to restaurant customers (those sales are entered in Dinerware); 4) Every night, we enter one bulk "restaurant sale", which is actually an item in QB POS with a price of $1 and a cost of $.30 (intended to be the basic COGS in the restaurant). So, if we did $5000 in restaurant sales, we would enter a receipt for 5000 of the item "restaurant sale". This takes into account restaurant income and (sort of) COGS, but does NOT account for inventory.
Is there a way I can accurately track the inventory of items that go back to the restaurant? Is there a better way for me to enter the restaurant sales in QB and QB POS?

Solution: Create a quantity adjustment memo to adjust the quantities taken for the restaurant. This will post to an account called POS adjustment expense which can be moved to your Restaurant COGS.
I’m curious as to if you receive all inventory through POS, even those things not sold in the store. I assume you that don't. In either case, I would like to offer a free 30 min consultation to discuss your needs.  We have a number of clients in your industry whom we have helped.
 

Tax Exempt Sales Not Showing on POS Reports

Submitted by Will on August 11, 2011

Q: I have marked some customers as tax exempt in their information box in Point of Sale (POS), but my QuickBooks financial tax liability and tax summary do not post the "tax exempt sales. I have been having to locate it in other POS reports.

A: This is a bug and I’m not sure why they don't fix it.  What is happening is that although the sale is exempt and the right amount of tax is being collected, the customer is not being set as non-tax. We train never to use the exempt box. It is much more useful to set up tax locations for the various types of exempt customers you have. For example, tax location reseller and another out of state.  In this way, the POS report will be much more useful and you can ignore the QBF reports.
 

How can I create a Credit Memo in QB POS

Submitted by Will on August 09, 2011

Q: Is there a way to provide credit to a customer for a return so you can give a discount on the items on a new purchase?

A: Invoices and Credit Memos are only created when you connect POS to QuickBooks Financial software (QBFS) and use the account payment type.  So if you do connect the two, create your refund transaction. This will give the customer credit that can be used to discount another transaction by using the account payment type for the credit. Then the customer only needs to pay the difference.
 

Correcting Integrated Invoices

Submitted by Will on August 04, 2011

QuickBooks Pro for Windows: 2010

Q: How do I correct integrated invoices to have the "to be printed" checked on an invoice?QB POS charge accounts previously would integrate with financial. At the end of the day I could go into financial print forms and all the day's invoices would be there. Now I have to go to each invoice and check the to be printed button.

A: So, at some point you unchecked the "to be printed" box.  This means that all of the invoices will be set not to print.  To fix this, record an invoice with the checkbox checked and all new invoices will be set to print.  You can't really do anything for the previous invoice.

ReRegistering QB POS Everyday

Submitted by Will on August 03, 2011

Q: I reregister QB POSv10 every day. Each time that I shutdown POS v10 I have to clear the entitlements clients’ folder and reenter the validation codes to get it to work. Do you know of a solution to this? Support hasn't been able to help.  This has worked for over 6 months.  Also, now my other POS workstation will not work with the server workstation.

A: While I can't help you with the first part as none of my clients are having that problem, I can help with the second question. POS keeps the server information in a file called WSactivity.xml.  Depending on your operating system, the file will be in different places.  In Win 7, the location C:\ProgramData\Intuit\QuickBooks Point of Sale 10.0\Ini.  Just delete this file and the workstations will try to reconnect rather than looking for the old file.
 

QuickBooks POS Sales Report

Submitted by Will on August 02, 2011

Q: In Quickbooks POS, I can't get my sales reports to show group items as they were sold. Instead, it shows me all of the separate units. Any idea as to why this is happening?

A: Group items are not really an item, but a grouping of other items. It is a way to put items on sales receipts in a group. For this reason, it will not list group items.  If you want to track those sales and report on these, you would need to create an assembly. Once you build the assembly, it will remove the items and create an assembled item that can be tracked. It pulls the items from inventory and tracks them as an item.