Inventory parts are parts you stock and count. Bella keeps the On Hand quantity, takes parts out of stock when they’re used on jobs, adds them back when you receive them, and can count stock separately at more than one inventory site, such as a warehouse and each truck. The Inventory menu shows when your account has the Advanced Inventory add-on.
Where to find it
- Inventory > Inventory Parts lists every part. Click a row to open it.
- Inventory > New Inventory Part, or New Part on the list, adds one.
- Inventory parts are items with the type Inventory, so they also show in Accounting > Item List. See Products and Services (Items).
- Admins, and Standard Users with Full Access to Inventory, can add, open and receive parts. View Only users can see the Inventory Parts list but can’t open or change parts.
- With multiple inventory sites on, Standard Users only see the sites assigned to them.
The Inventory Parts list
- Buttons: New Part and Bulk Receive. With multiple sites on, also an Inventory Site box and Bulk Transfer.
- Inventory Site shows the On Hand for one site. Admins can pick All Sites to see the Total On Hand.
- The charts above the list show Inventory totals, Stock levels (In stock, Low, Out of stock), Needs reordering and Stock value by vendor. Stock value by vendor only shows for users who can see costs. Click a part in Needs reordering to open it.
- A red On Hand means the part is at or below its Reorder Point. A red vendor name means the vendor is inactive.
- Type in the Search inventory parts box to filter. The button with three lines lets you choose columns, download a CSV Report or XLSX Report, and tick Display Active Parts and/or Display Inactive Parts.
Part fields
An inventory part has the same name, description, price, cost and account fields as an Inventory item in the Item List (see Products and Services (Items)). The differences:
- The name box is called Name / Number.
- Purchase Information and Sales Information only show for admins and for users with Display Price, Price Level, Amount, and Cost columns in Job Item list and Inventory Part List ticked on their user.
- Taxable is ticked by default on a new part.
- A new part stays open after you click Save, so you can click Receive Inventory right away.
Inventory Information
- On Hand: how many you have. It reads Total On Hand (all sites added up) when multiple sites are on. You can’t type it. It changes when you receive, transfer or use stock.
- Reorder Point: the low-stock level, called Global Reorder Point when multiple sites are on. At or below it, the part shows as low.
- Email for low alert: filling this in turns on a Low Inventory Alert email. It’s sent when a site’s stock is at or below the Reorder Point as the part’s stock changes or the part is saved. The alert goes to your company email and the user who made the change, not to the address typed here.
- Asset Account: the balance sheet account that holds the value of your stock. The COGS Account (in Purchase Information) is where the part’s cost goes when you sell it.
- Site Details: with multiple sites on, a saved part lists each site and its On Hand, with a Transfer Inventory button.
Delete only works for parts that aren’t on any job or transaction. Otherwise untick Active.
Receiving stock
- For one part, open it and click Receive Inventory.
- Quantity Received: required. Starts at 1.
- Receiving Site: required when multiple sites are on.
- Vendor: required. Starts with the part’s Preferred Vendor.
- Accounts Payable: required. The A/P account for the bill.
- Class: only shows when Activate Classes is on in Account Settings.
- Save adds the quantity to the site’s On Hand, records it in Receive History, and creates a vendor bill for the quantity times the part’s Unit Cost. An Inventory Received email goes to users assigned to that site, or to your company email.
- Bulk Receive (Inventory > Bulk Receive): pick the Receiving Site (multiple sites only), then Received From Vendor and the A/P Account, then tick the parts, set each Quantity and click Receive Selected Parts.
- Inventory > Receive History lists each receipt: Received Date, Received By, Inventory Part, Site, Quantity and Vendor.
Good to know: set the Unit Cost before you receive. The bill uses the cost on the part at that moment.
Using parts on jobs
- Whether stock comes off when a part is added to a job or when it’s invoiced is set in Account Settings (Inventory Settings).
- If there isn’t enough stock, Bella stops you with “There is not enough quantity on hand at the site”. Receive more, or turn on Allow On Hand quantities to go negative in Account Settings.
- With multiple sites on, the item selection window on a job has a Site box. Stock comes out of that site.
- Deleting a part’s line item from a job puts the deducted quantity back on hand.
Multiple inventory sites
Turn on Activate Multiple Inventory Sites in Account Settings. If you use Advanced Inventory sites in QuickBooks, see QuickBooks Desktop Integration.
- Inventory > Inventory Sites (admins only): click Add Inventory Site. Fill in the Site Name (required), Description and an address.
- Your Main site’s name can’t be changed.
- A site with stock can’t be deleted. Bella asks you to transfer all its inventory to another site first.
- Each Standard User with View Only or Full Access to Inventory needs at least one site in Assigned Inventory Sites on their user (gear icon > User List).
- To turn multiple sites off again, first move all stock to the Main site with Bulk Transfer.
Transferring stock
Transfers need multiple inventory sites. Admins and Standard Users with Full Access to Inventory can make them.
- For one part, open it, then click Transfer Inventory under Site Details. Enter the Quantity to transfer, Transfer From and Transfer To (they can’t be the same), then click Transfer.
- Inventory > Bulk Transfer: pick the Sending Site, tick parts and set each Quantity (it can’t be more than the On Hand), pick the Receiving Site and click Transfer Inventory.
- An Inventory Transfer email goes to users assigned to the receiving site, or to your company email.
- With Send Inventory Transfer confirmation email on in Account Settings, stock leaves the sending site right away but is only added to the receiving site once an admin confirms it. Pending transfers show in a Confirm Inventory Transfer box at the top of Inventory Parts for admins. Click Confirm.
- Inventory > Transfer History lists transfers made while the confirmation email setting is on: Transfer Date, Transferred By, Inventory Part, From Site, Quantity, To Site, Confirmed Date and Confirmed By.
Step by step
Set up a part and receive stock
- Inventory > New Inventory Part.
- Enter the Name / Number, Unit Cost, Preferred Vendor, Unit Price and Reorder Point.
- Click Save. The part stays open.
- Click Receive Inventory, enter the Quantity Received, check Vendor and Accounts Payable, and click Save.
Add a truck and move parts to it
- Gear icon > Account Settings: tick Activate Multiple Inventory Sites and save.
- Inventory > Inventory Sites > Add Inventory Site. Name it, like “Truck 2”, and save.
- Add the site to the technician’s Assigned Inventory Sites.
- Inventory > Bulk Transfer: Sending Site Main, tick the parts and quantities, Receiving Site Truck 2, then Transfer Inventory.
Example
A pool pump set up as an inventory part:
- Name / Number: Variable Speed Pool Pump, 1.5 HP
- Part Number: VS15HP
- Unit Cost: $225
- Unit Price: $450 (Markup 100%, Margin 50%)
- Reorder Point: 2
- Accounts: Income / Cost of Goods Sold / Inventory Asset
- Receive 5: On Hand goes up by 5 and a $1,125 vendor bill is created.
See also: Products and Services (Items), Account Settings and Accounting Overview.