[Question] QB Point of Sales integration with QB Bookkeeping

[LindaK]

I was hired to straighten out the books for a computer retail and repair shop. They have QB Point of Sales (POS) and QB Financial (Bookkeeping) Software. I am very familiar with QB for bookkeeping but have never worked with QB POS. Is anyone familiar with the POS system and how it functions with the accounting software. My current dilemma as I am just starting into this project is why receiving vouchers are coming across to QB Bookkeeping functioning as an invoice. They come across and go in as a billed item to the customer, seeming to leave no where to utilize the invoice.

As we would normally
1) Create a purchase order
2) Receive items with or without bill (in this scenario we will say without bill) choosing the applicable purchase order to bring the information forward and receive it.
3) When we receive bill (invoice) we would enter bill against inventory, creating a bill to be paid to that vendor.

I have read a bit on the net of many who are disgruntled with the QB point of sales system and all the glitches it has in the integration.

Any help would be greatly appreciated.

[bluewaterbusiness]

Hi Linda- I got the following from the QB POS help menu. Sorry it is so lengthy. You can also visit the QBPOS COMMUNITY for answers to specific questions. My understanding is that there are various ways to configure the Financial Exchange between QB and QBPOS.

From Intuit:

"Receiving merchandise into inventory always increases your Inventory Asset account. Other accounts affected and documents created depend on:

Where you choose to enter vendor billing information (Point of Sale or QuickBooks)

Whether the merchandise has already been paid for

Whether you send summarized or detailed receiving information (controls whether item information is included)

What version of QuickBooks financial software you are using

If you elect to enter billing information in QuickBooks financial software:

Use this option if you prefer to handle all vendor billing tasks in your financial software. This is the default setting for new Point of Sale users.

The vendor billing fields (payee, terms, bill date, invoice/reference #) are NOT available on the receiving voucher form in Point of Sale

All vouchers are sent immediately to QuickBooks as item receipts

When the billing information is received from the vendor, enter it in QuickBooks and the item receipt is converted to a bill in Accounts Payable

If the vendor billing information received and entered in QuickBooks includes charges or adjustments not entered on the original voucher in Point of Sale, such as a freight charges, discounts, or fees, there will be a difference between the documents in the two programs unless you also edit the voucher in Point of Sale to add these items.

If you elect to enter billing information in Point of Sale:

This is the default setting if you have upgraded from a version of Point of Sale prior to 5.0. If upgrading from Version 5.0, your prior setting is retained.

The vendor billing fields (payee, terms, bill date, invoice/reference #) are added to the receiving voucher form in Point of Sale

Receiving vouchers are sent to QuickBooks in different ways, depending on whether billing information (Invoice/Ref#) has been entered:

If billing information is received and entered when the voucher is initially created, the voucher is sent directly to Accounts Payable as a bill. No general journal entry is created.

If billing information is not initially entered, the voucher is sent to the Unbilled Purchases liability account and a general journal entry is made. Later, when the voucher is edited in Point of Sale to add billing information, the voucher is sent a second time as a bill to Accounts Payable and removed from the Unbilled Purchases account.

If the Already Paid checkbox is selected (meaning you have prepaid the vendor for the merchandise), the voucher is sent as an item receipt whether billing information is entered or not. No general journal entry is made. You should manually apply the previously made amount to the item receipt in QuickBooks.

Fees and Discounts on Vouchers

If a voucher with unspread fees and/or discounts is sent to Unbilled Purchases, the fees and discounts will not be taken into account on the initial general journal entry. Instead, the final bill sent to your financial software (once an invoice for the voucher has been received) will be adjusted to reflect any fees or discounts. If you spread these amounts over the item costs, the amounts are reflected in the net item costs.



Note: If you send detailed item information to QuickBooks financial software, individual items will be listed on the QuickBooks document created However, information on General Journal transactions created for vouchers where billing information has not yet been entered never show individual items.

You can view the specific document or journal entry created In QuickBooks for a receiving voucher via a link in your Point of Sale receiving history list."

I hope this helps!

[LindaK]

Angie,
Don't apologize for being lengthy. This looks like some great information. Thank you also for the link to the QBPOS Community! I will review the post and QBPOS Community at length tomorrow.

I have been reviewing the QB POS manual on site, it has also started to make sense. Thanks so much!

[bluewaterbusiness]

Just let me know if you need any other help!

[StephanieP]

Hey there,

I'm not completely familiar with all the technical stuff that goes along with integrating QB Financial software and QB POS (we have an IT guy for that ), but here's the gist of how it works here.

• The warehouse receives product
• The items are received in the POS system, generating a Receiving Voucher that shoots over to me (QB Finance) - It shows up in my system as an Item Receipt
• I then Enter Bills Against Inventory which turns the Item Receipt into a bill so that I can pay the invoice

Hope that helps a bit as far as the general process goes.