Financial Accounting   - Gateway Of Account

Group
Ledger  
Sub-Ledger  
Cost Categories
Cost Centers   
Budget  
Voucher Type
Currency
Memos
Bank Reconciliation     
Sales Register /Sales Returns Register  / Purchases Register  / Purchases Returns Register / Journal Entries Register / Entry Journal   
Reports
  -- Trial Balance   
  -- Profit & Loss   
  -- Trading Account   
  -- Trading & Profit and Loss Account   
  -- Balance Sheet   
  -- Fixed Assets Schedule   
  -- Receivables and Payables Analysis   
  -- Sales and Purchase Analysis   
  -- Party-wise Sales  
  -- Sales Analysis   
  -- Party-wise Purchases  
  -- Product-wise Purchases
  -- Purchases Analysis
  -- ABC Analysis  
Fixed Assets

Financial Accounting
 

The Financial Accounting Module in INTRAWEB SOLUTIONS comprises all the Reports related to this Module. The Reports are grouped under suitable sub-Menus, which we shall see in more detail a little later in this chapter.

The Financial Accounting Menu is displayed when the user select this option from the Main Menu.

The available options of the Financial Accounting Menu are listed below.

. Ledger
. Sub-Ledger
. Cash and Bank Books
. Sales Reports
. Purchase Reports
. Registers
. Final Accounts
. Receivables and Payables Analysis
. Sales and Purchase Analysis
. Miscellaneous Analysis
. Masters Information
. Check List

Let us now study the above Reports in greater detail. If the user has not already gone through the chapter entitled Reporting Basics, he might want to read it now, so as to have a better understanding of how to use the Reporting Features of INTRAWEB SOLUTIONS effectively.

 Group

Here We Can Create Different Group with alias, when ledger is created it fall under those group which are Created and Selected

Name: - Type the name of the group/sub group.

Alias: - Type the alias name if any.

Under: - Select the group under which you are creating the sub group. Group Behaves Like a Sub Ledger:-If it is set to “YES” the group behaves like a control account for the ledgers it contains.

Net Dr/Cr Balance for Reporting:-Set this option to “Yes” to display amounts as a net figure instead of separate debit and credit balances in the reports.
Used for Calculation (e.g. taxes, discount):-This option is used fr the group for which automatic calculation is required.

Group Behaves Like a Sub Ledger:-If it is set to “YES” the group behaves like a control account for the ledgers it contains.Net Dr/Cr Balance for Reporting:-Set this option to “Yes” to display amounts as a net figure instead of separate debit and credit balances in the reports.Used for Calculation(e.g. taxes, discount):-This option is used fr the group for which automatic calculation is required.

 Ledger

The Ledger Report in INTRAWEB SOLUTIONS allows the user to view the transactions of multiple Accounts or Accounts Groups in a Statement of Account format for a selected Date Range.
The Ledger Parameters window is displayed when selected from the Financial Accounting option of the Main Menu.

Here Ledger is Created and Fall Under this category

Account Type                                                 Linked To
Assets / Liability                                             Balance Sheet
Bank Account                                                 Balance  Sheet
Cash Account                                                 Balance Sheet
Income & Expense                                          Profit & Loss
Party Account                                                 Balance Sheet
Petty Cash                                                       Balance Sheet
Purchase Account                                           Profit & Loss
Employee Account    
Sales Account                                                 Profit & Loss

Name:-Type the name of the ledger.
Alias:-The alias (other name) for the ledger name.
Under:-It is for selecting the group for the ledger.
Inventory values are affected:-Set this option YES if there is any effect over the stock value in respect of changes in the balance of this ledger.
Mailing Details:-The fields unde this group accept address detail.
Tax Information:-These fields are for the statutory information of the party.
Opening Balance:-This is for putting the opening balance of the ledger.

The List of Accounts, as available in the Account Master, is displayed in the Tree Panel.  Select a single Account, a Group of Accounts or Multiple Account Groups from the Tree Panel, whose transaction data is to be viewed in the Report, by double clicking the same. Click Select All Items to view the Report for all the Accounts listed in the Tree Panel.
Click Unselect All to cancel the previous selection and start selecting the Accounts afresh.

Next, select the Date Range in the Report Dates box. The Transactions, whose dates fall within the selected Date Range, will be displayed in the Report.
If the user is selecting a large number of Accounts for printing, he might want to print an Index of the List of Accounts included in the Report. Select the Print Index checkbox.
When the user select an Account Group/Groups, by default, INTRAWEB SOLUTIONS includes all the Accounts falling within that Group, in the Report, even if there are no transactions within the selected period. This would make the Report lengthy and bulky, if the Number of Accounts is large. To avoid this and select only those Accounts, for which there are transactions input during the selected Date Range, select the Moved Accounts Only checkbox. This will exclude all the Accounts from the Report, for which there have been no transactions input during the selected period.
From the Output box, select the Output location. Note that the default Report Output option is set to Screen, so the user can view the Reports and check the information, before printing or exporting the Report data.

If the user wants each Account to be printed on a separate page, select the Start New Accounts on Fresh Pages checkbox. Lastly, select the Report Layout from the Layout combo.
Select the Customize Report button if the user wishes to create different Report Layouts or modify the existing Report Layout. The user can also filter the information to be displayed in the Report, by selecting the Set Report Filters button. For more information on how this is done, please refer to the chapter entitled Reporting Basics.

Click OK to view/print the Report or click Cancel to close the Ledger Parameters window and return to the Main Menu.
A sample Ledger Report is displayed below.

Transactions of any type of Account can be viewed or printed in the Ledger Report. The basic report format would be Transaction Date, Voucher Number, Account-2 Name, Debit Amount, Credit Amount and Balance. The Account Name appears at the top on a separate line and below this the transactions for that Account are displayed.

Click Previous Page or Next Page buttons to scroll through the Report. If the user wishes to jump to a specific Account or transaction in the Report, use the Find button to enter the search criteria and move to the required item in the Report. Click Find Next to move to the next occurrence of the same item in the Report. Finally, if the user wishes to view more specific information, click the Filter Report button to enter the Filter Condition(s) and view only the required Account data.

Click Close in the Report to close the Ledger Report window and return to the Main Menu.

There are various styles in displaying the Ledger, which are described in detail in the Section on Accounts Tree-Properties in the chapter entitled Getting Started – Create Masters. They include displaying multiple amounts of a single voucher as a consolidated entry, displaying summary balances, etc. The user may refer to the above Section for more information on the same.

Sub-Ledger
 

Click Close in the Report to close the Sub-Ledger Report window and return to the Main Menu.

Cost Categories

Here Cost Category are Created Cost centre fall under this Category

Cost Centre to keep detail Track with in Branches. It behave like warehouse integrated with inventory.
e.g where the item are located ,how much the item quantity..

 

Cost Centers

Cost Centre to keep detail Track with in Branches. It behaves like warehouse integrated with inventory. E.g. where the items are located, how much the item quantity is Budget is varying necessary for every accounting activities.



Budget

Budget is basically made for future events on the basis of the current activities. This is assumption based. Company are making budget on its expenses mainly.
Month budget for Whole Company or particular department can be created here Scenario Management is the latest management tool by which the user can create multiple scenarios for the purpose of forecasting or to view provisional reports.

Budget is vary necessary for every accounting activities.

Budget is basically made for future events on the basis of the current activities. This is assumption based. Company are making budget on its expenses mainly.

Month budget for Whole company or particular department can be created here
Scenario Management is the latest management tool by which the user can create multiple scenarios for the purpose of forecasting or to view provisional reports.

Currencies


 
In Currency Page you create multiple currency require for company transaction
Currency page is shown below

Here Different Types Of Voucher are Created

Name: - Type the name , to creating a new voucher type.


Alias: - You can type the alias

Type of voucher: - This is one of the important fields that has to taken care of when a voucher type is being created. A voucher class only can be created based on another existing voucher.   

Abbr:-This is the abbreviation of the existing voucher type that .You need not change anything.

Method of voucher Numbering:-This field decides how you like to enter the voucher number.

Use advance Configuration: - This option is for setting advance parameters for voucher numbering            
               
Use Effective Dates for vouchers: - Sometimes an entry is passed on some day and that will be effective from some other day. In that case this option is used.

Make optional as default: - By default all vouchers is of Regular type. You can change this option by setting this field value Yes.

Use common Narration: - The default value is Yes>It allows a common narrating for whole voucher.

Narration for each entry: - Setting it yes will allow you to put narration for every ledger you select while passing the entry.

Print after saving Voucher: - No.

Name of Class: - Type the class name which will be created under the selected voucher type.

F.Voucher Types :
Here Different Types Of Voucher are Created

Name:-Type the name , to creating a new voucher type.
Alias:-You can type the alias
Type of voucher:-This is one of the important fields that has to taken care of when a voucher type is being created. A voucher class only can be created based on another existing voucher.
Abbr:-This is the abbreviation of the existing voucher type that .You need not change anything.
Method of voucher Numbering:-This field decides how you like to enter the voucher number.
Use advance Configuration:-This  option is  for setting advance parameters for voucher numbering
Use Effective Dates for vouchers:-Sometimes an entry is passed on some day and that will be effective from some other day. In that case this option is used.
Make optional as default:-By default all vouchers is of Regular type. You can change this option by setting this  field value Yes.
Use common Narration:-The default value is Yes>It allows a common narratin for whole voucher.
Narration for each entry:-Setting it yes will allow you to put narration for every ledger you select while passing the entry.
Print after saving Voucher:-No.
Name of Class:-Type the class name which will be created under the selected voucher type.

A. Contra : It Is transaction indicating transfer of funds from
                        a) Cash Account to Bank account
                        b) Bank account to Cash Account
                        c) Bank Account to Bank Account

This mode used for transfer entries between cash and bank. Cash to cash transfer or bank to bank transfer is also made through this mode.

B. Payment : Here Company Settles Expenses of conveyance, staff welfare, postage, Furnitures & Stationery through Cash

It is used for making any kind of payment.

Account:-Select Header account with current

Voucher Date:-select the voucher date

Expense head:-Select the expense head Cheque number with narration.

Voucher total

C. Receipt : This Mode Is Used To Enter all kind of  receipt vouchers
.This is a receipt for the company and this should be entered through receipt voucher.

D. Journal : This Mode is basically for adjustment entries. Normally this Mode does not accept any cash/bank ledger

Note     : Payment    --> Receipt     -->  Journal (flow is like this)

E. Sales :
In sales order section use gets order for product from customer with qty and rate

E1. Credit Note: Return of Goods  after Bill Is Passed through Credit Note,
Here Bill adjustment is done against reference and pick the bill against which return is being made.

F: Purchase :
In Purchase Order Company define product name and qty and rate that company want to purchase product from vender

F1: Debit Note :
A debit Note is a document notifying a supplier that a debit has been made to his account.

A debit note is prepared after the supplier agrees to grant a price reduction.The debit note records the adjustment being requested.

Debit note is created against any party (Sundry debtors or Creditors)  that may be for overcharged or undercharged or returns of goods against any purchase or sale not for replacement purpose
            * Return of Goods(a whole or part)
            *Quantity not Upto the mark
            *Bill Wrongly overcharged
           
G. Reversing Journal : Reversing journals are special journals that are automatically reversed after the date of the applicability. They exit only unto the day it is applicable.

E.g. Salary of the company paid on the 2nd of each month. Outstanding salary entry is normally made at the end of the financial period. So no outstanding entries are made for interim periods.
On 31st January the company want to check the position of the accounts after considering all the liabilities. As the liabilities are not actually met, the possible way to handle the situation is to pass the reversing journal having the applicable unto date 31st of the month.

In fact the different voucher types help in classifying the different types of transactions and they do no affect the way the voucher is posted in the ledger.

Memos


This is a non-accounting voucher and the entries made using it will not affect your accounts.

It does not past the entries to the ledgers but stores them in a separate “Memo Register”.
We can also alter and convert a memo voucher into a regular voucher when you decide to bring the entry into your books.

Some use of memo voucher
1)Making suspense payment:-E.g. the company gives an employee cash to buy office supplies,the exact nature and cost of which are unknown.

2)Voucher not verified at the time of entry:-It sometime happens that you do not understand the details of a voucher you are entering.

3)Items given on approval:-You will normally enter completed sales into the books. If items are given “on approval”, you can track them wit a memo voucher and convert it into a proper sales voucher or delete it depending on the outcome.

The Cash and Bank Books Menu is displayed when selected from the Financial Accounting option of the Main Menu.

Cash Book

The Cash Book records all the transactions passed through the Cash Account. This report is useful to tally the physical Cash Balances on a Daily or Monthly basis as well as to study the Cash movements (Receipts and/or Payments) during the selected period. The Cash Book Parameters window is displayed when selected under the Cash and Bank Books option from the Financial Accounting Menu.

Select the Cash Account from the Account combo. Select the Report Dates and the Layout for the Report. Select when the Balances should be drawn up and displayed in the Report, from the options in the Balancing box.

The default Balancing option is Daily. For each Day that the user has Cash movements, the Opening Cash Balance brought forward and the Closing Cash Balance carried forward is displayed separately. For the Monthly option, the Balances would be displayed at the beginning and end of the Month respectively. If the user selects None, the Opening Cash Balance brought forward is displayed once at the beginning of the Report and the Closing Cash Balance is displayed only at the end of the Report, with the transactions listed in between Date-wise. The difference between a Ledger/Sub-Ledger report and a Cash/Bank book is in the method of Balancing. In the Ledger, Balancing is done line-wise and the Balance is brought forward once after each page only. In the Cash/Bank book the Balance is brought forward every day or every month, depending on the method of Balancing selected in the Report Dialog box. Click OK to view the Report or click Cancel to close the Cash Book Parameters window and return to the Main Menu.

A sample Cash Book Report is shown as follows:

The Cash and Bank Books reports show the user, the transactions entered for the Cash/Bank Account that is selected while taking the report. The user can maintain multiple Cash/Bank Accounts in INTRAWEB SOLUTIONS and select a specific Cash/Bank Account, for which he need to take the report. Click Close in the Report to close the Cash Book Report window and return to the Main Menu.

Columnar Cash Book

The Columnar Cash Book gives the user a report that shows the transactions of all the Cash/Bank Accounts selected, in separate columns for each Cash/Bank Account. This report provides Balances in each Cash/Bank Account in a single report and the Total Debits/Credits entered in each Account every day or every month. The report would have to be customized to include the additional columns and the user would have to select the Accounts that he wishes to include in the report.

Analytical Reports for Cash/Bank Accounts

Analytical reports give the user a summarized analysis of Cash/Bank transactions. A common analytical report based on Cash/Bank Accounts is the Cash Flow statement. The report in INTRAWEB SOLUTIONS can be taken from the menu \Financial Accounting\Final Accounts\Cash Flow. This report shows, both, the past performances of Cash/Bank inflow and outflow and also gives the user the forecast of the expected Cash Flow. The inflow of Cash/Bank Balances is forecast, based on the Receivables, considering the Due Dates of Receivables and Sales Orders on one side and the outflow of Cash/Bank Balances, based on the Due Dates of Payables and Purchase Orders. The past Cash Flow reports are based on the Cash/Bank inflow and outflow from each Group head. The report includes all Accounts of Cash and Bank type for the purpose of analysis.

Bank Book
The Bank Book displays all the transactions entered for a specific Bank Account or for a Group of Bank Accounts.
Select the Bank Account from the Account combo. Select the Report Dates and the Layout for the Report. Select when the Balances should be drawn up and displayed in the Report, from the options in the Balancing box. Click OK to view the Report or click Cancel to close the Bank Book Parameters window and return to the Main Menu.

Sales Return
 

Select the Sales Account from the Account combo. Select the Report Dates and the Report Layout from the Layout combo. Click OK to view the Report.

This report is similar to the Sales Register with the only difference being that instead of Sales Invoices, it gives the user details of Sales Returns entered during the period for which he is taking the report. The information included is the Return Date, the Customer Name, the Product, Quantity, Rate and Gross. The Report is customizable, if any other information is required.
Click Close in the Report to close the Sales Returns Book Report window and return to   the Main Menu.

Purchase Returns

 
The Purchases Returns Book window is displayed when selected under the Purchases Reports option of the Financial Accounting Menu.

Select the Purchases Account from the Account combo. Select the Report Dates and the Report Layout from the Layout combo. Click OK to view the Report.
This report is similar to the Purchases Register with the only difference being that instead of Purchase Vouchers, it gives the user details of Purchases Returns entered during the period for which the user are taking the report. The information included is the Return Date, the Customer Name, the Product, Quantity, Rate and Gross. The Report is customizable, if any other information is required.

Report


            a) Balance Sheet :
            b)Income & Expenses A/c
            c)Ratio Analysis
            d)Display --> Trial Balance
                             -->   Day Book
            e)Statement Of Account --> Outstanding
                                                          --> Interest Calculation
                                                          --> Cost Centre
                                                          --> Job Work Analysis
                                                          --> Audit
                                                          --> Static
            f)Cash/bank Book
            g)Cash/Fund Flow
            h)Exception payment      -->Overdue Payment
                                                           -->Overdue Receivable

  Inventory

Master Menu

Main Group :  In Main Group Page You Create Main Group for your Company   Item

Sub Group : In sub Group you created multiple Sub Group for One Main Group for Company Item Sub Group page is shown below

Color : In Color Page You add new color for Item

Size : In Size Page you add new size for item

Batch : In Batch Master Page you create multiple batch. In batch Page you enter Batch Name, Mfg Date, Expire Date and   expire Date is always greater than mfg Date.

Currency : In Currency Page you create multiple currency require for company transaction

Currency Exchange Rate : In currency exchange rate you enter currency exchange rate for particular currency selected from drop down list and date.

Status : In Status Page you enter Status that require for Transaction section example (Completed, Canel led etc.)

Quality : In Quality page  you enter Quality details that require in Item Master

Item Master :  Item Master Page use for created Item for transaction (e.g for Purchase and Sales)
In Item Master Select Main group, Sub group, quality, usage units, currency, color, size
Max and min Quantity, standard cost, wt avg cost etc.

Transaction Menu

Opening Stock
Opening Stock page can be access from Transaction /Stock/Opening Stock. It is where you can enter the opening stock of the item. You can enter date, select item name, warehouse, optional batch number. On selection of batch number expiry and manufacturing date comes automatically if you have made entry in the Batch Master. Then you specify the quantity and rate for that item and amount comes automatically and makes selection of type of the stock it is and account where opening stock effect will be coming. On click of Insert Records gets inserted into the grid.

On click of the update button records get saved into the database.

Opening stock page is shown below



Physical Count

Physical Count page  can be access from Transaction /Stock/Physical Count. It is where you can enter the actual stock quantity in the warehouse and get the variance for that item. On this page selection of the Main Group and Sub Group is provided and on selection of  this all the item related to this Main Group and Sub Group get displayed which include Item Name, Warehouse, Batch Number, Expiry Date ,Manufacturing  Date, System Count .User can enter Physical count the variance get  automatically displayed. To enter the physical count user need to press edit button and on click of edit button physical count column become editable and on click of update the row become non-editable. User can also delete the row if required.

After entering physical count quantity user can press update button to save the records in the database.

Physical Count Page is shown below


Stock Adjustment

Stock Adjustment page can be access from Transaction /Stock/Stock Adjustment. Here is where you can increased or decrease the stock quantity. To increase the stock quantity you need to enter positive quantity and to reduce the stock quantity you need to enter negative quantity. User need to select the warehouse optionally batch number and the Expiry Date and Manufacturing Date will come automatically (by default Select Warhosuse and Item Name System Stock Display). For the effect of the account you need to select the account Ledger from which the amount will get reduce or increased.

Stock Adjustment page is shown below

Stock Transfer

Stock Transfer page can be access from Transaction /Stock/Stock Transfer. This page can be used to transfer the stock from one warehouse to another(optionally from one batch in one warehouse to another batch in another warehouse).To transfer stock user need to enter Date,Inward Warehouse Name,Description,optionally Batch,Outward Warehouse,Item Name,Quantity and Rate.

Stock Transfer page is shown below



Purchase Order
Purchase Order page can be access from Transaction /Purchase Order. Here is where we can create Purchase Order. In Purchase Order the Order number come automatically. Contract date, Shipment Terms, Shipment Date, Status and Vendor Name need to be enter on Purchase Order Link. On the Description link you enter Item to  purchase ,warehouse ,optionally batch number, Quantity, Rate, Rate per unit and amount(which come automatically).On click of insert the data get display in the tabular form below. Here you can enter multiple items if required. The Total of all the item get displayed at the bottom of the page.


On the total link you need to select the currency, select the account and amount and click on insert button. Likewise if you have tax then selects the tax account

Purchase Order page is shown below

Purchase Invoice

Purchase Invoice can be access from Transaction/Purchase Invoice. Purchase Invoice Can be mabe in 3 different Method

1 ) By CreatingPurchase  Invoice Without Creating Purchase Order
2) By Creating Purchase Invoice From Particular Purchase Order
3) By Creating Multiple Purchase Invoice From One Purchase Order

1 Method

In Purchase Invoice ,  Invoice number come automatically. Contract date, Shipment Terms, Shipment Date, Status and Vendor Name need to be enter on Purchase Invoice Link. On the Description link you enter Item to  purchase ,warehouse ,optionally batch number, Quantity, Rate, Rate per unit and amount(which come automatically).On click of insert the data get display in the tabular form below. Here you can enter multiple item if required. The Total of all the item get displayed at the bottom of the page.

On the total link you need to select the currency, select the account and amount and click on insert button. Likewise if you have tax then selects the tax account

2 Method

In Purchase Invoice   Invoice number comes automatically. In Purchase Invoice link You need to select Purchase Order then automatically Contract date, Shipment Terms, Shipment Date, Status and Vendor Name display in Purchase Invoice Link. On the Description link All  Item   enter   in purchase order with warehouse, optionally batch number, Quantity, Rate, Rate per unit and amount Display in Grid View .Total of the entire item get displayed at the bottom of the page.

On the total link you need to select the currency, select the account and amount and click on insert button. Likewise if you have taxes then select the tax account

 3 Method

In Purchase Invoice   Invoice number comes automatically. In Purchase Invoice link You need to select Purchase Order then automatically Contract date, Shipment Terms, Shipment Date, Status and Vendor Name display in Purchase Invoice Link. On the Description link all  Item   enter   in purchase order with warehouse, optionally batch number, Quantity, Rate, Rate per unit and amount Display  in Grid View (Suppose In Purchase Order you enter 5 Item but you want to add only first two item then another 3 item remove from  purchase invoice grid view and then update Purchase Invoice. Now  if suppose if you want to Create New Purchase Invoice  base on  same purchase order then remaining 3 item get  display in Purchase Invoice  grid).Total of all the item get displayed at the bottom of the page.

On the total link you need to select the currency  , select the account and amount and click on insert button. Likewise if you have tax   then   selects the tax account

Stock Effect
Base on the Quantity enter in the Purchase Invoice the Inventory Stock for particular item. Get increase in the warehouse (Optionally in the Particular Batch if selected)



Purchase Return

Purchase Return page can be access from Transaction/Purchase Return Here is where we can create Purchase Return .In Purchase Return page Purchase Return number come automatically. Contract date, purchase invoice no, vender name you have selected in the Description Section you enter Item to  purchase Return ,warehouse , optionally batch number,Quantity,Rate,Rate per unit and amount(which come automatically).On click of insert the data get display in the tabular form below. Here you can enter multiple item if required.

(Note:- You Return only those item enter in Purchase Invoice with same warehouse(Optionally in the Particular Batch if selected))The Total of all the item get displayed at the bottom of the page.


in the total Section  you need to select the currency ,select the account and amount and click on insert button. Likewise if you have tax then selected the tax account

Stock Effect

Base on the Quantity enter in the Purchase Return the Inventory Stock for particular item
Get decrease in the warehouse (Optionally in the Particular Batch if selected)



Sales Order
Sales Order page can be access from Transaction / Sales Order. Here is where we can create Sales Order. In Sales Order the the Order number come automatically. Contract date, Shipment Terms, Shipment Date, Status and Customer Name need to be enter on Sales Order Link. On the Description link you enter Item to to Sales, warehouse ,optionally batch number,Quantity,Rate,Rate per unit and amount(which come automatically).On click of insert the data get display in the tabular form below.Here you can enter multiple item if required. The Total of the entire item get displayed at the bottom of the page.

On the total link you need to select the currency, select the account and amount and click on insert button. Likewise if you have tax then selects the tax account

Sales Invoice
Sales Invoice page can be access from Transaction/ Sales Invoice. Sales Invoice Can by 3 Method
1. By Creating Sales Invoice Without Creating Sales Order

2 By Creating Sales Invoice From Particular Sales Order

3. By Creating Multiple Sales Invoice From One Sales Order

1 Method

In Sales Invoice. Invoice number come automatically. Contract date ,Shipment Terms, Shipment Date, Status and Customer Name need to be enter on Sales Invoice Link. On the Description link you enter Item to to Sales, warehouse ,optionally batch number,Quantity,Rate,Rate per unit and amount(which come automatically).On click of insert the data get display in the tabular form below. Here you can enter multiple items if required. The Total of the entire item gets displayed at the bottom of the page.

On the total link you need to select the currency, select the account and amount and click on insert button. Likewise if you have taxes then select the tax account


2 Method

In Sales Invoice   Invoice numbers come automatically. In Sales Invoice link You need to select Sales Order then automatically Contract date, Shipment Terms, Shipment Date, Status and Vendor Name display in Sales Invoice Link. On the Description link All

 Item   enter   in Sales order with warehouse, optionally batch number, Quantity, Rate, Rate per unit and amount display in Grid View .Total of all the item get displayed at the bottom of the page.
On the total link you need to select the currency, select the account and amount and click on insert button. Likewise if you have taxes then select the tax account

 3 Method

In Sales Invoice, Invoice number comes automatically. In Sales Invoice link You need to select Sales Order then automatically Contract date, Shipment Terms, Shipment Date, Status and Customer Name display in Sales Invoice Link. On the Description link all
 Item   enter   in Sales order with warehouse, optionally batch number, Quantity, Rate, Rate per unit and amount display in Grid View (Suppose In Sales Order you enter 5 Item but you want to add only first two item then another 3 item remove from Sales invoice grid view and then update Sales Invoice. Now  if suppose if you want to Create New Sales Invoice  base on  same Sales order then remaining 3 item get  display in Sales Invoice  grid).Total of all the item get displayed at the bottom of the page.
On the total link you need to select the currency   , select the account and amount and click on insert button. Likewise if you have tax   then   selects the tax account

Stock Effect

Base on the Quantity enter in the Sales Invoice the Inventory Stock for particular item Get decrease   in the warehouse (Optionally in the Particular Batch if selected)

Sales Return

Sales Return page can be access from Transaction/ Sales Return Here is where we can create Sales Return .In Sales Return page Sales Return number come automatically. Contract date , Sales invoice no, Customer name you have selected
in the Description Section you enter Item to  Sales Return ,warehouse ,optionally batch number,Quantity,Rate,Rate per unit and amount(which come automatically).On click of insert the data get display in the tabular form below. Here you can enter multiple item if required.(Note:- You Return only those item enter in Sales Invoice with same warehouse(Optionally in the Particular Batch if selected))The Total of all the item get displayed at the bottom of the page.

in the total Section  you need to select the currency ,select the account and amount and click on insert button. Likewise if you have tax then select the tax account

Stock Effect
Base on the Quantity enter in the Sales Return the Inventory Stock for particular item
Get Increase in the warehouse (Optionally in the Particular Batch if selected)

Inventory Reports


 The Inventory Reports Menu is displayed when this option is selected from the Main Menu.

Intraweb Solutions has various reports available for analysis of Stock movements. Some reports give details of each incoming and outgoing Item and some are summarized reports based on various parameters.

The major Inventory Reports we would look at here are listed below.

Opening Stocks Register

. Stock Ledger
. Stock Statement
. Stock Movement
. Stock Valuation
. ABC Analysis
. Batch-wise Stock Analysis
. Ageing Analysis
. Reorder Report
. Fast Moving Items
. Slow Moving Items

 We shall study the above Reports in more detail on the following pages.
 
Opening Stocks Register
 
The Opening Stocks Register is a Report listing all the Opening Stock Balances, which are entered at the commencement of the Accounting Period or have been brought  forward from the Previous Accounting Year.

The Opening Stocks Register Parameters window is displayed when this option is selected from the Inventory Menu.

The Opening Stock Balances have to be entered at the commencement of the Accounting Period when you start using Intraweb Solutions for the first time. Thereafter, they will be automatically carried forward to the Next Accounting period, when the Current Year is “Closed”.

The Report displays the Date, Voucher Number, Product, Warehouse,Batch,Expiry Date,Mfg.Date,Quantity, Rate and Value.  

The Total Value of the Opening Stocks Register Report should tally with the Closing Stock Balance of the Previous Accounting Year. If it does not tally, recheck the Balances  brought forward with the Closing Stock Balances for the Previous Year.  

A sample Opening Stocks Register Report is displayed below.
 
Stock Ledger

 
This report displays complete details of all the Stock related Transactions over a selected  period.
The Stock Ledger Parameters window is displayed when this option is selected from the  Inventory Menu.
The Stock Ledger Report provides complete information regarding the Product related  Transactions.
It displays the Transaction Date, Voucher Number, Quantity Received, Rate at which Received, Quantity Issued, Rate at which Issued,
Quantity Balance, Average Rate, Value of Balance Quantity.

By default, the Transactions are listed in Date order for each Product.

The Report can also be filtered to view specific information, based on the criteria or  conditions you select .

Stock Statement

 
This Report displays the Daily Transactions of the Products in summary and also, the  effect of those Transactions on the Stock Balance and Value of the Products.  The Stock Statement Parameters window is displayed when this option is selected from  the Inventory Menu.  

For each  Product, it displays the incoming and outgoing transactions entered for that Product.

The report also keeps track of updating the Stock balance and Value with each transaction. Filter the report to see the Statement for a particular Warehouse.

Note that the Stock Statement differs from the Stock Ledger Report in that it does not  display the daily transactions in detail. You cannot view the Voucher Numbers of the  transactions or the individual Receipts and Issues. Rather, for each day it shows you the  Opening Stock Balance, Total Receipts, Total Issues and Closing Stock Balance for that  Day. The Receipts are added to the Opening Stock Balance and the Issues are deducted  to arrive at the Closing Stock Balance for the Day. Observe that the Closing Stock  Balance for one day is the Opening Stock Balance for the next day.

Stock Movement

The Stock Movement Report is similar to the Stock Statement Report but displays a  consolidated view of the Transactions for a Product over a given period.

The Stock Movement Parameters window is displayed when this option is selected from the Inventory Menu.

The Stock Movement Report is also sorted Product-wise. For each Product, it displays  the Opening Balance at the beginning of the Report period, the Total Quantity Received  and the Total Quantity Issued during the Report period, the Closing Stock Balance at the  end of the Report period and the Value of the Closing Stock Balance.  

You can filter the Report to view the information for a specific Warehouse

Stock Valuation

 
The Stock Valuation Report displays a list of Items with the Available Stock in hand, Unit  Cost and Value of each item.

The Stock Valuation Parameters window is displayed when you select this option from  the Inventory Menu.

The Stock Valuation Report shows you the Quantity of Stock on hand, the Unit Cost and the Value for each selected Product. Intraweb Solutions applies the method of  Valuation defined for each Product in the Product Master and displays the Value for the  Stock Quantity on hand, in the Report.

ABC Analysis

 
The “Always Better Control” (ABC) Analysis Report displays the Stock Balances in  descending order of their Value.

The ABC Analysis Parameters window is displayed when you select this option from the Inventory Menu.

The Report analyzes the values of the Inventory Items and displays the same in a  descending order, with the item having the highest value shown first. At a glance, this  Report would show you the Items  that have the highest level of investment  in your Inventory. This information would help you to take suitable decisions vis-à-vis  your Inventory management.

Batch-wise Stock Analysis


 
The Batch-wise Stock Analysis Report displays the Batch-wise Quantity on hand for each  Product. In other words, you can see the current Stock Balance of a Product broken  down Batch-wise.

The Batch-wise Stocks Parameters window is displayed when you select this option from the Inventory Menu.  you have an option to select the Batches that should be  displayed in the Report. The options are All Batches, only Good (valid) Batches or  Expired Batches,Select the appropriate and  Click OK to view the Report.

The Batch-wise Stocks Report is sorted Product-wise and displays the Batch-wise Stocks  details for each Product. These details include the Batch Number, the Quantity available  for the Batch, the Rate at which the Batch was received (Batch Rate), the Value (which is calculated as Quantity multiplied by the Batch Rate), the Expiry Date and Manufacturing Date of the Batch.

Ageing Analysis

 
The Ageing Analysis Report displays the age of the Stock Quantity on hand, grouping the  Quantity into various Ageing Slabs defined in Number of Days from the Date of entry.  The Ageing Analysis Parameters window is displayed when you select this option from  the Inventory Menu.

In the Ageing Slabs box, enter the Number of Days for the four Ageing Slabs. The  Report will use these Slabs to group the Stock on hand according to the Number of Days  elapsed since the Date of entry. Click OK to view  the report.  

For each Product  the Report displays the Total Stock Quantity on hand and it.s Value, before showing the breakup of the Total Quantity by the age of  the Stock. Essentially, the Stock ageing reflected here shows the number of days that  you have been holding these Quantities in your Inventory, irrespective of the Manufacturing or Expiry Dates for the same.
 
Reorder Report

 
The Reorder Report compares the current Stock Quantity with that defined as the  Reorder Level in the Product Master and displays all those Items where the Quantity on  hand is below the Reorder Level.

The Reorder Report Parameters window is displayed when you select this option from the Inventory Menu.

The Reorder Report checks the Reorder Level defined in the Product Master and  compares it with the  available Quantity balance. If the Quantity available is less  than the Reorder Level, Intraweb Solutions displays the Item, Quantity Balance, Reorder Level, the  Deficit Quantity to be ordered and the Deficit Value involved.  

The Report is useful to ensure timely Purchases of those Items, which fall below Reorder Levels from time to time. A periodic or regular review of this Report would help avoid  “Stock Out” situations, which otherwise disrupt Production schedules and Order Delivery  Schedules.


Fast Moving Items

The Fast Moving Items Report displays the list of Items having the highest Quantity  Issued from Inventory, in descending order of the Quantity issued by way of Sales or Consumption. Thus, the Item with the highest Issues is displayed first in the Report.

This Report is also referred to as the XYZ Analysis Report. The XYZ Analysis Parameters window is displayed when you select this option from the Inventory Menu.
The Fast Moving (XYZ) Analysis Report shows the outward movement (Issues) of Items from Inventory. The report displays the Items with highest Issue Quantity in a descending order that goes down to the Item, which has the lowest outgoing Quantity.

This report intraweb Solutionses on the Items that are fast moving in terms of Issues from Inventory, so that Stocks of those items can always be maintained.  

 
Slow Moving Items
The Slow Moving Items Analysis Report displays the list of Items having the lowest  Quantity Issued from Inventory, in ascending order of the Quantity issued by way of  Sales or Consumption. Thus, the Item with the lowest Issues is displayed first in the  Report.

The Slow Moving Items Analysis Parameters window is displayed when you select this option from the Inventory Menu.
The Slow Moving Items Analysis Report shows the outward movement (Issues) of Items from Inventory. The report displays the Items with lowest Issue Quantity in an  ascending order that goes down to the Item, which has the highest outgoing Quantity.

This report  on the Items that are slow moving in terms of Issues from Inventory,  so that Stocks of those items can be consumed or disposed off before their Expiry Dates.  
This report is required by management to analyze the inactive or non-moving Items, so  that they are not ordered again and also, to push out the slow moving Items through  promotions and schemes.

Barcode Inventory Control, Accounting and Business Management Software

We have Integrated Financial Accounting software with barcode for following user segments :

Business Houses * organizations * Traders, Dealers, Distributors or Stockists of Goods, Consumer Items, Pharmaceuticals * Wholesalers * Large Retailers * Medical Suppliers * Industries * Manufacturing Units * Automobile Dealers * Vehicle Service Stations * Garages * Petrol Pumps * Hotels, Guest Houses, Motels * Hospitals, Nursing Homes, Pathological Labs, X-Ray Labs * Newspapers, Magazine, Periodical Publishers * Commodity Brokers

Our software have features specific to the requirements of above user segments .
We offers the simplest, easiest-to-use manufacturing Bar code solutions in the industry. We offer a wide selection of quality products for creating, printing, and using bar codes. The use of bar coding in manufacturing is growing significantly. Bar codes provide fast, easy, and accurate method of data entry. The correct use of Bar codes decreases employee time required and increase an organization's efficiency.

Accurate inventory control is critical for any manufacturing company. Your enterprise needs to track receipts of goods, the movement of goods within or between locations, the sale, removal or other disposition of goods, and the precise valuation and status of goods remaining in inventory at any point in time down to the Location status, Color, Size, Style, Lot Numbers, Serial Numbers and Expiration Dates remaining in stock.

Apart from inventory bar coding is also implemented in transaction module. All transaction have unique bar code ID. Apart from that barcode is also used for identifying the customers, supplier and account heads. You can print the barcode labels from any module of the software using your laser or inkjet printers. No special barcode printers or fonts are required.

Our Accounting and Inventory Software is designed to provide you with accurate information on all aspects of your inventory and ensure you have the software tools to manage and control your inventory in the most cost-effective manner possible.
Task of Inventory Control

Fast and easy physical inventory counts
Accurate tracking of inventory
Accurate tracking of lot and serial tracked items
Bar code Inventory Module - Our Solution

Scan bar coded inventory items into the product record
Scan barcode of an item into invoice or memo to get all other information of the product filled in automatically for faster and accurate invoicing.
Print Bar coded Receiving Labels to track all incoming materials
Print Bar coded Pick Lists to track materials picked for shop orders or sales orders
Print Bar coded Shipping Labels to apply to packaged finished goods
Print Bar coded Serial number Labels to apply to finished product
To use labels to wand in physical count into Physical Inventory Module
Print Invoices, Vouchers etc. with barcodes for easy tracking of goods during shipping
Print barcodes on any laser or inkjet printer from within the the program. No special bar code printer or fonts are required.