Zoho Books -  HSBC Integration

Zoho Books has partnered with HSBC to enable you to perform banking functions from within Zoho Books. With this integration, you can check your live account balance, initiate bill payments, fetch bank feeds automatically and do more. It brings banking and accounting to one platform.

Benefits

Note: This integration is available only for users in the India edition of Zoho Books created under the zoho.in domain.

Watch this video to learn how the integration works.


Set up the HSBC Integration

To set up the HSBC integration in Zoho Books:

Set up HSBC Integration

The link will open in a new tab where you can enter your organisation and contact details. The HSBC team will get in touch with you and help you create a new HSBC account (if you don’t have one already), or help you get the required credentials for your existing account.

HSBC Setup Credentials
Field Description
Profile ID The HSBC team would have sent you the Profile ID via email. 
Client ID The HSBC team would have sent you this Client ID via email.
Client Secret The HSBC team would have sent you this Client Secret via email.
HSBC Public Key The HSBC team would have shared this file with you via email and you will have to upload it. This field will only support formats such as pem, crt, txt, doc, and docx.
HSBC Bank Account You can select one of the bank accounts that was created in the Banking module, or add a new bank account and select it.  
Secret PIN Set a secure PIN that you will remember as you will use it to initiate payments in Zoho Books.
Configure HSBC Integration

Zoho Books and HSBC bank will be integrated.

Note: This integration is a user-level integration, that means that other admins or users will not be able to initiate payments on your behalf.

Add Bank Account for Bank Feeds

Next, you can add your bank account to fetch the bank feeds into Zoho Books automatically. To add:

Add Bank Account Add Bank Account Details

The connection between the bank account and Zoho Books will be established and the bank feeds will be fetched into Zoho Books from the date you’ve mentioned.

Check Your Live Account Balance

Once you’ve added your HSBC bank account, you will be able to check your live account balance from the Banking module whenever you need. To check:

View Live Account Balance

Refresh Bank Feeds

When you want to fetch the latest feeds from your bank account into Zoho Books, you can refresh the bank feeds.

Refresh HSBC Bank Feeds

The fetching of bank feeds will be initiated in the back end and you can continue using Zoho Books. The latest bank feeds will be available shortly.

Insight: In general, Zoho Books fetches the bank feeds automatically once every 24 hours.

Learn about categorising and matching transactions, adding transactions, creating transaction rules and more from the Banking module using your bank account.

Make Payments to Vendors

1. Add Vendor’s Bank Account Details

The first step in making payments towards a vendor is adding the vendor’s bank account details to the contact. To add vendor’s bank account details:

Add Bank Account Details Adding vendor's bank account

2. Initiate Payments

Once you’ve added your vendor’s bank account details, you can initiate payments from Zoho Books in three ways:

Pay Individual Bills

You can initiate a payment via HSBC for a bill in Zoho Books. To initiate payment:

Pay via HSBC button
Fields Description
Balance Due The total sum of the money due for payment for a particular bill.
Amount Enter the amount you would like to pay. You can make a complete or a partial payment towards the bill.
From Account Select the From Account from the list of HSBC bank accounts from which you can initiate a payment.
To Account Select the account to which you would like to make the payment.
Transaction Type Select the Transaction Type from the available fund transfer options. The modes of fund transfer available are NEFT and RTGS.
Paying via HSBC

Warning: If you enter the Secret PIN incorrectly multiple times, the HSBC integration will be deactivated. You will have to disable the integration and set up the integration again to initiate payments via HSBC.

Enter Secret PIN

The payment will be initiated from within Zoho Books and you will have to authorise the payment from the HSBCnet.

Pay Multiple Bills

There are two ways by which you can initiate payments towards multiple bills:

  1. Pay multiple bills of the same vendor
  2. Pay multiple bills of different vendors

Pay multiple bills of the same vendor

New Vendor Payment button Paying multiple bills via HSBC Enter Secret PIN

Warning: If you enter the Secret PIN incorrectly multiple times, the HSBC integration will be deactivated. You will have to disable the integration and set up the integration again to initiate payments via HSBC.

The payment will be initiated and you will have to authorise the payment from the HSBCnet.

Pay multiple bills of different vendors

Pay via HSBC Multiple Bills and Multiple Vendors Enter Secret PIN

Warning: If you enter the Secret PIN incorrectly multiple times, the HSBC integration will be deactivated. You will have to disable the integration and set up the integration again to initiate payments via HSBC.

The payment will be initiated and you will have to authorise the payment from the HSBCnet.

Pay Vendors in Advance

You can make advance payments to vendors directly. To initiate an advance vendor payment:

New Vendor Payment button Making Vendor Advance Payment via HSBC Enter Secret PIN

Warning: If you enter the Secret PIN incorrectly multiple times, the HSBC integration will be deactivated. You will have to disable the integration and set up the integration again to initiate payments via HSBC.

The payment will be initiated and you will have to authorise the payment from the HSBCnet.

3. Authorise Payment in HSBCnet

If you had initiated a NEFT or RTGS payment from within Zoho Books, you will have to authorise that payment using File Level Authorisation (FLA). In FLA, you will have to authorise or reject a file which may contain one or multiple payments.

To authorise the payment from HSBCnet:

File Authorisation in HSBCnet Review Files Authorise or Reject file

Once you authorise the file, you’ll see a confirmation screen with the payment status and the details. This payment may be sent for further authorisations based on the authorisation structure that is configured at HSBCnet for the account. Once the payment is made successfully, the corresponding bill’s status in Zoho Books will be updated to Paid automatically.

Make Cross-Border Payments to Vendors

You can pay your vendors who are overseas using the Zoho Books-HSBC integration. The first step in making payments towards a vendor is adding their bank account details to their contact in Zoho Books.

Note: Cross-border payments is only supported for the following currencies: HKD, INR, AED, AUD, BHD, CAD, CHF, CNY, CZK, DKK, JPY, KWD, LKR, NOK, NZD, OMR, PHP, PLN, QAR, RUB, SAR, SEK, SGD, THB, TRY, USD, EUR, GBP, and ZAR.

Note: This feature is currently available on early access only. If you would like to access this feature, send an email to support.india@zohobooks.com.

Add Vendor’s Bank Account Details

To add a vendor’s bank account details:

Add Details

Note: You need to ensure while creating a vendor that the currency you choose is a foreign currency to make cross-border payments.

Next, you need to create a bill for this vendor for whom you wish to make the cross-border payment.

Once you’ve added your vendor’s bank account details and have created a bill for them, you can initiate payments for that particular bill.

Initiate Cross-Border Payments

You can initiate cross-border payments in Zoho Books in three ways:

Pay Individual Bills

You can initiate a cross-border payment via HSBC for an individual bill in Zoho Books. Here’s how:

Individual Bills
Fields Description
Balance Due The sum total of the money due for payment for a particular bill.
Payment Amount Enter the amount you would like to pay. You can make a complete or a partial payment towards the bill.
From Account Select the From Account from the list of HSBC bank accounts from which the amount will be deducted.
To Account Select the bank account to which you would like to make the payment.
Transaction Type XACH will be selected as the default transaction type.
Individual Bills Individual Bills

Warning: If you enter the Secret PIN incorrectly multiple times, the HSBC integration will be deactivated. You will have to disable the integration and setup the integration again to initiate payments via HSBC.

The payment will be initiated from within Zoho Books and you will have to authorise the payment from the HSBCnet.

Insight: During the time of the actual payment after authorisation, you might come across a difference in amount due to varying exchange rates.The difference in amount due to varying exchange rates can be recorded as a transaction in Zoho Books while reconciling the accounts in the Banking module.

Pay Multiple Bills

There are two ways by which you can initiate cross-border payments towards multiple bills:

Pay multiple bills of the same vendor

You can pay multiple bills of the same vendor provided that they all have the same foreign currency.

Multiple Bills Multiple Bills

Warning: If you enter the Secret PIN incorrectly multiple times, the HSBC integration will be deactivated. You will have to disable the integration and setup the integration again to initiate payments via HSBC.

The payment will be initiated from within Zoho Books and you will have to authorise the payment from the HSBCnet.

Insight: During the time of the actual payment after authorisation, you might come across a difference in amount due to varying exchange rates.The difference in amount due to varying exchange rates can be recorded as a transaction in Zoho Books while reconciling the accounts in the Banking module.

Pay multiple bills of different vendors

You can pay multiple bills of different vendors provided that they all have the same foreign currency.

Multiple Bills Multiple Bills

Enter the Secret PIN that you had configured while setting up the integration and click Initiate Payment.

Multiple Bills

Warning: If you enter the Secret PIN incorrectly multiple times, the HSBC integration will be deactivated. You will have to disable the integration and setup the integration again to initiate payments via HSBC.

The payment will be initiated from within Zoho Books and you will have to authorise the payment from the HSBCnet.

Insight: During the time of the actual payment after authorisation, you might come across a difference in amount due to varying exchange rates.The difference in amount due to varying exchange rates can be recorded as a transaction in Zoho Books while reconciling the accounts in the Banking module.

Pay Vendors in Advance

You can make advance cross-border payments to vendors directly. Here’s how:

Vendor Advance

Enter the Secret PIN that you had configured while setting up the integration and click Initiate Payment.

Vendor Advance

Warning: If you enter the Secret PIN incorrectly multiple times, the HSBC integration will be deactivated. You will have to disable the integration and setup the integration again to initiate payments via HSBC.

The payment will be initiated from within Zoho Books and you will have to authorise the payment from the HSBCnet.

Insight: During the time of the actual payment after authorisation, you might come across a difference in amount due to varying exchange rates.The difference in amount due to varying exchange rates can be recorded as a transaction in Zoho Books while reconciling the accounts in the Banking module.

Authorise Cross-Border Payment in HSBCnet

If you had initiated a XACH payment from within Zoho Books, you will have to authorise that payment in HSBCnet.

To authorise the payment from HSBCnet:

Authorisation Authorisation

This payment may be sent for further authorisations based on the authorisation structure that is configured at HSBCnet for the account. Once the payment is made successfully, the corresponding bill’s status in Zoho Books will be updated to Paid automatically.

Make GST Payments

  You can initiate payments towards your GST returns directly from Zoho Books. To initiate GST payments:

GSTR-3B Summary Pay GSTR-3B via HSBC

OR

Initiate payments from GST Payments Making GST payment Enter Secret PIN

Warning: If you enter the Secret PIN incorrectly multiple times, the HSBC integration will be deactivated. You will have to disable the integration and set up the integration again to initiate payments via HSBC.

The payment will be initiated from Zoho Books and the status of the transaction will be In-progress. Once you authorise the payment at HSBCnet, the payment status will be updated in Zoho Books automatically.

Update HSBC Public Key

When your public key expires, HSBC will send a new public key to your email address. You should upload the new key in Zoho Books to continue using the integration. Here’s how:

Edit Public Key Proceed to Save Save Public Key

Your public key will now be updated, and you can continue using the integration.

Disable the Integration

If you don’t want your Zoho Books account to be connected with HSBC, you can disable the integration.

Note: Disabling the integration will only remove the integration at Zoho Books’ end and you can set up the HSBC integration using the same HSBC credentials.

To disable:

HSBC Disable button Disabling HSBC Integration

Note: If you have any queries regarding the HSBC bank integration, write to us at hsbc-support@zohofinance.com.


Was this document helpful?
Yes
No
Thank you for your feedback!
Want a feature?
Suggest
Switch to smart accounting software. Switch to Zoho Books.   Start my free 14-day trial Explore Demo Account

Books

Simplify accounting
and GST filing.