Stock Book Report

Stock Book Report.

Stock Book Report

A stock book report is a summary of a firm’s existing stock. It distills 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 Report in ACCOXI

ACCOXI is most modern accounting software that provides easy and deliberate results for accounting. It provides the module of Reports and Stock Book – Inventory report included in it. 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 the user to get the information like how much stock you have, which products are selling fastest, stock adjustment details, and other information about the inventory. It shows the stock details such as 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. When the user opens the ACCOXI account, Reports module will appear on the bottom left side of the modules. Click on the Reports module, it opens to various financial reports of the Organization. There are various heads of reports like Payables, Inventory, Receivables, Accounts, Purchase, sales etc. Click on the Inventory head and select the option Stock Book. By clicking on Stock book option, stock details will popup on the screen.

Stock Book Report

Stock Book

It shows the stock details such as 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. 

Stock Book

           Fields

                                    Description

Customize Report

User can filter the report by using the option Customize Report. By clicking on the customize report, can filter the report by product.

 

User can filter the report by Product option, need to select a product. By clicking on the select option, list of available products will appear and can select the required one.  

By clicking on Run Report, user get the customize report based on data entered.

 

       

Print

If the user wants to take the print out of the report, it can be done by using the menu Print on the top right side of the page. When the user clicks on the print menu, it opens to Report page and it contains the details regarding the print.

 

 

User can set the page range, page height, width and can enter the required number of copies here. By clicking on the Print button, user gets the print out of the stock book report.

                         

Name

This column shows the number of all the items and its name.  

Units

It shows the units of the product.

Tax Rate

This column shows the tax rate of the particular product.

Batch Code

Every product has its own batch code. This column shows the batch code of the particular product.

Unit Price Batch wise

This column shows the batch wise price of the product.

Opening Stock

It is the number of products that available for sale or use at the beginning of an accounting period.

Opening Stock Value

This column shows the opening stock value that available for sale or use at the beginning of an accounting period.

Purchase Quantity

It shows the purchase quantity of the product.

Purchase Return Quantity

This column shows the quantity of item returned after the purchase.

Sales Quantity

It shows the sales quantity of the product.

Sales Return Quantity

This column shows the quantity of item that returned after the sales.

Stock Adjustment Quantity

This column shows the adjusting quantity that is, increase or decrease of the product.

Stock Inward Quantity

This column shows the inward quantity of stock.

Stock Outward Quantity

This column shows the outward quantity of stock.

Closing Stock

Closing stock is the stock of inventory that business still on hand at the end of reporting period. This column shows the closing stock of the product.

Total Value

It shows the sum total value of the particular product.  

 

Menus Available in Print View

Menus Available In Stock Book Print View

When the user clicks on the print menu, it opens to Report page. It shows the Stock book report and it consists of various menus.

        Fields

                                   Description

Refresh

If the latest data is not displayed, click on the refresh icon on the top left corner of the page to fetch the new data.

 

                          

 

Pagination Control

It controls the page navigation. User can select the page by using the page control keys or can enter the page number in the given box. After enter the page number, it will open to the screen.

 

 

            

Page Setup

This menu helps the user to set the page size, page orientation and margin size.

        By clicking on the Page Setup icon, a new tab will appear and user can select the page size, orientation and margin size with the tab.

                 

 

Switch to Interactive Layout

It helps the user to change the page to Interactive Layout. By clicking on the icon, it will change to interactive layout.

        

Zoom

User can use the zoom option to select the required zoom size for print. By clicking on the select option, available zoom size will appear and can select required size.

                            

Print

By clicking on the Print button, user gets the print out of the report.

 

                                

 

Export

Export menu enable the user to export the report to PDF format and can save in the system.

                                 

                  

When the user click on the Export menu, a new tab will appear for save the file. Then user can select the location to save the file, can set a name and click on save button to save the file as PDF format.            

                                                                                                       

 

Exit

Exit menu is for exit from the Print report page and it redirects to previous page.

                                   

 

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.