Items

Items are the goods or services that you deal with in your business.

Whenever you create transactions for your customers or vendors, you can add these items and their details will be auto-populated.

In this page…


Create Item

To create an item in Zoho Books:

New Item

Sales Information

Fields Description
Rate Rate at which you sell the item to your customers. This rate will be reflected on your sales transactions like invoices, sales orders, etc.
Account Account used to track sales of the item.
Description Add notes related to sales of the item.

Purchase Information

Fields Description
Rate Rate at which you buy the item from your vendors. This rate will be reflected on your purchase transactions like bills, purchase orders, etc.
Account The Cost of Goods Sold account is used for tracking the purchase made for items in Zoho Books.
Description Add notes related to purchases of the item.

Inventory Information

To enable inventory for the item:

Track Inventory
Fields Description
Account  Account which tracks the inventory of the item. By default, it is Inventory Asset.
Opening Stock Quantity of the item which you have in hand on the opening balance date.
Opening Stock rate per unit Cost at which you purchased the item for the opening stock.
Reorder Point After the stock of the item reaches this level, you will receive a notification.
Preferred Vendor The vendor from whom you wish to purchase this item.

Associate Tags
You can also associate reporting tags to items in Zoho Books.

Note:
Fields in red are mandatory, others are optional.

Inventory for Items

In Zoho Books, you can enter an opening stock for your items. Whenever you make sales or purchase transactions for items in Zoho Books, this stock gets auto-calculated accordingly. For example, let’s say you enter the opening stock for item A as 100. Then, you make an invoice for a customer by selling 70 units of Item A . Now, the stock will get reduced to 30 (100-70). You now decide to purchase 100 units of item A from your vendor and create a bill for the same. Now the stock will be increased to 130 (100+30). This is how inventory tracking works in Zoho Books.


Import Items

If you already have a list of items, you can import them into Zoho Books in the CSVTSV or XLS format.

To know the format of the import, i.e. the columns and data to be included in the import file, you can download the sample import file which we’ll be looking at in the steps below.

Choose File

Note: These fields are case-sensitive and will only be overwritten if the value in field name matches in both the import file and Zoho Books.

Insight: The file size cannot be more than 1 MB.

Insight: Character Encoding is used to pair numbers with characters. By default, the Unicode Transformation Format (UTF-8) encoding is used which supports a wide range of characters that go beyond 8 bits.

Insight: The Field Delimiter is used to separate two values in a row. While importing bills, the default file delimiter is comma (,) .

Overwrite Records Overwrite Records Map Fields Import Items

Never run out of stock with Zoho Books, the accounting software with inventory tracking.


Was this document helpful?
Yes
No
Want a feature?
Suggest
Switch to smart accounting software. Switch to Zoho Books.   Start my free 14-day trial Explore Demo Account

Books

Online accounting software
for small businesses.