Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
fengzhang66
Level 1

Grocery store bookkeeping

I need to record daily sales and track inventory
2 Comments 2
Fiat Lux - ASIA
Level 15

Grocery store bookkeeping

Make sure you have QBO Plus or Advanced to manage inventories.

https:// quickbooks.grsm.io/US

https:// quickbooks.grsm.io/us-promo

 

How to record your daily sales, visit the following reference

https:// quickbooks.intuit.com/learn-support/en-us/help-article/sales-receipts/record-total-daily-sales-quickbooks-online/L0rHb69Mh_US_en_US?uid=l6nq6n19

 

MariaSoledadG
QuickBooks Team

Grocery store bookkeeping

Let's make sure you'll be able to record daily sales and track inventory when using QuickBooks Online, fengzhang66.

 

QuickBooks lets you record daily sales to keep your income reports accurate. To do this, you can enter a single sales receipt to report the total daily sales in QuickBooks. To do this, first, you'll have to create a customer for daily sales.

 

  1. Go to Get paid & pay or Sales, then select Customers (Take me there).
  2. Select New customer.
  3. Enter "Daily Sales".
  4. Select Save.
     

Then, set up account for daily sales to have an accurate income reporting.  Here's how:

 

  1. Select the Gear icon on the Toolbar.
  2. Under Your Company, choose Chart of Accounts.
  3. Select New at the top right.
  4. Set up these accounts:

 

Once done, set up a "Daily Sales" category to keep your items organized:
 

  1. Select the Gear icon on the Toolbar.
  2. Under Lists, choose All Lists.
  3. Select Product Categories.
  4. Select New Category at the top right.
  5. Name the new category "Daily Sales".
  6. Select Save.

 

After setting up the Category, next are the items:
 

  1. Select the Gear icon on the Toolbar.
  2. Under Lists, choose Products and Services.
  3. Select New at the top right.
  4. Set up these items. Note: Make sure to select Daily Sales as Category for each item.

 

Next, create a daily sales template to record total daily sales ,and lastly, deposit them. For clearer steps, you can visit this article for detailed steps: Record Your Total Daily Sales In QuickBooks Online.

 

Aside from that, as what @Fiat Lux-Asia mentioned, tracking inventory is only available in QuickBooks Online Plus and Advanced. You'll have to ensure to turn on inventory tracking  to add inventory. Follow the steps provided below: 

 

  1. Go to Settings ⚙ and select Account and settings.
  2. Select the Sales tab.
  3. Select Edit ✎ in the Products and services section.
  4. Turn on Show Product/Service column on sales forms.
    You can also turn on price rules if you want to set up flexible pricing for the things you sell.
  5. Turn on both Track quantity and price/rate and Track inventory quantity on hand.
  6. Select Save and then Done.

 

After that, you can now add your inventory products and keep track of what it sells. Also, use reports to check the status of your inventory. I've provided this article for more additional information: Use Reports To See Your Sales and Inventory Status

 

That should let you perform accurately your grocery store bookkeeping when using QuickBooks. Moreover, aside from those inventory reports, QuickBooks offers a variety of reports that helps you track each angle of your business. You'll just have to customize them so they would show the information that you need. For more information on how to filter them, check out this article for your reference: Customize Reports In QuickBooks Online.

 

Please touch base if you have any other concerns about daily sales and inventory. We're here to make sure that everything is covered

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us