Showing posts with label Custom reports for Xero. Show all posts
Showing posts with label Custom reports for Xero. Show all posts

Friday, August 19, 2016

The best cloud accounting solution for small businesses!

Nowadays, having a reliable IT system in place is imperative for an efficient business workflow. As cloud experts, we've found early on that cloud computing is an integral part of having your IT system work for you, and not the other way around. Cloud email, cloud collaboration, cloud storage, and even cloud accounting are what make up a powerful, productive, and efficient IT system.

Although our founder has a deep passion for wielding cloud technology, by trade he is a Chartered Professional Accountant and a Certified Management Accountant. Both technology and accounting overlap in our world and we're often asked this question; what is the best cloud accounting solution for small and medium sized businesses?

The quickest answer; Xero.

As cloud strategists, we find accessibility is key when it comes to data and management. Xero, along with other cloud solutions, is built around the idea of accessibility. Cloud technologies enable everything to work faster and more efficiently. Even large banks and financial institutions are starting to use cloud storage for their data storage needs over their traditional data centers. With cloud accounting software like Xero, small businesses can do everything, including easy invoicing, inventory, multi-currency reconciling, source document attachment, purchase orders, cash-flow management, and much more. The ability to have these features fully accessible, from virtually anywhere, is a huge plus for small and medium sized businesses. Learn more about Xero features here: https://www.xero.com/ca/accounting-software/

Xero has been at the forefront of cloud accounting for a very long time. It's one of the easiest online accounting systems and offers great convenience for its users without compromising on key features that are normally found in legacy accounting software. It has become one of the fastest growing cloud accounting companies in the world, with a subscriber base of over 700,000, contributing a total life-time value of $1.5 billion. Their success is due to their loyal small business customers across 180 countries. Xero intelligently takes advantage of cloud technology which allows them to innovate faster than ever before and pushes them into new geographies.

There's no doubt that Xero is well on it's way to hitting the billion dollar annual revenue mark with it's rapid growth, making it a top choice for those looking for the perfect cloud accounting solution. Interlock IT is a Certified Xero Partner and a Certified Xero Development Partner. We'll make your transition to Xero painless and can even assist you with custom Xero reports and integrations. Give us a call and let us know what you're looking to do with Xero. We're more than happy to assist! We'll even provide a free Xero trial account; just fill out our contact us form and mention this post in the comments.

If you've adopted Google Apps for Work, we've created Blink Reports for Xero. Blink Reports is the only Google Sheets add-on that allows Xero customers to build financial reports, charts, and virtual dashboards connected to your live Xero data. Contact us today to discuss with us your cloud accounting needs!

Wednesday, January 13, 2016

Xero integrates Google mail - A Potent Mix

If you are a small-medium business owner, it's often difficult to get a clear picture of where you stand with a particular customer. Our favourite tool to keep track of this is Xero. With over half a million global subscribers and counting, Xero provides online accounting, bank reconciliation, invoicing services, and integrates with a wide range of powerful software solutions and add-ons. Now, with the integration of Google's Gmail, it's more powerful than ever.

Just before the end of 2015 Xero pushed their final major update of the year: Contacts were updated and Google's Gmail service was integrated into the contacts screens. Essentially, this gives Xero users complete visibility of the business they've done with their customers or suppliers, making it much easier to make decisions and develop opportunities. This vital update makes Contacts a hub for customer communication and demonstrates how cloud accounting has opened the doors of opportunity for innovation and efficiency.

Features in this update enable you to:
  • Connect your Gmail account to view emails with contacts directly in Xero. This saves emails to a contacts activity tab, adds email to a new invoice, quote, or bill, and allows you to download attachments to the contact record.
  • View emails between you and your customers in real time.
  • View emails from the email account that you've connected to Xero while they remain invisible to other users in your organization.
  • Share an email with other users in your organization by simply adding it to the contact's activity tab
You can see here email messages have been pulled from Blair's account using the contact's email address or emails including the words "GotoMeeting.com"
Connecting Xero to your Google account is simple, here's how:
  1. From the Contacts menu, select All Contacts.
  2. Select a contact.
  3. Under the bar graph, click Email, then click Connect to Gmail.
  4. Sign in to your Google account.
  5. On the permissions screen, select Allow.
You can find further details on Xero's Business Help Centre page and Xero's blog.

If you're already using Google apps and are looking for a great accounting solution to bridge the gap between you and your customers, Xero with Gmail is a robust and ideal solution. We at InterlockIT are proud Xero and Google Apps advocates and are more than happy to help make your business's IT solutions a breeze. Be sure to contact us to learn how we can assist you.

Friday, February 17, 2012

Custom reports for Freshbooks, Xero, and Norada Solve360

We've been building custom reports for Norada Solve360 CRM in Google Spreadsheets for a while and realized that since Freshbooks has a published open API we could do the same for Freshbooks customers.

In our case we wanted to know billings/revenue by employee.  The default Freshbooks report lumps the full invoice amount under who created the invoice not who generated the billable time entry.

Our custom report directly grabs the invoice line items via the Freshbooks API so updating the report with the latest data is as simple as clicking the menu option "Refresh Invoices".

Freshbooks Billings by Staff/Employee

Since it is programmed in Google Apps Script inside Google Spreadsheets sharing the report is a snap and you can use the invoice line item data to populate pivot table reports.  Pivot Tables in Google Spreadsheets allow you to slice the data any way you choose for billings by week, by task, by rate, etc.

All the Javascript like code runs on the Google infrastructure so there is zero software to install or manage and zero recurring costs.

Contact us at Interlockit.com if you'd like to purchase your own copy of this report or have us build a different report specific to your needs for Freshbooks, Xero, or Norada Solve360.