Need to import your OCBC bank statements to Xero?

Bank2Xero is made for you

Until mid 2019, there was no bank feed available for OCBC Bank in Singapore, so we came up with this Google Sheets template which makes it super simple and quick. We call it Bank2Xero for OCBC.

Even now while the bank feed is available, many finance teams like to have another way to bring their bank data to Xero, and use Bank2Xero for this.

Bank2Xero for OCBC is the easiest way to import your OCBC bank statement into Xero.

Access bank2Xero for OCBC Bank for free:

Why use Bank2Xero for OCBC?

Our goal was to have a template to convert the csv statement downloaded from the bank to the csv file in the format Xero requires.

We build it for our own needs.
We then released it publicly.
We have seen 1,000s of entrepreneurs and SMEs benefiting from it.

While still manual (don’t get us wrong, we are only wishing for all banks to have direct bank feed to Xero and Bank2Xero not be needed),  it makes the process as fast and painless as possible.

When you use Bank2Xero for OCBC, you can get your bank statements in Xero in just a few minutes (like… 4 minutes).

  1. Download the OCBC csv statement online
  2. Import in the Bank2Xero for OCBC Google Sheet… magic formulas format it the way Xero wants it
  3. Upload to Xero
  4. That’s the number of minutes it takes for the process 🙂

It should take less than 4 minutes to import you bank statement

You bank statement would already be in Xero. Less than 4 minutes.
Things to know
  • You need a Google Account to access the file (It’s a Google Sheet)
  • Only you will have access to your data: You will be invited to make a copy and, as usual with Google Sheets, once you copy, you are the owner and you manage the user rights. It’s your file. You decide whom you share the file with.
  • Bank2Xero is not affiliated with Xero nor with OCBC.
  • The template used to be called OCBC2Xero. The named was changed to Bank2Xero as more banks were added over time.
  • Why not an Excel template? We believe in online software, being collaborative by nature… just a url away. See Epic Sheets on how to make powerful spreadsheets.

Do you need to import another bank to Xero?

Bank2Xero is available for dozens of banks around the world. Find yours now: