Hi. How can we help?

Stock management with the QuickBooks Online integration

  Plan availability

  Lite   Pro   Enterprise    |     Standard    Advanced  

 

Accounting for stock/inventory costs is important to help you understand whether your retail business is making money. You'll need to understand how much your stock costs you, and how much your inventory is worth.

It is essential that you use Retail POS's stock order feature when adding new product inventory. If you do not, your product costs will be incorrect. To sync stock orders, you also need to have a QuickBooks Essentials plan or higher.

When you're processing your stock orders through Retail POS, you'll need to send these to QuickBooks Online to create an accounts payable invoice in QuickBooks Online. Unlike the rest of the integration, this does not happen automatically.

To post a received stock order to QuickBooks Online:

  1. Navigate to the Stock Control page in Retail POS.
  2. Filter the stock order page by Received orders.
  3. Click Send to QuickBooks Online to create the invoice in QuickBooks Online.retail-pos-quickbooks.png
  4. You can now click the View on QuickBooks Online button to load the invoice in QuickBooks Online.
    retail-pos-view-quickbooks.png

When you pay your invoice, you can match the outgoing payment transaction in your bank feed to the accounts payable invoice in QuickBooks Online.

The information sent to QuickBooks Online is:

  • Date the order is fully received in QuickBooks Online
  • Supplier name
  • Products received
  • Quantity received
  • Order name and Supplier Invoice Number is sent to the reference field in QuickBooks Online
  • Supply cost (exclusive of tax). Tax is applied by QuickBooks Online according to your settings.

    For retailers in the US and Canada, QuickBooks Online features automated sales tax and will calculate the correct tax rate based on customer tax exempt status, location, and type of product sold.

  • The due date on the bill will be based on the supplier's terms in QuickBooks Online. You can update the supplier's terms in QuickBooks Online if you'd like to change this.

All product costs will be sent to the Inventory Asset item designated in your QuickBooks Online setup page.

Shipping costs are not automatically included. You can create a 'Shipping costs' product with no tax, no price and no inventory tracking in Retail POS, and add it to the order when it is received to track stock costs for each order.

Stock Adjustments - breakage, wastage, shrinkage and inventory counts

It is important to track adjustments to your stock levels, whether they are damaged or broken stock, wastage (like food at the end of the day), or shrinkage (stolen items). Sometimes, you'll know about the loss when it happens (damaged stock, wastage), and other times, you might not realize until you do an inventory count.

All of these different types of adjustments can be recorded in Retail POS using the Inventory Count feature.

Stock adjustments, including inventory counts, are not able to be directly sent to QuickBooks Online. You'll need to complete a manual journal in QuickBooks Online to account for these.

Was this article helpful?