You are here: Home » SAAS » Xero: good progress on bank reconciliation in multi-currency

Xero: good progress on bank reconciliation in multi-currency

by Dennis Howlett on September 9, 2009

One of the toughest nuts for any software provider to successfully crack is multi-currency handling. I know for instance that FreeAgent has been noodling around this topic for ages and the folks are still doing a certain amount of head scratching. Xero has come up with a solution that looks elegant yet maintains the notions of simplicity that have driven its design from the get go.

I asked whether it would automagically handle billings in one currency, payments in another AND the all important reconciliation. The solution isn’t 100% there but it is pretty close. This is what Hamish Edwards told me in an email enquiry:

“With the new bank reconciliation functionality released today,  Xero handles the following scenarios:
1.      NZ Company, NZD base currency, GBP Bank Account, GBP Invoice and GBP Payment
From the bank reconciliation (for the GBP Bank Account), select Find & Match and apply GBP payment to GBP Invoice
2.      NZ Company, NZD base currency, GBP Bank Account, NZD Invoice and GBP Payment
From the bank reconciliation (for the GBP Bank Account), select Find & Match (un tick show GBP Items only) apply GBP Payment to NZD Invoice, Xero will automatically derive the exchange rate
3.      NZ Company, NZD base currency, GBP Bank Account, USD Invoice and GBP Payment
Currently you will need to perform two steps for this scenario:
·        Setup a USD Bank Account (may be call it a clearing account), pay the USD Invoice in USD from the ‘USD Bank Clearing Account’, by completing the payment blue bar of the invoice Awaiting Payment.
·        From the USD Bank Clearing Account, select Transfer, enter the GBP Account for ‘To Account’ enter the USD Amount and GBP Amount and Xero will derive the exchange rates.  You will then be able to reconcile the GBP Amount received against the Transfer using Find & Match. If there is demand we may accommodate scenario 3 fully from the bank reconciliation in a future release.”

I don’t know whether to see this as a concern or not but as of 28th September, Xero plans to charge an extra $10/month for the multi-currency component. It is inevitable that as a service develops at least some additional services will demand a cost increment. I’m just not sure whether this is something a customer would feel comfortable paying. My guess is that removal of the inevitable aggravation of trying to sort out currency conversions alone would be enough to say ‘yes’ but I’m also guessing that some will gripe. It’s inevitable. Even so, it sends a signal to the market about what constitutes value.

GD Star Rating
loading...
GD Star Rating
loading...
  • Share/Bookmark
  • Does anyone know if Xero support setting local prices in foreign currency?

    As an international wholesaler we prefer to fix local wholesale prices and RRP's - rather than have our prices change hourly/ daily.

    A store in the US that wanted to maintain e.g. a 50% margin would have to adjust their retail prices for every shipment if our prices changed continually.
  • Personally, I am very pleased that MC in Xero is a "swtich-on" feature. Xero should provide the stuff that all businesses want by default and hide away the stuff than only a subset of customers want (arguments about how large or small this subset is are irrelevant). Keeps the UI clean for the majority.
  • Dennis - the announcement of the tiered pricing was made nearly three months ago - http://www.cloudave.com/link/xero-releases-mult...

    My thoughts: Multi currency, to the level Xero does it, is something not all businesses need. It's an edge module and, as such, it makes sense to have it as an optional extra....
  • @Andrew: now you're being sarcastic.

    @Ben: the reconciliation thing is new and as I recall the cost increment was supposed to start 1st Aug. I don't know whether many/few will want this. I do know that m/c handling is something I always ask about in evals. It's something that gets called regularly on FreeAgent. Most of the people I know deal in at least two currencies and sometimes three. It's one of the few thriving areas for the UK banking system. I s'ppose it depends on your perspective as to whether it is 'edge' or not.
  • krupo
    I'm still trying to figure out whether what I see in your post makes SAP's currency handling look crazy or super-simple in comparison.

    Well from a "test automated controls" perspective, SAP's functionality is super fun to audit actually.... (how often do you hear "SAP's functionality" and "super fun to audit" in the same sentence?).
blog comments powered by Disqus

Previous post:

Next post: