WORK[etc] Web App Blog

Xero & Quickbooks Desktop Updates

05
Feb
Posted by Daniel Barnett Sun, 5 Feb '12 @ 3:29 PM
Our 2012 Roadmap has the public beta release for Quickbooks Desktop and Xero integrations slated as the last week in January. 

UPDATE: New beta invites for XERO accounced.

The bad news is that we're running a few weeks behind, the good news is that we've opted for a whole lot more integration fidelity than originally planned.  And also the extra few weeks have given us more time to better test and de-bug than we'd normally spend.  I know some people have been anxiously waiting for this release, but it is critical we get it right as getting it wrong is potentially catastrophic for a business (!).

This is where it is at...

Xero Integration

The Xero integration provides synchronisation of invoices, payments and contacts.  The synchronisation process is configured within WORKetc and is optionally setup as either one or two way automated process.  In other words, once configured WORKetc will communicate with Xero on a scheduled basis to:
  • Synchronise WORKetc items to Xero
  • Synchronise WORKetc items from Xero
  • Synchronise WORKetc items to and from Xero

The configuration of the integration is straightforward and requires the completion of a streamlined authorisation process to enable WORKetc to communicate with your Xero account.

Xero integration supports invoice mapping of:
  •  An associated sales account
  • Shipping and discount items
  • Tax codes

The integration maintains the high level of granularity provided by WORKetc’s invoicing structure.  For example, a WORKetc invoice synchronised to Xero will have:
  • A separate line item for each WORKetc line item
  • An appropriate tax code if there are applicable taxes for each WORK line item
  • A separate line item for each discount item of each WORK line item
  • A separate line item for each shipping item of each WORK line item
  • Associated line item charges appear sequentially
  • A single line item for invoice level discounts

The contact synchronisation process synchronises, name, address and contact details allowing users to be able to quickly invoice new accounts from either system.

Plugin for QuickBooks Desktop

The WORKetc Plugin for QuickBooks will offer the import of WORKetc invoices and payments from within QuickBooks Desktop.  WORKetc provides a high level of granularity within its invoicing structure including:
  • Support for multiple taxes per line item
  • Line item shipping
  • Item and invoice level discounts

The WORKetc Plugin for QuickBooks maintains this level of granularity for the customer’s convenience and clarity.  For example, if your WORKetc invoice imported using the plugin will produce the following in QuickBooks:
  • A separate line item for each WORKetc line item
  • A separate line item for each tax item of each WORK line item
  • A separate line item for each discount item of each WORK line item
  • A separate line item for each shipping item of each WORK line item
  • Associated line item charges appear sequentially
  • A single line item for invoice level discounts

The plugin has configurable options for mapping shipping, discount and tax to suitable QuickBooks items.  In addition, it also supports mapping of the WORKetc line item types to generalised item types in QuickBooks.  A number of desktop editions of QuickBooks have practical limits on the number of items that can be created and WORKetc has endeavoured to design a plugin that works within these bounds so that all users can take advantage of its features.

So when....?

We are still going to be at minimum 10 days from public beta - possibly longer depending on how long it takes for each product to be properly certified by their respective vendors.  If you've put your hand up for the beta in these previous posts (Xero, Quickbooks) then support will be in touch.


We'll be starting work on Quickbooks Online immediately after and development time for this will be significantly shorter (as we've already resolved all the "gotchas").


And of course permissions, roles, saved views, sales pipeline and custom fields 2.0 are all teetering on the edge of beta as well.


February is shaping up to be a massive month.

16 Comments

  • Earl Rudolfo Monday 6, February 2012 12:46 PM

    That's great news, WORKetc team. Sounds exciting, looking forward to being a part of the public beta. Definitely willing to wait a while longer to make sure it's done right. Thanks for the update.

  • John Monday 6, February 2012 1:47 PM

    Excited about the QBO integration news!

  • Tim Tuesday 7, February 2012 2:10 AM

    Thanks for the update... can't come soon enough. In the middle of manually exporting/importing from WEtc to Xero... ugh.. 2011 year-end summary data, and all of January's transactions.

  • Donna Tuesday 7, February 2012 5:18 AM

    Is there any doc on the QB integration where I can determine if it will handle QB classes and how it might do that.

  • Tim Tuesday 7, February 2012 12:02 PM

    Thanks for the update... can't come soon enough. In the middle of manually exporting/importing from WEtc to Xero... ugh.. 2011 year-end summary data, and all of January's transactions.

  • Tim Thursday 23, February 2012 2:59 PM

    Any update on the Xero integration release?

  • Matthew Friday 24, February 2012 10:31 PM

    Wondering the same, we are anxious to use Worketc.com and Xero, as of yet we have gone from Batchbook, to freshbooks, to sugarcrm, to zohocrm to quickbooks, to hopefully making Worketc.com and Xero our complete solution in time for our launch of http://TastyNow.com.

  • Michael Monday 19, March 2012 7:32 AM

    Any news on the progress of xero integration as of yet?

  • Travis Thursday 29, March 2012 9:38 PM

    ETA?

  • Jeannette Monday 2, April 2012 11:00 PM

    Any news on when the xero integration will be available?

  • Dan @ WORKetc Monday 2, April 2012 11:32 PM

    We're still waiting on certification with Xero.

  • Michael Wednesday 4, April 2012 12:53 AM

    Dan, is it still possible to have beta access to the Xero integration? I would be keen to give it a run...

  • Adi Khanna Tuesday 10, April 2012 9:25 PM

    Any update to QB integration?

  • Dan @ WORKetc Wednesday 11, April 2012 6:45 AM

    Next beta invites are available here:
    http://www.worketc.com/blog/Development/102

    Quickbooks Desktop is turning out to be very difficult - mostly because of the installer requirement. We're still working on it, but reality is Quickbooks Online is probably going to be released before Desktop!

  • Curtis Saturday 14, April 2012 9:56 PM

    That is good news. We use QuickBooks Online! Awesome!

  • Bill Saturday 9, March 2013 4:39 PM

    Did Quickbooks desktop integration ever get released?

Post your comment

New Comment



Product Releases

Big News

Coalface

Archive