To know about the contact details of banks for e-Payments, click here.

Record e-Payment Transactions

Recording an e-Payment transaction is as easy as recording any other payment transaction. All you need to do is to select e-Payment as the mode of payment while recording the payment voucher. You can also make e-payments to your parties or the employees on your company’s payroll using the same simple steps. You must enable the option Export/Upload Payment Instructions on voucher creation in the e-payment configuration screen so that the Exporting Payment Instructions screen appears once the payment voucher is recorded.

1. Record a payment voucher.
   1. Press Alt+G (Go To) > Create Voucher > press F5 (Payment) and press Enter.
      Alternatively, Gateway of Tally > Vouchers> press F5(Payment) > and press Enter.
   2. Debit the party ledger and credit the bank ledger that is configured for e-Payments.
2. Verify the e-Payments details.
   1. In the Bank Allocations screen, select e-Fund Transfer as the Transaction Type.
   2. Enter other details such as A/c No., IFS Code, Bank Name, Inst No., and so on if you have not maintained the beneficiary details in the party master.
      
   3. Press F12 (Configure) and set the option Show Ref ID to Yes if multiple beneficiary details are maintained. 
      The Ref ID column appears in the Bank Allocations screen.
   4. Press Backspace to select the required beneficiary for the transaction.
      
   5. Press Ctrl+A to accept the Bank Allocations screen.
3. Press Ctrl+A to save the payment voucher. 
   The Exporting Payment Instructions screen appears.
   
4. Press C (Configure) to change the configurations or press E (Send) to export the details.
   On successful export, the following message appears.
   

If beneficiary account details (like A/c No., IFS Code, and so on) are not provided in the ledger or during the transaction, or if there is a mismatch in the details, then the transaction will not be exported. You can find the transaction in the e-Payments report under the respective section.

• For DBS, the transactions are directly uploaded to the bank portal, if you are logged in with the Tally.NET User ID that is registered with the bank. You can view the status in the e-Payments report and authorise the same on the bank portal.

• For other banks supported for e-payments, the transactions are exported locally. You can upload the exported transactions by logging in to the bank portal.

Export/Upload Payment Instructions to the Bank

Once your e-payment transactions are recorded, the payment instructions are ready to be uploaded to the bank portal. Before uploading, the e-Payments report in TallyPrime will help you in checking the transactions to ensure that the details are complete and error-free. If there are any errors, then you can drill down to the relevant section and update the details. Once you have cross-checked the details, you can proceed to export and upload the payment instructions to the bank. You also have the option to provide additional security for your payment instructions by encrypting the exported files. This encryption is valid for ICICI Bank, Standard Chartered Bank (India), Citi Bank and Bank of Baroda.

Note: For ICICI Bank: Encryption is mandatory to upload the exported files to the bank portal. The encryption tool has to be taken from your ICICI Bank RM. If you want to encrypt the files directly in TallyPrime, use the tool ICICI_WEH128. To encrypt the file outside TallyPrime, use ICICI_AES128_Encryptor.
For Citibank: Since the encryption tool is external which the customer has to procure, please contact your Citibank RM with this regard.
You can upload either a single transaction or multiple transactions at the same time. Single transactions can be uploaded directly during voucher entry, as shown in the e-Payment Transactions section.

Once the transactions are processed from the bank, you can download the intermediate file to update the status of the completed transactions. This is supported by Kotak Bank, ICICI Bank, Standard Chartered Bank, HDFC Bank, Bank of Baroda, Axis Bank, RazorpayX and AU Small Finance Bank.

To export payment instructions for multiple payments.

1. Press Alt+G (Go To) > type or select e-Payments > press Enter.
   Alternatively, Gateway of Tally > Banking > e-Payments.
2. Select the required bank column for the Ready for Sending to Bank section, and press Enter.
   The e-Payments screen for the selected bank appears, as shown below:
   
3. Select the transactions that you want to export, and press Alt+E (Export) > Payment Instructions.
   The Exporting Payment Instructions screen appears as shown below:
   
4. Press C (Configure) to change the configurations or press E (Send) to export the details.

You can now log in to your bank portal to upload the exported output file from your local system.

e-Payments Report

The e-Payments report in TallyPrime provide you with a clear picture of all your e-payment transactions. You can view and track the status of your e-payment transactions, and identify any incomplete information or mismatch in beneficiary details. You can view the e-payments that are sent (or ready to be sent) to the bank. You can also view the bank balance as per the company’s books and compare it with the balance as per the bank.

In the case of DBS (India), you can open the bank portal directly from the e-Payments report.

In this section

• View e-Payments Report
• Transactions recorded with incomplete bank details
• Transactions with Mismatch in Bank Details (with Master)
• Transactions Sent to Bank (Unreconciled)
• Bank balance as per company books

View e-Payments Report

The default view of the e-Payment report displays the list of errors for which the payment instruction is not generated along with the count of transactions and the amount. If you have transactions in multiple bank ledgers then all the bank ledgers are shown in multiple columns together with the transaction count and amount. Apart from the error list, you can also see the list of transactions that were sent to the bank but it is not yet reconciled and also the list of transactions that are ready to be sent to the bank.

• Press Alt+G (Go To) > type or select e-Payments > press Enter.
  Alternatively, Gateway of Tally > Banking > e-Payments > press Enter.
  

The transactions displayed in the report include vendor payments or payroll payments, or both, according to your business type. You can include or exclude the payroll transactions by pressing F8 (Exclude Payroll).

If you have already sent the list of transactions to the bank, then you can include exported or processed transactions by pressing Ctrl+B (Basis of Values) > enable Include Exported/Processed transactions.

Transactions recorded with incomplete bank details

The Transactions with Incomplete Bank Details section displays transactions in which certain mandatory bank details (such as A/c No. and IFS Code) were not specified for e-Fund Transfer. You can select the transaction and provide the required information and then the transactions will be ready to be sent to the bank. You can also choose to add the same details to the party master.

1. Press Alt+G (Go To) > type or select e-Payments > press Enter.
   Alternatively, Gateway of Tally > Banking > e-Payments > press Enter.
2. Drill down from the required bank column for the Transactions with Incomplete Bank Details section, as shown below:
   
3. Press Alt+H (Exclude) to exclude the transaction or press Enter to view the Bank Details screen.
   
4. Provide the missing information, or press Alt+S (Copy Master Info.) to copy the bank details from the master to the voucher.

While saving the details, you can do one of the following:

• Press A to accept the transaction with the information you entered.
• Press R to replace the master details with the bank details specified in the voucher. The R: Replace button appears if bank details have been specified in the master.
• Press D to accept the transaction and also update your master ledger. This option will not appear while you are copying the details from the master.
• Press B to make any changes in the Bank Details (Voucher) section.

Once the details are updated the transaction moves to the Ready for sending to bank section.

Transactions with Mismatch in Bank Details (with Masters)

When the bank details specified in a transaction do not match with the bank details specified in the party master, the transaction will be listed under Transactions with Mismatch in Bank Details (with Masters) in the e-Payments report. You can copy the information from the master to the voucher directly from the e-Payments report. You can accept the details in the master or press Alt+J (Accept as is) to accept the modified bank details. 

1. Press Alt+G (Go To) > type or select e-Payments > press Enter.
   Alternatively, Gateway of Tally > Banking > e-Payments > press Enter.
2. Drill down from the required bank column for the Transactions with Mismatch in Bank Details (with Masters) section. The following screen appears:
   
3. Press Alt+H (Exclude) to exclude the transaction, press Alt+J (Accept as is) or press Enter to view the Bank Details screen.
   
4. Press Alt+S (Copy Master Info.) to copy the bank details from the master to the voucher.
5. Press Enter to accept the bank details as per the master. This will ensure that the bank details are the same as the bank details entered in the bank ledger master.

Once completed, the selected transaction moves to the Ready for sending to bank section.

Transactions Sent to Bank (Unreconciled)

The e-Payments report also displays transactions that have been already sent to the bank, but are yet to be reconciled, under the Transactions Sent to Bank (Unreconciled) section. You can check the status of the transactions and import the intermediate/reverse file to update the status. In the case of DBS, press Alt+R (Update Status) to refresh the status.

1. Press Alt+G (Go To) > type or select e-Payments > press Enter.
   Alternatively, Gateway of Tally > Banking > e-Payments > press Enter.
2. Drill down from the required bank column for the Transactions Sent to Bank (Unreconciled) section.
3. Press Enter. The e-Payments screen for the bank appears with the status of each of the transactions, as shown below:
   
4. Press F5 (Refresh) to view the updated status of the transactions.

Re-export transactions to bank | Reset Status

The Transactions Sent to Bank (Unreconciled) section also provides you with the option to reset the status of your exported transactions and reconsider them for e-payments. For instance, you might have exported the transaction already, but the file is lost or damaged. In such cases, you can reset the status of the transaction and re-export it to the bank portal. You only have to select the transaction and press Alt+S (Reset Status). The transaction will be reconsidered for e-payments and included in the relevant section.

For DBS transactions, one of the following statuses may appear:

• Submitted – When transactions are sent to the bank.
• Verifying – When transactions are under verification by the bank.
• Authorisation pending – When transactions have been accepted by the bank and are available for authorisation on the bank portal.
• Authorised – When transactions are authorised on the bank portal.
• Processed – When transactions are processed by the bank.
• Failed – When transactions have failed due to incorrect sender A/c no., invalid IFS code, unregistered TSS ID with the bank, and so on.

Bank Balance as per Company Books

In the e-Payments report, the Bank Balance as per Company Books section reflects the balance as of the last date.

• Press Alt+G (Go To) > type or select e-Payments > press Enter.
  Alternatively, Gateway of Tally > Banking > e-Payments > press Enter.
• Drill down from Bank Balance as per Company Books to view all your unreconciled vouchers in one place.
  

You can view the transactions that were excluded from the e-payment process, by pressing Alt+H (Show Included). If you want to include the transaction in the e-payment process, then select the transaction and press Alt+S (Reset Status). The transaction will be considered for e-payments and included in the relevant section.

e-Payment Reconciliation

Reconciliation of e-payments is necessary to detect any differences between the bank balance as per the company’s books and the bank balance as per the statement supplied by the bank for e-payments. 

TallyPrime is here to simplify reconciliation for you. You only have to import the intermediate file in TallyPrime, and, based on the status in the file, TallyPrime will reconcile your e-payment transactions. You can find further details of reconciliation in the e-Payments report <hyperlink to e-Payments report>

1. Open e-Payment report.
   • Press Alt+G (Go To) > type or select e-Payments > press Enter.
     Alternatively, Gateway of Tally > Banking > e-Payments > press Enter.
2. Drill down from the Transactions Sent to Bank (Unreconciled) section.
3. Import Intermediate File.
   1. Press Alt+O (Import) > Intermediate File.
      The Import Intermediate File screen appears.
      
   2. Select the File Path and File to Import (Delimited), and press Enter.
      
      The following success message will appear after the file is imported. These transactions will be reconciled with the updated Bank Date and Inst No.
      

Refer to the Bank Reconciliation article to know more about Bank Reconciliation in general.

Security for e-Payments

You can provide additional security for your banking details and e-payments by creating users with special rights and authorising them for specific operations. You can use the Security Control feature to set up the required security levels. For example, if you want your data entry operator to have access only for e-Payments related reports, then you can allow full access or access to alter for the List of Reports related to e-Payments.

1. Press Alt+K (Company) > User Roles.
2. Select the security level (for example, Data Entry) from the List of Security Levels, and press Enter.
   • Under Allow the following Facilities, select from the List of Reports as e-Payments.
     
3. Accept the security settings. As always, you can press Ctrl+A to save the screen.

Refer to the Manage Users article for more information on Security Control.