Banking in Tally.ERP 9

 Home / / Banking in Tally.ERP 9

Banking in Tally.ERP 9

Banking Features in Tally.ERP 9


Banking Module has been enhanced in Tally.ERP 9 to simplify the overall banking experience. A separate menu Banking has been provided under Utilities in the Gateway of Tally. The user need not go to different menus to operate the banking related operations in Tally.ERP 9, such as Printing Cheques (pre-Configured), BRS (Bank Reconciliation Statement), Printing Cheque/Cash Deposit Slips, printing Payment Advices, managing Cheques, Import Bank Statement for Auto BRS, etc.

The banking transactions can now be provided with Bank Allocation details such as the Transaction Type, Instrument No, Date, etc. A single bank amount can also be allocated to multiple transaction types such as Cheque, Electronic Cheque, Electronic DD/PO, Inter Bank Transfer, Others and Same Bank Transfer based on the requirement.

The BRS screen now provides detailed information with regard to transaction types, instrument no., instrument date, cheque favouring, etc. The user can also provide Opening BRS for unreconciled transactions.

Features of Banking in Tally.ERP 9

The salient features of Banking in Tally.ERP 9 are as follows:

Cheque Printing:

Allows user to configure cheques for banks using sample formats provided, which come along with images.

Supports multiple Cheque formats for a single bank.

Allows user to print the pending or already printed or the required cheques continuously from a single screen.

Also allows user to update the cheque details and have track of cheques to be printed, of a selected or all banks.

Vertical Cheque Printing is an enhanced feature in cheque printing.

Configurations can be stored on Tally.NET for easy maintenance and update.

Cheque Register

Allows user to configure cheque number ranges for Auto cheque numbering based on cheque range.

Duplicate cheque number validation

Report for cheques issued (like the issue log slip in the cheque books)

Inventory of cheques available (not used)

Stale/cancelled cheque management

Filters based on Cheque range

Bank Reconciliation:

The BRS screen allows user to reconcile the bank account.

This screen will now provide detailed information with regard to transaction types, instrument no., instrument date, cheque favouring, etc.

User can also provide Opening BRS for unreconciled transactions.

Allows user to import bank statements to perform Auto Bank Reconciliation.

Deposit Slips:

Bank-wise Cash Deposit Slips for the Cash being deposited can be generated automatically along with cash denominations.

Cash Deposit Slips that are required to accompany Cash that is being deposited to the Bank can be generated automatically along with cash denominations.

Payment Advice:

The payment advice sent to the suppliers / other parties along with the cheques/other instruments may be generated quickly from the voucher itself.

To access Banking, go to Gateway of Tally > Banking.



Migrating Banking Vouchers for Existing Data

When the existing users of Tally.ERP 9 access their company data using Tally.ERP 9 Release 3.0 for the first time, will migrate the Banking vouchers.

On completion of migration, the following has to be considered for Bank Reconciliation:

The Transaction Type row in the Bank Reconciliation screen will be blank. The user may alter the vouchers and select the appropriate transaction type (Cheque/DD) in the Bank Allocation table and accept the vouchers, in case required.



The Instrument Date displayed in the Bank Reconciliation screen will be the Voucher Date. The reconciliation will be based on the Instrument Date provided in the Bank Allocation table and not on the Voucher date.



The Bank Reconciliation screen lists the transactions on the basis of each transaction type selected in the voucher.
Example: A single banking voucher having Cheque/DD and Electronic Cheque as Transaction type will be considered as two transactions in the Bank Reconciliation screen.

More:

Banking Features

Cheque Printing

Auto Bank Reconciliation

Manual Bank Reconciliation

Cheque Deposit Slip

Cash Deposit Slip

Payment Advice

Cheque Management

Banking Features


Default features for Banking can be altered from the F11: Features > F1: Accounting Features screen

Set the option Alter Banking Features to Yes

The Banking Features screen appears as shown below:

The fields in the screen are explained below:

Alter List of Transaction Types: On setting this option to Yes, the Alteration of Transaction Types screen opens. In this the user can include or exclude Transaction Types, as required

Note: At-least one Transaction Type should be enabled for Payments and Receipts.
Show Additional Bank Details For: Banking Details include Account Number, IFS Code, Bank Name for Inter Bank Transfers and Account Number for Same Bank Transfer. On enabling this option, all these Additional Details will get displayed during Voucher entry. If the user doesn't want to display these details during entry, the option None can be selected.

Allow to Enter Beneficiary Code: On enabling this option, a button B:Show Beneficiary Code/Hide Beneficiary Code is available in the Ledger Master Creation/Alteration screens. This will help the user enter Beneficiary Code, specific to the Bank selected in the Company

Note: All Ledger Creation/Alteration screens have the option Allow to Enter Beneficiary Code, except Cash, P& L and Bank
Show Transfer Mode: Enabling this option, will display the Mode of Transfer (NEFT/RTGS) in the Bank Allocations screen for Inter Bank Transfers transaction type while passing Payments and Receipts voucher entry. This will get picked up during voucher entry using Voucher Class

Enable Bank Details for Cost Centres: This option is available only if Cost Centres and Cost Categories are enabled for the Company. On setting this to Yes, the Cost Centre Creation screen will have the option Provide Bank Details.

Import Beneficiary Bank Account Details: Bank Account Details of the beneficiary can be imported in Excel Format,  if this option is set to Yes

If this option is set to Yes, the Import  of Data screen appears as shown below:

Enter the Import File Name, along with the location path to import the required Excel File

To view a sample file, click the button, P: Payee Sample File

Note: If Payroll is enabled, the button, E: Employee Sample File is available, which is used to import Employee Bank Details
The Exporting Sample File screen appears. On accepting this screen, the Ledger Bank Details file opens

Cheque Printing



The Cheque Printing option in the Banking menu allows the user to print all the pending, already printed or the required cheques continuously from a single screen. It also allows to update the cheque details of a transaction, i.e., the instrument no, instrument date, cheque favouring, etc. The bank ledger needs to be enabled for cheque printing from ledger creation or alteration mode.

Click the links given below for details.

Accessing Cheque Printing

Printing Cheques / Cheque Printing Reports

Configuring Cheque Printing

Accessing Cheque Printing

To access Cheque Printing screen,

Go to Gateway of Tally > Banking > Cheque Printing.

The Select Bank screen displaying the List of Bank appears as shown:



Select All or the required Bank account from the List of Bank.

Press Enter.

The Cheque Printing screen of the selected Bank is displayed as shown:



By default, this screen displays list of pending cheques of the current date’s month.

Press F6: Show All to display all the cheques.



Note: This button toggles between Show All / Hide Printed.
Bank Not Configured for Cheque Printing

The cheque printing screen will prompt with a message Bank not configured for Cheque Printing when the bank ledger not configured for cheque printing is selected, as shown:



The bank needs to be enabled for cheque printing from ledger alteration screen.

In the Cheque Printing screen of the ledgers configured for it,

Select the required row from the Cheque Printing list to open the voucher in alteration mode.

F2: Period: Allows to change the period.

F4: Bank: Allows to select All / Other required Bank from the list.

F7: Edit Ch Details: Allows to edit/update the Favouring Name, Instrument No and Instrument Date columns, as shown:



Accept the screen to save the settings.

F12: Range: Allows to filter the Cheque printing screen. The user can filter the transactions based on the Amount, Bank Date, Date, Favouring Name, Instrument Date, Instrument No., Ledgers, Narration, Remarks and Transaction Type as shown:



Printing Cheques / Cheque Printing Reports

The user may print All or selected cheque from the Cheque Printing list.

Printing All Cheques

To Print All Cheque from the list,

Go to Gateway of Tally > Banking > Cheque Printing.

Select the required Bank account from List of Bank. To change the selection made, press F4: Bank button to select another bank.

The Cheque Printing screen is displayed.

Click Print or Press Alt+P.

The Print Report screen appears. Set the option Print Cheque to Yes as shown:



Note: The option - Print Cheque appears only if a particular bank is selected for printing cheques. On selecting All Items for displaying pending cheques of different banks in cheque printing screen, this option will not appear.
Accept to Print all the cheques.

The Cheque Printing proceeds and displays confirmation for each cheque with Cheque Details, as shown:



Confirm to print cheque one by one before printing. Additionally the facility to change the orientation and adjust the distance of top edge and left edge with flexibility to avoid printing the date on cheque is provided.

Printer Selection

Press S: Select Printer button to select the printer and the paper size. Select the paper size as A4.

Orientation

In the Sample Cheque Printing screen, press N: Orientation button (Alt+N) to select the orientation. The orientations - Vertical and Horizontal gets listed.



On selecting Vertical - centre/left/right the cheque gets printed in vertically (oriented as portrait). Using these options, the cheque can be printed by setting the orientation to:

Vertical Left: On inserting the paper in the printer tray, the cheque gets printed vertically on the left hand side of the paper.

Vertical Centre: On inserting the paper in the printer tray, the cheque gets printed vertically at the centre of the paper.

Vertical Right: On inserting the paper in the printer tray, the cheque gets printed vertically on the right hand side of the paper.

Additionally for printing the cheque face up or face down with vertical orientation, the field - Print From (for Vertical Only) gets displayed. Depending on the printer, the front or rear can be selected.  

Front: In printers which print face up select Front.

Rear: For printers which print face down place the paper in reverse order and select Rear.

On selecting Horizontal the cheque gets printed horizontally (oriented as landscape).

Overall Adjustment

Using the configuration provided for overall adjustment:

The cheque dimensions pre-configured on selecting the cheque format can be adjusted such that the overall dimensions get shifted by the required 'mm' from top and left edge of cheque.

While printing the cheque, date field can be left blank if it is not required to be printed.

From the Sample Cheque Printing screen, click on F12: Configure button and change/retain the dimensions in 'mm' as per requirement.



Adjust Distance From Top Edge (in mm): To adjust the distance from top edge such that the overall measurements defined in Cheque Dimensions screen get shifted as per the 'mm' entered here.

Adjust Distance From Left Edge (in mm): To adjust the distance from left edge such that the overall measurements defined in Cheque Dimensions screen get shifted as per the 'mm' entered here.

Print Amount in Foreign Currency: Set this option to Yes, to print cheques for foreign currency transactions in the respective currency.

Print Date: By default the date gets printed on the cheque. If the date is not to be printed on the cheque set this field to No.

Accept the configuration and print the cheque. The adjustments done for overall adjustment using F12: Configuration of cheque printing screen does not affect the settings of Cheque Dimensions pre-configured for the selected cheque format.

The Printed Cheque displays as shown:



Printing Selected Cheques

To Print selected Cheques from the list,

Go to Gateway of Tally > Banking > Cheque Printing.

Select All or required Bank account from List of Bank.

The Cheque Printing screen is displayed.

Press spacebar to select the required row(s).

Click Print or Press Alt+P.

The Cheque Printing screen appears.

Accept to print the cheque(s).

Cheque Report Printing

To print the Cheque report,

Go to Gateway of Tally > Banking > Cheque Printing.

Select All or required Bank account from List of Bank.

The Cheque Printing screen is displayed.

Click Print or Press Alt+P.

Cheque Report Printing screen appears confirming to print.

Click No or Press N or Esc.

Print Cheque: This option appears on selecting a particular bank. Set it to No.

Include Printed Cheques also: Set this option to Yes to display the printed cheques also in the report.

Show Forex Transactions only: Set this option to Yes in case you need only the forex transactions to be displayed in the report.

Note: This option appears only in case Multi Currency feature is enabled for the company.
Show Payment Favouring: Set this option to Yes to display Favouring Name details in the report.

Show Remarks also: Set this option to Yes to display the Remarks in the report.

On setting Print Cheque it to Yes, the options - Include Printed Cheques also, Show Payment Favouring and Show Remarks also gets set to No automatically as the user has opted to print cheque. If Print Cheque is set to No, a statement displaying all entries including details of printed cheques can be generated with information about favouring name and remarks as entered in the Bank Allocation sub-screen of payment voucher.

The Cheque Report Printing screen is displayed as shown:



Accept to Print.

The Cheque Report Printing is displayed as shown:



Configuring Cheque Printing

The user may configure the Cheque Printing screen based on his requirement.

To configure,

Press F12: Configure, the Configuration screen is displayed as shown:



Confirm each Cheque before Print

By default this is set to Yes. The cheque printing will confirm for each cheque before printing.

Include Printed Cheques also

By default, this option is set to No. Set it to Yes to display the Printed Cheques also

Note: This option is similar to the function key F6: Show All / Hide Printed.
Show Forex Transactions only

By default, this option is set to Yes. The cheque printing screen displays only the forex transaction.

Note: This option appears only in case the company is enabled with multi currency feature.
Show Payment Favouring

By default, this option is set to Yes. The cheque printing screen displays the Favouring Name column.

Note: The Favouring Name column displays only those names which are different from the Party/Ledger account names.
Show Remarks also

By default, this option is set to No. Set it to Yes to display the Remarks also.

Appearance of Name

Select the required Display Name Style from the list to display in cheque printing screen.

Scale Factor for Values

Select the required Scale Factors from the list.

Sorting Method

Select the required Sorting Methods from the list.

Cheque Printing



The Cheque Printing option in the Banking menu allows the user to print all the pending, already printed or the required cheques continuously from a single screen. It also allows to update the cheque details of a transaction, i.e., the instrument no, instrument date, cheque favouring, etc. The bank ledger needs to be enabled for cheque printing from ledger creation or alteration mode.

Click the links given below for details.

Accessing Cheque Printing

Printing Cheques / Cheque Printing Reports

Configuring Cheque Printing

Accessing Cheque Printing

To access Cheque Printing screen,

Go to Gateway of Tally > Banking > Cheque Printing.

The Select Bank screen displaying the List of Bank appears as shown:



Select All or the required Bank account from the List of Bank.

Press Enter.

The Cheque Printing screen of the selected Bank is displayed as shown:



By default, this screen displays list of pending cheques of the current date’s month.

Press F6: Show All to display all the cheques.



Note: This button toggles between Show All / Hide Printed.
Bank Not Configured for Cheque Printing

The cheque printing screen will prompt with a message Bank not configured for Cheque Printing when the bank ledger not configured for cheque printing is selected, as shown:



The bank needs to be enabled for cheque printing from ledger alteration screen.

In the Cheque Printing screen of the ledgers configured for it,

Select the required row from the Cheque Printing list to open the voucher in alteration mode.

F2: Period: Allows to change the period.

F4: Bank: Allows to select All / Other required Bank from the list.

F7: Edit Ch Details: Allows to edit/update the Favouring Name, Instrument No and Instrument Date columns, as shown:



Accept the screen to save the settings.

F12: Range: Allows to filter the Cheque printing screen. The user can filter the transactions based on the Amount, Bank Date, Date, Favouring Name, Instrument Date, Instrument No., Ledgers, Narration, Remarks and Transaction Type as shown:



Printing Cheques / Cheque Printing Reports

The user may print All or selected cheque from the Cheque Printing list.

Printing All Cheques

To Print All Cheque from the list,

Go to Gateway of Tally > Banking > Cheque Printing.

Select the required Bank account from List of Bank. To change the selection made, press F4: Bank button to select another bank.

The Cheque Printing screen is displayed.

Click Print or Press Alt+P.

The Print Report screen appears. Set the option Print Cheque to Yes as shown:



Note: The option - Print Cheque appears only if a particular bank is selected for printing cheques. On selecting All Items for displaying pending cheques of different banks in cheque printing screen, this option will not appear.
Accept to Print all the cheques.

The Cheque Printing proceeds and displays confirmation for each cheque with Cheque Details, as shown:



Confirm to print cheque one by one before printing. Additionally the facility to change the orientation and adjust the distance of top edge and left edge with flexibility to avoid printing the date on cheque is provided.

Printer Selection

Press S: Select Printer button to select the printer and the paper size. Select the paper size as A4.

Orientation

In the Sample Cheque Printing screen, press N: Orientation button (Alt+N) to select the orientation. The orientations - Vertical and Horizontal gets listed.



On selecting Vertical - centre/left/right the cheque gets printed in vertically (oriented as portrait). Using these options, the cheque can be printed by setting the orientation to:

Vertical Left: On inserting the paper in the printer tray, the cheque gets printed vertically on the left hand side of the paper.

Vertical Centre: On inserting the paper in the printer tray, the cheque gets printed vertically at the centre of the paper.

Vertical Right: On inserting the paper in the printer tray, the cheque gets printed vertically on the right hand side of the paper.

Additionally for printing the cheque face up or face down with vertical orientation, the field - Print From (for Vertical Only) gets displayed. Depending on the printer, the front or rear can be selected.  

Front: In printers which print face up select Front.

Rear: For printers which print face down place the paper in reverse order and select Rear.

On selecting Horizontal the cheque gets printed horizontally (oriented as landscape).

Overall Adjustment

Using the configuration provided for overall adjustment:

The cheque dimensions pre-configured on selecting the cheque format can be adjusted such that the overall dimensions get shifted by the required 'mm' from top and left edge of cheque.

While printing the cheque, date field can be left blank if it is not required to be printed.

From the Sample Cheque Printing screen, click on F12: Configure button and change/retain the dimensions in 'mm' as per requirement.



Adjust Distance From Top Edge (in mm): To adjust the distance from top edge such that the overall measurements defined in Cheque Dimensions screen get shifted as per the 'mm' entered here.

Adjust Distance From Left Edge (in mm): To adjust the distance from left edge such that the overall measurements defined in Cheque Dimensions screen get shifted as per the 'mm' entered here.

Print Amount in Foreign Currency: Set this option to Yes, to print cheques for foreign currency transactions in the respective currency.

Print Date: By default the date gets printed on the cheque. If the date is not to be printed on the cheque set this field to No.

Accept the configuration and print the cheque. The adjustments done for overall adjustment using F12: Configuration of cheque printing screen does not affect the settings of Cheque Dimensions pre-configured for the selected cheque format.

The Printed Cheque displays as shown:



Printing Selected Cheques

To Print selected Cheques from the list,

Go to Gateway of Tally > Banking > Cheque Printing.

Select All or required Bank account from List of Bank.

The Cheque Printing screen is displayed.

Press spacebar to select the required row(s).

Click Print or Press Alt+P.

The Cheque Printing screen appears.

Accept to print the cheque(s).

Cheque Report Printing

To print the Cheque report,

Go to Gateway of Tally > Banking > Cheque Printing.

Select All or required Bank account from List of Bank.

The Cheque Printing screen is displayed.

Click Print or Press Alt+P.

Cheque Report Printing screen appears confirming to print.

Click No or Press N or Esc.

Print Cheque: This option appears on selecting a particular bank. Set it to No.

Include Printed Cheques also: Set this option to Yes to display the printed cheques also in the report.

Show Forex Transactions only: Set this option to Yes in case you need only the forex transactions to be displayed in the report.

Note: This option appears only in case Multi Currency feature is enabled for the company.
Show Payment Favouring: Set this option to Yes to display Favouring Name details in the report.

Show Remarks also: Set this option to Yes to display the Remarks in the report.

On setting Print Cheque it to Yes, the options - Include Printed Cheques also, Show Payment Favouring and Show Remarks also gets set to No automatically as the user has opted to print cheque. If Print Cheque is set to No, a statement displaying all entries including details of printed cheques can be generated with information about favouring name and remarks as entered in the Bank Allocation sub-screen of payment voucher.

The Cheque Report Printing screen is displayed as shown:



Accept to Print.

The Cheque Report Printing is displayed as shown:



Configuring Cheque Printing

The user may configure the Cheque Printing screen based on his requirement.

To configure,

Press F12: Configure, the Configuration screen is displayed as shown:



Confirm each Cheque before Print

By default this is set to Yes. The cheque printing will confirm for each cheque before printing.

Include Printed Cheques also

By default, this option is set to No. Set it to Yes to display the Printed Cheques also

Note: This option is similar to the function key F6: Show All / Hide Printed.
Show Forex Transactions only

By default, this option is set to Yes. The cheque printing screen displays only the forex transaction.

Note: This option appears only in case the company is enabled with multi currency feature.
Show Payment Favouring

By default, this option is set to Yes. The cheque printing screen displays the Favouring Name column.

Note: The Favouring Name column displays only those names which are different from the Party/Ledger account names.
Show Remarks also

By default, this option is set to No. Set it to Yes to display the Remarks also.

Appearance of Name

Select the required Display Name Style from the list to display in cheque printing screen.

Scale Factor for Values

Select the required Scale Factors from the list.

Sorting Method

Select the required Sorting Methods from the list.

Manual Bank Reconciliation



The Bank Reconciliation option in the Banking menu allows the user to perform the following operations:

Reconcile Bank accounts.

Create vouchers from the Bank Reconciliation screen itself.

The user can also provide opening BRS for unreconciled transactions.

Alter the voucher by selecting the required transaction from the Bank Reconciliation screen.

Filter the report to display transactions based on Amount, Bank Date, Instrument No, Instrument Date, Party ledger, etc.

Accessing Bank Reconciliation

Printing Bank Reconciliation Statement

Configuring Bank Reconciliation Statement

Accessing Bank Reconciliation

To access Bank Reconciliation screen,

Go to Gateway of Tally > Banking > Bank Reconciliation

The Select Bank screen displaying the List of Bank appears as shown:



Select the required Bank account from the List of Bank and press Enter.

The Bank Reconciliation screen of the selected Bank appears. By default the details in the Bank Reconciliation screen are sorted based on Bank Date (if bank date is already specified for the transaction). Or else, such sorting will be based on the Instrument Date.



Note:
 
1. The Bank Reconciliation screen can also be accessed from Gateway of Tally > Display > Accounts Books > Cash/Bank Books > Select Bank Ledger > Select a month > F5: Reconcile.
 
2. By default, the screen displays the period range from date specified in the Effective Date for Reconciliation in the Bank ledger master till the date of last entry.
 
3. The Bank Date has be to be provided based on the Instrument Date and not on Voucher Date.
Button options in Bank Reconciliation screen

F2: Period

Press F2 key or click F2: Period to specify a period for which the Bank Reconciliation screen is to be displayed.

S: Set Bank Dates

To set a bank date for all the transactions for reconciliation, click S: Set Bank Dates button or press Alt+S key.

On pressing Alt+S, a Set Bank Date sub-screen appears as shown:



Instrument Date: On selecting Instrument Date as the Bank Date Type, the Bank Date field for all the transactions in the Bank Reconciliation screen is filled with the instrument date entered for that transaction in the Bank Allocations screen.

New Date: On selecting New Date as the Bank Date Type, a new field Date appears in the Set Bank Date sub-screen.



      Specify the required bank date that is to be filled for all the transactions in the Bank Reconciliation screen.

Voucher Date: On selecting Voucher Date as the Bank Date Type, the Bank Date field for all the transactions in the Bank Reconciliation screen is filled with the Date of Voucher.

C: Create Voucher:

Press Alt+C key or click C: Create Voucher to create a voucher from the Bank Reconciliation screen itself.

U: Opening BRS

In Tally.ERP 9 Series A Release 3.0 onwards the user may provided opening BRS to the unreconciled transactions using this function.

The opening BRS will be used in the following scenarios:

The BRS feature was used in the middle of the financial year by setting Effective Date of  Reconciliation in Bank ledger master in Tally.ERP 9, or

Accounting was started in Tally.ERP 9 in the middle of the financial year.

Opening balance of Bank having unreconciled transactions brought forward to Bank ledger created in Tally.ERP 9, or for other reasons.

In these cases the user had to manually keep track of the unreconciled transaction until they are reconciled.   

To provide Opening BRS:

Click U: Opening BRS.

The Opening Bank Allocation screen for the selected Bank is displayed as shown:



Provide the unreconciled transaction details based on the nature of transactions  (Deposit/Withdrawal) as shown:



Save the screen.

When the company data is split the unreconciled transactions will automatically get updated in the Opening BRS details.

The Bank Reconciliation screen is displayed with opening BRS provided as shown:



Provide the date of the realised transactions (the amount reflecting in the bank passbook) in the Bank Date field provided.

Save the Bank Reconciliation screen.

Note: When the user tries to access F12: Range for filters in the Bank Reconciliation screen, will prompt to Accept the current screen before proceeding.
Press Ctrl+Enter on the required transaction row to open the voucher in alteration mode.

F12: Range

Allows to filter the Bank Reconciliation screen. The user may filter the transactions based on the Amount, Bank Date, Date, Favouring Name, etc as shown:



Configuring Bank Reconciliation

The user may configure the Bank Reconciliation screen based on his requirement.

To configure,

Press F12: Configure, the Configuration screen is displayed as shown:



Select vouchers to show

By default, all the vouchers are displayed. Select the required Ledger Entries type from the list.

Show Narrations also

Set this option to Yes to display the narration in the Bank Reconciliation screen.

Show Remarks also

Set this option to Yes to display the remarks in the Bank Reconciliation screen as shown:



Show Forex details also

Set this option to Yes to display the forex details also in the report.

Show Forex Transactions only

By default, this option is set to Yes. The cheque printing screen displays only the forex transaction.

Note: The options Show Forex details also and Show Forex Transactions only appear only in case Multi Currency feature is enabled for the company.
Show Reconciled Transactions also

Set this option to Yes to display the reconciled transactions also in the Bank Reconciliation screen.

Allow Back dated Reconciliation

Set this option to Yes to allow reconciling back dated transactions also.

Show Payment Favouring / Received From

Set this option to Yes to display the Payment Favouring / Received From details in the Bank Reconciliation screen.

The Bank Reconciliation screen with Narration, Remarks and Payment Favouring/Received From details is displayed, as shown:



Note:
 
1.The Favouring Name column displays only those names which are different from the Party/Ledger account names.
 
2. Bank Reconciliation capability has been enhanced, from this screen users can
 * View the voucher display by pressing Alt + Enter from Bank Date field
 * Alter the Voucher by pressing Ctrl +Enter from Bank Date field
Show all Unreconciled Transactions Till Date

Set this option to Yes to display all the Unreconciled Transactions till the given date, irrespective of the From date set in the Bank Reconciliation Statement.

Note:
1. This option is also available in Gateway of Tally > F12:Configure > General.
 
2.The option set will be applicable to all the banks for the selected company.
Appearance of Name

Select the required Display Name Style from the list to display in cheque printing screen.

The completed Bank Reconciliation screen is displayed as shown



Printing Bank Reconciliation Statement

The user may print the Bank Reconciliation statement for the required Bank.

To Print Bank Reconciliation Statement:

Go to Gateway of Tally > Banking > Bank Reconciliation.

Select the required Bank account from List of Bank.

The Bank Reconciliation screen is displayed.

Click Print or Press Alt+P.

The Print Report screen appears.



Click No or Press N or Esc to set the following options:

Select Vouchers to Show: By default this is selected as All Vouchers, select the required option from the Ledger Entries list.

Show Narrations also: Set this option to Yes to display the narration in the report.

Show Remarks also: Set this option to Yes to display the remarks in the report.

Show Forex details also: Set this option to Yes to display the forex details in the report.

Show Forex Transactions only: Set this option to Yes to display the forex transactions only in the report.

Note: The options Show Forex details also and Show Forex Transactions only appear only in case Multi Currency feature is enabled for the company.
Show Reconciled Transactions also: Set this option to Yes to display the reconciled transactions also in the report.

Show Payment Favouring/Received From: Set this option to Yes to display the Payment Favouring/Received From details in the report.

Accept to Print.

The Bank Reconciliation Statement appears as shown:



Alteration of Reconciled Voucher

In some cases users may alter the reconciled vouchers by changing/splitting the amount, in such cases Tally.ERP 9 will display the message asking the confirmation to continue with the alteration. Users can later a reconciled voucher from Day Book, Bank Conciliation or from voucher reports.

Here ABC company is altering the voucher dated 3-7-2010 (already reconciled) where the company has issued the cheque for Rs. 1000 to Supreme Computers

Note: To alter a voucher from Bank Reconciliation report, from Bank Date field press Ctrl + Enter
The amount of 1000 has been split into 600 & 400. On saving this voucher Tally.ERP 9 displays the message indicating the reconciled voucher is altered and bank balance in BRS will not Match, hence Bank Date will be removed.

Cheque Deposit Slip



The Cheque Deposit Slip option in the Banking menu allows the user to generate the deposit slip for payments received through cheque/dd which need to be deposited into the bank.

Click the below links for detail.

Accessing Cheque Deposit Slip

Printing Cheque Deposit Slip / Cheque Deposit Slip Report

Configuring Cheque Deposit Slip

Accessing Cheque Deposit Slip

To access Cheque Deposit Slip screen,

Go to Gateway of Tally > Banking > Deposit Slip > Cheque Deposit Slip.

The Select Bank screen displaying the List of Bank appears as shown:



Select the required Bank account and press Enter.

The Cheque Deposit Slip screen of the selected Bank is displayed as shown:



Note: The Cheque Deposit Slip screen displays only those transactions which have Cheque/DD as Transaction type allocated in the Bank Allocation table in the Receipt voucher entry.
Select the required row from the Cheque Deposit Slip list and press Enter to open the voucher in alteration mode.

F2: Period allows to change the period.

F4: Bank allows to select other required Bank from the list.

F5:Cash allows user to view cash transactions (for the same Bank).

F6: Show All allows user to view the transactions for which cheque deposit slips haven’t been printed or to view all transactions for that bank for the period mentioned.

F7: Edit Ch Details allows to edit/update the Received From Name and Instrument No. as shown:



Note:
 
The Received From is an addition field available in the Cheque Deposit Slip screen to specify the name of Individual / Business Organisation who has issued the cheque, to be printed in the deposit slip / report.
 
When the user tries to access F12: Range for filters in Edit Cheque Details screen, will prompt to Accept the current screen before proceeding.
Accept the screen to save the settings.

Ctrl+P: Mark as Printed allows to mark all the Cheque Deposit Slips as Printed at once.

F12: Range allows to filter the Cheque Deposit Slip screen. The user may filter the cheque details based on the Amount, Bank Date, Date, Party Ledger, etc as shown:



Printing Cheque Deposit Slip / Cheque Deposit Slip Report

The user may select All or the required receipts to be included in the Cheque Deposit Slip. The Cheque Deposit Slip report prints all the receipts for the selected period.

Printing Cheque Deposit Slip

To Print the Cheque Deposit Slip,

Go to Gateway of Tally > Banking > Deposit Slip >  Cheque Deposit Slip.

Select the required Bank account from List of Bank.

The Cheque Deposit Slip screen is displayed with the list of receipts.

To include all the receipts in the Cheque Deposit Slip,

Click Print or Press Alt+P.

To include selected receipts in the Cheque Deposit Slip,

Press Spacebar to the required receipt row(s).

Click Print or Press Alt+P.

The Printing Cheque Deposit Slip screen appears.



Click No or Press N or Esc to set the other options as follows:

Print Deposit Slip: By default, this option is set to Yes.

Date of Printing: By default, the current date is displayed. Specify the required date to be printed in the Cheque Deposit Slip.

Space to leave on Top (default 0.5 inches): Set the required space.

Show Received From: Set this option to Yes to print the Received From details in the deposit slip.

Print Company's Telephone Number: Set this option to Yes to print the Company's Telephone Number.

Print Company’s PAN/IT Number: By default, this option is set to Yes.

Note: The option Show Forex Transactions only will skip when you are opting to print the Cheque Deposit Slip.
Accept to Print.

The Cheque Deposit Slip is displayed as shown:



Printing Cheque Deposit Slip Report

To Print the Cheque Deposit Slip Report,

Go to Gateway of Tally > Banking > Deposit Slip > Cheque Deposit Slip.

Select the required Bank account from List of Bank.

Click Print or Press Alt+P.

The Printing Cheque Deposit Slip screen appears.

Click No or Press N or Esc to set the other options as follows:

Print Cheque Deposit Slip: By default, this option is set to Yes. Set this option to No to print the report.

Space to leave on Top (default 0.5 inches): Set the required space.

Show Forex Transactions only: By default, this option is set to No. Set this option to Yes in case you need only the forex transactions to be displayed in the report.

Note: This option appears only in case Multi Currency feature is enabled for the company
Show Received From: Set this option to Yes to display the Received From details in the report.

Show Bank/Branch Name also: Set this option to Yes to display the Bank and Branch columns in the report.

Show Remarks also: Set this option to Yes to display the Remarks in the report.

Accept to Print.

The Cheque Deposit Slip Report is displayed as shown:



Note: The Received From column will display the receiver's name (provided in the Bank Allocation), only if it is different from the Party/Ledger Name displayed in Particulars column.
Configuring Cheque Deposit Slip

The user may configure the Cheque Deposit Slip screen based on his requirement.

To configure,

Press F12: Configure, the Configuration screen is displayed as shown:



Show Forex Transactions only:

By default, this option is set to No. Set it to Yes to display only the forex transactions.

Note: This option appears only in case the company is enabled with multi currency feature.
Show Received From:

By default, this is set to No. Set it to Yes to display Received From column in the Cheque Deposit Slip screen to specify the details as shown:



Show Bank/Branch Name Also

By default, this is set to No. Set it to Yes to display Bank and Branch columns in the Cheque Deposit Slip screen.

Show Remarks also:

By default, this is set to No. Set it to Yes to display Remarks column in the Cheque Deposit Slip screen.

Appearance of Name:

Select the required Display Name Style from the list to display in deposit slip screen.

Scale Factor for Values:

Select the required Scale Factors from the list.

Sorting Method:

Select the required Sorting Methods from the list.

Cash Deposit Slip



Any cash received has to be deposited in the bank with relevant Cash Deposit Slip attached. Tally.ERP 9 allows users to generate cash deposit slip for depositing cash into a bank on any particular date. The Cash Deposit Slip option in the Banking menu is used to generate cash deposit slips, bank-wise.

The Cash Deposit Slip provided in Tally.ERP 9 has all the contents of cash deposit slip – Account Number, Account Holder Name, Bank Name, Branch Name (information is fetched automatically from Bank ledger), Company’s Telephone Number, (information is fetched automatically from Company Creation screen), and Cash Denomination Details (information is fetched automatically from Contra voucher), so that user will not have to manually enter all the details.

Accessing Cash Deposit Slip

Printing Cash Deposit Slip / Deposit Cash Slip Report

Configuring Cash Deposit Slip

Accessing Cash Deposit Slip

To access Cash Deposit Slip screen,

Go to Gateway of Tally > Banking > Deposit Slip > Cash Deposit Slip.

                                                                      

List of Bank will be displayed in the Select Bank screen as shown:



Select the required Bank account from the list for whose transaction you want to print Cash Deposit Slip and press Enter.

The Cash Deposit Slip screen of the selected Bank is displayed as shown:



Note: The Cash Deposit Slip screen displays only those transactions which have Cash as Transaction Type allocated in the Bank Allocation screen in the Contra voucher entry.
Select required row from the Cash Deposit Slip list and press Enter to open the voucher in alteration mode.

F2: Period is used to view cash transactions for a particular period.

F4: Bank is used to toggle between the banks from the same screen. This will reduce navigation time.

F5: Cheques allows user to view transactions for which Cheques/DDs have been received (for the same Bank), and print Cheque Deposit Slip for the same.

F6: Show All allows user to view the transactions for which cash deposit slips haven’t been printed or to view all transactions for that bank for the period mentioned.

F12: Range allows user to filter Cash Deposit Slip screen. User may filter the transactions based on the Amount, Date, Bank Date, Instrument Date, etc. as shown:



This is a useful tool, as it makes the process of finding particular transactions fast, easy and simple.

Printing Cash Deposit Slip / Cash Deposit Slip Report

Cash Deposit Slip can be printed for all or just selected transactions.

Cash Deposit Slip Report can be printed for all the transactions for the selected period

Printing Cash Deposit Slip

To Print the Cash Deposit Slip,

Go to Gateway of Tally > Banking > Deposit Slip > Cash Deposit Slip

Select the required Bank account from List of Bank.

The Cash Deposit Slip screen displays the list of transactions for the bank selected.

To print Cash Deposit Slip for selected transactions,

Press Spacebar to select required transaction(s).

Click Print or Press Alt+P.

The Printing Cash Deposit Slip screen appears.



Date of Printing: The date that has to be printed on the Cash Deposit Slip has to be specified in this field. By default, the current system date is displayed. Usually, this date will be the date on which the actual deposit of the cash into the bank will be made.

Space to leave on Top (default 0.5 inches): This is the space between the top of the page and the Title (First Line on the page). User can specify the dimension as per requirement.

Print Company's Telephone Number: Set this option to Yes to print the Company's Telephone Number. The Telephone Number specified in the Company Creation screen will be captured.

Print Company’s PAN/IT Number: The PAN or IT Number specified in the F11: Features (F3: Statutory & Taxation) will be captured. By default, this option is set to No.

Click on Yes or Press Y or Enter to Accept.

A new screen will appear where Cash Denomination details can be specified for individual transaction, as shown:



By default, it will take the cash denominations specified in the Contra voucher.  If the Cash Denominations are different during actual cash deposit in bank, click on No or press N or Esc and enter the Cash Denomination details.

Accept to print.

The Cash Deposit Slip is displayed as shown:



Note: If A/c Holder Name is not mentioned in the Bank ledger master, then the name of the company as mentioned in the Company Creation screen will be printed as Account Holder Name of the Cash Deposit Slip.
The Cash Deposit Slip for the first transaction will be printed.

For the next transaction selected, a new Cash Denomination details screen will appear. User can specify the details and print the Cash Deposit Slip.

A separate Cash Deposit Slip will be printed for all the selected transactions.

To print Cash Deposit Slips for all transactions,

Click Print or Press Alt+P.

The Printing Cash Deposit Slip screen appears.



Click No or Press N or Esc to set the other options as follows:



Print Cash Deposit Slip: When all the transactions are selected for printing, user can print a report of the Cash Deposit Slip by setting this option to No. By default, this option is set to No.

Date of Printing: By default, the current date is displayed. Specify the date to be printed in the Cash Deposit Slip. This date should be the date on which the actual deposit of the cash in the bank will be made.

Space to leave on Top (default 0.5 inches): This is the space between the top of the page and the Title (First Line on the page). User can specify the dimension as per requirement.

Print Company's Telephone Number: Set this option to Yes to print the Company's Telephone Number. The Telephone Number specified in the Company Creation screen will be captured.

Print Company’s PAN/IT Number: The PAN or IT Number specified in the F11: Features (F3: Statutory & Taxation) will be captured.

Click on Yes or Press Y or Enter to Accept.

A new screen will appear where Cash Denomination details can be specified for individual transaction, as shown:



By default, it will take the cash denominations specified in the Contra voucher. If the Cash Denominations are different during actual cash deposit in bank, click on No or press N or Esc and enter the Cash Denomination details.

Accept to print.

The Cash Deposit Slip is displayed as shown:



The Cash Deposit Slip for the first transaction will be printed.

For the Next transaction selected, a new Cash Denomination details screen will appear. User can specify the details and print the Cash Deposit Slip.

A separate Cash Deposit Slip will be printed for all the transactions.

Note: 1. If the option Print Consolidated Cash Deposit Slip is set to Yes, then a blank Cash Denomination details screen is displayed and a combined Cash Deposit Slip is printed for all the transactions selected.
 
2. On filling in the details in this screen and pressing Enter at the end, a notification is displayed – Details entered here will not get updated in the vouchers.
Printing Cash Deposit Slip Report

To Print the Cash Deposit Slip Report,

Go to Gateway of Tally > Banking > Deposit Slip > Cash Deposit Slip.

Select required Bank account from List of Bank.

Click Print or Press Alt+P.

The Printing Cash Deposit Slip screen appears.



Click No or Press N or Esc to set the other options as follows:

Print Cash Deposit Slip: Set this option to No to print the Cash Deposit Slip report.

Space to leave on Top (default 0.5 inches): This is the space between the top of the page to the Title (First Line on the page). User can specify the dimension as per requirement.

Show Remarks also: Set this option to Yes to display the Remarks in the report.

Accept to Print.

The Cash Deposit Slip Report is displayed as shown:



Configuring Cash Deposit Slip

User may configure the Cash Deposit Slip screen based on requirements.

To configure,

Press F12: Configure, the Configuration screen is displayed as shown.



Print Consolidated Cash Deposit Slip:

This option, when enabled, is used to print a single Cash Deposit Slip for all selected transaction. By default, this is set to No. Set this option to Yes, to generate a Consolidated Cash Deposit Slip of the selected transactions.

Include Printed Cash Deposit Slips also:

To view all the transactions for a given period, even if Cash Deposit Slip has been printed for them, this option can be set to Yes.

Note: This option will work in accordance with the F6: Show All option in the Button Bar.
Show Remarks also:

To view the remarks entered in the Contra voucher, set this option to Yes. A Remarks column will appear in the Cash Deposit Slip screen. By default, this is set to No.

Appearance of Name:

In the Cash Deposit Slip screen, user can choose the Display Style of the name under Particulars column; Alias (Name), Alias Only, Name (Alias) or Name Only, using this option.

Scale Factor for Values:

User can choose to view the Value in the Amount column based on different factors – Crores, Hundreds, Lakhs, Millions, Ten Lakhs, Ten Millions, Ten Thousands, and Thousands.

Sorting Method:

List of transactions can be sorted by user by selecting any of the Sorting Methods from the list. The transactions can be sorted in ascending or descending order based on – Amount-wise, Date, Instrument Date, Instrument Number, Party-wise. By default, the transactions are sorted in ascending order based on Date.

Payment Advice



The Payment Advice option in the Banking menu allows the user to generate the payment advice to be sent to suppliers/other parties along with the cheques/other instruments.

Accessing Payment Advice

Printing Payment Advice

Accessing Payment Advice

To access Payment Advice screen,

Go to Gateway of Tally > Banking > Payment Advice.

The ledger selection screen displaying the List of Ledgers appears as shown:



Select the required Ledger and press Enter.

Note: If All items is selected, the payment advice for all transactions will be displayed
The Payment Advice screen displays the payment list of the selected ledger as shown:



Select the required row and press Enter to open the voucher in Alteration mode.

Press F12:Configurations for more options as shown below:



Confirm each payment advice before Print/e-Mail:  If user selects multiple transactions for mailing/printing belonging to different Parties,  then the confirmation screen will be displayed one by one for each party's payment advice. If this option is set to No then Confirmation screen display once.

Note: The option will come when user selects "All Items' and not when individual ledger is selected
Start Fresh page for Print/e-Mail : When this option is set to Yes, if user selects multiple transactions for mailing/printing belonging to same Party, then print/mail  for one transaction will happen per page at a time (without combining all into one page)  

To print the Payment Advice when a single ledger is selected,

Go to Gateway of Tally > Banking > Payment Advice.

Select the required Ledger account from List of Ledgers.

The Payment Advice screen is displayed with list of payment vouchers.



To print each transaction or payment advice in separate page,

Press F12:Configure

Set Yes to Start fresh page for each transaction for Print/e-Mail as shown below:



Accept the screen

Printing Payment Advice

To print the payment advice of all the payments,

Click Print or Press Alt+P.

To print the payment advice for the selected payments:

Press Spacebar to select the required payment row(s)

Click Print or Press Alt+P.

 

The Print Report screen appears as shown below:



Click No or Press N or Esc key to set the other options as follows:

Payment Advice Date: By default, the current date is displayed. Provide the required date

Include Bill Details: By default, this options is set to No. Set it to Yes to include the bill details in the payment advice

Show Transferred to: By default, this options is set to No. Set it to Yes to show the transferred information like A/c No, IFS code, Bank Name which is applicable for Inter & Same Bank Transfer

Print Due Date: By default, this option is set to No. Set it to Yes to print the due date in the payment advice

Print Company’s PAN/IT Number: By default, this option is set to No. Set Yes to print the PAN/IT No of the company

Button options in the Payment Advice report

F2: Period

Press F2 key or click F2: Period button to change the period.

F4: Ledger

Press F4 key or click F4: Ledger button to select other required Ledger from the list.

P: Mark as Printed

Press P: Mark as Printed or click Ctrl + P to mark the transaction as printed. When data is migrated from a lower release to release 4.8, many of the transactions for which payment advice have already been printed will appear as not printed in release 4.8. This option can be used to mark those transactions as printed.

F12: Configure

To configure the Payment Advice for printing,

Click F12: Configure button or press F12 key from the Print Report of the Payment Advice screen

The Payment Advice Print Configuration screen appears as shown:



Note: The Payment Advice Printing Configuration screen allows the user to enable/disable Printing Company Logo. The Location of Logo set in F11: Accounting Features will be the pre-filled in this screen which can be altered as per requirement.
Set the required options and press Ctrl+A to save the settings

The Print Report screen appears.

Press Ctrl+A or click Accept to Print

The print previews of the selected Payment Advices will be displayed as one payment advice per page as shown below:



To edit the content in Payment Advice such as Salutation, Signature, etc. you can refer to Payment Advice Printing Configuration here.

Cheque Management



Cheques are still the preferred payment instrument across businesses and hence easy management adds significant value in day to day operations. Hence, effective Cheque Management system is essential for any business.

Tally.ERP 9 makes it easy for you to manage your cheques:

Allows creation of multiple Cheque Books with unique ranges for every bank in Bank Ledger creation.

Selection of cheque ranges during Voucher Entry and auto cheque numbering.

Giving a comprehensive report of the status of all the cheques in the form of Cheque Register.

Voucher Entry



Auto Cheque Numbering and Selection of Cheque Books during Bank allocation is supported in all Accounting Vouchers in Tally.ERP 9. To know how to provide Cheque Range for auto cheque numbering, click here.

Payment Voucher is taken to explain these two features used for Cheque Management.

To view the Payment Voucher entry screen:

Go to Gateway of Tally > Accounting Vouchers

Select F5: Payment from the Button Bar or press F5.

Payment voucher can be passed using Single Entry or Double Entry mode by configuring the setting Use Single Entry mode for Pymt/Rcpt/Contra in F12: Configure.



To use Auto Cheque Numbering during Bank Allocation t