Stock Book Report

A stock book report is a summary of a firm’s existing stock. It shows details like how much stock you have, which products are selling fastest, stock adjustment details, and other information about the inventory. Stock book tracks inventory manually by entering when inventory comes in and when it goes out. This report gives a detailed overview of inventory with a list of all the products and variants that have in stock, as well as a list of items that are out of stock.

STOCK BOOK IN ACCOXI

In Accoxi, the Stock Book Report offers a comprehensive overview of inventory, presenting a detailed list of all products and variants currently in stock, along with those that are out of stock. This report provides crucial information such as stock levels, fastest-selling products, stock adjustment details, and other inventory-related insights. It includes specifics like item name, unit, tax rate, batch code, unit price batch-wise, opening stock, opening stock value, purchase quantity, purchase return quantity, sales quantity, sales return quantity, stock adjustment quantity, stock inward quantity, stock outward quantity, closing stock, and total value. Accessible under the inventory section in the report module, this report serves as a valuable tool for managing and analyzing stock-related data.

MENU AVAILABLE IN STOCK BOOK REPORT

Field	Description
Customize	The user has the flexibility to tailor the report data by clicking on this button. The report permits data filtration based date, product and In stock items.
Export to Excel	By clicking this button, users can export the report to Excel.
Export to PDF	Clicking this button allows the user to export the report to PDF.
Print	This button enables users to print the report.
Email	To send the report via email, simply click this button. The report in PDF format will be attached to the email, and you can input the recipient's email address, CC address, subject, and any additional details for the email.
Pagination	The pagination control offers the capability to navigate from one page to another.
Exit	Clicking the 'Exit' button allows the user to exit from the report.

DATA AVAILABLE IN STOCK BOOK REPORT

Field	Description
#	The symbol '#' represents the number of lines in the given context.
Name	This section provides a view of the items currently held in the inventory.
Units	The units of the item are displayed in this section.
Sales Rate	This column displays the sales rate of the particular item.
Opening Stock	The opening stock of the item is presented in this section.
Opening Stock Value	The opening stock value of the item is displayed in this section.
Pur. Qty	The quantity purchased for the item is shown in this section.
Pur. Return Qty	The quantity returned for the item is presented in this section.
Sales Qty	The total quantity made for sales is displayed here.
Sales Return Qty	The total quantity received as sales return is shown here.
Stock Adjusted Qty	If there is any quantity adjusted for the item, it will be displayed in this column.
Stock Inward Qty	If the item is involved in stock inward, the total quantity will be displayed here.
Stock Outward Qty	In the case of the item being assigned for stock transfer, the total quantity will be showcased in this area.
Reserved Qty	The quantity being reserved is displayed in this section.
Closing Stock	The closing stock of the item within the selected date is presented here.
Available Stock	The stock available for sale on the selected date is displayed here.
Total Value	The total value of the closing stock is being presented.

Frequently Asked Questions?

01What is the content of Stock Book report in Accoxi?

Stock Book report gives a detailed overview of inventory with a list of all the products and variants that have in stock, as well as a list of items that are out of stock. The report helps you to get the information like how much stock you have, which products are selling fastest, stock adjustment details, and other information about the inventory.

02How can I check the closing stock of particular product?

Click on the Reports module.
Select the report Stock Book from Inventory head.
Stock book report opens and closing stock and other related information are included in the table data.

03What is the purpose of Customize Report option in the Stock Book report?

Accoxi provides the module of Reports and Stock Book of Inventory report included in it. In the report, Customize Report menu helps you to filter the stock book details. By clicking on the customize report, you can filter the report by selecting a particular product.

Click on the Reports module.
Select the option Stock Book from Inventory head.
Click on the Customize Report menu.
By clicking on the customize report, you can filter the report by Product and select any one of the product to filter the report.
Click on Run Report to get the customize data.

04How can I export the stock book data in to Excel format?

Click on the Reports module.
Select the report Stock Book from Inventory head.
At the right hand side of the report, there is a Print menu.
Click on the Print menu and it opens the print view form.
Click on the Export menu at the bottom right side of the page.
New tab will appear for save the file. You can select the location to save the file.
Click on save button to save the data in Excel format.

05How to check sales return quantity of a product?

Click on the Reports module.
Select the report Stock Book from Inventory head.
At the right hand side of the data table, sales return details are included.
It shows details of Purchase quantity, Purchase return quantity, Sales quantity, Sales return quantity, Stock adjustment quantity, Stock inward quantity etc.