Reports

If you have enabled inventory tracking for an item, you can view the reports for items in the Reports module in the left sidebar.

Sales by Item

This report contains the following information:

Summary of the sales of items in your organization.
The quantity sold, total selling price of all the items and the average selling price of the individual units.
The average selling price is calculated by dividing the amount by the quantity sold.

Sales by Item

This report contains the following information:

Summary of the purchase of items in your organization.
The quantity purchased, total purchase price of all the items and the average purchase price of the individual units.
The average purchase price is calculated by dividing the amount by the quantity sold.

Purchases by Item

This report contains details of the amount of stock that you have in various categories such as:

Quantity ordered
The quantity of items for which you have created a bill or purchase order.

Committed stock
Stock for which that you’ve created a delivery challan or sales order..

Stock on Hand
Stock that is currently available for your sales transactions.

With this report, you can have an overview of the stock levels in your inventory

Inventory Summary

This report contains the following information:

Inventory Valuation Summary

This report tracks batches of items which you buy from your vendors and sell to your customer.

The number of items in each batch is displayed below the Quantity under Product In.
Zoho Books works on the First In First Out (FIFO) stock tracking principle. So, any sales made will result in deduction of stock from the oldest purchases made for that item. As stock of each purchase transactions gets over, the stock gets deducted from the subsequent purchase transactions. This report gives you a detailed summary of quantity of items purchased and items sold multiple times at multiple rates.
With this report, you can see the transactions from your vendors in the Product In section and the sales to your customers from the same batch in the Product Out section.
This helps you to track the profit or loss incurred while selling of items batch wise.

FIFO Cost Lot Tracking

Was this document helpful?

Yes