Inventory Items
Managing inventory in QuickBooks Online
QuickBooks Online offers robust tools for tracking products, cost of goods sold (COGS), and inventory value. To ensure your records remain accurate, it is important to use the correct workflows for setup, reporting, and adjustments.
This guide covers common inventory tasks and how to handle them within the QuickBooks Online interface.
Setting up initial inventory balances
When you begin tracking inventory, you must enter your starting quantities and values correctly to avoid duplicating dollar amounts in your asset accounts.
Do not use journal entries for inventory setup. Journal entries cannot link to specific inventory items, which prevents QuickBooks from accurately tracking quantities and cost layers. Instead, use the dedicated inventory features:
- Go to the Settings (gear icon) and select Products and Services.
- Select New to create your inventory items.
- Enter the Initial quantity on hand and the As of date (the start date you begin tracking).
This process automatically records the value to your Inventory Asset account and the offset to Opening Balance Equity, ensuring your books are balanced from day one.
Expense accounts vs. Cost of Goods Sold (COGS)
It is important to distinguish between standard business expenses and inventory costs.
- Expense Accounts: Use these for costs that are not held as inventory assets, such as office supplies or immediate repairs.
- COGS Accounts: Use this account type for items you buy or manufacture with the intent to sell.
When you sell an inventory item, QuickBooks automatically calculates the cost based on what you purchased and moves that amount from your Inventory Asset account to your COGS account. The calculation relies on the purchase cost and quantity bought, not just the quantity sold.
Tracking inventory by project or job
To view inventory status associated with specific projects or customers:
- Navigate to Reports.
- Search for and open the Transaction Detail by Account report (or similar transaction detail reports).
- Customize the report to group or subtotal by Customer or Project.
- Filter the report to show only inventory items and relevant transaction types (such as purchases and sales).
This allows you to see the flow of inventory items in and out of specific jobs, which may provide more detail than standard stock status reports.
Moving costs from Work in Process (WIP) to Inventory
If you manufacture items and accumulate costs in a WIP asset account, you must move those costs to finished inventory. You can do this using a specialized transaction:
- Create a generic vendor (e.g., named “WIP Clearing”).
- Ensure your finished inventory items are set up with zero quantity and zero cost initially.
- Open the + New menu and select Check (or Expense).
- Select the “WIP Clearing” vendor.
- In the Item details section (line items), select the finished inventory items, enter the quantities, and enter the total costs.
- In the Account section (or the Expenses tab depending on your view), select your WIP asset account and enter the total amount as a negative number.
- Save the transaction. The result will be a $0.00 check that clears the balance from your WIP account and updates the inventory value and quantity.
Using custom fields for inventory
You can add custom fields to your inventory items to track additional data, such as serial numbers or bin locations.
- Go to Settings and select Products and Services.
- Edit an existing inventory item or create a new one.
- In the item details, look for the Custom fields section.
- Select Add to define new fields or manage existing ones.
If custom fields are not appearing, ensure you are using a supported browser and that your user permissions allow for modifying item lists.
Importing bulk inventory data
For warehouses or businesses needing to add large volumes of inventory items or lines to purchase orders, manual entry is not efficient.
- Importing Items: You can import inventory item lists directly using Excel or CSV files via the Import Data tool found in the Settings menu.
- Importing Transactions: While QuickBooks Online supports importing lists, complex transaction imports (like purchase orders with thousands of lines) often require third-party apps or specific file formats. Visit the Apps menu in QuickBooks Online to find solutions that facilitate bulk transaction imports from spreadsheets.
Troubleshooting inventory entry issues
If you are unable to enter or adjust inventory quantities, or if the inventory features are missing:
- Check User Permissions: Only the Master Admin or a user with “Full” inventory permissions can adjust inventory quantities and values. Standard sales users may be able to view items but cannot change stock levels.
- Browser Issues: If you are an admin and still facing issues, clear your browser cache and cookies, or try logging in using an incognito/private window.
- Performance: QuickBooks Online is a cloud-based solution, so performance is not dependent on your local computer’s memory. If you are experiencing slowness with a very large item list, ensure your internet connection is stable.