Stock Ledger Report

Stock Ledger Report In ACCOXI.

Stock Ledger Report

A stock ledger report is a detailed record that keeps track of stock movements of a company. Inward or outward transactions related to purchasing, selling and stock transfers are recorded in the stock ledger which is reflected in the stock ledger report.

Stock Ledger Report in ACCOXI

ACCOXI is the most modern accounting software that provides easy and deliberate results for accounting. It provides the module of Reports and it consists of various heads of reports like Payables, Inventory, Receivables, Accounts, Purchase, and Sales etc. Stock ledger report included in Inventory head. Stock Ledger report is a report that displays all stock movement transactions of the organization. It displays the stock ledger details such as Voucher type, Voucher number, Date, Name of the party, Batch code, Quantity, Rate, FIFO Cost, Quantity on hand and Closing 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 Ledger. By clicking on the Stock Ledger option, details will popup on the screen

Stock Ledger Report In ACCOXI

Stock Ledger

User can select the Product or Batch from customize report option, and it  displays the stock ledger details such as Voucher type, Voucher number, Date, Name of the party, Batch code, Quantity, Rate, FIFO Cost, Quantity on hand and Closing Value. 

Stock Ledger

           Fields

                                       Description

Customize Report

User can filter the ledger report by using the option Customize Report. By clicking on the customize report, use can filter the report by Product or by Batch of the 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.  

If the user filters report by Batch option, need to select a batch. By clicking on the select option, list of available batch 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 ledger report.                          

Date

This column shows the transaction date of the particular transaction. It is the date used to define a particular day or time of the week when the transfer was done.

Voucher Type

This column shows the voucher type of the transaction. It may be purchase, sales, purchase return, opening stock etc.

Voucher Number

Voucher number helps the user to identify transactions in records and it will be the continuation of the previous transaction.  

Name

This column shows the Name of the supplier/customer of a particular transaction.

Batch Code

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

Quantity

This column shows the quantity of the item.

Rate

It shows the rate of the particular item.

FIFO Cost

It shows the FIFO cost of the transaction. First in First Out method means that the cost of a company’s oldest inventory is used in the cost of goods sold.

Quantity on hand

It is the stock of inventory that business still on hand at the end of reporting period. This column shows the available quantity of the product.

Closing Value

This column shows the closing value of the particular product.  

Menus Available in Print View

Menus Available In Stock Ledger Print View

When the user clicks on the print menu, it opens to Report page. It shows the stock ledger report view 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 Ledger report in Accoxi?

Stock Ledger report consists of various heads of reports like Payables, Inventory, Receivables, Accounts, Purchase, and Sales etc. Stock ledger report included in Inventory head.  Stock Ledger report is a report that displays all stock movement transactions of the organization. It displays the stock ledger details such as Voucher type, Voucher number, Date, Name of the party, Batch code, Quantity, Rate, FIFO Cost, Quantity on hand and Closing Value.

02How to take printout of Stock Ledger report?

  • Click on the Reports module.
  • Select the report Stock Ledger 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.
  • You can set the page range, page height, width and can enter the required number of copies here.
  • Click on the Print menu to get the printout of the report.

03How can I filter the Stock Ledger report?

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

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

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

  • Click on the Reports module.
  • Select the report Stock Ledger 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.