Tipalti Help Center home page
  • Get started
    • Onboarding tools
    • Video tutorials
    • Live training
  • User guides
    • Tipalti Hub Home
      • Log in to the Tipalti Hub
      • Manage finances from Home
    • Tipalti AI Assistant
      • Ask the assistant
      • Common prompts
    • Administration
      • Administrative operations
      • Admin settings
      • Custom fields
      • Team management
      • User roles
      • User permissions
      • Email domain setup
      • Email notifications
      • Manage communications
      • Edit and customize templates
    • Multiple entities
      • Multiple entities
      • Switch entities with multi-instance setup
    • Funding
      • Funds overview
      • Manage virtual accounts
      • Fund Tipalti accounts
      • Transfer funds between accounts
      • Multi-FX
    • Payees
      • Search payee information
      • Manage payee status and settings
      • iFrame/ Supplier Hub
      • Manage Supplier Hub payees
      • Manage actions as a payee
      • Add and review payee documents
      • Verification of payee
    • Taxation
      • US tax forms
      • Tax form expiration
      • Tax withholding
      • Certificate of No US Activities
      • Additional documents
      • Non-US tax collection
      • Tax form statuses
    • Procurement
      • New Procurement
      • Original Procurement
    • PO matching
      • New PO matching
      • Original PO matching
    • Bills
    • Tipalti Expenses
      • Get started
      • Create and submit expenses
      • Manage and approve expenses
      • Build expense approval workflows
      • Reimburse expenses
      • Connect your corporate cards
    • Tipalti Cards
      • Tipalti Cards
      • Fund your card
      • Manage cards
      • Monitor card transactions
      • Process transactions
      • ERP sync
      • Credit card statement report
    • Payments
      • Submit payments
      • Manage payments
      • Schedule payments
      • Understanding payment statuses
      • Payment methods coverage: US and ROW
      • Payment methods coverage: UK and EU
      • Payment methods coverage: Canada
      • Payment error codes
      • Managing unsuccessful payments
    • Reports
      • AI-powered reports
      • Payment reports
      • Bill reports
      • Payee reports
      • Tax reports
      • User reports
    • Security practices
      • Email security
      • Business continuity practices
      • Two-factor authentication
      • Detect
  • Integrations
    • 3rd Party Apps
      • Partner Platforms
      • SSO
    • ERPs
      • Sage Intacct
      • NetSuite 2.0
      • Microsoft Business Central
      • QuickBooks
      • Xero
      • Tipalti Connect
      • Acumatica
      • SAP B1
    • File Integration
      • Configure auto-sync settings
      • Import files
      • Export files
  • FAQs
    • General FAQs
    • User guide FAQs
      • Payee FAQs
      • Bill FAQs
      • Card FAQs
      • PO Matching FAQs
      • Payment FAQs
      • Detect FAQs
      • Taxation FAQs
      • Administration FAQs
      • Expenses FAQs
    • ERP FAQs
  • Release notes
  • Dev docs
Sign in
  • Get started  
    • Onboarding tools  
    • Video tutorials  
    • Live training  
  • User guide  
    • Log in to the Tipalti Hub
    • Administration  
      • Administrative operations
      • User roles
    • Multiple entities
    • Funding  
      • View funds required
      • Fund Tipalti accounts
      • Multi-FX  
        • Currency cutoffs and validations
    • Payees  
      • Search payee information
      • Manage payee status and settings
      • iFrame/ Supplier Hub
      • Manage Supplier Hub payees
      • Documents review
    • Taxation  
      • US tax forms
      • Tax form expiration
      • Tax withholding  
        • Withholding rates
        • Income types
        • Tax form and entity types
      • Certificate of No US Activities
      • Additional documents
      • Non-US tax collection
      • Tax form statuses
    • Procurement  
      • System overview
      • Create and track purchase requests
      • Approve purchase requests
      • Mark goods and services as received
      • Vendor registration
      • Send PO PDF
      • Back office  
        • Set reminders
        • Run parallel PR/ vendor approval
        • Emails
        • PO PDF customization
        • Upload budget
        • Customize Procurement forms
        • Contract repository
      • Workflow integrations
    • PO Matching  
      • Matching process
      • Handle matching exceptions
      • Bill routing
      • Matching policies
      • Bill coding
      • Bill approval for PO-backed bills  
        • Approvable bills
        • Non-approvable bills
        • PO updates
      • Prepayments (NetSuite 2.0)
      • Track and match a dropship invoice  
        • Set payees up as dropship vendors
        • Upload and match a dropship invoice
    • Bills  
      • Bill flows
      • Usability
      • Add invoices
      • Manage bills
      • Add comments and files to bills
      • Bill approvers
      • Invoice processing approvals
      • Email Security
      • Tax collection in Bills
      • Bill statuses
    • Tipalti Expenses  
      • Get started
      • Create and submit expenses
      • Manage and approve expenses
      • Reimburse expenses
      • Connect your corporate cards
    • Tipalti Cards  
      • Funds flow
      • Manage cards
      • Card transactions overview
      • Process transactions
      • ERP sync
      • Credit card statement report
    • Submitting payments
    • Payment information  
      • Payment statuses defined
      • Payment methods coverage: US and ROW
      • Payment methods coverage: UK and EU
      • Payment methods coverage: Canada
      • Payment error codes
    • Reports  
      • Smart report builder
      • Payment reports
      • Bill reports
      • Payee reports
      • Tax reports
      • User reports
    • Security practices  
      • Email security
      • Business continuity practices
      • Two-factor authentication
    • Detect
  • Integrations  
    • 3rd Party Apps  
      • Partner Platforms
      • SSO
    • ERPs  
      • Sage Intacct
      • NetSuite 2.0
      • Microsoft Business Central
      • QuickBooks
      • Xero
      • Tipalti Connect
      • Acumatica
      • SAP B1
    • File Integration  
      • Configure auto-sync settings
      • Import files
      • Export files
  • FAQs  
    • General FAQs
    • User guide FAQs  
      • Bill FAQs
      • Card FAQs
      • PO Matching FAQs
      • Payment FAQs
      • Detect FAQs
      • Taxation FAQs
      • Administration FAQs
      • Expenses FAQs
    • ERP FAQs
  • Release notes
  • Dev docs
  1. Tipalti
  2. Integrations
  3. ERPs
  4. Sage Intacct

Articles in this section

  • Sage Intacct
  • Setup
  • Integration workflow
  • Synchronization
  • Required user roles
  • Sync monitoring for Sage Intacct

Synchronization with Sage Intacct

Select a category below to see information about synchronization between Intacct and Tipalti.

Vendors
  • Payee payment terms sync bidirectionally (and payer payment terms sync from Intacct to Tipalti).
  • Inactive vendors in Intacct are marked as suspended in Tipalti and vice versa.
  • Vendors that are deleted in Intacct are closed in Tipalti.
Bills

Tipalti to Intacct

Bills in the following statuses are synced automatically from Tipalti to Intacct:

  • Scheduled for payment
  • Submitted for payment
  • Paid
  • Partially paid

Payers can choose to sync bills from Tipalti to Intacct before or after bill approval. Syncing before approval syncs bills in "Pending approval" status, which allows payers to see their bills earlier in the ERP.

Currently, syncing bills before approval is not available for payers using the PO Matching feature.

When a synchronized bill is deleted or disputed, it is removed from Intacct. If the bill is un-deleted or undisputed, it is re-created in Intacct.

Retracted approvals

When an approved bill is synced to Intacct, it includes the approval date.

  • If the bill is sent back to AP in Tipalti, it's retracted, and in Intacct, this is synced as a reversal with the retracted date.
  • If the bill is approved again, this is synced as a new bill in Intacct. 

Bills paid manually

The GL account type (Bank/ Credit card) and transaction date for bills marked as paid manually are synced to the payer's ERP under the relevant bill payment.

Intacct to Tipalti

  • GL accounts linked to multiple entities sync from Intacct to Tipalti.
  • Units of measurement, which are used for PO matching, sync from Intacct to Tipalti. Unit values must be unique in Intacct for sync to be successful.
  • Card transaction lines, including the VAT field, are synced to Tipalti.
Vendor credits for fees

A vendor credit is created for a payee's transaction fee and is linked to the payee's bill. When the payment is submitted to Tipalti, both vendor credit and bill are synced to Intacct.

When the payment is paid:

  1. If the payment is a NetNow payment, the payee NetNow fee is added as a line on the fee vendor credit.
  2. If the payee's payment is subject to withholding, a different vendor credit is created for the withholding amount and is linked to the bill.
  3. All vendor credit information is synchronized to Intacct and a bill payment is created.
  4. If there is a payee foreign exchange (FX) fee, it is added to the bill payment.

Example

  • Bill = $1000
  • Vendor credit 1:
    • Payee transaction fee = $3
    • Payee NetNow fee = $2
  • Vendor credit 2: Withholding amount = $4
  • Payee FX fee = $1
  • Net amount (received by payee) = $990

Bill payment = Net amount + Payee NetNow fee + Payee FX fee = $993

GL accounts

GL accounts linked to multiple entities sync from Intacct to Tipalti.

PO matching
  • In Intacct, POs and receipts (PO receivers) can be defined in 3 ways:
    • Leave Transaction Open - Partially matched transaction is kept open until completed.
    • Close Original and Create Back Order - Once the transaction has been partially matched, it is closed, and a new transaction is created with the remaining quantity.
    • Close transaction - Partially matched transaction is closed.
  • POs and receipts (PO receivers) are synced to Tipalti and matched to the invoice.
  • Once matching is complete, a "Vendor invoice" is synced back to Intacct and a linked bill is created automatically to represent the transaction.
Custom fields
  • In Intacct, Amortization class allows you to categorize and manage the amortization of expenses over a specific period.
  • Amortization class is synced to Tipalti as two fields:
    • Start Amortization date is synced as a custom field of type Date.
    • Amortization classes is synced as a custom field of type List.

Standard integration

Several fields are mapped automatically in the standard integration and are not available for custom mapping. Select a category below to see the mapped fields.

Payment sync

All payments in Tipalti that were added, updated or deleted since the last sync are collected and synced to Intacct.

Mapped fields

Tipalti

Intacct

Tipalti payee ID (idap)VendorRef by Payee ID
Total amountTotalAmt
Submitted dateTxnDate
RefCodeExternal ID (custom field)
Txn refcodeDoc. No.*
CurrencyCurrencyRef
PaymentAmount (displays under Related Bills)Line
RefCode (displays under Related Bills)Line
Account (Virtual Account ID)BankAccountRef
* Labeled "Ref. No." in the Intacct user interface
GL account sync

All GL accounts in Intacct that were added, updated or deleted since the last sync are collected and synced to Tipalti.

Mapped fields

Tipalti

Intacct

NumberAcctNum
NameName
DescriptionDescription
External IDID
Vendor sync

All vendors that were added, updated or deleted since the last sync are collected and synced to Intacct, Tipalti, or both systems.

Mapped fields

Tipalti

Intacct

EmailPrimaryEmailAddr.Address
Company nameCompanyName
First nameGivenname
Middle nameMiddlename
Last nameFamilyName
Street 1BillAddr.Line1
Street 2BillAddr.Line2
CityBillAddr.City
StateBillAddr.CountrySubDivisionCode
ZipBillAddr.PostalCode
PhoneMobile
Bill sync

All bills that were added, updated or deleted since the last sync are collected and synced from Tipalti to Intacct.

Mapped fields

Tipalti

Intacct

Tipalti payee ID (idap)VendorRef by Payee ID
Due dateDueDate (if it exists)
Invoice dateTxnDate
Invoice numberDocNumber
RefcodeExternalID (custom field)
Bill line amountLine [0..n].TaxInclusiveAmt (only Billable / HasBeenBill lines)
Bill line descriptionLine [0..n].Description (only Billable / HasBeenBill lines)
Bill line accountLine [0..n].AccountRef
Vendor credit sync

All vendor credit records that were added, updated or deleted since the last sync are collected and synced from Tipalti to Intacct.

  • When a vendor credit is applied in Tipalti, a bill payment is created automatically in Intacct and the vendor credit is linked to it.
  • When a vendor credit is applied in Intacct, it is applied automatically in Tipalti.

Mapped fields

Tipalti

Intacct

AmountTotalAmt
CurrencyCurrencyRef
Invoice datetxnDate
Invoice numberdocNumber
Bill line amountline
Bill line descriptionline.description
Purchase orders sync

All purchase orders in Intacct that were added, updated or deleted since the last sync are collected and synced to Tipalti.

Mapped fields

Tipalti

common

Intacct

ExternalIdIdRECORDNO
PurchaseOrderNumberPurchaseOrderNumberDOCID
StatusStatus*STATE
MemoMemoMESSAGE
PurchaseOrderDateCreatedDateWHENCREATED
IdapVendorIDCUSTVENDID
PurchaseOrderLines.
PurchaseOrderLine[].Item
PurchaseOrderLines[].
Item^
PODOCUMENTENTRIES.
podocumententry[].ITEMID
PurchaseOrderLines.
PurchaseOrderLine[].Quantity
PurchaseOrderLines[].
Quantity
PODOCUMENTENTRIES.
podocumententry[].UIQTY
PurchaseOrderLines.
PurchaseOrderLine[].Units
PurchaseOrderLines[].
Units
PODOCUMENTENTRIES.
podocumententry[].UNIT
PurchaseOrderLines.Line
Description
PurchaseOrderLines[].
Description
PODOCUMENTENTRIES.
podocumententry[].MEMO
PurchaseOrderLines.
PurchaseOrderLine[].Rate
PurchaseOrderLines[].
Rate
PODOCUMENTENTRIES.
podocumententry[].UIPRICE
PurchaseOrderLines.
PurchaseOrderLine[].Item
PurchaseOrderLines[].
TRX_VALUE
PODOCUMENTENTRIES.
podocumententry[].TRX_VALUE
PurchaseOrderLines.PurchaseOrderLine[].
CustomFields.Warehouse
PurchaseOrderLines[].
CustomFields.Warehouse
PODOCUMENTENTRIES.
podocumententry[].WAREHOUSE.
LOCATION_NO
PurchaseOrderLines.PurchaseOrderLine[].
CustomFields.Department
PurchaseOrderLines[].
CustomFields.Department
PODOCUMENTENTRIES.
podocumententry[].DEPARTMENT
PurchaseOrderLines.PurchaseOrderLine[].
CustomFields.Class
PurchaseOrderLines[].
CustomFields.Classǂ
PODOCUMENTENTRIES.
podocumententry[].CLASSID
PurchaseOrderLines.PurchaseOrderLine[].
CustomFields.Location
PurchaseOrderLines[].
CustomFields.Location
PODOCUMENTENTRIES.
podocumententry[].LOCATIONID
PurchaseOrderLines.
PurchaseOrderLine[].PoLineId
PurchaseOrderLines[].
ExternalID
PODOCUMENTENTRIES.
podocumententry[].LINE_NO
PurchaseOrderLines.
PurchaseOrderLine[].BilledQuantity
PurchaseOrderLines[].
BilledQuantity
PODOCUMENTENTRIES.
podocumententry[].QTY_CONVERTED
PurchaseOrderLines.
PurchaseOrderLine[].LineType
PurchaseOrderLines[].
LineType = 'Item'
N/A
N/APurchaseOrderLines[].
BilledAmount
PODOCUMENTENTRIES.
podocumententry[].
TOTAL_AMOUNT_CONVERTED
PayerEntityPayerEntity+PODOCUMENTENTRIES.
podocumententry[].LOCATIONID
CurrencyCurrency+PODOCUMENTENTRIES.
podocumententry[].CURRENCY
PurchaseOrderLines.
PurchaseOrderLine[].CustomFields.<Dimension1>
PurchaseOrderLines[].
CustomFields.<Dimension1>
PODOCUMENTENTRIES.
podocumententry[].GLDIM<Dimension2>
* The Intacctstatus is mapped to a Tipalti status according to the status map
^ Extracted from the ITEMID by taking the value before '--'
ǂ Extracted from the CLASSID by taking the value before '--'
+ Same for all the podocumententry lines
Dimension1: The name of the dimension as saved in Tipalti, e.g., Better.
Dimension2: The name of the dimension as saved in the ERP in an uppercase format, e.g., BETTERPROMOTION.

Mapped purchase order statuses

Tipalti

Intacct

PendingApproval
  • Submitted
  • Partially approved
  • Draft
Closed
  • Closed
  • Converted (in 2-way matching)
Active
  • Pending
  • In progress
  • Converted (in 3-way matching)
  • Partially converted (in 3-way matching)
DeletedDeclined
PartiallyBilledPartially converted (in 2-way matching)
PO receivers sync

All PO receivers (GRNs) in Intacct that were added, updated or deleted since the last sync are collected and synced to Tipalti.

Mapped fields

Tipalti

common

Intacct

ReceiptNumberReceiptNumberDOCID
StatusStatus*STATE
MemoNotesMESSAGE
ReceiptDateReceiptDateWHENCREATED
SupplierVendorIDCUSTVENDID
ShipmentDateShipmentDateWHENCREATED
PurchaseOrderNumberPurchaseOrderNumberCREATEDFROM
GrnLines.GoodsReceived
NotificationLine[].InvoiceNumber
ItemReceiptLines[].
InvoiceNumber
PODOCUMENTENTRIES.
podocumententry[].SOURCE_DOCID
GrnLines.GoodsReceived
NotificationLine[].ItemCode
ItemReceiptLines[].
ItemCode
PODOCUMENTENTRIES.
podocumententry[].ITEMID
GrnLines.GoodsReceived
NotificationLine[].ItemDescription
ItemReceiptLines[].
ItemDescription
PODOCUMENTENTRIES.
podocumententry[].MEMO
GrnLines.GoodsReceived
NotificationLine[].ItemUnits
ItemReceiptLines[].
ItemUnits
PODOCUMENTENTRIES.
podocumententry[].UNIT
GrnLines.GoodsReceived
NotificationLine[].LineNotes
ItemReceiptLines[].
LineNotes
PODOCUMENTENTRIES.
podocumententry[].MEMO
GrnLines.GoodsReceived
NotificationLine[].Quantity
ItemReceiptLines[].
QuantityShipped
PODOCUMENTENTRIES.
podocumententry[].UIQTY
GrnLines.GoodsReceived
NotificationLine[].PoLineId
ItemReceiptLines[].
ExternalID
PODOCUMENTENTRIES.
podocumententry[].LINE_NO
PayerEntityPayerEntity^PODOCUMENTENTRIES.
podocumententry[].LOCATIONID
* The Intacctstatus is mapped to a Tipalti status according to the status map
^ Same for all the podocumententry lines

Mapped PO receiver statuses

Tipalti

Intacct

Active
  • Draft
  • Pending
  • In progress
  • Partially converted
Closed
  • Closed
  • Converted
DeletedDeclined
Vendor invoice sync  

All Vendor invoices (matched bills) that were added, updated or deleted since the last sync are collected and synced to Intacct.

Mapped fields

Tipalti

common

Intacct

InvoiceDate*InvoiceDatedatecreated.day
InvoiceDateInvoiceDatedatecreated.month
InvoiceDateInvoiceDatedatecreated.year
InvoiceDueDate*InvoiceDueDatedatedue.day
InvoiceDueDateInvoiceDueDatedatedue.month
InvoiceDueDateInvoiceDueDatedatedue.year
N/AN/Apotransitems.potransitem[].
billable = 'false'
InvoiceLines.InvoiceLine[].
RelatedPurchaseOrders.
TipaltiRelatedPurchaseOrder[].
ItemNumber
invoiceLine.PurchaseOrders[].
Item
potransitems.potransitem[].
itemid
N/AN/Apotransitems.potransitem[].
line_num = index of line
PayerEntityNamePayerEntitypotransitems.potransitem[].
locationid

InvoiceLines.InvoiceLine[].
RelatedPurchaseOrders.
TipaltiRelatedPurchaseOrder[].
Amount/

InvoiceLines.InvoiceLine[].
RelatedPurchaseOrders.
TipaltiRelatedPurchaseOrder[].
Quantity

InvoiceLine.PurchaseOrders[].
NetAmount/ invoiceLine.
PurchaseOrders[].NetAmount.Quantity
potransitems.potransitem[].
price
InvoiceLines.InvoiceLine[].
RelatedPurchaseOrders.
TipaltiRelatedPurchaseOrder[].
Quantity
invoiceLine.PurchaseOrders[].
Quantity
potransitems.potransitem[].
quantity
N/AN/Apotransitems.potransitem[].
taxable = false
N/AN/Apotransitems.potransitem[].
unit
IdapVendorID^potransitems.potransitem[].
vendorid
N/AN/AState (Pending/Draft -
according to approval status)
InvoiceNumberInvoiceNumbervendordocno
InvoiceRefCodeIddocumentnoǂ
N/AN/Atransactiontypeǂ =
'Vendor Invoice'
IdapVendorIDvendoridǂ
InvoiceLines.InvoiceLine[].
RelatedPurchaseOrders.
TipaltiRelatedPurchaseOrder[].
PurchaseOrderNumber
PurchaseOrderNumbercreatedfromǂ
* Day/ month/ year are extracted from a single string
^ Same VendorId for all items
ǂ Only relevant for non-update scenarios
  • ZD.4.log-1212665864.zip
    20 KB Download
Was this article helpful?

We’d love the opportunity to improve. Submit your feedback.

We’re glad you enjoyed the article!

Have more questions? Submit a request
Return to top
Privacy Policy | Terms of Use | Payer/Sender Rights | Customer Assistance Policy
LinkedIn Instagram Facebook Twitter YouTube
Contact support