Wells Fargo Now Sharing Data with Xero

Last week Xero announced that it had entered into a data sharing agreement with Wells Fargo, one of the top US banks. Xero users will now be able to get bank feeds directly from Wells Fargo into Xero without having to manually export and import files. Xero is the first major technology company to partner with Wells Fargo to help their common customers share data between their two platforms.

Xero recently surpassed more than 700,000 subscribers around the world and North America is their fastest growing market with more than 62,000 subscribers. In the UK, with the addition of Barclays earlier this year, Xero now has five of the top six banks already running direct feeds to Xero giving them coverage for over 90% of UK’s small businesses.

We’ve noticed an increase in the number of enquires about FileMaker and Xero integration from North America over the past 12 months, particularly from customers looking for an alternative to QuickBooks. We can expect more major US banking integrations in the coming months, similar to what we have seen in Australia, New Zealand and the UK.

If you’re looking for a “do it yourself” option for FileMaker Xero integration check out fmAccounting Link (Xero Edition) – it includes examples for authenticating, uploading and downloading Contacts, Invoices, Payments and more. It’s 100% unlocked allowing you to integrate the functionality into your existing FileMaker solution, helping your company save time and money by removing the double data entry between FileMaker and Xero.

This article in Inc. magazine has an interesting perspective on what the Wells Fargo Xero agreement will mean for small business customers in the US.

fmAccounting Link (Xero Edition) Update

We’ve just released an update to fmAccounting Link (Xero Edition) – v1.86. You can read about the changes in the version history notes but here are some of the highlights:

  • added a <Reference> field for Invoices POST calc so you can set the customer reference number
  • updated the uploading of an Invoice to Xero to display any ApiException errors if present (more meaningful error messages)
  • Accounts: added portals to Accounts Form layout showing related Invoice Items, Bill Items and Payments
  • Invoices: added script to GET the Xero online invoice url (the URL that customers can click on the Xero Invoice to make an online payment)
  • Invoices: added script/button to update the status from Xero for the current Invoice. This allows you to periodically check the status of any outstanding invoices from FileMaker to see if they have been paid in Xero, which is particularly helpful when you only record payments in Xero
  • Invoices: added script to GET the Xero Invoice PDF. This lets you download the same PDF that Xero generates to a FileMaker container field, allowing you to file it or email it etc.
  • Invoices: added a Mark as Sent flag for the Invoice and added SentToContact to XeroInvoicePOSTCalc field. If you’re using Xero’s new email reminders feature this is required to let Xero know the Invoice has been sent to the customer

This update is once again free to all existing customers – just download the latest version from the same link from your order email. We’re working on the next round of changes which will include examples for the following Xero API endpoints:

  • Expense Claims
  • Purchase Orders

Databuzz to Exhibit at the 2016 FileMaker Developer Conference

devcon_16_banner_horz_dark

The annual FileMaker Developer Conference (DevCon) is only 50 days away and we’re excited to announce that we will be exhibiting at the conference once again. This year’s DevCon (the 21st) will be held in the same location as last year – Las Vegas, Nevada – from July 18-21, 2016.

The Exhibitor Hall will be in the Gracia Ballroom this year, which is the same location where breakfast and lunch are served. This is the same format from previous DevCons so you can grab lunch then spend some time visiting the exhibitor booths.

We’re looking forward to demonstrating our products to attendees – last year set a new attendance record of 1500 attendees from over 18 countries. This year we will be on-hand to demonstrate the following products:

  • fmSMS: our award winning 2 way SMS solution for FileMaker Pro, FileMaker Go, FileMaker WebDirect and FileMaker Server. fmSMS allows you to send an SMS from FileMaker Pro, FileMaker Go and FileMaker Server to almost any mobile phone in the world, reaching over 800 networks in more than 200 countries. You can get more information about fmSMS from the fmSMS website
  • fmAccounting Link (Xero Edition): our solution that integrates between FileMaker Pro and the Xero Accounting Software. Xero is the market­leading small business cloud accounting software in Australia, New Zealand and the United Kingdom and is making great progress in the United States market. fmAccounting Link (Xero Edition) lets you upload and download Contacts, Invoices, Payments, Bills, Timesheets and more between FileMaker and Xero. You can get more information from the fmAccounting Link (Xero Edition) product page.
  • fmAccounting Link (MYOB AccountRight Edition): our solution that integrates between FileMaker Pro and the MYOB AccountRight Accounting Software (Australia and New Zealand). MYOB AccountRight runs either in the Cloud or on the Desktop, and fmAccounting Link (MYOB AccountRight Edition) allows you to upload Contacts, Invoices, Payments and more at the click of a button. You can get more information from the fmAccounting Link (MYOB AccountRight Edition) product page
  • fmAccounting Link (MYOB Essentials Edition): our latest solution that integrates between FileMaker Pro and the MYOB Essentials Accounting Software, the the easy online accounting software from MYOB (Australia and New Zealand). fmAccounting Link (MYOB Essentials Edition) allows you to upload Contacts, Invoices, Payments and more at the click of a button. You can get more information at the fmAccounting Link (MYOB Essentials Edition) product page

If you’re coming to the conference please stop by and say hello. We’d love to demonstrate how you can send and receive SMS/TXT messages using the FileMaker platform and integrate with Xero and MYOB AccountRight/Essentials.. We hope to see as many of you there as possible and look forward to answering your questions about FileMaker, SMS integration and Xero.

The Benefits of FileMaker Integration with your Accounting Software

integration

The start of a new financial year is a great time to assess how your business has performed over the previous 12 months and start making plans for the next financial year. It’s also a good time to assess your business processes and put in place systems that help streamline the way your business works and contribute to the bottom line in the next fiscal year.

For Australian businesses the new financial year starts in a few weeks (1 July), for New Zealand and the United Kingdom is was on 1 April, for Canada it was 1 January and for the United States it was 1 October.

If you’re planning to make any changes to your accounting software and systems the start of a new financial year is the perfect time to implement these changes. You can use the weeks (and months) leading up to the new financial year to decide on any changes you wish to make, then develop and test these changes during the end of the current financial year before going live at the start of the new financial year. If you can’t wait for the start of a new financial year the start of a new quarter is usually the next best time.

Some of the questions you might wish to consider include:

  • does my Customer Relationship Management (CRM) software “talk” to my accounting software?
  • are my staff doing double data entry of Customers, Invoices, Payments etc in my CRM and my accounting software?
  • if I could eliminate any double data entry would that free up my staff to work on more productive tasks?

The ability to integrate CRM software with Accounting software has become much easier thanks to the rise of APIs. An API is an Application Programming Interface that a company makes available to other software developers – essentially it is a series of instructions for what you need to do to get your software talking to their software. In the small business space accounting software vendors such as Xero, MYOB and Saasu all provide well documented and reliable APIs that you can use to integrate your CRM software with their accounting software.

Having an API allows the accounting software applications to create an ecosystem of “add ons” that extend the functionality of usefulness of the accounting software, for example having transactions from a point of sale system automatically uploaded to the accounting software at the end of the day or being able to accept online payments for an invoice.

If you’re using FileMaker as your CRM application to track your customers, sales, invoices and payments there are a number of advantages of integrating it with your accounting software, including:

  • no more double data entry in FileMaker and the accounting software. Enter the invoice once in FileMaker, click a button and the invoice is pushed to your accounting software in a few seconds
  • less errors between your CRM system and your accounting system. Being able to push invoices, payments etc from your main system to your accounting system means there is less likelihood of data entry errors between the 2 systems
  • free up staff time for more productive work. Rather than having staff spend countless hours each week doing double data entry they can be freed up for more productive (and enjoyable) work, such as following up on sales leads, customer service, marketing etc.
  • it also allows staff to push data to the accounting software without giving them direct access to the accounting software

Having implemented a number of FileMaker/CRM and accounting integrations over the past 3 years we’ve seen the benefits first hand. One customer that processed hundreds of sales every fortnight has now freed up 1-2 hours of time each day for staff that were responsible for the double data entry of invoices. Now they enter the sale once into FileMaker, click a button and a few seconds later get confirmation that the invoice has been uploaded.

We’ve also integrated FileMaker with our accounting software in our business. Before the integration the workflow for processing an online sale was something like this:

  1. customer makes an online purchase from our webstore and a notification is sent us via email with the order details
  2. Databuzz staff manually create a new order in our FileMaker CRM system
  3. Databuzz staff then manually create the same invoice in our accounting software
  4. Once the invoice has been created we then manually add the payment details

Now that we have integrated our FileMaker CRM with our online webstore and our accounting software the process is this:

  1. customer makes an online purchase from our webstore and a notification is sent us via email with the order details
  2. Databuzz staff review the order in our FileMaker CRM which can show webstore orders live, then click a button to push that sale to our CRM and online accounting software, including the Customer, Invoice and Payment details

That saves around 5-10 minutes of data entry time per order – multiple this by tens or hundreds of orders and you can see the time savings add up quickly.

If you would like to discuss integrating your FileMaker solution with either Xero, MYOB AccountRight or MYOB Essentials please contact us for a free initial consultation to discuss your requirements. We also have a number of products which allow you or your in-house/external FileMaker developer to do the integration yourself:

A typical integration usually takes around 4-8 hours – in that time we can have your FileMaker system authenticating with your accounting software, uploading Contacts, Invoices, Payments and more. Imagine how much time and money your business could save by integrating your CRM with your accounting software.

The Hidden New Features of FileMaker v15

When a new version of the FileMaker platform is released I immediately locate the “New Features” list to familiarise myself with the changes in the new version. When v0 was released recently I was a bit surprised when reading the list of new features – only 1 new function, 1 new script step, the new concealed edit box, some important changes to the Script Workspace, a swag of SSL certificate enhancements and a bunch of usability improvements.

These are all great new features – support for iBeacons and Touch ID on FileMaker Go, multiple undo in the Script Workspace/Specify Calculation dialog, being able to delete all records in a table immediately, and support for additional external ODBC data sources are all great additions and will allow developers to create some amazing solutions for our customers. I certainly look forward to using these in the future when a project requires these features – but it didn’t “feel” like there was a lot of new features we could start using immediately on all projects regardless of whether they were deployed using FileMaker Pro, FileMaker Go or FileMaker WebDirect.

Another thing happened shortly after FileMaker v15 was released – I started getting notifications from the FileMaker Community letting me know that product issues that I had previously reported with FileMaker Pro/Go v14 had been fixed in v15 (here’s an example). I’ve been pretty good at reporting product issues as they arise via the official FileMaker Inc site over the years – often all you’ll hear back is that the issue has been confirmed and sent to Development for review, but at least I know that FileMaker Inc. are aware of the issue and it will hopefully be fixed in a future update.

After receiving over half a dozen of these notifications I started to wonder how many bugs were fixed in v15 and if there was a list of these. A quick look at the FileMaker Pro v15 Release Notes showed no list of bugs that were fixed in this release. FileMaker Inc. haven’t released a list of bug fixes for many years unfortunately – I remember back in the 2000’s getting a nice list of bug fixes with each new version of FileMaker Pro that was released. Knowing which bugs have been fixed is important to both developers and customers – we can remove workarounds that we put in place or we can release new features knowing they are now going to work in situations where they didn’t work before.

I then thought I would search the list of Product Issues for ones that had the same update as my notifications, e.g. “This issue has been addressed in FileMaker Pro 15”, “This issue has been addressed in FileMaker Go 15”, etc. A quick search of the FileMaker Product Issues for these patterns found over 150 matching results – a substantial number by any measure and an indication of the effort the FileMaker engineers have put into this new release. Whilst the list of new features isn’t as “meaty” as previous releases it’s great to see soo many bugs being fixed in one release – it would be great if there was an easier way to review these without having to do searches in the FileMaker Community.

Some developers will argue that FileMaker Inc. should have patched previous versions (e.g. v13, v14) as well and not force users to upgrade to get these “bug fixes”, and I have some sympathy with that argument. However you only have to look at the pattern for previous releases to know that FileMaker Inc. are generally going to roll bug fixes into a future version and have been encouraging customers to move to annual licensing so they immediately get any new releases every 12 months, along the lines of a subscription model.

The software industry has been moving towards the “software as a subscription” model for the past few years – looking at my own currently installed suite of software I now have a number of applications that I use on a subscription basis, including:

  • Microsoft Office
  • Adobe applications
  • Xero (online accounting)
  • various WordPress plugins/extensions

and no doubt that list will increase every year. Given the industry trend it’s not surprising to see FileMaker move towards an annual release/licensing model. Personally I would love to see “updates” released to the currently shipping version that fix these bugs (some of them are critical for certain deployments) more frequently, rather than having to wait 12 months for a new annual release. And an easier way to read the list of bug fixes.

I encourage everyone to go and read the list of issues that were addressed in the FileMaker v15 platform – it’s very likely you’ll see fixes to issues that you had encountered but didn’t realise were now fixed.

Databuzz releases fmAccounting Link (MYOB Essentials Edition) – Integrate FileMaker Pro and MYOB Essentials Accounting Software

Sydney, Australia – May 17, 2016 – Databuzz today announced fmAccounting Link (MYOB Essentials Edition), a FileMaker solution that integrates with the MYOB Essentials Accounting Software.

fmAccounting Link (MYOB Essentials Edition) allows you to upload and download data between your FileMaker solution and MYOB Essentials, the easy online accounting that has everything your clients need to take care of business, including payroll. fmAccounting Link (MYOB Essentials Edition) removes double data entry and human errors saving your company significant time, money and hassle by automating the exchange of data between FileMaker and MYOB Essentials.

fmAccounting Link (MYOB Essentials Edition) is completely unlocked allowing you to integrate it into your FileMaker solution. You can copy and paste examples showing you how to authenticate with the MYOB Essentials API and upload Contacts, Invoices, Payments and more at the click of a button.

fmAccounting Link (MYOB Essentials Edition) features include:

  • works with FileMaker Pro v12, v13, v14 and v15
  • completely unlocked
  • can be hosted by FileMaker Pro or FileMaker Server
  • works with Macintosh and Windows

“Many small businesses use FileMaker Pro to track their Contacts and generate Invoices and MYOB Essentials for accounting,” said Andrew Duncan, Director of Databuzz. “You no longer need to do any double data entry in both applications – with fmAccounting Link (MYOB Essentials Edition) you can push and pull data between FileMaker and MYOB Essentials at the click of a button.”

fmAccounting Link (MYOB Essentials Edition) includes examples for the following MYOB Essentials API endpoints:

  • Businesses: select from all available MYOB Essentials Businesses that you have access to
  • Contacts: download and upload Contacts (Customers and Suppliers)
  • Invoices: download and upload Invoices (including Invoice line items)
  • Items (Products): download and upload Items (Products price list)
  • Payments: upload Payments against an Invoice
  • Account Codes: download Account Codes from MYOB Essentials
  • Tax Types: download Tax Types from MYOB Essentials

 Availability, Pricing, and Compatibility

fmAccounting Link is available in a number of licenses: Company, Vertical Solution and Developer. It is available now from the Databuzz website at http://www.databuzz.com.au/fmaccounting-link-myob-essentials-edition/. Workgroup Licenses start at AUD $495.00. fmAccounting Link (MYOB Essentials Edition) requires FileMaker Pro v12, v13, v14 or v15 and a subscription to MYOB Essentials.

Media/Customer Contact:

Andrew Duncan

Phone: +61 418 468 103

sales@databuzz.com.au

About Databuzz: Databuzz is a long standing member of the FileMaker Business Alliance. We have been developing and deploying FileMaker solutions for clients in Australia and internationally since 1999. Our clients are individuals, small-medium businesses, government agencies and multi-national corporations. Databuzz was founded by Andrew Duncan, a Certified FileMaker 14 Developer. For more information please visit our website at http://www.databuzz.com.au.

###

FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries. All other trademarks are the property of their respective owners.

fmSMS and FileMaker Pro v15

We’re pleased to report that fmSMS v3 is compatible with FileMaker Pro/Pro Advanced v15 that was released today. We haven’t encountered any issues so far in our testing and have been able to send single and bulk messages successfully.

If you encounter any issues with fmSMS v3 and FileMaker Pro v15 please let us know.

fmAccounting Link (Xero Edition) and FileMaker Pro v15

We’re pleased to report that fmAccounting Link (Xero Edition) v1 is compatible with FileMaker Pro/Pro Advanced v15 that was released today. We haven’t encountered any issues so far in our testing and have been able to authenticate, download from Xero to FileMaker and upload from FileMaker to Xero successfully.

If you encounter any issues with fmAccounting Link (Xero Edition) v1 and FileMaker Pro v15 please let us know.

fmAccounting Link (MYOB AccountRight Edition) and FileMaker Pro v15

We’re pleased to report that fmAccounting Link (MYOB AccountRight Edition) v1 is compatible with FileMaker Pro/Pro Advanced v15 that was released today. We haven’t encountered any issues so far in our testing and have been able to authenticate, download from AccountRight to FileMaker and upload from FileMaker to AccountRight successfully.

If you encounter any issues with fmAccounting Link (MYOB AccountRight Edition) v1 and FileMaker Pro v15 please let us know.

fmAccounting Link (MYOB Essentials Edition) Preview Video

We’ve just uploaded our first preview video for fmAccounting Link (MYOB Essentials Edition). This video demonstrates the following:

  • authenticating against the MYOB Essentials API
  • downloading a list of available MYOB Essentials Businesses
  • downloading Inventory Items, Tax Types and Chart of Accounts from MYOB Essentials
  • uploading a Contact from FileMaker Pro to MYOB Essentials
  • uploading an Invoice from FileMaker Pro to MYOB Essentials
  • uploading a Payment from FileMaker Pro to MYOB Essentials

You can watch the video below or directly on YouTube via this link.

We should be releasing fmAccounting Link (MYOB Essentials Edition) in the next couple of weeks – please Contact Us if you have any questions in the meantime.