{"id":4081,"date":"2018-12-13T15:00:52","date_gmt":"2018-12-13T14:00:52","guid":{"rendered":"https:\/\/beebole.com\/blog\/?p=4081"},"modified":"2025-04-11T13:50:27","modified_gmt":"2025-04-11T11:50:27","slug":"timesheet-integration-xero-office365","status":"publish","type":"post","link":"https:\/\/beebole.com\/blog\/timesheet-integration-xero-office365","title":{"rendered":"Timesheet integration with Xero and Office 365: A case study by Taptu"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-embracing-the-api-economy\">Embracing the API economy<\/h2>\n\n\n\n<p>Ah, the joys of cloud computing! No hardware, less waste, reduced costs, remote access, automatic updates, and the list goes on. But the growing selection of solutions might have you feeling like you&nbsp;<em>can<\/em> have too much of a good thing. Today, <a href=\"https:\/\/www.intermedia.net\/assets\/pdf\/death_by_1000_cloud_apps_ebook.pdf\" target=\"_blank\" rel=\"noopener\">small and medium businesses are juggling an average of 14.3 applications, or 5.5 apps per employee<\/a>. Unless effectively integrated, each of these applications is an information silo, limiting a business&#8217; ability to get a clear picture of its data.<\/p>\n\n\n\n<p><strong>Integrations<\/strong> can provide valuable real time data, reduce human error, improve customer service, boost productivity, and give a big picture view that helps businesses to identify pain points, bottlenecks, and resource sucks. Application programming interfaces (APIs) are key building blocks of this interconnectedness, allowing for the flow of information across organizational boundaries. The growing cloud economy only further impels the so-called <a href=\"https:\/\/www2.deloitte.com\/insights\/us\/en\/focus\/tech-trends\/2018\/api-program-strategy.html\" target=\"_blank\" rel=\"noopener\">&#8220;API imperative&#8221;<\/a>. The problem? <a href=\"https:\/\/beebole.com\/blog\/time-tracking-integrations-guide\/\">Building integrations<\/a> requires time, resources, and a certain amount of IT expertise.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-are-the-key-elements-of-a-custom-api-integration\">What are the key elements of a custom API integration?<\/h2>\n\n\n\n<p>It can be tough to commit, but investing in quality integrations will pay off for most businesses. If you don&#8217;t already have an in-house IT team, and it&#8217;s not a skill set you need full time, an IT consultancy may be the best choice. Beebole customer <a href=\"https:\/\/www.taptu.com.au\/#home\" target=\"_blank\" rel=\"noopener\">Taptu<\/a>, an IT advisor and API integration specialist based in Australia, has extensive experience building integrations for a variety of businesses. They shared some integration insights with us.<\/p>\n\n\n\n<p>Should you choose to create an integration in-house, Taptu CEO Luca&nbsp;Gnezda offers this advice. &#8220;<em>Ideally, you want to try and isolate data down to a single source of truth and held within a single software platform, pushing to one or more customer systems.<\/em> <em>That makes for the easiest and most robust integration,<\/em>&#8221; he says.<\/p>\n\n\n\n<p>In Taptu&#8217;s experience, the <strong>key elements that make an API integration strong<\/strong> are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Unambiguous primary keys in the source system and, ideally, natural keys whenever possible.<\/li>\n\n\n\n<li>Limiting integration to what you really need.<\/li>\n\n\n\n<li>An intermediary system to hold merged copies of data for future disambiguation.<\/li>\n\n\n\n<li>An external primary key in the consuming system, so you can reliably link data back to its source.<\/li>\n\n\n\n<li>Great error handling!<\/li>\n\n\n\n<li>Design integration for self-recovery. No failure should be terminal, and errors should self-correct as data in the source system is fixed.<\/li>\n\n\n\n<li>Fix the source, not the integration.<\/li>\n\n\n\n<li>Separation of interests. Separate the functions of data push and synchronization from master data and warehousing and reporting.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-timesheet-integration-with-xero-payroll-and-office-365-via-api\">Timesheet integration with Xero Payroll and Office 365 via API<\/h2>\n\n\n\n<p>While Taptu is usually busy creating integrations for their clients, they recently built their own API integration platform with <a class=\"highlighted-link bbl-link-hs bbl-link-hs-v-1\" href=\"https:\/\/beebole.com\"><span>Beebole<svg width=\"17\" height=\"18\" viewBox=\"0 0 17 18\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M11.25 0.875H15.625C15.7908 0.875 15.9497 0.940848 16.0669 1.05806C16.1842 1.17527 16.25 1.33424 16.25 1.5V5.875C16.25 6.04076 16.1842 6.19973 16.0669 6.31694C15.9497 6.43415 15.7908 6.5 15.625 6.5C15.4592 6.5 15.3003 6.43415 15.1831 6.31694C15.0658 6.19973 15 6.04076 15 5.875V3.00833L4.81667 13.1917C4.69819 13.3021 4.54148 13.3622 4.37956 13.3593C4.21765 13.3565 4.06316 13.2909 3.94865 13.1764C3.83414 13.0618 3.76854 12.9074 3.76569 12.7454C3.76283 12.5835 3.82293 12.4268 3.93333 12.3083L14.1167 2.125H11.25C11.0842 2.125 10.9253 2.05915 10.8081 1.94194C10.6908 1.82473 10.625 1.66576 10.625 1.5C10.625 1.33424 10.6908 1.17527 10.8081 1.05806C10.9253 0.940848 11.0842 0.875 11.25 0.875ZM2.5 4.625C2.16848 4.625 1.85054 4.7567 1.61612 4.99112C1.3817 5.22554 1.25 5.54348 1.25 5.875V14.625C1.25 14.9565 1.3817 15.2745 1.61612 15.5089C1.85054 15.7433 2.16848 15.875 2.5 15.875H11.25C11.5815 15.875 11.8995 15.7433 12.1339 15.5089C12.3683 15.2745 12.5 14.9565 12.5 14.625V7.75C12.5 7.58424 12.5658 7.42527 12.6831 7.30806C12.8003 7.19085 12.9592 7.125 13.125 7.125C13.2908 7.125 13.4497 7.19085 13.5669 7.30806C13.6842 7.42527 13.75 7.58424 13.75 7.75V14.625C13.75 15.288 13.4866 15.9239 13.0178 16.3928C12.5489 16.8616 11.913 17.125 11.25 17.125H2.5C1.83696 17.125 1.20107 16.8616 0.732233 16.3928C0.263392 15.9239 0 15.288 0 14.625V5.875C0 5.21196 0.263392 4.57607 0.732233 4.10723C1.20107 3.63839 1.83696 3.375 2.5 3.375H9.375C9.54076 3.375 9.69973 3.44085 9.81694 3.55806C9.93415 3.67527 10 3.83424 10 4C10 4.16576 9.93415 4.32473 9.81694 4.44194C9.69973 4.55915 9.54076 4.625 9.375 4.625H2.5Z\"\/><\/svg><\/span><\/a>, Xero, Office 365, their bespoke platform in Azure, and their data warehouse. It requires a <strong>data mashup<\/strong> including client, employee, contractor and service management, client projects, employee and contractor timesheets, client invoicing, remuneration, and reporting. The integration is complex and incorporates many elements, but essentially its steps include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A one-way sync of clients from Xero to all other systems<\/li>\n\n\n\n<li>A two-way sync of employees between Xero and Beebole<\/li>\n\n\n\n<li>A one-way sync of projects from Beebole to the bespoke platform, and then adding master data within the bespoke system<\/li>\n\n\n\n<li>A one-way sync of time from Beebole<\/li>\n\n\n\n<li>The definition of services as the connection between people, time, and client projects<\/li>\n\n\n\n<li>The auto-generation and one-way write of invoicing to Xero<\/li>\n\n\n\n<li>The auto-generation and one-way write of remuneration to Xero<\/li>\n<\/ul>\n\n\n\n<p>Luca explains, &#8220;<em>Our business implements client engagements, invoicing, and remuneration in a non-standard way. This allows our business to be far more agile than our competitors and empowers staff to control the type of work engagements they agree on with our clients<\/em>.&#8221; While they&#8217;re still finishing the front end user experience, Taptu&#8217;s integration is nearly <strong>automating their entire business work and invoicing pipeline<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-using-beebole-s-free-api\">Using Beebole&#8217;s free API<\/h2>\n\n\n\n<p>No two companies are alike, and the best integration may be one tailored to your business&#8217; specific needs. That&#8217;s why Beebole offers a free API, to give you the possibility to integrate with tools like Xero or Office 365 or build custom applications, just as Taptu did.<\/p>\n\n\n\n<p>&#8220;<em>We really enjoy using Beebole<\/em>,&#8221; says Luca Gnezda. &#8220;<em>It&#8217;s simple but effective.<\/em> <em>Most other timesheet systems try to be too much, and make usability worse and integration harder. Beebole is elegant in its simplicity. . . . <strong>The API itself is robust and reliable<\/strong>.<\/em>&#8220;<\/p>\n\n\n\n<p>Some clients may take for granted the availability of an API, but it is not in fact offered by all time tracking tools. Before choosing a time tracking platform, treat integration as an important feature to ensure you don&#8217;t onboard a tool that is not compatible with your existing software.<\/p>\n\n\n\n    <div class=\"bbl-testimonials set_testimonials-block\">\n                    <div class=\"item\">\n                <div class=\"item-text\">A great time system solution. Easy to implement and a straightforward API. The support is fantastic. Overall, I am very pleased.<\/div>\n                <div class=\"item-author\">\n                    Steve R.                                            ,                         <span class=\"position-company\">\n                            Chief Architect                                                             at                                                         Caribou Systems                        <\/span>\n                                    <\/div>\n            <\/div>\n            <\/div>\n\n\n\n<p><strong>Beebole users can enable the API via the &#8220;Account&#8221; module in the settings page, and learn more via Beebole&#8217;s <a href=\"https:\/\/beebole.com\/timesheet-api\/\">API documentation<\/a>.<\/strong><\/p>\n\n\n<div  class=\"mb-4 call_to_action-block\">\n    <div class=\"call_to_action-blockcontent py-5 px-4 text-center border-top border-bottom\">\n                    <h4 class=\"call_to_action-header h2 mt-0\">Want to Achieve What Taptu Did?<\/h4>\n                            <p class=\"call_to_action-text\">The first step is a quick call with us so we can understand your exact business needs.<\/p>\n                <div class=\"call_to_action-btns btns-wrap d-block d-lg-flex justify-content-center mx-auto\">\n                            <a class=\"w-100 w-lg-auto btn btn-outline-primary text-primary link-light me-lg-4 mb-3 mb-lg-0 bbl_cta_block_demo_btn \" href=\"https:\/\/beebole.com\/talk-sales\/\" id=\"cta_post_4081_article_demo_1\">Book a Call<\/a>\n                                <\/div>\n    <\/div>\n<\/div>\n\n\n<p>\u2014<\/p>\n\n\n\n<p>Photo by Hans-Peter Gauster on Unsplash<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Embracing the API economy Ah, the joys of cloud computing! No hardware, less waste, reduced costs, remote access, automatic updates, and the list goes on. But the growing selection of solutions might have you feeling like you&nbsp;can have too much of a good thing. Today, small and medium businesses are juggling an average of 14.3 [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":4125,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1361],"tags":[1371,1669,3987],"class_list":["post-4081","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-timesheet-case-studies","tag-it","tag-case-study","tag-beebole"],"acf":[],"_links":{"self":[{"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/posts\/4081","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/comments?post=4081"}],"version-history":[{"count":22,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/posts\/4081\/revisions"}],"predecessor-version":[{"id":13970,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/posts\/4081\/revisions\/13970"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/media\/4125"}],"wp:attachment":[{"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/media?parent=4081"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/categories?post=4081"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/tags?post=4081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}