linked chain

How We Sync GetLinked With Sage Intacct To Power Up Our Customer’s Reporting

In May 2018 we announced our Trusted CFO Solutions partnership with GetLinked. Here are a few things we’ve been doing with it, and examples of how we save time and money.

Since launching our partnership, we’ve worked with GetLinked to enhance their sync into Sage Intacct. GetLinked has some limitations as you might typically see with a Quickbooks install. The sync works well to departments but does not sync into items, classes, customers, and other dimensions such as vendors.

But, GetLinked built a new version for us to sync all the dimensions into Sage Intacct. Also, they helped us understand Davenport as a new dimension in restaurants. For example, lunch versus dinner. We’ve been able to reconfigure the point of sale (POS) and add additional POS items for the lunch categories versus the dinner categories and bring in those food sales for lunch and dinner as a meal type class. With that, we can get more granular into the analysis of the sales per day.

We haven’t seen any other system integration to the POS in that way. It’s unique in that it evaluates lunch and dinner differently.

In the past, the process was manual for this evaluation. First, we dumped data into Excel, and then a financial analysis was manually done to see performance over time.

With the creation of some automated data tagging to run reports in Sage Intacct by GetLinked, we can operate on a more granular level. GetLinked helps control the mapping of tables for us, and we can log in, update the mappings when we add new ones, map it accurately, and sync it every day into Sage Intacct.

Why Doesn’t Sage Intacct Natively Sync This Information?

This information isn’t in Sage Intacct; it resides in a Point of Sale (POS) system. No bartender or server is going to enter data into Sage Intacct, related to menu choices. The POS handles all of that information and then it creates a daily sales report in a different configuration that might include a PDF.

As an integration tool, GetLinked syncs with most POS systems. Over fifty percent of our restaurant clients use one of the POS systems that GetLinked built the integration. GetLinked has about thirty-seven POS systems on the approved list.

If a customer has that, we want them to go to a POS system that GetLinked approves. Then we can configure it for their financial analyses. Having an approved GetLinked POS system will prevent clients from having to run a report in the POS. Moreover, they will no longer have to input data to Excel daily or use the Excel document as their database.

You can’t run reports off of Excel, and you have to look at the data and analyze it in a very manual way. Once into Sage Intacct, in a lower level granular way that matches the POS, we have a database that has dynamic real-time live reports. Additionally, we can slice and dice data and build reports on the fly as we continue to analyze it.

That is the biggest reason we chose GetLinked. Plus, we like to work with the best partners in the nation. Many other integration tools don’t have the accounting checks and balances like GetLinked. GetLinked won’t let you bring in an unbalanced transaction. Many others will.

GetLinked is a gold standard partner from a higher level enterprise accounting perspective. They offer many more checks and balances so that we’re not running out of control or the systems aren’t talking to each other properly. The way that they build their software allows us more functionality related to accounting control and compliance.

GetLinked will build the integrations from the POS into GetLinked. Several, we developed based on a restaurant wanting to use a specific one to their industry for their quick service.

Our client, Affairs to Remember uses GetLinked for automation to enhance and optimize their current system, Caterease. Our client was using Caterease like QuickBooks is used, so it’s taken about nine months to get a manually built sales process.

As in QuickBooks, the trial balance and sub-ledgers might not tie. So, you might have a sales contract that doesn’t balance to the commissions paid from the sale.

If there is any integration you need with Sage Intacct already built with Sage Intacct, then GetLinked is your 50/50 way to go around that.

 

Tags

Grow Your Restaurant

With our Free Restaurant Success Series

Freely access our restaurant resource center filled with tools, videos, webinars, articles, infographics, and other helpful content to tackle your unique restaurant challenges and grow the business.

What are you waiting for?

Click the button below to learn more.

cloud accounting software for restaurants

Related Content

Why you probably Don’t Need a CFO

“I think we need a CFO” This is what we hear from business owners who contact us. The truth is often they don’t. …
woman working while outside on vacation

Is It Time To Change Your ERP System? Choose a System That DOESN’T Steal Your Soul!

Imagine a world where financial reports are delivered in real-time without your direct involvement and you stop worki…
looking at glasses to see the blurry background of trees

You Don’t Need Microsoft Power BI with Sage Intacct’s Interactive Visual Explorer

Does the world need another acronym? AI, ML, BI – Who cares? The world is changing. And that’s not all. [video wid…

Trusted CFO Solutions Has Blown Us Away Exceeding Our Expectations With PPP2!

We invited Jody Kell of Intown Renewal Developers to share in his own words his experience about partnering with the …
100 dollar bill with benjamin franklin

Maximize Your Second Draw From The Paycheck Protection Program! The Trusted CFO Solutions Team Is Ready to Help!

Did you miss out on relief funds during the first round of PPP? We have good news! On January 13th, 2021, Congress op…
grocery store fruit orderly

Financial & Business Management Assessment & The Power of Controlled Costs for Restaurants

As we leave 2020 and look ahead to 2021, the restaurants that assess their current situation, the ‘Now’, and look ahe…
Trusted CFO Solutions

Trusted CFO Solutions is an advisory and accounting solutions firm with a proven track record of helping clients create... Click to learn more.

Sage Intacct Partner

Contact Us

1000 Circle 75 Parkway | Suite 850 Atlanta, GA 30339 | 855-236-2384

© Trusted CFO Solutions — Sitemap.

Site by JSM.