OCBC2Xero: the manual, but easy, way to import OCBC transactions into Xero
** Update Feb 27th, 2016: Now offering templates for more banks thant just OCBC, the file is renamed Bank2Xero **
From making it basically impossible for entrepreneurs to get credit cards to providing online banking services that Champollion would have failed to decipher, Singaporean banks are not known for making their customers’ lives easy*.
Add to this the fact that Xero has not released feed integration for Singaporean banks** and that’s dozens of entrepreneurs and SMEs who have to go through the stress-inducing experience of manually importing transactions.
Luckily, there’s a spreadsheet for that: Bank2Xero:OCBC ***
The instructions work best with Google Chrome, where the drag-and-drop of the OCBC csv exported file to the Google Sheet can be done without leaving the browser window.
I hope import feeds will be available in Xero soon, but in the meantime this template should make the OCBC to Xero import easier for some entrepreneurs.
- * Based on my own experience and the fact that, among the pictures of beaches, food and babies, complaints about Singaporean banks are a recurring theme on my Facebook feed. Although it’s two years old, I believe this e27 article is still pretty accurate: http://e27.co/comparison-of-corporate-banking-in-singapore (the article identifies DBS and OCBC as being the friendliest banks).
- ** I don’t know who’s to blame for this as it seems Xero and Yodlee have been working on the project for months: http://sbr.com.sg/financial-services/commentary/what-singapore-bank-feeds-are-all-about
- *** Spreadsheets are beautiful. Check out MAVA, the Map of Active VCs in Asia.
Credits: photo by B Rosen.