Account Module

(1)

(2)

Account Module

Account Module is used to records the details of day by day financial transactions of the organization which are coming under Account Department. Following are the Transaction Forms in Account Module.

1. Bank - Used to create & record details of Bank A/c. Receipts & Payments 2. Cash - Used to create & records details of Cash Receipts & Payments 3. Journal Voucher - Used to create & record details of Journal Vouchers.

4. Cr / Dr Note - Used to create & record the Credit / Debit Notes 5. Contra - Used to create & record contra entries.

6. Main Report - Used to generate Reports of all forms.

7. Reconciliation - Used to examine item by item of two related sets of figures obtained from different sources.

8. MIS Reports - MIS Reports & Other Reports.

Bank / Cash

All Receipts | All Payments

Journal Voucher

Day Book Entry (Credit & Debit)

Cr / Dr Note

Credit / Debit Note Raising

Contra Entry

Cash To Bank / Bank to Bank / Cash to Cash / Bank to Cash

Main Reports

Reconciliation

(3)

Bank:

The Bank Transaction Form is used to create & record details of the Receipts & Payments which done through a Bank on daily basis.

Bank

Payment Receipt

Receipt (Option):

The receipt option is used to create and record the details of the payment receipts which received from customers or any other source.

Payment (Option):

The payment option is used to create and record the details of the payments made to the suppliers or any others.

Opening Bank Form:

To open the Bank Transaction Form, click on Account Module and then click on Bank. On clicking the Bank Transaction Form will be opened.

Note: Whenever you open the form, it will be in edition mode, so you can start entering the details directly.

(4)

First of all you have to fill up following fields which are mandatory.

Field Name Description / Function Field Type /

Job Owner Option Select Option as Receipt if the same is “Receipt” and if it is

for Payment, then select option “Payment”. The default select will be Receipt.

Mandatory By User

Sr. No. Sr. No. Auto filled by System. Mandatory

By System Day Book Select & define day book for the transaction.

Value comes from “Master>Categories> Account > Bank >”

Mandatory By System By User Account Name Select & define Account Name for the day book, if the

company has multiple accounts in the same day book. If the default Account Name is OK then do not change it but if you want select another one then delete the default value and press “Enter Key” and click on the right one from the displayed list of Account Names.

Value comes from “Master>Categories> Account > Bank > Account Ledger”

Mandatory By System By User

Voucher Dt. Date of Receipt / Payment Voucher. Auto filled by System. Mandatory By System Voucher No. Sr. No. of Receipt / Payment Voucher. Auto filled by system. Mandatory By System

Currency Select the currency of transaction. Mandatory

By User Exch. Rate Put the exchange rate of selected currency in this field. Mandatory

By User Cr. Balance System displays the Credit Balance of the selected Day Book

& Account Name

Mandatory By System Dr. Balance System displays the Debit Balance of the selected Day Book &

Account Name

Mandatory By System Description Write down the narration / description of the Receipt / Payment

Voucher

Bank Receipt / Payment Details Grid Fields:

(5)

(6)

Following are the grid fields.

By System Account Name Select & Define the Customer Name, Supplier Name etc. from

or to the payment receipted or paid.

Mandatory By User A/c. Short Name Value auto picked by system from Account Ledger.

Value comes from “Master > Account Ledger >”

Mandatory By System Dr. / Cr. Balance Showing the Account Balance of the selected Account Name. Mandatory By System Advance Check ID. Check if the Receipt of Payment is an advance. Optional

(If applicable) By User Amount Put the figure of amount Receipted or Paid. Mandatory

By User Deduction If there is any deduction like TDS or other, please press F3

and on pressing F3 a separate form will be opened in and in the form you have to enter the details.

Optional (if applicable)

By User

Acc_Code : Value Autopicked by System Ac_Name : Select the Account Name in this field. Description: Write down the details of deduction. Add_Amt. : Put the figure of deduction amount.

TDS : Check_ID. Click on the Check_ID if the same is TDS. This Check_ID will function, if you have applied the TDS option in the “Master > Account Ledger > Options” for the selected Account Name.

Voucher Amount Net Voucher amount after the deduction. Equation field. Value

displayed by the System. MandatoryBy System

Cheque No. Put the Cheque No. in this field. Mandatory

By User Cheque Dt. Date field. Select & define the Date of Cheque. Mandatory

By User Invoice No. Put the Invoice No. in this field. (if applicable) Optional

(If applicable) By User TDS Value Amount of TDS displayed by the system. Equation field. Mandatory

By System Order No. Put the Order No. in this field. (if applicable) Mandatory By User Order Dt. Date field. Select & define the Date of Order. Optional

(7)

Other Details:

1) Attachment : Please refer Common Features > Attachment 2) My Reminders : Please refer Common Features > My Reminders

Save: After completion of above, press button shown on top of the form or press “F5” Key to save the record.

New: After saving ff you want to define another code click on button shown on top of the form or press “F2” Key button and then make the necessary data entry.

Delete: To delete a record, first open the form and then press “Esc” key. This makes the form on Edition Off mode. Now form displays all the records whatever your stored in system. Select therecord(s) whichever you want to delete by clicking on it and click on button shown on top of the form or press “F6” Key.

(8)

Cash:

The Cash Transaction Form is used to create & record details of the day by day cash Receipts & Payments transactions.

Cash

Payment Receipt

Receipt (Option):

The receipt option is used to create and record the details of the payment receipts which received from customers or any other source.

Payment (Option):

The payment option is used to create and record the details of the payments made to the suppliers or any others.

Opening Cash Form:

To open the Cash Transaction Form, click on Account Module and then click on Cash. On clicking the Cash Transaction Form will be opened.

(9)

Job Owner Option Select Option as Receipt if the same is “Receipt” and if it is

for Payment, then select option “Payment”. The default select will be Receipt.

By System Day Book Select & define day book for the transaction.

Value comes from “Master>Categories> Account > Cash >”

Mandatory By System By User Account Name Select & define Account Name for the day book, if the

company has multiple accounts in the same day book. If the default Account Name is OK then do not change it but if you want select another one then delete the default value and press “Enter Key” and click on the right one from the displayed list of Account Names.

Value comes from “Master>Categories> Account > Cash > Account Ledger”

Mandatory By System By User

Voucher Dt. Date of Receipt / Payment Voucher. Auto filled by System. Mandatory By System Voucher No. Sr. No. of Receipt / Payment Voucher. Auto filled by system. Mandatory By System Cr. Balance System displays the Credit Balance of the selected Day Book

& Account Name MandatoryBy System

Dr. Balance System displays the Debit Balance of the selected Day Book & Account Name

Mandatory By System Description Write down the narration / description of the Receipt / Payment

Voucher MandatoryBy User

Cash Receipt / Payment Details Grid Fields:

(10)

By System Account Name Select & Define the Customer Name, Supplier Name etc. from

or to the payment receipted or paid.

Mandatory By System Dr. / Cr. Balance Showing the Account Balance of the selected Account Name. Mandatory By System Advance Check ID. Check if the Receipt of Payment is an advance. Optional

(If applicable) By User Amount Put the figure of amount Receipted or Paid. Mandatory

By User Deduction If there is any deduction like TDS or other, please press F3

and on pressing F3 a separate form will be opened in and in the form you have to enter the details.

Optional (if applicable)

By User

Acc_Code : Value Autopicked by System Ac_Name : Select the Account Name in this field. Description: Write down the details of deduction. Add_Amt. : Put the figure of deduction amount.

TDS : Check_ID. Click on the Check_ID if the same is TDS. This Check_ID will function, if you have applied the TDS option in the “Master > Account Ledger > Options” for the selected Account Name.

Voucher Amount Net Voucher amount after the deduction. Equation field. Value

displayed by the System. MandatoryBy System

By User Cheque Dt. Date field. Select & define the Date of Cheque. Mandatory

By User Invoice No. Put the Invoice No. in this field. (if applicable) Optional

(If applicable) By User TDS Value Amount of TDS displayed by the system. Equation field. Mandatory

By System Order No. Put the Order No. in this field. (if applicable) Mandatory By User Order Dt. Date field. Select & define the Date of Order. Optional

(11)

Other Details:

(12)

Journal Voucher:

The Journal Voucher is a written authorization prepared for every financial transaction, or for every transaction that meets defined requirements. This Transaction Form is used to create & record day by day Journal Voucher entries related to company accounts.

A journal voucher is an integral part of the audit trail, and carries (1) a serial number, (2) transaction date, (3) transaction amount, (4) ledger account(s) affected, (5) reference(s) to documentary evidence (such as invoices or receipts) supporting the entry, (6) brief description of the transaction, and the (7) signature(s) or initials of one or more authorized signatories. A journal is, in effect, a collection of financial data culled from journal vouchers.

Opening Journal Voucher Form:

To open the Journal Voucher Transaction Form, click on Account Module and then click on Journal Voucher. On clicking the Journal Voucher Form will be opened.

(13)

Job Owner Day Book Select & define day book for the transaction.

Value comes from “Master>Categories> Account > Journal Voucher”

By System Voucher No. Sr. No. of Journal Voucher. Auto filled by system. Mandatory By System Voucher Dt. Date of Journal Voucher. Auto filled by System. Can be

changed if required. MandatoryBy System

By User

Reference Put the Reference No. if any Mandatory

By User

Currency Select the currency of transaction. Mandatory

By User Exch. Rate Put the exchange rate of selected currency in this field. Mandatory

By User Due Date Set the Due Date for Receipt / Payment of Journal Voucher in

this field.

Mandatory By User Reminder If required you can set reminder for this due date by selecting

this option Check Box. MandatoryBy User

Journal Voucher Grid Fields:

(14)

Field Name Description / Function Field Type / _{Job Owner} Dr. / Cr. Balance Put the type of Account i.e. Debit or Credit in this field Mandatory

By User

By System Account Name Select & Define the Customer Name, Supplier Name etc. of

Journal Voucher in this field.

Mandatory By System Amount Put the figure of Journal Voucher Amount in this field. Mandatory By User Bill Adjustment

(Check Box)

Select this option only if the Journal Voucher for Bill Adjustment of Purchase or Sales or any other.

Mandatory By User Adjustment

(Button)

On Selection of option Bill Adjustment now you have to enter the details of Adjustment in this field. To enter the details just click on the Adjustment Button to open the Grid Table. After opening the Grid Table enter the details by adding row.

Ref. No. Put the Reference if any in this field. Optional By User Current Balance Auto displayed by the system. Equation field. Mandatory

By User Remarks Write down the remarks if any in this field. Optional By User

Other Details:

(15)

Credit / Debit Note:

Credit Note: A form or letter sent by a seller to a buyer, stating that a certain amount has been credited to the buyer's account.

Debit Note: A form or letter issued by a seller to advise the amount owed by the buyer. An invoice is a type of debit note. Also called debit memo.

This Transaction Form is used to create record & issue the Credit or Debit Notes related to company accounts transactions.

Opening Credit / Debit Note:

To open the Cr / Dr Note Transaction Form, click on Account Module and then click on Cr / Dr Note. On clicking the Credit or Debit Note Form will be opened.

There are two option buttons i.e. Credit & Debit. For Credit Note, please select the Credit and for Debit Note, please select Debit.

See Picture 

Field Name Description / Function Field Type / _{Job Owner} Day Book Select day book for the transaction.

Value comes from “Master>Categories> Account > Cr / Dr Note”

(16)

Sr. No. Sr. No. Auto filled by System. Mandatory By System Voucher No. Sr. No. of Credit Note or Debit Note Voucher. Auto filled by

system.

Mandatory By System Voucher Dt. Date of Credit or Debit Note. Auto filled by System. Can be

changed if required.

Mandatory By System By User Party Name Select party name in this field on which the Credit Note or

Debit Note is raised.

Value comes from “Master > Account Ledger ”

Mandatory By User Amount Put the Amount of Credit or Debit Note in this field. Mandatory

By User Cr or Dr Bal On selection of Credit or Debit option, the system shows the

Credit Balance or Debit Balance of the selected Party in this field.

Mandatory By System New Reference If new reference is applicable, please click on the Check Box &

define the New Reference in this field.

Mandatory By User Against Reference If against reference is applicable, please click on the Check

Box & define the Against Reference in this field.

Mandatory By User Narration Write down the Narration of the Credit or Debit Note in this

field.

Mandatory By User Remarks Write down the remarks if any in this field. Mandatory

By User

Grid Table Fields:

Sr. Auto filled by the system. Mandatory

By System A/C. Name Select the Account Name in this field. If Credit or Debit Note is

for multiple items then you can select multiple rows. MandatoryBy User Amount Put the amount of Credit or Debit Note in this field. Mandatory By User Cr_Dr Select the Type of Amount i.e. Credit or Debit Mandatory

By User Remarks

Other Details:

(17)

Contra Entry:

The Contra Transaction Form is used to make a booking entry that is entered on the opposite side of an earlier entry to cancel its effect on the account balance.

Opening Contra Entry:

To open the Contra Transaction Form, click on Account Module and then click on Contra. On clicking the Contra Transaction Form will be opened.

After opening the Contra Transaction Form select the type of Contra Transaction from option displayed in the Form. Following are the Contract Transaction Type;

1. Cash To Cash 2. Cash To Bank 3. Bank To Cash 4. Bank To Bank

See Picture 

First of all you have to fill up following fields which are mandatory. Cash To Cash Contra Entry:

Job Owner Day Book Select day book for the transaction.

Value comes from “Master>Categories> Account > Contra”

(18)

Sr. No. Sr. No. Auto filled by System. Mandatory By System Voucher No. Sr. No. of Contra Entry Voucher. Auto filled by system. Mandatory By System Voucher Dt. Date of Contra Entry Voucher. Auto filled by System. Can be

Mandatory By System By User Bank A/c. / Cash

A/c. Select the Cash Account Name in this field. Value comes from “Master > Account Ledger ”

Mandatory By User Narration Write down the Narration of the Cash to Cash Contra Entry in

this field.

A/C. Name Select the Account Name in this field. If it is for multiple items then you can select multiple rows.

Amount Put the amount in this field. Mandatory

By User Remarks Write down the remarks if any in this field. Mandatory

By User Cash To Bank Contra Entry:

Job Owner Day Book Select day book for the transaction.

By System Voucher No. Sr. No. of Contra Entry Voucher. Auto filled by system. Mandatory By System Voucher Dt. Date of Contra Entry Voucher. Auto filled by System. Can be

Mandatory By System By User Bank A/c. / Cash

A/c. Select the Cash Account Name in this field. Value comes from “Master > Account Ledger ”

Mandatory By User Narration Write down the Narration of the Cash to Bank Contra Entry in

this field.

(19)

Bank To Bank Contra Entry:

By User Bank A/c. / Cash

A/c.

Select the Bank Account Name in this field. Value comes from “Master > Account Ledger ”

Mandatory By User Narration Write down the Narration of the Bank to Bank Contra Entry in

this field. MandatoryBy User

Cheque No. Put the Cheque No. in this field Mandatory

By User Cheque Dt. Select & Define the Date of cheque in this field. Mandatory

By User

By User Bank To Cash Contra Entry:

By User Bank A/c. / Cash

A/c.

Select the Bank Account Name in this field. Value comes from “Master > Account Ledger ”

Mandatory By User Narration Write down the Narration of the Bank to Cash Contra Entry in

this field.

A/C. Name Select the Account Name in this field. If it is for multiple items

then you can select multiple rows. MandatoryBy User

Cheque No. Put the Cheque No. in this field Mandatory

By User Cheque Dt. Select & Define the Date of cheque in this field. Mandatory

By User

(20)

Other Details:

(21)

Main Reports:

The Main Reports Form contains all the required reports of the Accounts Module of the organization which are required by transaction wise and also yearly.

Opening Main Reports:

To open the Main Reports Form, click on Account Module and then click on Main Reports. On clicking the Main Reports Form will be opened. Following are Main Report of the Account Module.

1. JV Details (Journal Voucher Details) 2. Reconciliation Details

3. Account Ledger Utility. 4. Opening Balance 5. Trial Balance Sheet 6. Ledger Details

7. Profit & Loss Account 8. Day Book Details 9. Bank Book Details 10. Cash Book Details 11. Balance Sheet

12. Bank / Cash Statement See Picture 

(22)

Journal Voucher Details Report button is used to generate the detailed report of Journal Vouchers day wise / week wise / month wise/ yearly with transaction details. To generate it, after opening the Main Report, click on JV Details button. On clicking the following JV Details Form will be opened. See Picture 

In the Form you have to select the period at following fields;

From Date : Select the date from which you want to start the JV Monthly Summary period. To Date : Select the date of ending period.

After select the periods, click on button to view the JV Monthly Summary details. See Picture 

(23)

If you want generate report for printing or making PDF file or exporting to any other application, click on button. On clicking the report format with data will be displayed.

Now to view the details of JV Monthly Summary for a particular month, please make double click on month name and making double click another Form will be opened named as JV Details and the JV Details of the particular month will be displayed in that Form. If you want remove an entry, please select it and click on button to remove it.

See Picture 

RECONCILIATION DETAILS:

Reconciliation Details button is used to view and generate the reports of Reconciliation of various Day Books for various periods as per your requirement. To view & generate it, after opening the Main Report, click on Reconciliation Details button. On clicking the following Reconciliation Details Form will be opened.

See Picture 

In the this Form you have to select & fill following fields; Book Name : Select the Day Book in this field

From : Select the starting date of Reconciliation Details period. To : Select the ending date of Reconciliation Details period.

(24)

Options:

Un-cleared : To view all un-cleared reconciliation entry details. Un-cleared : To view all cleared reconciliation entry details.

Un-cleared : To view all cleared & un-cleared reconciliation entry details.

After selecting & filling the fields, click on button to view the Reconciliation Details. See Picture 

ACCOUNT LEDGER UTILITY:

Account Ledger Utilities button is used to search & view the transaction details of particular Voucher as and when required. To search & view it, after opening the Main Report, click on Account Ledger Utility button. On clicking the following Account Ledger Utility Form will be opened.

See Picture 

(25)

See Picture 

After selecting & filling the fields, click on button to view the Account Ledger Details of selected Voucher Name.

(26)

BANK BOOK DETAILS:

Bank Book Details button is used to generate the detailed report of Bank Book Entries day wise / week wise / month wise/ yearly with transaction details. To generate it, after opening the Main Report, click on Bank Book Details button. On clicking the following Bank Book Details will be opened.

See Picture 

In the Form you have to select & fill the following fields;

Bank Book Name : Select the Bank Book Name in this field.

From : Select the starting date from which you want the Bank Monthly Summary period.

To : Select the ending date of period.

After select the periods, click on button to view the Bank Book Monthly Summary details. See Picture 

(27)

If you want to remove the Bank Monthly Summary for particular period or month, click on the Check Box mentioned in line of that particular period or month to select it. Then click on

button to remove it.

Now to view the details of Bank Monthly Summary for a particular month, please make double click on month name and making double click another Form will be opened named as Bank Details and the Bank Details of the particular month will be displayed in that Form. If you want remove an entry, please select it and click on button to remove it.

(28)

LEDGER DETAILS:

Ledger Details button is used to generate the detailed Account Statement of particular Party month wise / yearly with transaction details. To generate it, after opening the Main Report, click on Ledger Details button. On clicking the following Ledger Details will be opened.

See Picture 

Ledger Name : Select the Account Ledger Name in this field.

From : Select the starting date from which you want the Ledger Monthly Summary. To : Select the ending date of period.

After select the periods, click on button to view the Ledger Monthly Summary details. See Picture 

(29)

If you want to remove the Ledger Monthly Summary for particular period or month, click on the Check Box mentioned in line of that particular period or month to select it. Then click on

Now to view the details of Ledger Monthly Summary Details for a particular month, please make double click on month name and making double click another Form will be opened named as Ledger Vouchers and the Ledger Vouchers of the particular month will be displayed in that Form. If you want remove an entry, please select it and click on button to remove it.

(30)

CASH BOOK DETAILS:

Cash Book Details button is used to generate the detailed report of Cash Book Entries day wise / week wise / month wise/ yearly with transaction details. To generate it, after opening the Main Report, click on Cash Book Details button. On clicking the following Cash Book Details will be opened.

See Picture 

Bank Book Name : Select the Cash Book Name in this field.

From : Select the starting date from which you want the Cash Monthly Summary. To : Select the ending date of period.

After select the periods, click on button to view the Cash Book Monthly Summary details. See Picture 

(31)

If you want to remove the Cash Monthly Summary for particular period or month, click on the Check Box mentioned in line of that particular period or month to select it. Then click on

Now to view the details of Cash Monthly Summary for a particular month, please make double click on month name and making double click another Form will be opened named as Cash Book Details and the Bank Details of the particular month will be displayed in that Form. If you want remove an entry, please select it and click on button to remove it.

(32)

DAY BOOK DETAILS:

Day Book Details Report button is used to generate the detailed report of day by day transaction of Day Book on day wise / week wise / month wise/ yearly with transaction details. To generate it, after opening the Main Report, click on Day Book Details button. On clicking the following Day Book Details Form will be opened.

See Picture 

In the Form you have to select the period at following fields;

From Date : Select the date from which you want to start the Day Book Details. To Date : Select the date of ending period.

The period should within the financial year.

After select the periods, click on button to view the Day Book Details. See Picture 

If you want to remove the Day Book Details for particular period or month, click on the Check Box mentioned in line of that particular period or month to select it. Then click on button to remove it.

(33)

Now to view the details of Day Book Details Summary for a particular month, please make double click on month name and making double click another Form will be opened named as Voucher and the Voucher details of the particular month will be displayed in that Form. If you want remove an entry, please select it and click on button to remove it.

(34)

BANK / CASH STATEMENT:

Bank / Cash State button is used to generate the detailed report of Bank / Cash transaction statements on day wise / week wise / month wise/ yearly with transaction details. To generate it, after opening the Main Report, click on Bank / Cash Statement button. On clicking the following Bank / Cash Statement Form will be opened.

See Picture 

First of all you have to select Statement option i.e. Bank Statement or Cash Statement by clicking on the Check Box. Whenever you select the option as Bank only the Bank Day Books list will be displayed in Day Book Name field when you select it and for option Cash only the Cash Book names will be displayed in Day Book Name field.

After selecting ht e option now select & fill-up the following fields;

Day Book Name : Select the Day Book Name i.e. Bank or Cash in this field. From : Select the starting date of Bank / Cash Statement in this field. To : Select the ending date of Bank / Cash Statement in this field. The period should within the financial year.

After select the periods, click on button to view the Day Book Details. See Picture 

(35)

TRIAL BALANCE SHEET:

Accounting: The aggregate of all debit and credit balances at the end of an accounting period that (1) shows if the general ledger is in balance (total debits equal total credits) before making closing entries, (2) serves as a worksheet for making closing entries, and (3) provides the basis for making draft financial statements.

Trial Balance Sheet button is used to generate the detailed report aggregate of all debit and credit balances at the end of an account period (1) shows if the general ledger is in balance (total debits equal total credits) before making closing entries, (2) serves as a worksheet for making closing entries, and (3) provides the basis for making draft financial statements. To generate it, after opening the Main Report, click on Trial Balance Sheet button. On clicking system will ask following

See Picture 

First put select from & to date in the related fields and after that if you want the Trial Balance Sheet only for opening balance then, please select the option “Only Opening Balance” by clicking on Check Box or if not then leave the option as unselected. Now press

See Picture 

(36)

PROFIT & LOSS:

Profit & Loss Account is a measure of financial performance that indicates earnings after expenses and other deductions are made. There are several levels of profit including gross profit, net profit, and net operating profit after taxes.

Profit & Loss button is used to generate the detailed reports of the Profit & Loss Account of the organization. To generate it, after opening the Main Report, click on Profit & Loss button. On clicking system will ask following

See Picture 

First put select from & to date in the related fields and after that if you want the Profit & Loss Account Report only for opening then, please select the option “Yes” by clicking on Check Box or if not then select the option “No”. Now press

(37)

BALANCE SHEET:

Balance Sheet is condensed statement that shows the financial position of an entity on a specified date (usually the last day of an accounting period).

Balance Sheet button is used to generate the Balance Sheet Statement of the organization for particular period or financial year. To generate it, after opening the Main Report, click on Balance Sheet button. On clicking system will ask following

See Picture 

First put select from & to date in the related fields and after that if you want the Balance Sheet Report only for opening then, please select the option “Yes” by clicking on Check Box or if not then select the option “No”. Now press

See Picture 

(38)

OPENING BALANCE:

Opening Balance button is used to enter or import the Opening Balance figure of Stock, Account, Sales Tax Forms, Excise & Reconciliation. For all these opening entries there are separate form and to open it, click on the Opening Balance.

Item Opening Stock

Item Opening Stock form is used to enter new stock or import the last financial year closing stocks. If you use the software first time, then you have to enter the opening item stock manually or import with help. If you are already installed and already entered the item stock details then import the item opening stock by click on Fetch Opening for New Year button.

See Picture 

Entering Item Stock Manually

Before entering the Item Stock Manually you have select & define the Item Group & Sub Groups (Wherever it applicable). You can find out the items by Item Name or Alt. Name (Item Code) for which you are making the opening stock.

You can find the item through entering its group & sub group names. You can find the item by entering item name.

(39)

Following are Form Fields in this form;

Job Owner Item Group To select the Item Group an opening stock item Mandatory By User Sub Group To select sub group of an opening stock item (if applicable) Mandatory

By User Sub Group1 To select sub group1 of an opening stock item (if applicable) Mandatory

By User Sub Group2 To select sub group2 of an opening stock item (if applicable) Mandatory

By User Find Item To find an item by its name. Type the starting of item name in

this field then system displays items starting with typed word.

Mandatory By User Find Alt. Item To find an item by its Alt. Name or Item Code. Type the Alt.

Name or Item code in this field then system displays the items of typed item code.

Date Date of Item opening stock. Mandatory

By System In this form there are to Grid Forms. One is for entering the items and another one is for entering the items on which the excise is applicable.

General Grid Table:

To enter all the items which are covered under Item Opening Stock.

Grid Table Fields:

Following are the Grid Table fields;

Field Name Description / Function _{Job Owner}Field Type

IT_CODE Auto filled by System. Not Editable Mandatory

By System Item Name Stock Item Name. Auto filled by System. Not Editable Mandatory By System Alt. Name Stock Item Alt. Name or Item Code. Auto filled by System. Not

Editable

Mandatory By System Drg. No. Displays Drawing No. of Selected Stock Item (if applicable).

Not Editable

Mandatory By System

(40)

Alt. Qty. (Button)

To enter the Item Alt Qty. Click on the Alt. Qty. button. On clicking one window will be opened showing the Location and other details. Fill-up the fields which are editable.

See Picture 

Qty. Put the stock quantity of the selected item in this field. Mandatory By User

Rate Put the rate of item in this field. Mandatory

By User QC Ref. No. Enter the QC Reference (if any) of the selected item in this

field. MandatoryBy User

Item Stock Details Grid Table:

To record the details of Excisable Items with name of manufacturer which are related to RG reports. If the selected items is coming under excise riles then fill-up the excise details along with name of manufacturer in this form.

After all these click on button and after that click on button to save the record.

Importing Item Stock (Fetch Opening for New Year)

This option is used to import Item Stock from previous year closing balance. Click on the button named as “Fetch Opening for New Year”. On clicking the system will as as shown below;

(41)

Account Opening Balance

Account Opening Balance form is used to enter Opening Balance of organizations various accounts or import the last financial year closing Account balances. If you use the software first time, then you have to enter the Account opening balance manually. If you are already installed and already doing the account transactions then import the item opening stock by click on Fetch Opening for New Year button.

See Picture 

Entering Account Opening Balance Manually

Before entering the Account Opening Balance Manually you have select Main Group Name of Account in “Select Main Group Name” field. On selection of Main Group all accounts created under the selected group will be displayed in the general Grid Table.

If you want to import all accounts of all groups in single click, then click on button. On clicking the all accounts will be displayed in general Grid Table.

You can find out the accounts by typing the account name in “Find By Account” field. General Grid Table:

(42)

Following are the Grid Table fields;

AC_NAME Auto filled by System. Not Editable Mandatory

By System Short Name Account Code. Auto filled by System. Not Editable Mandatory By System Credit Amount Enter the Credit Amount in this field. Mandatory By User Debit Amount Enter the Debit Amount in this field. Mandatory

By User City Auto filled by System. Not Editable (if applicable) Mandatory

By System Category Auto filled by System. Not Editable (If applicable) Mandatory By System From_Ledger_Code Auto filled by System. Not Editable Mandatory By System From_Ledger_Name Auto filled by System. Not Editable Mandatory By System Importing Account Opening (Fetch Opening for New Year)

This option is used to import Account Opening Balances for all accounts from previous year closing balance. Click on the button named as “Fetch Opening for New Year”. On clicking the system will as shown below;

To import the Account Opening balances, click on button. After sometime the item list of Accounts with opening balance will be displayed in the General Grid Table.

Account Outstanding Details:

The Account Outstanding Details tab form is used to enter the outstanding details of the company bill wise of any particular accounts displayed in the General Grid Table. To enter the details first you have to select the account name from General Grid Table and then click right button of mouse in the Account Outstanding Details tab form and select Add Rows.

(43)

Advance Details:

The Advance Details tab form is used to enter the advance payment details of the company which received or paid to any particular accounts displayed in the General Grid Table. To enter the details first you have to select the account name from General Grid Table and then click right button of mouse in the Advance Details tab form and select Add Rows.

(44)

“C” Form Opening

“C” Form Opening is used to enter the details of Pending “C” forms for the Sales done against “C” Form. In this form you have to enter details manually and there is no an importing option.

See Picture 

First of all select the type of sales in “Sales Type” field and after that click right button of mouse in Grid Table and select Add Rows. Fill-up the following fields.

Financial Year Put the Financial Year of Sales Invoice in this field. Mandatory By User Party Name Select the Name of Party in this field. Mandatory

By User Bill No. Put the Sales Invoice / Bill No. in this field. Mandatory

By User Bill Date Put the Sales Invoice / Bill Date in this field. Mandatory

By User Bill Amount Put the Sales Invoice / Bill Amount in this field. Mandatory

By System After all these click on button to save the record.

(45)

Excise Opening Entry

Excise Opening Entry form is used to enter the Excise opening balance details. See Picture 

First of all select the financial year in Account Year field after that enter opening balance details in the necessary fields.

(46)

Reconciliation Opening

Reconciliation Opening for is used to enter the opening of Reconciliation details of the Bank Account(s) of the organization.

See Picture 

First of all select the day book of reconciliation in “Day Book” field and after that click right button of mouse in Grid Table and select Add Rows. Fill-up the following fields.

Sr. No. Put the Serial Number in this field. Mandatory

By User Voucher Dt. Select the Voucher Date in this field. Mandatory

By User Account Name Select the Account Name in this field Mandatory

By User Account Code Auto filled by system on selection of Account Name. Mandatory

By System Type Select Type of Payment i.e. Receipt or Payment Mandatory By User

Cheque Amt. Put the Cheque Amount in this field Mandatory

By User Cheque Dt. Select the Date of Cheque in this field. Mandatory

By User

(47)

Reconciliation:

The Reconciliation Transaction Form is used Item by item examination of two related sets of figures obtained from different sources. Most commonly, this term is applied to bank reconciliation.

Opening Reconciliation Form:

To open the Reconciliation Form, click on Account Module and then click on Reconciliation. On clicking the Reconciliation Transaction Form will be opened.

After opening the Reconciliation Transaction Form you have to select option “Bank” or “Cash” by clicking on the button given in the form in Green Colour (Bank) & Red Colour (Cash).

See Picture 

Value comes from “Master>Categories> Account > Reconciliation”

By System Date Select & Define the Reconciliation Date in this field. Auto filled

by the system.

(48)

Records Searching Options:

If you want check a particular record by cheque no., particulars, credit amount or debit amount you search it. For that you have give any one of the details in the following fields.

Cheque No. Put the cheque no. in this field for searching the record by

cheque number wise and pres “Enter” key MandatoryBy System Particulars Put the particulars if any in this field for searching the record

by particular wise and pres “Enter” key

Mandatory By System By User Credit To search the record by Credit Amount wise, put the exact

amount in this field and pres “Enter” key

Mandatory By User Debit To search the record by Debit Amount wise, put the exact

amount in this field and pres “Enter” key

After completion of the above, click on “GENRATE” button to display the details in grid field. Grid Table Fields:

Check ID Check Box. Used to select the record to make Reconciliation Date Entry.

Mandatory By User Reconciliation Dt. Put the Date of Reconciliation. The date should post date of

Cheque or Cash Voucher. MandatoryBy User

Cleared Dt. Put the Date of Cheque / Cash Voucher Cleared. The date should post date of Cheque or Cash Voucher.

Voucher Dt. Auto filled by the system Mandatory

By System

Voucher No. Auto filled by the system Mandatory

By System

Particulars Auto filled by the system Mandatory

By System

Trans Type Auto filled by the system Mandatory

By System

Credit Auto filled by the system Mandatory

By System

Debit Auto filled by the system Mandatory

By System Cheque Amount Auto filled by the system. Only applicable for Bank option. Mandatory By System Cheque Dt. Auto filled by the system. Only applicable for Bank option. Mandatory By System

F.Y. Financial Year. Auto filled by the system Mandatory

By System

Type_O Auto filled by the system Mandatory

By System Balance as per

Company Book Displays the Balance of Company Books of Account. Calculation Field. Auto Filled by System MandatoryBy System Amounts Not

Reflected in Bank

Displays the Amount which not reflected in Bank Account. Calculation Field. Auto Filled by System

(49)