> ## Documentation Index
> Fetch the complete documentation index at: https://docs.upflow.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Sage Intacct & Upflow - Overview

> Overview of how the Sage Intacct integration works with Upflow: subsidiaries, sync frequency, supported data, and key limitations to know upfront.

To sync your Sage account with Upflow for the first time or add a new subsidiary, please refer to [Synchronize Upflow with Sage Intacct](https://docs.upflow.io/en-us/integrations/sage-intacct/connect.md).

Here’s an overview of how Sage integrates with Upflow.

## Subsidiaries

Upflow does not support multi-subsidiary organisations. Only one Sage subsidiary can be mapped/synced per Upflow organization.

## Sync Frequency

The sync frequency between Sage and Upflow is every two hours.

## Entities and Data flows

| Sage Intacct | Data flow | Upflow |
| - | - | - |
| Customer | → | Customer |
| Order entry invoice | → | Invoice |
| Invoice | → | Invoice |
| A/R Adjustment - debit memo | → | Invoice |
| A/R Adjustment - credit memo | → | Credit note |
| Negative invoice | → | Credit note |
| Invoice reversal | → | Credit note |
| Payment | ← → | Payment |
| Payment advance | → | Payment |
| Manual deposit | → | Payment |
| Payment reversal | → | Refund |
| Contact | → | Contact |

Note that we don’t filter on GL account type - we filter on journal types and entity types.

## Parent \<> Child hierarchies

* Sage Intacct offers several levels of depth in their customer hierarchy. Here is an example of parent → child → grand child
* Upflow only supports 1 level of depth, so any grand children will be “flattened” at the child level

In Upflow, the parent balance will be the sum of itself and all its children

![](https://mintcdn.com/upflow-04dc27cd/BozRqwR6DM9YX9fO/images/45614479759889.png?fit=max\&auto=format\&n=BozRqwR6DM9YX9fO\&q=85\&s=0e24251b6cd766e3bcdff17c0d4bf3a9)

### Payments on child customer invoices

To guarantee consistent payment write-backs to Sage Intacct, Upflow blocks payments on child customer invoices in two places:

* **Portal payments**: child customer invoices cannot be paid from a parent customer's portal. Their checkboxes are disabled, with the message "You cannot pay for invoices belonging to child customers". To pay these invoices, use the child customer's own portal.

![Parent customer portal showing a disabled checkbox on a child customer invoice with the message: You cannot pay for invoices belonging to child customers](https://mintcdn.com/upflow-04dc27cd/vktNmbYnGpxtJEnh/images/sage-intacct-portal-child-invoice-blocked.png?fit=max\&auto=format\&n=vktNmbYnGpxtJEnh\&q=85\&s=6d39b6368a2d8ca0b42e5ec923ac19b0)

* **Cash application**: bank transactions cannot be applied to child customer invoices. In the transaction application modal, these invoices show the message "The customer of this invoice does not match the selected customer". Select the child customer directly to apply the transaction to its invoices.

![Bank transaction application modal showing a child customer invoice flagged with the message: The customer of this invoice does not match the selected customer](https://mintcdn.com/upflow-04dc27cd/vktNmbYnGpxtJEnh/images/sage-intacct-cash-app-child-invoice-blocked.png?fit=max\&auto=format\&n=vktNmbYnGpxtJEnh\&q=85\&s=2aed0a86110bef74d3b89a1de8750e6e)

## Invoices

### Invoice statuses

When you activate [Send invoices from Upflow](https://docs.upflow.io/en-us/collection-and-collaboration/send-invoices-from-upflow/overview.md), any new invoice imported into Upflow is considered `UNSENT`, regardless of its Sage Intacct status.

| Sage Intacct status | Upflow status | Comment |
| - | - | - |
| DRAFT | - | Not imported in Upflow |
| Order entry: PENDINGAR: Posted | `DUE` / `OVERDUE` | Order entry transaction can be Pending —> generates AR invoice of status POSTED |
| Posted | `DUE` / `OVERDUE` | |
| Partially paid | `DUE` / `OVERDUE` | |
| PAID | `PAID` | |
| No Value | `PAID` | Sage Intacct sets every invoice with a total of 0 to No Value. Upflow imports it as `PAID` with no outstanding amount. These invoices trigger no reminders and don't affect customer balances. |
| Reversed | `VOIDED` | Reversed invoice —> change status to `Voided` |
| Reversal | `VOIDED` | Reversal invoice —> create Credit note with status `Voided` in Upflow |

### Negative invoices

**Negative invoices in Sage are imported in Upflow as credit notes.**

Note that Upflow only has 4 core accounting data entities: invoices / credit notes / payments / refunds. Every Sage Intacct entity is therefore mapped to one of these 4. Since negative invoices have the same effect as credit notes on the customer balance, they are imported as such.

### Invoice PDFs

Invoice PDFs can be imported from either Sage modules:

* Account receivables
* Order entry

You must configure this in your Upflow Settings > Integrations:

![](https://mintcdn.com/upflow-04dc27cd/BozRqwR6DM9YX9fO/images/45614479760785.png?fit=max\&auto=format\&n=BozRqwR6DM9YX9fO\&q=85\&s=c5e3076ecba487566fcb3b2bf2f0ea6e)

## Payments

### Payment Statuses

| Sage Intacct Payment | Upflow Payment status | Comment |
| - | - | - |
| `completed` | `SUCCEEDED` | The payment is posted to the General Ledger. Completed payments appear on the Posted payments page. |
| `reversed` | Payment = `VOIDED`Refund = `VOIDED` | This creates a reversal refund in Sage and in Upflow |
| `draft` | - | Not imported in Upflow |

### Payment methods

The following methods are imported and mapped into Upflow.

| Sage payment method | Upflow payment method |
| - | - |
| CREDIT\_CARD | Card |
| AMEX\_CHARGE\_CARD | Card |
| CASH | Cash |
| CHECK | Check |
| CHECK\_DELIVERY | Check |
| WF\_CHECK | Check |
| ACH | Wire Transfer |
| AMEX\_ACH | Wire Transfer |
| WF\_DOMESTIC\_ACH | Wire Transfer |
| WF\_USD\_WIRE | Wire Transfer |
| EFT | Wire Transfer |

### Payments write back into Sage

Payments collected through Upflow are written back to Sage Intacct. For the full configuration, status tracking, and how to recover from a failed export, see [Payment write-back](https://docs.upflow.io/en-us/integrations/sage-intacct/payment-write-back.md).

## Contacts

Contacts are created in Upflow from several different sources of information in Sage Intacct:

| Sage Intacct | Upflow |
| - | - |
| ✅ Primary contact: Email address | Upflow contact, of type `main` |
| ❌ Primary contact: Secondary email address | Not imported in Upflow |
| ✅ Contact list | Upflow contacts |

![](https://mintcdn.com/upflow-04dc27cd/BozRqwR6DM9YX9fO/images/45614479762833.png?fit=max\&auto=format\&n=BozRqwR6DM9YX9fO\&q=85\&s=1c02b804098f075f6e12e7d7a1305b7c)

## Custom fields

Upflow supports native and custom fields whenever they are available in Sage, in particular:

* ✅ Contacts
* ✅ Customers
* ✅ Invoices
* ✅ Payments
* ✅ Credit notes

### Contact custom fields

Contact native fields are imported into Upflow as custom fields:

* ✅ Bill-to contact or Ship-to contact → Contact custom field `Contact position`
* ✅ Category → Contact custom field  `Contact position`

![](https://mintcdn.com/upflow-04dc27cd/BozRqwR6DM9YX9fO/images/45614487255569.png?fit=max\&auto=format\&n=BozRqwR6DM9YX9fO\&q=85\&s=ec487e8b5a6df2ceb57aa31f35012139)

### Good to know

* Sage Intacct projects are not imported into Upflow.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.