Use Google Finance to convert currencies for you

Google Sheets is able to leverage many Google services, like Google Translate and Google Finance, to make your job easier.

Google Finance ties into Google Sheets with the helpful function =GoogleFinance(). You can use this to quickly and easily convert currencies in your Blink Reports for Xero spreadsheet.

For example, say a business operates in the EU, and thus in Euros, but you want to report your financials in US dollars. Wouldn't it be easier to have a cell in your spreadsheet that tells you the exchange rate at a glance?

In our case, we've simply entered the =GoogleFinance() function in the report parameters, so that we can now both call it in other sheets and reference it at a glance. It's best if this goes on the Report Parameters sheet so that there's no chance of it being overwritten by data coming in from Xero via Blink Reports.

In a blank cell, use the following function to automatically grab up-to-date exchange rates from Google Finance:

=GoogleFinance("CURRENCY:<SourceCurrencySymbol><ToCurrencySymbol>")

So if you want the Euros to US dollars exchange rate, the formula would read:

=GoogleFinance("CURRENCY:EURUSD")

The formula works with a number of common ISO 4217 currency codes, so most major currencies will be easily converted all from within your spreadsheet.

Multi-company financial consolidations and consolidated dashboards are now available!

The team at Interlockit.com is thrilled to announce that Blink Reports can now connect one spreadsheet to multiple Xero organizations, making the creation and publishing of multi-company financial consolidations and consolidated dashboards a breeze!

Thanks to valuable feedback from our users we've also freshened the user interface. For example, we've used the conditional formatting feature of Google Spreadsheets to dynamically apply shading to lines such as Total Income or Net Profit, so that you can see at a glance what's most important. You can see screenshots of the improvements on our Blink Reports overview page.

Some of our behind-the-scenes work has made authorizing against Xero organizations simpler and provides more informative error messages.

If you'd like to check out our new multi-company functionality please sign up for a free trial!

Blink Reports Partner Highlight: Catching Clouds

We'd like to thank Catching Clouds for their insight into the needs of Xero focused accounting firms plus their knowledge of existing Xero Reporting Add-ons!

They are definitely a partner you should talk to if you are an ecommerce seller with any U.S. operations.

For more information, please check out their website:  www.catchingclouds.net

"At Catching Clouds LLC, we specialize in helping multi-channel ecommerce sellers grow their businesses by providing them with current, accurate, and actionable financial information about their businesses.

We provide virtual controller and bookkeeper services combined with the accounting cloud tools, design, and management necessary to be our customers' complete accounting department. By outsourcing their accounting needs, including sales tax, bill payment, payroll, inventory, and expense management, our customers have the time to focus of developing the heart and soul of their businesses. 

We work with Amazon and Amazon FBA sellers, eBay, Shopify, BigCommerce and many other platforms. Our customers sell on multiple marketplaces and shopping carts, and we are their Ecommerce Accountant who handles all of the accounting functions for their ecommerce business."

Blink Reports for Xero – The Official Release!

The power of…

Google Spreadsheets + Xero Accounting

Blink Reports is a powerful Google Spreadsheets Add-on that allows you to take control of your Xero data to build financial reports, charts, and dashboards with a series of simple formulas. The best part? It's all connected live!  No more exporting of static reports that become quickly out of date.

Leverage all the flexibility and security, plus easy sharing and collaboration of Google Spreadsheets for your Xero reporting needs.

We're always happy to hear feedback from people like you and the platform is constantly improving. You can reach us any time at feedback@blinkreports.com.

Check it out today at www.blinkreports.com!