Brought to you by

Welcome Wesabeans

Posted 8 years ago in Product by Adam Moore
Posted by Adam Moore

July 31st is the last day you can export your transactions from Wesabe. Like many others we were saddened to hear they won’t continue. We’d like to try and help out all Wesabeans keep their data, and are trying to make the transition to Xero Personal as easy as possible.

We really appreciate all those who helped us by securely uploading their files to test. Thanks to your efforts we’ve included the ability to import your data from Wesabe in today’s release.

Transactions that you’ve attached tags to in Wesabe will have labels attached in Xero Personal. Whilst your transactions won’t be instantly categorised (but we will try and suggest categories with Xero Personal crowdsourcing data) you’ll still be able to keep your personal data in a secure environment, so it’s worth spending a bit of time categorising to ensure you keep all your valuable information.

Sign up to Xero Personal

We’d love to hear about how you’re finding Xero Personal and let us know how we can help you get started at Xero Answers.

You can view the full instructions for how to upload your Wesabe data into Xero Personal in our Help Centre, but here’s a quick video overview.


July 15, 2010 at 10.09 am

I tested the Wesabe import today and it worked for the most part, but I noticed a couple of problems.

First, the splits set in Wesabe are not being imported as splits, but as alternative labels. A split on a $100 purchase from the grocery store in Wesabe looks similar to this [groceries, cash:20] meaning $20 was for cash and the $80 balance was for groceries. Xero merely imports the entire string of cash:20 as a label so you end up with multiple cash:x labels in your list of labels. It would be great if the import algorithm could parse the split and create a corresponding split in Xero.

The second problem was that the original ‘Bank Name’ field for each transaction wasn’t imported. This is the original name imported into Wesabe before a person readable name is applied to the transaction. It typically looks like this [Point Of Sale Withdrawal / 7-ELEVEN blahblahblah]. I DO NOT want to lose this data as it is an invaluable record. Also, this means that any transactions that I didn’t relabel in Wesabe is imported with the transaction name ‘Unknown’ and is pretty much rendered useless, as I would have no idea where that transaction was originally performed. When I import from a bank OFX file, this data is split between the Original Payee and Reference fields so I am not sure why the Wesabe importer doesn’t properly import it.

Owen Evans
July 15, 2010 at 10.29 am

Hi Paul,
Great to hear that the import managed to get your transactions into Xero Personal.
We realise there are a few things that would be nice to have happen automatically, with splitting and categorisation we have the problem that we don’t have a direct mapping between wesabe tags and categories in Xero Personal and we don’t have a concept of splitting an uncategorised transaction, we’ll certainly be looking for some feedback as to common tags that can be used to map to Xero Personal categories.

As for the original bank import data, this should be coming in as the “Original bank details” in the expanded view of the transaction.
can you make sure that the information isn’t in the popup that comes up when you click on the “more…” link.

Also can you check that the details are in the CSV under the Raw Name column

Many Thanks

K Rouse
July 15, 2010 at 1.05 pm

When exporting transactions from wesabe for a single account the column name in the csv is ‘Bank Name’, not ‘Raw Name’. It is only ‘Raw Name’ when all accounts are in one file.

Changing the title in the single account csv to ‘Raw Name’ enables the upload to work. The original bank details came through as the ‘Payee’ and ‘Original Payee’ in Xero.

July 15, 2010 at 5.03 pm

Yup, K Rouse had it right. I was importing a single account, not a csv with all accounts. Good catch!

My suggestion for the splits is to just add the general/misc category to any split transaction and mark them for review. I’m sure you could also guess at the category based on the tags. I know it could get weird because Wesabe allowed multiple tags for each transaction, so it might be difficult to split, but if you make sure to automatically mark split transactions for review, that might be best.

Sara Goepel
July 16, 2010 at 11.06 am

@Paul & K Rouse- thank you for bringing the single account export issue to our attention as we hadn’t come across it in test files we received. We’re working on a fix and we’ll update you when it’s released.

Catherine Walker in reply to Sara Goepel Xero
July 16, 2010 at 5.01 pm

@Paul & K Rouse – hey, just letting you know we’ve uploaded a fix for the single account export issue – any further problems let us know and thanks again for shouting out. Regards, Catherine

July 19, 2010 at 8.14 am

Is there anything you can do about making splits import properly?

July 20, 2010 at 10.03 am

Is there a plan to open up personal for all NZers?

I don’t bank with BNZ and don’t use Xero business. I’ve been using Wesabe for years, and I’m keen to switch to something good.

Catherine Walker in reply to Dave Xero
July 20, 2010 at 5.13 pm

@Dave, at this stage Xero Personal is only available for NZ users if you already have a Xero account or are a BNZ customer.
Regards, Catherine

Leave a reply

Your email address will not be published. Required fields are marked *