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 hour.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 |
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
Invoices
Invoice statuses
| 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 | |
| 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
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 = VOIDEDRefund = 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.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 |
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
Good to know
- Sage Intacct projects are not imported into Upflow.