Integration Configuration for Treez – Sage Intacct Integration

By | November 11, 2021

Greytrix is considered an integration specialist. We have developed a good number of integrations of Sage Intacct with various 3rd party software, Treez being one of them efficiently integrated with Sage Intacct.

We want to walk you through one of its functionality, the Integration Configuration of the GUMU™ for Treez – Sage Intacct Integration. At the same time, the subsequent coming up blogs would elaborate more on how this Integration works.

If I need to specify what this Integration does, in elementary words, it carries the sales and refund transactions from Treez POS into Sage Intacct as a General Ledger transaction.

How does this data Integration work?

We follow the import methodology to integrate the data from Treez to Sage Intacct. However, while doing so, we need to ensure that the critical entity of General Ledger is GL accounts used in the Integration should be pre-existing in Sage Intacct. As for the amounts of Sales, Refund, Discount, Tax, and Payment will be retrieved from Treez and grouped based on ticket number, wherein each ticket in Treez represents the Sale or Refund transaction. Based on these entries, we understand that the summarized GL entries get created within Sage Intacct .

Let’s go through the significance of the “Integration Configuration Screen”. We have explained above that all these amounts (Sales, Refund, Discount, Tax, and Payment) carry to Sage Intacct as GL Entries; thus, we need to know the accounts to map for each entry type.

The above explanation will help one understand the significance of the screen, which allows one to define maps and make the Integration smoother. You can refer to the images below to get an idea of it.

Sage Summit

Payment accountSpecify Payment account. Total amount will be display in the Debit.
Discount accountSpecify discount account. Discount amount will be display in the Debit.
JournalSelect desired Journal to which entries will be added.
Sales accountSpecify Sales account. Amount of this account will be display in credit.
Sales Tax accountSpecify tax account. Tax account will be display in credit.
Rounding accountSpecify Rounding account.  Any rounding differences are tagged to a different GL accounts for reconciliation purpose.
Cash Refund accountSpecify Cash Refund account. Amount of this account will be display in credit.
Discount Refund accountSpecify Discount Refund account. Amount of this account will be display in credit.
Sales Refund accountSpecify Sales Refund account. Amount of this account will be display in credit.
Sales Tax Refund accountSpecify Sales Tax Refund account. Amount of this account will be display in credit.
LocationSpecify the location dimension.  Here you have to select default Location id.
DepartmentSpecify the department dimension.  Here you have to select default Location id
CustomerIDSpecify the Customer dimension (A generic Customer needs to be setup in Sage Intacct which will represent transactions from particular client/store from Treez.)
StateDraft or Posted. Specify the stage of journal entries posted in Sage Intacct

You can see all these account entries generated under Journal Entries (GJ) as shown in the below image for Sales and Refund entries.

Sage Summit

Sage Summit

This how Integration Configuration screen is used to map sales, refund, discount, tax and payment values from Treez POS into Sage Intacct.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.

Greytrix has a wide product range for Sage Intacct- a Cloud ERP. This includes migrations from QuickBooks | Sage 50 | Sage 100 | Sage 300 to Sage Intacct. Our unique GUMU™ integrations include Sage Intacct for Sage CRM | Salesforce | FTP/SFTP | | Checkbook | Dynamics 365 CRM | Magento | Rent Manager | Treez | Avalara Avatax | Blackline SFTP. We also offer best-in-class Sage Intacct Development Services, Consulting services, integrated apps like POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage Intacct to Sage business partners, resellers, and Sage PSG worldwide. Greytrix constantly develops apps, products, and add-ons to enhance user experience. Sage Intacct add-ons include AR Lockbox File Processing.

Greytrix GUMU™ integration for Sage CRM – Sage Intacct, Sales Commission App for Sage Intacct, and ACH/Digital Check Payments for Sage powered by GUMU™ are listed on Sage Intacct Marketplace.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.

For more information on Sage Business Cloud Services, please contact us at We will like to hear from you.