Inventory, Purchase Orders, COS, Bill Payment, Shrinkage

I've got you covered, Geoffrey Cann.

Let's make sure the Initial Cost is added to the items. This way, the Cost of Sales will show on the Profit and Loss report. Here's how:

1. Go to the Gear icon and then select Products and Services.
2. Locate the stock item and click on the Edit link.
3. Then, locate the Starting Value hyperlink, and click it. 
4. On the Initial Cost box, enter the cost of the product.
5. Once done, click on Save and Close.
6. Repeat the process for the other items.

Once done, run the Profit and Loss report to view the Cost of Sales.

For the bill payment, you can check where it was reported by running the Bills and Applied Payments report. Here's how:

1. Go to the Reports menu.
2. Search for Bills and Applied Payments Report.
3. Click Customize to filter the correct payment.
4. Once done, click on Run report.

As for adding an amount in Sales price/rate, this will not be added to the sales figures as long you don't create any sales transactions. 

Additionally, I encourage running reports in QuickBooks Online to see your best sellers, what’s on hand, the cost of goods, and more. This ensures your data is accurate.

If you have any more questions, please don't hesitate to reach back out. I'm always a comment away!

Hi

FYI

• Business is a Sole Trader Public House with Casual Dining
• Purchase Orders used only for Wet Stock (Tied to Brewery)
• All Stock items have Purchase Cost inputted
• Accounts are using Accrual method 

Please confirm if my understanding is correct for each of these points

• Stock Shrinkage represents my Cost of Sales in P/L Report?
• This figure is only accurate following most recent stock count? 
• Stock Transactions > Purchase Orders, Bills, Bill Payments are not posted to Accounts > P/L, VAT?
• Stock Transactions > Bank Transactions, Bills, Bill Payments are solely used for Reconciliation purposes?
• Sales Income figures are solely represented in P/L from imported Zettle Sales Data?
• Sales Income figures are not generated from Stock Shrinkage in P/L?

As for adding an amount in Sales price/rate, this will not be added to the sales figures as long you don't create any sales transactions. > Does this refer to sales processed using QBO and not those imported from my ePOS Zettle?

Thanks for getting back to us, Daltons.

Yes, you're correct about the Stock Shrinkage. This represents your Cost of Sales in the Profit and Loss report. The figure is also accurate following the most recent stock count.

As for the stock transactions you've mentioned, they're not reported in the Profit and Loss report. You can run Vendor reports to view them.

Aside from the transactions that are solely used for reconciliation you've added, these also included the manually entered data in the program that affects the accounts.

Also, Sales Income figures are represented in the Profit and Loss report from the imported Zettle data. The amounts aren't generated from Stock Shrinkage in the report.

Lastly, when using the newly added Sales price/rate in your sales transactions, this refers to QuickBooks and the ePOS Zettle sales.

I’m also adding this article that you can read for reference in case you need to add another product to your account: Add stock products in QuickBooks Online.

If you have other follow-up questions about managing your stocks, you can always tag me in your reply. I’m always around ready to help you. Have a good one! 

Hi

Further to my previous questions from last June.

I find I am not updating stock levels consistently.  What would be the implications of switching off Stock/Product Tracking?

My hope is to simplify my P/L with COS Food & COS Wet > Sales Food & Sales Wet.

Regards

Geoffrey E Cann

Hi Geoffrey, thanks for getting back to us here - you'd need to ensure that all stock items are inactive and have a quantity on hand of zero before turning off stock tracking. If you have items with a non-zero balance, you can adjust the qty on hand to zero before making these inactive (select the drop-down beside the stock item> adjust quantity). This will create an adjusting journal that posts to the stock shrinkage (cost of sales) account. You could then set up your simplified items as non-stock products, which you'll be able to select when entering transactions. :)