{"id":9888,"date":"2021-12-13T15:22:00","date_gmt":"2021-12-13T20:22:00","guid":{"rendered":"https:\/\/www.sage.com\/en-us\/blog\/?p=9888"},"modified":"2025-04-24T10:55:17","modified_gmt":"2025-04-24T14:55:17","slug":"rehabbing-financials-to-tame-100-instances-of-quickbooks","status":"publish","type":"post","link":"https:\/\/www.sage.com\/en-us\/blog\/rehabbing-financials-to-tame-100-instances-of-quickbooks\/","title":{"rendered":"Rehabbing financials to tame 100+ instances of QuickBooks"},"content":{"rendered":"<header class=\"entry-header has-dark-background-color entry-header--has-illustration entry-header--has-illustration--generic\">\n\t<div class=\"container\">\n\t\t<div class=\"entry-header__row row align-center\">\n\t\t\t<div class=\"col col-lg-7 col-xlg-6 entry-header__content\">\n\t\t\t\t\t\t\t<div class=\"component component-single-header\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"entry-header__misc text--subtitle text--uppercase text--small\">\n\t\t\t\t\t\t\t<a href=\"https:\/\/www.sage.com\/en-us\/blog\/category\/accountants\/\" class=\"entry-header__link\">Accountants<\/a>\t\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t<div class=\"entry-title-wrapper\">\n\t\t\t\t\t<h1 class=\"entry-title\">\n\t\t\t\t\t\tRehabbing financials to tame 100+ instances of QuickBooks\t\t\t\t\t<\/h1>\n\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t<p class=\"entry-header__description\">\n\t\t\t\t\t\t\t\t\t\t\t<\/p>\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t<\/div>\n\t<div class=\"single-post-details container\">\n\t\t<div class=\"col\">\n\t\t\t<span class=\"posted-on \"><time class=\"entry-date published\" datetime=\"2021-12-13T15:22:00-05:00\">December 13, 2021<\/time><\/span><span class=\"reading-time\"> min read<\/span>\n\t\t<button\n\t\t\ttype=\"button\"\n\t\t\tclass=\"social-share-button button button--icon button--secondary js-social-share-button\"\n\t\t\tdata-share-title=\"Rehabbing financials to tame 100+ instances of QuickBooks\"\n\t\t\tdata-share-url=\"https:\/\/www.sage.com\/en-us\/blog\/rehabbing-financials-to-tame-100-instances-of-quickbooks\/\"\n\t\t\tdata-share-text=\"Please read this interesting article\"\n\t\t>\n\t\t\t<span class=\"social-share-button__share-label\">Share<\/span>\n\t\t\t<span class=\"social-share-button__copy-label\" hidden>Copy Link<\/span>\n\t\t\t<span class=\"social-share-button__copy-tooltip\" aria-hidden=\"true\" hidden>Copied<\/span>\n\t\t<\/button>\n\n\t\t\t\t<\/div>\n\t<\/div>\n<\/header>\n\n\n<div class=\"wp-block-post-author has-dark-background-color alignfull\">\n\t<div class=\"container\">\n\t\t<div class=\"col\">\n\t\t\t\t\t\t\t<div class=\"co-authors\">\n\t\t\t\t\t\n\t\t<div class=\"entry-author-wrapper\">\n\t\t\t<a class=\"entry-author\" href=\"https:\/\/www.sage.com\/en-us\/blog\/author\/andrew-sevillia\/\">\n\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"40\" height=\"40\" src=\"https:\/\/www.sage.com\/en-us\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/andrew_sevillia_profile.jpg\" class=\"entry-author__image\" alt=\"Andrew Sevillia\" \/>\t\t\t\t<span class=\"entry-author__name\">Andrew Sevillia<\/span>\n\t\t\t<\/a>\n\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t<\/div>\n<\/div>\n\n\n\n<p class=\"\"><a href=\"https:\/\/team-rehab.com\/\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">Team Rehabilitation Services<\/span><\/a><span data-contrast=\"auto\">&nbsp;(Team Rehab) is a network of 140 therapist-owned outpatient physical therapy clinics in Michigan, Illinois, Indiana, Wisconsin, and Georgia. The 20-year-old organization strives for the best outpatient physical therapy, occupational therapy, and speech therapy that measurably improves patient outcomes.<\/span><\/p>\n\n\n\n<p class=\"\"><span data-contrast=\"auto\">We recently had an enlightening conversation with Kimberley Alleman, the company\u2019s finance director, who told us how Sage Intacct has changed the game for Team Rehab by replacing 100+ different instances of&nbsp;Intuit QuickBooks. In a&nbsp;<\/span><span data-contrast=\"none\">new customer story<\/span><span data-contrast=\"auto\">, she described how the rapidly growing healthcare organization achieved the following results in just a few years:<\/span><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><span data-contrast=\"auto\">Improved finance team efficiency 40% <\/span><span data-ccp-props=\"{}\">&nbsp;<\/span><\/li>\n\n\n\n<li><span data-contrast=\"auto\">Saved 180+ labor hours per month by automating workflows<\/span><span data-ccp-props=\"{}\">&nbsp;<\/span><\/li>\n\n\n\n<li><span data-contrast=\"auto\">Supported rapid growth as business grew 20% year-over-year<\/span><span data-ccp-props=\"{}\">&nbsp;<\/span><\/li>\n\n\n\n<li><span data-contrast=\"auto\">Gained greater confidence in hiring and investment decisions<\/span><span data-ccp-props=\"{}\">&nbsp;<\/span><\/li>\n<\/ul>\n\n\n\n<p class=\"\"><span data-contrast=\"auto\">The company prioritizes patient satisfaction, outcomes, and referrals well above expenses or cost containment, and&nbsp;hand-in-hand&nbsp;with ensuring happy patients is its focus on Team Rehab\u2019s 1,800 employees. Everyone,&nbsp;from clinic directors to receptionists, has the option to buy into the company and become a stakeholder with a vested interest in the business. This two-pronged strategy is clearly working, since the company has been featured as one of Michigan\u2019s&nbsp;<\/span><span data-contrast=\"none\">top workplaces<\/span><span data-contrast=\"auto\">&nbsp;for 13 years running.<\/span><span data-ccp-props=\"{}\">&nbsp;<\/span><\/p>\n\n\n\n<p class=\"\"><span data-contrast=\"auto\">That kind of success is no easy feat, especially amidst a pandemic and continued rapid growth. In fact, Team Rehab adds around 20-25 new locations&nbsp;every year. Two years ago, when each clinic had its own separate instance of Intuit QuickBooks, the finance team struggled to do any type of company-wide reporting.<\/span><span data-ccp-props=\"{}\">&nbsp;<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><span data-contrast=\"auto\">Wrangling Complexity and Growth<\/span><\/strong><span data-ccp-props=\"{}\">&nbsp;<\/span><\/h2>\n\n\n\n<p class=\"\"><span data-contrast=\"auto\">Not only did five people spend two full days manually <a href=\"https:\/\/www.sage.com\/en-us\/sage-business-cloud\/intacct\/product-capabilities\/extended-capabilities\/consolidation-accounting\/\n\" target=\"_blank\" rel=\"noopener\">consolidating the books<\/a> and printing individual clinic P&amp;Ls every month,&nbsp;all kinds of other financial processes were&nbsp;cumbersome and tedious as well. \u201cBack then, there were a lot of things that we did in Excel,\u201d remembered Alleman. \u201cI was keying in the P&amp;Ls for every single entity into a massive spreadsheet. I literally went in and typed line-by-line numbers for our financials each month.\u201d<\/span><span data-ccp-props=\"{}\">&nbsp;<\/span><\/p>\n\n\n\n<p class=\"\"><span data-contrast=\"auto\">And as expenses came in through the company\u2019s main entity, the finance team would have to allocate those out to&nbsp;all of&nbsp;the individual clinics that rolled up underneath Team Rehab Services. To do so, they\u2019d log in and out of QuickBooks&nbsp;over and over again&nbsp;to record intercompany journal entries in each clinic\u2019s instance, as well as for the umbrella company. \u201cStaying on our old&nbsp;software just made no sense, given the continuous growth we were expecting,\u201d noted Alleman. \u201cWe knew QuickBooks was at risk of crashing at any point, and when we found Sage Intacct, we immediately loved its multi-entity support and automated intercompany&nbsp;capabilities.\u201d&nbsp;<\/span><span data-ccp-props=\"{}\">&nbsp;<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><span data-contrast=\"auto\">Eliminating 3+ Weeks of Manual Work Every Month<\/span><\/strong><span data-ccp-props=\"{}\">&nbsp;<\/span><\/h2>\n\n\n\n<p class=\"\"><span data-contrast=\"auto\">Team Rehab\u2019s finance team worked with Sage Intacct consulting partner&nbsp;<\/span><a href=\"https:\/\/www.altavistatech.com\/\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">AltaVista Technology<\/span><\/a><span data-contrast=\"auto\">&nbsp;for a full data migration and implementation. Alleman shared, \u201cAltaVista sat down with&nbsp;us&nbsp;and we mapped out a fairly quick timeline. They helped us import our transaction-level detail from&nbsp;all of&nbsp;those QuickBooks instances into Sage Intacct within just five weeks \u2014 it was amazing. We went live right on schedule and never looked back.\u201d Thankfully they were well past this transition by the time COVID lockdowns began last year, so everyone was able to easily work from home. Alleman notes that they simply would not have been able to function as a team if they hadn\u2019t had a cloud-based system at that point.<\/span><\/p>\n\n\n\n<p class=\"\"><span data-contrast=\"auto\">Across the board, Sage Intacct helps the team save more than 180 hours each month, representing a 40% efficiency gain. For example, they\u2019ve automated the entry of Team Rehab\u2019s ~2,700 corporate credit card transactions every month. Rather than spending more than a week\u2019s worth of time recording every item by hand, they now receive a simple export from American Express and can instantly import it into Sage Intacct to reconcile expense details. A similar import from ADP helped speed the process of manually adding each new hire into Sage Intacct for tracking.<\/span><span data-ccp-props=\"{}\">&nbsp;<\/span><\/p>\n\n\n\n<p class=\"\"><span data-contrast=\"auto\">In addition, the team <a href=\"https:\/\/www.sage.com\/en-us\/sage-business-cloud\/intacct\/product-capabilities\/core-financials\/accounts-payable\/\n\" target=\"_blank\" rel=\"noopener\">streamlined accounts payable<\/a> by replacing around 200 paper checks every week with ACH files through Sage Intacct. They got rid of file cabinets full of checks and&nbsp;invoices, and&nbsp;improved the expense reporting and reimbursement process as well. \u201cWe used to have people enter their expense reports on an Excel spreadsheet, print that out and&nbsp;attach to paper copies of their receipts, and then send it to our team, who\u2019d enter everything into QuickBooks,\u201d Alleman said. \u201cOur employees like using Nexonia, which is fully integrated with Sage Intacct, because they can now use an app on their phone to&nbsp;capture receipts and everything is processed behind the scenes. That has been a huge time&nbsp;<\/span><i><span data-contrast=\"auto\">and<\/span><\/i><span data-contrast=\"auto\">&nbsp;paper savings.\u201d<\/span><span data-ccp-props=\"{}\">&nbsp;<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><span data-contrast=\"auto\">From the Bird&#8217;s Eye View to Financial Close-ups<\/span><\/strong><span data-ccp-props=\"{}\">&nbsp;<\/span><\/h2>\n\n\n\n<p class=\"\"><span data-contrast=\"auto\">In addition to these impressive productivity gains, one of the biggest impacts of Team Rehab\u2019s&nbsp;move to Sage Intacct is finally having a top-level view of the whole company in one spot. The CFO, CEO and board now have&nbsp;all of&nbsp;the <a href=\"https:\/\/www.sage.com\/en-us\/sage-business-cloud\/intacct\/product-capabilities\/extended-capabilities\/financial-reporting\/\n\" target=\"_blank\" rel=\"noopener\">transparency and visibility<\/a> they need to steer the business, not just at the clinic level, but across regional groupings or&nbsp;states as well.<\/span><span data-ccp-props=\"{}\">&nbsp;<\/span><\/p>\n\n\n\n<p class=\"\"><span data-contrast=\"auto\">AltaVista helped the finance team use Sage Intacct to set up all of the P&amp;L statements they need, sliced and diced in different ways, including helpful KPIs based on statistical data. Now, each clinic\u2019s financial statement includes a line right below revenue that shows the total number of patient visits, average charge per visit, reimbursement rate per visit, and reimbursement as a percentage of charges for that month. This helps the mentors for each clinic \u2014 who bring experience running other profitable clinics \u2014 see where each location should put their focus.<\/span><span data-ccp-props=\"{}\">&nbsp;<\/span><\/p>\n\n\n\n<p class=\"\"><span data-contrast=\"auto\">What\u2019s great is that Alleman simply imports clinical and operational data from the company\u2019s patient billing system, and then Sage Intacct automates&nbsp;all of&nbsp;those calculations and feeds the metrics into her reports. She also uses the system to store ownership percentages for each clinic, ensuring that bonuses and profit distributions are paid out accurately. In addition, she built a custom report to track different fixed asset ratios, which the CFO reviews quarterly as part of debt covenants with the bank.<\/span><span data-ccp-props=\"{}\">&nbsp;<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><span data-contrast=\"auto\">A Reputation of Responsiveness<\/span><\/strong><span data-ccp-props=\"{}\">&nbsp;<\/span><\/h2>\n\n\n\n<p class=\"\"><span data-contrast=\"auto\">In general, Sage Intacct has improved the finance team\u2019s reputation within the company now that they\u2019re able to respond within 24 hours to any ad hoc request. \u201cSage Intacct saves us so much time when people have questions about a clinic\u2019s financials, because we have information right at our fingertips. Every year now, our employee survey comes back saying that finance is very responsive,\u201d mentioned Alleman.<\/span><span data-ccp-props=\"{}\">&nbsp;<\/span><\/p>\n\n\n\n<p class=\"\"><span data-contrast=\"auto\">Next up, the company hopes to fully integrate Sage Intacct with its Salesforce, patient billing, and ADP platforms, which should have an even greater impact on overall efficiency.&nbsp;<\/span><\/p>\n \n<div class=\"single-cta\">\n\t<div class=\"single-cta__positioner\">\n\t\t<div class=\"single-cta__wrapper has-dark-background-color\">\n\t\t\t<div class=\"single-cta__content\">\n\t\t\t\t\t\t\t\t<h2 class=\"single-cta__title h3\">Take a coffee break with Sage<\/h2>\n\n\t\t\t\t\t\t\t\t\t<div class=\"single-cta__description\">\n\t\t\t\t\t\t<p><!-- wp:paragraph --><\/p>\n<p class=\"\">Interactive Demo<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a\n\t\t\t\t\t\thref=\"https:\/\/www.sage.com\/en-us\/sage-business-cloud\/intacct\/coffee-break-demo\/\"\n\t\t\t\t\t\tclass=\"single-cta__button button button--primary\"\n\t\t\t\t\t\t\t\t\t\t\t\t\tid=\"cta-id-14172\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tdata-button-location=\"cta_box\"\n\t\t\t\t\t\t\t\t\t\t\t>Learn more<\/a>\n\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<img decoding=\"async\" width=\"1440\" height=\"810\" src=\"https:\/\/www.sage.com\/en-us\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/character-illustration_support-training_coffee-break-demo_b-1440x810.png\" class=\"single-cta__image\" alt=\"animated-person-sitting-on-giant-coffee-cup\" loading=\"lazy\" srcset=\"https:\/\/www.sage.com\/en-us\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/character-illustration_support-training_coffee-break-demo_b-1440x810.png 1440w\" sizes=\"auto, (min-width: 48em) 33vw, 100vw\" \/>\t\t\t<\/div>\n<\/div>\n\n\n<div class=\"single-cta\">\n\t<div class=\"single-cta__positioner\">\n\t\t<div class=\"single-cta__wrapper has-dark-background-color\">\n\t\t\t<div class=\"single-cta__content\">\n\t\t\t\t\t\t\t\t<h2 class=\"single-cta__title h3\">Subscribe to our Sage Advice Newsletter<\/h2>\n\n\t\t\t\t\t\t\t\t\t<div class=\"single-cta__description\">\n\t\t\t\t\t\t<p>Get our latest business advice delivered directly to your inbox.<\/p>\n\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a\n\t\t\t\t\t\thref=\"#gate-ab515c6e-7e90-4c2f-a67e-113872516e8b\"\n\t\t\t\t\t\tclass=\"single-cta__button button button--primary\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t>Subscribe<\/a>\n\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<img decoding=\"async\" width=\"1440\" height=\"810\" src=\"https:\/\/www.sage.com\/en-us\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/GettyImages-1073797282-1440x810.jpg\" class=\"single-cta__image\" alt=\"Working from home with tea in hand\" loading=\"lazy\" srcset=\"https:\/\/www.sage.com\/en-us\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/GettyImages-1073797282-1440x810.jpg 1440w\" sizes=\"auto, (min-width: 48em) 33vw, 100vw\" \/>\t\t\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Team Rehabilitation Services&nbsp;(Team Rehab) is a network of 140 therapist-owned outpatient physical therapy clinics in Michigan, Illinois, Indiana, Wisconsin, and Georgia. The 20-year-old organization strives for the best outpatient physical therapy, occupational therapy, and speech therapy that measurably improves patient outcomes. We recently had an enlightening conversation with Kimberley Alleman, the company\u2019s finance director, who [&hellip;]<\/p>\n","protected":false},"author":1446,"featured_media":9065,"menu_order":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_sage_video":false,"post_featured_image_hide":false,"footnotes":""},"categories":[158,48],"tags":[2,170,420,168],"business_type":[40,312,41],"lilypad":[],"context":[418,429],"industry":[451],"persona":[150],"imagine_tag":[209,436],"coauthors":[613],"class_list":["post-9888","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-accountants","category-technology-innovation","tag-accountants","tag-business-strategy","tag-cloud-financial-management","tag-sage-accounting","business_type-small-business","business_type-accountants","business_type-growing-business","industry-healthcare"],"sage_meta":{"region":"en-us","author_name":"Andrew Sevillia","featured_image":"https:\/\/www.sage.com\/en-us\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/GettyImages-1139667011_updated.jpg","imagine_tags":{"209":"Accounting","436":"Intacct Accounting"}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Sage Advice US","distributor_original_site_url":"https:\/\/www.sage.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/posts\/9888","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/users\/1446"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/comments?post=9888"}],"version-history":[{"count":0,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/posts\/9888\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/media\/9065"}],"wp:attachment":[{"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/media?parent=9888"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/categories?post=9888"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/tags?post=9888"},{"taxonomy":"business_type","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/business_type?post=9888"},{"taxonomy":"lilypad","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/lilypad?post=9888"},{"taxonomy":"context","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/context?post=9888"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/industry?post=9888"},{"taxonomy":"persona","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/persona?post=9888"},{"taxonomy":"imagine_tag","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/imagine_tag?post=9888"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/coauthors?post=9888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}