Items are the products and services you put on jobs, estimates and invoices: labor, parts, materials, fees, discounts and sales tax. This article covers the item list, the item form, price levels and importing. For how items fit into your books, see Accounting Overview.
The Item List
- Click Accounting > Item List. Click a row to open an item, or click New Item at the top left to add one.
- Admins, and Standard Users with Full Access to Accounting, can add and open items. Users with View Only access to Accounting can see the list but can’t open or add items.
- Type in the Search items box to filter the list. The filter icon on the Type column shows only the item types you pick.
- The button with three lines lets you choose columns, download a CSV Report or XLSX Report, and tick Display Active Items and/or Display Inactive Items.
- A red number in the On Hand column means the part is at or below its Reorder Point. A red vendor name means that vendor is inactive.
Item types
Pick the Item Type first. It decides which fields the item has, and it can’t be changed once the item is saved. To change the type, make a new item and untick Active on the old one.
- Service: labor or work you charge for, such as pool cleaning, HVAC repair or mowing.
- NonInventory: parts and materials you sell but don’t count, such as fittings, screws or a part bought for one job.
- Inventory: parts you stock and count. Bella tracks the On Hand quantity. See Inventory Parts.
- Other Charge: fees that aren’t a product or service, such as a trip charge, disposal fee or rush fee. It can be a set amount or a percent.
- Discount: an amount taken off. For a percent discount, tick In percent and enter the Rate.
- Sales Tax Item: a sales tax rate you collect for a tax agency.
- Payment: a payment line item. It has no price: only Name, Description, Taxable and Income Account apply.
Item details
- Name: required, up to 255 characters. This is what shows on jobs, estimates and invoices, like “Weekly Pool Cleaning”. Names must be unique unless Allow duplicate Item names is on in Account Settings. Otherwise Save shows “Item Name … already exist”.
- Description: optional, up to 5,000 characters, like “includes chemicals and filter rinse”.
- Unit of Measure (up to 20 characters) and Part Number: NonInventory and Inventory items only. They show as U/M and Part # in the list.
- Work Types: only shows when Activate Work Types is on in Account Settings, and not on Sales Tax Items.
- Active: the checkbox at the top right. Untick it to retire an item. It stays on past jobs and invoices.
- Notes: if file attachments are on for your account, a Notes section under the form lets you add notes and files to the item. See Uploading File Attachments.
Price, cost, markup and margin
- Unit Price: what you charge for one unit. Used by Service, NonInventory, Inventory and Other Charge items that aren’t in percent.
- In percent: Other Charge and Discount only. Tick it to enter a Rate (%) instead of a Unit Price.
- Taxable: tick it if sales tax applies to the item. The rate comes from the sales tax item on the job, estimate or invoice, such as the customer’s Default Sales Tax.
- To track what an item costs you, turn on the switch for its type: Service provided by a subcontractor or partner (Service), Purchased for customer job (NonInventory) or Reimbursable charge (Other Charge that isn’t in percent). This shows Purchase Information: Unit Cost, Expense Account and Preferred Vendor. Inventory items always have Purchase Information.
- Markup (profit as a percent of the Unit Cost) and Margin (profit as a percent of the Unit Price) are worked out for you when Purchase Information shows. They show a dash until there’s a cost or price to work from. A red value means you’re selling below cost.
Sales Tax Items
- Rate: the tax percent, up to three decimals, like 8.25%.
- Most common: tick it for the sales tax item you use most.
- Tax Agency (Vendor): the vendor you pay the tax to.
- There’s no account box. Bella posts sales tax to your Sales Tax Payable account.
Accounts
- Income Account: where the sale is recorded, like “Service Income”. Lists Income and Other Income accounts.
- Expense Account: where the cost goes when Purchase Information is on for a Service, NonInventory or Other Charge item. Lists Expense and Other Expense accounts. A new item starts with Uncategorized Expense.
- Inventory items have a COGS Account and an Asset Account instead. See Inventory Parts.
- A new item starts with your default accounts picked. Line items on jobs and invoices post to their item’s accounts.
Best practice: set your accounts up once with your bookkeeper. Wrong account choices are easy to miss until year end.
Saving and deleting
- Save saves the item and goes back to the list. Cancel goes back without saving.
- Delete only works for items that aren’t on any job or transaction. Otherwise Bella tells you to untick Active and save instead, so the history stays. Standard Users marked User not able to delete any data don’t see Delete.
Price levels
Click Accounting > Price Level List, then New Price Level. Admins and Standard Users with Full Access to Accounting can set them up.
- Name: required, up to 20 characters, like “Wholesale”.
- Type Fixed %: enter the Percent to raise every item’s Unit Price by. Use a minus number, like -10, for lower prices. Items priced in percent aren’t changed.
- Type Per Item: shows a grid of your items. Tick the items this price level includes, and type a Custom Price for any of them. When the price level is used, only the ticked items are offered, plus Discounts, percent Other Charges and Sales Tax Items, which are always offered.
- Active: untick it to retire the price level.
- Set a Price Level on the customer (see Creating and Editing a Customer) and it’s picked for you when you add items to that customer’s jobs. Admins, and users who can see prices and costs, can also pick one in the Price Level box of the item selection window.
Importing items
Click the gear icon > Data Import, then open Item Importer. Data Import is for admins.
- The file must be CSV (comma delimited). After you upload it, match your columns to Bella’s fields.
- Item Type and Item Name must be filled in on every row. Item Type must be one of Bella’s type names: Service, NonInventory, Inventory, Other Charge or Discount (upper or lower case doesn’t matter).
- Account, COGS Account and Asset Account must match the name of an account already in Bella. Create missing accounts first.
- Other columns: Active (Active/Non), Taxable (Tax/Non), Description, Price/Rate, Cost, U/M, On Hand, Reorder Point, Part #, Preferred Vendor and Site. A Preferred Vendor must already exist in Bella.
- A row whose Item Name matches an existing item updates that item instead of adding a new one. To update prices, import the list again.
Step by step
Add a service with a price
- Accounting > Item List > New Item.
- Type the Name. Leave Item Type on Service.
- Enter the Unit Price and tick Taxable if needed.
- Check the Income Account, then click Save.
Track what a subcontractor charges you
- On a Service item, turn on Service provided by a subcontractor or partner.
- Enter the Unit Cost, Expense Account and Preferred Vendor.
- Enter the Unit Price. Markup and Margin fill in. Click Save.
Retire an item you no longer sell
- Open the item and untick Active.
- Click Save. It drops out of the active list but stays on past records.
Examples
A labor service
- Item Type: Service
- Name: Pool Cleaning, 1 Hour
- Unit Price: $75
- Income Account: Service Income
A trip charge
- Item Type: Other Charge
- Name: Trip Charge
- In percent: not ticked
- Unit Price: $35
See also: Accounting Overview, Inventory Parts, Creating a Job and Creating an Invoice.