---
title: "QuickBooks Online stock count from a sheet · Hypamoon"
description: "Typing a physical stock count into QuickBooks Online item by item? Count on a phone or in a sheet, check the differences and post them as one adjustment."
url: https://hypamoon.com/connect-to/quickbooks-online/stock-count
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [QuickBooks Online](https://hypamoon.com/connect-to/quickbooks-online)
3.  Stock count

For teams that run on QuickBooks Online

# QuickBooks Online stock count from a sheet

QuickBooks Online has no way to import a stock count. Shops and wholesalers print a list, count, and type each new quantity into an inventory adjustment, which takes hours with hundreds of items.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=quickbooks-online/stock-count)

## How it goes today

1.  Print the list of inventory items.
2.  Count and write the quantities on paper.
3.  Type each new quantity into an adjustment.
4.  Check the stock value afterwards.

## How it can go

**A stock count goes into QuickBooks Online as one adjustment, after you check it.**

You count on a phone page, or fill in a sheet with the items from QuickBooks Online. You see the difference per item in quantity and value. After your approval, one inventory adjustment is posted in QuickBooks Online on the date of the count. This works with QuickBooks Online Plus and Advanced in the United States.

## Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. QuickBooks Online works with a sign-in instead of a key: you sign in to QuickBooks Online once to give access, never in the chat.

Your request

> With Hypamoon, give me a phone page and a sheet with our inventory items from QuickBooks Online to count. Show the difference per item in quantity and value against QuickBooks Online. After I approve, post one inventory adjustment in QuickBooks Online dated on the count day, and email me the list.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~quickbooks-online/stock-count&say=a%20stock%20count%20from%20a%20phone%20page%20or%20sheet%20posted%20as%20one%20QuickBooks%20Online%20inventory%20adjustment%20after%20my%20approval.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=quickbooks-online/stock-count)

You create your own app on the Intuit Developer Platform and connect your QuickBooks company once. It stays yours.

## More for teams on QuickBooks Online

-   [**My customers want a receipt when they pay, and I send each one by hand.**](https://hypamoon.com/connect-to/quickbooks-online/payment-receipts)
-   [**I want statements to go out every month, only to customers who owe us.**](https://hypamoon.com/connect-to/quickbooks-online/statements)
-   [**Every month I add up the reports of each company in a spreadsheet.**](https://hypamoon.com/connect-to/quickbooks-online/group-reporting)
-   [**Working out interest on every late invoice takes too much time.**](https://hypamoon.com/connect-to/quickbooks-online/late-payment-interest)
-   [**We raise prices each year and change every recurring invoice one by one.**](https://hypamoon.com/connect-to/quickbooks-online/recurring-invoice-prices)
-   [**I want to download a full year of receipts at once for my accountant.**](https://hypamoon.com/connect-to/quickbooks-online/document-archive)
-   [**I want to see per customer how many days they take to pay.**](https://hypamoon.com/connect-to/quickbooks-online/payment-behaviour)
-   [**A customer pays many invoices at once and I match each one by hand.**](https://hypamoon.com/connect-to/quickbooks-online/remittance-matching)
-   [**I make several purchase orders by hand from every estimate.**](https://hypamoon.com/connect-to/quickbooks-online/estimate-purchase-orders)
-   [**I keep a spreadsheet to spread prepaid bills over the months.**](https://hypamoon.com/connect-to/quickbooks-online/prepayments)
-   [**I want customers who do not answer an estimate to get a reminder.**](https://hypamoon.com/connect-to/quickbooks-online/estimate-follow-up)
-   [**I need invoices paid between two dates per rep, not invoices created.**](https://hypamoon.com/connect-to/quickbooks-online/sales-commissions)
-   [**Can you set credit limits for customers to stop invoices or orders being raised?**](https://hypamoon.com/connect-to/quickbooks-online/credit-limits)
-   [**QuickBooks Online doesn't let nonprofits create end-of-year donation letters for donors.**](https://hypamoon.com/connect-to/quickbooks-online/donor-statements)
-   [**It does not create a proper Canadian tax receipt.**](https://hypamoon.com/connect-to/quickbooks-online/donation-receipts)
-   [**We need a report that HMRC accepts when making a Gift Aid claim.**](https://hypamoon.com/connect-to/quickbooks-online/gift-aid)
-   [**Can I set up expenses to split automatically to classes by percentage?**](https://hypamoon.com/connect-to/quickbooks-online/cost-allocation)
-   [**How do I set up payment scheduling on an invoice?**](https://hypamoon.com/connect-to/quickbooks-online/payment-plans)
-   [**Is there a way to have QuickBooks flag a duplicate bill we entered by hand?**](https://hypamoon.com/connect-to/quickbooks-online/duplicate-bills)
-   [**How do you reconcile supplier statements to QuickBooks Online, like a bank statement?**](https://hypamoon.com/connect-to/quickbooks-online/vendor-statements)
-   [**I need to add retention to an invoice and release it when the job is complete.**](https://hypamoon.com/connect-to/quickbooks-online/retainage)
-   [**Is there a report for economic nexus with another state?**](https://hypamoon.com/connect-to/quickbooks-online/economic-nexus)
-   [**What is the best way to track restricted funds for my nonprofit?**](https://hypamoon.com/connect-to/quickbooks-online/restricted-funds)
-   [**Is it possible to sell a product at set, different price levels?**](https://hypamoon.com/connect-to/quickbooks-online/price-levels)
-   [**How can I use discounts to write off small amounts on my customer invoices?**](https://hypamoon.com/connect-to/quickbooks-online/small-balance-write-offs)
-   [**Can you close open estimates in a batch, not one by one?**](https://hypamoon.com/connect-to/quickbooks-online/close-old-estimates)
-   [**Now I have 90 some-odd payments to deposit.**](https://hypamoon.com/connect-to/quickbooks-online/undeposited-funds)
-   [**Does QuickBooks Online Plus have a notification for low inventory?**](https://hypamoon.com/connect-to/quickbooks-online/low-stock-alerts)
-   [**Will it notify you if you are going over budget?**](https://hypamoon.com/connect-to/quickbooks-online/budget-alerts)
-   [**Is there an easier way to track resale certificates?**](https://hypamoon.com/connect-to/quickbooks-online/resale-certificates)
-   [**I need to create a positive pay file for the bank.**](https://hypamoon.com/connect-to/quickbooks-online/positive-pay)
-   [**Since QuickBooks Online cannot import IIF files, I had to hunt down a way.**](https://hypamoon.com/connect-to/quickbooks-online/iif-import)
-   [**I chase clients every month about their uncategorized transactions.**](https://hypamoon.com/connect-to/quickbooks-online/uncategorized-questions)
-   [**We keep a depreciation schedule in a spreadsheet and post it by hand.**](https://hypamoon.com/connect-to/quickbooks-online/depreciation)
-   [**We need approvals, and on our plan that means upgrading to Advanced.**](https://hypamoon.com/connect-to/quickbooks-online/bill-approvals)
-   [**Our government customer wants a Peppol e-invoice, not a PDF.**](https://hypamoon.com/connect-to/quickbooks-online/peppol-invoices)
-   [**I was looking for months for a way to create a customer portal.**](https://hypamoon.com/connect-to/quickbooks-online/customer-portal)
-   [**Everything for QuickBooks Online**](https://hypamoon.com/connect-to/quickbooks-online)
